Finance Committee

FINANCE COMMITTEE AGENDA *This meeting will be conducted via Zoom* DATE: January 26, 2021 TIME: 4:30 p.m. LOCATION: Zoom Join Zoom Meeting: https://zoom.us/j/97072068332?pwd=SEJaUmw3U2FHby9mcnpsOWFJbEVOUT09 Join by Phone: 312 626 6799 US Meeting ID: 970 7206 8332 Passcode: 562805 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: November 24, December 29 5) DEPARTMENT REPORTS 1. PURCHASING ​Camille Thomas a) Report of bids b) Report of award of professional service contracts ● Municipal Properties - CDE Substation Survey at the Exit 8 Athletic Complex from McKay-Burchett & Co. in the amount of $6,300.00. This expense will be reimbursed by CDE. ● ● Municipal Properties - Appraisal of the southern end of the Athletic Complex (approx. 140 acres) and a section of the north end (approx. 3 acres) from Mark Young Real Estate Appraisals in the amount of $2,600.00. ● ● Municipal Properties - Survey for the proposed Hazelwood Regional Recreation Center property from McKay-Burchett & Co. in the amount of $2,750.00. ● ● Municipal Properties - Legal description and drawing of the southern (142 acres) of the Athletic Complex and the 100 ft. utility easement on the northern end from McKay-Burchett & Co. in the amount of $3,100.00. ● ● Municipal Properties - Appraisal of the proposed Hazelwood Regional Recreation Center property from Mark Young Real Estate Appraisals in the amount of $1,000.00. ● ● G&W - Design and preparation of construction documents for new thermal dryer equipment from Hazen & Sawyer in the amount of $1,164,106.00. ● ● G&W - Fee increase for the flow monitoring services provided by ADS Environmental Services in the amount of $58,200.00 for a total cost of $174,600.00. ● ● G&W - Fee increase for the relocation of utilities on Rossview Road from TTL, Inc. (formally DBS & Associates) in the amount of $50,427.28 for a total of $241,953.59. ● ● Fire Dept. - CFR Burn Building Remediation services from ECS Southeast, LLP in the amount of $1,344.00. ● ● Purchasing - Land closing for 1019 Main Street from Cunnigham, Mitchell & Rocconi. There is no cost to the city. ● ● City Garage - Design, architectural and mechanical engineering services for the old Perkins & Miller building from Vision Architects in the amount of $12,200.00. c) Report of sales of surplus property on ​GovDeals.com ​$​12,200.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 ● Burr Forman, TN River Keepers v. City - $1,817.00 ● Bradley Arant, Jeff Robinson v. City - $4,106.90 ● Bradley Arant, Kimberly Black v. City - $1,814.49 ● Bradley Arant, Employment Matters - $2,905.00 6) COMMITTEE ACTION No items were submitted for committee action. 7) CITY COUNCIL ACTION No items were submitted for City Council action. 8) PUBLIC COMMENTS None. 9) ADJOURNMENT  FINANCE COMMITTEE NOVEMBER 24, 2020 MINUTES CALL TO ORDER The regular monthly meeting of the City of Clarksville Finance Committee was called to order by Chairman Jeff Burkhart on Tuesday, November 24, 2020, at 3:30 p.m. in the City Hall Conference Room, 1 Public Square, Clarksville, Tennessee. ATTENDANCE IN PERSON: Jeff Burkhart, Tim Chandler, Valerie Guzman VIA ZOOM: Jeff Henley, Stacey Streetman APPROVAL OF ELECTRONIC MEETING In order to comply with the technical aspects of the Governor’s Executive Order regarding holding open meetings in a forum other than in the open and in public, the Finance Committee determines that meeting electronically is necessary to protect the health, safety, and welfare of its citizens due to the COVID-19 outbreak. Councilman Chandler made a motion to approve the electronic meeting. The motion was seconded by Councillady Guzman. The following vote was recorded: AYE: Chandler, Guzman, Streetman Councilman Henley did not respond to this vote. The motion to approve the electronic meeting passed. ADOPTION OF MINUTES Councillady Guzman made a motion to adopt the October 27th minutes as presented. The motion was seconded by Councilman Chandler. The following vote was recorded: AYE: Chandler, Guzman, Streetman  Councilman Henley did not respond to this vote. The motion to adopt the minutes of October 27 passed. PURCHASING DEPARTMENT REPORT Director of Purchasing Camille Thomas presented the monthly bid summary and reported award of the following professional service contracts: ● Gas & Water - Ringgold Road Equalization, Ringgold Creek Force Main and the Sherwood Forest Lift Station Improvements & Force Main from AECOM Technical Services, Inc. in the total amount of $2,640,600.00. ● Housing & Community Development - Fair Housing Training from the Fair Housing Center in the amount of $6,500.00. ● Fire Rescue - Master Site Plan for Station #1 from McKay-Burchett & Company in the amount of $4,500.00. Ms. Thomas reported sales of surplus property on GovDeals in the amount of $6,307.00 during October. GENERAL FUND REPORT Chief Financial Officer Laurie Matta said expenditures were exceeding revenues by $2.6 million which was normal until property tax payments begin and noted tax bills had been mailed later than usual. She said the City had collected 22.3% more in revenues compared to the same period the previous year. The Local Option Sales Taxes funded $1.6 million for the General Fund, $78,434 million for the Road Fund, and $5 million for schools. Year-to-date department spending was under budget at $5.3 million less than FY20 and capital project spending totalled $4.3 million of $38.2 million invested. Ms. Matta reported the current Fund Balance at $24.2 million or 21.5% of budgeted expenditures and said opportunities for COVID-19 grants were constantly changing. Councilman Chandler expressed appreciation to Ms. Matta and the staff of the Finance Department for their excellent management of city funds. DEPARTMENT OF ELECTRICITY REPORT CDE Chief Financial Officer David Johns said the Broadband Division cash balance had increased by $300,000 and the retained earnings totalled almost $2 million as compared to $1.5 million one year ago. Broadband operating revenues were $2 million with the cost of programming just under $700,000 with a net income of $467,000. Christy Batts said growth during October yielded a 123 net customer gain with a 145 net gain for internet and 11 net gain for phone service. She noted a 6% gain over the previous year. Mr. Johns said the electric plant increased $3 million for the month. Year-to-date earnings for the Electric Division totalled $6.68 million with a total operating revenue of just under $12 million. He said power usage was approximately 15% less than the previous month. The Electric Division net income was $1.1 million. CITY ATTORNEY REPORT City Attorney Lance Baker reported payment of the following legal expenditures: ● Klein Solomon Mills-Ethics Complaint matter - $16,517.50 (two months) ● Burr Forman - TN River Keepers v. City - $3,950.00 ● Bradley Arant - Jeff Robinson v. City - $15,512.77 ● Bradley Arant - Kimberly Black v. City - $6,657.67 EMPLOYEE PAY PLAN Councillady Guzman made a motion to approve the ​2021 Employee Pay Tables with effective dates of January 1, 2021 for City General and Gas & Water, and March 27, 2021 for Fire Rescue and Police. The motion was seconded by Councilman Chandler. Councilman Chandler stated his intent to abstain because of relatives who are city employees. Councillady Guzman stated she would vote in support of the plan, but noted she does not benefit from a relative’s city employment. The following vote was recorded: AYE: Burkhart, Guzman, Streetman ABSTAIN: Chandler Councilman Henley did not respond to this vote. The motion to approve the pay tables passed. BANKING SERVICES RESOLUTION 38-2020-21 ​Recommending banking services contracts under reevaluation as required by State Law Chief Financial Officer Laurie Matta this resolution confirms the City’s reevaluation of current banking services as now required by State Law. She said she will recommend renewing contracts with Legends Bank and US Bank prior to their expiration in 2021. Councillady Guzman made a motion to forward this resolution to the City Council with a recommendation of approval. The motion was seconded by Councilman Chandler. The following vote was recorded: AYE: Burkhart, Chandler, Guzman, Henley ABSTAIN: Streetman RESOLUTION 39-2020-21 ​Declaring intent to reimburse $40,000,000 for certain project expenditures with proceeds of general obligation bonds, notes, or other debt obligations Ms. Matta said this reimbursement would cover capital projects approved in the FY21 Budget and noted City Council approval would be required to draw funds. Councilman Chandler made a motion to forward this resolution to the City  Council with a recommendation of approval. The motion was seconded by Councillady Guzman. The following vote was recorded: AYE: Chandler, Guzman, Henley, Sr\treetman The motion to forward this resolution to the City Council with a recommendation of approval passed. POLICE RESOLUTION 35-2020-21 Authorizing a memorandum of understanding with the Tennessee Bureau of Investigation relative to the Mobile Identification Device Policy Police Chief David Crockarell said this agreement would allow the Clarksville Police Department to access the TBI fingerprint portal for victims of homicide. Councilman Chandler made a motion to forward this resolution to the City Council with a recommendation of approval. The motion was seconded by Councillady Guzman. The following vote was recorded: AYE: Chandler, Guzman, Henley, Streetman The motion to forward this resolution to the City Council with a recommendation of approval passed. RESOLUTION 36-2020-21 ​Authorizing a mutual aid agreement with Austin Peay State University for police services Councilman Henley said this agreement was being renewed in conjunction with the change in leadership of the APSU Police Department and the Clarksville Police Department. Councillady Guzman made a motion to forward this resolution to the City Council with a recommendation of approval. The motion was seconded by Councilman Chandler. The following vote was recorded: AYE: Chandler, Guzman, Henley, Streetman The motion to forward this resolution to the City Council with a recommendation of approval passed. ROXY THEATER RESOLUTION 40-2020-21 ​Approving a lease with the Roxy Regional Theater Mayor Pitts said this lease was modeled after the lease the City has with the Custom House Museum and that once purchased, the City will maintain the exterior of the building and the Roxy would be responsible for maintaining the interior. He said the historic facade will be retained. Councillady Guzman made a motion to forward this resolution to the City Council with a recommendation of approval. The motion was seconded by Councilman Chandler. The following vote was recorded:  AYE: Chandler, Guzman, Henley, Streetman The motion to forward this resolution to the City Council with a recommendation of approval passed. SECURITY OFFICER AUTHORITY ORDINANCE 49-2020-21 ​(First Reading) Amending the Official Code relative citations for city code violation of miscellaneous offences Health & Safety Director Wes Golden said the Loss Prevention Officers currently provide security for City Hall, CTS, Gas & Water, and some parks. Councilman Chandler expressed concern about the officers becoming involved in alcohol-related incidents. Councilman Burkhart was concerned about the officers’ safety. Mr. Baker said they would be allowed to issue citations to violators of specific offenses, but they would not be authorized to arrest anyone. Councilman Burkhart made a motion to refer this ordinance to the Public Safety Committee. The motion was seconded by Councilman Chandler. Councilman Henley said the committee would meet November 30 to review this ordinance. The following vote was recorded: AYE: Chandler, Guzman, Henley NOTE: Councillady Streetman was not available for this vote. The motion to refer this ordinance to the Public Safety Committee passed. PUBLIC COMMENTS There were no public comments. ADJOURNMENT The meeting was adjourned at 4:22 p.m.  FINANCE COMMITTEE DECEMBER 29, 2020 MINUTES The regular monthly meeting of the City of Clarksville Finance Committee originally scheduled for Thursday, December 29, 2020, was cancelled; there were no department items submitted for consideration by the committee.  CDE Lightband Rolling 4 month Balance Sheet - Broadband Division December 31, 2020 12/31/19 % Change 12/31/20 11/30/20 10/31/20 9/30/20 Assets Current Assets: Cash -Operating Account $ 5,782,103.72 -9.13% $ 5,254,139.95 $ 5,256,167.33 $ 4,872,419.06 $ 4,577,011.77 Accounts Receivable: Subscribers, less allowance 1,457,895.08 0.48% 1,464,893.94 1,660,927.63 1,618,867.31 1,595,837.17 Other 31,626.26 65.72% 52,412.22 62,863.94 70,937.61 79,152.53 Temporary advances - Electric 2,111,484.45 10.22% 2,327,257.39 2,066,689.10 2,101,752.24 2,063,267.75 Inventory 359,898.95 127.82% 819,908.15 819,504.95 639,420.15 595,031.30 Total Current Assets $ 9,743,008.46 1.80% $ 9,918,611.65 $ 9,866,152.95 $ 9,303,396.37 $ 8,910,300.52 Noncurrent Assets: Construction Work In Progress $ 35,325.52 1105.17% $ 425,730.89 $ 48,440.64 $ 67,730.15 $ 72,877.48 Telecommunications Plant 8,528,124.09 10.60% 9,432,300.20 9,416,777.54 9,347,830.20 9,255,725.48 Accumulated Depreciation (5,483,574.14) 6.21% (5,823,886.10) (5,789,069.05) (5,826,348.70) (5,779,718.40) Deferred Debit - Software & Outflows of Resources 475,674.15 -4.14% 455,962.75 456,627.06 454,559.99 488,357.92 Total Noncurrent Assets $ 3,555,549.62 26.28% $ 4,490,107.74 $ 4,132,776.19 $ 4,043,771.64 $ 4,037,242.48 Total Assets $ 13,298,558.08 8.35% $ 14,408,719.39 $ 13,998,929.14 $ 13,347,168.01 $ 12,947,543.00 Retained Earnings and Liabilities: Retained Earnings (Deficit): Retained Earnings - Beginning of Year $ 803,836.93 520.33% $ 4,986,471.41 $ 4,986,471.41 $ 4,986,471.41 $ 4,986,471.41 Retained Earnings - YTD 1,901,478.98 21.83% 2,316,585.58 1,822,643.42 1,355,434.83 1,010,229.54 Retained Earnings - Current 433,955.01 26.77% 550,116.82 493,942.16 467,208.59 345,205.29 Total Retained Earnings (Deficit) $ 3,139,270.92 150.16% $ 7,853,173.81 $ 7,303,056.99 $ 6,809,114.83 $ 6,341,906.24 Current Liabilities: Accounts Payable $ 2,121,870.47 -0.71% $ 2,106,799.40 $ 2,197,276.64 $ 2,068,274.23 $ 2,164,334.33 Unearned Revenue $ 682,497.65 17.45% $ 801,576.15 $ 801,576.15 $ 801,576.15 $ 801,576.15 Other Accrued Payables 254,664.91 9.02% 277,625.42 327,147.31 298,472.60 269,428.71 Total Current Liabilities $ 3,059,033.03 4.15% $ 3,186,000.97 $ 3,326,000.10 $ 3,168,322.98 $ 3,235,339.19 Noncurrent Liabilities: Customer Deposits $ 1,337.48 -85.98% $ 187.48 $ 187.48 $ 187.48 $ 187.48 Postretirement Benefits 348,371.52 11.63% 388,874.00 389,201.44 389,059.59 389,626.96 Deferred Inflows of Resources 104,614.00 -19.18% 84,552.00 84,552.00 84,552.00 84,552.00 Long Term Debt to the Electric Division 6,645,931.13 -56.43% 2,895,931.13 2,895,931.13 2,895,931.13 2,895,931.13 Total Noncurrent Liabilities $ 7,100,254.13 -52.54% $ 3,369,544.61 $ 3,369,872.05 $ 3,369,730.20 $ 3,370,297.57 Total Liabilities $ 10,159,287.16 -35.47% $ 6,555,545.58 $ 6,695,872.15 $ 6,538,053.18 $ 6,605,636.76 Total Liabilities & Retained Earnings $ 13,298,558.08 8.35% $ 14,408,719.39 $ 13,998,929.14 $ 13,347,168.01 $ 12,947,543.00  CDE Lightband Income Statement - Broadband Division 12/31/2020 % 12/31/19 Change 12/31/20 11/30/20 10/31/20 9/30/20 Operating Revenue: Programming Revenue $ 420,910.58 -1.29% $ 415,495.13 $ 416,623.11 $ 412,403.51 $ 415,579.41 Internet Revenue 1,246,310.72 11.69% 1,392,030.55 1,367,329.99 1,352,879.91 1,346,185.28 Telephone Revenue 149,107.17 7.34% 160,055.46 158,800.91 158,891.67 158,429.40 Miscellaneous Fee Revenue 165,298.91 10.37% 182,444.09 127,584.02 136,029.05 132,050.60 Total Operating Revenues 1,981,627.38 8.50% 2,150,025.23 2,070,338.03 2,060,204.14 2,052,244.69 Cost of Programming & Services 694,224.24 -3.80% 667,827.82 678,486.28 683,919.62 690,378.86 Gross Revenue: $ 1,287,403.14 15.13% $ 1,482,197.41 $ 1,391,851.75 $ 1,376,284.52 $ 1,361,865.83 Operating Expenses: Network Support Expense-Video $ 33,675.63 -5.19% $ 31,928.00 $ 31,882.75 $ 31,864.33 $ 31,956.43 Network Support Expense-Internet 136,706.60 7.05% 146,344.98 146,206.13 149,481.82 150,216.81 Network Support Expense-Phone 15,620.16 -0.43% 15,552.62 15,558.76 16,029.00 15,626.36 Network Admin. & Oper. Expense 114,004.43 0.32% 114,365.38 137,276.60 111,157.80 119,854.80 Building & Office Expense 8,047.00 0.00% 8,047.00 8,047.00 8,047.00 8,047.00 Depreciation & Amortization Expense 101,515.03 -0.95% 100,548.50 103,262.72 89,283.35 94,260.09 General & Administrative Expense 196,112.78 24.46% 244,073.56 193,425.88 201,991.99 298,544.70 Station Apparatus Expense 120,996.87 12.48% 136,094.61 123,773.77 156,147.26 161,464.90 Customer Service Expense 52,149.24 19.41% 62,269.93 54,257.46 54,075.46 53,375.53 Marketing Expense 67,010.53 -3.79% 64,467.59 75,750.07 82,341.37 74,655.08 Total Operating Expenses $ 845,838.27 9.20% $ 923,692.17 $ 889,441.14 $ 900,419.38 $ 1,008,001.70 Operating Income (Loss) $ 441,564.87 26.48% $ 558,505.24 $ 502,410.61 $ 475,865.14 $ 353,864.13 Interest Expense 4,536.77 -47.60% 2,377.44 2,457.47 2,645.57 2,647.86 Other Expenses - Tax Equivalent 3,073.09 95.60% 6,010.98 6,010.98 6,010.98 6,010.98 Other Expense - Loss on Retirement of Equipment $ - $ - $ - $ - $ - Total Other Expenses (Income) $ 7,609.86 10.23% $ 8,388.42 $ 8,468.45 $ 8,656.55 $ 8,658.84 Net Income (Loss) $ 433,955.01 26.77% $ 550,116.82 $ 493,942.16 $ 467,208.59 $ 345,205.29 EBITDA $ 543,079.90 $ 659,053.74 $ 605,673.33 $ 565,148.49 $ 448,124.22  CDE Lightband Cash Flow Statement - Broadband Division December 31, 2020 RECONCILIATION OF OPERATING INCOME TO NET CASH PROVIDED BY OPER ACTIVITIES: Operating income (loss) $ 558,505.24 Adjustments to reconcile oper income to cash provided (used) by operating activities Depreciation and amortization 100,548.50 Changes in: Accounts receivable 206,485.41 Advances to Electric (260,568.29) Inventory (403.20) Accounts payable (90,477.24) Accrued expenses (49,849.33) Customer deposits - Other (7,724.11) Net Cash From Operating Activities 456,516.98 CASH FLOWS FROM FINANCING ACTIVITIES: Payment of long term debt - Additions to plant (458,544.36) Net Cash Used by Financing Activities (458,544.36) NET DECREASE IN CASH AND CASH EQUIVALENTS $ (2,027.38) CASH AND CASH EQUIVALENTS - BEG OF MONTH 5,256,167.33 CASH AND CASH EQUIVALENTS - END OF MONTH $ 5,254,139.95 CDE Lightband Subscriber Analysis October 2020 - December 2020 G October Actual November Actual December Actual r o w Net Gain October Growth % Net Gain November Growth % Net Gain December Growth % t October October October Over Prev. % Growth Prior Year Year Over November November November Over Prev. % Growth Prior Year Year Over December December December 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,177 5,302 (125) 25 -2% 5,176 0% 5,191 5,254 (63) 14 -1% 5,146 1% 5,191 5,242 (51) 0 -1% 5,070 2% Lightband Basic 361 331 30 2 9% 365 -1% 356 329 27 (5) 8% 371 -4% 354 329 25 (2) 8% 373 -5% Lightband Plus 1,721 1,779 (58) 8 -3% 1,911 -10% 1,713 1,763 (50) (8) -3% 1,923 -11% 1,725 1,756 (31) 12 -2% 1,915 -10% Lightband Extra 2,329 2,460 (131) (27) -5% 2,866 -19% 2,314 2,437 (123) (15) -5% 2,821 -18% 2,280 2,433 (153) (34) -6% 2,751 -17% Streaming Services 737 704 33 42 0% 0 779 697 82 42 0% 0 803 696 107 24 0% 0 Other Pkgs 29 28 1 0 4% 34 -15% 29 28 1 0 4% 31 -6% 29 28 1 0 4% 31 -6% Internet (Total) 23,450 23,547 (97) 145 0% 21,898 7% 23,585 23,625 (40) 135 0% 21,887 8% 23,713 23,760 (47) 128 0% 21,894 8% Residential Internet 21,683 21,704 (21) 137 0% 20,274 7% 21,806 21,771 35 123 0% 20,249 8% 21,909 21,900 9 103 0% 20,251 8% Business Internet 1,767 1,843 (76) 8 -4% 1,624 9% 1,779 1,854 (75) 12 -4% 1,638 9% 1,804 1,860 (56) 25 -3% 1,643 10% Phone (Total) 2,535 2,525 10 11 0% 2,559 -1% 2,534 2,570 (36) (1) -1% 2,549 -1% 2,533 2,498 35 (1) 1% 2,544 0% Residential Phone 1,722 1,744 (22) 1 -1% 1,798 -4% 1,715 1,735 (20) (7) -1% 1,789 -4% 1,704 1,729 (25) (11) -1% 1,782 -4% Business Phone 813 781 32 10 4% 761 7% 819 835 (16) 6 -2% 760 8% 829 769 60 10 8% 762 9% Total Broadband Customers 24,256 24,583 (327) 123 -1% 22,982 6% 24,386 24,702 (316) 130 -1% 23,007 6% 24,386 24,832 (446) 0 -2% 23,014 6%  CDE Lightband Rolling 4 Month Balance Sheet - Electric Division December 31, 2020 Prior Year 12/31/2019 % Change 12/31/2020 11/30/2020 10/31/2020 9/30/2020 UTILITY PLANT 1 Electric Plant $ 307,045,501.33 5.79% $ 324,822,037.88 $ 323,619,005.70 $ 322,476,696.71 $ 319,024,502.77 2 Less Depreciation (104,975,954.84) 7.15% (112,480,091.90) (111,489,853.49) (110,615,736.69) (109,711,064.49) 3 Total $202,069,546.49 5.08% $212,341,945.98 $212,129,152.21 $211,860,960.02 $209,313,438.28 4 Unamortized acq. adj. 54,081.54 -66.67% 18,027.18 21,031.71 24,036.24 27,040.77 6 Total Plant - Net $202,123,628.03 5.06% $212,359,973.16 $212,150,183.92 $211,884,996.26 $209,340,479.05 OTHER PROPERTY AND INVESTMENTS 8 Interdivisional loan 6,645,931.13 -56.43% 2,895,931.13 2,895,931.13 2,895,931.13 2,895,931.13 9 Sinking Funds 8,013,295.02 11.15% 8,907,088.70 7,906,614.45 6,906,259.73 6,906,090.49 12 Other Special Funds - - - - - 13 Total 14,659,226.15 -19.48% 11,803,019.83 10,802,545.58 9,802,190.86 9,802,021.62 CURRENT AND ACCRUED ASSETS 14 General Cash/temp cash investments 9,056,555.66 71.61% 15,541,650.85 11,512,604.69 9,721,720.78 10,223,600.56 14.1 Reserved Cash 24,533,763.23 -14.15% 21,063,156.76 23,006,728.40 23,000,278.86 22,839,553.45 15 Accounts Receivable 11,466,436.60 15.16% 13,204,477.69 11,061,117.27 11,749,601.49 14,063,721.12 16 Materials and Supplies 4,320,330.04 -23.88% 3,288,709.97 3,210,672.47 3,135,879.05 2,904,626.49 18 Other Current Assets 24,598,318.37 -26.91% 17,977,681.85 18,253,523.17 21,528,282.36 23,877,412.80 19 Total 73,975,403.90 -3.92% 71,075,677.12 67,044,646.00 69,135,762.54 73,908,914.42 DEFERRED DEBITS 22 Clearing Accounts 26,037.26 15,927.78 16,766.07 17,604.36 18,442.65 24 Energy Service Loans Rec 2,043,088.40 -36.35% 1,300,405.22 1,359,354.09 1,422,771.40 1,477,989.84 26 Other Deferred Debits 4,455,350.59 -16.42% 3,723,922.96 3,881,531.33 4,423,401.48 4,503,713.85 27 Total 6,524,476.25 -22.75% 5,040,255.96 5,257,651.49 5,863,777.24 6,000,146.34 28 TOTAL ASSETS & OTHER DEBITS $297,282,734.33 1.01% $300,278,926.07 $295,255,026.99 $296,686,726.90 $299,051,561.43 CAPITAL EARNINGS REINVESTED IN SYSTEM ASSETS 33 Beginning of year 181,656,853.69 5.53% 191,710,376.76 191,710,376.76 191,710,376.76 191,710,376.76 34 Current Year to Date 6,446,929.65 15.92% 7,473,427.09 6,515,374.82 6,686,216.66 5,562,101.32 35 Total 188,103,783.34 5.89% 199,183,803.85 198,225,751.58 198,396,593.42 197,272,478.08 Long Term Debt 39.1 Bonds and other Long Term Debt 59,540,000.00 -5.30% 56,385,000.00 56,385,000.00 56,385,000.00 56,385,000.00 40 Debt Premium and discount 7,735,339.94 -7.67% 7,142,119.94 7,191,554.94 7,240,989.94 7,290,424.94 41 Total 67,275,339.94 -5.57% 63,527,119.94 63,576,554.94 63,625,989.94 63,675,424.94 OTHER NON-CURRENT LIABILITIES 39.2 Post Retirement Benefits 1,612,709.90 6.19% 1,712,505.05 1,716,306.94 1,719,579.88 1,723,783.51 42 Energy Service Loans - Advances 2,132,834.77 -35.93% 1,366,459.76 1,430,437.27 1,485,698.28 1,538,089.62 44 Total 3,745,544.67 -17.80% 3,078,964.81 3,146,744.21 3,205,278.16 3,261,873.13 CURRENT AND ACCRUED LIABILITIES 46 Accounts Payable 27,165,854.21 -15.61% 22,924,070.60 18,588,314.05 20,070,307.87 23,953,267.58 47 Customer Deposits 6,982,503.70 4.82% 7,318,773.71 7,314,028.67 7,280,496.15 7,197,748.97 52.2 Interest Accrued - Other 866,770.80 -3.50% 836,408.20 627,306.15 418,204.10 209,102.05 53 Other Current Liabilities 3,142,937.67 8.49% 3,409,784.96 3,776,327.39 3,689,857.26 3,481,666.68 54 Total 38,158,066.38 -9.62% 34,489,037.47 30,305,976.26 31,458,865.38 34,841,785.28 58 TOTAL LIABILITIES AND OTHER CREDITS $ 297,282,734.33 1.01% $ 300,278,926.07 $ 295,255,026.99 $ 296,686,726.90 $ 299,051,561.43  CDE Lightband Revenues and Expenses ‐ Electric Division 12/31/2020 Prior Year Prior 3 Months 12/31/2019 % Change 12/31/2020 11/30/2020 10/31/2020 9/30/2020 OPERATING REVENUE 59 Electric Sales Revenue 14,350,440.27 1.03% 14,498,894.87 10,881,361.61 11,412,614.53 14,621,297.95 60 Revenue from Late Payments 123,409.35 ‐8.58% 112,822.00 69,374.46 106,917.34 132,893.83 61 Misc Service Revenue 121,452.14 ‐29.35% 85,801.18 121,883.00 74,170.12 107,285.70 62 Rent from Electric Property 308,183.59 2.63% 316,295.65 249,623.30 314,601.01 313,741.41 63 Other Electric Revenue 0.56 87.50% 1.05 0.46 0.73 0.49 64 Total Operating Revenue 14,903,485.91 0.74% 15,013,814.75 11,322,242.83 11,908,303.73 15,175,219.38 PURCHASED POWER 65 Total Power Cost 10,719,212.51 0.77% 10,801,932.98 8,226,007.50 7,321,610.16 9,348,678.96 OPERATING EXPENSE 66 Transmission Expense 2,998.66 38.93% 4,165.91 2,407.66 3,947.11 3,256.94 67 Distribution Expense 244,233.03 54.80% 378,077.91 170,481.32 314,696.79 377,303.70 68 Customer Accounts Expense 285,176.54 ‐39.02% 173,894.47 303,574.23 335,998.64 474,776.97 69 Cust. Service and Inf. Exp. 34,059.57 3.17% 35,139.57 26,884.64 51,277.07 34,981.60 70 Sales Expense 10,700.06 6.56% 11,402.40 9,207.84 8,639.62 5,149.90 71 Admin. And General Expense 397,032.37 ‐29.49% 279,959.00 430,112.02 403,818.02 427,028.50 72 Operating Expense 974,200.23 ‐9.40% 882,639.26 942,667.71 1,118,377.25 1,322,497.61 MAINTENANCE EXPENSE 73 Transmission Expense 1,312.51 327.72% 5,613.88 2,734.78 4,542.27 6,008.98 74 Distribution Expense 306,552.47 8.59% 332,883.18 225,505.62 291,245.50 207,099.72 75 Admin. and General Expense 169,526.25 19.37% 202,363.01 222,125.31 177,972.18 150,363.21 76 Maintenance Expense 477,391.23 13.29% 540,860.07 450,365.71 473,759.95 363,471.91 OTHER OPERATING EXPENSE 77 Depreciation Expense 1,054,320.53 11.11% 1,171,444.94 1,142,284.66 1,142,748.96 1,140,897.04 78 Amort. of Acquisition Adjust. 3,004.53 0.00% 3,004.53 3,004.53 3,004.53 3,004.53 79 Taxes and Tax Equivalents 560,410.72 7.83% 604,283.48 572,130.55 569,164.91 571,751.58 80 Total other oper. Expense 1,617,735.78 9.95% 1,778,732.95 1,717,419.74 1,714,918.40 1,715,653.15 Total operating expense and 81 purchased power 13,788,539.75 1.56% 14,004,165.26 11,336,460.66 10,628,665.76 12,750,301.63 INCOME 82 Operating Income 1,114,946.16 ‐9.44% 1,009,649.49 (14,217.83) 1,279,637.97 2,424,917.75 83 Other Income 53,336.37 140.46% 128,251.33 23,191.13 24,325.77 24,222.62 84 Total Income 1,168,282.53 ‐2.60% 1,137,900.82 8,973.30 1,303,963.74 2,449,140.37 85 Misc Income Deductions ‐ ‐ ‐ ‐ ‐ 86 Net Income before debt expense 1,168,282.53 ‐2.60% 1,137,900.82 8,973.30 1,303,963.74 2,449,140.37 DEBT EXPENSE 90 Interest on Long Term Debt 235,270.09 ‐3.23% 227,679.44 227,679.44 227,679.44 227,679.44 92 Other Interest Expense 1,517.00 5.74% 1,604.11 1,570.70 1,603.96 1,576.72 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,352.09 ‐4.01% 179,848.55 179,815.14 179,848.40 179,821.16 NET INCOME 96 Income before Extraord. Items 980,930.44 ‐2.33% 958,052.27 (170,841.84) 1,124,115.34 2,269,319.21 97 Extraordinary Items ‐ ‐ ‐ ‐ ‐ 98 Net Income 980,930.44 ‐2.33% 958,052.27 (170,841.84) 1,124,115.34 2,269,319.21  CDE Lightband Cash Flow Statement - Electric Division December 31, 2020 RECONCILIATION OF OPERATING INCOME TO NET CASH PROVIDED BY OPER ACTIVITIES: Operating income $ 1,009,649.49 Adjustments to reconcile oper income to cash provided (used) by operating activities Depreciation and amortization 1,174,449.47 Changes in: Accounts receivable (2,143,360.42) Materials and supplies (78,037.50) Interdivisional loan - Accounts receivable - TVA Energy Service Loans 58,948.87 Advances - TVA Energy Service Loans (63,977.51) Prepayments - Other current assets 382,690.76 Accounts payable 4,335,756.55 Accrued expenses 209,102.05 Customer deposits 4,745.04 Other postemployment benefits (3,801.89) Other (366,542.43) Net Cash Provided by Operating Activities 4,519,622.48 CASH FLOWS FROM FINANCING ACTIVITIES: Additions to plant (1,384,238.71) Payment of long-term debt (49,435.00) Net Cash used by Financing Activities (1,433,673.71) NET INCREASE IN CASH AND CASH EQUIVALENTS $ 3,085,948.77 CASH AND CASH EQUIVALENTS - BEG OF MONTH 42,425,947.54 CASH AND CASH EQUIVALENTS - END OF MONTH $ 45,511,896.31 CASH AND CASH EQUIVALENTS CONSIST OF: Sinking Funds 8,907,088.70 Construction Funds - General cash/temp cash investments 15,541,650.85 Reserved Cash 21,063,156.76 $ 45,511,896.31 Department of Finance & Revenue December 2020 Financial Review Fiscal Year 2021 Clarksville, Tennessee December 31, 2020  General Fund Revenues vs. Expenditures Fiscal Year 2021 As of December 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,813,328 (83,260) September 4,725,612 7,493,615 (2,768,003) October 5,330,915 7,626,453 (2,295,538) November 6,760,414 6,173,673 586,741 December 21,640,931 12,970,093 8,670,837 January - February - March - April - May - June - YTD Total $ 53,632,233 $ 47,078,020 $ 6,554,214 $25,000,000 $20,000,000 $15,000,000 FY 2021 Revenues $10,000,000 FY 2021 Expenditures $5,000,000 $-  General Fund Revenue Comparison Fiscal Year 2021 As of December 31, 2020 FY 2021 FY 2020 Variance Revenue Revenue July $ 9,444,294 $ 5,454,774 $ 3,989,520 August 5,730,068 $ 5,286,834 443,234 September 4,725,612 $ 4,836,616 (111,004) October 5,330,915 $ 5,059,278 271,637 November 6,760,414 $ 7,710,416 (950,002) December 21,640,931 $ 18,909,185 2,731,746 January - - February - - March - - April - - May - - June - - YTD Total $ 53,632,233 $ 47,257,102 $ 6,375,131 $63,000,000 $53,000,000 $43,000,000 $33,000,000 FY2020 YTD Revenue FY2021 YTD Revenue $23,000,000 FY2021 YTD Budgeted Revenue $13,000,000 $3,000,000  GENERAL FUND REVENUES Fiscal Year 2021 As of December 31, 2020 Total Budget YTD Month TAXES Prior Year Property Taxes 894,712 861,948 79,755 2020 Property Taxes 34,346,266 16,531,498 14,348,305 PiLOTS 687,473 74,808 74,808 Local Option Sales Tax 20,238,985 10,141,232 3,371,337 Beer & Liquor Tax 4,553,322 2,505,998 414,142 Business License 3,202,692 1,251,968 73,047 Franchise Tax (cable) 1,500,932 294,845 - Hote/Motel 350,000 180,322 32,603 Other Taxes 366,887 149,681 33,976 TOTAL TAXES 66,141,269 31,992,300 18,427,973 LICENSES AND PERMITS Building Permits 2,700,000 1,615,170 314,309 Other Permits 129,309 55,355 7,840 TOTAL PERMITS 2,829,309 1,670,525 322,149 INTERGOVERNMENTAL Grant reimbursements 988,157 13,875 13,875 State Shared Revenues TVA Replacement Tax 1,595,148 379,876 - State Sales Tax 11,431,894 6,349,741 1,115,013 State Street Aid 4,917,044 2,540,801 421,285 Other Taxes 1,990,380 817,398 92,021 TOTAL INTERGOVERNMENTAL 20,922,623 10,101,690 1,642,194 OTHER REVENUES Charges for Services 624,671 300,439 49,186 Recreation 403,010 95,594 15,977 Golf Courses 737,318 414,300 22,669 Fines and Forefeitures 553,792 225,249 31,316 Investment & Interest Earnings 175,995 15,770 1,702 Other Misc. Revenues 1,024,543 221,663 33,742 Extraordinary Sources (COVID Funds) 5,841,737 4,513,827 362,447 Transfer from CDE 5,197,147 2,439,587 409,431 Transfer From CGW 3,628,651 1,511,938 302,388 Other Transfers 817,696 129,350 19,756 TOTAL OTHER REVENUES 19,004,560 9,867,718 1,248,614 TOTAL REVENUES GENERAL FUND 108,897,761 53,632,233 21,640,931  General Fund Expenditure Comparison Fiscal Year 2021 As of December 31, 2020 FY 2021 FY 2020 Variance Expenditures Expenditures July $ 7,000,858 $ 8,407,620 $ (1,406,762) August 5,813,328 $ 6,844,729 (1,031,401) September 7,493,615 $ 8,912,821 (1,419,207) October 7,626,453 $ 8,818,714 (1,192,261) November 6,173,673 $ 6,798,578 (624,905) December 12,970,093 $ 6,760,944 6,209,149 January - - February - - March - - April - - May - - June - - YTD Total $ 47,078,020 $ 46,543,407 $ 534,613 $62,000,000 $52,000,000 $42,000,000 FY2020 YTD Expenditures $32,000,000 FY2021 YTD Expenditures $22,000,000 FY2021 YTD Budgeted Expenditures $12,000,000 $2,000,000  General Fund Year-to-Date Departmental Budget vs. Actual Expenditures Fiscal Year 2021 As of December 31, 2020 $30,000,000 Expenditures Estimated Variance FY 2021 YTD YTD Budget (Over)Under $25,000,000 Departmental: $20,000,000 Police $ 14,521,193 $ 16,658,931 $ 2,137,738 Fire 9,123,778 10,506,762 1,382,984 $15,000,000 FY 2021 Actual YTD Highway & Street 6,416,868 7,379,557 962,689 $10,000,000 Parks & Rec. & Golf 3,764,915 4,589,492 824,577 $5,000,000 Building & Codes 944,470 1,141,920 197,450 FY2021 Total $0 Info. Technology 922,227 976,190 53,963 Budget Finance 823,704 970,659 146,954 City Garage 521,445 713,834 192,389 Municipal Properties 273,273 375,059 101,786 Human Resources 484,288 594,721 110,433 Legislative / Admin. 281,252 326,982 45,730 Mayor's Office 320,620 363,854 43,234 City Court 191,299 229,916 38,616 $1,100,000 Legal 185,911 210,247 24,336 $1,000,000 $900,000 Internal Audit 158,450 204,672 46,221 $800,000 Purchasing 83,367 103,698 20,331 $700,000 Departmental Total 39,017,060 45,346,491 6,329,430 $600,000 $500,000 FY 2021 $400,000 Actual YTD Nondepartmental: $300,000 Debt 4,683,509 5,391,260 707,751 $200,000 FY2021 Total $100,000 Extraordinary - COVID 1,131,013 2,245,102 1,114,089 Budget $0 Transit 74,008 767,255 693,247 Retirees 690,952 897,267 206,314 Other 1,481,478 1,584,524 103,046 YTD Total $ 47,078,020 $ 56,231,897 $ 9,153,877  Schedule of Sales Tax Collections Fiscal Year 2021 As of December 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 1,376,154 1,461,197 1,553,548 1,747,769 October 1,330,621 1,576,737 1,541,129 1,677,233 November 1,443,473 1,509,818 1,547,242 1,729,856 December 1,357,713 1,602,804 1,559,998 1,806,872 January February March April May June YTD Total $ 8,386,388 $ 9,227,239 $ 9,393,535 $ 10,638,741 City of Clarksville $12,500,000 $10,500,000 $8,500,000 $6,500,000 $4,500,000 $2,500,000 $500,000 FY 2018 FY 2019 FY 2020 FY 2021  Local Sales Tax Collections Fiscal Year 2021 As of December 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 7,120,548 100,012 1,666,037 81,733 5,272,767 588,563 6,613,002 81,018 October 6,794,013 93,645 1,598,799 78,434 5,023,135 525,200 6,346,115 77,302 November 7,168,367 106,174 1,648,961 80,895 5,332,337 704,705 6,545,224 81,562 December 7,393,332 105,297 1,722,376 84,496 5,481,163 640,825 6,836,628 84,121 January - February - March - April - May - June - YTD TOTAL $ 43,450,878 $ 615,190 $ 10,141,232 $ 497,509 $ 32,196,947 $ 3,691,657 $ 40,253,605 $ 494,384 Monthly Distribution 1.42% 23.30% 1.14% COUNTY CITY 74.14% CITY ROADS SCHOOLS  Capital Project Status Report Fiscal Year 2021 As of December 31, 2020 TOTAL ACTIVE ACTIVE PROJECTS TOTAL FY EXPENSES PROJECT PROJECT FY2020-2021 FUNDING 7/1/20-12/31/20 BALANCE EXPENSES ** STREET DEPARTMENT: 93101 Rossview/Dunbar Cave/Cardinal Improvements 13,280,000 606,304 3,371,940 9,908,061 14301 Edmondson Ferry/1A Bypass Interesection Improvement 1,150,004 0 1,150,002 2 15306 Northeast Connector 16,808,700 161,944 1,427,721 15,380,979 17301 International & Dunlop Intersection Improvement 2,807,831 0 445,506 2,362,325 17304 Adaptaive Signal Control Project (Wilma) 1,200,000 106,408 106,408 1,093,592 17305 Tylertown & Oakland Intersection Improvement 10,000,000 303,612 1,215,711 8,784,289 17307 Tylertown & Trenton Drainage Overflow Project 3,540,185 33,495 107,242 3,432,943 18301 Drainage Mitigation FY2018 280,801 0 106,642 174,159 18302 New Sidewalks FY2018 934,954 720,652 869,976 64,978 19301 Lilac Lane 100,000 0 2,600 97,400 19302 Whitfield Road Improvements 15,850,000 349,628 1,658,758 14,191,242 19303 Spot Intersection Improvements 1,500,000 46,405 140,542 1,359,458 20301 Dunbar Cave Road Bridge 600,000 466,246 466,746 133,254 20302 4th Street and College Signal 400,000 91,297 129,289 270,711 20303 New Sidewalks FY20-24 1,850,000 0 843,791 1,006,209 20304 Drainage Mitigation FY20-24 569,199 750 750 568,449 20305 Cemetary Retaining Wall 510,000 494,285 495,785 14,215 21301 Storm Sewer Rehab 350,000 0 0 350,000 21302 College Street Streetscape 300,000 0 0 300,000 21303 College Street SCO Repair/Replace 500,000 0 0 500,000 $ 72,531,674 $ 3,381,026 $ 12,539,408 $ 59,992,266 PARKS & RECREATION: 16503 Athlectic Complex 19,667,813 255,608 5,006,353 14,661,460 16504 Red River East Trail Project 2,403,712 144,474 2,298,860 104,852 17501 Valleybrook Park & Upland Trail Connection 0 0 0 0 17502 Public Spaces 150,000 0 150,000 0 17503 Edith Pettus Park Renovations 201,800 0 23,615 178,185 17504 Crow Community Center Renovation 370,000 197,091 316,957 53,043 17505 Liberty Park/Marina Remediation 905,218 168,238 271,019 634,199 17506 Swan Lake Renovations 1,046,605 0 1,039,218 7,387 19502 Pollard Road Additional Parking 229,199 71,814 299,515 -70,316 19503 Billy Dunlop Pavillion & Restroom 382,485 0 380,591 1,894 19504 Heritage Park Improvements 1,000,000 77,427 586,048 413,952 19505 Regional Community Center 500,000 0 0 500,000 20501 Red River Pedestrian Bridge 3,068,233 20,125 31,806 3,036,427 20502 Mason Rudolph Cart Path Paving 0 0 0 0 20503 Swan Lake Cart Path Paving 190,800 0 187,700 3,100 20504 Burt Cobb Recreation Center Roof 230,000 32,443 223,932 6,068 21501 Marina Dredging at Red River East 330,000 14 14 329,986 $ 30,675,865 $ 967,235 $ 10,815,629 $ 19,860,236 FIRE DEPARTMENT: 16221 Fire Maintenance Facility 1,666,377 187,436 235,688 1,430,689 20221 Renovation of Station 10 0 0 0 0 20222 Custom Engine (replaces 1999 model) 590,000 588,374 588,374 1,626 21221 New Admin Building 200,000 0 0 200,000 21222 New Burn Building 225,000 0 0 225,000 21223 100' Ladder Truck 1,500,000 888 888 1,499,112 21224 New Rescue Truck 350,000 444 444 349,556 $ 4,531,377 $ 777,141 $ 825,393 $ 3,705,984 POLICE DEPARTMENT: 19211 District 3 Precinct Building 3,500,000 1,146,445 1,338,697 2,161,303 21211 Vista Lane Renoation 60,000 0 0 60,000 $ 3,560,000 $ 1,146,445 $ 1,338,697 $ 2,221,303 GENERAL GOVERNMENT: 41016 Corporate Business Park Expansion $ 14,368,821 $ - $ 14,092,700 $ 276,121 13101 Clarksville Performing Arts & Conf Center 7,834,713 0 179,907 7,654,806 15102 TDOT 2013 Multimodal Access 206,017 0 169,830 36,187 16103 2015 Multimodal Access Grant 241,189 0 222,043 19,146 19101 New Council Chambers 0 0 0 0 19102 Structural Repairs - Cumberland Garage 1,099,036 0 0 1,099,036 20101 Frosty Morn 1,200,000 342,004 346,504 853,496 $ 24,949,776 $ 342,004 $ 15,010,984 $ 9,938,792 debt issuance costs Total Spent YTD: Major Projects $ 136,248,692 $ 6,613,852 $ 40,530,111 $ 95,718,581 * 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 December 31, 2020 Estimated Estimated Ending Beginning Fund Revenues Expenditures Fund Fund Balance Balance YTD YTD 12/31/20 7/01/20 General Fund: $ 26,757,752 $ 53,632,233 $ 47,078,020 $ 33,311,966 Capital Projects Fund: 558,793 3,033,868 6,613,852 (3,021,190) Debt Service Fund: 502,905 4,658,564 4,648,660 512,808 Internal Service Funds: 8,800,626 7,382,261 9,727,474 6,455,413 Non-Major Governmental Funds: Drug Fund 754,410 175,963 62,154 868,220 Road Improvement Fund 1,290,400 497,509 0 1,787,909 Police Special Fund 165,524 119,729 188,507 96,745 Parks Special Fund 261,198 89,890 125,122 225,967 Other Special Revenue Fund* 812,813 282,012 489,440 605,385 Community Development 496,555 112,596 438,511 170,640 Capital Projects Revenue District Fund 467,556 0 0 467,556 * Includes: Fire Spec. Rev., Traffic Camera Police & Parks, SRF  Notice of Grant Applications Fiscal Year 2021 As of December 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 Not funded Firefighters Grant Homeland Security training for CFD. 2021 Alcohol & Funding for alcohol and impaired driver countermeasures. Pays for overtime for TN Highway Safety 03/25/20 Impared Driving 133505.4 125000 $0 Awarded officers to conduct DUI checkpoints and saturation patrols for a one year period. Office (THSO) Enforcement Including purchase of equipment for DUI checkpoints. 2021 Child Passenger TN Highway Safety Funding for child safety seats and booster seats to provide to low income families 03/25/20 Safety and Occupant $10,564 $0 Not funded Office (THSO) and staff time for events/enforcement of proper use of child passenger restraints. Protection 2021 TN Highway Safety Funding for training of officers for bicycle/pedestrian crash investigations, staff 03/27/20 Bicycle/Pedestrian $13,544 $0 Not funded Office (THSO) time for enforcement and public awareness activities. Safety 2021 Distracted TN Highway Safety Funding to purchase driving simulators for distracted driving educational 03/30/20 $28,850 $0 Not funded Driving Office (THSO) purposes and public events. 2020 Assistance to Federal funding to reimburse for PPE expenses incurred related to COVID19 as Firefighters - US Dept of 05/15/20 $56,563 $5,656 Awarded well as expected PPE expenses through May 2021. Funding only covers face COVID19 Homeland Security masks, gloves and gowns used by firefighters on calls. Supplement 2019 Staffing for Requested funding to hire 15 new firefighters. Funding would cover 100% to Adquate Fire and US Dept of 05/20/20 $2,713,365 $0 Awarded entry level salaries and benefits for 3 years. Share has been waived due to Emergency Response Homeland Security COVID19. Match was waived. (SAFER) 2019 Fire Prevention US Dept of Federal funding to purchase a new fire safety trailer and training for two CFR 05/27/20 $60,683 $3,034 Not funded and Safety Homeland Security staff to become certified Fire and Safety Educators 2020 Coronavirus Emergency Allocation to cover expenses related to COVID, both past and future anticipated 05/29/20 US Dept of Justice $191,575 $0 Awarded Supplemental Funding expenses through January 2022 (CESF) TN Agriculture TN Dept of 06/01/20 2930 2920 2930 2920 Awarded Requested funding to plant 26 trees along the riverbank at Trice Landing Enhancement Program Agrculture 2020 Edward Byrne Annual share with Sherif's Office. CPD will purchase face shields and gas masks 08/17/20 Memorial Justice US DOJ $58,694 $0 Awarded for officer safety - county will purchase communication equipment, software and Grant JAG wireless communications services  Investment Report Fiscal Year 2021 As of December 31, 2020 ISSUER NAME PAR VALUE CUSIP COUPON RATE LOCAL GOVERNMENT INVESTMENT POOL SELF-INSURANCE $ 592,712 0.160 CAPITAL PROJECTS FUNDS 1,746,468 0.160 INVESTMENT ACCOUNT 11,475,424 0.160 2016 BOND ISSUANCE 446,612 0.160 LGIP TOTAL / AVERAGE $ 14,261,217 0.160 2016 BOND ISSUANCE SELF-INSURANCE CAPITAL PROJECTS FUNDS INVESTMENT ACCOUNT