Finance Committee

FINANCE COMMITTEE FEBRUARY 25, 2020 AGENDA TIME: 3:30 p.m. LOCATION: City Hall Conference Room 1) CALL TO ORDER 2) ATTENDANCE 3) ADOPTION OF MINUTES: January 28 4) DEPARTMENT REPORTS 1. PURCHASING ​Camille Thomas a) Report of bids b) Report of award of professional service contracts ● Design of an additional parking lot at Fort Defiance from Moore Engineering in the amount of $7,500.00. ● Demolition plans and oversight for the partial demolition of the Frosty Morn building from K & S Engineering in an amount not to exceed $9,500.00. c) Report of sale of surplus property on ​GovDeals.com ​January: $​36,164.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 payment of legal expenditures ​Lance Baker ● Burr & Forman, ​TN Riverkeepers v. City​ - $19,881.72 ● Bradley Arant, ​Jeff Robinson v. City​ - $15,360.01 ● Bradley Arant, ​Employment Matters​ - $2,047.50 ● Bradley Arant, ​Kimberly Black v. City​ - $4,700.41 5) COMMITTEE ACTION None. 6) CITY COUNCIL ACTION None. 7) PUBLIC COMMENTS ​ (3 individuals allowed; 5 minutes each) 8) ADJOURNMENT  FINANCE COMMITTEE JANUARY 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, January 28, 2020, at 3:30 p.m. in the City Hall Conference Room, 1 Public Square, Clarksville, Tennessee. ATTENDANCE PRESENT: Jeff Burkhart, Tim Chandler, Valerie Guzman, Jeff Henley, Stacey Streetman ADOPTION OF MINUTES Councilman Henley made a motion to adopt the December 23, 2019 minutes as presented. The motion was seconded by Councillady Guzman. A voice vote was taken; the motion passed without objection. PURCHASING DEPARTMENT Director of Purchasing Camille Thomas presented the monthly bid summary and noted vendor interest had increased since bids were now being posted on a national data base. Ms. Thomas reported award of the following professional service contracts: ● Recreation - Chlorine and Air Sampling Testing at the New Providence Pool from GHP Environmental and Architecture in the amount of $2,970.00. ● Recreation/Project Management - Boundary & Topographic Survey of 1004 Franklin Street from McKay-Burchett & Co. in an amount not to exceed $1,500.00. ● Recreation/Project Management - Design Services for the Improvements at Pettus Park from Moore Engineering in the amount of $25,000.00. ● Street Department - Design Services for the 4th Street and College Street Signal from KCI Technologies, LLC in the amount of $14,675.00.  ● Street Department - Design Services for a New Retaining Wall for the Riverview Cemetery from K & S Engineering in the amount of $1,500.00. ● Street Department - Intersection Improvements at Ted Crozier Blvd./Dunlop Lane, Allen Rd./Tiny Town Rd. and Glendale Dr./Ashland City Rd. from Civil-Site Clarksville, PLLC in the amount of $79,750.00. ● Gas &Water - Fee Increase for Additional Flow Monitoring Services from ADS Environmental Services (1st Contract Renewal) in the amount of $58,200.00. ● Gas &Water - Tower Climber Training from Honeywell/Miller Training in the amount of $7,969.50. ● Project Management - Boundary & Topographic Survey of the Frost Morn Property from McKay-Burchett & Co. in an amount not to exceed $6,500.00. Ms. Thomas also reported sales of surplus property on ​GovDeals.com ​during December 2019 in the amount of $​38,896.00. GENERAL FUND REPORT Chief Financial Officer Laurie Matta said revenues had exceeded expenditures by $769,000 during the first six months of FY20, $9.1 million more than the previous year. She said revenue collections were 3% ahead of projections with 48% of budgeted revenues already collected, including $17.4 million in property taxes. Local Option Sales Tax collections were 1.8% more than the previous year with a total of $5.9 million; $ 1.4 million for the General Fund, $72,000 for the Road Fund, and $7.4 million for schools. Ms. Matta said $2.7 million of $30.2 million invested had been spent on capital projects during the current fiscal year. The audited beginning FY20 Fund Balance was $28.2 million or 27% of expenditures. There was no grant activity during December. Ms. Matta said she would research smaller investment options because the LGIP rate had increased. Mayor Pitts said the General Fund audit was completed on time and with no findings. DEPARTMENT OF ELECTRICITY REPORT CDE Chief Financial Officer David Johns said repairs to the electrical plant following the November storms totaled $3 million for which the department would be requesting reimbursement from FEMA. The Electric Division had earned $6.4 million through December and the Broadband cash balance had reached $5.8 million with a net income of $433,000. Christy Batts said Broadband was selling more services to existing customers. CITY ATTORNEY REPORT City Attorney Lance Baker reported payment of the following legal expenditures: ● Bradley Arant, ​Kimberly Black v. City​ - $4,633.00 ● Bass Berry & Sims,​ Environmental Matters​ - 180.97 Mr. Baker noted the Tennessee River Keepers showed no interest in settling prior to their filing of a lawsuit against the City. COMMITTEE ACTION No committee action was required. RESIDENTIAL PLUMBING FEE ORDINANCE 54-2019-20 ​(First Reading) Amending the Official Code relative to residential new construction plumbing permit fee Building & Codes Interim Director David Smith said this proposed change would streamline payments for new residential construction by creating a flat fee. The recommendation of the Public Safety Committee was for approval. Councilman Henley made a motion to forward this ordinance to the City Council with a recommendation of approval. The motion was seconded by Councilman Chandler. A voice vote was taken; the motion passed without objection. EAST MONTGOMERY UTILITY DISTRICT RESOLUTION 41-2019-20 ​Authorizing an interlocal agreement with East Montgomery Utility District for sanitary sewerage services Gas & Water General Manager Marks Riggins said this agreement would allow developers to extend gravity sewer into the utility district service area. The recommendation of the Gas & Water Committee was for approval. 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. A voice vote was taken; the motion passed without objection. TODD COUNTY FISCAL COURT AGREEMENT RESOLUTION 42-2019-20 ​Authorizing an interlocal agreement with Todd County Fiscal Court for natural gas infrastructure Mr. Riggins said the City will have four representatives (Councillady ​Valerie Guzman, Suzanne Langford, Troy Jones, and Mark Riggins) ​on this board and noted that Todd County will own the gas lines and the City of Clarksville will be the end customer. The recommendation of the Gas & Water Committee was for approval. Councillady Guzman made a motion to forward this resolution to the City Council with a recommendation of approval. The motion was seconded by Councilman Chandler. A voice vote was taken; the motion passed without objection. POLICE DISTRICT 3 PRECINCT ORDINANCE 55-2019-20 ​(First Reading) Accepting donation of property from the Industrial Development Board and Montgomery County Commission for Police District 3 Project Manager David Smith said the IDB had agreed to donate .13 acres of land in the Industrial Park needed to build Police District 3 next to Fire Station 12. The recommendation of the Public Safety Committee was for approval. Councilman Henley made a motion to forward this ordinance to the City Council  with a recommendation of approval. The motion was seconded by Councilman Chandler. A voice vote was taken; the motion passed without objection. K-9 DONATION RESOLUTION 39-2019-20 ​Authorizing retirement of Patrol Service Dog Leonidas from the K-9 Unit and further authorizing donation of same to Police Officer Gary Mefford Police Chief Al Ansley said this service dog had been part of the K-9 Unit for nine years and had suffered a severe spinal injury. The recommendation of the Public Safety Committee was for approval. 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. A voice vote was taken; the motion passed without objection. POLICE-APSU AGREEMENT RESOLUTION 40-2019-20 Authorizing a Mutual Aid Agreement with Austin Peay State University for police services Chief Ansley said this agreement would give the university police access to the CPD radio frequency at no cost to the City. The recommendation of the Public Safety Committee was for approval. 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. A voice vote was taken; the motion passed without objection. OPEN ROADS POLICY RESOLUTION 43-2019-20 ​Authorizing an Interlocal Agreement with the Tennessee Department of Safety and Homeland Security Chief Ansley said this resolution would renew the 2015 agreement to clear and keep state roadways open after a vehicle crash. 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. A voice vote was taken; the motion passed without objection. PUBLIC COMMENTS There were no public comments. ADJOURNMENT The meeting was adjourned at 4:08 p.m.  CITY GENERAL BID SUMMARY FEBRUARY 25, 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 4000 PM Heritage Park Safe Route To Schools Adams Contracting $ 292,937.00 4005 G&W Kraft Street Sewer Rehab Granite Inliner $ 357,420.00 4006 G&W WWTP Primary Treatment Building HVAC Replacement Triple S Contracting $ 281,570.00 4008 G&W Ringgold Rd. Sewer Rehab Granite Inliner $ 383,311.92 4014-P G&W Utility Rate Study/General Facilities Charges Update Raftelis $ 48,500.00 4015 CDE Hardware Upgrades Zcorum $ 335,866.45 4019 Recreation Concession Services for the Heritage Park Complex C&T Concessions $ 1,550.00 /mth SOLE SOURCE PURCHASES: 1. G&W. - Future purchases of Performance Pipe/Disco 8100 Series pipe from Consolidated Pipe. 3. G&W – Future purchases of HC-100 Handheld Controllers from E.H. Wachs. 4. G&W – Future purchases and services of MR Systems products from MR Systems, Inc. 5. G&W – Future purchases and services of cellular gateway & spread spectrum radios from Microhard Systems. 6. G&W- Future purchases and services of Microfiltration System equipment from Pall Corporation. 7. G&W – Future purchases of Watson Marlow and Bredel pumps from Eco-Tech, Inc. 8. G&W – Future purchases of Belgas regulators from Tri-State Meter. 9. G&W – Future purchases of Root rotary meters from Tri-State Meter. 10. CDE – Future purchases and services of Adaptive Wi-Fi Cloud from Plume. 11. CDE – Future purchases of Plume PODs from Plume. 12. Police Dept. – Future purchases of complex DNA testing from Cybergenetics. 13. Police Dept. – Future purchases of Stop Stick tire deflation devices from Stop Stick. Ltd. PROPRIETARY PURCHASE: 1. G&W. – Future manhole utility work for TDOT resurfacing projects from CK Masonry Co. STATE CONTRACT PURCHASES: 1. G&W – Two 2020 Ford F150 trucks from Lonnie Cobb Ford in the amount of $ 53,320.00. 2. I.T. – VMware software form CDW-Government in the amount of $ 5,162.24. Bid # 4000– PM –Heritage Park Safe Route to Schools: Adams Contracting $ 292.937.00* Sessions Paving $ 320,712.40 CD Steger $ 321.248.40 Pride Concrete $ 336,263.53 Local AGG Concrete No Response Beech Construction No Response Carver Construction No Response Colditz Trucking No Response Fulgham MacIndoe & Associates No Response Jarrett Builder No Response Local Leland Inc. No Response Precision Concrete Cutting No Response PRI of East TN No Response Queen City Asphalt No Response Local RAWSO Constructors No Response Reed Construction No Response S&W Contracting No Response Local Two Rivers Roofing No Response Bell & Associates Construction No Response Byard Construction No Response Local Crowder Construction No Response Gibbs Brothers Construction No Response Hall Construction No Response Local Jones Brothers Contractors No Response Local Maynard Construction No Response Local Pavement Restoration No Response Pinnacle Construction Partners No Response RG Anderson No Response REJ Construction No Response Rogers Group No Response The Gravel Co. No Response Pride Construction Solution No Response V-Barr Group No Response Bid # 4005– G&W – Kraft Street Sewer Rehab: Granite Inliner $ 357,420.00* Insituform $ 422,200.00 SAK Construction $ 514,662.00 Gulf Coast Underground No Bid Beech Construction No Response Carver Construction Co No Response Colditz Trucking No Response Crowder Construction No Response Curl Construction & Excavating No Response Elitte Septic Tank & Grease Trap No Response Fulghum MacIndoe & Associates No Response Gregory Construction No Response ITS Maintenance No Response Jarrett Builders No Response Local Jones Brothers Contracting No Response Local Leland Inc. No Response McCall’s Contracting No Response Local Northstar Environmental Group No Response PRI of East TN No Response R Roese Contracting No Response RAWSO Construction No Response Reed Construction No Response S&W Contracting No Response Thalle Construction Co. No Response Two Rivers Roofing No Response Byard Construction No Response Local Civil Constructors No Response Elk Mountain Construction No Response Franklin Construction No Response J&H Construction of Cookeville No Response J&S Construction No Response Mike Smith Dump Service No Response Moore Construction Co. No Response Local Parchaman Construction No Response Local REJ Construction No Response Tennessee Concrete Construction No Response Bid # 4006– G&W– WWTP Primary Treatment Building HVAC Replacement: Triple S Contracting $ 281,571.00* Local Main Stream Heating & Cooling $ 305,660.00 Local Action Air No Response Local Anderson Lumber Co. No Response Archer Air Conditioning Service No Response ATECH Inc. No Response Local Autumn Comfort Heating & Cooling No Response Local Bernhard Energy Solutions No Response Brymak & Associates No Response Durcap Asphalt Paving Co. No Response EDI No Response Freeman Mechanical No Response Local Hathaway Demo Construction No Response John Bouchard & Sons No Response Knight Electric No Response Local Leland No Response Maynard Select No Response Modern Heating Cooling Roofing No Response Local Morton Mechanical No Response Local Premiere Building Maintenance No Response S&W Contracting No Response Smithfield Construction No Response Southeast Contractors No Response Two Rivers Roofing No Response Air Conditioning Service No Response Bentley’s Air Conditioning No Response Charles Stone Heating & Cooling No Response C-Tech Controls No Response Hall Construction No Response Local Kings Air Conditioning & Heating No Response Liberty Heating & Cooling No Response Music City Mechanical No Response Siemens Industry No Response Trane No Response Local Xenergy No Response Bid # 4008– G&W – Ringgold Rd. Sewer Rehab: Granite Inliner $ 383,311.92* Insituform $ 738,325.50 SAK Construction $ 697,980.00 IPR Southeast $ 1,186,270.00 Gulf Coast Underground No Bid Beech Construction No Response Carver Construction Co No Response Colditz Trucking No Response Crowder Construction No Response Curl Construction & Excavating No Response Elitte Septic Tank & Grease Trap No Response Fulghum MacIndoe & Associates No Response Gregory Construction No Response ITS Maintenance No Response Jarrett Builders No Response Local Jones Brothers Contracting No Response Local Leland Inc. No Response McCall’s Contracting No Response Local Northstar Environmental Group No Response PRI of East TN No Response R Roese Contracting No Response RAWSO Construction No Response Reed Construction No Response S&W Contracting No Response Thalle Construction Co. No Response Two Rivers Roofing No Response Byard Construction No Response Local Civil Constructors No Response Elk Mountain Construction No Response Franklin Construction No Response J&H Construction of Cookeville No Response J&S Construction No Response Mike Smith Dump Service No Response Moore Construction Co. No Response Local Parchaman Construction No Response Local REJ Construction No Response Tennessee Concrete Construction No Response Proposal # 4014-P– G&W – Utility Rate Study/General Facilities Charges Update: Raftelis $ 48,500.00 ** The Tenergy Corp No Response Black & Veatch No Response Pendulum Energy No Response Willis Graves & Associates No Response PHG Energy No Response Power of Clean Energy No Response Allen Sign Company No Response BDB Co. No Response Blue Cypress Consulting No Response Brett Design/Build No Response Designsensory No Response Engage Collaborative Management No Response Environmental Leverage No Response Frost Environmental Services No Response Fulgham MacIndoe & Associates No Response PSD Software No Response Quantum Environmental & Engineering No Response Raymond James & Associates No Response Reed Construction No Response Vexus International No Response Xperience Technical Group No Response *This was a proposal where price was not the only factor in award. ** Not to exceed. Bid # 4015– CDE– Hardware Upgrades: Zcorum $ 335.866.45* Layer 3 Communication $ 354,344.50 enfoPoint Solutions $ 356,987.56 MCA Technology Solutions $ 373,305.00 Bid # 4019– Recreation – Concession Services for Heritage Par Complex: C&T Concession $ 1,550.00** Benny Cushman No Response Local KAC Concession No Response Local Conditt Enterprise No Response Bobby Smith No Response Local Snack Shack No Response Local Top Self Concessions No Response Allen Sign Co. No Response Local Ms. Pete’s Café & Catering No Response Local Reed Construction No Response The Choppin Block No Response Local Beyond Details No Response Black Eyed Pea Restaurant & Catering No Response Blue Coast Burrito No Response C&G Fine Foods No Response Carolyn & Glenn Catering No Response Catering Events by Suzette No Response Catering Concepts by Timothy No Response Epic Hospitality Group No Response Food Sales East No Response J&J Concession No Response Jessica’s Cupcakes No Response LA Hacienda Mexican Restaurant No Response Local Menu Makers Catering No Response Ray’s BBQ & Catering No Response Roscoe’s Smoked Bar B Que No Response Sydnor Boys BBQ No Response Sysco Nashville No Response Tasty Dog Vending & Catering No Response The Livery Stable No Response The Open Door No Response The Very Idea No Response Tircor Nashville No Response Universal Contract No Response VCE No Response White House Foodland No Response ** Paid to The City monthly. Department Recommendation Department of Finance & Revenue January 2020 Financial Review Fiscal Year 2020 Clarksville, Tennessee January 31, 2020  General Fund Revenues vs. Expenditures Fiscal Year 2020 As of January 31, 2019 FY 2020 Monthly FY 2020 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,424 8,818,714 (3,759,290) November 7,710,416 6,798,578 911,838 December 18,909,185 6,760,944 12,148,240 January 7,924,680 9,198,711 (1,274,031) February - March - April - May - June - YTD Total $ 55,181,929 $ 55,742,118 $ (560,189) $20,000,000 $18,000,000 $16,000,000 $14,000,000 $12,000,000 $10,000,000 FY 2020 Revenues $8,000,000 FY 2020 Expenditures $6,000,000 $4,000,000 $2,000,000 $-  General Fund Revenue Comparison Fiscal Year 2020 As of January 31, 2019 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,424 $ 4,797,738 261,686 November 7,710,416 $ 7,399,053 311,362 December 18,909,185 $ 10,970,345 7,938,839 January 7,924,680 $ 17,899,039 (9,974,359) February - - March - - April - - May - - June - - YTD Total $ 55,181,929 $ 56,054,101 $ (872,172) $63,000,000 $53,000,000 $43,000,000 $33,000,000 FY2019 YTD Revenue FY2020 YTD Revenue $23,000,000 FY2020 YTD Budgeted Revenue $13,000,000 $3,000,000  GENERAL FUND REVENUES Fiscal Year 2020 As of January 31, 2020 Total Budget YTD Month TAXES Prior Year Property Taxes 1,020,975 790,772 36,692 2019 Property Taxes 32,000,000 19,081,822 2,483,998 PiLOTS 105,140 90,175 764 Local Option Sales Tax 20,492,455 10,526,370 1,572,114 Beer & Liquor Tax 4,291,557 2,596,662 420,270 Business License 2,648,841 560,513 109,023 Franchise Tax (cable) 1,501,048 335,337 46,113 Hote/Motel 425,000 278,346 35,164 Other Taxes 482,100 170,471 16,734 TOTAL TAXES 62,967,116 34,430,469 4,720,873 LICENSES AND PERMITS Building Permits 1,925,000 1,455,092 178,916 Other Permits 132,269 59,930 8,180 TOTAL PERMITS 2,057,269 1,515,022 187,096 INTERGOVERNMENTAL Grant reimbursements 295,888 10,078 - State Shared Revenues TVA Replacement Tax 1,552,000 817,498 408,749 State Sales Tax 11,712,375 7,046,704 1,013,296 State Street Aid 5,339,000 3,077,796 430,487 Other Taxes 2,161,008 982,235 86,065 TOTAL INTERGOVERNMENTAL 21,060,271 11,934,311 1,938,596 OTHER REVENUES Charges for Services 933,050 406,598 54,727 Recreation 634,155 280,726 38,828 Golf Courses 645,975 305,581 13,047 Fines and Forefeitures 582,056 308,777 37,505 Investment & Interest Earnings 351,500 228,517 33,705 Other Misc. Revenues 288,362 730,320 176,769 Transfer from CDE 4,800,000 2,714,879 392,432 Transfer From CGW 3,954,295 2,102,264 329,525 Other Transfers 443,025 224,464 1,577 TOTAL OTHER REVENUES 12,632,418 7,302,127 1,078,114 TOTAL REVENUES GENERAL FUND 98,717,074 55,181,929 7,924,680  General Fund Expenditure Comparison Fiscal Year 2020 As of January 31, 2019 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,198,711 $ 7,912,332 1,286,380 February - - March - - April - - May - - June - - YTD Total $ 55,742,118 $ 50,072,221 $ 5,669,897 $62,000,000 $52,000,000 $42,000,000 FY2019 YTD Expenditures $32,000,000 FY2020 YTD Expenditures $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 January 31, 2019 $30,000,000 Expenditures Estimated Variance FY 2019 YTD YTD Budget (Over)Under $25,000,000 Departmental: $20,000,000 Police $ 17,791,978 $ 18,344,841 $ 552,863 $15,000,000 FY 2020 Actual Fire 10,593,017 11,080,335 487,318 YTD Highway & Street 8,779,956 8,504,052 (275,905) $10,000,000 Parks & Rec. & Golf 4,583,540 5,619,203 1,035,663 $5,000,000 Building & Codes 1,155,645 1,276,569 120,924 FY2020 Total $0 Info. Technology 1,164,748 1,082,436 (82,312) Budget Finance 1,000,702 1,057,622 56,920 City Garage 664,250 765,351 101,101 Municipal Properties 322,930 427,622 104,691 Human Resources 531,085 641,042 109,957 Legislative / Admin. 459,919 445,798 (14,121) Mayor's Office 376,217 390,724 14,507 City Court 266,039 265,228 (811) $1,100,000 Legal 272,174 275,228 3,055 $1,000,000 $900,000 Internal Audit 217,247 253,585 36,337 $800,000 Purchasing 126,027 130,429 4,402 $700,000 Departmental Total 48,305,475 50,560,064 2,254,589 $600,000 $500,000 FY 2020 $400,000 Actual YTD Nondepartmental: $300,000 Debt 3,582,886 5,667,618 2,084,732 $200,000 FY2020 Total Transit 1,368,844 1,449,532 80,688 $100,000 Budget $0 Retirees 359,614 916,466 556,852 Other 2,125,298 2,351,551 226,253 YTD Total $ 55,742,118 $ 60,945,232 $ 5,203,114  Schedule of Sales Tax Collections Fiscal Year 2020 As of January 31, 2019 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 March April May June YTD Total $ 9,298,469 $ 9,841,350 $ 10,786,331 $ 11,042,774 City of Clarksville $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 January 31, 2019 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 - March - April - May - June - YTD TOTAL $ 46,059,784 $ 695,599 $ 10,526,370 $ 516,404 $ 34,321,411 $ 4,801,515 $ 41,782,337 $ 524,068 Monthly Distribution 1.64% 22.19% 1.09% COUNTY CITY 75.08% CITY ROADS SCHOOLS  Capital Project Status Report Fiscal Year 2020 As of January 31, 2019 TOTAL ACTIVE ACTIVE PROJECTS FY EXPENSES PROJECT TOTAL FUNDING PROJECT FY2019-2020 7/1/19-1/31/19 BALANCE EXPENSES ** STREET DEPARTMENT: 93101 Rossview/Dunbar Cave/Cardinal Improvements 13,280,000 173,527 2,692,064 10,587,936 14301 Edmondson Ferry/1A Bypass Interesection Improvement 1,967,029 9,640 1,150,002 817,027 15306 Northeast Connector 16,808,700 318,521 1,194,562 15,614,138 17301 International & Dunlop Intersection Improvement 2,807,831 319,291 442,043 2,365,788 17304 Adaptaive Signal Control Project (Wilma) 1,200,000 0 0 1,200,000 17305 Tylertown & Oakland Intersection Improvement 10,000,000 188,163 761,371 9,238,629 17307 Tylertown & Trenton Drainage Overflow Project 1,040,185 5,494 73,747 966,438 18301 Drainage Mitigation FY2018 280,801 0 106,642 174,159 18302 New Sidewalks FY2018 934,954 44,257 115,797 819,157 19301 Lilac Lane 100,000 0 1,600 98,400 19302 Whitfield Road Improvements 3,350,000 241,489 449,818 2,900,182 19303 Spot Intersection Improvements 1,500,000 35,702 41,902 1,458,098 20301 Dunbar Cave Road Bridge 600,000 0 0 600,000 20302 4th Street and College Signal 400,000 0 0 400,000 20303 New Sidewalks FY20-24 900,000 275,255 275,255 624,745 20304 Drainage Mitigation FY20-24 450,000 0 0 450,000 20305 Cemetary Retaining Wall 330,000 0 0 330,000 $ 55,949,500 $ 1,611,342 $ 7,304,803 $ 48,644,697 PARKS & RECREATION: 16503 Athlectic Complex 5,650,000 53,601 4,525,361 1,124,639 16504 Red River East Trail Project 2,146,832 823,644 2,075,447 71,385 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 120,000 0 119,866 134 17505 Liberty Park/Marina Remediation 905,218 24,556 85,080 820,138 17506 Swan Lake Renovations 1,046,605 223 1,039,218 7,387 19502 Pollard Road Additional Parking 304,199 34,244 42,244 261,955 19503 Billy Dunlop Pavillion & Restroom 382,485 97,134 99,134 283,351 19504 Heritage Park Improvements 1,000,000 283,148 501,016 498,984 19505 Regional Community Center 500,000 0 0 500,000 20501 Red River Pedestrian Bridge 3,068,233 0 0 3,068,233 20502 Mason Rudolph Cart Path Paving 125,000 0 0 125,000 20503 Swan Lake Cart Path Paving 190,800 32,400 32,400 158,400 $ 15,951,172 $ 1,363,950 $ 8,692,131 $ 7,259,041 FIRE DEPARTMENT: 16221 Fire Maintenance Facility 314,352 12,000 13,300 301,052 20221 Renovation of Station 10 125,000 0 0 125,000 20222 Custom Engine (replaces 1999 model) 450,000 0 0 450,000 $ 889,352 $ 12,000 $ 13,300 $ 876,052 POLICE DEPARTMENT: 19211 District 3 Precinct Building 3,500,000 176,550 176,550 3,323,450 $ 3,500,000 $ 176,550 $ 176,550 $ 3,323,450 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 906,017 40,950 169,830 736,187 16103 2015 Multimodal Access Grant 915,758 100,939 222,043 693,715 19101 New Council Chambers 0 0 0 0 19102 Structural Repairs - Cumberland Garage 1,099,036 0 0 1,099,036 $ 18,903,595 $ 144,889 $ 14,664,480 $ 4,239,115 debt issuance costs Total Spent YTD: Major Projects $ 95,193,619 $ 3,308,730 $ 30,851,264 $ 64,342,355 * 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 January 31, 2019 Estimated Estimated Ending Beginning Fund Revenues Expenditures Fund Fund Balance Balance YTD YTD 1/31/20 7/01/19 General Fund: $ 29,943,642 $ 52,681,929 $ 55,742,118 $ 26,883,453 Capital Projects Fund: 2,556,107 1,704,975 3,308,730 952,352 Debt Service Fund: 474,377 3,950,970 3,941,238 484,109 Internal Service Funds: 6,300,385 5,566,018 9,591,078 2,275,325 Non-Major Governmental Funds: Drug Fund 502,153 293,839 53,751 742,242 Road Improvement Fund 1,094,794 516,404 0 1,611,198 Police Special Fund 191,193 283,741 496,221 (21,288) Parks Special Fund 362,757 252,028 297,271 317,513 Other Special Revenue Fund* 840,479 295,214 360,091 775,601 Community Development 460,231 1,147,534 1,310,062 297,703 Capital Projects Revenue District Fund 78,179 2,500,000 382,629 2,195,549 * Includes: Fire Spec. Rev., Traffic Camera Police & Parks, SRF  Notice of Grant Applications Fiscal Year 2020 As of January 31, 2019 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 connection 10/03/18 Awarded Alternative Program Transportion $1,818,233 $674,689 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 to 12/06/18 $56,840 $2,841 Not funded & Safety Grant Security (FEMA) 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 Submitted 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 08/23/19 2019 JAG Grant US Dept of Justice $59,459 $0 Awarded share to purchase a 3D laser scanner to analyze crime scenes. The 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 $125,000 2020 Childhood Mayoers/American and $25,000 for 1st and 2nd places, respectively. Low income youth can 08/30/19 $120,000 $0 Not funded Obesity Prevention Beverage compete for scholarships to any of the City's athletic leagues by submitting an Foundation application and essay. Transportation TN Dept of Funding to construct new sidewalks to benefit Clarksville High School, 10/03/19 $493,176 $123,294 Submitted Alternative Program Transportion Richview Middle School and Pisgah Elementary School.  Notice of Grant Applications Fiscal Year 2020 As of January 31, 2019 Date Funding Funds Match Submitted Project Title Agency Requested Required Status Notes TAEP Farmers TN Dept of 11/25/19 $750 $0 Submitted Funding to advertise and promote the downtown market. Market Promotion Agriculture  Investment Report Fiscal Year 2020 As of January 31, 2019 ISSUER NAME PAR VALUE CUSIP COUPON RATE LOCAL GOVERNMENT INVESTMENT POOL SELF-INSURANCE $ 589,697 1.690 CAPITAL PROJECTS FUNDS 1,799,706 1.690 INVESTMENT ACCOUNT 23,435,257 1.690 2016 BOND ISSUANCE 1,269,946 1.690 1.690 LGIP TOTAL / AVERAGE $ 27,094,606 1.690 2016 BOND ISSUANCE CAPITAL PROJECTS FUNDS SELF-INSURANCE INVESTMENT ACCOUNT  CDE Lightband Rolling 4 month Balance Sheet - Broadband Division January 31, 2020 1/31/19 % Change 1/31/20 12/31/19 11/30/19 10/31/19 Assets Current Assets: Cash -Operating Account $ 5,675,212.13 8.95% $ 6,182,946.05 $ 5,782,103.72 $ 5,349,809.45 $ 4,777,111.30 Accounts Receivable: Subscribers, less allowance 1,434,276.31 1.59% 1,457,037.97 1,457,895.08 1,564,329.62 1,526,832.05 Other 54,510.44 -46.91% 28,940.80 31,626.26 33,491.64 39,361.94 Temporary advances - Electric 1,890,403.22 9.81% 2,075,870.24 2,111,484.45 1,922,993.89 2,036,753.81 Inventory 294,919.75 86.61% 550,340.11 359,898.95 357,999.18 368,714.01 Total Current Assets $ 9,349,321.85 10.12% $ 10,295,135.17 $ 9,743,008.46 $ 9,228,623.78 $ 8,748,773.11 Noncurrent Assets: Construction Work In Progress $ 287,587.49 -86.33% $ 39,319.54 $ 35,325.52 $ 47,140.12 $ 53,995.46 Telecommunications Plant 8,157,140.56 4.42% 8,517,887.25 8,528,124.09 8,330,510.51 8,352,476.84 Accumulated Depreciation (5,528,490.88) -0.13% (5,521,341.28) (5,483,574.14) (5,438,505.75) (5,434,505.37) Deferred Debit - Software & Outflows of Resources 248,871.95 84.58% 459,361.48 475,674.15 518,065.15 573,896.61 Total Noncurrent Assets $ 3,165,109.12 10.43% $ 3,495,226.99 $ 3,555,549.62 $ 3,457,210.03 $ 3,545,863.54 Total Assets $ 12,514,430.97 10.20% $ 13,790,362.16 $ 13,298,558.08 $ 12,685,833.81 $ 12,294,636.65 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 1,780,300.70 31.18% 2,335,433.99 1,901,478.98 1,513,391.29 1,089,570.29 Retained Earnings - Current 378,612.36 -28.96% 268,974.40 433,955.01 388,087.69 423,821.00 Total Retained Earnings (Deficit) $ (852,586.42) -499.75% $ 3,408,245.32 $ 3,139,270.92 $ 2,705,315.91 $ 2,317,228.22 Current Liabilities: Accounts Payable $ 1,859,156.74 24.52% $ 2,315,093.95 $ 2,121,870.47 $ 1,972,333.14 $ 1,997,353.59 Unearned Revenue $ 609,040.12 12.06% $ 682,497.65 $ 682,497.65 $ 682,497.65 $ 682,497.65 Other Accrued Payables 259,097.84 10.00% 285,018.50 254,664.91 224,253.79 195,582.92 Total Current Liabilities $ 2,727,294.70 20.36% $ 3,282,610.10 $ 3,059,033.03 $ 2,879,084.58 $ 2,875,434.16 Noncurrent Liabilities: Customer Deposits $ 2,944.42 -56.27% $ 1,287.48 $ 1,337.48 $ 1,712.48 $ 1,556.04 Postretirement Benefits 332,853.14 4.45% 347,674.13 348,371.52 349,175.71 349,873.10 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 -35.45% 6,645,931.13 6,645,931.13 6,645,931.13 6,645,931.13 Total Noncurrent Liabilities $ 10,639,722.69 -33.27% $ 7,099,506.74 $ 7,100,254.13 $ 7,101,433.32 $ 7,101,974.27 Total Liabilities $ 13,367,017.39 -22.33% $ 10,382,116.84 $ 10,159,287.16 $ 9,980,517.90 $ 9,977,408.43 Total Liabilities & Retained Earnings $ 12,514,430.97 10.20% $ 13,790,362.16 $ 13,298,558.08 $ 12,685,833.81 $ 12,294,636.65  CDE Lightband Income Statement - Broadband Division 1/31/2020 % 1/31/19 Change 1/31/20 12/31/19 11/30/19 10/31/19 Operating Revenue: Programming Revenue $ 442,767.51 1.66% $ 450,116.78 $ 420,910.58 $ 416,042.03 $ 415,438.17 Internet Revenue 1,142,183.01 9.99% 1,256,338.36 1,246,310.72 1,239,727.41 1,241,498.87 Telephone Revenue 144,770.22 -0.76% 143,662.93 149,107.17 148,439.97 145,469.66 Miscellaneous Fee Revenue 146,735.24 -5.41% 138,794.88 165,298.91 134,359.00 153,641.20 Total Operating Revenues 1,876,455.98 5.99% 1,988,912.95 1,981,627.38 1,938,568.41 1,956,047.90 Cost of Programming & Services 719,388.49 4.44% 751,303.36 694,224.24 699,421.65 694,974.02 Gross Revenue: $ 1,157,067.49 6.96% $ 1,237,609.59 $ 1,287,403.14 $ 1,239,146.76 $ 1,261,073.88 Operating Expenses: Network Support Expense-Video $ 35,207.63 8.86% $ 38,326.29 $ 33,675.63 $ 36,748.70 $ 34,613.02 Network Support Expense-Internet 127,935.06 10.38% 141,213.22 136,706.60 134,576.52 134,539.68 Network Support Expense-Phone 15,718.40 12.64% 17,705.78 15,620.16 15,650.86 15,712.26 Network Admin. & Oper. Expense 118,786.39 9.65% 130,249.45 114,004.43 111,419.34 118,895.51 Building & Office Expense 8,047.00 0.00% 8,047.00 8,047.00 8,047.00 8,047.00 Depreciation & Amortization Expense 59,761.44 75.82% 105,071.45 101,515.03 96,261.58 99,066.10 General & Administrative Expense 165,168.07 1.19% 167,126.36 196,112.78 199,233.90 178,211.62 Station Apparatus Expense 129,069.85 51.79% 195,913.24 120,996.87 120,298.34 109,969.06 Customer Service Expense 60,844.28 -3.41% 58,770.19 52,149.24 64,251.27 52,680.97 Marketing Expense 42,601.68 132.69% 99,131.08 67,010.53 55,381.24 75,964.54 Total Operating Expenses $ 763,139.80 26.00% $ 961,554.06 $ 845,838.27 $ 841,868.75 $ 827,699.76 Operating Income (Loss) $ 393,927.69 -29.92% $ 276,055.53 $ 441,564.87 $ 397,278.01 $ 433,374.12 Interest Expense 12,242.24 -67.26% 4,008.04 4,536.77 6,117.23 6,480.03 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) $ 15,315.33 -53.76% $ 7,081.13 $ 7,609.86 $ 9,190.32 $ 9,553.12 Net Income (Loss) $ 378,612.36 -28.96% $ 268,974.40 $ 433,955.01 $ 388,087.69 $ 423,821.00 EBITDA $ 453,689.13 $ 381,126.98 $ 543,079.90 $ 493,539.59 $ 532,440.22  CDE Lightband Cash Flow Statement - Broadband Division January 31, 2020 RECONCILIATION OF OPERATING INCOME TO NET CASH PROVIDED BY OPER ACTIVITIES: Operating income (loss) $ 276,055.53 Adjustments to reconcile oper income to cash provided (used) by operating activities Depreciation and amortization 105,071.45 Changes in: Accounts receivable 3,542.57 Advances to Electric 35,614.21 Inventory (190,441.16) Accounts payable 193,223.48 Accrued expenses 29,656.20 Customer deposits (50.00) Other 9,231.54 Net Cash Provided by Operating Activities 461,903.82 CASH FLOWS FROM FINANCING ACTIVITIES: Payment of long term debt - Additions to plant (61,061.49) Net Cash Used by Financing Activities (61,061.49) NET INCREASE IN CASH AND CASH EQUIVALENTS $ 400,842.33 CASH AND CASH EQUIVALENTS - BEG OF MONTH 5,782,103.72 CASH AND CASH EQUIVALENTS - END OF MONTH $ 6,182,946.05  CDE Lightband Rolling 4 Month Balance Sheet - Electric Division January 31, 2020 Prior Year 1/31/2019 % Change 1/31/2020 12/31/2019 11/30/2019 10/31/2019 UTILITY PLANT 1 Electric Plant $ 290,005,656.47 6.18% $ 307,916,645.32 $ 307,045,501.33 $ 304,657,982.11 $ 300,452,462.74 2 Less Depreciation (99,956,889.92) 5.42% (105,371,738.29) (104,975,954.84) (104,311,877.66) (103,673,881.42) 3 Total $190,048,766.55 6.58% $202,544,907.03 $202,069,546.49 $200,346,104.45 $196,778,581.32 4 Unamortized acq. adj. 87,131.37 -41.38% 51,077.01 54,081.54 57,086.07 60,090.60 6 Total Plant - Net $190,135,897.92 6.55% $202,595,984.04 $202,123,628.03 $200,403,190.52 $196,838,671.92 OTHER PROPERTY AND INVESTMENTS 8 Interdivisional loan 10,295,931.13 -35.45% 6,645,931.13 6,645,931.13 6,645,931.13 6,645,931.13 9 Sinking Funds 8,611,290.94 -1.12% 8,515,130.42 8,013,295.02 7,011,557.17 7,010,755.22 12 Other Special Funds - - - - - 13 Total 18,907,222.07 -19.81% 15,161,061.55 14,659,226.15 13,657,488.30 13,656,686.35 CURRENT AND ACCRUED ASSETS 14 General Cash/temp cash investments 13,975,177.96 -48.52% 7,194,544.01 9,056,555.66 11,245,414.07 8,898,292.93 14.1 Reserved Cash 27,024,923.23 -8.33% 24,775,088.86 24,533,763.23 24,300,764.44 24,107,520.37 15 Accounts Receivable 12,883,855.62 -13.32% 11,168,075.66 11,466,436.60 11,089,948.30 11,309,682.26 16 Materials and Supplies 4,056,258.87 -2.29% 3,963,458.05 4,320,330.04 4,040,648.07 4,447,827.39 18 Other Current Assets 19,257,838.52 29.07% 24,856,935.56 24,598,318.37 23,220,172.82 28,830,985.01 19 Total 77,198,054.20 -6.79% 71,958,102.14 73,975,403.90 73,896,947.70 77,594,307.96 DEFERRED DEBITS 22 Clearing Accounts - 25,148.97 26,037.26 26,825.55 27,663.84 24 Energy Service Loans Rec 2,969,361.64 -33.72% 1,967,971.58 2,043,088.40 2,121,949.44 2,194,489.47 26 Other Deferred Debits 3,469,768.60 25.25% 4,345,780.64 4,455,350.59 4,356,545.96 4,365,544.04 27 Total 6,439,130.24 -1.56% 6,338,901.19 6,524,476.25 6,505,320.95 6,587,697.35 28 TOTAL ASSETS & OTHER DEBITS $292,680,304.43 1.15% $296,054,048.92 $297,282,734.33 $294,462,947.47 $294,677,363.58 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 6,091,187.44 2.61% 6,250,073.47 6,446,929.65 5,465,999.21 6,677,685.35 35 Total 178,080,253.21 5.52% 187,906,927.16 188,103,783.34 187,122,852.90 188,334,539.04 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,279,124.94 -7.17% 7,685,904.94 7,735,339.94 7,784,774.94 7,834,209.94 41 Total 70,879,124.94 -5.15% 67,225,904.94 67,275,339.94 67,324,774.94 67,374,209.94 OTHER NON-CURRENT LIABILITIES 41.9 Post Retirement Benefits 1,430,571.07 12.47% 1,608,934.90 1,612,709.90 1,616,371.11 1,619,303.74 42 Energy Service Loans - Advances 3,078,287.04 -33.29% 2,053,407.99 2,132,834.77 2,204,317.62 2,299,937.91 44 Total 4,508,858.11 -18.77% 3,662,342.89 3,745,544.67 3,820,688.73 3,919,241.65 CURRENT AND ACCRUED LIABILITIES 46 Accounts Payable 28,664,701.15 -9.64% 25,901,677.14 27,165,854.21 25,377,232.87 24,276,279.61 47 Customer Deposits 6,591,015.52 6.19% 6,999,310.12 6,982,503.70 6,953,733.22 6,980,198.21 52.2 Interest Accrued - Other 1,211,499.76 -10.57% 1,083,463.50 866,770.80 650,078.10 433,385.40 53 Other Current Liabilities 2,744,851.74 19.29% 3,274,423.17 3,142,937.67 3,213,586.71 3,359,509.73 54 Total 39,212,068.17 -4.98% 37,258,873.93 38,158,066.38 36,194,630.90 35,049,372.95 58 TOTAL LIABILITIES AND OTHER CREDITS $ 292,680,304.43 1.15% $ 296,054,048.92 $ 297,282,734.33 $ 294,462,947.47 $ 294,677,363.58  CDE Lightband Revenues and Expenses ‐ Electric Division 1/31/2020 Prior Year Prior 3 Months 1/31/2019 % Change 1/31/2020 12/31/2019 11/30/2019 10/31/2019 OPERATING REVENUE 59 Electric Sales Revenue 15,168,778.70 ‐4.42% 14,497,796.21 14,350,440.27 12,344,396.07 13,326,383.59 60 Revenue from Late Payments 152,390.66 ‐2.49% 148,603.08 123,409.35 91,438.14 136,391.41 61 Misc Service Revenue 127,057.88 3.38% 131,357.04 121,452.14 104,521.17 131,143.16 62 Rent from Electric Property 299,724.12 3.92% 311,468.49 308,183.59 308,766.89 309,043.19 63 Other Electric Revenue 1.27 ‐15504.72% (195.64) 0.56 (0.91) 1.42 64 Total Operating Revenue 15,747,952.63 ‐4.18% 15,089,029.18 14,903,485.91 12,849,121.36 13,902,962.77 PURCHASED POWER 65 Total Power Cost 12,798,063.04 ‐11.89% 11,276,159.88 10,719,212.51 10,814,288.69 8,696,236.35 OPERATING EXPENSE 66 Transmission Expense 3,690.39 35.35% 4,994.95 2,998.66 2,803.51 3,633.00 67 Distribution Expense 377,971.40 14.47% 432,649.21 244,233.03 260,146.94 296,883.76 68 Customer Accounts Expense 370,633.13 ‐8.81% 337,991.94 285,176.54 287,576.35 358,650.28 69 Cust. Service and Inf. Exp. 21,015.89 65.45% 34,769.86 34,059.57 33,380.37 29,300.65 70 Sales Expense 10,969.62 12.37% 12,326.47 10,700.06 9,858.19 11,127.19 71 Admin. And General Expense 313,843.33 53.57% 481,954.44 397,032.37 347,309.08 333,644.47 72 Operating Expense 1,098,123.76 18.81% 1,304,686.87 974,200.23 941,074.44 1,033,239.35 MAINTENANCE EXPENSE 73 Transmission Expense 2,911.17 100.68% 5,842.08 1,312.51 3,739.27 2,131.61 74 Distribution Expense 343,219.72 101.18% 690,492.38 306,552.47 258,802.42 257,307.76 75 Admin. and General Expense 190,305.60 23.49% 235,012.20 169,526.25 286,338.53 147,232.29 76 Maintenance Expense 536,436.49 73.62% 931,346.66 477,391.23 548,880.22 406,671.66 OTHER OPERATING EXPENSE 77 Depreciation Expense 1,016,836.61 4.84% 1,066,093.88 1,054,320.53 1,052,901.15 1,052,720.36 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 554,350.76 2.37% 567,466.90 560,410.72 569,678.30 538,770.21 80 Total other oper. Expense 1,574,191.90 3.96% 1,636,565.31 1,617,735.78 1,625,583.98 1,594,495.10 Total operating expense and 81 purchased power 16,006,815.19 ‐5.36% 15,148,758.72 13,788,539.75 13,929,827.33 11,730,642.46 INCOME 82 Operating Income (258,862.56) ‐76.93% (59,729.54) 1,114,946.16 (1,080,705.97) 2,172,320.31 83 Other Income 73,603.54 ‐31.14% 50,685.13 53,336.37 56,342.06 67,744.16 84 Total Income (185,259.02) ‐95.12% (9,044.41) 1,168,282.53 (1,024,363.91) 2,240,064.47 85 Misc Income Deductions (1,600.00) (425.00) ‐ ‐ ‐ 86 Net Income before debt expense (186,859.02) ‐94.93% (9,469.41) 1,168,282.53 (1,024,363.91) 2,240,064.47 DEBT EXPENSE 90 Interest on Long Term Debt 242,538.83 ‐3.00% 235,270.09 235,270.09 235,270.09 235,270.09 92 Other Interest Expense 1,504.70 3.12% 1,551.68 1,517.00 1,487.14 1,533.23 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 194,608.53 ‐3.71% 187,386.77 187,352.09 187,322.23 187,368.32 NET INCOME 96 Income before Extraord. Items (381,467.55) ‐48.40% (196,856.18) 980,930.44 (1,211,686.14) 2,052,696.15 97 Extraordinary Items ‐ ‐ ‐ ‐ ‐ 98 Net Income (381,467.55) ‐48.40% (196,856.18) 980,930.44 (1,211,686.14) 2,052,696.15  CDE Lightband Cash Flow Statement - Electric Division January 31, 2020 RECONCILIATION OF OPERATING INCOME TO NET CASH PROVIDED BY OPER ACTIVITIES: Operating income $ (59,729.54) Adjustments to reconcile oper income to cash provided (used) by operating activities Depreciation and amortization 1,069,098.41 Changes in: Accounts receivable 298,360.94 Materials and supplies 356,871.99 Interdivisional loan - Accounts receivable - TVA Energy Service Loans 75,116.82 Advances - TVA Energy Service Loans (79,426.78) Prepayments - Other current assets (526,611.22) Accounts payable (1,264,177.07) Accrued expenses 216,692.70 Customer deposits 16,806.42 Other postemployment benefits (3,775.00) Other 131,485.50 Net Cash from Operating Activities 230,713.17 CASH FLOWS FROM FINANCING ACTIVITIES: Additions to plant (1,541,454.42) Payment of long-term debt (49,435.00) Net Cash used by Financing Activities (1,590,889.42) NET DECREASE IN CASH AND CASH EQUIVALENTS $ (1,360,176.25) CASH AND CASH EQUIVALENTS - BEG OF MONTH 41,844,939.54 CASH AND CASH EQUIVALENTS - END OF MONTH $ 40,484,763.29 CASH AND CASH EQUIVALENTS CONSIST OF: Sinking Funds 8,515,130.42 Construction Funds - General cash/temp cash investments 7,194,544.01 Reserved Cash 24,775,088.86 $ 40,484,763.29 CDE Lightband Subscriber Analysis November 2019 - January 2020 Month End Reports November 2019 December 2019 January 2020 Net Gain Growth % Net Gain Growth % Net Gain Growth % November November November Over Prev. % Growth November Year over December December December Over Prev. % Growth December Year over January January January Over Prev. % Growth January Year over Service Actual Budget Variance Month to Budget 2018 Actual Year Actual Budget Variance Month to Budget 2018 Actual Year Actual Budget Variance Month to Budget 2019 Actual Year Video 5,146 5,275 (129) (29) -2% 5,544 -7% 5,070 5,273 (203) (76) -4% 5,508 -8% 4,950 5,271 (321) (120) -6% 5,383 -8% LB Basic 371 317 54 6 17% 359 3% 373 316 57 2 18% 360 4% 375 316 59 2 19% 351 7% LB Plus 1,923 1,583 340 12 21% 1,815 6% 1,915 1,582 333 (8) 21% 1,819 5% 1,881 1,581 300 (34) 19% 1,800 5% LB Extra 2,821 3,376 (555) (45) -16% 3,328 -15% 2,751 3,375 (624) (70) -18% 3,289 -16% 2,664 3,373 (709) (87) -21% 3,193 -17% Bronze Pkg 2 2 - - 0% 2 0% 2 2 - - 0% 2 0% 2 2 - - 0% 2 0% Silver Pkg 2 2 - - 0% 2 0% 2 2 - - 0% 2 0% 1 2 (1) (1) -50% 2 -50% Gold Pkg 27 35 (8) (2) -23% 38 -29% 27 35 (8) - -23% 36 -25% 27 35 (8) - -23% 35 -23% Internet 20,249 20,037 212 (25) 1% 19,096 6% 20,251 20,166 85 2 0% 19,192 6% 20,249 20,243 6 (2) 0% 19,288 5% Phone 2,549 2,576 (27) (1) -1% 2,587 -1% 2,544 2,587 (43) (5) -2% 2,575 -1% 2,527 2,595 (68) (17) -3% 2,560 -1% Comm Internet 1,638 1,611 27 14 2% 1,481 11% 1,643 1,633 10 5 1% 1,490 10% 1,670 1,661 9 27 1% 1,492 12% Broadband ONTs 23,007 22,370 637 25 3% 21,584 7% 23,014 22,450 564 7 3% 21,665 6% 23,407 22,540 867 393 4% 21,755 8%