Muyni
← Back to Clarksville

Finance Committee

Regular Meeting

Clarksville, TN · October 26, 2021

AgendaMinutes

Minutes

FINANCE COMMITTEE October 26, 2021 MINUTES CALL TO ORDER The monthly meeting of the City of Clarksville Finance Committee was called to order by Chairperson Streetman on Tuesday, October 26, 2021, at 4:30 p.m. in the City Hall Conference Room, 1 Public Square, Clarksville, Tennessee. ATTENDANCE: PRESENT: Travis Holleman, Karen Reynolds, Wanda Smith, Stacey Streetman ABSENT: Wallace Redd ADOPTION OF MINUTES Councilperson Holleman made a motion to adopt the September 28 minutes as presented. The motion was seconded by Councilperson Reynolds. A voice vote was taken; the motion passed without objection. PURCHASING DEPARTMENT Director of Purchasing Camille Thomas reported that there were 17 properties for sale at public auction. Of those 17 properties, 15 sold for over asking price for all but one property. $241,000 was brought in from the sale and part of those funds will go towards paying off taxes owed to the City and County. She also shared the monthly bid summary and reported award of the following professional service contracts: Report of award of professional service contracts 1. G&W - Design of the Ivy Bend Impressed Current Cathodic Protection System from Southern Cathodic Protection Company in the amount of $22,820.00. 2. Project Management - Design and Construction Administration for the Smith Trahern Rehabilitation Project from Lyle-Cook-Martin in the amount of $26,368.88. 3. Fire Rescue - Engineering Design for the Sewer Main Extension for Station #8 from McKay-Burchett & Co. Engineers in the amount of $4,500.00. Sale of Surplus Property on GovDeals.com for the month of September 2021 - $16,790.00. GENERAL GOVERNMENT Chief Financial Officer Laurie Matta said expenditures were exceeding revenues by $4.3 million and waiting for tax revenue to come in, and noted this situation was typical for the beginning of a fiscal year. Expenditures are up by 12.8% which is also typical at the beginning of the year. Local option sales tax increased 12% over last year and is on trend. Ms. Matta also reported that the City has received two grant awards. Ms. Reynolds asked who determines how that grant money is spent. Ms. Matta explained a committee will be formed and the Mayor said they are waiting on the final rules and process before they can set up an avenue for input. DEPARTMENT OF ELECTRICITY On behalf of Chief Financial Officer David Johns, Christy Batts reported on the Electric Division first and said it was an average month with regards to electric plant. For revenue and expenses, she said monthly revenue was $16.8 million and purchasing power expenses was $9.8 million. The month ended with $3 million in net income and they attribute it to the weather. Ms. Batts then reported on Broadband. She said there was a reduction in earnings due to increased rental rates for the fiber network and cost allocations and those numbers went up over 50% in overall costs. For the income statement, operating revenue came in at $375,000. CITY ATTORNEY City Attorney Lance Baker reported payment of the following legal expenditures. Mr. Baker said the amount listed for Batson Nolan, Nicholson v. City was an error, as that is from the month prior. The correct amount is $9,950. ● Bradley Arant, Kimberly Black v. City, $6,755.00 ● Bradley Arant, Robinson v. City, $19,871.65 ● Batson Nolan, Nicholson v. City, $27,613.50 ● Batson Nolan, Robinson v. City, $4,450.00 ● Howell & Fisher, Robinson v. City, Pitts, & Baker, $2,662.50 ● Klein Solomon, Ethics Complaint, $5,220.00 ● Burr Forman, TN River Keepers, $118.50 CITY COUNCIL ACTION 1. FINANCE Mr. John Hillborn explained the HVAC system is a proprietary system through Siemens and, come January, will no longer be supported. Ms. Reynolds asked if it would be cheaper to buy new. Mr. Hillborn said it would be significantly higher in price vs repairing. Ms. Matta said a special-called session will be called prior to Regular Session on Thursday, November 4. a) ORDINANCE -2021-22 (First Reading) Amending the Operating and Capital Budgets for Fiscal Year 2022 for Governmental Funds (ORDINANCE 130-2021-22) to repair the City Hall air conditioning (Hvac) system. Finance Committee: Approval Councilperson Holleman made a motion for approval by the Finance Committee. Councilperson Reynolds seconded the motion. Motion Passed. AYE: Holleman, Reynolds, Streetman NAY: None PUBLIC COMMENTS There were no public comments ADJOURNMENT The meeting was adjourned at 4:59 p.m. ADOPTED: November 23, 2021 ____________________________ Stacey Streetman, Chair ____________________________ Lisa Canfield, Recorder

Agenda

FINANCE COMMITTEE AGENDA DATE: October 26, 2021 TIME: 4:30 p.m. LOCATION: City Hall Conference Room 1 Public Square, 4th Floor 1) CALL TO ORDER 2) ATTENDANCE 3) ADOPTION OF MINUTES: September 28 4) DEPARTMENT REPORTS 1. PURCHASING Camille Thomas a) Public Auction Report b) Report of bids c) Report of award of professional service contracts 1. G&W - Design of the Ivy Bend Impressed Current Cathodic Protection System from Southern Cathodic Protection Company in the amount of $22,820.00. 2. Project Management - Design and Construction Administration for the Smith Trahern Rehabilitation Project from Lyle-Cook-Martin in the amount of $26,368.88. 3. Fire Rescue - Engineering Design for the Sewer Main Extension for Station #8 from McKay-Burchett & Co. Engineers in the amount of $4,500.00. Sale of Surplus Property on GovDeals.com for the month of September 2021 - $16,790.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, $6,755.00 ● Bradley Arant, Robinson v. City, $19,871.65 ● Batson Nolan, Nicholson v. City, $27,613.50 ● Batson Nolan, Robinson v. City, $4,450.00 ● Klein Solomon, Ethics Complaint, $5,220.00 ● Burr Forman, TN River Keepers, $118.50 5) CITY COUNCIL ACTION 1. FINANCE a) ORDINANCE -2021-22 (First Reading) Amending the Operating and Capital Budgets for Fiscal Year 2022 for Governmental Funds (ORDINANCE 130-2021-22) to repair the City Hall air conditioning (Hvac) system. Finance Committee: 6) PUBLIC COMMENTS (allows 3 persons; 5 minutes each) 7) ADJOURNMENT FINANCE COMMITTEE September 28, 2021 MINUTES CALL TO ORDER The rescheduled monthly meeting of the City of Clarksville Finance Committee was called to order by Chairperson Streetman on Tuesday, September 28, 2021, at 4:30 p.m. in the City Hall Conference Room, 1 Public Square, Clarksville, Tennessee. ATTENDANCE: PRESENT: Travis Holleman, Wallace Redd, Karen Reynolds, Stacey Streetman ADOPTION OF MINUTES Councilperson Redd made a motion to adopt the August 24 and August 31 minutes as presented. The motion was seconded by Councilperson Holleman. A voice vote was taken; the motion passed without objection. PURCHASING DEPARTMENT Director of Purchasing Camille Thomas shared the monthly bid summary and reported award of the following professional service contracts: ● Gas and Water - Design of the High Point Road LP Natural Gas Main Extensions from Clark Engineering & Utility Solutions, LLC in the amount of $84,100.00. ● Gas and Water - North Clarksville Water Treatment Plant Construction Monitoring & Testing Services from TTL, Inc. in the amount of $2,485,291.55. ● Gas and Water - Fee Increase on the Miscellaneous Engineering & Surveying Services in support of Capital Improvement Projects contract with Suiter Surveying & Land Planning in the amount of $30,000.00 for a total cost of $80,000.00. Mr Riggins said this agreement is for various services - any surveys or engineering services. ● Recreation / Project Management - Exit 8 Athletic Complex Road Design from TTL, Inc. in the amount of $533,030.00. ● Recreation / Project Management - National Pollutant Discharge Elimination System, Stormwater Pollution Prevention Plan and Aquatic Resource Alteration Permit for the Exit 8 Athletic Complex Project from ECS in the amount of $8,000.00. ● Housing and Community Development - Appraisal of 114-116 S. 11th Street from Mark Young Real Estate Appraisals in the amount of $600.00. ● Housing and Community Development - Grant Writing Application Assistance for a Lead-Based Hazard Program from Vy Cornett in the amount of $2,800.00. ● Parking - Peer Review of Data and Testing Methods for the Cumberland Parking Garage Performed by Neely Engineering from K & S Engineering in the amount of $20,550.00. Councilperson Reynolds asked for an explanation. Ms. Thomas said the City was asked by a third party to review the recommendations made by Neely Engineering for the parking garage. ● Project Management - Environmental Study and Categorical Exclusion Required by the FAA for the Property to be Conveyed to the City by the Regional Airport Authority from Goodwyn, Mills, Cawood, LLC in the amount of $6,000.00. Ms. Thomas reported sales of surplus on GovDeals.com in the amount of $13,616.99 during August 2021. GENERAL GOVERNMENT Chief Financial Officer Laurie Matta reported on the monthly financials through August 21, 2021. Expenditures currently exceed revenues by $2.4 million dollars and noted this situation was typical for the beginning of a fiscal year. Revenue collections were slightly higher than the previous year for the same period by $350,000. Local Option Sales Taxes are on trend with the budget, and the Fund Balance is at 23.4% DEPARTMENT OF ELECTRICITY David Johns reported the following financials for the Electric and Broadband Divisions through the month of August: CDE will exceed $400 million in Gross Plant due to growth, YTD revenues matched last year at $3.2 million, and Net Income came in at $1.6 million, which is slightly less than last year. Broadband: Cash is up to $6 million, and they are on track to beat $8 million this year, earnings YTD income numbers are less than last year as fiber rent increased ($120,000/month). Net Income is $378,000 and Net Cash showed an increase at $550,000. CITY ATTORNEY City Attorney Lance Baker reported payment of the following legal expenditures and announced he would update all members of the City Council on the status of each case during the next regular session. ● Bradley Arant, Kimberly Black v. City, $70.00 ● Bradley Arant, Robinson v. City, $7,706.25 ● Bradley Arant, Employment Matters, $855.00 ● Batson Nolan, Nicholson v. City, $27,613.50 ● Batson Nolan, Robinson v. City, $1,025.00 ● Burr Forman, Tennessee Riverkeepers, $632.00 ● Klein Solomon, Ethics Complaint, $7,060.79 5) CITY COUNCIL ACTION 1. CITY COUNCIL LEGISLATION a) ORDINANCE 30-2021-222 (First Reading) Amending the official code Title 1, Chapter 2, Section 204 relative to presenting legislation and deliberation of city council members to maximize efficiency Councilperson Holleman Councilperson Holleman said this would affect Regular Session only and is to provide efficiencies for meetings. Concerns were shared that this will cut into their time to answer and that the ordinance is not clear. Mr. Baker suggested the ordinance be amended to include an inclusion that answering a fellow council member’s question will not be attributed to their allotted time. There was also concern about the number of items on the agenda and not necessarily how long a person talks that is affecting the length of meetings.. After much discussion, the following voice vote was taken: Councilperson Holleman made a motion for approval by the Finance Committee. The motion was seconded by Councilperson Redd. Motion failed for a lack of a majority, however the Ordinance can still move forward to Council. AYE: Holleman, Redd NAY: Reynolds Streetman 2. FINANCE a) ORDINANCE 27-2021-22 (First Reading) Authorizing a utility and ingress and egress easement to Bellsouth Telecommunications, LLC/D/B/A AT&T Tennessee at the intersection of Whitfield Rd., and Needmore Rd. Councilperson Holleman made a motion for approval by the Finance Committee. The motion was seconded by Councilperson Reynolds. A voice vote was taken. Motion passed unanimously. AYE: Holleman, Redd, Reynolds, Streetman 3. PURCHASING a) ORDINANCE 32-2021-22 (First Reading) Authorizing the sale of property located at 803 Howard Street to Marlon Placid Camille Thomas Mr. Placid realized the driveway was on the property the City owns after he built the driveway. He would like to purchase the property and has agreed to pay $7,300. Councilperson asked how we obtained the property and Ms. Thomas said it was through a tax sale and he would be paying today’s rate per appraisal. Councilperson also asked about using the land for low income housing. The general consensus was that this lot has been sitting on the books for quite some time and this brings revenue to the City. Councilperson Reynolds made a motion for approval by the Finance Committee. The motion was seconded by Councilperson Holleman. A voice vote was taken. Motion passed. AYE: Holleman, Redd, Streetman NAY: Reynolds PUBLIC COMMENTS There were no public comments ADJOURNMENT The meeting was adjourned at 5:16 p.m. ADOPTED: _____________________________ Stacey Streetman, Chair ___________________________ Lisa Canfield, Recorder Minutes prepared by Lisa Canfield Department of Finance & Revenue September 2021 Financial Review Fiscal Year 2022 Clarksville, Tennessee September 30, 2021 General Fund Revenues vs. Expenditures Fiscal Year 2022 As of September 30, 2021 FY 2022 Monthly FY 2022 Revenues Expenditures Variance July $ 6,184,565 $ 6,911,062 $ (726,498) August 5,852,474 7,489,536 (1,637,062) September 6,580,879 8,511,419 (1,930,540) October - November - December - January - February - March - April - May - June - YTD Total $ 18,617,918 $ 22,912,017 $ (4,294,100) $9,000,000 $8,000,000 $7,000,000 $6,000,000 $5,000,000 FY 2022 Revenues $4,000,000 FY 2022 Expenditures $3,000,000 $2,000,000 $1,000,000 $- July August September General Fund Revenue Comparison Fiscal Year 2022 As of September 30, 2021 FY 2022 FY 2021 Variance Revenue Revenue July $ 6,184,565 $ 5,954,091 $ 230,474 August 5,852,474 $ 5,730,068 122,406 September 6,580,879 $ 4,725,612 1,855,267 October - November - December - January - February - March - April - May - June - YTD Total $ 18,617,918 $ 16,409,771 $ 2,208,147 $21,000,000 $19,000,000 $17,000,000 $15,000,000 $13,000,000 FY2021 YTD Revenue FY2022 YTD Revenue $11,000,000 FY2022 YTD Budgeted Revenue $9,000,000 $7,000,000 $5,000,000 $3,000,000 July August September GENERAL FUND REVENUES Fiscal Year 2022 As of September 30, 2021 Total Budget YTD Month TAXES Prior Year Property Taxes 1,220,925 275,931 102,785 2021 Property Taxes 42,194,386 - - PiLOTS 582,925 - - Local Option Sales Tax 22,133,534 5,882,837 1,847,268 Beer & Liquor Tax 5,210,004 1,294,039 423,659 Business License 3,650,499 236,361 79,782 Franchise Tax (cable) 1,576,004 229,318 1,849 Hotel/Motel 342,182 136,227 52,615 Other Taxes 317,247 62,559 16,538 TOTAL TAXES 77,227,706 8,117,272 2,524,495 LICENSES AND PERMITS Building Permits 3,444,000 1,034,980 358,417 Other Permits 145,205 28,640 9,310 TOTAL PERMITS 3,589,205 1,063,620 367,727 INTERGOVERNMENTAL Grant reimbursements 1,410,647 158,050 158,050 State Shared Revenues TVA Replacement Tax 1,568,562 - - State Sales Tax 13,558,758 3,846,015 1,242,766 State Street Aid 5,630,532 1,380,083 450,255 Other Taxes 1,992,229 535,037 127,195 TOTAL INTERGOVERNMENTAL 24,160,728 5,919,185 1,978,267 OTHER REVENUES Charges for Services 881,213 161,147 47,708 Recreation 548,240 141,728 23,739 Golf Courses 753,250 282,684 88,080 Fines and Forefeitures 615,893 119,487 34,849 Investment & Interest Earnings 30,100 2,176 710 Other Misc. Revenues 373,500 315,713 253,990 Transfer from CDE 5,381,250 1,352,120 533,258 Transfer From CGW 4,298,532 1,074,633 716,422 Other Transfers 3,947,692 68,152 11,636 TOTAL OTHER REVENUES 16,829,670 3,517,840 1,710,391 TOTAL REVENUES GENERAL FUND 121,807,309 18,617,918 6,580,879 General Fund Expenditure Comparison Fiscal Year 2022 As of September 30, 2021 FY 2022 FY 2021 Variance Expenditures Expenditures July $ 6,911,062 $ 7,000,858 $ (89,796) August 7,489,536 $ 5,813,328 1,676,208 September 8,511,419 $ 7,493,615 1,017,804 October - November - December - January - February - March - April - May - June - YTD Total $ 22,912,017 $ 20,307,800 $ 2,604,217 $32,000,000 $27,000,000 $22,000,000 FY2021 YTD Expenditures FY2022 YTD Expenditures $17,000,000 FY2022 YTD Budgeted $12,000,000 Expenditures $7,000,000 $2,000,000 July August September General Fund Year-to-Date Departmental Budget vs. Actual Expenditures Fiscal Year 2022 As of September 30, 2021 $30,000,000 Expenditures Estimated Variance Departmental: FY 2022 YTD YTD Budget (Over)Under $25,000,000 Police $ 7,723,256 $ 9,376,571 $ 1,653,316 $20,000,000 Fire 4,341,890 5,661,492 1,319,602 $15,000,000 FY 2022 Actual Highway & Street 3,090,359 4,322,149 1,231,790 YTD $10,000,000 Parks & Rec. & Golf 1,774,068 2,276,618 502,549 Building & Codes 511,790 563,408 51,617 $5,000,000 Info. Technology 833,105 576,933 (256,172) FY2022 Total $0 Finance 365,293 474,378 109,085 Budget Building Maintenance 207,287 321,850 114,562 City Garage 240,864 336,285 95,421 Municipal Properties 121,803 206,764 84,961 Human Resources 240,851 379,012 138,160 Legislative / Admin. 132,436 158,646 26,210 Mayor's Office 168,169 185,427 17,259 City Court 75,231 117,120 41,889 $1,100,000 Legal 82,187 135,103 52,915 $1,000,000 $900,000 Internal Audit 42,857 105,151 62,293 $800,000 Purchasing 41,698 52,891 11,194 $700,000 Departmental Total 19,993,144 25,249,796 5,256,652 $600,000 $500,000 FY 2022 $400,000 Actual YTD Nondepartmental: $300,000 Debt 1,369,822 2,723,341 1,353,519 $200,000 FY2022 Total $100,000 Capital Projects - 1,316,759 1,316,759 $0 Budget Transit 1,000,537 473,370 (527,167) Retirees 74,104 521,620 447,515 Other 474,410 479,289 4,878 YTD Total $ 22,912,017 $ 30,764,174 $ 7,852,156 Schedule of Sales Tax Collections Fiscal Year 2022 As of September 30, 2021 City of Clarksville Local Sales & Use Tax Net Collections Net Collections Net Collections Net Collections FY 2019 FY 2020 FY 2021 FY 2022 July $ 1,524,372 $ 1,607,009 $ 1,840,352 $ 2,112,811 August 1,552,311 1,584,610 1,836,659 2,118,112 September 1,461,197 1,553,548 1,747,769 1,935,724 October November December January February March April May June YTD Total $ 4,537,880 $ 4,745,167 $ 5,424,780 $ 6,166,647 City of Clarksville $6,500,000 $5,500,000 $4,500,000 $3,500,000 $2,500,000 $1,500,000 $500,000 FY 2019 FY 2020 FY 2021 FY 2022 Local Sales Tax Collections Fiscal Year 2022 As of September 30, 2021 TOTAL NET COLLECTIONS PAID TO GROSS COLLECTIONS UNICORPORATED NET COLLECTIONS COUNTY CITY CITY ROADS SCHOOLS AREA CITY LIMITS PAID TO STATE July $ 8,433,496 $ 110,532 $ 2,014,008 $ 98,803 $ 6,210,153 $ 535,248 $ 7,994,204 $ 95,956 August 8,363,509 114,459 2,021,561 96,551 6,130,939 646,757 7,811,912 95,160 September 7,883,493 124,636 1,847,268 88,456 5,823,133 816,188 7,157,003 89,698 October - November - December - January - February - March - April - May - June - YTD TOTAL $ 24,680,498 $ 349,626 $ 5,882,836 $ 283,811 $ 18,164,225 $ 1,998,193 $ 22,963,120 $ 280,815 Monthly Distribution 1.58% 23.43% 1.12% COUNTY CITY 73.86% CITY ROADS SCHOOLS Capital Project Status Report Fiscal Year 2022 As of September 30, 2021 TOTAL ACTIVE ACTIVE PROJECTS TOTAL FY EXPENSES PROJECT PROJECT FY2021-2022 FUNDING 7/1/21-9/30/21 BALANCE EXPENSES ** STREET DEPARTMENT: 93101 Rossview/Dunbar Cave/Cardinal Improvements 14,430,000 592,409 5,678,455 8,751,545 15306 Spring Creek Parkway 16,808,700 1,268,373 4,061,258 12,747,442 17304 Adaptaive Signal Control Project (Wilma) 1,200,000 6,653 161,979 1,038,021 17305 Tylertown & Oakland Intersection Improvement 10,000,000 42,917 1,391,225 8,608,775 17307 Tylertown & Trenton Drainage Overflow Project 3,540,185 7,645 204,599 3,335,586 19301 Lilac Lane 100,000 - 48,056 51,944 19302 Whitfield Road Improvements 15,850,000 217,956 2,055,995 13,794,005 19303 Spot Intersection Improvements 3,237,027 29,740 608,842 2,628,185 20303 New Sidewalks FY20-24 1,884,727 317,299 1,161,090 723,637 20304 Drainage Mitigation FY20-24 624,159 - 750 623,409 21301 Storm Sewer Rehab 350,000 336,914 336,914 13,086 21302 College Street Streetscape 300,000 - - 300,000 21303 College Street SCO Repair/Replace 610,000 - 600,704 9,296 22301 New Sidewalks using CMAQ funding 540,000 - - 540,000 22302 New Sidewalks using Local funding 475,000 - - 475,000 22303 New Sidewalks using local funding #2 180,000 - - 180,000 22304 New Sidewalks - TAP (SRTS) 66,000 - - 66,000 22305 Exit 1 Improvements 290,000 - - 290,000 22306 Needmore Road Improvements Phase 1 1,750,000 - - 1,750,000 22307 Memorial Extension 150,343 - - 150,343 22308 48/13 Sidewalks/Crosswalks 625,000 - - 625,000 73,011,141 2,819,905 16,309,867 56,701,274 PARKS & RECREATION: 16503 Exit 8 Athletic Complex & Access 19,665,378 13,360 5,065,830 14,599,548 16504 Red River Trail and Revitalization 2,366,212 - 2,340,156 26,056 17503 Edith Pettus Park Renovations 201,800 - 23,615 178,185 17505 Liberty Park/Marina Remediation 1,155,218 1,238 586,427 568,791 19502 Pollard Road Additional Parking 382,785 - 301,824 80,961 19504 Heritage Park Improvements 1,000,000 123,461 757,246 242,754 19505 Regional Community Center 500,000 - - 500,000 20501 Red River Pedestrian Bridge 2,768,233 - 92,931 2,675,302 20504 Burt Cobb Recreation Center Repairs 280,000 2,700 226,632 53,368 21501 Marina Dredging at Red River East 220,000 - 110,014 109,986 22501 Tennis Court Lighting 250,000 - - 250,000 22502 Billy Dunlop Cumberland River 200,000 - - 200,000 $ 28,989,626 $ 140,759 $ 9,504,674 $ 19,484,952 FIRE DEPARTMENT: 16221 Fire Maintenance and CFR1 Property Improvements 1,566,377 80,218 1,503,631 62,746 21221 Fire Admin & Training Facility 200,000 - 52,500 147,500 21222 New Burn Building 225,000 - 4,240 220,760 21223 100' Ladder Truck 1,447,000 - 207,381 1,239,619 21224 New Rescue Truck 403,000 - 63,065 339,935 22221 75' Aerial Fire Truck 1,200,000 970,323 - 1,200,000 22222 Rescue Truck 400,000 - - 400,000 $ 5,441,377 $ 1,050,541 $ 1,830,816 $ 3,610,561 POLICE DEPARTMENT: 19211 District 3 Precinct Building 3,337,500 - 3,004,355 333,145 21211 Vista Lane Renoation 160,000 - - 160,000 22211 Outdoor Rubber Berm Trap 160,140 - - 160,140 $ 3,657,640 $ - $ 3,004,355 $ 653,285 GENERAL GOVERNMENT: 41016 Corporate Business Park Expansion 14,368,821 79,889 14,172,589 196,232 13101 Clarksville Performing Arts & Conf Center 7,834,713 - 992,800 6,841,913 19102 Structural Repairs - Cumberland Garage 1,099,036 - - 1,099,036 20101 Frosty Morn Revitalization 1,250,000 15 1,096,013 153,987 22101 L&N Train Station Repairs 50,000 - - 50,000 22102 Smith Trahern Rehabilitation 200,000 4,950 - 200,000 $ 24,802,570 $ 84,854 $ 16,261,402 $ 8,541,168 debt issuance costs Total Spent YTD: Major Projects $ 135,902,354 $ 4,096,058 $ 46,911,114 $ 88,991,240 * 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 2022 As of September 30, 2021 Estimated Beginning Fund Revenues Expenditures Estimated Ending Fund Balance YTD YTD Fund Balance 09/30/21 7/01/21 General Fund: $ 31,762,217 $ 18,617,918 $ 22,912,017 $ 27,468,117 Capital Projects Fund: (2,129,149) 665,330 4,096,058 (5,559,877) Debt Service Fund: 342,422 1,377,484 1,369,822 350,084 Internal Service Funds: 9,345,843 1,448,326 4,192,138 6,602,030 Non-Major Governmental Funds: Drug Fund 749,302 87,955 14,828 822,429 Road Improvement Fund 1,599,509 283,810 0 1,883,319 Police Special Fund 180,076 20,660 27,868 172,868 Parks Special Fund 342,740 94,147 116,710 320,176 Other Special Revenue Fund* 16,428,975 1,783,099 768,956 17,443,117 Community Development 503,364 34,794 217,863 320,296 * Includes: Fire Spec. Rev., Traffic Camera Police & Parks, SRF & COVID Notice of Grant Applications Fiscal Year 2022 As of September 30, 2021 Date Funding Funds Match Submitted Project Title Agency Requested Required Status Notes 2021 Alcohol & Funding for alcohol and impaired driver countermeasures. Pays for overtime TN Highway Safety 03/25/20 Impared Driving 133505.4 $125,000 $0 Awarded for officers to conduct DUI checkpoints and saturation patrols for a one year Office (THSO) Enforcement period. Including purchase of equipment for DUI checkpoints. 2021 TN Highway Safety Funding for training of officers for bicycle/pedestrian crash investigations, 03/27/20 Bicycle/Pedestrian 13544 $10,000 $0 Awarded Office (THSO) staff time for enforcement and public awareness activities. Safety 2020 Assistance to Federal funding to reimburse for PPE expenses incurred related to COVID19 Firefighters - US Dept of 05/15/20 $56,563 $5,656 Awarded as well as expected PPE expenses through May 2021. Funding only covers COVID19 Homeland Security face masks, gloves and gowns used by firefighters on calls. Supplement 2019 Staffing for Requested funding to hire 15 new firefighters. Funding would cover 100% 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) 2020 Coronavirus Emergency Allocation to cover expenses related to COVID, both past and future 05/29/20 US Dept of Justice $191,575 $0 Awarded Supplemental anticipated expenses through January 2022 Funding (CESF) TN Agriculture TN Dept of 06/01/20 Enhancement $2,930 $2,920 $2,930 $2,920 Awarded Requested funding to plant 26 trees along the riverbank at Trice Landing Agrculture Program 2020 Edward Byrne Annual share with Sheriff's Office. CPD will purchase face shields and gas 08/17/20 Memorial Justice US DOJ $58,694 $0 Awarded masks for officer safety - county will purchase communication equipment, Grant JAG software and wireless communications services 2021 TAEP - TN Dept of 01/31/21 $1,000 $0 Awarded Advertising for farmer's market Farmer's Market Agriculture 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 Not funded Firefighters Homeland Security epartment. Federal funding to purchase an inflatable firehouse for fire education activities 2020 Fire Prevention US Dept of 02/26/21 $12,324 $616 Not funded and DSLR camera equipment as well as report writing software for fire & Safety Grant Homeland Security investigation activites. 2022 THSO - TN Highway Safety Funding for training of officers for bicycle/pedestrian crash investigations, 03/22/21 13544 $15,000 $0 Awarded Bicycle/Pedestrian Office (THSO) staff time for enforcement and public awareness activities. 2022 THSO - TN Highway Safety Funding to purchase driving simulators for distracted driving educational 03/22/21 $28,850.00 $0 Awarded Distracted Driving Office (THSO) purposes and public events. Funding for alcohol and impaired driver countermeasures. Pays for overtime 2022 THSO - DUI TN Highway Safety 03/23/21 $125,000.00 $0 Awarded for officers to conduct DUI checkpoints and saturation patrols for a one year OT Office (THSO) period. Including purchase of equipment for DUI checkpoints. 2022 THSO - TN Highway Safety 03/23/21 $37,704.00 $0 Awarded Funding for overtime costs related to motorcycle safety enforcement. Motorcycle Safety Office (THSO) 2021 NEA Arts National Engagement in 04/06/21 Endowment for the $10,000.00 $10,000.00 Awarded Homeschool art program American Arts Communities Notice of Grant Applications Fiscal Year 2022 As of September 30, 2021 Date Funding Funds Match Submitted Project Title Agency Requested Required Status Notes State of TN Dept. of 2022 TAEP Tree Funding to replace aging and dying tress at various locations in the downtown 06/03/21 Agriculture, Forestry $8,000.00 $8,000.00 Awarded Project - Downtown area. Division Dept. of Justice, Funding to purchase portable traffic sign board, speed monitoring trailer, lidar, 08/13/21 2021 JAG Bureau of Justice $69,255.00 $0.00 Awarded wireless communication equipment and services. Assistance Investment Report Fiscal Year 2022 As of September 30, 2021 ISSUER NAME PAR VALUE CUSIP COUPON RATE LOCAL GOVERNMENT INVESTMENT POOL SELF-INSURANCE $ 592,898 0.010 CAPITAL PROJECTS FUNDS 1,747,015 0.010 INVESTMENT ACCOUNT 21,586,694 0.010 2016 BOND ISSUANCE 340,553 0.010 ARP TRAUNCH 1 12,766,508 0.010 LGIP TOTAL / AVERAGE $ 37,033,668 0.010 CAPITAL PROJECTS FUNDS SELF-INSURANCE ARP TRAUNCH 1 2016 BOND ISSUANCE INVESTMENT ACCOUNT CDE Lightband Rolling 4 Month Balance Sheet - Electric Division September 30, 2021 Prior Year 9/30/2020 % Change 9/30/2021 8/31/2021 7/31/2021 6/30/2021 (F) UTILITY PLANT 1 Electric Plant $ 319,024,502.77 3.99% $ 331,765,937.35 $ 331,381,682.45 $ 330,848,012.16 $ 330,754,739.22 2 Less Depreciation (109,711,064.49) 7.37% (117,798,835.21) (117,075,038.90) (116,342,801.26) (115,548,795.48) 3 Total $209,313,438.28 2.22% $213,967,102.14 $214,306,643.55 $214,505,210.90 $215,205,943.74 4 Unamortized acq. adj. 27,040.77 -100.00% - - - - 6 Total Plant - Net $209,340,479.05 2.21% $213,967,102.14 $214,306,643.55 $214,505,210.90 $215,205,943.74 OTHER PROPERTY AND INVESTMENTS 8 Interdivisional loan 2,895,931.13 -100.00% - - - - 9 Sinking Funds 6,906,090.49 12.44% 7,765,237.29 7,764,856.69 11,210,402.75 11,209,129.64 12 Other Special Funds - - - - - 13 Total 9,802,021.62 -20.78% 7,765,237.29 7,764,856.69 11,210,402.75 11,209,129.64 CURRENT AND ACCRUED ASSETS 14 General Cash/temp cash investments 10,223,600.56 70.09% 17,389,227.45 16,020,853.99 16,312,411.35 16,767,658.18 14.1 Reserved Cash 22,839,553.45 -2.73% 22,215,784.28 22,099,006.14 21,958,260.92 21,829,543.56 15 Accounts Receivable 14,063,721.12 13.19% 15,919,008.85 16,538,040.70 15,756,976.90 14,450,588.70 16 Materials and Supplies 2,904,626.49 60.26% 4,655,051.47 4,325,396.99 4,133,155.50 3,653,786.96 18 Other Current Assets 23,877,412.80 7.90% 25,763,997.00 25,061,717.25 24,250,476.23 22,239,422.10 19 Total 73,908,914.42 16.28% 85,943,069.05 84,045,015.07 82,411,280.90 78,940,999.50 DEFERRED DEBITS 22 Clearing Accounts 18,442.65 -54.54% 8,383.17 9,221.46 10,059.75 10,898.04 24 Energy Service Loans Rec 1,477,989.84 -44.52% 820,014.68 855,595.58 895,827.75 940,963.03 26 Other Deferred Debits 4,503,713.85 -24.25% 3,411,430.57 3,481,124.90 3,416,970.86 3,478,654.26 27 Total 6,000,146.34 -29.34% 4,239,828.42 4,345,941.94 4,322,858.36 4,430,515.33 28 TOTAL ASSETS & OTHER DEBITS $299,051,561.43 4.30% $311,915,236.90 $310,462,457.25 $312,449,752.91 $309,786,588.21 CAPITAL EARNINGS REINVESTED IN SYSTEM ASSETS 33 Beginning of year 191,710,376.76 7.14% 205,402,772.01 205,402,772.01 205,402,772.01 191,710,376.76 34 Current Year to Date 5,562,101.32 13.19% 6,295,943.66 3,213,500.58 1,625,382.25 13,692,395.25 35 Total 197,272,478.08 7.31% 211,698,715.67 208,616,272.59 207,028,154.26 205,402,772.01 Long Term Debt 39.1 Bonds and other Long Term Debt 56,385,000.00 -5.76% 53,140,000.00 53,140,000.00 56,385,000.00 56,385,000.00 40 Debt Premium and discount 7,290,424.94 -8.14% 6,697,204.94 6,746,639.94 6,796,074.94 6,845,509.94 41 Total 63,675,424.94 -6.03% 59,837,204.94 59,886,639.94 63,181,074.94 63,230,509.94 OTHER NON-CURRENT LIABILITIES 39.2 Post Retirement Benefits 1,723,783.51 -30.43% 1,199,281.01 1,203,419.12 1,207,949.57 1,212,197.72 42 Energy Service Loans - Advances 1,538,089.62 -44.08% 860,087.48 899,206.16 953,083.36 1,011,810.43 44 Total 3,261,873.13 -36.87% 2,059,368.49 2,102,625.28 2,161,032.93 2,224,008.15 CURRENT AND ACCRUED LIABILITIES 46 Accounts Payable 23,953,267.58 9.83% 26,307,260.70 28,120,025.46 27,480,831.31 26,174,463.15 47 Customer Deposits 7,197,748.97 3.99% 7,484,805.28 7,458,428.49 7,421,428.55 7,430,674.24 52.2 Interest Accrued - Other 209,102.05 200,320.83 - 1,001,604.16 801,283.33 53 Other Current Liabilities 3,481,666.68 24.30% 4,327,560.99 4,278,465.49 4,175,626.76 4,522,877.39 54 Total 34,841,785.28 9.98% 38,319,947.80 39,856,919.44 40,079,490.78 38,929,298.11 58 TOTAL LIABILITIES AND OTHER CREDITS $ 299,051,561.43 4.30% $ 311,915,236.90 $ 310,462,457.25 $ 312,449,752.91 $ 309,786,588.21 CDE Lightband Revenues and Expenses ‐ Electric Division 9/30/2021 Prior Year Prior 3 Months 9/30/2020 % Change 9/30/2021 8/31/2021 7/31/2021 6/30/2021 (F) OPERATING REVENUE 59 Electric Sales Revenue 14,621,297.95 9.62% 16,028,252.45 17,246,433.03 16,914,822.24 14,685,637.06 60 Revenue from Late Payments 132,893.83 ‐9.62% 120,104.17 121,395.40 101,218.66 77,325.07 61 Misc Service Revenue 107,285.70 37.47% 147,489.00 162,290.00 151,347.00 136,566.00 62 Rent from Electric Property 313,741.41 37.50% 431,393.42 431,051.17 429,839.42 376,376.22 63 Other Electric Revenue 0.49 ‐18.37% 0.40 0.66 2.02 10,357.72 64 Total Operating Revenue 15,175,219.38 10.23% 16,727,239.44 17,961,170.26 17,597,229.34 15,286,262.07 PURCHASED POWER 65 Total Power Cost 9,348,678.96 5.86% 9,896,085.70 12,464,718.17 12,355,259.79 11,241,775.78 OPERATING EXPENSE 66 Transmission Expense 3,256.94 76.72% 5,755.78 5,681.66 6,269.58 7,872.71 67 Distribution Expense 377,303.70 7.74% 406,497.58 378,690.56 400,561.14 568,938.39 68 Customer Accounts Expense 474,776.97 ‐31.51% 325,173.27 399,798.60 360,276.66 293,820.16 69 Cust. Service and Inf. Exp. 34,981.60 ‐13.17% 30,373.51 81,274.42 38,158.38 61,709.33 70 Sales Expense 5,149.90 90.44% 9,807.68 31,376.25 11,964.08 10,986.54 71 Admin. And General Expense 427,028.50 13.01% 482,580.08 518,786.71 382,303.14 1,073,776.93 72 Operating Expense 1,322,497.61 ‐4.71% 1,260,187.90 1,415,608.20 1,199,532.98 2,017,104.06 MAINTENANCE EXPENSE 73 Transmission Expense 6,008.98 4.22% 6,262.69 6,254.15 6,552.72 3,414.40 74 Distribution Expense 207,099.72 83.27% 379,552.22 392,554.43 284,179.64 497,457.07 75 Admin. and General Expense 150,363.21 18.21% 177,750.41 173,544.97 180,999.03 306,337.45 76 Maintenance Expense 363,471.91 55.05% 563,565.32 572,353.55 471,731.39 807,208.92 OTHER OPERATING EXPENSE 77 Depreciation Expense 1,140,897.04 3.72% 1,183,324.88 1,184,391.00 1,178,180.58 1,174,339.89 78 Amort. of Acquisition Adjust. 3,004.53 ‐100.00% ‐ ‐ ‐ 155,024.62 79 Taxes and Tax Equivalents 571,751.58 0.57% 574,982.72 575,181.27 606,505.02 975,980.25 80 Total other oper. Expense 1,715,653.15 2.49% 1,758,307.60 1,759,572.27 1,784,685.60 2,305,344.76 Total operating expense and 81 purchased power 12,750,301.63 5.71% 13,478,146.52 16,212,252.19 15,811,209.76 16,371,433.52 INCOME 82 Operating Income 2,424,917.75 33.99% 3,249,092.92 1,748,918.07 1,786,019.58 (1,085,171.45) 83 Other Income 24,222.62 ‐61.08% 9,426.89 11,318.61 10,472.85 12,231.20 84 Total Income 2,449,140.37 33.05% 3,258,519.81 1,760,236.68 1,796,492.43 (1,072,940.25) 85 Misc Income Deductions ‐ (5,000.00) (1,000.00) ‐ ‐ 86 Net Income before debt expense 2,449,140.37 32.84% 3,253,519.81 1,759,236.68 1,796,492.43 (1,072,940.25) DEBT EXPENSE 90 Interest on Long Term Debt 227,679.44 ‐3.86% 218,898.22 218,898.23 218,898.22 218,402.72 92 Other Interest Expense 1,576.72 2.33% 1,613.51 1,655.12 1,646.96 1,629.48 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 179,821.16 ‐4.86% 171,076.73 171,118.35 171,110.18 170,597.20 NET INCOME 96 Income before Extraord. Items 2,269,319.21 35.83% 3,082,443.08 1,588,118.33 1,625,382.25 (1,243,537.45) 97 Extraordinary Items ‐ ‐ ‐ ‐ ‐ 98 Net Income 2,269,319.21 35.83% 3,082,443.08 1,588,118.33 1,625,382.25 (1,243,537.45) CDE Lightband Cash Flow Statement - Electric Division September 30, 2021 RECONCILIATION OF OPERATING INCOME TO NET CASH PROVIDED BY OPER ACTIVITIES: Operating income $ 3,249,092.92 Adjustments to reconcile oper income to cash provided (used) by operating activities Depreciation and amortization 1,183,324.88 Changes in: Accounts receivable 619,031.85 Materials and supplies (329,654.48) Interdivisional loan - Accounts receivable - TVA Energy Service Loans 35,580.90 Advances - TVA Energy Service Loans (39,118.68) Prepayments - Other current assets (798,396.97) Accounts payable (1,812,764.76) Accrued expenses 200,320.83 Customer deposits 26,376.79 Other postemployment benefits (4,138.11) Other 49,095.50 Net Cash from Operating Activities 2,378,750.67 CASH FLOWS FROM FINANCING ACTIVITIES: Additions to plant (843,783.47) Payment of long-term debt (49,435.00) Net Cash used by Financing Activities (893,218.47) NET INCREASE IN CASH AND CASH EQUIVALENTS $ 1,485,532.20 CASH AND CASH EQUIVALENTS - BEG OF MONTH 45,884,716.82 CASH AND CASH EQUIVALENTS - END OF MONTH $ 47,370,249.02 CASH AND CASH EQUIVALENTS CONSIST OF: Sinking Funds 7,765,237.29 Construction Funds - General cash/temp cash investments 17,389,227.45 Reserved Cash 22,215,784.28 $ 47,370,249.02 CDE Lightband Rolling 4 month Balance Sheet - Broadband Division September 30, 2021 9/30/20 % Change 9/30/21 8/31/21 7/31/21 6/30/2021 (F) Assets Current Assets: Cash -Operating Account $ 4,577,011.77 38.29% $ 6,329,494.23 $ 6,038,212.60 $ 5,545,531.94 $ 5,020,538.01 Accounts Receivable: Subscribers, less allowance 1,595,837.17 8.07% 1,724,589.01 1,729,714.11 1,567,563.90 1,687,629.66 Other 79,152.53 -66.76% 26,311.53 24,683.64 29,452.98 38,418.71 Temporary advances - Electric 2,063,267.75 9.38% 2,256,860.99 2,173,276.13 2,317,962.95 2,193,070.25 Inventory 595,031.30 -12.47% 520,808.69 442,205.23 450,923.82 608,619.58 Total Current Assets $ 8,910,300.52 21.86% $ 10,858,064.45 $ 10,408,091.71 $ 9,911,435.59 $ 9,548,276.21 Noncurrent Assets: Construction Work In Progress $ 72,877.48 -98.02% $ 1,444.59 $ 22,287.59 $ 169,269.44 $ 67,554.08 Telecommunications Plant 9,255,725.48 14.40% 10,588,643.87 10,615,011.62 10,468,439.86 10,424,633.61 Accumulated Depreciation (5,779,718.40) 9.26% (6,315,170.95) (6,259,758.70) (6,182,577.72) (6,108,996.39) Deferred Debit - Software & Outflows of Resources 488,357.92 -4.27% 467,493.41 430,793.21 353,685.48 289,460.84 Total Noncurrent Assets $ 4,037,242.48 17.47% $ 4,742,410.92 $ 4,808,333.72 $ 4,808,817.06 $ 4,672,652.14 Total Assets $ 12,947,543.00 20.49% $ 15,600,475.37 $ 15,216,425.43 $ 14,720,252.65 $ 14,220,928.35 Retained Earnings and Liabilities: Retained Earnings (Deficit): Retained Earnings - Beginning of Year $ 4,986,471.41 109.28% $ 10,435,630.63 $ 10,435,630.63 $ 10,435,630.63 $ 4,986,471.41 Retained Earnings - YTD 1,010,229.54 -24.64% 761,346.04 383,183.23 - 5,100,456.52 Retained Earnings - Current 345,205.29 8.66% 375,092.75 378,162.81 383,183.23 348,702.70 Total Retained Earnings (Deficit) $ 6,341,906.24 82.47% $ 11,572,069.42 $ 11,196,976.67 $ 10,818,813.86 $ 10,435,630.63 Current Liabilities: Accounts Payable $ 2,164,334.33 10.85% $ 2,399,208.19 $ 2,420,425.02 $ 2,330,169.84 $ 2,243,373.73 Unearned Revenue $ 801,576.15 8.43% $ 869,178.78 $ 869,178.78 $ 869,178.78 $ 869,178.78 Other Accrued Payables 269,428.71 11.80% 301,231.30 270,807.38 242,815.21 213,220.35 Total Current Liabilities $ 3,235,339.19 10.33% $ 3,569,618.27 $ 3,560,411.18 $ 3,442,163.83 $ 3,325,772.86 Noncurrent Liabilities: Customer Deposits $ 187.48 -100.00% $ - $ - $ (12.52) $ (12.52) Postretirement Benefits 389,626.96 -56.26% 170,417.68 170,667.58 170,917.48 171,167.38 Deferred Inflows of Resources 84,552.00 241.06% 288,370.00 288,370.00 288,370.00 288,370.00 Long Term Debt to the Electric Division 2,895,931.13 -100.00% - - - - Total Noncurrent Liabilities $ 3,370,297.57 -86.39% $ 458,787.68 $ 459,037.58 $ 459,274.96 $ 459,524.86 Total Liabilities $ 6,605,636.76 -39.02% $ 4,028,405.95 $ 4,019,448.76 $ 3,901,438.79 $ 3,785,297.72 Total Liabilities & Retained Earnings $ 12,947,543.00 20.49% $ 15,600,475.37 $ 15,216,425.43 $ 14,720,252.65 $ 14,220,928.35 CDE Lightband Income Statement - Broadband Division 9/30/2021 % 9/30/20 Change 9/30/21 8/31/21 7/31/21 6/30/2021 (F) Operating Revenue: Programming Revenue $ 415,579.41 4.29% $ 433,393.14 $ 433,340.03 $ 425,713.09 $ 422,782.82 Internet Revenue 1,346,185.28 14.88% 1,546,441.39 1,545,828.94 1,490,441.05 1,408,698.91 Telephone Revenue 158,429.40 5.85% 167,698.37 168,847.36 166,311.74 167,626.52 Miscellaneous Fee Revenue 132,050.60 21.53% 160,486.69 134,244.16 126,304.56 160,344.97 Total Operating Revenues 2,052,244.69 12.46% 2,308,019.59 2,282,260.49 2,208,770.44 2,159,453.22 Cost of Programming & Services 690,378.86 6.53% 735,441.82 776,995.83 756,933.73 767,344.04 Gross Revenue: $ 1,361,865.83 15.47% $ 1,572,577.77 $ 1,505,264.66 $ 1,451,836.71 $ 1,392,109.18 Operating Expenses: Network Support Expense-Video $ 31,956.43 60.16% $ 51,181.84 $ 51,783.99 $ 55,305.74 $ 31,508.21 Network Support Expense-Internet 150,216.81 55.31% 233,305.60 265,253.03 229,862.50 159,890.16 Network Support Expense-Phone 15,626.36 50.30% 23,485.75 23,559.75 24,382.50 15,571.04 Network Admin. & Oper. Expense 119,854.80 -2.39% 116,985.57 108,791.74 122,371.97 132,414.86 Building & Office Expense 8,047.00 0.00% 8,047.00 8,047.00 8,047.00 8,047.00 Depreciation & Amortization Expense 94,260.09 46.52% 138,109.90 140,544.19 142,242.97 131,984.18 General & Administrative Expense 298,544.70 6.42% 317,704.76 226,945.26 226,915.81 231,509.98 Station Apparatus Expense 161,464.90 -0.20% 161,139.01 148,896.69 128,419.73 141,528.54 Customer Service Expense 53,375.53 3.38% 55,179.09 55,807.63 64,403.93 54,862.08 Marketing Expense 74,655.08 15.79% 86,443.26 89,941.62 62,212.85 107,933.64 Total Operating Expenses $ 1,008,001.70 18.21% $ 1,191,581.78 $ 1,119,570.90 $ 1,064,165.00 $ 1,015,249.69 Operating Income (Loss) $ 353,864.13 7.67% $ 380,995.99 $ 385,693.76 $ 387,671.71 $ 376,859.49 Interest Expense (Income) 2,647.86 -166.51% (1,761.01) (1,786.57) (1,522.50) (631.33) Other Expenses - Tax Equivalent 6,010.98 27.50% 7,664.25 9,317.52 6,010.98 28,788.12 Total Other Expenses (Income) $ 8,658.84 -31.82% $ 5,903.24 $ 7,530.95 $ 4,488.48 $ 28,156.79 Net Income (Loss) $ 345,205.29 8.66% $ 375,092.75 $ 378,162.81 $ 383,183.23 $ 348,702.70 EBITDA $ 448,124.22 $ 519,105.89 $ 526,237.95 $ 529,914.68 $ 508,843.67 CDE Lightband Cash Flow Statement - Broadband Division September 30, 2021 RECONCILIATION OF OPERATING INCOME TO NET CASH PROVIDED BY OPER ACTIVITIES: Operating income (loss) $ 380,995.99 Adjustments to reconcile oper income to cash provided (used) by operating activities Depreciation and amortization 138,109.90 Changes in: Accounts receivable 3,497.21 Advances to Electric (83,584.86) Inventory (78,603.46) Accounts payable (21,216.83) Accrued expenses 30,174.02 Customer deposits - Other (42,603.44) Net Cash From Operating Activities 326,768.53 CASH FLOWS FROM FIN & INV ACTIVITIES: Payment of long term debt - Additions to plant (35,486.90) Net Cash Used by Financing Activities (35,486.90) NET INCREASE IN CASH AND CASH EQUIVALENTS $ 291,281.63 CASH AND CASH EQUIVALENTS - BEG OF MONTH 6,038,212.60 CASH AND CASH EQUIVALENTS - END OF MONTH $ 6,329,494.23 CDE Lightband Subscriber Analysis July 2021 - September 2021 G July Actual August Actual September Actual r o w Net Gain July Prior Growth % Net Gain August Growth % Net Gain September Growth % t July July July Over Prev. % Growth Year Year Over August August August Over Prev. % Growth Prior Year Year Over September September September 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,200 4,944 256 67 5% 5,190 0% 5,236 4,971 265 36 5% 5,185 1% 5,235 4,923 312 (1) 6% 5,152 2% Lightband Basic 344 324 20 4 6% 359 -4% 337 326 11 (7) 3% 366 -8% 329 324 5 (8) 2% 359 -8% Lightband Plus 1,599 1,700 (101) (5) -6% 1,762 -9% 1,591 1,710 (119) (8) -7% 1,740 -9% 1,573 1,697 (124) (18) -7% 1,713 -8% Lightband Extra 2,102 2,248 (146) (15) -6% 2,424 -13% 2,061 2,259 (198) (41) -9% 2,391 -14% 2,035 2,234 (199) (26) -9% 2,356 -14% Streaming Services 1,127 643 484 84 0% 616 1,221 647 574 94 0% 659 1,272 639 633 51 0% 695 Other Pkgs 28 29 (1) (1) -3% 29 -3% 26 29 (3) (2) -10% 29 -10% 26 29 (3) 0 -10% 29 -10% Internet (Total) 24,994 24,396 598 (403) 2% 22,979 9% 25,237 24,617 620 243 3% 23,088 9% 25,320 24,708 612 83 2% 23,305 9% Residential Internet 23,082 22,700 382 (420) 2% 21,260 9% 23,296 22,899 397 214 2% 21,351 9% 23,370 22,973 397 74 2% 21,546 8% Business Internet 1,912 1,696 216 17 13% 1,719 11% 1,941 1,718 223 29 13% 1,737 12% 1,950 1,735 215 9 12% 1,759 11% Phone (Total) 2,550 2,485 65 14 3% 2,529 1% 2,547 2,488 59 (3) 2% 2,528 1% 2,539 2,475 64 (8) 3% 2,524 1% Residential Phone 1,695 1,674 21 13 1% 1,734 -2% 1,688 1,670 18 (7) 1% 1,730 -2% 1,675 1,660 15 (13) 1% 1,721 -3% Business Phone 855 811 44 1 5% 795 8% 859 818 41 4 5% 798 8% 864 815 49 5 6% 803 8% Total Broadband Customers 25,819 25,255 564 260 2% 23,913 8% 25,956 25,471 485 137 2% 24,069 8% 26,014 25,547 467 58 2% 24,133 8% ORDINANCE ____-2021-22 AN ORDINANCE AMENDING THE OPERATING AND CAPITAL BUDGETS FOR FISCAL YEAR 2022 FOR GOVERNMENTAL FUNDS (ORDINANCE 130-2021-22) TO REPAIR THE CITY HALL AIR CONDITIONING (HVAC) SYSTEM. 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 Hall air conditioning system (HVAC) has been failing on a regular basis. The majority of the current air conditioning system was installed in with the original building in 1982. WHEREAS, A thorough assessment of the HVAC for City Hall was conducted by a mechanical engineer. Several immediate and impending needs have been identified in order to keep the system functioning. Additionally, a compressor will be replaced. NOW, THEREFORE, BE IT ORDAINED BY THE CITY COUNCIL OF THE CITY OF CLARKSVILLE, TENNESSEE: That the following Amendment be made: 10419703-4432 Building Repairs & Maintenance Increase $500,000 BE IT FURTHER ORDAINED that above funds will be provided from the fund balance of the general fund. __________________________________________ MAYOR ATTEST: _______________________________________ CITY CLERK FIRST READING: SECOND READING: EFFECTIVE DATE:

Get email alerts for Clarksville

A daily email when new agendas and minutes are posted.

Report an issue with this meeting