Finance Committee

FINANCE COMMITTEE AGENDA *This meeting will be conducted via Zoom* DATE:February 23, 2021 TIME: 4:30 p.m. LOCATION: Zoom Join Zoom Meeting https://zoom.us/j/91598496322?pwd=TzRFV2FhOWFJWUJJTjdyYzZZcmxGUT09 Dial in: +1 312 626 6799 US (Chicago) Meeting ID: 915 9849 6322 Passcode: 793895 1) CALL TO ORDER 2) ATTENDANCE 3) APPROVAL OF ELECTRONIC MEETING In order to comply with the technical aspects of the Governor’s Executive Order regarding holding open meetings in a forum other than in the open and in public, the Finance Committee determines that meeting electronically is necessary to protect the health, safety, and welfare of its citizens due to the COVID-19 outbreak. 4) ADOPTION OF MINUTES: January 26 5) DEPARTMENT REPORTS 1. PURCHASING ​Camille Thomas a) Report of bids  b) Report of award of professional service contracts ● Housing & Community Development - Case Management for 2 months for the Shelter Plus Care Grant program from Buffalo Valley, Inc. in the amount of $1,200.00. ● Fire Dept. - Design Services for a 20,000 sq. ft. Admin Training Building from Powell Architecture in the amount of $42,000.00. ● Municipal Properties - Frosty Morn post demolition stabilization design and construction inspection from K & S Engineering in the amount of $8,000.00. c) Report of sales of surplus property on ​GovDeals.com ​January 2021 - $​53,037.00. 2. GENERAL GOVERNMENT a) Monthly report ​Laurie Matta 3. DEPARTMENT OF ELECTRICITY a) Monthly reports ​David Johns, Christy Batts 4. CITY ATTORNEY a) Report of legal expenditures ​Lance Baker ● Bradley Arant, Kimberly Black v. City - $334.53; ● Bradley Arant, Jeff Robinson v. City - $9,027.50; ● Burr Forman, TN River Keepers v. City - $3,555.00; and ● Klein Solomon Mills, Ethic Complaints matters - $2,940.00 6) COMMITTEE ACTION No items were submitted for committee action. 7) CITY COUNCIL ACTION 1. FINANCE a) ORDINANCE 74-2020-21 ​(First Reading) Amending the Operating Budget for FY21 for Governmental Funds to add funding to support the Juneteenth holiday ​Laurie Matta/Councilperson Allen  2. HOUSING & COMMUNITY DEVELOPMENT a) ORDINANCE 75-2020-21 ​(First Reading) Amding the FY21 Housing & Community Development Budget to include the 2021 Community Housing Partnership of Williamson County THDA Grant ​Dennis Newburn 8) PUBLIC COMMENTS No requests for public comments were submitted. 9) ATTORNEY-CLIENT NON-PUBLIC MEETING a) Robinson & FSC v. City Lawsuits 10) ADJOURNMENT  FINANCE COMMITTEE JANUARY 26, 2021 MINUTES CALL TO ORDER The regular monthly meeting of the City of Clarksville Finance Committee was called to order by Chairperson Stacey Streetman on Tuesday, January 26, 2021, at 4:30 p.m. in the City Hall Conference Room, 1 Public Square, Clarksville,Tennessee, This meeting was conducted in person and via Zoom. ATTENDANCE IN PERSON: Travis Holleman, Wallace Redd, Stacey Streetman 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. Councilperson Redd made a motion to approve the electronic meeting. The motion was seconded by Councilperson Holleman. The following vote was recorded: AYE: Holleman, Redd, Streetman The motion to approve the electronic meeting unanimously passed. ADOPTION OF MINUTES: Councilperson Redd made a motion to adopt the November 24, 2020 and December 29, 2020 minutes as presented. The motion was seconded by Councilperson Holleman. The following vote was recorded: AYE: Holleman, Redd, Streetman  The motion to adopt the minutes as presented unanimously passed. PURCHASING REPORT Director of Purchasing Camille Thomas shared the monthly bid summar and reported award of the following professional service contracts: ● Municipal Properties - CDE Substation Survey at the Exit 8 Athletic Complex from McKay-Burchett & Co. in the amount of $6,300.00. This expense will be reimbursed by CDE. ● Municipal Properties - Appraisal of the southern end of the Athletic Complex (approx. 140 acres) and a section of the north end (approx. 3 acres) from Mark Young Real Estate Appraisals in the amount of $2,600.00. ● Municipal Properties - Survey for the proposed Hazelwood Regional Recreation Center property from McKay-Burchett & Co. in the amount of $2,750.00. ● Municipal Properties - Legal description and drawing of the southern (142 acres) of the Athletic Complex and the 100 ft. utility easement on the northern end from McKay-Burchett & Co. in the amount of $3,100.00. ● Municipal Properties - Appraisal of the proposed Hazelwood Regional Recreation Center property from Mark Young Real Estate Appraisals in the amount of $1,000.00. ● Gas & Water - Design and preparation of construction documents for new thermal dryer equipment from Hazen & Sawyer in the amount of $1,164,106.00. ● Gas & Water - Fee increase for the flow monitoring services provided by ADS Environmental Services in the amount of $58,200.00 for a total cost of $174,600.00. ● Gas & Water - Fee increase for the relocation of utilities on Rossview Road from TTL, Inc. (formally DBS & Associates) in the amount of $50,427.28 for a total of $241,953.59. ● Fire Dept. - CFR Burn Building Remediation services from ECS Southeast, LLP in the amount of $1,344.00. ● Purchasing - Land closing for 1019 Main Street from Cunnigham, Mitchell & Rocconi. There is no cost to the city. ● City Garage - Design, architectural and mechanical engineering services for the old Perkins & Miller building from Vision Architects in the amount of $12,200.00.  Ms. Thomas reported sales of surplus property in the amount of $12,200.00 during November and December 2020. GENERAL FUND REPORT Chief Financial Officer Laurie Matta said revenues were exceeding expenses by $6.1 million. She said year-to-date collected revenues totaled $6.4 million, which included COVID-19 relief funds, which was 17% higher that projected. Local Option Sales Tax totaling $1.8 million, 13% more than the previous year, generated $1.7 million for the General Fund, $84,000 for the road fund, and 5.5 million for schools. The total capital project investment was $40.5 and the December 31, 2020 ending Fund Balance reached $33.3 million or 296% of budgeted expenditures. Ms. Matta said grant activities had been slow and reported $14.3 million invested in the Local Government Investment Pool. DEPARTMENT OF ELECTRICITY REPORT CDE Chief Financial Officer David Johns said the Broadband Division cash reached $5.2 million noting the department recently paid a significant capital outlay expense. He reported year-to-date retained earnings of $2.8 million over the past six months. Mr. Johns felt the department was on pace for the highest income year to date. Broadband operating expenses totaled $2.1 in December 2020 with the cost of programming mostly for video. Christy Batts said the December subscriber performance was good with Broadband reaching 24,000 customers. CITY ATTORNEY’S REPORT City Attorney Lance Baker reported payment of the following legal expenditures. ● Burr Forman, TN River Keepers v. City - $1,817.00 ● Bradley Arant, Jeff Robinson v. City - $4,106.90 ● Bradley Arant, Kimberly Black v. City - $1,814.49 ● Bradley Arant, Employment Matters - $2,905.00 COMMITTEE AND CITY COUNCIL ACTION No items were submitted for Committee or City Council action. PUBLIC COMMENTS No requests were submitted for public comments. ADJOURNMENT The meeting was adjourned at 5:02 p.m.  BID SUMMARY FEBRUARY 23, 2021 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 4086-P Recreation Lights & Sound for Riverfest Warbabies $ 22,000.00 4124 Recreation Liberty Park Remediation Phase II Neely Engineering $ 695,315.00 4132 G&W Pea Ridge Road to Pollard Road Water Main Improvements Parchman Const. $ 339,244.32 4138 Recreation HVAC Replacement at Freedom Point Mainstream Heating $ 60,400.00 4140 G&W College Street Combined Sewer Replacement Parchman Const. $ 768,814.39 SOLE SOURCE PURCHASES: 1. Fire Dept. – Future purchases of ResQTec Air Bags from Mid-South Emergency. 2. G&W – Future purchases of parts and equipment for the sampling and flow monitoring equipment at the Wastewater Treatment Plant from Kazmier & Associates. 3. G&W – Future purchases of refurbished 750 gas meters from Superior Gaskets. 4. G&W – Future purchases of nylon bearing rings for the Ovivo compactors at the Wastewater Treatment Plant from Ovivo USA, LLC 5. G&W – Future gas, water and sewer valve box adjustments from CK Masonry. Proposal #4086-P – Recreation – Lights & Sound for Riverfest Warbabies $ 22,000.00* Local ProVideo No Response Mary’s Music No Response Local Edward Jones Productions No Response Local Rhino TN, LLC No Response American Stage Co. No Response Staging Techniques No Response System Solutions, LLC No Response Myers Concert Productions No Response Event System Productions No Response Memphis Sound Entertainment No Response LMG Touring No Response Morris Light & Sound No Response Spring Tree Media Group No Response Zia Music Productions No Response Stage Rite Sound No Response XL Mediaworks, Inc. No Response Accurate Staging No Response Extreme Lighting & Sound No Response Griggs Audio Productions No Response High Tech Special Effects No Response Interstate Lighting & Sound No Response Kendall Stage Curtains Co. No Response Memphis Audio, Inc. No Response Polaris Productions No Response Porter Acoustics No Response Stage Light Tennessee No Response Zade Productions No Response Bid #4124 – Recreation – Liberty Park Remediation Phase II Neely Engineering & Contracting $ 695,315.00* Local Earth Retention Stabilization No Response Pride Concrete, LLC No Response Local CJ Geo No Response Uretek USA No Response Triple S Contracting No Response Local B. R. Miller & Co. No Response Local Moore Construction No Response Local J. Shepherd Construction No Response Local Hall Construction No Response Local Hughes Construction No Response Local Gregory Construction No Response Southeast Contractors No Response B & B Construction & Excavation No Response Beech Construction Services No Response Cross Driven Construction No Response G Power Group No Response J & S Construction Company No Response Jeff Freitage Construction No Response Masonry Specialist Corp. No Response Accurate Contracting Services No Response Adams Masonry No Response Ashburn Property Maintenance No Response BELFOR Property Restoration No Response Bluff City Coring & Cutting No Response Buckhead Construction Co. No Response Damon-Marcus Company No Response Earhart Maintenance Service No Response Industrial Fabrication Repair No Response M. Chavez Masonry & Remodeling No Response Seal Master No Response Seiber Restoration, LLC No Response Specialty Concrete Solutions No Response Total Building Maintenance No Response Volunteer Restoration, Inc. No Response Bar Environmental No Response Blue Team Restoration No Response Curl Construction & Excavating No Response H & D Concrete Solutions No Response Hathaway’s Demo Construction No Response Level Up Home Improvement No Response MDI Construction No Response Precision Concrete Cutting No Response Pure Green, LLC No Response The Hogan Company No Response Bid #4132 – G&W – Pea Ridge Road & Pollard Road Water Improvements Parchman Construction $ 339,244.32* Scott & Ritter $ 388,335.00 Byard Construction $ 395,945.00 Local JSJ Construction $ 486,577.00 Michels Corporation $ 962,301.00 Progressive Pipeline $ 1,555,669.00 Pride Utility Construction No Response Tri-State Utility Contractors No Response King Pipeline & Utility No Response Hayes Utility Contractor No Response B. W. Hobson Construction No Response Distribution Construction No Response Hiwassee Construction No Response Revell Construction No Response Midsouth Utility No Response James N. Bush Construction No Response Classic City Mechanical No Response T. J. Construction No Response Williamson Construction No Response David Dickson No Response MG Dyess, Inc. No Response Strike No Response W & O Construction No Response Wolseley Industrial Group No Response Team Construction No Response Appalachian Pipeline No Response Holloman Corporation No Response Cleary Construction No Response Schmid Pipeline Construction No Response J. F. Construction Services No Response Meadows Construction No Response Local Norris Brothers Excavating No Response C. J. Hughes No Response Martin Contracting No Response Boan Contracting No Response Equix Energy Services No Response SAK Construction No Response Lafferty & Son No Response Local W. Rogers Group No Response Bobby Luttrell & Sons No Response Twin States Utilities No Response Crowder Construction No Response Haren Construction No Response Conrad Construction No Response Goodrich Construction No Response Local J. Cumby Construction No Response Triple S Contracting No Response Local Civil Constructors No Response Means Backhoe Service No Response J. Shepherd Construction No Response Local Ronald Franks Construction No Response Fisher Contracting No Response Pride Construction No Response Summit Constructors No Response Cumberland Valley Constructors No Response Moore Construction No Response Local Dynamic Construction No Response Garney Construction No Response Pernell Excavating No Response Local Alberici Constructors No Response Gaines Shearon Construction No Response Morgan Contracting No Response Local Reynolds Construction No Response Smith Contractors No Response Bid #4138 – Recreation – HVAC Replacement at Freedom Point Mainstream Heating & Cooling $ 60,400.00* Local Freeman Mechanical $ 69,000.00 Local John W. Davis Heating & Cooling No Bid Local Siemens Industry, Inc. No Bid Local Lee Company No Bid Local Active Energy No Bid Local Four Season Heating & Cooling No Response Local Modern Heating & Cooling No Response Local Beltline Electric Co., Inc. No Response Maynard Select No Response Music City Mechanical No Response Alpha Mechanical Service, Inc. No Response Trane No Response Morton Mechanical No Response Local Hometown Air Conditioning No Response Local All Weather Heating & Cooling No Response Local C-Tech, Inc. No Response H & H Heating & Air Conditioning No Response Local Mac Plumbing No Response Local Dawson-Dawson Heating No Response Local Autumn Comforting Heating No Response Local Hiller Plumbing & Heating No Response Local Action Air No Response Local All American Air No Response Archer Air Conditioning No Response Bumpus Heating & Cooling No Response Charles Stone Heating & Cooling No Response Bid #4140 – G&W – College Street Combined Sewer Replacement Parchman Construction $ 768,814.39* Scott & Ritter $ 722,380.00** L & G Construction $ 824,235.00 Cleary Construction $ 874,120.00 Progressive Pipeline No Bid Smith Contractors No Response Haren Construction No Response Dugan & Meyers No Response Reeves & Young No Response Judy Construction No Response Pernell Excavating No Response Local Cumberland Valley Constructors No Response D.J. Shubeck Co. No Response 3D Enterprises Contracting No Response David Dickson No Response Schmid Pipeline Construction No Response MG Dyess, Inc. No Response Strike No Response W & O Construction No Response Byard Construction No Response Local Wolseley Industrial Group No Response Team Construction No Response Appalachian Pipeline No Response Holloman Corporation No Response J. Cumby Construction No Response Michels Corporation No Response J.F. Construction Services No Response Meadows Construction No Response Local Norris Brothers Excavating No Response Moore Construction No Response Local C. J. Hughes No Response Martin Contracting No Response Boan Contracting No Response James N. Bush Construction No Response Equix Energy Services No Response SAK Construction No Response Lafferty & Son No Response Local Rogers Company No Response Bobby Luttrell & Sons No Response Twin States Utilities No Response Crowder Construction No Response Conrad Construction No Response Goodrich Construction No Response Local Triple S Contracting No Response Local Civil Constructors No Response Means Backhoe Service No Response J. Shepherd Construction No Response Local Ronald Franks Construction No Response Fisher Contracting No Response Pride Construction No Response Summit Constructors No Response Dynamic Construction No Response Garney Construction No Response Gregory Construction No Response Gaines Shearon Construction No Response **Vendor had many exceptions to the bid spec requirements, therefore was deemed non-responsive. __________________________________________________________________________________________ *Department Recommendation Department of Finance & Revenue January 2021 Financial Review Fiscal Year 2021 Clarksville, Tennessee January 31, 2021  General Fund Revenues vs. Expenditures Fiscal Year 2021 As of January 31, 2021 FY 2021 Monthly FY 2021 Revenues Expenditures Variance July $ 9,444,294 $ 7,000,858 $ 2,443,436 August 5,730,068 5,813,328 (83,260) September 4,725,612 7,493,615 (2,768,003) October 5,330,915 7,626,453 (2,295,538) November 6,760,414 6,173,673 586,741 December 21,657,000 12,970,096 8,686,904 January 11,580,069 7,408,034 4,172,036 February - March - April - May - June - YTD Total $ 65,228,371 $ 54,486,056 $ 10,742,316 $25,000,000 $20,000,000 $15,000,000 FY 2021 Revenues $10,000,000 FY 2021 Expenditures $5,000,000 $-  General Fund Revenue Comparison Fiscal Year 2021 As of January 31, 2021 FY 2021 FY 2020 Variance Revenue Revenue July $ 9,444,294 $ 5,454,774 $ 3,989,520 August 5,730,068 $ 5,286,834 443,234 September 4,725,612 $ 4,836,616 (111,004) October 5,330,915 $ 5,059,278 271,637 November 6,760,414 $ 7,710,416 (950,002) December 21,657,000 $ 18,909,185 2,747,815 January 11,580,069 $ 7,951,271 3,628,798 February - - March - - April - - May - - June - - YTD Total $ 65,228,371 $ 55,208,373 $ 10,019,998 $73,000,000 $63,000,000 $53,000,000 $43,000,000 FY2020 YTD Revenue $33,000,000 FY2021 YTD Revenue FY2021 YTD Budgeted Revenue $23,000,000 $13,000,000 $3,000,000  GENERAL FUND REVENUES Fiscal Year 2021 As of January 31, 2021 Total Budget YTD Month TAXES Prior Year Property Taxes 894,712 941,780 67,908 2020 Property Taxes 34,346,266 21,007,608 4,476,110 PiLOTS 687,473 75,572 764 Local Option Sales Tax 20,238,985 11,996,906 1,855,674 Beer & Liquor Tax 4,553,322 2,982,460 476,463 Business License 3,202,692 1,345,962 93,994 Franchise Tax (cable) 1,500,932 413,716 118,870 Hote/Motel 350,000 205,699 25,377 Other Taxes 366,887 173,481 19,697 TOTAL TAXES 66,141,269 39,143,184 7,134,858 LICENSES AND PERMITS Building Permits 2,700,000 1,921,958 306,788 Other Permits 129,309 63,105 7,750 TOTAL PERMITS 2,829,309 1,985,063 314,538 INTERGOVERNMENTAL Grant reimbursements 2,583,305 393,751 - State Shared Revenues TVA Replacement Tax 300,000 299,426 - State Sales Tax 63,806 47,874 6,372 State Street Aid 2,550,961 1,511,329 206,261 Other Taxes 15,424,551 9,798,915 1,736,971 TOTAL INTERGOVERNMENTAL 20,922,623 12,051,295 1,949,605 OTHER REVENUES Charges for Services 624,671 337,950 37,468 Recreation 403,010 91,414 20,288 Golf Courses 737,318 449,244 10,477 Fines and Forefeitures 553,792 250,416 25,166 Investment & Interest Earnings 175,995 17,135 1,365 Other Misc. Revenues 1,026,543 249,664 28,001 Extraordinary Sources (COVID Funds) 5,841,737 5,842,112 1,328,285 Transfer from CDE 5,197,147 2,849,019 409,431 Transfer From CGW 3,628,651 1,814,325 302,388 Other Transfers 817,696 147,551 18,200 TOTAL OTHER REVENUES 19,006,560 12,048,830 2,181,068 TOTAL REVENUES GENERAL FUND 108,899,761 65,228,371 11,580,069  General Fund Expenditure Comparison Fiscal Year 2021 As of January 31, 2021 FY 2021 FY 2020 Variance Expenditures Expenditures July $ 7,000,858 $ 8,407,620 $ (1,406,762) August 5,813,328 $ 6,844,729 (1,031,401) September 7,493,615 $ 8,912,821 (1,419,207) October 7,626,453 $ 8,818,714 (1,192,261) November 6,173,673 $ 6,798,578 (624,905) December 12,970,096 $ 6,760,944 6,209,151 January 7,408,034 $ 9,314,931 (1,906,898) February - - March - - April - - May - - June - - YTD Total $ 54,486,056 $ 55,858,338 $ (1,372,282) $72,000,000 $62,000,000 $52,000,000 $42,000,000 FY2020 YTD Expenditures $32,000,000 FY2021 YTD Expenditures FY2021 YTD Budgeted $22,000,000 Expenditures $12,000,000 $2,000,000  General Fund Year-to-Date Departmental Budget vs. Actual Expenditures Fiscal Year 2021 As of January 31, 2021 $30,000,000 Expenditures Estimated Variance FY 2021 YTD YTD Budget (Over)Under $25,000,000 Departmental: $20,000,000 Police $ 16,839,252 $ 19,435,419 $ 2,596,167 Fire 10,692,135 12,257,889 1,565,754 $15,000,000 FY 2021 Actual YTD Highway & Street 7,069,206 8,609,483 1,540,277 $10,000,000 Parks & Rec. & Golf 4,345,649 5,354,407 1,008,759 $5,000,000 Building & Codes 1,103,082 1,332,240 229,158 FY2021 Total $0 Info. Technology 1,027,313 1,138,888 111,576 Budget Finance 967,679 1,132,435 164,756 City Garage 602,657 832,806 230,149 Municipal Properties 318,193 437,569 119,375 Human Resources 567,432 693,841 126,408 Legislative / Admin. 363,456 381,479 18,023 Mayor's Office 386,800 424,496 37,696 City Court 256,158 268,235 12,077 $1,100,000 Legal 212,030 245,288 33,258 $1,000,000 $900,000 Internal Audit 195,762 238,783 43,022 $800,000 Purchasing 97,467 120,981 23,514 $700,000 Departmental Total 45,044,271 52,904,239 7,859,968 $600,000 $500,000 FY 2021 $400,000 Actual YTD Nondepartmental: $300,000 Debt 5,518,278 6,289,803 771,525 $200,000 FY2021 Total $100,000 Extraordinary - COVID 1,253,532 2,619,285 1,365,753 Budget $0 Transit 132,819 895,130 762,311 Retirees 709,137 1,046,811 337,674 Other 1,828,019 1,848,611 20,592 YTD Total $ 54,486,056 $ 65,603,880 $ 11,117,824  Schedule of Sales Tax Collections Fiscal Year 2021 As of January 31, 2021 City of Clarksville Local Sales & Use Tax Net Collections Net Collections Net Collections Net Collections FY 2018 FY 2019 FY 2020 FY 2021 July $ 1,425,145 $ 1,524,372 $ 1,607,009 $ 1,840,352 August 1,453,282 1,552,311 1,584,610 1,836,659 September 1,376,154 1,461,197 1,553,548 1,747,769 October 1,330,621 1,576,737 1,541,129 1,677,233 November 1,443,473 1,509,818 1,547,242 1,729,856 December 1,357,713 1,602,804 1,559,998 1,806,872 January 1,454,962 1,559,092 1,649,239 1,855,674 February March April May June YTD Total $ 9,841,350 $ 10,786,331 $ 11,042,774 $ 12,494,416 City of Clarksville $14,500,000 $12,500,000 $10,500,000 $8,500,000 $6,500,000 $4,500,000 $2,500,000 $500,000 FY 2018 FY 2019 FY 2020 FY 2021  Local Sales Tax Collections Fiscal Year 2021 As of January 31, 2021 TOTAL NET COLLECTIONS PAID TO GROSS COLLECTIONS UNICORPORATED NET COLLECTIONS COUNTY CITY CITY ROADS SCHOOLS AREA CITY LIMITS PAID TO STATE July $ 7,463,614 $ 103,279 $ 1,754,290 $ 86,062 $ 5,519,983 $ 585,231 $ 6,963,304 $ 84,921 August 7,511,005 106,783 1,750,770 85,889 5,567,563 647,132 6,949,333 85,460 September 7,120,548 100,012 1,666,037 81,733 5,272,767 588,563 6,613,002 81,018 October 6,794,013 93,645 1,598,799 78,434 5,023,135 525,200 6,346,115 77,302 November 7,168,367 106,174 1,648,961 80,895 5,332,337 704,705 6,545,224 81,562 December 7,393,332 105,297 1,722,376 84,496 5,481,163 640,825 6,836,628 84,121 January 7,637,988 110,817 1,768,896 86,779 5,671,497 703,612 7,021,281 86,905 February - March - April - May - June - YTD TOTAL $ 51,088,866 $ 726,007 $ 11,910,128 $ 584,288 $ 37,868,444 $ 4,395,269 $ 47,274,886 $ 581,289 Monthly Distribution 1.45% 23.16% 1.14% COUNTY CITY 74.25% CITY ROADS SCHOOLS  Capital Project Status Report Fiscal Year 2021 As of January 31, 2021 TOTAL ACTIVE ACTIVE PROJECTS TOTAL FY EXPENSES PROJECT PROJECT FY2020-2021 FUNDING 7/1/20-1/31/21 BALANCE EXPENSES ** STREET DEPARTMENT: 93101 Rossview/Dunbar Cave/Cardinal Improvements 13,280,000 1,094,920 3,860,555 9,419,445 14301 Edmondson Ferry/1A Bypass Interesection Improvement 1,150,004 0 1,150,002 2 15306 Northeast Connector 16,808,700 227,746 1,493,524 15,315,176 17301 International & Dunlop Intersection Improvement 2,807,831 603,253 1,048,758 1,759,073 17304 Adaptaive Signal Control Project (Wilma) 1,200,000 120,620 120,620 1,079,380 17305 Tylertown & Oakland Intersection Improvement 10,000,000 329,295 1,241,394 8,758,606 17307 Tylertown & Trenton Drainage Overflow Project 3,540,185 48,580 122,327 3,417,858 18301 Drainage Mitigation FY2018 280,801 0 106,642 174,159 18302 New Sidewalks FY2018 934,954 720,652 869,976 64,978 19301 Lilac Lane 100,000 45,605 48,205 51,795 19302 Whitfield Road Improvements 15,850,000 355,045 1,664,174 14,185,826 19303 Spot Intersection Improvements 1,500,000 183,566 277,702 1,222,298 20301 Dunbar Cave Road Bridge 600,000 531,267 531,767 68,233 20302 4th Street and College Signal 400,000 91,775 129,767 270,233 20303 New Sidewalks FY20-24 1,850,000 0 843,791 1,006,209 20304 Drainage Mitigation FY20-24 569,199 750 750 568,449 20305 Cemetary Retaining Wall 510,000 494,285 495,785 14,215 21301 Storm Sewer Rehab 350,000 0 0 350,000 21302 College Street Streetscape 300,000 0 0 300,000 21303 College Street SCO Repair/Replace 500,000 0 0 500,000 $ 72,531,674 $ 4,847,357 $ 14,005,739 $ 58,525,935 PARKS & RECREATION: 16503 Athlectic Complex 19,667,813 283,608 5,034,353 14,633,460 16504 Red River East Trail Project 2,403,712 178,172 2,332,558 71,154 17501 Valleybrook Park & Upland Trail Connection 0 0 0 0 17502 Public Spaces 150,000 0 150,000 0 17503 Edith Pettus Park Renovations 201,800 0 23,615 178,185 17504 Crow Community Center Renovation 370,000 197,091 316,957 53,043 17505 Liberty Park/Marina Remediation 905,218 168,373 271,154 634,064 17506 Swan Lake Renovations 1,046,605 0 1,039,218 7,387 19502 Pollard Road Additional Parking 229,199 74,123 301,824 -72,625 19503 Billy Dunlop Pavillion & Restroom 382,485 0 380,591 1,894 19504 Heritage Park Improvements 1,000,000 103,823 612,445 387,555 19505 Regional Community Center 500,000 0 0 500,000 20501 Red River Pedestrian Bridge 3,068,233 20,125 31,806 3,036,427 20502 Mason Rudolph Cart Path Paving 0 0 0 0 20503 Swan Lake Cart Path Paving 190,800 0 187,700 3,100 20504 Burt Cobb Recreation Center Roof 230,000 32,443 223,932 6,068 21501 Marina Dredging at Red River East 330,000 14 14 329,986 $ 30,675,865 $ 1,057,773 $ 10,906,168 $ 19,769,697 FIRE DEPARTMENT: 16221 Fire Maintenance Facility 1,666,377 346,795 395,047 1,271,330 20221 Renovation of Station 10 0 0 0 0 20222 Custom Engine (replaces 1999 model) 590,000 588,374 588,374 1,626 21221 New Admin Building 200,000 0 0 200,000 21222 New Burn Building 225,000 3,412 3,412 221,588 21223 100' Ladder Truck 1,500,000 8,939 8,939 1,491,061 21224 New Rescue Truck 350,000 2,308 2,308 347,692 $ 4,531,377 $ 949,828 $ 998,080 $ 3,533,297 POLICE DEPARTMENT: 19211 District 3 Precinct Building 3,500,000 1,146,445 1,338,697 2,161,303 21211 Vista Lane Renoation 60,000 0 0 60,000 $ 3,560,000 $ 1,146,445 $ 1,338,697 $ 2,221,303 GENERAL GOVERNMENT: 41016 Corporate Business Park Expansion $ 14,368,821 $ - $ 14,092,700 $ 276,121 13101 Clarksville Performing Arts & Conf Center 7,834,713 0 179,907 7,654,806 15102 TDOT 2013 Multimodal Access 206,017 0 169,830 36,187 16103 2015 Multimodal Access Grant 241,189 0 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 1,023,603 1,028,103 171,898 $ 24,949,776 $ 1,023,603 $ 15,692,582 $ 9,257,194 debt issuance costs Total Spent YTD: Major Projects $ 136,248,692 $ 9,025,006 $ 42,941,266 $ 93,307,426 * 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 2021 As of January 31, 2021 Estimated Beginning Fund Revenues Expenditures Estimated Ending Fund Balance YTD YTD Fund Balance 01/31/21 7/01/20 General Fund: $ 26,757,752 $ 65,228,371 $ 54,486,056 $ 37,500,068 Capital Projects Fund: 558,793 3,814,065 9,025,006 (4,652,148) Debt Service Fund: 502,905 5,537,390 5,527,487 512,808 Internal Service Funds: 8,800,626 7,888,436 11,216,819 5,472,244 Non-Major Governmental Funds: Drug Fund 754,410 228,334 64,666 918,079 Road Improvement Fund 1,290,400 497,509 0 1,787,909 Police Special Fund 165,524 124,797 246,835 43,487 Parks Special Fund 261,198 118,887 151,642 228,443 Other Special Revenue Fund* 812,813 312,714 512,319 613,208 Community Development 496,555 271,220 551,380 216,396 Capital Projects Revenue District Fund 467,556 0 0 467,556 * Includes: Fire Spec. Rev., Traffic Camera Police & Parks, SRF  Notice of Grant Applications Fiscal Year 2021 As of January 31, 2021 Date Funding Funds Match Submitted Project Title Agency Requested Required Status Notes 2019 Assistance to US Dept of Federal funding to purchase mobile air units, thermal imaging cameras and 03/19/20 $146,489 $14,649 Not funded Firefighters Grant Homeland Security training for CFD. 2021 Alcohol & Funding for alcohol and impaired driver countermeasures. Pays for overtime for TN Highway Safety 03/25/20 Impared Driving 133505.4 125000 $0 Awarded officers to conduct DUI checkpoints and saturation patrols for a one year Office (THSO) Enforcement period. Including purchase of equipment for DUI checkpoints. 2021 Child Passenger Funding for child safety seats and booster seats to provide to low income TN Highway Safety 03/25/20 Safety and Occupant $10,564 $0 Not funded families and staff time for events/enforcement of proper use of child passenger Office (THSO) Protection restraints. 2021 TN Highway Safety Funding for training of officers for bicycle/pedestrian crash investigations, staff 03/27/20 Bicycle/Pedestrian $13,544 $0 Not funded Office (THSO) 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 Not funded Driving Office (THSO) purposes and public events. 2020 Assistance to Federal funding to reimburse for PPE expenses incurred related to COVID19 as Firefighters - US Dept of 05/15/20 $56,563 $5,656 Awarded well as expected PPE expenses through May 2021. Funding only covers face COVID19 Homeland Security masks, gloves and gowns used by firefighters on calls. Supplement 2019 Staffing for Requested funding to hire 15 new firefighters. Funding would cover 100% to Adquate Fire and US Dept of 05/20/20 $2,713,365 $0 Awarded entry level salaries and benefits for 3 years. Share has been waived due to Emergency Response Homeland Security COVID19. Match was waived. (SAFER) 2019 Fire Prevention US Dept of Federal funding to purchase a new fire safety trailer and training for two CFR 05/27/20 $60,683 $3,034 Not funded and Safety Homeland Security staff to become certified Fire and Safety Educators 2020 Coronavirus Emergency Allocation to cover expenses related to COVID, both past and future anticipated 05/29/20 US Dept of Justice $191,575 $0 Awarded Supplemental Funding expenses through January 2022 (CESF) TN Agriculture TN Dept of 06/01/20 Enhancement 2930 2920 2930 2920 Awarded Requested funding to plant 26 trees along the riverbank at Trice Landing Agrculture Program 2020 Edward Byrne Annual share with Sherif's Office. CPD will purchase face shields and gas masks 08/17/20 Memorial Justice US DOJ $58,694 $0 Awarded for officer safety - county will purchase communication equipment, software and Grant JAG wireless communications services 2020 Assistance to US Dept of Federal funding to purchase new handheld and mobile radios for the fire 02/12/21 $768,052 $76,805 Submitted Firefighters Homeland Security epartment.  Investment Report Fiscal Year 2021 As of January 31, 2021 ISSUER NAME PAR VALUE CUSIP COUPON RATE LOCAL GOVERNMENT INVESTMENT POOL SELF-INSURANCE $ 592,783 0.160 CAPITAL PROJECTS FUNDS 1,746,676 0.160 INVESTMENT ACCOUNT 11,479,209 0.160 2016 BOND ISSUANCE 444,245 0.160 LGIP TOTAL / AVERAGE $ 14,262,912 0.160 2016 BOND ISSUANCE SELF-INSURANCE CAPITAL PROJECTS FUNDS INVESTMENT ACCOUNT  CDE Lightband Rolling 4 month Balance Sheet - Broadband Division January 31, 2021 1/31/20 % Change 1/31/21 12/31/20 11/30/20 10/31/20 Assets Current Assets: Cash -Operating Account $ 6,182,946.05 -3.99% $ 5,935,950.29 $ 5,254,139.95 $ 5,256,167.33 $ 4,872,419.06 Accounts Receivable: Subscribers, less allowance 1,457,037.97 13.82% 1,658,337.96 1,464,893.94 1,660,927.63 1,618,867.31 Other 28,940.80 57.41% 45,555.90 52,412.22 62,863.94 70,937.61 Temporary advances - Electric 2,075,870.24 -4.17% 1,989,208.81 2,327,257.39 2,066,689.10 2,101,752.24 Inventory 550,340.11 31.55% 723,998.96 819,908.15 819,504.95 639,420.15 Total Current Assets $ 10,295,135.17 0.56% $ 10,353,051.92 $ 9,918,611.65 $ 9,866,152.95 $ 9,303,396.37 Noncurrent Assets: Construction Work In Progress $ 39,319.54 1038.52% $ 447,659.69 $ 425,730.89 $ 48,440.64 $ 67,730.15 Telecommunications Plant 8,517,887.25 11.71% 9,515,441.09 9,432,300.20 9,416,777.54 9,347,830.20 Accumulated Depreciation (5,521,341.28) 6.44% (5,876,781.34) (5,823,886.10) (5,789,069.05) (5,826,348.70) Deferred Debit - Software & Outflows of Resources 459,361.48 -8.96% 418,179.82 455,962.75 456,627.06 454,559.99 Total Noncurrent Assets $ 3,495,226.99 28.88% $ 4,504,499.26 $ 4,490,107.74 $ 4,132,776.19 $ 4,043,771.64 Total Assets $ 13,790,362.16 7.74% $ 14,857,551.18 $ 14,408,719.39 $ 13,998,929.14 $ 13,347,168.01 Retained Earnings and Liabilities: Retained Earnings (Deficit): Retained Earnings - Beginning of Year $ 803,836.93 520.33% $ 4,986,471.41 $ 4,986,471.41 $ 4,986,471.41 $ 4,986,471.41 Retained Earnings - YTD 2,335,433.99 22.75% 2,866,702.40 2,316,585.58 1,822,643.42 1,355,434.83 Retained Earnings - Current 268,974.40 37.57% 370,023.65 550,116.82 493,942.16 467,208.59 Total Retained Earnings (Deficit) $ 3,408,245.32 141.27% $ 8,223,197.46 $ 7,853,173.81 $ 7,303,056.99 $ 6,809,114.83 Current Liabilities: Accounts Payable $ 2,315,093.95 -6.77% $ 2,158,454.07 $ 2,106,799.40 $ 2,197,276.64 $ 2,068,274.23 Unearned Revenue $ 682,497.65 17.45% $ 801,576.15 $ 801,576.15 $ 801,576.15 $ 801,576.15 Other Accrued Payables 285,018.50 7.45% 306,265.34 277,625.42 327,147.31 298,472.60 Total Current Liabilities $ 3,282,610.10 -0.50% $ 3,266,295.56 $ 3,186,000.97 $ 3,326,000.10 $ 3,168,322.98 Noncurrent Liabilities: Customer Deposits $ 1,287.48 -85.44% $ 187.48 $ 187.48 $ 187.48 $ 187.48 Postretirement Benefits 347,674.13 11.42% 387,387.55 388,874.00 389,201.44 389,059.59 Deferred Inflows of Resources 104,614.00 -19.18% 84,552.00 84,552.00 84,552.00 84,552.00 Long Term Debt to the Electric Division 6,645,931.13 -56.43% 2,895,931.13 2,895,931.13 2,895,931.13 2,895,931.13 Total Noncurrent Liabilities $ 7,099,506.74 -52.56% $ 3,368,058.16 $ 3,369,544.61 $ 3,369,872.05 $ 3,369,730.20 Total Liabilities $ 10,382,116.84 -36.10% $ 6,634,353.72 $ 6,555,545.58 $ 6,695,872.15 $ 6,538,053.18 Total Liabilities & Retained Earnings $ 13,790,362.16 7.74% $ 14,857,551.18 $ 14,408,719.39 $ 13,998,929.14 $ 13,347,168.01  CDE Lightband Income Statement - Broadband Division 1/31/2021 % 1/31/20 Change 1/31/21 12/31/20 11/30/20 10/31/20 Operating Revenue: Programming Revenue $ 450,116.78 -7.81% $ 414,969.76 $ 415,495.13 $ 416,623.11 $ 412,403.51 Internet Revenue 1,256,338.36 12.12% 1,408,599.09 1,392,030.55 1,367,329.99 1,352,879.91 Telephone Revenue 143,662.93 14.36% 164,292.84 160,055.46 158,800.91 158,891.67 Miscellaneous Fee Revenue 138,794.88 -6.75% 129,433.14 182,444.09 127,584.02 136,029.05 Total Operating Revenues 1,988,912.95 6.45% 2,117,294.83 2,150,025.23 2,070,338.03 2,060,204.14 Cost of Programming & Services 751,303.36 -0.10% 750,528.68 667,827.82 678,486.28 683,919.62 Gross Revenue: $ 1,237,609.59 10.44% $ 1,366,766.15 $ 1,482,197.41 $ 1,391,851.75 $ 1,376,284.52 Operating Expenses: Network Support Expense-Video $ 38,326.29 -1.72% $ 37,668.21 $ 31,928.00 $ 31,882.75 $ 31,864.33 Network Support Expense-Internet 141,213.22 3.95% 146,795.12 146,344.98 146,206.13 149,481.82 Network Support Expense-Phone 17,705.78 -11.99% 15,583.32 15,552.62 15,558.76 16,029.00 Network Admin. & Oper. Expense 130,249.45 -16.75% 108,432.38 114,365.38 137,276.60 111,157.80 Building & Office Expense 8,047.00 0.00% 8,047.00 8,047.00 8,047.00 8,047.00 Depreciation & Amortization Expense 105,071.45 -6.24% 98,519.69 100,548.50 103,262.72 89,283.35 General & Administrative Expense 167,126.36 21.32% 202,755.57 244,073.56 193,425.88 201,991.99 Station Apparatus Expense 195,913.24 14.68% 224,668.11 136,094.61 123,773.77 156,147.26 Customer Service Expense 58,770.19 11.45% 65,500.98 62,269.93 54,257.46 54,075.46 Marketing Expense 99,131.08 -18.96% 80,331.88 64,467.59 75,750.07 82,341.37 Total Operating Expenses $ 961,554.06 2.78% $ 988,302.26 $ 923,692.17 $ 889,441.14 $ 900,419.38 Operating Income (Loss) $ 276,055.53 37.10% $ 378,463.89 $ 558,505.24 $ 502,410.61 $ 475,865.14 Interest Expense 4,008.04 -39.39% 2,429.26 2,377.44 2,457.47 2,645.57 Other Expenses - Tax Equivalent 3,073.09 95.60% 6,010.98 6,010.98 6,010.98 6,010.98 Other Expense - Loss on Retirement of Equipment $ - $ - $ - $ - $ - Total Other Expenses (Income) $ 7,081.13 19.19% $ 8,440.24 $ 8,388.42 $ 8,468.45 $ 8,656.55 Net Income (Loss) $ 268,974.40 37.57% $ 370,023.65 $ 550,116.82 $ 493,942.16 $ 467,208.59 EBITDA $ 381,126.98 $ 476,983.58 $ 659,053.74 $ 605,673.33 $ 565,148.49  CDE Lightband Cash Flow Statement - Broadband Division January 31, 2021 RECONCILIATION OF OPERATING INCOME TO NET CASH PROVIDED BY OPER ACTIVITIES: Operating income (loss) $ 378,463.89 Adjustments to reconcile oper income to cash provided (used) by operating activities Depreciation and amortization 98,519.69 Changes in: Accounts receivable (186,587.70) Advances to Electric 338,048.58 Inventory 95,909.19 Accounts payable 51,654.67 Accrued expenses 27,153.47 Customer deposits - Other 29,342.69 Net Cash From Operating Activities 832,504.48 CASH FLOWS FROM FINANCING ACTIVITIES: Payment of long term debt - Additions to plant (150,694.14) Net Cash Used by Financing Activities (150,694.14) NET INCREASE IN CASH AND CASH EQUIVALENTS $ 681,810.34 CASH AND CASH EQUIVALENTS - BEG OF MONTH 5,254,139.95 CASH AND CASH EQUIVALENTS - END OF MONTH $ 5,935,950.29  CDE Lightband Rolling 4 Month Balance Sheet - Electric Division January 31, 2021 Prior Year 1/31/2020 % Change 1/31/2021 12/31/2020 11/30/2020 10/31/2020 UTILITY PLANT 1 Electric Plant $ 307,916,645.32 5.75% $ 325,621,433.00 $ 324,822,037.88 $ 323,619,005.70 $ 322,476,696.71 2 Less Depreciation (105,371,738.29) 7.69% (113,475,523.49) (112,480,091.90) (111,489,853.49) (110,615,736.69) 3 Total $202,544,907.03 4.74% $212,145,909.51 $212,341,945.98 $212,129,152.21 $211,860,960.02 4 Unamortized acq. adj. 51,077.01 -70.59% 15,022.65 18,027.18 21,031.71 24,036.24 6 Total Plant - Net $202,595,984.04 4.72% $212,160,932.16 $212,359,973.16 $212,150,183.92 $211,884,996.26 OTHER PROPERTY AND INVESTMENTS 8 Interdivisional loan 6,645,931.13 -56.43% 2,895,931.13 2,895,931.13 2,895,931.13 2,895,931.13 9 Sinking Funds 8,515,130.42 4.61% 8,907,749.38 8,907,088.70 7,906,614.45 6,906,259.73 12 Other Special Funds - - - - - 13 Total 15,161,061.55 -22.14% 11,803,680.51 11,803,019.83 10,802,545.58 9,802,190.86 CURRENT AND ACCRUED ASSETS 14 General Cash/temp cash investments 7,194,544.01 33.01% 9,569,157.24 15,541,650.85 11,512,604.69 9,721,720.78 14.1 Reserved Cash 24,775,088.86 -14.34% 21,222,860.06 21,063,156.76 23,006,728.40 23,000,278.86 15 Accounts Receivable 11,168,075.66 33.71% 14,933,023.02 13,204,477.69 11,061,117.27 11,749,601.49 16 Materials and Supplies 3,963,458.05 -20.71% 3,142,455.26 3,288,709.97 3,210,672.47 3,135,879.05 18 Other Current Assets 24,856,935.56 3.83% 25,809,458.64 17,977,681.85 18,253,523.17 21,528,282.36 19 Total 71,958,102.14 3.78% 74,676,954.22 71,075,677.12 67,044,646.00 69,135,762.54 DEFERRED DEBITS 22 Clearing Accounts 25,148.97 15,089.49 15,927.78 16,766.07 17,604.36 24 Energy Service Loans Rec 1,967,971.58 -36.86% 1,242,565.44 1,300,405.22 1,359,354.09 1,422,771.40 26 Other Deferred Debits 4,345,780.64 -11.95% 3,826,458.81 3,723,922.96 3,881,531.33 4,423,401.48 27 Total 6,338,901.19 -19.80% 5,084,113.74 5,040,255.96 5,257,651.49 5,863,777.24 28 TOTAL ASSETS & OTHER DEBITS $296,054,048.92 2.59% $303,725,680.63 $300,278,926.07 $295,255,026.99 $296,686,726.90 CAPITAL EARNINGS REINVESTED IN SYSTEM ASSETS 33 Beginning of year 181,656,853.69 5.53% 191,710,376.76 191,710,376.76 191,710,376.76 191,710,376.76 34 Current Year to Date 6,250,073.47 49.21% 9,325,607.39 7,473,427.09 6,515,374.82 6,686,216.66 35 Total 187,906,927.16 6.99% 201,035,984.15 199,183,803.85 198,225,751.58 198,396,593.42 Long Term Debt 39.1 Bonds and other Long Term Debt 59,540,000.00 -5.30% 56,385,000.00 56,385,000.00 56,385,000.00 56,385,000.00 40 Debt Premium and discount 7,685,904.94 -7.72% 7,092,684.94 7,142,119.94 7,191,554.94 7,240,989.94 41 Total 67,225,904.94 -5.58% 63,477,684.94 63,527,119.94 63,576,554.94 63,625,989.94 OTHER NON-CURRENT LIABILITIES 39.2 Post Retirement Benefits 1,608,934.90 6.00% 1,705,489.69 1,712,505.05 1,716,306.94 1,719,579.88 42 Energy Service Loans - Advances 2,053,407.99 -36.20% 1,310,001.16 1,366,459.76 1,430,437.27 1,485,698.28 44 Total 3,662,342.89 -17.66% 3,015,490.85 3,078,964.81 3,146,744.21 3,205,278.16 CURRENT AND ACCRUED LIABILITIES 46 Accounts Payable 25,901,677.14 -6.15% 24,307,942.72 22,924,070.60 18,588,314.05 20,070,307.87 47 Customer Deposits 6,999,310.12 4.80% 7,335,143.00 7,318,773.71 7,314,028.67 7,280,496.15 52.2 Interest Accrued - Other 1,083,463.50 -3.50% 1,045,510.25 836,408.20 627,306.15 418,204.10 53 Other Current Liabilities 3,274,423.17 7.13% 3,507,924.72 3,409,784.96 3,776,327.39 3,689,857.26 54 Total 37,258,873.93 -2.85% 36,196,520.69 34,489,037.47 30,305,976.26 31,458,865.38 58 TOTAL LIABILITIES AND OTHER CREDITS $ 296,054,048.92 2.59% $ 303,725,680.63 $ 300,278,926.07 $ 295,255,026.99 $ 296,686,726.90  CDE Lightband Revenues and Expenses ‐ Electric Division 1/31/2021 Prior Year Prior 3 Months 1/31/2020 % Change 1/31/2021 12/31/2020 11/30/2020 10/31/2020 OPERATING REVENUE 59 Electric Sales Revenue 14,497,796.21 9.33% 15,851,047.82 14,498,894.87 10,881,361.61 11,412,614.53 60 Revenue from Late Payments 148,603.08 ‐21.81% 116,186.99 112,822.00 69,374.46 106,917.34 61 Misc Service Revenue 131,357.04 ‐29.86% 92,134.07 85,801.18 121,883.00 74,170.12 62 Rent from Electric Property 311,468.49 2.05% 317,842.93 316,295.65 249,623.30 314,601.01 63 Other Electric Revenue (195.64) ‐100.46% 0.90 1.05 0.46 0.73 64 Total Operating Revenue 15,089,029.18 8.54% 16,377,212.71 15,013,814.75 11,322,242.83 11,908,303.73 PURCHASED POWER 65 Total Power Cost 11,276,159.88 ‐2.92% 10,946,472.08 10,801,932.98 8,226,007.50 7,321,610.16 OPERATING EXPENSE 66 Transmission Expense 4,994.95 ‐35.30% 3,231.84 4,165.91 2,407.66 3,947.11 67 Distribution Expense 432,649.21 ‐26.68% 317,232.19 378,077.91 170,481.32 314,696.79 68 Customer Accounts Expense 337,991.94 ‐1.56% 332,708.54 173,894.47 303,574.23 335,998.64 69 Cust. Service and Inf. Exp. 34,769.86 ‐2.72% 33,823.37 35,139.57 26,884.64 51,277.07 70 Sales Expense 12,326.47 ‐14.02% 10,597.82 11,402.40 9,207.84 8,639.62 71 Admin. And General Expense 481,954.44 7.94% 520,231.58 279,959.00 430,112.02 403,818.02 72 Operating Expense 1,304,686.87 ‐6.66% 1,217,825.34 882,639.26 942,667.71 1,118,377.25 MAINTENANCE EXPENSE 73 Transmission Expense 5,842.08 ‐0.28% 5,825.76 5,613.88 2,734.78 4,542.27 74 Distribution Expense 690,492.38 ‐61.37% 266,735.56 332,883.18 225,505.62 291,245.50 75 Admin. and General Expense 235,012.20 ‐22.36% 182,460.32 202,363.01 222,125.31 177,972.18 76 Maintenance Expense 931,346.66 ‐51.14% 455,021.64 540,860.07 450,365.71 473,759.95 OTHER OPERATING EXPENSE 77 Depreciation Expense 1,066,093.88 9.97% 1,172,364.44 1,171,444.94 1,142,284.66 1,142,748.96 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 567,466.90 1.24% 574,517.52 604,283.48 572,130.55 569,164.91 80 Total other oper. Expense 1,636,565.31 6.92% 1,749,886.49 1,778,732.95 1,717,419.74 1,714,918.40 Total operating expense and 81 purchased power 15,148,758.72 ‐5.15% 14,369,205.55 14,004,165.26 11,336,460.66 10,628,665.76 INCOME 82 Operating Income (59,729.54) ‐3461.83% 2,008,007.16 1,009,649.49 (14,217.83) 1,279,637.97 83 Other Income 50,685.13 ‐52.55% 24,048.48 128,251.33 23,191.13 24,325.77 84 Total Income (9,044.41) ‐22567.53% 2,032,055.64 1,137,900.82 8,973.30 1,303,963.74 85 Misc Income Deductions (425.00) ‐ ‐ ‐ ‐ 86 Net Income before debt expense (9,469.41) ‐21559.16% 2,032,055.64 1,137,900.82 8,973.30 1,303,963.74 DEBT EXPENSE 90 Interest on Long Term Debt 235,270.09 ‐3.23% 227,679.44 227,679.44 227,679.44 227,679.44 92 Other Interest Expense 1,551.68 5.11% 1,630.90 1,604.11 1,570.70 1,603.96 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,386.77 ‐4.01% 179,875.34 179,848.55 179,815.14 179,848.40 NET INCOME 96 Income before Extraord. Items (196,856.18) ‐1040.88% 1,852,180.30 958,052.27 (170,841.84) 1,124,115.34 97 Extraordinary Items ‐ ‐ ‐ ‐ ‐ 98 Net Income (196,856.18) ‐1040.88% 1,852,180.30 958,052.27 (170,841.84) 1,124,115.34  CDE Lightband Cash Flow Statement - Electric Division January 31, 2021 RECONCILIATION OF OPERATING INCOME TO NET CASH PROVIDED BY OPER ACTIVITIES: Operating income $ 2,008,007.16 Adjustments to reconcile oper income to cash provided (used) by operating activities Depreciation and amortization 1,175,368.97 Changes in: Accounts receivable (1,728,545.33) Materials and supplies 146,254.71 Interdivisional loan - Accounts receivable - TVA Energy Service Loans 57,839.78 Advances - TVA Energy Service Loans (56,458.60) Prepayments - Other current assets (8,089,301.21) Accounts payable 1,383,872.12 Accrued expenses 209,102.05 Customer deposits 16,369.29 Other postemployment benefits (7,015.36) Other 98,139.76 Net Cash Used by Operating Activities (4,786,366.66) CASH FLOWS FROM FINANCING ACTIVITIES: Additions to plant (976,327.97) Payment of long-term debt (49,435.00) Net Cash used by Financing Activities (1,025,762.97) NET DECREASE IN CASH AND CASH EQUIVALENTS $ (5,812,129.63) CASH AND CASH EQUIVALENTS - BEG OF MONTH 45,511,896.31 CASH AND CASH EQUIVALENTS - END OF MONTH $ 39,699,766.68 CASH AND CASH EQUIVALENTS CONSIST OF: Sinking Funds 8,907,749.38 Construction Funds - General cash/temp cash investments 9,569,157.24 Reserved Cash 21,222,860.06 $ 39,699,766.68 CDE Lightband Subscriber Analysis November 2020 - January 2021 November Actual December Actual January Actual G r o w Net Gain November Growth % Net Gain December Growth % Net Gain January Growth % t November November November Over Prev. % Growth Prior Year Year Over December December December Over Prev. % Growth Prior Year Year Over January January January Over Prev. % Growth Prior Year Year Over Service h Actual Budget Variance Month to Budget Actual Year Actual Budget Variance Month to Budget Actual Year Actual Budget Variance Month to Budget Actual Year Video (Total) 5,191 5,254 (63) 14 -1% 5,146 1% 5,191 5,242 (51) 0 -1% 5,070 2% 5,219 5,223 (4) 28 0% 4,955 5% Lightband Basic 356 329 27 (5) 8% 371 -4% 354 329 25 (2) 8% 373 -5% 351 326 25 (3) 8% 375 -6% Lightband Plus 1,713 1,763 (50) (8) -3% 1,923 -11% 1,725 1,756 (31) 12 -2% 1,915 -10% 1,705 1,747 (42) (20) -2% 1,881 -9% Lightband Extra 2,314 2,437 (123) (15) -5% 2,821 -18% 2,280 2,433 (153) (34) -6% 2,751 -17% 2,266 2,428 (162) (14) -7% 2,664 -15% Streaming Services 779 697 82 42 0% 0 803 696 107 24 0% 0 868 694 174 65 0% 0 Other Pkgs 29 28 1 0 4% 31 -6% 29 28 1 0 4% 31 -6% 29 28 1 0 4% 35 -17% Internet (Total) 23,585 23,625 (40) 135 0% 21,887 8% 23,713 23,760 (47) 128 0% 21,894 8% 24,020 23,904 116 307 0% 21,904 10% Residential Internet 21,806 21,771 35 123 0% 20,249 8% 21,909 21,900 9 103 0% 20,251 8% 22,192 22,029 163 283 1% 20,243 10% Business Internet 1,779 1,854 (75) 12 -4% 1,638 9% 1,804 1,860 (56) 25 -3% 1,643 10% 1,828 1,875 (47) 24 -3% 1,661 10% Phone (Total) 2,534 2,570 (36) (1) -1% 2,549 -1% 2,533 2,498 35 (1) 1% 2,544 0% 2,538 2,564 (26) 5 -1% 2,527 0% Residential Phone 1,715 1,735 (20) (7) -1% 1,789 -4% 1,704 1,729 (25) (11) -1% 1,782 -4% 1,706 1,723 (17) 2 -1% 1,768 -4% Business Phone 819 835 (16) 6 -2% 760 8% 829 769 60 10 8% 762 9% 832 841 (9) 3 -1% 759 10% Total Broadband Customers 24,386 24,702 (316) 130 -1% 23,007 6% 24,534 24,832 (298) 148 -1% 23,014 7% 24,774 25,042 (268) 240 -1% 23,407 6%  ​ORDINANCE 74-2020-21 AN ORDINANCE AMENDING THE OPERATING BUDGET FOR FISCAL YEAR 2021 FOR GOVERNMENTAL FUNDS (ORDINANCE 39-2020-21) TO ADD FUNDING TO SUPPORT THE JUNETEENTH HOLIDAY WHEREAS, Article VII, Section 3 of the official charter of the City of Clarksville provides for the approval and adoption of a budget; and WHEREAS, Article VII, Section 3 of the official charter of the City of Clarksville provides for the ability to amend the adopted budget by ordinance by the City Council at any time during the fiscal year by vote of a majority of the City Council on two (2) separate readings; and WHEREAS, The City Council has approved the addition of the Juneteenth holiday to the City’s Code, Section 1.5-1501 Holidays; and WHEREAS, Juneteenth is has become recognized nationally as a celebration commemorating the end of slavery in the United States; and WHEREAS, This City Council believes it is fitting and proper for all Clarksvillian’s to celebrate this historic milestone toward achieving the American ideal that “all men are created equal; and WHEREAS, The City Council further urges all citizens to celebrate its freedom and exercise their rights to all the opportunities and resources available in this community. NOW, THEREFORE, BE IT ORDAINED BY THE CITY COUNCIL OF THE CITY OF CLARKSVILLE, TENNESSEE: That the following Amendment be made: General Fund 10491003 – 4869 – Transfer to Transit Increase $18,220 10422001 – 4132 - Fire Department Overtime Increase $62,183 10422001 – 4221 - Fire Department Taxes Increase $ 4,757 10422001 – 4231 - Fire Department TCRS Increase $11,703 10421001 – 4132 - Police Department Overtime Increase $44,387 10421001 – 4221 - Police Department Taxes Increase $ 3,396 10421001 – 4231 - Police Department TCRS Increase $ 8,354 BE IT FURTHER ORDAINED that above $153,000 shall be provided from the fund balance of the General Fund​. FIRST READING: SECOND READING: EFFECTIVE DATE:  ORDINANCE 75-2020-21 AN ORDINANCE AMENDING THE FY2021 HOUSING AND COMMUNITY DEVELOPMENT BUDGET (ORDINANCE 87-2019-20) AUTHORIZING THE CITY OF CLARKSVILLE TO CREATE A PROJECT OF $16,250 TO INCLUDE THE 2021 COMMUNITY HOUSING PARTNERSHIP OF WILLIAMSON COUNTY THDA GRANT WHEREAS, the Housing and Community Development office of the City of Clarksville has been awarded funding from THDA, and; WHEREAS, the grant period is to be effective from April 27, 2020 to December 31, 2020. NOW, THEREFORE, BE IT ORDAINED BY THE CITY COUNCIL OF THE CITY OF CLARKSVILLE, TENNESSEE: That the following projects be created within the ESG (Emergency Solutions Grant) Fund: 82463003 4810 YPK20 Subrecipient: YAIPak’s 2020 Increase: $8,600 82463003 4810 R4120 Subrecipient: Right For One 2020 Increase: $7,650 BE IT FURTHER ORDAINED: That the following ESG be budgeted: 8246300 33150 Grant Revenue Increase: $16,250 FIRST READING: SECOND READING: EFFECTIVE DATE: