Finance Committee

FINANCE COMMITTEE AGENDA *This meeting will be conducted in person and via Google Meets* DATE:July 28, 2020 TIME: 3:30 p.m. LOCATION: City Hall Conference Room 1) CALL TO ORDER 2) ATTENDANCE 3) APPROVAL OF ELECTRONIC MEETING In order to comply with the technical aspects of the Governor’s Executive Order regarding holding open meetings in a forum other than in the open and in public, the Finance Committee determines that meeting electronically is necessary to protect the health, safety, and welfare of its citizens due to the COVID-19 outbreak. 4) ADOPTION OF MINUTES: June 23 5) DEPARTMENT REPORTS 1. PURCHASING ​Camille Thomas a) Report of bids  b) Report of award of professional service contracts ● Street Dept. - NPDES Monitoring from Barge Design Solutions, Inc. in the amount of $16,700.00. ● H&CD - Appraisal of the New Providence Hotel from Mark Young Real Estate Appraisals in the amount of $2,000.00. c) Report of sale of surplus property on ​GovDeals.com ​June 2020: $19,225.90 2. GENERAL FUND a) Monthly report ​Laurie Matta 3. DEPARTMENT OF ELECTRICITY a) Monthly reports ​David Johns, Christy Batts 4. CITY ATTORNEY a) Report of legal expenditures ​Lance Baker ● Bradley Arant, ​Jeff Robinson v. City​ - $29,768.81 ● Bradley Arant, ​Jeff Robinson v. City​ - $46,078.45 ● Bradley Arant, ​Kimberly Black v. City ​- $577.50 ● Cunningham Mitchell & Rocconi,​ Robinson v. City​ - $400.00 ● Batson Nolan, ​Robinson v. City​ - $2,500.00 ● Rassas North, ​Robinson v. City​ - $855.00 ● Marks Shell & Maness,​ Robinson v. City​ - $4,350.00 ● Burr Forman, ​TN River Keepers. v. City​ - $8,462.79 6) COMMITTEE ACTION None. 7) CITY COUNCIL ACTION 1. FINANCE (a) ORDINANCE 7-2020-21 ​(First Reading) Repealing ORDINANCE 152-2006-07 establishing the Capital Projects Revenue District and the Capital Improvement Fund ​Laurie Matta  2. LEGAL a) RESOLUTION 16-2020-21 Approving the waiver of the City’s subrogation claim related to the OJI death of Jeffery Prosecky ​Lance Baker 3. PLANNING COMMISSION (a) RESOLUTION 12-2020-21 ​Repealing Resolution 60-1992-93 (Residential Development Commission) and approving the formation of the Land Regulation Advisory Committee ​Jeff Tyndall 8) PUBLIC COMMENTS ​ (3 individuals allowed; 5 minutes each) In accordance with the Alternative Public Comments Procedure, requests must be made no less than 48 hours prior to the meeting; no requests were submitted. 9) ADJOURNMENT  FINANCE COMMITTEE JUNE 23, 2020 MINUTES NON-PUBLIC MEETING City Attorney Lance Baker met in a non-public meeting with the City of Clarksville Finance Committee on Tuesday, June 23, 2020, at 3:00 p.m. in the hallway outside City Council Chambers, 106 Public Square, Clarksville, Tennessee, regarding the proposed ordinance relative to short term rentals. Members present included Councilman Jeff Burkhart, Councilwoman Valerie Guzman, Councilman Jeff Henley, and Councillady Stacey Streetman. CALL TO ORDER The public meeting of the Finance Committee was called to order by Chairman Jeff Burkhart at 3:06 in City Council Chambers. In an effort to facilitate the continued response to the Coronavirus Disease (COVID-19), this meeting was conducted in person and via Google Meets. ATTENDANCE IN PERSON: Jeff Burkhart, Valerie Guzman, Jeff Henley, Stacey Streetman VIA GOOGLE MEETS: Tim Chandler APPROVAL OF ELECTRONIC MEETING In order to comply with the technical aspects of the Governor’s Executive Order regarding holding open meetings in a forum other than in the open and in public, the Finance Committee determines that meeting electronically is necessary to protect the health, safety, and welfare of its citizens due to the COVID-19 outbreak. Councillady Guzman made a motion to authorize the electronic meeting. The motion was seconded by Councillady Streetman. The following vote was recorded:  AYE: Burkhart, Chandler, Guzman, Henley, Streetman The motion to authorize the electronic meeting unanimously passed. ADOPTION OF MINUTES Councilman Henley made a motion to adopt the minutes of May 26 as presented. The motion was seconded by Councilman Chandler. The following vote was recorded: AYE: Burkhart, Chandler, Guzman, Henley, Streetman The motion to adopt the May 26 minutes unanimously passed. PURCHASING DEPARTMENT Director of Purchasing Camille Thomas reviewed the monthly bid summary and reported award of the following professional service contracts: ● CDE - Renovation Design of the Office on Madison Street from Lyle-Cook-Martin Architects in the amount of $710,751.00. Ms. Thomas confirmed later during the meeting that the reported contract amount was for the total project and that architectural fees were $53,000. ● CDE - Survey & Design for a New Parking Area at the Wilma Rudolph Blvd. Office from TTL Company (formerly DBS & Associates) in the amount of $4,000.00. ● Street Dept. - Security Upgrade Design for the Lobby from Powell Architecture in an amount not to exceed $4,000.00. ● Street Dept. - Design for the Replacement of the Dunbar Cave Road Bridge from Winford A. Petrone Co., PLLC in the amount of 15% of the construction cost. ● Gas & Water - New North Service Center Renovation Design from Lyle-Cook-Martin in the amount of $40,000.00. ● Project Management - Asbestos Monitoring of the Frosty Morn Building from Gobbell Hays Partners, Inc. in the amount of $21,070.00. Ms. Thomas reported sales of surplus property on ​GovDeals.com ​in the amount of $​33,326.00 during ​May 2020. GENERAL FUND REPORT Chief Financial Officer Laurie Matta said year-to-date revenues were exceeding expenditures by $3 million with $33 million collected for property taxes. She noted the $2.8 million transfer to the Central Business Improvement District. Department spending was $4.4 million, or 5.3%, more than the previous year, but was $2.1 million, or 6.1%  under budget. Local Option Sales Taxes provided $4.9 million for schools, $76,600 for the Road Improvement Fund, and $1,561,000 for the General Fund. Capital project spending totaled $5.5 million of $33.1 million invested. Ms. Matta said the current Fund Balance was $30.3 million or 30% of expenditures. Grants awarded included funding for emergency supplies relative to the COVID-19 Pandemic and nine new police officers. Ms. Matta briefly reviewed Reports on Debt Obligation for $4,430,000 and $42,619,000 DEPARTMENT OF ELECTRICITY Christy Batts reported Broadband Cash was above $6 million with year-to-date retained earnings of $4 million and noted payment of a one-time fee of $176,000 for a new internet supplier. She said the division gained 218 net customers for video, internet, and phone during the month of May. Mrs. Batts said the interdivisional loan to the Electric Division was on schedule to be paid off in 2021 which would be 17 years earlier than planned. CITY ATTORNEY City Attorney Lance Baker reported payment of the following legal expenditure: ● Bradley Arant Boult Cummings: Kimberly Black v. City $983.82 CROSSING GUARD PAY PLAN Deputy Chief David Crockarell said the proposed plan would pay crossing guards for a full three hours at the full rate. Guards were currently working an additional second or third zone at half rate. He said the plan would also help recruit and retain employees. Councilman Henley made a motion to approve the new plan. The motion was seconded by Councillady Streetman. A voice vote was taken; the motion passed without objection. COMMUNITY DEVELOPMENT RESOLUTION 4-2020-21 ​Authorizing the Grant Application and Adopting the 2020-2024 Consolidated Plan and the 2020-2021 Annual Action Plan and the 2020-2021 Budget for Community Development Block Grant and HOME Programs Interim Director Tammy Kilgore said this resolution would authorize the department's five-year consolidated plan including CDBG and HOME funds. She noted the community would be involved in the needs assessment, marketing analysis, and strategic plan. Councillady Streetman made a motion to forward this resolution to the City Council with a recommendation of approval. The motion was seconded by Councillady Guzman. The following vote was recorded: AYE: Chandler, Guzman, Henley, Streetman The motion to forward this resolution to the City Council with a recommendation of approval passed. HUMAN RESOURCES RESOLUTION 5-2020-21 Adopting Personnel Policy #20-1 pertaining to Confined Spaces in the Workplace Safety Manager Wes Golden said this policy was mandated by the Occupational Safety and Health Administration and would make the policy consistent for all departments. Councillady Guzman made a motion to forward this resolution to the City Council with a recommendation of approval. The motion was seconded by Councillady Streetman. The following vote was recorded: AYE: Chandler, Guzman, Henley, Streetman The motion to forward this resolution to the City Council with a recommendation of approval passed. RESOLUTION 6-2020-21 Adopting Personnel Policy #20-2 pertaining to Control of Hazardous Energy Sources in the Workplace Mr. Golden said this policy was also required by OSHA and required specific procedures for training and documentation. Councilman Henley made a motion to forward this resolution to the City Council with a recommendation of approval. The motion was seconded by Councillady Guzman. The following vote was recorded: AYE: Chandler, Guzman, Henley, Streetman The motion to forward this resolution to the City Council with a recommendation of approval passed. POLICE RESOLUTION 1-2020-21 Authorizing an interlocal agreement with the E911 Emergency Communications District Chief Crockarell said this resolution would renew the annual agreement regarding E911 services. Councilman Henley made a motion to forward this resolution to the City Council with a recommendation of approval. The motion was seconded by Councillady Guzman. The following vote was recorded: AYE: Chandler, Guzman, Henley, Streetman The motion to forward this resolution to the City Council with a recommendation of approval passed.  RESOLUTION 2-2020-21 Authorizing an interlocal agreement with Montgomery County regarding shared expenses for autopsies Chief Crockarell said this agreement would provide for a 50/50 split for autopsy expenses and the agreement would be in effect until either party chose to withdraw. Councilman Henley made a motion to forward this resolution to the City Council with a recommendation of approval. The motion was seconded by Councillady Streetman. The following vote was recorded: AYE: Chandler, Guzman, Henley, Streetman The motion to forward this resolution to the City Council with a recommendation of approval passed. SHORT TERM RENTALS ORDINANCE 1-2020-21 (First Reading) Amending the Official Code to establish regulations pertaining to short term rentals Councillady Streetman summarized the contents of the ordinance and said the regulations would benefit tenants and adjoining property owners. Assistant City Attorney Neil Stauffer said a provision was included that would grandfather existing short term rentals upon confirmation that owners had paid business taxes for at least six months prior to the effective date of the ordinance and noted issuance of a permit was not dependent on a particular zone classification. Following discussion, Councilman Henley made a motion to forward this ordinance to the City Council with a recommendation of approval. The motion was seconded by Councillady Streetman. The following vote was recorded: AYE: Chandler, Guzman, Henley, Streetman The motion to forward this ordinance to the City Council with a recommendation of approval passed. SUFFRAGIST MONUMENT RESOLUTION 3-2020-21 Authorizing a Memorandum of Understanding with the Clarksville-Montgomery County Arts & Heritage Development Council pertaining to Clarksville’s Original Suffragist Monument on Public Square Director of Parks & Recreation Jennifer Letourneau noted placing of this monument would commemorate 100 years of women’s right to vote. She said funds were being raised by the Arts & Heritage Development Council. Councilman Henley made a motion to forward this ordinance to the City Council with a recommendation of approval. The motion was seconded by Councillady Streetman. The following vote was recorded: AYE: Chandler, Guzman, Henley, Streetman  The motion to forward this resolution to the City Council with a recommendation of approval passed. PUBLIC COMMENTS No requests were submitted in accordance with the Alternative Public Comments Procedure (RESOLUTION 55-2019-20). ADJOURNMENT The meeting was adjourned at 4:22 p.m. Department of Finance & Revenue June 2020 Financial Review Fiscal Year 2020 Clarksville, Tennessee June 30, 2020  General Fund Revenues vs. Expenditures Fiscal Year 2020 As of June 30, 2020 FY 2020 FY 2020 Monthly Revenues Expenditures Variance July $ 5,454,774 $ 8,407,620 $ (2,952,846) August 5,286,834 6,844,729 (1,557,895) September 4,836,616 8,912,821 (4,076,205) October 5,059,278 8,818,714 (3,759,436) November 7,710,416 6,798,578 911,838 December 18,909,185 6,760,944 12,148,240 January 7,951,271 9,314,931 (1,363,660) February 17,481,296 7,016,970 10,464,327 March 6,418,611 8,006,544 (1,587,933) April 5,404,641 7,365,063 (1,960,421) May 5,779,064 8,884,873 (3,105,809) June 5,228,167 10,968,274 (5,740,107) YTD Total $ 95,520,152 $ 98,100,061 $ (2,579,908) $20,000,000 $18,000,000 $16,000,000 $14,000,000 $12,000,000 $10,000,000 $8,000,000 FY 2020 Revenues $6,000,000 $4,000,000 FY 2020 Expenditures $2,000,000 $-  General Fund Revenue Comparison Fiscal Year 2020 As of June 30, 2020 FY 2020 FY 2019 Variance Revenue Revenue July $ 5,454,774 $ 4,091,658 $ 1,363,116 August 5,286,834 $ 6,447,488 (1,160,655) September 4,836,616 $ 4,448,778 387,838 October 5,059,278 $ 4,797,738 261,540 November 7,710,416 $ 7,399,053 311,362 December 18,909,185 $ 10,970,345 7,938,839 January 7,951,271 $ 17,899,039 (9,947,768) February 17,481,296 $ 15,975,125 1,506,171 March 6,418,611 $ 6,350,095 68,516 April 5,404,641 $ 5,275,436 129,205 May 5,779,064 $ 7,043,562 (1,264,498) June 5,228,167 $ 3,989,360 1,238,807 YTD Total $ 95,520,152 $ 94,687,678 $ 832,475 $103,000,000 $93,000,000 $83,000,000 $73,000,000 $63,000,000 $53,000,000 FY2019 YTD Revenue $43,000,000 FY2020 YTD Revenue $33,000,000 $23,000,000 FY2020 YTD Budgeted Revenue $13,000,000 $3,000,000  General Fund Revenue Details Fiscal Year 2020 As of June 30 2020 Total Budget YTD Month TAXES Prior Year Property Taxes 894,711 1,083,319 56,571 2019 Property Taxes 30,162,934 29,418,572 269,934 PiLOTS 90,175 90,175 - Local Option Sales Tax 18,091,510 18,812,530 1,513,408 Beer & Liquor Tax 4,047,113 4,408,925 439,645 Business License 2,623,286 2,488,544 685,295 Franchise Tax (cable) 1,500,931 932,059 - Hote/Motel 424,243 404,185 13,244 Other Taxes 367,426 348,320 53,065 TOTAL TAXES 58,202,329 57,986,629 3,031,163 LICENSES AND PERMITS Building Permits 2,081,533 2,506,964 223,198 Other Permits 104,719 119,983 26,919 TOTAL PERMITS 2,186,252 2,626,947 250,117 INTERGOVERNMENTAL Grant reimbursements 57,824 31,683 4,667 State Shared Revenues TVA Replacement Tax 1,595,148 1,634,997 408,749 State Sales Tax 11,963,610 12,045,387 876,305 State Street Aid 5,782,794 5,011,414 290,123 Other Taxes 2,034,999 2,033,245 26,551 TOTAL INTERGOVERNMENTAL 21,434,375 20,756,726 1,606,395 OTHER REVENUES Charges for Services 690,078 649,917 52,794 Recreation 447,498 331,341 18,067 Golf Courses 393,802 458,926 90,870 Fines and Forefeitures 476,113 465,665 37,885 Investment & Interest Earnings 335,214 317,058 5,787 Other Misc. Revenues 916,134 961,390 20,803 Transfer from CDE 4,677,035 4,677,038 392,432 Transfer From CGW 3,749,887 3,135,655 -284,707 Other Transfers 449,502 282,861 6,560 TOTAL OTHER REVENUES 12,135,263 11,279,850 340,491 TOTAL REVENUES GENERAL FUND 93,958,219 92,650,153 5,228,167  General Fund Expenditure Comparison Fiscal Year 2020 As of June 30, 2020 FY 2020 FY 2019 Variance Expenditures Expenditures July $ 8,407,620 $ 8,104,262 $ 303,358 August 6,844,729 $ 6,305,053 539,676 September 8,912,821 $ 7,022,647 1,890,175 October 8,818,714 $ 7,220,036 1,598,678 November 6,798,578 $ 6,961,101 (162,523) December 6,760,944 $ 6,546,791 214,154 January 9,314,931 $ 7,912,332 1,402,599 February 7,016,970 $ 6,497,012 519,958 March 8,006,544 $ 7,117,979 888,565 April 7,365,063 $ 7,969,755 (604,692) May 8,884,873 $ 10,920,746 (2,035,873) June 10,968,274 $ 9,752,421 1,215,853 YTD Total $ 98,100,061 $ 92,330,134 $ 5,769,926 $122,000,000 $102,000,000 $82,000,000 $62,000,000 FY2019 YTD Expenditures FY2020 YTD Expenditures $42,000,000 FY2020 YTD Budgeted $22,000,000 Expenditures $2,000,000  General Fund Year-to-Date Departmental Budget vs. Actual Expenditures Fiscal Year 2020 As of June 30, 2020 35,000,000.00 Expenditures Estimated Variance 30,000,000.00 Departmental: FY 2020 YTD YTD Budget (Over)Under 25,000,000.00 Police $ 30,135,704 $ 30,483,422 $ 347,718 Fire 18,425,508 18,546,163 120,655 20,000,000.00 Highway & Street 14,068,155 14,091,315 23,160 FY 20 YTD Budget 15,000,000.00 Parks & Rec. & Golf 8,112,356 9,121,351 1,008,995 FY 2020 Actual YTD 10,000,000.00 Building & Codes 1,975,204 2,084,861 109,657 Info. Technology 1,841,127 1,856,268 15,141 5,000,000.00 Finance 1,669,997 1,710,696 40,699 0.00 City Garage 1,220,152 1,246,615 26,463 Municipal Properties 463,905 488,015 24,110 Human Resources 1,061,621 1,114,323 52,702 Legislative / Admin. 636,340 660,400 24,060 Mayor's Office 639,398 649,428 10,030 1,400,000.00 City Court 431,851 439,961 8,110 Legal 465,928 495,021 29,093 1,200,000.00 Internal Audit 328,636 387,571 58,935 1,000,000.00 FY 20 YTD Budget Purchasing 179,598 199,666 20,068 800,000.00 FY 2020 Actual YTD Departmental Total 81,655,480 83,575,076 1,919,596 600,000.00 400,000.00 Nondepartmental: 200,000.00 Debt 9,307,597 10,062,173 754,576 0.00 Transit 1,994,548 2,110,414 115,866 Retirees 1,532,806 1,571,085 38,279 Other 3,609,629 3,751,448 141,819 YTD Total $ 98,100,060 $ 101,070,196 $ 2,970,136  Schedule of Sales Tax Collections Fiscal Year 2020 As of June 30, 2020 City of Clarksville Local Sales & Use Tax Net Collections Net Collections Net Collections Net Collections FY 2017 FY 2018 FY 2019 FY 2020 July $ 1,291,892 $ 1,425,145 $ 1,524,372 $ 1,607,009 August 1,394,223 1,453,282 1,552,311 1,584,610 September 1,312,394 1,376,154 1,461,197 1,553,548 October 1,305,179 1,330,621 1,576,737 1,541,129 November 1,362,262 1,443,473 1,509,818 1,547,242 December 1,275,621 1,357,713 1,602,804 1,559,998 January 1,356,898 1,454,962 1,559,092 1,649,239 February 1,807,932 1,823,774 2,079,756 2,544,675 March 1,196,658 1,234,732 1,333,119 1,429,615 April 1,164,740 1,319,995 1,383,586 1,492,772 May 1,448,181 1,556,171 1,639,262 1,637,949 June 1,397,041 1,486,610 1,546,062 1,587,653 YTD Total $ 16,313,021 $ 17,262,632 $ 18,768,116 $ 19,735,437 City of Clarksville $25,500,000 $20,500,000 $15,500,000 $10,500,000 $5,500,000 $500,000 FY 2017 FY 2018 FY 2019 FY 2020  Local Sales Tax Collections Fiscal Year 2020 As of June 30, 2020 TOTAL NET COLLECTIONS PAID TO GROSS COLLECTIONS UNICORPORATED NET COLLECTIONS COUNTY CITY CITY ROADS SCHOOLS AREA CITY LIMITS PAID TO STATE July $ 6,902,369 $ 113,097 $ 1,531,859 $ 75,150 $ 5,182,264 $ 900,496 $ 6,080,408 $ 78,535 August 6,720,676 106,434 1,510,507 74,103 5,029,633 801,486 5,995,658 76,468 September 6,460,371 96,698 1,480,898 72,650 4,810,125 655,748 5,878,129 73,506 October 6,395,968 95,166 1,469,060 72,069 4,759,673 637,600 5,831,141 72,773 November 6,395,605 94,012 1,474,887 72,355 4,754,350 614,102 5,854,271 72,769 December 6,384,366 90,981 1,487,046 72,952 4,733,387 554,474 5,902,534 72,641 January 6,800,429 99,211 1,572,114 77,125 5,051,979 637,609 6,240,195 77,375 February 10,549,656 156,468 2,425,676 118,999 7,848,513 1,041,451 9,628,239 120,034 March 5,800,974 80,414 1,362,760 66,854 4,290,945 457,771 5,409,207 66,004 April 6,028,266 82,243 1,422,964 69,808 4,453,252 448,683 5,648,172 68,590 May 6,690,623 94,768 1,561,352 76,597 4,957,907 569,274 6,197,475 76,126 June 6,493,692 92,365 1,513,408 74,245 4,813,674 560,405 6,007,173 73,885 YTD TOTAL $ 81,622,995 $ 1,201,857 $ 18,812,530 $ 922,907 $ 60,685,701 $ 7,879,098 $ 74,672,603 $ 928,707 Monthly Distribution  Capital Project Status Report Fiscal Year 2020 As of June 30, 2020 TOTAL ACTIVE ACTIVE PROJECTS FY EXPENSES TOTAL FUNDING PROJECT PROJECT BALANCE FY2019-2020 7/1/19-5/31/20 EXPENSES ** STREET DEPARTMENT: 93101 Rossview/Dunbar Cave/Cardinal Improvements 13,280,000 247,099 2,765,635 10,514,365 14301 Edmondson Ferry/1A Bypass Interesection Improvement 1,150,004 9,640 1,150,002 2 15306 Northeast Connector 16,808,700 389,737 1,265,777 15,542,923 17301 International & Dunlop Intersection Improvement 2,807,831 322,754 445,506 2,362,325 17304 Adaptaive Signal Control Project (Wilma) 1,200,000 0 0 1,200,000 17305 Tylertown & Oakland Intersection Improvement 10,000,000 338,891 912,099 9,087,901 17307 Tylertown & Trenton Drainage Overflow Project 1,040,185 5,494 73,747 966,438 18301 Drainage Mitigation FY2018 400,000 0 106,642 293,358 18302 New Sidewalks FY2018 934,954 77,785 149,325 785,630 19301 Lilac Lane 100,000 1,000 2,600 97,400 19302 Whitfield Road Improvements 3,350,000 1,100,801 1,309,130 2,040,870 19303 Spot Intersection Improvements 1,500,000 87,936 94,136 1,405,864 20301 Dunbar Cave Road Bridge 600,000 500 500 599,500 20302 4th Street and College Signal 400,000 37,992 37,992 362,008 20303 New Sidewalks FY20-24 900,000 843,791 843,791 56,209 20304 Drainage Mitigation FY20-24 450,000 0 0 450,000 20305 Cemetary Retaining Wall 510,000 1,500 1,500 508,500 $ 55,431,674 $ 3,464,920 $ 9,158,382 $ 46,273,292 PARKS & RECREATION: 16503 Athlectic Complex 5,297,478 278,984 4,750,745 546,733 16504 Red River East Trail Project 2,403,712 902,583 2,154,386 249,326 17501 Valleybrook Park & Upland Trail Connection 160,000 0 0 160,000 17502 Public Spaces 150,000 1,250 150,000 0 17503 Edith Pettus Park Renovations 201,800 15,000 23,615 178,185 17504 Crow Community Center Renovation 370,000 0 119,866 250,134 17505 Liberty Park/Marina Remediation 905,218 42,258 102,782 802,436 17506 Swan Lake Renovations 1,046,605 223 1,039,218 7,387 19502 Pollard Road Additional Parking 319,199 219,701 227,701 91,498 19503 Billy Dunlop Pavillion & Restroom 382,485 378,591 380,591 1,894 19504 Heritage Park Improvements 1,000,000 290,753 508,621 491,379 19505 Regional Community Center 500,000 0 0 500,000 20501 Red River Pedestrian Bridge 3,068,233 11,681 11,681 3,056,552 20502 Mason Rudolph Cart Path Paving 125,000 0 0 125,000 20503 Swan Lake Cart Path Paving 190,800 187,700 187,700 3,100 20504 Burt Cobb Recreation Center Roof 230,000 191,488 191,488 38,512 $ 16,350,530 $ 2,520,213 $ 9,848,394 $ 6,502,136 FIRE DEPARTMENT: 16221 Fire Maintenance Facility 901,377 46,952 48,252 853,125 20221 Renovation of Station 10 125,000 0 0 125,000 20222 Custom Engine (replaces 1999 model) 590,000 0 0 590,000 $ 1,616,377 $ 46,952 $ 48,252 $ 1,568,125 POLICE DEPARTMENT: 19211 District 3 Precinct Building 3,500,000 192,252 192,252 3,307,748 $ 3,500,000 $ 192,252 $ 192,252 $ 3,307,748 GENERAL GOVERNMENT: 41016 Corporate Business Park Expansion $ 14,368,821 $ - $ 14,092,700 $ 276,121 13101 Clarksville Performing Arts & Conf Center 1,613,963 3,000 179,907 1,434,056 15102 TDOT 2013 Multimodal Access 206,017 40,950 169,830 36,187 16103 2015 Multimodal Access Grant 241,189 100,939 222,043 19,146 19101 New Council Chambers 0 0 0 0 19102 Structural Repairs - Cumberland Garage 1,099,036 0 0 1,099,036 20101 Frosty Morn 1,200,000 4,500 4,500 1,195,500 $ 18,729,026 $ 149,389 $ 14,668,980 $ 4,060,046 debt issuance costs Total Spent YTD: Major Projects $ 95,627,607 $ 6,373,726 $ 33,916,260 $ 61,711,347 * Fiscal Year to date invoices paid (July 1st to current month end) ** Total Active Expenses includes all expenses paid during the life of a project, not just the current fiscal year.  Fund Balances Fiscal Year 2020 As of June 30, 2020 Beginning Fund Estimated Ending Revenues Expenditures Fund Balance Fund Balance YTD YTD 7/01/19 06/30/20 General Fund: $ 29,943,642 $ 92,650,153 $ 98,100,060 $ 24,493,734 Capital Projects Fund: 2,556,107 3,592,866 6,373,726 (224,752) Debt Service Fund: 474,377 11,582,315 11,562,820 493,872 Internal Service Funds: 6,300,385 17,570,099 16,876,053 6,994,431 Non-Major Governmental Funds: Drug Fund 502,153 399,597 143,182 758,568 Road Improvement Fund 1,094,794 922,907 750,000 1,267,701 Police Special Fund 191,193 608,378 654,686 144,885 Parks Special Fund 362,757 308,019 410,309 260,467 Other Special Revenue Fund* 840,479 685,347 889,563 636,263 Community Development 460,231 1,714,019 1,780,336 393,914 Capital Projects Revenue District Fund 78,179 2,870,000 2,480,623 467,555 * Includes: Fire Spec. Rev., Traffic Camera Police & Parks, SRF  Notice of Grant Applications Fiscal Year 2020 As of June 30, 2020 Date Funding Funds Match Submitted Project Title Agency Requested Required Status Notes Transportation TN Dept of $1,994,338 $498,584 Funding for a pedestrian bridge over the Red River to complete the 10/03/18 Awarded Alternative Program Transportion $1,818,233 $674,689 connection between the Red River Trail and the Greenway Assistance to Dept of Homeland To purchase 82 sets of ballistic protective equipment for firefighters in the 10/26/18 $127,846 $12,784 Not funded Firefighters Grant Security (FEMA) event of an active shooter/mass casualty situation. 2018 Fire Prevention Dept of Homeland To purchase a new fire safety trailer used for public education programs and 12/06/18 $56,840 $2,841 Not funded & Safety Grant Security (FEMA) to pay for 2 fire staff to become certified as Fire and Safety Educators. Sam's Club (LG Requested their community grant program funding to support our 2019 02/15/19 Riverfest $2,000 $0 Awarded Highway) Riverfest event. TN Highway Safety For continued fuding for alcohol and impaired driver countermeasures. This 03/15/19 Office 2020 Alcohol THSO $90,000 $0 Awarded grant pays for overtime for police officers to conduct DUI checkpoints and Impairment saturation patrols for a one year period. Heritage Park Dog Boyd Foundations Requested funding to purchase new agility and play equipment as well as 05/30/19 $12,045 $0 Not funded Park Enhancement Dog Park Dash amenities for Heritgage dog park 2019 TAEP Tree TN Dept of 06/07/19 Planting at Billy $2,743 $2,743 Awarded To purchase 25 new trees to be planted at Billy Dunlop Park. Agriculture Dunlop Park Annually shared with Montgomery County Sheriff's Office. CPD will use our share to purchase a 3D laser scanner to analyze crime scenes. The 08/23/19 2019 JAG Grant US Dept of Justice $59,459 $0 Awarded Sheriff will use their share for wireless communication services for dupites in the field. US Conf of To strt a new Athletic Leqgue Scholarship Program. Awards will be 2020 Childhood Mayoers/American $125,000 and $25,000 for 1st and 2nd places, respectively. Low income 08/30/19 $120,000 $0 Not funded Obesity Prevention Beverage youth can compete for scholarships to any of the City's athletic leagues by Foundation submitting an application and essay. Transportation TN Dept of Funding to construct new sidewalks to benefit Clarksville High School, 10/03/19 $493,176 $123,294 Not funded Alternative Program Transportion Richview Middle School and Pisgah Elementary School.  Date Funding Funds Match Submitted Project Title Agency Requested Required Status Notes TAEP Farmers TN Dept of 11/25/19 $750 $0 Awarded Funding to advertise and promote the downtown market. Market Promotion Agriculture 03/06/20 Movies in the Park Walmart #673 $1,000 $0 Submitted Funding to support the 2020 Mayor's Summer Night Lights Program 03/06/20 Movies in the Park Walmart #1075 $1,000 $0 Submitted Funding to support the 2020 Mayor's Summer Night Lights Program 03/06/20 Riverfest Sam's Club #6512 $2,000 $0 Not funded Funding to support the 2020 Riverfest event $1,000 03/06/20 Movies in the Park Walmart #4589 $0 Awarded Funding to support the 2020 Mayor's Summer Night Lights Program $500 03/06/20 Movies in the Park Walmart #3495 $1,000 $0 Not funded Funding to support the 2020 Mayor's Summer Night Lights Program Funding to support the CFD Family Assistance Program to help assist Fire Rescue Smoke $1,500 03/06/20 Walmart #4469 $0 Awarded families affected by fire by providing them with toiletries, etc. and purcase Alarm Program $1,000 smoke alarms to be installed free of charge. 2020 COPS Hiring Federal funding to hire 9 new police officers. If awarded, funding will pay a 03/10/20 US DOJ $1,125,000 $587,015 Awarded Program percentage of the officers salaries and benefits over a three year period. 2019 Assistance to US Dept of Federal funding to purchase mobile air units, thermal imaging cameras and 03/19/20 $146,489 $14,649 Submitted Firefighters Grant Homeland Security training for CFD. Funding to cover saff expenses and to purchase equipment for the purpose 2021 Teen Driver TN Highway Safety 03/24/20 $14,067 $0 Submitted of conducting safety days and educational trainings for oung drivers as well Safety Education Office (THSO) as enforcement of seat belt usage by young drivers in school zones.  Date Funding Funds Match Submitted Project Title Agency Requested Required Status Notes 2021 Alcohol & Funding for alcohol and impaired driver countermeasures. Pays for overtime TN Highway Safety 03/25/20 Impared Driving $133,505 $0 Submitted for officers to conduct DUI checkpoints and saturation patrols for a one year Office (THSO) Enforcement period. Including purchase of equipment for DUI checkpoints. 2021 Child Funding for child safety seats and booster seats to provide to low income TN Highway Safety 03/25/20 Passenger Safety and $10,564 $0 Submitted families and staff time for events/enforcement of proper use of child Office (THSO) Occupant Protection passenger restraints. 2021 TN Highway Safety Funding for training of officers for bicycle/pedestrian crash investigations, 03/27/20 Bicycle/Pedestrian $13,544 $0 Submitted Office (THSO) staff time for enforcement and public awareness activities. Safety 2021 Distracted TN Highway Safety Funding to purchase driving simulators for distracted driving educational 03/30/20 $28,850 $0 Submitted Driving Office (THSO) purposes and public events. 2020 Port Security Dept of Homeland 04/23/20 $75,000 $25,000 Submitted Funding to purchase a rescue boat for fire/rescue operations Grant Program Security (FEMA) 2020 Summer Food State of TN Dept of Submitted To serve a maximum of 66,000 meals durin the month of June 2020 at 7 05/01/20 $424,127 $0 Service Program Human Services withdrawn different sites throughout the City. 2020 Assistance to Federal funding to reimburse for PPE expenses incurred related to Firefighters - US Dept of 05/15/20 $56,563 $5,656 Submitted COVID19 as well as expected PPE expenses through May 2021. Funding COVID19 Homeland Security only covers face masks, gloves and gowns used by firefighters on calls. Supplement 2019 Staffing for Requested funding to hire 15 new firefighters. Funding would cover 100% Adquate Fire and US Dept of 05/20/20 $2,713,365 $0 Submitted to entry level salaries and benefits for 3 years. Share has been waived due to Emergency Homeland Security COVID19. Response (SAFER) 2019 Fire Prevention US Dept of Federal funding to purchase a new fire safety trailer and training for two 05/27/20 $60,683 $3,034 Submitted and Safety Homeland Security CFR staff to become certified Fire and Safety Educators 2020 COVID19 Submitted Allocation provided to cover expenses related to COVID19 both past and 05/29/20 Emergency US Dept of Justice $191,575 $0 Awarded future anticipated expenses through January 2022. Supplemental  Date Funding Funds Match Submitted Project Title Agency Requested Required Status Notes TN Agriculture TN Dept of 06/01/20 Enhancement $2,930 $2,930 Submitted Requested funding to plant 26 trees along the riverbank at Trice Landing Agrculture Program Google recommended the City's Fire Department for a grant to provide PPE Tides Foundation 6.16.29 Fire Dept PPE $17,500 $0 Awarded (not specific to COVID19) Fire Department plans to use for new turn out (Google) gear.  Investment Report Fiscal Year 2020 As of June 30, 2020 COUPON ISSUER NAME PAR VALUE CUSIP RATE LOCAL GOVERNMENT INVESTMENT POOL SELF-INSURANCE $ 592,020 0.380 CAPITAL PROJECTS FUNDS 1,806,798 0.380 INVESTMENT ACCOUNT 16,151,032 0.380 2016 BOND ISSUANCE 692,205 0.380 0.380 LGIP TOTAL / AVERAGE $ 19,242,054 0.380 SELF-INSURANCE CAPITAL PROJECTS FUNDS INVESTMENT ACCOUNT 2016 BOND ISSUANCE  CDE Lightband Rolling 4 month Balance Sheet - Broadband Division June 30, 2020 6/30/2019 (R) % Change 6/30/20 5/31/20 4/30/20 3/31/20 Assets Current Assets: Cash -Operating Account $ 3,691,884.79 1.42% $ 3,744,241.79 $ 6,084,029.66 $ 5,850,945.91 $ 5,782,482.51 Accounts Receivable: Subscribers, less allowance 1,502,695.90 3.83% 1,560,202.57 1,678,134.72 1,568,962.72 1,580,967.92 Other 48,481.04 144.27% 118,425.89 48,968.96 35,728.77 39,914.32 Temporary advances - Electric 1,808,320.98 17.45% 2,123,796.85 1,905,734.31 2,046,363.69 1,965,275.56 Inventory 408,335.49 40.09% 572,019.29 579,424.19 642,920.79 639,398.43 Total Current Assets $ 7,459,718.20 8.83% $ 8,118,686.39 $ 10,296,291.84 $ 10,144,921.88 $ 10,008,038.74 Noncurrent Assets: Construction Work In Progress $ 41,740.24 -80.06% $ 8,322.70 $ 70,216.33 $ 6,445.27 $ 5,730.74 Telecommunications Plant 8,165,308.70 12.50% 9,186,179.72 8,802,523.91 8,800,818.87 8,494,721.90 Accumulated Depreciation (5,351,268.09) 5.41% (5,640,605.30) (5,620,718.03) (5,567,829.96) (5,553,501.14) Deferred Debit - Software & Outflows of Resources 428,856.10 -43.83% 240,893.07 277,135.01 322,429.87 369,065.48 Total Noncurrent Assets $ 3,284,636.95 15.53% $ 3,794,790.19 $ 3,529,157.22 $ 3,561,864.05 $ 3,316,016.98 Total Assets $ 10,744,355.15 10.88% $ 11,913,476.58 $ 13,825,449.06 $ 13,706,785.93 $ 13,324,055.72 Retained Earnings and Liabilities: Retained Earnings (Deficit): Retained Earnings - Beginning of Year $ (3,011,499.48) -126.69% $ 803,836.93 $ 803,836.93 $ 803,836.93 $ 803,836.93 Retained Earnings - YTD 3,644,470.14 10.50% 4,027,098.57 3,764,290.10 3,364,931.70 2,953,912.65 Retained Earnings - Current 170,866.27 80.96% 309,196.13 262,808.47 399,358.40 411,019.05 Total Retained Earnings (Deficit) $ 803,836.93 539.45% $ 5,140,131.63 $ 4,830,935.50 $ 4,568,127.03 $ 4,168,768.63 Current Liabilities: Accounts Payable $ 1,995,835.85 22.87% $ 2,452,333.92 $ 1,980,979.05 $ 2,153,886.59 $ 2,113,081.53 Unearned Revenue $ 682,497.65 0.00% $ 682,497.65 $ 682,497.65 $ 682,497.65 $ 682,497.65 Other Accrued Payables 156,271.62 70.43% 266,332.95 235,067.87 206,025.11 262,047.25 Total Current Liabilities $ 2,834,605.12 19.99% $ 3,401,164.52 $ 2,898,544.57 $ 3,042,409.35 $ 3,057,626.43 Noncurrent Liabilities: Customer Deposits $ 2,698.81 -63.41% $ 987.48 $ 1,137.48 $ 1,137.48 $ 1,137.48 Postretirement Benefits 352,669.16 10.79% 390,709.82 344,286.38 344,566.94 345,978.05 Deferred Inflows of Resources 104,614.00 -19.18% 84,552.00 104,614.00 104,614.00 104,614.00 Long Term Debt to the Electric Division 6,645,931.13 -56.43% 2,895,931.13 5,645,931.13 5,645,931.13 5,645,931.13 Total Noncurrent Liabilities $ 7,105,913.10 -52.54% $ 3,372,180.43 $ 6,095,968.99 $ 6,096,249.55 $ 6,097,660.66 Total Liabilities $ 9,940,518.22 -31.86% $ 6,773,344.95 $ 8,994,513.56 $ 9,138,658.90 $ 9,155,287.09 Total Liabilities & Retained Earnings $ 10,744,355.15 10.88% $ 11,913,476.58 $ 13,825,449.06 $ 13,706,785.93 $ 13,324,055.72  CDE Lightband Income Statement - Broadband Division 6/30/2020 % 6/30/2019 (R) Change 6/30/20 5/31/20 4/30/20 3/31/20 Operating Revenue: Programming Revenue $ 338,112.99 28.72% $ 435,204.12 $ 437,268.13 $ 440,207.86 $ 439,473.85 Internet Revenue 1,179,980.91 11.15% 1,311,504.07 1,295,429.63 1,285,568.32 1,272,890.37 Telephone Revenue 145,291.39 8.45% 157,568.53 152,643.68 152,332.52 152,737.80 Miscellaneous Fee Revenue 159,618.58 9.82% 175,290.60 86,815.12 111,555.87 136,281.35 Total Operating Revenues 1,823,003.87 14.07% 2,079,567.32 1,972,156.56 1,989,664.57 2,001,383.37 Cost of Programming & Services 689,283.85 1.97% 702,886.08 699,067.16 742,253.10 733,034.95 Gross Revenue: $ 1,133,720.02 21.43% $ 1,376,681.24 $ 1,273,089.40 $ 1,247,411.47 $ 1,268,348.42 Operating Expenses: Network Support Expense-Video $ 46,304.20 -16.83% $ 38,510.26 $ 33,614.23 $ 33,403.65 $ 39,189.13 Network Support Expense-Internet 131,113.56 13.87% 149,297.98 319,053.34 141,900.78 138,237.22 Network Support Expense-Phone 16,108.32 -3.18% 15,595.60 15,589.46 15,571.04 15,620.16 Network Admin. & Oper. Expense 114,927.28 -1.96% 112,670.66 109,636.89 114,903.97 125,486.85 Building & Office Expense 8,047.00 0.00% 8,047.00 8,047.00 8,047.00 8,047.00 Depreciation & Amortization Expense 78,685.41 20.07% 94,473.99 92,161.05 89,443.49 92,631.49 General & Administrative Expense 217,813.63 71.14% 372,758.06 187,354.89 228,816.81 223,103.37 Station Apparatus Expense 151,594.22 -17.55% 124,989.19 118,461.25 93,845.62 101,722.68 Customer Service Expense 64,617.34 -17.17% 53,524.31 51,952.07 53,807.03 52,379.83 Marketing Expense 90,378.12 -1.29% 89,209.70 65,875.36 59,829.02 53,796.64 Total Operating Expenses $ 919,589.08 15.17% $ 1,059,076.75 $ 1,001,745.54 $ 839,568.41 $ 850,214.37 Operating Income (Loss) $ 214,130.94 48.32% $ 317,604.49 $ 271,343.86 $ 407,843.06 $ 418,134.05 Interest Expense 11,504.12 -53.62% 5,335.27 5,462.30 5,411.57 4,041.91 Other Expenses - Tax Equivalent 31,760.55 -90.32% 3,073.09 3,073.09 3,073.09 3,073.09 Other Expense - Loss on Retirement of Equipment $ - $ - $ - $ - $ - Total Other Expenses (Income) $ 43,264.67 -80.57% $ 8,408.36 $ 8,535.39 $ 8,484.66 $ 7,115.00 Net Income (Loss) $ 170,866.27 80.96% $ 309,196.13 $ 262,808.47 $ 399,358.40 $ 411,019.05 EBITDA $ 292,816.35 $ 412,078.48 $ 363,504.91 $ 497,286.55 $ 510,765.54  CDE Lightband Cash Flow Statement - Broadband Division June 30, 2020 RECONCILIATION OF OPERATING INCOME TO NET CASH PROVIDED BY OPER ACTIVITIES: Operating income (loss) $ 317,604.49 Adjustments to reconcile oper income to cash provided (used) by operating activities Depreciation and amortization 94,473.99 Changes in: Accounts receivable 48,475.22 Advances to Electric (218,062.54) Inventory 7,404.90 Accounts payable 471,354.87 Accrued expenses 77,688.52 Customer deposits (150.00) Other 7,771.58 Net Cash From Operating Activities 806,561.03 CASH FLOWS FROM FINANCING ACTIVITIES: Payment of long term debt (2,750,000.00) Additions to plant (396,348.90) Net Cash Used by Financing Activities (3,146,348.90) NET DECREASE IN CASH AND CASH EQUIVALENTS $ (2,339,787.87) CASH AND CASH EQUIVALENTS - BEG OF MONTH 6,084,029.66 CASH AND CASH EQUIVALENTS - END OF MONTH $ 3,744,241.79  CDE Lightband Rolling 4 Month Balance Sheet - Electric Division June 30, 2020 Prior Year 6/30/2019 (R) % Change 6/30/2020 5/31/2020 4/30/2020 3/31/2020 UTILITY PLANT 1 Electric Plant $ 296,224,657.21 7.56% $ 318,626,028.37 $ 314,177,448.60 $ 312,985,684.70 $ 311,730,311.37 2 Less Depreciation (101,024,118.13) 7.36% (108,459,751.31) (107,939,705.49) (107,433,297.24) (106,480,470.76) 3 Total $195,200,539.08 7.67% $210,166,277.06 $206,237,743.11 $205,552,387.46 $205,249,840.61 4 Unamortized acq. adj. 72,108.72 -50.00% 36,054.36 39,058.89 42,063.42 45,067.95 6 Total Plant - Net $195,272,647.80 7.65% $210,202,331.42 $206,276,802.00 $205,594,450.88 $205,294,908.56 OTHER PROPERTY AND INVESTMENTS 8 Interdivisional loan 6,645,931.13 -56.43% 2,895,931.13 5,645,931.13 5,645,931.13 5,645,931.13 9 Sinking Funds 10,356,727.39 -0.89% 10,264,776.70 8,763,793.86 7,263,370.21 7,263,063.20 12 Other Special Funds - - - - - 13 Total 17,002,658.52 -22.60% 13,160,707.83 14,409,724.99 12,909,301.34 12,908,994.33 CURRENT AND ACCRUED ASSETS 14 General Cash/temp cash investments 12,707,123.14 -18.26% 10,386,294.64 9,971,177.02 9,740,134.21 5,935,136.64 14.1 Reserved Cash 23,164,910.13 -2.94% 22,483,758.22 22,313,993.48 22,170,470.04 22,076,543.77 15 Accounts Receivable 12,916,453.18 2.23% 13,204,691.74 11,891,719.73 10,406,174.16 11,779,432.47 16 Materials and Supplies 3,461,504.71 -10.53% 3,097,100.13 3,754,240.85 3,970,214.37 3,944,763.73 18 Other Current Assets 23,242,280.77 -13.66% 20,067,650.18 18,666,665.80 21,928,767.57 27,508,377.97 19 Total 75,492,271.93 -8.28% 69,239,494.91 66,597,796.88 68,215,760.35 71,244,254.58 DEFERRED DEBITS 22 Clearing Accounts - 20,957.52 21,795.81 22,634.10 23,472.39 24 Energy Service Loans Rec 2,543,106.81 -35.22% 1,647,303.76 1,715,381.63 1,771,500.91 1,821,657.93 26 Other Deferred Debits 4,275,158.87 -10.06% 3,844,963.02 3,891,771.40 3,916,420.43 3,993,132.91 27 Total 6,818,265.68 -19.14% 5,513,224.30 5,628,948.84 5,710,555.44 5,838,263.23 28 TOTAL ASSETS & OTHER DEBITS $294,585,843.93 1.20% $298,115,758.46 $292,913,272.71 $292,430,068.01 $295,286,420.70 CAPITAL EARNINGS REINVESTED IN SYSTEM ASSETS 33 Beginning of year 171,989,065.77 5.62% 181,656,853.69 181,656,853.69 181,656,853.69 181,656,853.69 34 Current Year to Date 9,667,787.92 11.46% 10,775,694.42 11,430,639.51 11,440,890.84 10,557,394.47 35 Total 181,656,853.69 5.93% 192,432,548.11 193,087,493.20 193,097,744.53 192,214,248.16 Long Term Debt 39.1 Bonds and other Long Term Debt 62,600,000.00 -4.89% 59,540,000.00 59,540,000.00 59,540,000.00 59,540,000.00 40 Debt Premium and discount 8,031,949.94 -7.39% 7,438,729.94 7,488,164.94 7,537,599.94 7,587,034.94 41 Total 70,631,949.94 -5.17% 66,978,729.94 67,028,164.94 67,077,599.94 67,127,034.94 OTHER NON-CURRENT LIABILITIES 39.2 Post Retirement Benefits 1,629,152.62 6.49% 1,734,863.91 1,589,878.10 1,593,112.80 1,599,084.94 42 Energy Service Loans - Advances 2,630,809.67 -34.53% 1,722,512.95 1,780,622.60 1,831,115.92 1,897,886.93 44 Total 4,259,962.29 -18.84% 3,457,376.86 3,370,500.70 3,424,228.72 3,496,971.87 CURRENT AND ACCRUED LIABILITIES 46 Accounts Payable 27,161,988.15 -11.66% 23,996,063.30 18,354,375.25 17,913,113.98 21,821,941.13 47 Customer Deposits 6,821,459.19 4.77% 7,146,827.23 7,120,091.19 7,090,010.76 7,051,277.43 52.2 Interest Accrued - Other 866,770.80 -3.50% 836,408.36 627,306.27 418,204.18 209,102.09 53 Other Current Liabilities 3,186,859.87 2.54% 3,267,804.66 3,325,341.16 3,409,165.90 3,365,845.08 54 Total 38,037,078.01 -7.33% 35,247,103.55 29,427,113.87 28,830,494.82 32,448,165.73 58 TOTAL LIABILITIES AND OTHER CREDITS $ 294,585,843.93 1.20% $ 298,115,758.46 $ 292,913,272.71 $ 292,430,068.01 $ 295,286,420.70  CDE Lightband Revenues and Expenses ‐ Electric Division 6/30/2020 Prior Year Prior 3 Months 6/30/2019 (R) % Change 6/30/2020 5/31/2020 4/30/2020 3/31/2020 OPERATING REVENUE 59 Electric Sales Revenue 14,223,618.12 ‐3.32% 13,751,849.83 11,228,037.27 11,201,767.95 13,393,257.15 60 Revenue from Late Payments 74,026.88 5.51% 78,105.16 (1,205.87) 123,335.35 126,181.94 61 Misc Service Revenue 82,745.11 59.72% 132,158.37 35,223.56 41,112.93 90,745.90 62 Rent from Electric Property 338,344.05 ‐8.14% 310,790.37 311,533.31 310,250.05 309,709.73 63 Other Electric Revenue 1.15 1162777.39% 13,373.09 0.37 (12.59) 0.11 64 Total Operating Revenue 14,718,735.31 ‐2.94% 14,286,276.82 11,573,588.64 11,676,453.69 13,919,894.83 PURCHASED POWER 65 Total Power Cost 10,980,565.71 ‐4.38% 10,499,262.53 8,082,474.83 7,159,182.86 8,038,790.54 OPERATING EXPENSE 66 Transmission Expense 5,276.81 47.38% 7,776.99 6,457.36 6,061.70 6,079.36 67 Distribution Expense 424,757.74 ‐17.41% 350,787.61 356,291.62 297,731.09 350,974.82 68 Customer Accounts Expense 360,232.70 0.62% 362,478.27 294,985.08 310,005.59 340,412.55 69 Cust. Service and Inf. Exp. 43,765.04 ‐14.68% 37,339.73 26,498.78 33,379.51 33,598.00 70 Sales Expense 12,556.02 ‐38.21% 7,758.21 8,337.66 9,723.63 11,855.47 71 Admin. And General Expense 601,414.77 94.49% 1,169,703.00 394,875.19 600,707.76 372,275.86 72 Operating Expense 1,448,003.08 33.69% 1,935,843.81 1,087,445.69 1,257,609.28 1,115,196.06 MAINTENANCE EXPENSE 73 Transmission Expense 2,598.91 16.49% 3,027.51 4,722.24 7,765.09 4,583.28 74 Distribution Expense 538,980.81 ‐25.34% 402,385.42 389,959.33 357,053.72 268,912.23 75 Admin. and General Expense 327,156.23 ‐16.78% 272,265.94 210,677.21 203,567.45 197,641.19 76 Maintenance Expense 868,735.95 ‐21.99% 677,678.87 605,358.78 568,386.26 471,136.70 OTHER OPERATING EXPENSE 77 Depreciation Expense 1,003,632.10 9.14% 1,095,411.76 1,092,568.10 1,090,446.52 1,071,511.72 78 Amort. of Acquisition Adjust. 3,004.53 0.00% 3,004.53 3,004.53 3,004.53 3,004.53 79 Taxes and Tax Equivalents 502,489.88 12.61% 565,878.68 558,733.91 561,656.57 560,584.32 80 Total other oper. Expense 1,509,126.51 10.28% 1,664,294.97 1,654,306.54 1,655,107.62 1,635,100.57 Total operating expense and 81 purchased power 14,806,431.25 ‐0.20% 14,777,080.18 11,429,585.84 10,640,286.02 11,260,223.87 INCOME 82 Operating Income (87,695.94) 459.66% (490,803.36) 144,002.80 1,036,167.67 2,659,670.96 83 Other Income 75,719.47 ‐66.08% 25,684.42 25,565.70 28,609.26 44,050.02 84 Total Income (11,976.47) 3783.61% (465,118.94) 169,568.50 1,064,776.93 2,703,720.98 85 Misc Income Deductions (6,250.00) (10,000.00) ‐ (1,500.00) ‐ 86 Net Income before debt expense (18,226.47) 2506.75% (475,118.94) 169,568.50 1,063,276.93 2,703,720.98 DEBT EXPENSE 90 Interest on Long Term Debt 235,270.09 ‐3.23% 227,679.48 227,679.48 227,679.48 182,135.78 92 Other Interest Expense 1,532.87 3.18% 1,581.67 1,575.35 1,536.08 1,603.12 93 Amort. of Debt Disc. and Exp. ‐ ‐ ‐ ‐ ‐ 94 Amort. of Prem. on Debt (49,435.00) 0.00% (49,435.00) (49,435.00) (49,435.00) (49,435.00) 95 Total Debt Expense 187,367.96 ‐4.03% 179,826.15 179,819.83 179,780.56 134,303.90 NET INCOME 96 Income before Extraord. Items (205,594.43) 218.56% (654,945.09) (10,251.33) 883,496.37 2,569,417.08 97 Extraordinary Items ‐ ‐ ‐ ‐ ‐ 98 Net Income (205,594.43) 218.56% (654,945.09) (10,251.33) 883,496.37 2,569,417.08  CDE Lightband Cash Flow Statement - Electric Division June 30, 2020 RECONCILIATION OF OPERATING INCOME TO NET CASH PROVIDED BY OPER ACTIVITIES: Operating income $ (490,803.36) Adjustments to reconcile oper income to cash provided (used) by operating activities Depreciation and amortization 1,098,416.29 Changes in: Accounts receivable (1,312,972.01) Materials and supplies 657,140.72 Interdivisional loan 2,750,000.00 Accounts receivable - TVA Energy Service Loans 68,077.87 Advances - TVA Energy Service Loans (58,109.65) Prepayments - Other current assets (1,517,479.44) Accounts payable 5,641,688.05 Accrued expenses 209,102.09 Customer deposits 26,736.04 Other postemployment benefits 144,985.81 Other (57,536.50) Net Cash Provided by Operating Activities 7,159,245.91 CASH FLOWS FROM FINANCING ACTIVITIES: Additions to plant (5,023,945.71) Payment of long-term debt (49,435.00) Net Cash used by Financing Activities (5,073,380.71) NET INCREASE IN CASH AND CASH EQUIVALENTS $ 2,085,865.20 CASH AND CASH EQUIVALENTS - BEG OF MONTH 41,048,964.36 CASH AND CASH EQUIVALENTS - END OF MONTH $ 43,134,829.56 CASH AND CASH EQUIVALENTS CONSIST OF: Sinking Funds 10,264,776.70 Construction Funds - General cash/temp cash investments 10,386,294.64 Reserved Cash 22,483,758.22 $ 43,134,829.56  CDE Lightband Subscriber Analysis April 2020 -June 2020 April 2020 May 2020 June 2020 Net Gain April Prior Growth % Net Gain May Prior Growth % Net Gain June Prior Growth % April April April Over Prev. % Growth Year Year Over May May May Over Prev. % Growth Year Year Over June June June Over Prev. % Growth Year Year Over Service Actual Budget Variance Month to Budget Actual Year Actual Budget Variance Month to Budget Actual Year Actual Budget Variance Month to Budget Actual Year Video (Total) 5,314 5,303 11 (516) 0% 5,248 1% 5,312 5,303 9 (2) 0% 5,220 2% 5,255 5,335 (80) (57) -1% 5,199 1% Lightband Basic 376 316 60 (59) 19% 367 2% 375 316 59 (1) 19% 372 1% 366 318 48 (9) 15% 374 -2% Lightband Plus 1,822 1,579 243 (234) 15% 1,811 1% 1,817 1,579 238 (5) 15% 1,834 -1% 1,787 1,590 197 (30) 12% 1,842 -3% Lightband Extra 2,545 3,369 (824) (251) -24% 3,032 -16% 2,532 3,369 (837) (13) -25% 2,979 -15% 2,476 3,392 (916) (56) -27% 2,949 -16% Streaming Services 541 0 541 28 0% 0 0% 558 0 558 17 0% 0 0% 596 0 596 38 0% 0 0% Other Pkgs 30 39 (9) 0 -23% 38 -21% 30 39 (9) 0 -23% 35 -14% 30 35 (5) 0 -14% 34 -12% Internet (Total) 22,317 22,215 102 84 0% 21,168 5% 22,421 22,334 87 104 0% 21,210 6% 23,007 22,454 553 586 2% 21,340 8% Residential Internet 20,636 20,499 137 77 1% 19,645 5% 20,727 20,599 128 91 1% 19,674 5% 21,307 20,694 613 580 3% 19,785 8% Business Internet 1,681 1,716 (35) 7 -2% 1,523 10% 1,694 1,735 (41) 13 -2% 1,536 10% 1,700 1,760 (60) 6 -3% 1,555 9% Phone (Total) 2,536 2,616 (80) (8) -3% 2,551 -1% 2,539 2,636 (97) 3 -4% 2,548 0% 2,540 2,653 (113) 1 -4% 2,552 0% Residential Phone 1,762 1,808 (46) (7) -3% 1,828 -4% 1,760 1,812 (52) (2) -3% 1,817 -3% 1,754 1,810 (56) (6) -3% 1,809 -3% Business Phone 774 808 (34) (1) -4% 723 7% 779 824 (45) 5 -5% 731 7% 786 843 (57) 7 -7% 743 6% Total Broadband Customers 23,753 22,860 893 107 4% 22,132 7% 23,971 22,290 1,681 218 8% 22,213 8% 23,913 22,970 943 (58) 4% 22,519 6%  ORDINANCE 7-2020-21 AN ORDINANCE REPEALING ORDINANCE 152-2006-07 ESTABLISHING A CAPITAL PROJECTS REVENUE DISTRICT (CPRD) AND CAPITAL IMPROVEMENT FUND WHEREAS, the City Council created the CPRD in an effort to capture property tax growth in a specific area where the new hospital was developed off of Ted Crozier Sr. Boulevard and Dunlop Lane; and WHEREAS​, the City’s formation of this district was intended to be similar to tax increment financing (TIF) district; and WHEREAS​, the CPRD has served as an accounting entry to move property tax revenue from the general fund into the CPRD fund where those funds are then transferred to the Debt Service Fund to pay General Obligation (GO) Bonds for various capital projects; and WHEREAS, the City Council finds the best interest of the City is served by the repeal of the ordinance that created the CPRD and to account for said revenue/funds in the ordinary way in accordance with governmental accounting practices; and any associated debt shall continue to be the obligation of the City and will continue to be paid through the Debt Service Fund. NOW, THEREFORE, BE IT ORDAINED BY THE CITY COUNCIL OF THE CITY OF CLARKSVILLE, TENNESSEE: Ordinance 152-2006-07 is hereby repealed and that the Capital Projects Revenue District (CPRD) and the Capital Improvement Fund (CIF) special revenue fund is dissolved. CPRD Fund Decrease Revenue 4141000-31120 $2,434,942 Decrease Expenditures 41410003-4911 $2,434,942 General Fund Increase 2020 Property Tax Revenue 100310-31120 $2,434,942 Increase transfer to debt service fund 10470003-4911 $2,434,942 Transfer unassigned fund balance from CPRD Fund to General Fund $77,910* *Balance may differ depending on the actual ending fund balance for FY20. BE IT FURTHER ORDAINED ​The financial impact to the general fund is an increase in property tax revenue and an increase in transfer out to the debt service fund. These increases are offset by the decreases in the CPRD special revenue fund. FIRST READING: SECOND READING: EFFECTIVE DATE:  RESOLUTION 12-2020-21 A RESOLUTION REPEALING RESOLUTION 60-1992-93 (RESIDENTIAL DEVELOPMENT COMMISSION) AND APPROVING THE FORMATION OF THE LAND REGULATION ADVISORY COMMITTEE FOR THE CITY OF CLARKSVILLE AND MONTGOMERY COUNTY, TENNESSEE WHEREAS, from time to time the subdivision regulations or zoning codes of the city or county text are updated by the City Council, County Commission, or Regional Planning Commission; and WHEREAS, there is interest in establishing a working relationship with the City Council, County Commission, Regional Planning Commission, and the developers and home builders of the community to allow for an open exchange of ideas and concerns in order to implement orderly growth and address the future population expectations of the city and county; and WHEREAS, the previously created Residential Development Commission has been obsolete but there is merit in updating its purpose. NOW, THEREFORE, BE IT RESOLVED BY THE CITY COUNCIL OF THE CITY OF CLARKSVILLE, TENNESSEE: That RESOLUTION 60-1992-93 is hereby repealed and replaced by this resolution. BE IT FURTHER RESOLVED that a Land Regulation Advisory Committee be formed to act as follows: Committee Composition: Beginning in September 2020, the Land Regulation Advisory Committee, hereafter known as the “Committee,” shall be comprised of 7 total members, 2 members of the Clarksville City Council, 2 members of the Montgomery County Commission, and 3 citizens of Montgomery County involved in land development, home building, or real estate and doing business in Montgomery County. The City Council and County Commissioner representatives shall be selected to 2 year terms without succession, appointed by their respective mayors. The citizen members shall be jointly appointed by the Clarksville City Mayor and the Montgomery County Mayor. These appointments shall be for 2 year terms without succession.  A chairman and vice-chairman shall be chosen by vote of the Committee. A term of chairman or vice-chairman shall last 1 year without succession. Ex-officio membership on the Committee shall be comprised of the City Mayor, County Mayor, Director of the Regional Planning Commission, and Chairman of the Regional Planning Commission. Purpose and Authority of the Committee: ​The Committee shall have no legal authority or policy-making authority with the City Council, County Commission, or Regional Planning Commission. The committee will be called to meet when significant changes to the text of the City Zoning Ordinance, County Zoning Resolution, or Montgomery County Subdivision Regulations are proposed. This meeting shall take place prior to the Regional Planning Commission meeting where the Public Hearing is scheduled. The committee shall act as a sounding board to solicit input from the elected officials and the development community regarding the proposed legislation. The City Mayor or County Mayor may request the Committee to convene on a specific topic involving land development to solicit input prior to development or policy or legislation following the proper meeting notification contained herein. Meetings of the Committee​: The committee shall meet as required; at a minimum twice annually. The time and place of the meeting shall be posted at least 48 hours in advance on the City, County, and Regional Planning Commission calendars with a copy of the agenda and proposed legislation available for public review at the Regional Planning Commission office during normal business hours. Governance: The Regional Planning Commission Director shall act as the secretary of the committee and be responsible for the agenda, notification, and minutes for each committee meeting. The order of business and conduct shall be governed by “Roberts Rules of Order”. Compensation: No financial compensation will be provided by the Regional Planning Commission. City Councilmembers and County Commissioners may be compensated according to their individual rules of meeting procedures. ADOPTED: