Finance Committee
Regular MeetingClarksville, TN · October 26, 2021
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.