Finance Committee

FINANCE COMMITTEE MAY 26, 2020 AGENDA 1) 3:00 P.M. NON-PUBLIC MEETING a) Discussion regarding settlement offer - Robinson v. City 2) 3:30 P.M. PUBLIC MEETING CALL TO ORDER 3) ATTENDANCE 4) APPROVAL OF ELECTRONIC MEETING MOTION: ​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. 5) CONSIDERATION OF SETTLEMENT OFFER a) Robinson v. City 6) ADOPTION OF MINUTES: April 28, May 19, May 21 7) DEPARTMENT REPORTS 1. PURCHASING ​Camille Thomas a) Report of bids  b) Report of award of professional service contracts ● Gas & Water - Gas Operator Qualifications Learning Management System from Industrial Training Services, Inc. in the amount of $54,625.00. ● Gas & Water - Design of a 2 MGD Water Treatment Plant Upgrade from Smith Seckman Reid, Inc. in the amount of $182,589.00. ● Human Resources - Cost Association for Post 2006 Hired Employees Retiree Benefits from Findley in the amount of $5,500.00. c) Report of sale of surplus property on ​GovDeals.com ​April 2020: $​6,251.00. 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 ● Bradley Arant, Kimberly Black v. City - $12,397.00 ● Bradley Arant, Jeff Robinson v. City - $21,666.25 ● McCarter English, Fort Campbell Matters - $6,628.05 8) COMMITTEE ACTION None. 9) CITY COUNCIL ACTION 1. BLACKMAN STREET PROPERTY TRANSFER a) ORDINANCE 78-2010-20 (First Reading) Authorizing a quit claim deed to transfer property on Blackman Street to Sydney Hedrick ​Mayor Pitts 2. GAS & WATER a) RESOLUTION 73-2019-20 ​Authorizing an agreement with Woodlawn Utility District for water services ​Mark Riggins  b) RESOLUTION 74-2019-20 Authorizing an agreement with Woodlawn Utility District for sanitary sewerage services ​Mark Riggins 10) 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. 11) ADJOURNMENT  FINANCE COMMITTEE APRIL 28, 2020 MINUTES CALL TO ORDER The regular monthly meeting of the City of Clarksville Finance Committee was called to order by Chairman Jeff Burkhart on Tuesday, April 28, 2020, at 3:30 p.m. from the City Hall Conference Room, 1 Public Square, Clarksville, Tennessee. In an effort to facilitate the response to the Coronavirus Disease (COVID-19), this meeting was via Google Meets. ATTENDANCE The following members responded to roll call and were connected to the meet: PARTICIPATING: Jeff Burkhart, Tim Chandler, Valerie Guzman, Jeff Henley, Stacey Streetman Chairman Jeff Burkhart, Mayor Joe Pitts, City Attorney Lance Baker, Sylvia Skinner, and Director of Information Technology Amie Wilson were physically present. APPROVAL OF ELECTRONIC MEETING MOTION: ​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 Streetman made a motion to approve the electronic meeting. The motion was seconded by Councilman Henley. The following roll call vote was recorded: AYE: Chandler, Guzman, Henley, Streetman The motion to conduct this meeting by electronic means passed. MINUTES Councilman Henley made a motion to adopt the March 24th minutes as presented. The motion was seconded by Councilman Chandler. The following roll call vote was recorded: AYE: Chandler, Guzman, Henley, Streetman The motion to adopt the minutes as presented passed. PURCHASING REPORT Director of Purchasing Camille Thomas briefly reviewed the monthly bid summary and reported award of the following professional service contracts: ● Gas & Water - South Second Street Sewer Capacity Study from McKay-Burchett & Co., LLC in the amount of $9,950.00. ○ ● Human Resources - Actuarial Study for the Internal Services Fund from Select Actuarial Services in the amount of $6,000.00. ● ● Project Management - Post Demolition Rendering of the Frosty Morn Building from Powell Architecture in an amount not to exceed $5,000.00. Ms. Thomas reported sale of surplus property on ​GovDeals.com ​in the amount of $27,008.00 for March 2020. GENERAL FUND REPORT Chief Financial Officer Laurie Matta said expenses were exceeding revenues by $1.4 million during March, but revenues were exceeding expenditures by $8.4 million year-to-date. Revenues were exceeding FY21 YTD by $725,510. Property tax collection totaled $32.7 million or 95% billed and 77% of budgeted revenues had been collected. Although spending was 8.2% under budget, all departments had been asked to reduce their FY20 budget. Local Option Sales Taxes collected totaled $5.4 million with $1.4 million for the General Fund, $ 66,854 for the Road Improvement Fund, and $4.3 million for schools. Active capital project spending reached $4.7 of $32.3 million invested. The current Fund Balance was estimated at $35.5 million or 34.6% of budgeted expenditures. Ms. Matta said she was monitoring the loss of sales tax revenue due to businesses being closed during the COVID-19 pandemic. She said Tennessee’s economic recovery may take up to 6 to 12 months. Mayor Pitts commended the Finance Department for early efforts to reduce spending without adversely impacting services. CDE REPORT CDE Chief Financial Officer David Johns said the March Broadband cash was lower because of repayment of the interdivisional loan to the Electric Division. The net income was $411,000 for the month. Christy Batts reported a net gain of 130 customers, mostly residential who were shifting services by changing packages and moving to streaming. She said efforts were being made to attract new customers and to encourage existing  commercial customers to retain their services when reopening upon the expiration of the Governor’s mandatory stay-at-home order (COVID-19). The Electric Division reported lower usage during the month resulting in a lower TVA power bill and earnings totaled $10.5 million. CITY ATTORNEY REPORT City Attorney Lance Baker reported payment of the following legal expenditures: ● Bradley Arant, ​Jeff Robinson v. City​ - $12,629.25 ● Bradley Arant, ​Kimberly Black v. City​ - $1,382.50 ● Bradley Arant, ​Jeff Robinson v. City​ - $50,545.95 (two months) ● Burr Forman, ​TN River Keepers v. City​ - $1,501.00 REFUNDING BONDS RESOLUTION 57-2019-20 ​Initial resolution to refinance $48 million Tennessee Municipal Bond Fund loans Chief Financial Officer Laurie said she determined previous plans for refinancing were not cost effective. She said 2018 Tennessee Municipal Bond Fund loans were established at a variable rate and this refinancing could result in a rate of less than 3% interest. Ms. Matta said the City would not be obligated to refinance at the appropriate time if it was not feasible. 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 roll call 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/HEALTH DEPARTMENT AGREEMENT RESOLUTION 60-2019-20 ​Authorizing an interlocal agreement between the Tennessee Department of Health and the City of Clarksville (Police Department) relative to sharing of limited personal health information City Attorney Lance Bakker said this agreement would allow the Police Department to receive information from the Tennessee Department of health regarding individuals who have tested COVID-19 positive when responding to emergencies. Councilady Streetman made a motion to forward this resolution to the City Council with a recommendation of approval. The motion was seconded by Councilman Chandler. The following roll call vote was recorded: AYE: Chandler, Guzman, Henley, Streetman The motion to forward this resolution to the City Council with a recommendation of approval passed. BRISTOL RIDGE/BELEW CONTRACT ORDINANCE 72-2019-20 ​(First Reading) Approving a contract authorizing entry and construction between Bristol Ridge Apartments, LLC/William L. Belew, Jr., and the City of Clarksville Street Department Engineer Chris Cowan said this 150’ roadway was being proposed as a result of the recent rezoning of the Belew property on Hwy 76. Traffic assessments recommended an access point near the parking area to lead traffic to the existing signal. Mr. Cowan said this ordinance would require the developer to build the road on city-owned property at his expense and then dedicate the road to the City which would be constructed according to City standards. Councilman Chandler made a motion to forward this ordinance to the City Council with a recommendation of approval. The motion was seconded by Councilady Streetman. The following vote was recorded: AYE: Chandler, Guzman, Henley, Streetman The motion to approve passed. PUBLIC COMMENTS Councilman Chandler thanked Mayor Pitts for establishing a plan to reopen the local economy during the COVID-19 pandemic even though it was superseded by the Governor. ADJOURNMENT The meeting was adjourned at 4:07 p.m.  FINANCE COMMITTEE MAY 19, 2020 MINUTES CALL TO ORDER A meeting of the City of Clarksville Finance Committee was called to order by Chairman Jeff Burkhart on Tuesday, May 19, 2020, at 9:00 a.m. in the City Hall Conference Room, 1 Public Square, Clarksville, Tennessee. This meeting was conducted via Google Meets. ATTENDANCE The following members responded to roll call and were connected to the meet: PARTICIPATING: Jeff Burkhart, Tim Chandler, Valerie Guzman, Jeff Henley, Stacey Streetman Chairman Jeff Burkhart, Mayor Joe Pitts, and Chief Financial Officer Laurie Matta were physically present, as well as Sylvia Skinner (City Clerk), Will Wyatt (Director of Human Resources), Lance Baker (City Attorney), Amie Wilson (Director of Information Technology), Stephanie Fox (Director of Internal Audit), James Halford (Chief of Staff), and Camille Thomas (Director of Purchasing). Several department staff members were also present. 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.  Councilman Henley made a motion to approve the electronic meeting. The motion was seconded by Councilman Chandler. The following roll call vote was recorded: AYE: Chandler, Guzman, Henley, Streetman The motion to conduct this meeting by electronic means passed. FY21 STATUS QUO BUDGET REVIEW The proposed status quo budgets for the Legislative, Finance & Revenue/Parking Commission, Human Resources, Legal, Information Technology/GIS, Internal Audit, Mayor’s Office, and Purchasing department were briefly reviewed. The status quo budgets were being proposed as 5% less than the current amended FY20 budgets. ADJOURNMENT The meeting was adjourned at 10:07 a.m.  FINANCE COMMITTEE MAY 21, 2020 MINUTES CALL TO ORDER A meeting of the City of Clarksville Finance Committee was called to order by Chairman Jeff Burkhart on Thursday, May 21, 2020, at 1:30 p.m. in the City Hall Conference Room, 1 Public Square, Clarksville, Tennessee. This meeting was conducted via Google Meets. ATTENDANCE The following members responded to roll call and were connected to the meet: PARTICIPATING: Jeff Burkhart, Tim Chandler, Valerie Guzman, Jeff Henley, Stacey Streetman Chairman Jeff Burkhart, Mayor Joe Pitts, and Chief Financial Officer Laurie Matta were physically present, as well as Hope Peterson (E-911), Shannon Greene (Central Business Improvement District), Dr. Ellen Kanervo (Arts & Heritage Development Council), Jeff Tyndall (Regional Planning Commission), Anita Atchley and Robert Thompson (Senior Citizens Center), Frank Lott and Colin McAlexander (Custom House Museum), John Patterson (Regional Airport Authority), Juanita Charles (Human Relations Commission), and Bill Summers and Roger Carroll (Crime Stoppers). 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.  Councilman Chandler made a motion to authorize the electronic meeting. The motion was seconded by Councillady Streetman. The following roll call vote was recorded: AYE: Chandler, Guzman, Henley, Streetman The motion to conduct this meeting by electronic means passed. FY21 STATUS QUO BUDGET REVIEW The proposed status quo budgets for the miscellaneous entities were briefly discussed. These included E-911, Central Business Improvement District, Arts & Heritage Development Council, Regional Planning Commission, Senior Citizens Center, Custom House Museum, Regional Airport Authority, Human Relations Commission, Crime Stoppers, Rail Authority, Campbell Strong, and Debt. ADJOURNMENT The meeting was adjourned at 3:20 p.m.  FINANCE & ADMINISTRATION COMMITTEE BID SUMMARY May 26, 2020 The following bids/proposals have been solicited, opened and have been approved by the Purchasing Director. All are low bid/proposal except where noted. BID # DEPT. DESCRIPTION AWARDED TO AMOUNT 4034 G&W Sensus 496 Service Regulators Equipment Controls Co. $ 38,649.60 4041 Recreation Roof Replacement for Burt Cobb Community Center Beech Construction $ 223,748.00 SOLE SOURCE PURCHASE: 1. G&W - Future purchases and service of Kohler Brand generators and parts from Nixon Power Systems. EMERGENCY PURCHASE: 1. Recreation – McGregor Park Dock Repair from Thomson & Thomson in the amount of $78,850.00. Bid # 4034– G&W- Sensus 496 Service Regulators: Equipment Controls Co. $ 38,649.60* Combustion & Controls Co. $ 57,420.00 Tri-State Meter & Regulator No Response Bid #4041 – Recreation – Roof Replacement for Burt Cobb Community Center Beech Construction $ 223,748.00* Hall Construction $ 263.560.00 Local ARCS No Response Adams Construction No Response Carter Douglas Co. No Response Goodrich Construction No Response Local Guardian Weather Proofing Solutions No Response Leon Ross Construction No Response Modern Heating, Cooling & Roofing No Response Local Pride Concrete No Response Local Quality Exterior Co. No Response Local RSS Roofing Services & Solutions No Response Two Rivers Roofing, Inc. No Response Tennessee Roofing & Siding No Response Local Advanced Enterprises, Inc. No Response Jerry’s Roofing No Response Local NIR Roof Care No Response Jackson Roofing No Response Local Ray Marable Contractor, Inc. No Response Local T’s Construction & Roofing No Response JDH Company, Inc. No Response Best Choice Roofing & Home Improvement No Response Local Ronnie Harrison Construction No Response TLC Pro Roofing, LLC No Response Aspen Park Properties No Response Local Baker Roofing Co. No Response Bar Environmental No Response Blue Team Restoration No Response Burell Built LLC No Response Corporate Vision, Inc. No Response Duracap Asphalt Paving Co. No Response Hathaway’s Demo Const. Environmental Service No Response K&J Associates No Response Leland, Inc. No Response Level Up Home Improvements No Response Local Matthews Construction LLC No Response Perry Roofing Co. Inc. No Response R.L. Alvarez Construction LLC No Response Local Roofing Services Co. Inc. No Response S&W Contracting Co. Inc. No Response Smithfield Construction LLC No Response Southeast Contractors, Inc. No Response The Lewis Group Architects Inc. No Response Transformation Construction Group No Response ARCO Roofing of TN Inc. No Response Collier Roofing Co. No Response Don Kennedy Roofing Co. Inc. No Response Elite Roofing Co. No Response Estes Roofing, Inc. No Response Genesis Roofing Co. No Response H&H Home Improvement No Response J&S Construction Co. Inc. No Response J. Cumby Construction Co. Inc. No Response Jewell Roofing & Gutters No Response John J. Campbell Roofing No Response Meyer Brothers Roofing LLC No Response Parchman Construction No Response Local Pinaire Roofing No Response Porter Roofing Contractors, Inc. No Response Simon Roofing No Response Sky Roofing LLC No Response Sortor’s Roofing & More No Response Southern Restoration & Rebuild No Response Southern Roofing Co. of TN No Response Sparks Roofing, Inc. No Response Triple S Contracting, Inc. No Response Local Twin River Turf No Response Local _________________________________________________________________ *Department Recommendation Department of Finance & Revenue April 2020 Financial Review Fiscal Year 2020 Clarksville, Tennessee April 30, 2020  General Fund Revenues vs. Expenditures Fiscal Year 2020 As of April 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,348,357 6,901,952 (1,553,595) May - June - YTD Total $ 84,456,638 $ 77,783,804 $ 6,672,834 $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 April 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,348,357 $ 5,275,436 72,921 May - - June - - YTD Total $ 84,456,638 $ 83,654,757 $ 801,881 $93,000,000 $83,000,000 $73,000,000 $63,000,000 $53,000,000 FY2019 YTD Revenue $43,000,000 $33,000,000 FY2020 YTD Revenue $23,000,000 FY2020 YTD Budgeted Revenue $13,000,000 $3,000,000  General Fund Revenue Details Fiscal Year 2020 As of April 30, 2020 Total Budget YTD Month TAXES Prior Year Property Taxes 894,711 927,094 1,661 2019 Property Taxes 30,162,934 29,006,989 114,773 PiLOTS 90,175 90,175 - Local Option Sales Tax 18,091,510 15,737,770 1,422,964 Beer & Liquor Tax 4,047,113 3,543,813 363,037 Business License 2,623,286 1,261,315 346,281 Franchise Tax (cable) 1,500,931 632,931 - Hote/Motel 424,243 360,908 30,019 Other Taxes 367,426 257,265 29,123 TOTAL TAXES 58,202,329 51,818,261 2,307,858 LICENSES AND PERMITS Building Permits 2,081,533 2,034,301 196,334 Other Permits 104,719 76,984 4,865 TOTAL PERMITS 2,186,252 2,111,285 201,199 INTERGOVERNMENTAL Grant reimbursements 57,824 23,013 - State Shared Revenues TVA Replacement Tax 1,595,148 1,226,248 408,749 State Sales Tax 11,963,610 10,196,984 902,558 State Street Aid 5,782,794 4,293,374 375,077 Other Taxes 2,034,999 1,946,589 294,415 TOTAL INTERGOVERNMENTAL 21,434,375 17,686,208 1,980,800 OTHER REVENUES Charges for Services 690,078 565,630 46,034 Recreation 447,498 309,508 (380) Golf Courses 393,802 347,059 882 Fines and Forefeitures 476,113 405,684 24,126 Investment & Interest Earnings 335,214 284,231 67 Other Misc. Revenues 916,134 799,984 63,551 Transfer from CDE 4,677,035 3,892,174 392,432 Transfer From CGW 3,749,887 3,090,838 329,525 Other Transfers 449,502 275,775 2,265 TOTAL OTHER REVENUES 12,135,263 9,970,884 858,500 TOTAL REVENUES GENERAL FUND 93,958,219 81,586,638 5,348,357  General Fund Expenditure Comparison Fiscal Year 2020 As of April 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 6,901,952 $ 7,969,755 (1,067,803) May - - June - - YTD Total $ 77,783,804 $ 71,656,967 $ 6,126,836 $92,000,000 $82,000,000 $72,000,000 $62,000,000 $52,000,000 FY2019 YTD Expenditures $42,000,000 FY2020 YTD Expenditures $32,000,000 $22,000,000 FY2020 YTD Budgeted Expenditures $12,000,000 $2,000,000  General Fund Year-to-Date Departmental Budget vs. Actual Expenditures Fiscal Year 2020 As of April 30, 2020 30,000,000.00 Expenditures Estimated Variance 25,000,000.00 Departmental: FY 2019 YTD YTD Budget (Over)Under 20,000,000.00 15,000,000.00 Police $ 25,232,649 $ 25,402,852 $ 170,203 10,000,000.00 Fire 15,216,924 15,455,136 238,212 5,000,000.00 FY 20 YTD Budget Highway & Street 10,829,790 11,666,498 836,708 0.00 Parks & Rec. & Golf 6,473,343 7,663,626 1,190,283 FY 2020 Actual YTD Building & Codes 1,667,937 1,737,384 69,447 Info. Technology 1,564,065 1,546,890 (17,175) Finance 1,389,781 1,425,580 35,799 City Garage 1,040,240 1,038,846 (1,394) Municipal Properties 390,756 406,679 15,923 Human Resources 890,913 906,240 15,327 Legislative / Admin. 542,552 550,333 7,781 Mayor's Office 536,250 541,190 4,940 1,200,000.00 City Court 366,900 366,634 (266) 1,000,000.00 Legal 389,198 377,604 (11,594) 800,000.00 600,000.00 Internal Audit 285,214 322,976 37,762 400,000.00 Purchasing 160,078 166,388 6,311 200,000.00 Departmental Total 66,976,589 69,574,856 2,598,267 0.00 FY 20 YTD Budget Nondepartmental: FY 2020 Actual YTD Debt 4,900,067 8,383,478 3,483,411 Transit 1,992,072 1,724,670 (267,402) Retirees 1,052,594 1,309,238 256,644 Other 2,862,483 3,126,207 263,724 YTD Total $ 77,783,804 $ 84,118,448 $ 6,334,644  Schedule of Sales Tax Collections Fiscal Year 2020 As of April 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 June YTD Total $ 13,467,799 $ 14,219,851 $ 15,582,792 $ 16,509,836 City of Clarksville $18,500,000 $16,500,000 $14,500,000 $12,500,000 $10,500,000 $8,500,000 $6,500,000 $4,500,000 $2,500,000 $500,000 FY 2017 FY 2018 FY 2019 FY 2020  Local Sales Tax Collections Fiscal Year 2020 As of April 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 - June - YTD TOTAL $ 68,438,680 $ 1,014,724 $ 15,737,771 $ 772,065 $ 50,914,120 $ 6,749,420 $ 62,467,955 $ 778,695 Monthly Distribution  Capital Project Status Report Fiscal Year 2020 As of April 30, 2020 TOTAL ACTIVE ACTIVE PROJECTS TOTAL FY EXPENSES PROJECT PROJECT FY2019-2020 FUNDING 7/1/19-4/30/20 BALANCE EXPENSES ** STREET DEPARTMENT: 93101 Rossview/Dunbar Cave/Cardinal Improvements 13,280,000 208,084 2,726,620 10,553,380 14301 Edmondson Ferry/1A Bypass Interesection Improvement1,150,004 9,640 1,150,002 2 15306 Northeast Connector 16,808,700 355,886 1,231,927 15,576,773 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 289,326 862,534 9,137,466 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 0 1,600 98,400 19302 Whitfield Road Improvements 3,350,000 850,442 1,058,771 2,291,229 19303 Spot Intersection Improvements 1,500,000 43,852 50,052 1,449,948 20301 Dunbar Cave Road Bridge 600,000 0 0 600,000 20302 4th Street and College Signal 400,000 13,050 13,050 386,950 20303 New Sidewalks FY20-24 900,000 782,364 782,364 117,636 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 $ 2,960,178 $ 8,653,639 $ 46,778,035 PARKS & RECREATION: 16503 Athlectic Complex 5,297,478 125,435 4,597,196 700,282 16504 Red River East Trail Project 2,403,712 899,603 2,151,406 252,306 17501 Valleybrook Park & Upland Trail Connection 160,000 0 0 160,000 17502 Public Spaces 150,000 0 148,750 1,250 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 39,008 99,532 805,686 17506 Swan Lake Renovations 1,046,605 223 1,039,218 7,387 19502 Pollard Road Additional Parking 319,199 34,244 42,244 276,955 19503 Billy Dunlop Pavillion & Restroom 382,485 376,391 378,391 4,094 19504 Heritage Park Improvements 1,000,000 284,698 502,566 497,434 19505 Regional Community Center 500,000 0 0 500,000 20501 Red River Pedestrian Bridge 3,068,233 1,721 1,721 3,066,512 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 0 0 230,000 $ 16,350,530 $ 1,964,024 $ 9,292,205 $ 7,058,325 FIRE DEPARTMENT: 16221 Fire Maintenance Facility 901,377 12,000 13,300 888,077 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 $ 12,000 $ 13,300 $ 1,603,077 POLICE DEPARTMENT: 19211 District 3 Precinct Building 3,500,000 188,000 188,000 3,312,000 $ 3,500,000 $ 188,000 $ 188,000 $ 3,312,000 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 0 0 1,200,000 $ 18,729,026 $ 144,889 $ 14,664,480 $ 4,064,546 debt issuance costs Total Spent YTD: Major Projects $ 95,627,607 $ 5,269,090 $ 32,811,624 $ 62,815,983 * 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 April 30, 2020 Beginning Fund Estimated Ending Revenues Expenditures Fund Balance Fund Balance YTD YTD 7/01/19 04/30/20 General Fund: $ 29,943,642 $ 81,586,638 $ 77,783,804 $ 33,746,476 Capital Projects Fund: 2,556,107 3,452,016 5,269,090 739,033 Debt Service Fund: 474,377 5,346,467 5,326,972 493,872 Internal Service Funds: 6,300,385 12,701,868 14,147,204 4,855,048 Non-Major Governmental Funds: Drug Fund 502,153 348,341 119,273 731,221 Road Improvement Fund 1,094,794 772,065 750,000 1,116,859 Police Special Fund 191,193 541,116 555,305 177,004 Parks Special Fund 362,757 278,930 395,068 246,619 Other Special Revenue Fund* 840,479 486,050 549,776 776,753 Community Development 460,231 1,460,044 1,577,708 342,567 Capital Projects Revenue District Fund 78,179 2,870,000 568,130 2,380,049 * Includes: Fire Spec. Rev., Traffic Camera Police & Parks, SRF  Notice of Grant Applications Fiscal Year 2020 As of April 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 Submitted 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. 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.  Date Funding Funds Match Submitted Project Title Agency Requested Required Status Notes 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)  Investment Report Fiscal Year 2020 As of April 30, 2020 COUPON ISSUER NAME PAR VALUE CUSIP RATE LOCAL GOVERNMENT INVESTMENT POOL SELF-INSURANCE $ 591,166 0.850 CAPITAL PROJECTS FUNDS 1,805,451 0.850 INVESTMENT ACCOUNT 24,100,118 0.850 2016 BOND ISSUANCE 726,629 0.850 0.850 LGIP TOTAL / AVERAGE $ 27,223,364 0.850 SELF-INSURANCE CAPITAL PROJECTS FUNDS INVESTMENT ACCOUNT 2016 BOND ISSUANCE  CDE Lightband Rolling 4 month Balance Sheet - Broadband Division April 30, 2020 4/30/19 % Change 4/30/20 3/31/20 2/29/20 1/31/20 Assets Current Assets: Cash -Operating Account $ 6,678,896.36 -12.40% $ 5,850,945.91 $ 5,782,482.51 $ 6,442,439.03 $ 6,182,946.05 Accounts Receivable: Subscribers, less allowance 1,476,076.20 6.29% 1,568,962.72 1,580,967.92 1,538,186.38 1,457,037.97 Other 41,652.55 -14.22% 35,728.77 39,914.32 35,829.00 28,940.80 Temporary advances - Electric 1,921,410.78 6.50% 2,046,363.69 1,965,275.56 1,900,474.79 2,075,870.24 Inventory 366,858.91 75.25% 642,920.79 639,398.43 553,812.52 550,340.11 Total Current Assets $ 10,484,894.80 -3.24% $ 10,144,921.88 $ 10,008,038.74 $ 10,470,741.72 $ 10,295,135.17 Noncurrent Assets: Construction Work In Progress $ 7,142.38 -9.76% $ 6,445.27 $ 5,730.74 $ 5,804.88 $ 39,319.54 Telecommunications Plant 8,329,388.74 5.66% 8,800,818.87 8,494,721.90 8,558,384.96 8,517,887.25 Accumulated Depreciation (5,470,736.47) 1.77% (5,567,829.96) (5,553,501.14) (5,569,428.66) (5,521,341.28) Deferred Debit - Software & Outflows of Resources 389,721.70 -17.27% 322,429.87 369,065.48 402,555.79 459,361.48 Total Noncurrent Assets $ 3,255,516.35 9.41% $ 3,561,864.05 $ 3,316,016.98 $ 3,397,316.97 $ 3,495,226.99 Total Assets $ 13,740,411.15 -0.24% $ 13,706,785.93 $ 13,324,055.72 $ 13,868,058.69 $ 13,790,362.16 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,007,341.54 11.89% 3,364,931.70 2,953,912.65 2,604,408.39 2,335,433.99 Retained Earnings - Current 372,716.20 7.15% 399,358.40 411,019.05 349,504.26 268,974.40 Total Retained Earnings (Deficit) $ 368,558.26 1139.46% $ 4,568,127.03 $ 4,168,768.63 $ 3,757,749.58 $ 3,408,245.32 Current Liabilities: Accounts Payable $ 2,027,253.49 6.25% $ 2,153,886.59 $ 2,113,081.53 $ 3,096,786.16 $ 2,315,093.95 Unearned Revenue $ 609,040.12 12.06% $ 682,497.65 $ 682,497.65 $ 682,497.65 $ 682,497.65 Other Accrued Payables 97,963.79 110.31% 206,025.11 262,047.25 232,259.61 285,018.50 Total Current Liabilities $ 2,734,257.40 11.27% $ 3,042,409.35 $ 3,057,626.43 $ 4,011,543.42 $ 3,282,610.10 Noncurrent Liabilities: Customer Deposits $ 2,794.42 -59.29% $ 1,137.48 $ 1,137.48 $ 1,287.48 $ 1,287.48 Postretirement Benefits 330,875.94 4.14% 344,566.94 345,978.05 346,933.08 347,674.13 Deferred Inflows of Resources 7,994.00 1208.66% 104,614.00 104,614.00 104,614.00 104,614.00 Long Term Debt to the Electric Division 10,295,931.13 -45.16% 5,645,931.13 5,645,931.13 5,645,931.13 6,645,931.13 Total Noncurrent Liabilities $ 10,637,595.49 -42.69% $ 6,096,249.55 $ 6,097,660.66 $ 6,098,765.69 $ 7,099,506.74 Total Liabilities $ 13,371,852.89 -31.66% $ 9,138,658.90 $ 9,155,287.09 $ 10,110,309.11 $ 10,382,116.84 Total Liabilities & Retained Earnings $ 13,740,411.15 -0.24% $ 13,706,785.93 $ 13,324,055.72 $ 13,868,058.69 $ 13,790,362.16  CDE Lightband Income Statement - Broadband Division 4/30/2020 % 4/30/19 Change 4/30/20 3/31/20 2/29/20 1/31/20 Operating Revenue: Programming Revenue $ 420,739.22 4.63% $ 440,207.86 $ 439,473.85 $ 442,492.71 $ 450,116.78 Internet Revenue 1,182,987.65 8.67% 1,285,568.32 1,272,890.37 1,268,453.42 1,256,338.36 Telephone Revenue 147,696.25 3.14% 152,332.52 152,737.80 149,463.99 143,662.93 Miscellaneous Fee Revenue 130,569.56 -14.56% 111,555.87 136,281.35 137,998.92 138,794.88 Total Operating Revenues 1,881,992.68 5.72% 1,989,664.57 2,001,383.37 1,998,409.04 1,988,912.95 Cost of Programming & Services 702,240.31 5.70% 742,253.10 733,034.95 703,815.65 751,303.36 Gross Revenue: $ 1,179,752.37 5.74% $ 1,247,411.47 $ 1,268,348.42 $ 1,294,593.39 $ 1,237,609.59 Operating Expenses: Network Support Expense-Video $ 42,214.99 -20.87% $ 33,403.65 $ 39,189.13 $ 35,397.72 $ 38,326.29 Network Support Expense-Internet 133,697.99 6.14% 141,900.78 138,237.22 138,458.28 141,213.22 Network Support Expense-Phone 19,773.42 -21.25% 15,571.04 15,620.16 15,589.46 17,705.78 Network Admin. & Oper. Expense 114,876.78 0.02% 114,903.97 125,486.85 108,147.67 130,249.45 Building & Office Expense 8,047.00 0.00% 8,047.00 8,047.00 8,047.00 8,047.00 Depreciation & Amortization Expense 71,868.17 24.45% 89,443.49 92,631.49 92,571.19 105,071.45 General & Administrative Expense 186,361.04 22.78% 228,816.81 223,103.37 232,204.23 167,126.36 Station Apparatus Expense 113,256.85 -17.14% 93,845.62 101,722.68 152,963.24 195,913.24 Customer Service Expense 57,247.96 -6.01% 53,807.03 52,379.83 64,673.54 58,770.19 Marketing Expense 45,972.76 30.14% 59,829.02 53,796.64 89,818.36 99,131.08 Total Operating Expenses $ 793,316.96 5.83% $ 839,568.41 $ 850,214.37 $ 937,870.69 $ 961,554.06 Operating Income (Loss) $ 386,435.41 5.54% $ 407,843.06 $ 418,134.05 $ 356,722.70 $ 276,055.53 Interest Expense 10,646.12 -49.17% 5,411.57 4,041.91 4,145.35 4,008.04 Other Expenses - Tax Equivalent 3,073.09 0.00% 3,073.09 3,073.09 3,073.09 3,073.09 Other Expense - Loss on Retirement of Equipment $ - $ - $ - $ - $ - Total Other Expenses (Income) $ 13,719.21 -38.15% $ 8,484.66 $ 7,115.00 $ 7,218.44 $ 7,081.13 Net Income (Loss) $ 372,716.20 7.15% $ 399,358.40 $ 411,019.05 $ 349,504.26 $ 268,974.40 EBITDA $ 458,303.58 $ 497,286.55 $ 510,765.54 $ 449,293.89 $ 381,126.98  CDE Lightband Cash Flow Statement - Broadband Division April 30, 2020 RECONCILIATION OF OPERATING INCOME TO NET CASH PROVIDED BY OPER ACTIVITIES: Operating income (loss) $ 407,843.06 Adjustments to reconcile oper income to cash provided (used) by operating activities Depreciation and amortization 89,443.49 Changes in: Accounts receivable 16,190.75 Advances to Electric (81,088.13) Inventory (3,522.36) Accounts payable 40,805.06 Accrued expenses (57,433.25) Customer deposits - Other 38,150.95 Net Cash Used by Operating Activities 450,389.57 CASH FLOWS FROM FINANCING ACTIVITIES: Payment of long term debt - Additions to plant (381,926.17) Net Cash Used by Financing Activities (381,926.17) NET INCREASE IN CASH AND CASH EQUIVALENTS $ 68,463.40 CASH AND CASH EQUIVALENTS - BEG OF MONTH 5,782,482.51 CASH AND CASH EQUIVALENTS - END OF MONTH $ 5,850,945.91  CDE Lightband olling onth Balan e Sheet - Ele tri Division April 30, 2020 Prior Year 30 20 Change 30 2020 3 3 2020 2 2 2020 3 2020 UTILITY PLANT 1 Electric Plant $ 294,159,330.49 6.40 $ 312,985,684.70 $ 311,730,311.37 $ 309,818,913.25 $ 307,916,645.32 2 Less Depreciation (102,470,225.97) 4.84 (107,433,297.24) (106,480,470.76) (105,940,590.51) (105,371,738.29) 3 Total $191,689,104.52 7.23 $205,552,387.46 $205,249,840.61 $203,878,322.74 $202,544,907.03 4 Unamortized ac . adj. 78,117.78 -46.15 42,063.42 45,067.95 48,072.48 51,077.01 6 Total Plant - Net $191,767,222.30 7.21 $205,594,450.88 $205,294,908.56 $203,926,395.22 $202,595,984.04 OTHER PROPERTY AND INVESTMENTS 8 Interdivisional loan 10,295,931.13 -45.16 5,645,931.13 5,645,931.13 5,645,931.13 6,645,931.13 9 Sin ing Funds 7,319,195.81 -0.76 7,263,370.21 7,263,063.20 7,262,504.61 8,515,130.42 12 Other Special Funds - - - - - 13 Total 17,615,126.94 -26.71 12,909,301.34 12,908,994.33 12,908,435.74 15,161,061.55 CURRENT AND ACCRUED ASSETS 14 General Cash temp cash investments 8,546,279.00 13.97 9,740,134.21 5,935,136.64 8,009,942.50 7,194,544.01 14.1 Reserved Cash 27,729,934.58 -20.05 22,170,470.04 22,076,543.77 21,977,956.32 24,775,088.86 15 Accounts Receivable 11,141,408.62 -6.60 10,406,174.16 11,779,432.47 13,893,320.95 11,168,075.66 16 Materials and Supplies 3,554,128.96 11.71 3,970,214.37 3,944,763.73 4,166,065.16 3,963,458.05 18 Other Current Assets 22,956,192.60 -4.48 21,928,767.57 27,508,377.97 25,709,800.10 24,856,935.56 19 Total 73,927,943.76 -7.73 68,215,760.35 71,244,254.58 73,757,085.03 71,958,102.14 DEFERRED DEBITS 22 Clearing Accounts - 22,634.10 23,472.39 24,310.68 25,148.97 24 Energy Service Loans Rec 2,724,630.39 -34.98 1,771,500.91 1,821,657.93 1,894,287.84 1,967,971.58 26 Other Deferred Debits 4,113,821.25 -4.80 3,916,420.43 3,993,132.91 4,180,434.43 4,345,780.64 27 Total 6,838,451.64 -16.49 5,710,555.44 5,838,263.23 6,099,032.95 6,338,901.19 28 TOTAL ASSETS OTHER DEBITS $290,148,744.64 0.79 $292,430,068.01 $295,286,420.70 $296,690,948.94 $296,054,048.92 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 10,891,161.64 5.05 11,440,890.84 10,557,394.47 7,987,977.39 6,250,073.47 35 Total 182,880,227.41 5.59 193,097,744.53 192,214,248.16 189,644,831.08 187,906,927.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,130,819.94 -7.30 7,537,599.94 7,587,034.94 7,636,469.94 7,685,904.94 41 Total 70,730,819.94 -5.16 67,077,599.94 67,127,034.94 67,176,469.94 67,225,904.94 OTHER NON-CURRENT LIABILITIES 41.9 Post Retirement Benefits 1,424,025.22 11.87 1,593,112.80 1,599,084.94 1,605,278.83 1,608,934.90 42 Energy Service Loans - Advances 2,818,021.45 -35.02 1,831,115.92 1,897,886.93 1,978,335.04 2,053,407.99 44 Total 4,242,046.67 -19.28 3,424,228.72 3,496,971.87 3,583,613.87 3,662,342.89 CURRENT AND ACCRUED LIABILITIES 46 Accounts Payable 22,306,612.03 -19.70 17,913,113.98 21,821,941.13 25,898,599.57 25,901,677.14 47 Customer Deposits 6,811,746.57 4.09 7,090,010.76 7,051,277.43 7,024,374.93 6,999,310.12 52.2 Interest Accrued - Other 433,385.40 -3.50 418,204.18 209,102.09 45,543.70 1,083,463.50 53 Other Current Liabilities 2,743,906.62 24.24 3,409,165.90 3,365,845.08 3,317,515.85 3,274,423.17 54 Total 32,295,650.62 -10.73 28,830,494.82 32,448,165.73 36,286,034.05 37,258,873.93 58 TOTAL LIABILITIES AND OTHER CREDITS $ 290,148,744.64 0.79 $ 292,430,068.01 $ 295,286,420.70 $ 296,690,948.94 $ 296,054,048.92  CDE Lightband Revenues and Expenses ‐ Electric Division 4/30/2020 Prior Year Prior 3 Months 4/30/2019 % Change 4/30/2020 3/31/2020 2/29/2020 1/31/2020 OPERATING REVENUE 59 Electric Sales Revenue 11,659,084.31 ‐3.92% 11,201,767.95 13,393,257.15 15,378,460.32 14,497,796.21 60 Revenue from Late Payments 113,893.12 8.29% 123,335.35 126,181.94 107,424.34 148,603.08 61 Misc Service Revenue 119,138.51 ‐65.49% 41,112.93 90,745.90 113,224.08 131,357.04 62 Rent from Electric Property 252,049.47 23.09% 310,250.05 309,709.73 309,009.77 311,468.49 63 Other Electric Revenue 1.96 ‐742.35% (12.59) 0.11 (127.05) (195.64) 64 Total Operating Revenue 12,144,167.37 ‐3.85% 11,676,453.69 13,919,894.83 15,907,991.46 15,089,029.18 PURCHASED POWER 65 Total Power Cost 7,889,445.54 ‐9.26% 7,159,182.86 8,038,790.54 10,641,607.91 11,276,159.88 OPERATING EXPENSE 66 Transmission Expense 3,135.99 93.29% 6,061.70 6,079.36 5,183.11 4,994.95 67 Distribution Expense 381,159.02 ‐21.89% 297,731.09 350,974.82 344,441.83 432,649.21 68 Customer Accounts Expense 575,265.95 ‐46.11% 310,005.59 340,412.55 324,172.26 337,991.94 69 Cust. Service and Inf. Exp. 25,791.64 29.42% 33,379.51 33,598.00 44,622.84 34,769.86 70 Sales Expense 10,914.04 ‐10.91% 9,723.63 11,855.47 11,770.95 12,326.47 71 Admin. And General Expense 327,814.94 83.25% 600,707.76 372,275.86 422,850.02 481,954.44 72 Operating Expense 1,324,081.58 ‐5.02% 1,257,609.28 1,115,196.06 1,153,041.01 1,304,686.87 MAINTENANCE EXPENSE 73 Transmission Expense 1,963.35 295.50% 7,765.09 4,583.28 5,714.96 5,842.08 74 Distribution Expense 312,275.09 14.34% 357,053.72 268,912.23 399,536.93 690,492.38 75 Admin. and General Expense 153,771.44 32.38% 203,567.45 197,641.19 200,848.24 235,012.20 76 Maintenance Expense 468,009.88 21.45% 568,386.26 471,136.70 606,100.13 931,346.66 OTHER OPERATING EXPENSE 77 Depreciation Expense 1,028,126.70 6.06% 1,090,446.52 1,071,511.72 1,067,670.64 1,066,093.88 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 559,686.27 0.35% 561,656.57 560,584.32 555,360.02 567,466.90 80 Total other oper. Expense 1,590,817.50 4.04% 1,655,107.62 1,635,100.57 1,626,035.19 1,636,565.31 Total operating expense and 81 purchased power 11,272,354.50 ‐5.61% 10,640,286.02 11,260,223.87 14,026,784.24 15,148,758.72 INCOME 82 Operating Income 871,812.87 18.85% 1,036,167.67 2,659,670.96 1,881,207.22 (59,729.54) 83 Other Income 70,276.26 ‐59.29% 28,609.26 44,050.02 43,997.77 50,685.13 84 Total Income 942,089.13 13.02% 1,064,776.93 2,703,720.98 1,925,204.99 (9,044.41) 85 Misc Income Deductions (500.00) (1,500.00) ‐ ‐ (425.00) 86 Net Income before debt expense 941,589.13 12.92% 1,063,276.93 2,703,720.98 1,925,204.99 (9,469.41) DEBT EXPENSE 90 Interest on Long Term Debt 235,270.09 ‐3.23% 227,679.48 182,135.78 235,270.09 235,270.09 92 Other Interest Expense 1,455.35 5.55% 1,536.08 1,603.12 1,465.98 1,551.68 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,290.44 ‐4.01% 179,780.56 134,303.90 187,301.07 187,386.77 NET INCOME 96 Income before Extraord. Items 754,298.69 17.13% 883,496.37 2,569,417.08 1,737,903.92 (196,856.18) 97 Extraordinary Items ‐ ‐ ‐ ‐ ‐ 98 Net Income 754,298.69 17.13% 883,496.37 2,569,417.08 1,737,903.92 (196,856.18)  CDE Lightband Cash Flow Statement - Ele tri Division April 30, 2020 RECONCILIATION OF OPERATING INCOME TO NET CASH PROVIDED BY OPER ACTIVITIES: Operating income $ 1,036,167.67 Adjustments to reconcile oper income to cash provided (used) by operating activities Depreciation and amortization 1,093,451.05 Changes in: Accounts receivable 1,373,258.31 Materials and supplies (25,450.64) Interdivisional loan - Accounts receivable - TVA Energy Service Loans 50,157.02 Advances - TVA Energy Service Loans (66,771.01) Prepayments - Other current assets 5,504,489.87 Accounts payable (3,908,827.15) Accrued expenses 209,102.09 Customer deposits 38,733.33 Other postemployment benefits (5,972.14) Other 43,320.82 Net Cash Provided by Operating Activities 5,341,659.22 CASH FLOWS FROM FINANCING ACTIVITIES: Additions to plant (1,392,993.37) Payment of long-term debt (49,435.00) Net Cash used by Financing Activities (1,442,428.37) NET INCREASE IN CASH AND CASH EQUIVALENTS $ 3,899,230.85 CASH AND CASH EQUIVALENTS - BEG OF MONTH 35,274,743.61 CASH AND CASH EQUIVALENTS - END OF MONTH $ 39,173,974.46 CASH AND CASH EQUIVALENTS CONSIST OF: Sin ing Funds 7,263,370.21 Construction Funds - General cash temp cash investments 9,740,134.21 Reserved Cash 22,170,470.04 $ 39,173,974.46  CDE Lightb Februa February 2020 Net Gain February Growth % February February February Over Prev. % Growth Prior Year Year Over Service Actual Budget Variance Month to Budget Actual Year Video (Total) 5,596 5,309 287 646 5% 5,311 5% Lightband Basic 431 316 115 56 36% 356 21% Lightband Plus 1,860 1,581 279 (21) 18% 1,802 3% Lightband Extra 2,811 3,373 (562) 147 -17% 3,115 -10% Streaming Services 464 0 464 464 0% 0 0% Other Pkgs 30 39 (9) 0 -23% 38 -21% Internet (Total) 22,142 22,007 135 161 1% 20,885 6% Residential Internet 20,465 20,316 149 154 1% 19,388 6% Business Internet 1,677 1,691 (14) 7 -1% 1,497 12% Phone (Total) 2,539 2,597 (58) 12 -2% 2,567 -1% Residential Phone 1,775 1,817 (42) 7 -2% 1,856 -4% Business Phone 764 780 (16) 5 -2% 711 7% Total Broadband Customers 23,516 22,640 876 876 4% 21,915 7% CDE Lightband Subscriber Analysis February 2020 - April 2020 March 2020 April 2020 Net Gain March Growth % March March March Over Prev. % Growth Prior Year Year Over April April April Actual Budget Variance Month to Budget Actual Year Actual Budget Variance 5,830 5,306 524 231 10% 5,303 10% 5,314 5,303 11 435 316 119 56 38% 361 20% 376 316 60 2,056 1,580 476 (21) 30% 1,815 13% 1,822 1,579 243 2,796 3,371 (575) 147 -17% 3,089 -9% 2,545 3,369 (824) 513 0 513 49 0% 0 0% 541 0 541 30 39 (9) 0 -23% 38 -21% 30 39 (9) 22,233 22,092 141 161 1% 21,117 5% 22,317 22,215 102 20,559 20,389 170 154 1% 19,607 5% 20,636 20,499 137 1,674 1,703 (29) 7 -2% 1,510 11% 1,681 1,716 (35) 2,544 2,602 (58) 5 -2% 2,554 0% 2,536 2,616 (80) 1,769 1,808 (39) (6) -2% 1,841 -4% 1,762 1,808 (46) 775 794 (19) 11 -2% 713 9% 774 808 (34) 23,646 22,810 836 876 4% 22,017 7% 23,753 22,860 893 April 2020 Net Gain April Prior Growth % Over Prev. % Growth Year Year Over Month to Budget Actual Year 210 0% 5,248 1% 56 19% 367 2% (21) 15% 1,811 1% 147 -24% 3,032 -16% 28 0% 0 0% 0 -23% 38 -21% 161 0% 21,168 5% 154 1% 19,645 5% 7 -2% 1,523 10% (8) -3% 2,551 -1% (7) -3% 1,828 -4% (1) -4% 723 7% 876 4% 22,132 7%  ORDINANCE 78-2019-20 AN ORDINANCE AUTHORIZING TRANSFER OF PROPERTY ON BLACKMAN STREET TO SYDNEY HEDRICK WHEREAS, Sydney Hedrick (hereinafter, “Mr. Hedrick”) owns certain real property located at 138 Blackman Street, having a map, group and parcel number of 066OB 01200 000 (hereinafter, the “Hedrick Property”); and WHEREAS, The City of Clarksville owns certain real property immediately abutting the Hedrick Property and having a map, group and parcel number of 066JG 00401 000; and WHEREAS, Mr. Hedrick and the City of Clarksville mutually desire to clarify and resolve ambiguity which may exist within the chain of title to the above-referenced parcels and, more specifically, ambiguity relating to the particular dimensions of the Hedrick Property; and WHEREAS, Mr. Hedrick and the City of Clarksville mutually desire to clarify and resolve the aforementioned ambiguity via the City’s execution of a quitclaim deed, which is attached hereto as Exhibit A. ​NOW, THEREFORE, BE IT ORDAINED BY THE CITY COUNCIL OF THE CITY OF CLARKSVILLE, TENNESSEE: That the City of Clarksville is hereby authorized to execute the quitclaim deed attached hereto as Exhibit A to transfer property on Blackman Street to Sydney Hedrick. FIRST READING: SECOND READING: EFFECTIVE DATE: CITY OF CLARKSVILLE, This instrument prepared by: A Tennessee Municipal Corporation The City Attorney’s Office One Public Square, 4​th​ Floor QUITCLAIM DEED Clarksville, TN 37040 TO: SYDNEY HEDRICK FOR A VALUABLE CONSIDERATION​, receipt of which is acknowledged, the ​CITY OF CLARKSVILLE, TENNESSEE, ​a Tennessee municipal corporation located in Montgomery County, Tennessee (hereinafter, “Grantor”), has this day quitclaimed and conveyed and does hereby transfer, quitclaim and convey unto SYDNEY HEDRICK​, his successors and assigns forever, all of the Grantor’s rights, title and interest in the following described property, together with all improvements thereon, situated in the 12th Civil District of Montgomery County, Tennessee, and further described as follows, to wit: See​ Exhibit A attached hereto. IN WITNESS WHEREOF​, the Grantor has executed this quitclaim deed on the ____ day of ____________________, 2020. CITY OF CLARKSVILLE, TENNESSEE A TENNESSEE MUNICIPAL CORPORATION By: _________________________________________ JOE PITTS, Mayor _____________________________ SYLVIA SKINNER​, City Clerk STATE OF TENNESSEE ) COUNTY OF MONTGOMERY ) Personally appeared before me, the undersigned, a Notary Public, in and for said County and State, ​JOE PITTS​, Mayor, and ​SYLVIA SKINNER​, City Clerk, with whom I am personally acquainted, and who, upon oath, acknowledged that they executed the within instrument for the purposes therein contained, and who further acknowledged that they are the Mayor and City Clerk, respectively of the maker, City of Clarksville, a Tennessee Corporation, and they are authorized by the maker to execute the instrument on behalf of the maker.  Witness my hand and seal this the _____ day of ___________________, 2020. _____________________________________________ NOTARY PUBLIC SEAL My commission expires: _____________________________________________ NAME AND ADDRESS OF PROPERTY PERSON/ENTITY RESPONSIBLE OWNER: FOR PAYMENT OF PROPERTY TAXES (IF DIFFERENT) Sydney Hedrick Same 2006 Hidden Meadows Drive Adams, TN 37010 STATE OF TENNESSEE ) COUNTY OF MONTGOMERY ) I, or we, hereby swear or affirm that the actual consideration for this transfer or value of the property transferred, whichever is greater is $0, which amount is equal to or greater than the amount which the property transferred would commend at a fair voluntary sale. _______________________________________ AFFIANT Sworn to and subscribed before me this the ___ day of _____________________, 2020. ____________________________________________ NOTARY PUBLIC My Commission Expires:_______________________ This conveyance by the City of Clarksville was authorized by the Clarksville City Council at its regular meeting on _______________, ___ 2020.  RESOLUTION 73-2019-20 A RESOLUTION AUTHORIZING AN INTERLOCAL AGREEMENT BETWEEN THE CITY OF CLARKSVILLE AND THE WOODLAWN UTILITY DISTRICT FOR WATER SERVICES WHEREAS, the City of Clarksville provides water service to customers through its’ Department of Gas & Water (CGW); and WHEREAS, the Woodlawn Utility District (hereafter “WUD”) is a utility district that provides water services to its customers; and WHEREAS, in September of 2007, the City, through CGW, and WUD (together the “Parties”) entered into a contract, under which WUD would supply water for Liberty Park Subdivision to CGW through a master meter and CGW would subsequently provide water service to customers within the subdivision; and WHEREAS, after the expiration of the aforementioned contract, the Parties maintained the same arrangement for water service for Liberty Park Subdivision; and WHEREAS, ​CGW is also currently providing water service to customers along a portion of Dotsonville Road; and WHEREAS, the aforementioned Liberty Park Subdivision and said portion along Dotsonville Road lie within the service area of WUD; and WHEREAS, it has been deemed no longer fiscally responsible and/or efficient for CGW to continue to provide water service to customers within the Liberty Park Subdivision and along a portion of Dotsonville Road; and WHEREAS, the Parties desire that WUD provide water service to customers within the Liberty Park Subdivision and along a portion of Dotsonville Road, by means of CGW transferring ownership of the infrastructure beyond the master water meter at Liberty Park Subdivision to WUD and replacing all of the associated CGW water meters within the Liberty Park Subdivision and along a portion of Dotsonville Road with WUD water meters, pursuant to the terms and provisions set forth in an agreement between the Parties (Transfer Of Water Service Contract) attached hereto and incorporated herein as Attachment A; and WHEREAS, the Parties now desire to memorialize said agreement through approval / adoption and execution of said contract / interlocal agreement, attached hereto and incorporated herein as Attachment A, pursuant to Tennessee Code Annotated Section 12-9-108 pertaining to the adoption of interlocal agreements among governmental entities, and pursuant to all applicable federal, state, and local laws, to include City ordinances and resolutions, and such applicable regulations. NOW, THEREFORE, BE IT RESOLVED BY THE CITY COUNCIL OF THE CITY OF CLARKSVILLE, TENNESSEE: That the Clarksville City Council hereby authorizes and approves a contract / interlocal agreement, pertaining to transferring, from CGW to WUD, the provision of water service to customers within the Liberty Park Subdivision and along a portion of Dotsonville Road, pursuant to and under the terms and provisions set forth in the agreement between the parties (Transfer Of Water Service Contract) attached hereto and incorporated herein as Attachment A, said contract / interlocal agreement to be effective and binding upon execution by the Mayor and the appropriate representative with authority to bind WUD. ADOPTED:  RESOLUTION 74-2019-20 A RESOLUTION AUTHORIZING AN INTERLOCAL AGREEMENT BETWEEN THE CITY OF CLARKSVILLE AND THE WOODLAWN UTILITY DISTRICT FOR SANITARY SEWERAGE SERVICES WHEREAS, the City of Clarksville provides sanitary sewerage service to customers through its’ Department of Gas & Water (CGW); and WHEREAS, the Woodlawn Utility District (hereafter “WUD”) is a utility district that provides water services to its customers; and WHEREAS, the City, through its’ CGW, and WUD (together the “Parties”) desire that CGW provide sanitary sewerage service within the District’s boundaries in Montgomery County, Tennessee, pursuant to the terms and provisions set forth in an agreement between the Parties (Interlocal Agreement For Sanitary Sewerage Service Billing And Collections), attached hereto and incorporated herein as Attachment A; and WHEREAS, the Parties now desire to memorialize said agreement through approval / adoption and execution of said contract / interlocal agreement, attached hereto and incorporated herein as Attachment A, pursuant to Tennessee Code Annotated Section 12-9-108 pertaining to the adoption of interlocal agreements among governmental entities, and pursuant to all applicable federal, state, and local laws, to include City ordinances and resolutions, and such applicable regulations. NOW, THEREFORE, BE IT RESOLVED BY THE CITY COUNCIL OF THE CITY OF CLARKSVILLE, TENNESSEE: That the Clarksville City Council hereby authorizes and approves a contract / interlocal agreement, pertaining to the provision of sanitary sewerage service within the Woodlawn Utility District’s boundaries in Montgomery County, Tennessee, pursuant to and under the terms and provisions set forth in the agreement between the parties (Interlocal Agreement For Sanitary Sewerage Service Billing And Collections) attached hereto and incorporated herein as Attachment A, said contract / interlocal agreement to be effective and binding upon execution by the Mayor and the appropriate representative with authority to bind WUD. ADOPTED: