Finance Committee

FINANCE COMMITTEE AGENDA *This meeting will be conducted in person and via Google Meets* DATE: September 22, 2020 TIME: 3:30 p.m. LOCATION: City Hall Conference Room/Google Meets 1) CALL TO ORDER 2) ATTENDANCE 3) APPROVAL OF ELECTRONIC MEETING In order to comply with the technical aspects of the Governor’s Executive Order regarding holding open meetings in a forum other than in the open and in public, the Finance Committee determines that meeting electronically is necessary to protect the health, safety, and welfare of its citizens due to the COVID-19 outbreak. 4) ADOPTION OF MINUTES: August 25, September 14 5) DEPARTMENT REPORTS 1. PURCHASING ​Camille Thomas a) Report of bids  b) Report of award of professional service contracts ● G&W - Engineering Services for the Utility Relocation at Tylertown Road and Oakland Road from HDR Engineering, Inc. in the amount of $528,629.00. ● G&W - Survey, Design, Easement Descriptions and Construction Plans for the Northwest Manifold Improvements from Suiter Surveying & Land Planning, Inc. in the amount of $58,250.00. c) Report of sale of surplus property on ​GovDeals.com ​August 2020: $4,980.00 2. GENERAL FUND a) Monthly report ​Laurie Matta 3. DEPARTMENT OF ELECTRICITY a) Monthly reports ​David Johns, Christy Batts 4. CITY ATTORNEY a) Report of legal expenditures ​Lance Baker ● Bradley Arant, Kimberly Black v. City - $3,619.00 ● Klein Solomon Mills, Ethics Committee Complaints - $1,650.00 6) COMMITTEE ACTION 1. Approval to obtain an appraisal ​for a portion of the TDK Properties located along Rufus Johnson Road, (Map 081 Parcel 054.02). This property is being purchased for a new water booster station and water tank site for the Sango area to meet growth demands. Mark Riggins 7) CITY COUNCIL ACTION None. 8) PUBLIC COMMENTS No requests were submitted. 9) ADJOURNMENT  FINANCE COMMITTEE AUGUST 25, 2020 MINUTES NON-PUBLIC MEETING City Attorney Lance Baker met in a non-public meeting with members of the City of Clarksville Finance Committee regarding the Robinson v. City case and the Langford v. City case on Tuesday, August 25, 2020, at 3:00 p.m. in the Mayor’s Conference Room. PUBLIC MEETING CALL TO ORDER The public meeting was called to order by Chairman Jeff Burkhart at 3:28 p.m. ATTENDANCE IN PERSON: Jeff Burkhart, Valerie Guzman, Jeff Henley, Stacey Streetman VIA GOOGLE MEETS: Tim Chandler APPROVAL OF ELECTRONIC MEETING In order to comply with the technical aspects of the Governor’s Executive Order regarding holding open meetings in a forum other than in the open and in public, the Finance Committee determines that meeting electronically is necessary to protect the health, safety, and welfare of its citizens due to the COVID-19 outbreak. Councilman Henley made a motion to approve conducting this meeting by electronic means. The motion was seconded by Councillady Streetman. The following vote was recorded: AYE: Burkhart, Chandler, Guzman, Henley, Streetman The motion to approve the electronic meeting unanimously passed. ADOPTION OF MINUTES Councilman Henley made a motion to adopt the minutes of July 28 and July 30 as presented. The motion was seconded by Councillady Streetman. The following vote was recorded: AYE: Burkhart, Chandler, Guzman, Henley, Streetman The motion to adopt the minutes unanimously passed. CONSIDERATION OF LAWSUIT SETTLEMENT There was no discussion or action taken regarding the Robinson v. City case or the Lankford v. City case. PURCHASING DEPARTMENT REPORT Director of Purchasing Camille Thomas shared the monthly bid summary and reported award of the following professional service contracts: ● Gas & Water - Miscellaneous Advisory & Consulting Services from D2 Energy, LLC in the amount of $25,000.00. ● Gas & Water - Miscellaneous Engineering Services from TTL, Inc. in the amount of $50,000.00. ● Fire Dept. - Design of a Maintenance Building at Fire Station #1 from Powell Architecture in the amount of $160,546.00. ● Municipal Properties - Abandoned R.J. Corman Property Survey, Adjacent to Frosty Morn from Matthew Dhority, RLS in the amount of $2,550.00. Ms. Thomas reported sales of surplus property on ​GovDeals.com ​in the amount of $1,707.00 during July. GENERAL FUND REPORT Chief Financial Officer Laurie Matta said revenues were exceeding expenditures by $2 million in July. She said $3.4 million had been received from the CARES Act and 10% of budgeted revenues had already been collected. Department spending was 17.7% less than the previous year with expenses $1.2 million under budget. Ms. Matta said the Local Option Sales Tax revenues increased by 14.5% which was more than projected and provided $5.5 million for schools, $86,000 for the road fund, and $1.7 million for the General Fund. She noted the State of Tennessee had not been accurately allocating revenues from annexed territories since 2010, but efforts were being made to correct the issues. The estimated FY20 year-end fund balance was $24.5 million and $27 million, or 27.9%, for the end of July. Ms. Matta said the Finance Department was making efforts to capture possible grants related to the COVID-19 Pandemic. DEPARTMENT OF ELECTRICITY REPORT CDE Chief Financial Officer David Johns said the Broadband Division cash was just under $4 million and noted a repayment on the interdivisional loan leaving the loan balance below $3 million. Current retained earnings were $549,000 for the month. He said this was the highest income month for the division since its inception in 2008. Broadband operating revenues totaled $2 million for the month with the cost of programming and services down because the video customer count decreased. Net income was $549,000. Christy Batts said overall subscribers increased by 26, however there was a decrease in new connects in all categories. She noted streaming services had been added as well as smart band internet services. Mr. Johns said the electric plant remained at $16 million which included a $2 million receivable (not yet collected) from FEMA. Net income was $1.4 million. Total operating revenue was $16.7 million with a payment to TVA of $12 million for power. Mr. Johns noted an upcoming debt service payment of $4.4 million. CITY ATTORNEY City Attorney Lance Baker reported payment of the following legal expenditures: ● Bradley Arant, ​Jeff Robinson v. City​ - $27,349.42 ● Bradley Arant, ​Kimberly Black v. City​ - $84.00 ● Burr Forman, ​TN River Keepers v. City​ - $5,775.15 UNCOLLECTIBLE WRITE-OFFS Ms. Matta said the write-offs were mostly damages to city properties. Councillady Streetman made a motion to authorize the write offs requested. The motion was seconded by Councillady Guzman. The following vote was recorded: AYE: Burkhart, Chandler, Guzman, Henley, Streetman The motion unanimously passed. CITY ATTORNEY OUTSIDE COUNSEL Mr. Baker was not in the room during this discussion, but returned to the meeting later. Deputy City Attorney Jeff Goodson said this request was for the City to retain and compensate outside counsel to defend Mr. Baker in the ethics complaint filed by Jeff Robinson. Councilman Henley made a motion to approve the request. The motion was seconded by Councillady Streetman. Mr. Goodson said he would not be the prosecuting attorney for this matter. The following vote was recorded: AYE: Burkhart, Chandler, Guzman, Henley, Streetman The motion unanimously passed. COMMUNITY DEVELOPMENT CREDIT CARD FEES ORDINANCE 21-2020-21 ​(First Reading) Waiving credit card processing ​fees Community Development Ms. Matta said the Office of Housing & Community Development requested this waiver to give their paying customers an option to pay without additional fees. Lisa Walker said the payments averaged between $25 and $100 each month. Councilman Henley made a motion to forward this ordinance to the City Council with a recommendation of approval. The motion was seconded by Councillady Streetman. The following vote was recorded: AYE: Burkhart, Chandler, Guzman, Henley, Streetman The motion unanimously passed. HABITAT FOR HUMANITY/JAMESTOWN PLACE ORDINANCE 23-2020-21 (First Reading) Authorizing sale of property located at 10 Jamestown Place to Habitat For Humanity Ms. Matta said this property was acquired through a back tax sale and had incurred a significant amount of back taxes and legal fees. She said Habitat For Humanity had agreed to pay $10,000 for the property including all fees. Councillady Stretman made a motion to forward this ordinance to the City Council with a recommendation of approval. The motion was seconded by Councillady Guzman. The following vote was recorded: AYE: Burkhart, Chandler, Guzman, Henley, Streetman The motion unanimously passed. BYRNE JAG AGREEMENT RESOLUTION 21-2020-21 Authorizing an interlocal agreement with Montgomery County pertaining to division of 2020 Byrne Justice Assistance Grant fund allocations and administration and use of such funds Ms. Matta said the City will be the administrator of this year’s JAG funds totaling $58,694. She said the City would pay $17,608 to Montgomery County for law enforcement purposes. Councilman Henley made a motion to forward this resolution to the City Council with a recommendation of approval. The motion was seconded by Councillady Streetman. The following vote was recorded: AYE: Burkhart, Chandler, Guzman, Henley, Streetman The motion unanimously passed. GAS & WATER FEE STRUCTURE ORDINANCE 20-2020-21 ​(First Reading) Amending the Official Code relative to gas, water, and sewer charges, deposits, programs, adjustments, and installment plans The recommendation of the Gas & Water Committee was for approval. Gas & Water General Manager Mark Riggins briefly reviewed the proposed changes to customer account policies. He said the new policies should not negatively affect existing customers. Mr. Riggins said this ordinance would also change the authority to extend utility services outside the city limits from the City Council to the department. Councilman Henley made a motion to forward this ordinance to the City Council with a recommendation of approval. The motion was seconded by Councillady Streetman. The following vote was recorded: AYE: Burkhart, Chandler, Guzman, Henley, Streetman The motion unanimously passed. PUBLIC SAFETY RADIO AGREEMENTS RESOLUTION 10-2020-21 ​Authorizing an interlocal agreement with Montgomery County Emergency Management Agency for use of radio frequencies for emergency responses RESOLUTION 11-2020-21 ​Authorizing an interlocal agreement with Montgomery County Emergency Medical Services for use of radio frequencies for emergency responses The recommendations of the Public Safety Committee were for approval. Councillady Streetman made a motion to forward both resolutions to the City Council with a recommendation of approval. The motion was seconded by Councillady Guzman. The following vote was recorded: AYE: Burkhart, Chandler, Guzman, Henley, Streetman The motion unanimously passed. 1019 MAIN STREET ORDINANCE 19-2020-21 ​(First Reading) Authorizing sale of property located at 1019 Main Street to Tangi Smith Director of Purchasing Camille Thomas said this property was acquired through a back tax sale and there had been no previous interest shown in purchasing the vacant corner lot. Councilman Henley and Councilman Chandler felt the City should make the public aware the property is available for sale. Mayor Pitts said Ms. Smith was willing to purchase the property and donate it to a non-profit organization that supports women veterans. Councillady Guzman made a motion to forward this ordinance to the City Council with a recommendation of approval.  The motion was seconded by Councillady Streetman. The following vote was recorded: AYE: Burkhart, Guzman, Henley, Streetman NAY: Chandler The motion passed. PUBLIC COMMENTS There were no public comments. ADJOURNMENT The meeting was adjourned at 4:33 p.m.  FINANCE COMMITTEE SEPTEMBER 14, 2020 MINUTES CALL TO ORDER A special meeting of the City of Clarksville Finance Committee was called to order by Chairman Jeff Burkhart on Monday, September 14, 2020, at 3:00 p.m. in the City Hall Conference Room, 1 Public Square, Clarksville, Tennessee. This meeting was conducted in person and via Google Meets. ATTENDANCE IN PERSON: Jeff Burkhart VIA GOOGLE MEETS: Tim Chandler, Valerie Guzman (joined late), Stacey Streetman ABSENT: Jeff Henley RETIREE BENEFITS SUMMARY Director of Human Resources Will Wyatt said in 2012 the City determined that it was spending less in claims than it was paying for premiums and decided to establish the on-site health clinic to contain healthcare costs by managing chronic conditions to improve the health and wellness of employees and their families. Summarizing the history of the City’s retirement benefit program, he said employees hired before July 2006 receive fully funded health insurance coverage upon retirement at a cost of $65 million per year. The fully funded insurance benefit was not provided for employees hired after July 1, 2006. A bridge plan was then implemented in 2009 through the Tennessee Consolidated Retirement System for public safety employees, but with a mandatory retirement age of 60 for police and firefighters and 62 for public safety administrative positions. He said employees hired between July 1, 2006 and 2009 had the understanding that they could work until age 65 when Medicare coverage begins. He said it would be far less expensive to establish a defined benefit for all employees than to grandfather +/- 40 public safety employees. Mr. Wyatt proposed a defined contribution of $800.00 per month for all employees with a ten-year vesting period and twenty years of service for the full benefit to fund their healthcare costs during retirement, creating an actuarial accrued liability of $1.6 million. CFO Laurie Matta said she preferred funding $408,000 per year.  David Shaub, Findley Company, said GASB rules changed to require that medical benefits be accounted for along with pensions. He said the liability for the existing plan was $65 million for 772 employees. He said the additional cost to be incurred would be $1.6 million with no cost of living increase. Mr. Shaub recommended a trust be created for pre-funding so the money cannot be taken back by the City. In response to Councilman Burkhart’s question, Mr. Wyatt said the $800 per month for each retiree would be deposited into a health saving account for the retiree to access as medical costs are needed. He also said the City Council could, if they choose to do so, but with no obligation, occasionally consider a cost of living increase for this benefit. Mr. Shaub said the current proposal required a retiree to be at least 55 with ten years of service. SELF INSURANCE PROGRAM In summary, Mr. Wyatt said the City’s fully insured program was very expensive so the decision was made to assume some risks that were being managed by outside companies and establish the clinic to absorb some of the expenses. Heather Mitchell, Meritain Health, said a fully insured plan shifts the health risks completely to the insurance company, and the self-funded plan shifts part of the sisk to the employer. She said advantages of being self-funded improves cash flow, lowers administrative costs, allows the City to keep any interest earned on the plan, and premium taxes are reduced. Ms. Mitchell noted the plans can be customized by selecting vendors such as pharmacy and on-site clinics. She noted options for stop-loss coverage. Bob Shupe, Employee Security Planning, LLC, said aggregate coverage is necessary due to uncertainty. He said a specific coverage is unlimited per person with no cap, whereas aggregate coverage establishes a cap. ADJOURNMENT The meeting was adjourned at 4:13 p.m.  FINANCE & ADMINISTRATION COMMITTEE BID SUMMARY SEPTEMBER 22, 2020 The following bids/proposals have been solicited, opened and have been approved by the Purchasing Director. All are low bid/proposal except where noted. BID # DEPT. DESCRIPTION AWARDED TO AMOUNT 4027 CDE Replacement of Relay Panels At Edgoten Substation Aubrey Silvey $182,000.00 4082 Street Dunbar Cave Bridge Box Culvert Replacement Concrete Structures $450,000.00 4092 H&CD Reconstruction of 1316 Laurent Lane Aspen Park Properties $120,932.91 4096 Police Sale of Firearms King’s Firearms $ 57,250.50 4094 G&W Old Castle Duralite Tier 22 Meter Boxes & Lids Fortiline Waterworks $ 36,708.80 4100 Police Soft Body Armor Gall’s $1,260.00 each SOLE SOURCE PURCHASES: 1. G&W- Future purchases of Neptune Water Meter parts from Southern Pipe & Supply. 2. G&W-Future purchases of Moyno polymer pump parts from D.J. Shubeck. 3. CDE-Future purchases and support of ONT Provisioning Tool from Layer 3 Networks. 4. CDE- Future purchases of Minerva Networks middleware platform from Minerva Networks. 5. CDE-Future purchases and support of Intelligent Routing platform software from Noction. 6. Garage-Future purchases of Etnyre Oil Distributor parts from Power Equipment. 7. Garage-Future purchases and service of Terex OEM parts from Terex USA. 8. Fire-Future purchases and service of EMS reporting from Emergency Reporting. Bid 4027-CDE-Replacement of Relay Panels at Edgoten Substation Aubrey Silvey $182,000.00* WM E. Groves Construction Contractor safety forms were not filled out. Service Electric Co. No bid bond. Advanced Wireless Solutions No Response AZZ Switchgear Systems No Response Bar Environmental No Response City Electric Supply No Response Colditz Trucking No Response Delta Star No Response Diversified Supply No Response Fulghum Maclndoe & Associates No Response G Power Group No Response Lenland Inc. No Response Llyod’s Electric Service No Response Nijsha Enterprise No Response Power Solutions Group No Response R. Roese Contracting Co. No Response Reed Construction No Response S&W Contracting Co. No Response Schaffhauser Electric Co. No Response Stansell Electric Co. No Response Travis Electric Service No Response Local Two Rivers Roofing No Response Vision Security Technologies No Response Bowman & Sons Construction No Response Boyce Ballard Construction No Response CD Steger Construction No Response Ground Support LLC. No Response Local Middle TN Urban Development No Response Parchman Construction No Response Local Power Tek LLC. No Response R&M Electric Inc. No Response Siemens Industry Inc. No Response Southwest Electrical Inc. No Response Thompson Electric Inc. No Response Bid 4082-Street Dept. -Dunbar Cave Bridge Box Culvert Replacement Concrete Structures $450,000.00* Adams Contracting $489,498.50 Brown Builders $610,798.00 Moore Construction No Response Local Byard Construction No Response Local Parchman Construction No Response Local Morris Wall Construction No Response Local Pride Concrete No Response Local Hall Construction No Response Local Jeff Shepherd Construction No Response Local Meadows Contracting, LLC. No Response Local REF Construction Co. No Response Triple S Contracting Inc. No Response Local Beech Construction Services No Response Chickamauga Construction No Response Cliff Carey General Contractors No Response Crowder Construction No Response Carl Construction & Excavating No Response Gaines Shearon Construction No Response Gregory Construction No Response Insituform Technologies No Response Jarrett Builders Inc. No Response Jones Brothers Construction No Response McCall Contracting Firm No Response Local McMillan Construction No Response Morgan Inc. No Response Local Peed Bros. Inc. No Response R. Roese Contracting Co. No Response RAWSO Constructors No Response Reed Construction No Response Rose Construction No Response Roy T. Godwin Contractors No Response Smith Contractor Inc. No Response Thalle Construction Co. No Response Transformation Construction Grp. No Response URETEK USA Inc. No Response Bid 4092-H&CD-Reconstruction of 1316 Laurent Lane Aspen Park Construction $120,932.91* Triple S Contracting $132,079.50 Local Adams Construction No Response Batten/Shaw Construction No Response Beech Construction Services No Response Blue Team Restoration No Response Bluebook Network Building & Construction No Response Brett Design/Build PLC No Response Cliff Corey General Contractors No Response Carl Construction & Excavating No Response English Mountain Construction No Response Gregory Construction No Response MDI Construction INC No Response Orion Building Corp No Response Parchman Construction Co. No Response Local Reed Construction No Response RL Alvarez Construction No Response Local Southeast Contractors No Response Stubblefield Construction No Response T.W. Frierson Contractor No Response The Whiting-Turner Contracting No Response Workman General Contractors No Response Local Hall Construction No Response Local Bid 4096-Police-Sale of Firearms King’s Firearms $57,250.50* TN Gun Country $43,000.00 Local Gulf States $42,895.00 Kiesler Police Supply No Bid Clarksville Gun & Archery No Response Local GT Distributors No Response Allen’s Gun Shop No Response Local *King’s Firearms is purchasing from the City. Bid 4094- G&W-Old Castle Duralite Tier 22 Meter Boxes & Lids Fortiline Waterworks $36,708.80* Southern Pipe Supply $36,904.32 Core & Main $43,968.00 Consolidated Pipe & Supply No Response C.I. Thornburg Co No Response Ferguson Waterworks No Response Kenny Pipe & Supply No Response Local Hayes Pipe Supply Inc. No Response 12K Utility & Meter LLC No Response Aclara SGS No Response Kamstrup Water Metering LLC No Response M&M Mfg No Response McLemore Water Meter Source No Response National Water Service LLC No Response Nova-Tech International Inc. No Response Sensus USA Inc. No Response Southern Cross No Response The Macomb Group No Response Walter A Wood Supply Co No Response Bid 4100-Police-Soft Body Armor Gall’s $1,260.00 each* CMS Uniforms $1,052.99 each** Mid-South Solution $1,285.50 each MES Supply $1,287.20 each Craig’s Firearms $1,358.15 each Kiesler Police Supply No Bid Summit Uniforms No Response A1 Tactical & Safety No Response Blackfox Tactical No Response Falcon Company Tactical LLC. No Response Greene Military No Response Accurate Law Enforcement No Response Bulletproof IT LLC No Response GT Distributors Inc. No Response Lawmen’s Shooter Supply No Response Staff Industries No Response Straek Inc. No Response **Did not meet specs. ________________________________________________________________ *Department Recommendation Department of Finance & Revenue August 2020 Financial Review Fiscal Year 2021 Clarksville, Tennessee August 31, 2020  General Fund Revenues vs. Expenditures Fiscal Year 2021 As of August 31, 2020 FY 2021 Monthly FY 2021 Revenues Expenditures Variance July $ 9,444,294 $ 7,000,858 $ 2,443,436 August 5,730,068 5,718,725 11,343 September - October - November - December - January - February - March - April - May - June - YTD Total $ 15,174,362 $ 12,719,583 $ 2,454,779 $10,000,000 $9,000,000 $8,000,000 $7,000,000 $6,000,000 $5,000,000 FY 2021 Revenues $4,000,000 FY 2021 Expenditures $3,000,000 $2,000,000 $1,000,000 $-  General Fund Revenue Comparison Fiscal Year 2021 As of August 31, 2020 FY 2020 FY 2019 Variance Revenue Revenue July $ 9,444,294 $ 5,454,774 $ 3,989,520 August 5,730,068 $ 5,286,834 443,234 September - - October - - November - - December - - January - - February - - March - - April - - May - - June - - YTD Total $ 15,174,362 $ 10,741,608 $ 4,432,754 $17,000,000 $15,000,000 $13,000,000 $11,000,000 FY2020 YTD Revenue FY2021 YTD Revenue $9,000,000 FY2021 YTD Budgeted Revenue $7,000,000 $5,000,000 $3,000,000 July August  GENERAL FUND REVENUES Fiscal Year 2021 As of August 31, 2020 Total Budget YTD Month TAXES Prior Year Property Taxes 894,712 502,209 168,775 2020 Property Taxes 31,911,324 - - PiLOTS 687,473 - - Local Option Sales Tax 17,791,510 3,505,059 1,750,770 Beer & Liquor Tax 3,696,163 887,406 435,195 Business License 2,623,286 859,265 114,665 Franchise Tax (cable) 1,500,932 - - Hote/Motel 424,243 55,792 31,681 Other Taxes 367,426 87,774 34,992 TOTAL TAXES 59,897,069 5,897,504 2,536,078 LICENSES AND PERMITS Building Permits 1,990,000 542,550 269,214 Other Permits 111,794 19,055 6,520 TOTAL PERMITS 2,101,794 561,605 275,734 INTERGOVERNMENTAL Grant reimbursements 307,854 - - State Shared Revenues TVA Replacement Tax 1,595,148 - - State Sales Tax 11,166,036 2,149,174 1,116,344 State Street Aid 4,651,185 827,532 438,011 Other Taxes 2,031,963 442,177 227,628 TOTAL INTERGOVERNMENTAL 19,752,186 3,418,884 1,781,983 OTHER REVENUES Charges for Services 690,128 106,276 35,313 Recreation 696,210 38,318 17,522 Golf Courses 697,330 195,063 96,435 Fines and Forefeitures 571,242 87,087 42,047 Investment & Interest Earnings 100,995 6,831 3,038 Other Misc. Revenues 917,235 46,617 8,472 Extraordinary Sources (COVID Funds) 3,490,203 3,490,202 0 Transfer from CDE 5,197,147 1,051,752 659,321 Transfer From CGW 3,628,651 302,388 302,388 Other Transfers 450,141 -28,175 -28,270 TOTAL OTHER REVENUES 16,439,282 5,296,361 1,136,265 TOTAL REVENUES GENERAL FUND 98,190,331 15,174,354 5,730,060  General Fund Expenditure Comparison Fiscal Year 2021 As of August 31, 2020 FY 2021 FY 2020 Variance Expenditures Expenditures July $ 7,000,858 $ 8,407,620 $ (1,406,762) August 5,718,725 $ 6,844,729 (1,126,004) September - - October - - November - - December - - January - - February - - March - - April - - May - - June - - YTD Total $ 12,719,583 $ 15,252,349 $ (2,532,766) $18,000,000 $16,000,000 $14,000,000 FY2020 YTD Expenditures $12,000,000 FY2021 YTD Expenditures $10,000,000 FY2021 YTD Budgeted $8,000,000 Expenditures $6,000,000 $4,000,000 $2,000,000 July August  General Fund Year-to-Date Departmental Budget vs. Actual Expenditures Fiscal Year 2021 As of August 31, 2020 $30,000,000 Expenditures Estimated Variance Departmental: FY 2019 YTD YTD Budget (Over)Under $25,000,000 $20,000,000 Police $ 4,170,967 $ 4,826,542 $ 655,575 Fire 2,446,468 2,939,393 492,925 $15,000,000 FY 2021 Actual YTD Highway & Street 1,933,525 2,194,685 261,159 $10,000,000 Parks & Rec. & Golf 1,140,752 1,444,214 303,462 $5,000,000 Building & Codes 264,642 330,103 65,461 FY2021 Total Info. Technology 431,303 293,908 (137,395) $0 Budget Finance 239,805 270,860 31,056 City Garage 146,217 197,381 51,164 Municipal Properties 104,466 77,268 (27,198) Human Resources 140,962 172,182 31,220 Legislative / Admin. 102,623 104,570 1,947 Mayor's Office 97,989 102,826 4,837 City Court 52,565 69,661 17,096 $1,100,000 Legal 52,264 71,745 19,481 $1,000,000 $900,000 Internal Audit 29,075 61,365 32,290 $800,000 Purchasing 20,682 31,614 10,932 $700,000 Departmental Total 11,374,304 13,188,315 1,814,011 $600,000 $500,000 FY 2021 $400,000 Actual YTD Nondepartmental: $300,000 Debt 764,515 1,435,430 670,915 $200,000 FY2021 Total $100,000 Extraordinary - COVID - 581,701 581,701 $0 Budget Transit 10,448 194,927 184,480 Retirees 48,277 248,755 200,478 Other 522,039 488,941 (33,098) YTD Total $ 12,719,583 $ 16,138,069 $ 3,418,486  Schedule of Sales Tax Collections Fiscal Year 2021 As of August 31, 2020 City of Clarksville Local Sales & Use Tax Net Collections Net Collections Net Collections Net Collections FY 2018 FY 2019 FY 2020 FY 2021 July $ 1,425,145 $ 1,524,372 $ 1,607,009 $ 1,840,352 August 1,453,282 1,552,311 1,584,610 1,836,659 September October November December January February March April May June YTD Total $ 2,878,427 $ 3,076,683 $ 3,191,619 $ 3,677,011 City of Clarksville $4,000,000 $3,500,000 $3,000,000 $2,500,000 $2,000,000 $1,500,000 $1,000,000 $500,000 FY 2018 FY 2019 FY 2020 FY 2021  Local Sales Tax Collections Fiscal Year 2021 As of August 31, 2020 TOTAL NET COLLECTIONS PAID TO GROSS COLLECTIONS UNICORPORATED NET COLLECTIONS COUNTY CITY CITY ROADS SCHOOLS AREA CITY LIMITS PAID TO STATE July $ 7,463,614 $ 103,279 $ 1,754,290 $ 86,062 $ 5,519,983 $ 585,231 $ 6,963,304 $ 84,921 August 7,511,005 106,783 1,750,770 85,889 5,567,563 647,132 6,949,333 85,460 September - October - November - December - January - February - March - April - May - June - YTD TOTAL $ 14,974,618 $ 210,062 $ 3,505,059 $ 171,951 $ 11,087,546 $ 1,232,363 $ 13,912,637 $ 170,381 Monthly Distribution 1.38% 23.50% 1.15% COUNTY CITY 73.96% CITY ROADS SCHOOLS  Capital Project Status Report Fiscal Year 2021 As of August 31, 2020 TOTAL ACTIVE ACTIVE PROJECTS FY EXPENSES PROJECT TOTAL FUNDING PROJECT FY2020-2021 7/1/20-7/31/20 BALANCE EXPENSES ** STREET DEPARTMENT: 93101 Rossview/Dunbar Cave/Cardinal Improvements 13,280,000 5,140 2,770,775 10,509,225 14301 Edmondson Ferry/1A Bypass Interesection Improvement 1,150,004 0 1,150,002 2 15306 Northeast Connector 16,808,700 9,230 1,275,007 15,533,693 17301 International & Dunlop Intersection Improvement 2,807,831 0 445,506 2,362,325 17304 Adaptaive Signal Control Project (Wilma) 1,200,000 0 0 1,200,000 17305 Tylertown & Oakland Intersection Improvement 10,000,000 294,555 1,206,654 8,793,346 17307 Tylertown & Trenton Drainage Overflow Project 1,040,185 26,785 100,532 939,653 18301 Drainage Mitigation FY2018 400,000 0 106,642 293,358 18302 New Sidewalks FY2018 934,954 492,713 642,037 292,917 19301 Lilac Lane 100,000 0 2,600 97,400 19302 Whitfield Road Improvements 3,350,000 222,604 1,531,734 1,818,266 19303 Spot Intersection Improvements 1,500,000 0 94,136 1,405,864 20301 Dunbar Cave Road Bridge 600,000 57,375 57,875 542,125 20302 4th Street and College Signal 400,000 63,033 101,025 298,975 20303 New Sidewalks FY20-24 900,000 0 843,791 56,209 20304 Drainage Mitigation FY20-24 450,000 0 0 450,000 20305 Cemetary Retaining Wall 510,000 368,704 370,204 139,796 $ 55,431,674 $ 1,540,139 $ 10,698,520 $ 44,733,154 PARKS & RECREATION: 16503 Athlectic Complex 5,297,478 0 4,750,745 546,733 16504 Red River East Trail Project 2,403,712 30,372 2,184,758 218,954 17501 Valleybrook Park & Upland Trail Connection 160,000 0 0 160,000 17502 Public Spaces 150,000 0 150,000 0 17503 Edith Pettus Park Renovations 201,800 0 23,615 178,185 17504 Crow Community Center Renovation 370,000 8,526 128,392 241,608 17505 Liberty Park/Marina Remediation 905,218 153,397 256,179 649,039 17506 Swan Lake Renovations 1,046,605 0 1,039,218 7,387 19502 Pollard Road Additional Parking 319,199 0 227,701 91,498 19503 Billy Dunlop Pavillion & Restroom 382,485 0 380,591 1,894 19504 Heritage Park Improvements 1,000,000 21,138 529,760 470,240 19505 Regional Community Center 500,000 0 0 500,000 20501 Red River Pedestrian Bridge 3,068,233 0 11,681 3,056,552 20502 Mason Rudolph Cart Path Paving 125,000 0 0 125,000 20503 Swan Lake Cart Path Paving 190,800 0 187,700 3,100 20504 Burt Cobb Recreation Center Roof 230,000 32,443 223,932 6,068 $ 16,350,530 $ 245,877 $ 10,094,271 $ 6,256,259 FIRE DEPARTMENT: 16221 Fire Maintenance Facility 901,377 69,904 118,156 783,221 20221 Renovation of Station 10 125,000 0 0 125,000 20222 Custom Engine (replaces 1999 model) 590,000 588,374 588,374 1,626 $ 1,616,377 $ 658,278 $ 706,530 $ 909,847 POLICE DEPARTMENT: 19211 District 3 Precinct Building 3,500,000 451,352 643,604 2,856,396 $ 3,500,000 $ 451,352 $ 643,604 $ 2,856,396 GENERAL GOVERNMENT: 41016 Corporate Business Park Expansion $ 14,368,821 $ - $ 14,092,700 $ 276,121 13101 Clarksville Performing Arts & Conf Center 1,613,963 0 179,907 1,434,056 15102 TDOT 2013 Multimodal Access 206,017 0 169,830 36,187 16103 2015 Multimodal Access Grant 241,189 0 222,043 19,146 19101 New Council Chambers 0 0 0 0 19102 Structural Repairs - Cumberland Garage 1,099,036 0 0 1,099,036 20101 Frosty Morn 1,200,000 72,872 77,372 1,122,628 $ 18,729,026 $ 72,872 $ 14,741,852 $ 3,987,174 debt issuance costs Total Spent YTD: Major Projects $ 95,627,607 $ 2,968,517 $ 36,884,777 $ 58,742,830 * Fiscal Year to date invoices paid (July 1st to current month end) ** Total Active Expenses includes all expenses paid during the life of a project, not just the current fiscal year.  Fund Balances Fiscal Year 2021 As of August 31, 2020 Estimated Estimated Ending Beginning Fund Revenues Expenditures Fund Fund Balance Balance YTD YTD 831/20 7/01/20 General Fund: $ 26,438,320 $ 15,174,362 $ 12,719,583 $ 28,893,099 Capital Projects Fund: (224,752) 786,024 2,968,517 (2,407,245) Debt Service Fund: 493,872 712,047 712,047 493,872 Internal Service Funds: 6,994,431 975,024 2,141,772 5,827,682 Non-Major Governmental Funds: Drug Fund 758,568 9,348 11,157 756,759 Road Improvement Fund 1,267,701 171,951 0 1,439,652 Police Special Fund 144,885 13,187 17,606 140,466 Parks Special Fund 260,467 39,186 33,496 266,157 Other Special Revenue Fund* 636,263 30,198 121,291 545,171 Community Development 393,914 0 68,318 325,596 Capital Projects Revenue District Fund 467,555 0 0 467,555 * Includes: Fire Spec. Rev., Traffic Camera Police & Parks, SRF  Notice of Grant Applications Fiscal Year 2021 As of August 31, 2020 Date Funding Funds Match Submitted Project Title Agency Requested Required Status Notes 2019 Assistance to US Dept of Federal funding to purchase mobile air units, thermal imaging cameras and 03/19/20 $146,489 $14,649 Submitted Firefighters Grant Homeland Security training for CFD. 2021 Alcohol & Funding for alcohol and impaired driver countermeasures. Pays for overtime for TN Highway Safety 03/25/20 Impared Driving 133505.4 125000 $0 Awarded officers to conduct DUI checkpoints and saturation patrols for a one year Office (THSO) Enforcement period. Including purchase of equipment for DUI checkpoints. 2021 Child Passenger Funding for child safety seats and booster seats to provide to low income TN Highway Safety 03/25/20 Safety and Occupant $10,564 $0 Not funded families and staff time for events/enforcement of proper use of child passenger Office (THSO) Protection restraints. 2021 TN Highway Safety Funding for training of officers for bicycle/pedestrian crash investigations, staff 03/27/20 Bicycle/Pedestrian $13,544 $0 Not funded Office (THSO) time for enforcement and public awareness activities. Safety 2021 Distracted TN Highway Safety Funding to purchase driving simulators for distracted driving educational 03/30/20 $28,850 $0 Not funded Driving Office (THSO) purposes and public events. 2020 Assistance to Federal funding to reimburse for PPE expenses incurred related to COVID19 as Firefighters - US Dept of 05/15/20 $56,563 $5,656 Submitted well as expected PPE expenses through May 2021. Funding only covers face COVID19 Homeland Security masks, gloves and gowns used by firefighters on calls. Supplement 2019 Staffing for Requested funding to hire 15 new firefighters. Funding would cover 100% to Adquate Fire and US Dept of 05/20/20 $2,713,365 $0 Submitted entry level salaries and benefits for 3 years. Share has been waived due to Emergency Response Homeland Security COVID19. (SAFER) 2019 Fire Prevention US Dept of Federal funding to purchase a new fire safety trailer and training for two CFR 05/27/20 $60,683 $3,034 Submitted and Safety Homeland Security staff to become certified Fire and Safety Educators 2020 Coronavirus Emergency Allocation to cover expenses related to COVID, both past and future 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 2930 2920 2930 2920 Awarded Requested funding to plant 26 trees along the riverbank at Trice Landing Agrculture Program 2020 Edward Byrne Annual share with Sherif's Office. CPD will purchase face shields and gas 08/17/20 Memorial Justice US DOJ $58,694 $0 Submitted masks for officer safety - county will purchase communication equipment, Grant JAG software and wireless communications services  Investment Report Fiscal Year 2021 As of August 31, 2020 ISSUER NAME PAR VALUE CUSIP COUPON RATE LOCAL GOVERNMENT INVESTMENT POOL SELF-INSURANCE $ 592,312 0.270 CAPITAL PROJECTS FUNDS 1,745,288 0.270 INVESTMENT ACCOUNT 13,249,222 0.270 2016 BOND ISSUANCE 663,539 0.270 0.270 LGIP TOTAL / AVERAGE $ 16,250,362 0.270 2016 BOND ISSUANCE SELF-INSURANCE CAPITAL PROJECTS FUNDS INVESTMENT ACCOUNT  CDE Lightband Rolling 4 month Balance Sheet - Broadband Division August 31, 2020 7/31/19 % Change 8/31/20 7/31/20 6/30/2020 (R) 5/31/20 Assets Current Assets: Cash -Operating Account $ 4,393,463.46 -1.94% $ 4,308,441.16 $ 3,953,426.91 $ 3,744,241.79 $ 6,084,029.66 Accounts Receivable: Subscribers, less allowance 1,482,757.98 5.97% 1,571,332.97 1,521,344.14 1,551,354.00 1,678,134.72 Other 29,809.62 201.15% 89,772.43 101,825.09 127,947.46 48,968.96 Temporary advances - Electric 1,970,951.75 2.30% 2,016,204.21 2,136,442.75 2,123,796.85 1,905,734.31 Inventory 447,884.94 32.17% 591,958.98 581,794.83 572,019.29 579,424.19 Total Current Assets $ 8,324,867.75 3.04% $ 8,577,709.75 $ 8,294,833.72 $ 8,119,359.39 $ 10,296,291.84 Noncurrent Assets: Construction Work In Progress $ 59,585.35 16.37% $ 69,337.32 $ 13,874.91 $ 8,322.70 $ 70,216.33 Telecommunications Plant 8,252,550.56 11.39% 9,192,401.58 9,194,502.42 9,220,379.22 8,802,523.91 Accumulated Depreciation (5,396,226.86) 6.11% (5,726,071.72) (5,699,432.20) (5,640,605.30) (5,620,718.03) Deferred Debit - Software & Outflows of Resources 383,164.71 -22.67% 296,290.81 203,273.51 240,893.07 277,135.01 Total Noncurrent Assets $ 3,299,073.76 16.15% $ 3,831,957.99 $ 3,712,218.64 $ 3,828,989.69 $ 3,529,157.22 Total Assets $ 11,623,941.51 6.76% $ 12,409,667.74 $ 12,007,052.36 $ 11,948,349.08 $ 13,825,449.06 Retained Earnings and Liabilities: Retained Earnings (Deficit): Retained Earnings - Beginning of Year $ 803,836.93 520.33% $ 4,986,471.41 $ 4,986,471.41 $ 803,836.93 $ 803,836.93 Retained Earnings - YTD 421,263.40 549,060.11 - 4,027,098.57 3,764,290.10 Retained Earnings - Current 394,276.48 16.97% 461,169.43 549,060.11 155,535.91 262,808.47 Total Retained Earnings (Deficit) $ 1,619,376.81 270.31% $ 5,996,700.95 $ 5,535,531.52 $ 4,986,471.41 $ 4,830,935.50 Current Liabilities: Accounts Payable $ 2,000,670.33 -0.07% $ 1,999,275.70 $ 2,086,528.43 $ 2,606,831.09 $ 1,980,979.05 Unearned Revenue $ 682,497.65 17.45% $ 801,576.15 $ 801,576.15 $ 801,576.15 $ 682,497.65 Other Accrued Payables 217,228.40 10.71% 240,495.63 211,516.39 181,290.00 235,067.87 Total Current Liabilities $ 2,900,396.38 4.86% $ 3,041,347.48 $ 3,099,620.97 $ 3,589,697.24 $ 2,898,544.57 Noncurrent Liabilities: Customer Deposits $ 2,348.81 -57.96% $ 987.48 $ 987.48 $ 987.48 $ 1,137.48 Postretirement Benefits 351,274.38 11.07% 390,148.70 390,429.26 390,709.82 344,286.38 Deferred Inflows of Resources 104,614.00 -19.18% 84,552.00 84,552.00 84,552.00 104,614.00 Long Term Debt to the Electric Division 6,645,931.13 -56.43% 2,895,931.13 2,895,931.13 2,895,931.13 5,645,931.13 Total Noncurrent Liabilities $ 7,104,168.32 -52.54% $ 3,371,619.31 $ 3,371,899.87 $ 3,372,180.43 $ 6,095,968.99 Total Liabilities $ 10,004,564.70 -35.90% $ 6,412,966.79 $ 6,471,520.84 $ 6,961,877.67 $ 8,994,513.56 Total Liabilities & Retained Earnings $ 11,623,941.51 6.76% $ 12,409,667.74 $ 12,007,052.36 $ 11,948,349.08 $ 13,825,449.06  CDE Lightband Income Statement - Broadband Division 8/31/2020 % 8/31/19 Change 8/31/20 7/31/20 6/30/2020 (R) 5/31/20 Operating Revenue: Programming Revenue $ 415,237.98 -0.27% $ 414,105.26 $ 428,198.30 $ 480,322.88 $ 437,268.13 Internet Revenue 1,223,551.44 7.56% 1,315,994.93 1,303,773.47 1,185,844.18 1,295,429.63 Telephone Revenue 149,542.74 5.04% 157,081.68 156,467.27 121,601.78 152,643.68 Miscellaneous Fee Revenue 176,701.39 -23.25% 135,621.49 148,867.91 182,241.55 86,815.12 Total Operating Revenues 1,965,033.55 2.94% 2,022,803.36 2,037,306.95 1,970,010.39 1,972,156.56 Cost of Programming & Services 691,512.46 -1.76% 679,361.66 692,969.85 702,886.08 699,067.16 Gross Revenue: $ 1,273,521.09 5.49% $ 1,343,441.70 $ 1,344,337.10 $ 1,267,124.31 $ 1,273,089.40 Operating Expenses: Network Support Expense-Video $ 34,762.38 12.38% $ 39,065.39 $ 31,637.81 $ 38,510.26 $ 33,614.23 Network Support Expense-Internet 137,214.44 6.76% 146,483.75 141,166.06 149,297.98 319,053.34 Network Support Expense-Phone 15,706.12 -0.64% 15,605.92 15,528.06 15,595.60 15,589.46 Network Admin. & Oper. Expense 137,278.41 -20.51% 109,117.30 111,750.65 112,670.66 109,636.89 Building & Office Expense 8,047.00 0.00% 8,047.00 8,047.00 8,047.00 8,047.00 Depreciation & Amortization Expense 76,351.42 17.04% 89,361.44 90,352.31 94,473.99 92,161.05 General & Administrative Expense 174,603.45 17.07% 204,412.28 186,454.09 380,835.22 187,354.89 Station Apparatus Expense 169,572.80 -15.16% 143,858.00 89,904.37 124,989.19 118,461.25 Customer Service Expense 53,178.69 -2.97% 51,599.70 60,852.53 54,295.72 51,952.07 Marketing Expense 62,140.88 6.23% 66,012.94 53,578.14 89,209.70 65,875.36 Total Operating Expenses $ 868,855.59 0.54% $ 873,563.72 $ 789,271.02 $ 1,067,925.32 $ 1,001,745.54 Operating Income (Loss) $ 404,665.50 16.12% $ 469,877.98 $ 555,066.08 $ 199,198.99 $ 271,343.86 Interest Expense 7,315.93 -63.13% 2,697.57 2,932.88 5,335.27 5,462.30 Other Expenses - Tax Equivalent 3,073.09 95.60% 6,010.98 3,073.09 38,327.81 3,073.09 Other Expense - Loss on Retirement of Equipment $ - $ - $ - $ - $ - Total Other Expenses (Income) $ 10,389.02 -16.18% $ 8,708.55 $ 6,005.97 $ 43,663.08 $ 8,535.39 Net Income (Loss) $ 394,276.48 16.97% $ 461,169.43 $ 549,060.11 $ 155,535.91 $ 262,808.47 EBITDA $ 481,016.92 $ 559,239.42 $ 645,418.39 $ 293,672.98 $ 363,504.91  CDE Lightband Cash Flow Statement - Broadband Division August 31, 2020 RECONCILIATION OF OPERATING INCOME TO NET CASH PROVIDED BY OPER ACTIVITIES: Operating income (loss) $ 469,877.98 Adjustments to reconcile oper income to cash provided (used) by operating activities Depreciation and amortization 89,361.44 Changes in: Accounts receivable (37,936.17) Advances to Electric 120,238.54 Inventory (10,164.15) Accounts payable (87,252.73) Accrued expenses 28,698.68 Customer deposits - Other (101,725.85) Net Cash From Operating Activities 471,097.74 CASH FLOWS FROM FINANCING ACTIVITIES: Payment of long term debt - Additions to plant (116,083.49) Net Cash Used by Financing Activities (116,083.49) NET INCREASE IN CASH AND CASH EQUIVALENTS $ 355,014.25 CASH AND CASH EQUIVALENTS - BEG OF MONTH 3,953,426.91 CASH AND CASH EQUIVALENTS - END OF MONTH $ 4,308,441.16  CDE Lightband Rolling 4 Month Balance Sheet - Electric Division August 31, 2020 Prior Year 8/31/2019 % Change 8/31/2020 7/31/2020 6/30/2020 (R) 5/31/2020 UTILITY PLANT 1 Electric Plant $ 297,813,255.32 6.64% $ 317,597,892.20 $ 316,368,987.09 $ 316,777,113.23 $ 314,177,448.60 2 Less Depreciation (102,205,298.11) 6.75% (109,108,481.91) (108,094,426.12) (107,444,710.95) (107,939,705.49) 3 Total $195,607,957.21 6.59% $208,489,410.29 $208,274,560.97 $209,332,402.28 $206,237,743.11 4 Unamortized acq. adj. 66,099.66 -54.55% 30,045.30 33,049.83 36,054.36 39,058.89 6 Total Plant - Net $195,674,056.87 6.56% $208,519,455.59 $208,307,610.80 $209,368,456.64 $206,276,802.00 OTHER PROPERTY AND INVESTMENTS 8 Interdivisional loan 6,645,931.13 -56.43% 2,895,931.13 2,895,931.13 2,895,931.13 5,645,931.13 9 Sinking Funds 7,008,633.51 -1.47% 6,905,920.58 10,814,336.51 10,313,171.43 8,763,793.86 12 Other Special Funds - - - - - 13 Total 13,654,564.64 -28.22% 9,801,851.71 13,710,267.64 13,209,102.56 14,409,724.99 CURRENT AND ACCRUED ASSETS 14 General Cash/temp cash investments 9,080,586.91 10.56% 10,039,055.76 8,308,268.89 10,386,294.64 9,971,177.02 14.1 Reserved Cash 23,638,400.68 -4.16% 22,655,256.27 22,465,893.42 22,526,653.95 22,313,993.48 15 Accounts Receivable 13,827,023.40 12.86% 15,605,497.45 15,784,282.20 15,112,053.02 11,891,719.73 16 Materials and Supplies 3,678,545.40 -19.15% 2,974,133.61 2,992,296.32 3,115,957.13 3,754,240.85 18 Other Current Assets 28,388,826.33 -15.83% 23,894,893.29 23,327,271.44 19,589,623.11 18,666,665.80 19 Total 78,613,382.72 -4.38% 75,168,836.38 72,878,012.27 70,730,581.85 66,597,796.88 DEFERRED DEBITS 22 Clearing Accounts 30,892.00 19,351.67 20,119.23 20,957.52 21,795.81 24 Energy Service Loans Rec 2,373,861.23 -35.55% 1,530,055.54 1,585,684.53 1,647,303.76 1,715,381.63 26 Other Deferred Debits 4,301,917.53 -10.97% 3,830,041.34 3,782,209.16 3,844,963.02 3,891,771.40 27 Total 6,706,670.76 -19.79% 5,379,448.55 5,388,012.92 5,513,224.30 5,628,948.84 28 TOTAL ASSETS & OTHER DEBITS $294,648,674.99 1.43% $298,869,592.23 $300,283,903.63 $298,821,365.35 $292,913,272.71 CAPITAL EARNINGS REINVESTED IN SYSTEM ASSETS 33 Beginning of year 181,656,853.69 5.53% 191,710,376.76 191,710,376.76 181,656,853.69 181,656,853.69 34 Current Year to Date 2,705,056.13 21.73% 3,292,782.11 1,453,297.96 10,053,523.07 11,430,639.51 35 Total 184,361,909.82 5.77% 195,003,158.87 193,163,674.72 191,710,376.76 193,087,493.20 Long Term Debt 39.1 Bonds and other Long Term Debt 59,540,000.00 -5.30% 56,385,000.00 59,540,000.00 59,540,000.00 59,540,000.00 40 Debt Premium and discount 7,933,079.94 -7.48% 7,339,859.94 7,389,294.94 7,438,729.94 7,488,164.94 41 Total 67,473,079.94 -5.56% 63,724,859.94 66,929,294.94 66,978,729.94 67,028,164.94 OTHER NON-CURRENT LIABILITIES 39.2 Post Retirement Benefits 1,623,709.35 6.42% 1,727,880.86 1,731,466.13 1,734,863.91 1,589,878.10 42 Energy Service Loans - Advances 2,475,925.66 -35.60% 1,594,523.17 1,653,222.01 1,722,512.95 1,780,622.60 44 Total 4,099,635.01 -18.96% 3,322,404.03 3,384,688.14 3,457,376.86 3,370,500.70 CURRENT AND ACCRUED LIABILITIES 46 Accounts Payable 28,717,424.13 -8.41% 26,302,899.33 25,343,173.90 25,412,703.43 18,354,375.25 47 Customer Deposits 6,853,832.99 4.57% 7,166,998.46 7,156,588.17 7,146,950.82 7,120,091.19 52.2 Interest Accrued - Other - - 1,045,510.45 836,408.36 627,306.27 53 Other Current Liabilities 3,142,793.10 6.57% 3,349,271.60 3,260,973.31 3,278,819.18 3,325,341.16 54 Total 38,714,050.22 -4.89% 36,819,169.39 36,806,245.83 36,674,881.79 29,427,113.87 58 TOTAL LIABILITIES AND OTHER CREDITS $ 294,648,674.99 1.43% $ 298,869,592.23 $ 300,283,903.63 $ 298,821,365.35 $ 292,913,272.71  CDE Lightband Revenues and Expenses ‐ Electric Division 8/31/2020 Prior Year Prior 3 Months 8/31/2019 % Change 8/31/2020 7/31/2020 6/30/2020 (R) 5/31/2020 OPERATING REVENUE 59 Electric Sales Revenue 16,546,945.91 ‐2.80% 16,083,081.51 16,137,588.79 13,269,347.40 11,228,037.27 60 Revenue from Late Payments 137,043.80 ‐18.88% 111,169.80 109,033.18 78,105.16 (1,205.87) 61 Misc Service Revenue 129,152.95 8.25% 139,810.30 146,179.57 166,123.00 35,223.56 62 Rent from Electric Property 307,815.19 1.88% 313,600.19 312,887.95 353,423.27 311,533.31 63 Other Electric Revenue 585.48 ‐99.93% 0.41 0.23 13,373.09 0.37 64 Total Operating Revenue 17,121,543.33 ‐2.77% 16,647,662.21 16,705,689.72 13,880,371.92 11,573,588.64 PURCHASED POWER 65 Total Power Cost 12,203,130.15 ‐8.53% 11,162,769.65 12,076,254.35 10,499,262.53 8,082,474.83 OPERATING EXPENSE 66 Transmission Expense 2,844.86 41.15% 4,015.60 5,156.05 7,776.99 6,457.36 67 Distribution Expense 263,226.63 23.64% 325,452.91 263,839.99 387,851.67 356,291.62 68 Customer Accounts Expense 277,666.52 9.10% 302,935.07 285,944.14 393,682.06 294,985.08 69 Cust. Service and Inf. Exp. 27,528.03 1.57% 27,960.15 28,410.63 39,933.48 26,498.78 70 Sales Expense 32,191.59 ‐13.08% 27,981.94 7,741.17 7,758.21 8,337.66 71 Admin. And General Expense 365,131.67 33.22% 486,442.22 390,571.17 1,170,913.39 394,875.19 72 Operating Expense 968,589.30 21.29% 1,174,787.89 981,663.15 2,007,915.80 1,087,445.69 MAINTENANCE EXPENSE 73 Transmission Expense 2,429.88 52.41% 3,703.30 3,767.63 3,027.51 4,722.24 74 Distribution Expense 281,054.44 36.70% 384,205.65 186,482.18 402,031.01 389,959.33 75 Admin. and General Expense 183,870.57 28.28% 235,869.01 179,480.70 272,265.94 210,677.21 76 Maintenance Expense 467,354.89 33.47% 623,777.96 369,730.51 677,324.46 605,358.78 OTHER OPERATING EXPENSE 77 Depreciation Expense 1,049,598.98 6.38% 1,116,615.82 1,104,010.38 1,095,411.76 1,092,568.10 78 Amort. of Acquisition Adjust. 3,004.53 0.00% 3,004.53 3,004.53 38,761.56 3,004.53 79 Taxes and Tax Equivalents 558,807.61 2.52% 572,911.02 563,833.53 793,838.81 558,733.91 80 Total other oper. Expense 1,611,411.12 5.03% 1,692,531.37 1,670,848.44 1,928,012.13 1,654,306.54 Total operating expense and 81 purchased power 15,250,485.46 ‐3.91% 14,653,866.87 15,098,496.45 15,112,514.92 11,429,585.84 INCOME 82 Operating Income 1,871,057.87 6.56% 1,993,795.34 1,607,193.27 (1,232,143.00) 144,002.80 83 Other Income 76,526.47 ‐66.63% 25,533.31 25,937.33 44,852.71 25,565.70 84 Total Income 1,947,584.34 3.68% 2,019,328.65 1,633,130.60 (1,187,290.29) 169,568.50 85 Misc Income Deductions ‐ ‐ ‐ (10,000.00) ‐ 86 Net Income before debt expense 1,947,584.34 3.68% 2,019,328.65 1,633,130.60 (1,197,290.29) 169,568.50 DEBT EXPENSE 90 Interest on Long Term Debt 235,270.14 ‐3.23% 227,679.44 227,679.48 227,679.48 227,679.48 92 Other Interest Expense 1,511.29 5.87% 1,600.06 1,588.16 1,581.67 1,575.35 93 Amort. of Debt Disc. and Exp. ‐ ‐ ‐ ‐ ‐ 94 Amort. of Prem. on Debt (49,435.00) 0.00% (49,435.00) (49,435.00) (49,435.00) (49,435.00) 95 Total Debt Expense 187,346.43 ‐4.00% 179,844.50 179,832.64 179,826.15 179,819.83 NET INCOME 96 Income before Extraord. Items 1,760,237.91 4.50% 1,839,484.15 1,453,297.96 (1,377,116.44) (10,251.33) 97 Extraordinary Items ‐ ‐ ‐ ‐ ‐ 98 Net Income 1,760,237.91 4.50% 1,839,484.15 1,453,297.96 (1,377,116.44) (10,251.33)  CDE Lightband Cash Flow Statement - Electric Division August 31, 2020 RECONCILIATION OF OPERATING INCOME TO NET CASH PROVIDED BY OPER ACTIVITIES: Operating income $ 1,993,795.34 Adjustments to reconcile oper income to cash provided (used) by operating activities Depreciation and amortization 1,119,620.35 Changes in: Accounts receivable 178,784.75 Materials and supplies 18,162.71 Interdivisional loan - Accounts receivable - TVA Energy Service Loans 55,628.99 Advances - TVA Energy Service Loans (58,698.84) Prepayments - Other current assets (768,997.66) Accounts payable 959,725.43 Accrued expenses (1,045,510.45) Customer deposits 10,410.29 Other postemployment benefits (3,585.27) Other 88,298.29 Net Cash Used by Operating Activities 2,547,633.93 CASH FLOWS FROM FINANCING ACTIVITIES: Additions to plant (1,331,465.14) Payment of long-term debt (3,204,435.00) Net Cash used by Financing Activities (4,535,900.14) NET DECREASE IN CASH AND CASH EQUIVALENTS $ (1,988,266.21) CASH AND CASH EQUIVALENTS - BEG OF MONTH 41,588,498.82 CASH AND CASH EQUIVALENTS - END OF MONTH $ 39,600,232.61 CASH AND CASH EQUIVALENTS CONSIST OF: Sinking Funds 6,905,920.58 Construction Funds - General cash/temp cash investments 10,039,055.76 Reserved Cash 22,655,256.27 $ 39,600,232.61 CDE Lightband Subscriber Analysis June 2020 - August 2020 G June 2020 July 2020 August Actual r o w Net Gain June Prior Growth % Net Gain July Prior Growth % Net Gain August Growth % t June June June Over Prev. % Growth Year Year Over July July July Over Prev. % Growth Year Year Over August August August 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,255 5,335 (80) (57) -1% 5,199 1% 5,190 5,011 179 (65) 4% 5,187 0% 5,185 5,036 149 (5) 3% 5,201 0% Lightband Basic 366 318 48 (9) 15% 374 -2% 359 251 108 (7) 43% 380 -6% 366 252 114 7 45% 375 -2% Lightband Plus 1,787 1,590 197 (30) 12% 1,842 -3% 1,762 1,505 257 (25) 17% 1,839 -4% 1,740 1,513 227 (22) 15% 1,881 -7% Lightband Extra 2,476 3,392 (916) (56) -27% 2,949 -16% 2,424 2,509 (85) (52) -3% 2,934 -17% 2,391 2,522 (131) (33) -5% 2,912 -18% Streaming Services 596 0 596 38 0% 0 0% 616 718 (102) 20 0% 0 659 721 (62) 43 0% 0 Other Pkgs 30 35 (5) 0 -14% 34 -12% 29 28 1 (1) 4% 34 -15% 29 28 1 0 4% 33 -12% Internet (Total) 23,007 22,454 553 586 2% 21,340 8% 22,979 23,194 (215) (28) -1% 21,504 7% 23,088 23,416 (328) 109 -1% 21,695 6% Residential Internet 21,307 20,694 613 580 3% 19,785 8% 21,260 21,389 (129) (47) -1% 19,904 7% 21,351 21,594 (243) 91 -1% 20,099 6% Business Internet 1,700 1,760 (60) 6 -3% 1,555 9% 1,719 1,805 (86) 19 -5% 1,600 7% 1,737 1,822 (85) 18 -5% 1,596 9% Phone (Total) 2,540 2,653 (113) 1 -4% 2,550 0% 2,529 2,586 (57) (11) -2% 2,552 -1% 2,528 2,590 (62) (1) -2% 2,558 -1% Residential Phone 1,754 1,810 (56) (6) -3% 1,810 -3% 1,734 1,769 (35) (20) -2% 1,809 -4% 1,730 1,766 (36) (4) -2% 1,811 -4% Business Phone 786 843 (57) 7 -7% 740 6% 795 817 (22) 9 -3% 743 7% 798 824 (26) 3 -3% 747 7% Total Broadband Customers 23,913 22,970 943 (58) 4% 22,381 7% 23,939 24,045 (106) 26 0% 22,519 6% 24,069 24,287 (218) 130 -1% 22,762 6%