Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
09.b EDB 2023 12 Board Financial Packet
. .� cot,,�, Clay County Utility Authority Working together to 3176 Old Jennings Road protect public health, Middleburg,FL 32068-3907 conserve our natural GPI Ci Telephone(904)272-5999 resources,and create 'en'- long-term value for Y AUTN: www.clayutility.org our ratepayers. March 14, 2024 To: Board of Supervisors From: Jeffrey Wesselman Re: December 2023 Financial Package I have enclosed the following financial information: A) Comparative Financial Statements for the three months of fiscal years 2023/2024 and 2022/2023. Comparative Balance Sheet Revenue & Expenditure Report Cash-flow Statement B) Cash &Cash Equivalents Report at December 31, 2023 C) Budget Reports for the two months of Fiscal Year 2023/2024 Operating and Interest Revenue Detail Budget Report Operating Expense Detail Budget Report D) Contributions In Aid of Construction (CIAC) Reports: Summary of total CIAC through December 31, 2023 Alternative Water Supply Details E) Capital Projects Reports: Capital Projects Budget Report F) Operating Detail by Month Operating Revenues Detail by Month Revenue Analysis Summary Operating Expense Detail by Month G) Other Reports Construction Department Budget Deferred Connection Report Key Performance Indicators Operating income is$716,001 (17%) over budget due to a unfavorable revenue and favorable expense variance. Operating revenue is$530,277 (3%) under budget and Operating expenses are$1,246,279 (11%) under budget. Itemized operating expense variances are in Section C. We gained 222 active (Residential 185, General Service 37)water accounts and 224 active sewer(Residential 188, General Service 36) accounts for the fiscal year 2023/2024 as compared to an increase of 188 active water accounts and an increase of 188 active sewer accounts for the same time in fiscal year 2022/2023. 1 CLAY COUNTY UTILITY AUTHORITY COMPARATIVE FINANCIAL STATEMENTS FISCAL YEAR 2023/2024 Section A 2 03/04/2024 05:24 PM COMPARATIVE BALANCE SHEET FOR CLAY COUNTY UTILITIES Page: 1/1 User: jwesselman DB: Ccua Fund 101 GENERAL FUND PERIOD ENDED PERIOD ENDED GL Number Description 12/31/2022 12/31/2023 *** Assets *** Cash 24,768,446.82 21,623,255.00 Investments 50,823,612.76 81,724,290.62 Accounts Receivable 3,608,729.96 3,452,482.35 Fixed Assets 535,989,574.23 638,789,125.15 Accum. Depreciation (188,062,448.52 (201,925,933.91) Other Assets 2,192,209.18 2,497,702.36 Deferred Outflows 1,651,778.96 1,431,155.16 Total Assets 430,971,903.39 547,592,076.73 *** Liabilities *** Liabilities-ST 17,877,710.83 23,478,530.67 Liabilities-LT (over 1 year) 80,829,925.49 148,715,465.23 Total Liabilities 98,707,636.32 172,193,995.90 *** Fund Balance *** Unassigned 57,795,484.23 62,657,550.17 Investment In Capital Assets 274,130,303.30 312,041,393.39 Total Fund Balance 331,925,787.53 374,698,943.56 Beginning Fund Balance 324,403,223.95 369,223,525.35 Net of Revenues VS Expenditures 338,479.54 699,137.27 Fund Balance Adjustments 7,522,563.58 5,475,418.21 Ending Fund Balance 332,264,267.07 375,398,080.83 Total Liabilities And Fund Balance 430,971,903.39 547,592,076.73 3 03/04/2024 05:26 PM BALANCE SHEET FOR CLAY COUNTY UTILITIES Page: 1/3 User: jwesselman Period Ending 12/31/2023 DB: Ccua Fund 101 GENERAL FUND Current Year GL Number Description Beg. Balance Balance *** Assets *** Cash 101.401.101.110 Cash-BB&T L.A.H.H. Account 465.29 2,322.94 101.401.101.125 '12 BBVA Compass Debt Service 1,757,496.40 403.89 101.401.101.160 Cash-BB&T Operating Account 9,489,949.87 4,871,157.28 101.401.101.161 Cash-BB&T Emergency Account 28,883.05 63,899.00 101.401.101.200 CASH-FSA 12,020.88 28,931.52 101.401.101.329 Debt Stabilization Reserve Unrestricted 963,662.12 1,062,561.39 101.401.101.331 2015/2019 Bond Sinking Fund 3,690,361.06 3,095,899.92 101.401.101.333 SBA - 2001 DEP Loan Debt Service Acct 52,129.09 25,116.90 101.401.101.335 CUSTOMER DEPOSIT FUND 3,792,115.96 3,825,504.14 101.401.101.336 SURPLUS FUND 3,288,855.18 2,422,683.23 101.401.101.337 SELF INSURANCE FUND 525,000.00 525,000.00 101.401.101.338 RENEWAL & REPLACEMENT FUND 230,495.15 590,126.67 101.401.101.340 WATER PLANT FUND (76%) 120,483.96 100,949.37 101.401.101.342 WATER LINE FUND (24%) 35,371.79 132,599.82 101.401.101.343 AWS Cash 2,337,912.19 1,951,380.10 101.401.101.344 SEWER PLANT FUND (53.33%) 1,356,949.47 2,398,137.76 101.401.101.346 SEWER LINE FUND (46.67%) 188,842.01 166,278.14 101.401.101.351 2018 Bond Sinking Fund 175,667.10 357,397.02 101.401.102.100 PETTY CASH FUND 2,905.91 2,905.91 Cash 28,049,566.48 21,623,255.00 Investments 101.401.101.323 Short Term Investments - Surplus 40,593,185.66 40,763,757.22 101.401.101.324 Truist Escrow Investment Account 60,443,265.44 40,960,533.40 Investments 101,036,451.10 81,724,290.62 Accounts Receivable 101.401.115.100 ACCOUNTS RECEIVABLE W&S CUST 1,078,203.10 1,253,790.82 101.401.115.110 A/R CIAC & MISC REPAIR INVS. 1,922,765.10 385,483.93 101.401.115.120 Loans To Customers 37,974.82 30,081.61 101.401.115.121 Loan to Customers Long-term 312,002.83 312,002.83 101.401.115.200 A/R UNBILLED WATER REVENUE 852,819.40 654,288.89 101.401.115.250 A/R Unbilled Reuse Revenue 191,252.91 92,924.64 101.401.115.300 A/R UNBILLED SEWER REVENUE 920,632.60 919,663.65 101.401.115.400 A/R CLEARING ACCOUNT (1,142.20) (2,099.47) 101.401.117.100 ALLOWANCE FOR DOUBTFULL A/R (193,654.55) (193,654.55) Accounts Receivable 5,120,854.01 3,452,482.35 Fixed Assets 101.401.161.900 LAND 5,268,724.07 5,268,724.07 101.401.162.900 BUILDINGS 15,240,674.68 15,240,674.68 101.401.166.900 MACHINERY & EQUIPMENT 510,633,695.66 515,036,737.57 101.401.168.900 Intangible Assets 3,866,031.40 7,498,469.40 101.401.169.900 CONSTRUCTION IN PROGRESS 74,747,287.33 95,744,519.43 Fixed Assets 609,756,413.14 638,789,125.15 Accum. Depreciation 101.401.163.900 ACCUM.DEPRECIATION BUILDINGS (9,748,296.50) (9,962,099.29) 101.401.167.900 ACCUM.DEPR. MACHINERY & EQUIPT (188,471,552.96 (191,963,834.62) Accum. Depreciation (198,219,849.46 (201,925,933.91) Other Assets 101.401.115.150 INTEREST RECEIVABLE 310,102.44 271,120.92 101.401.115.500 PREPAID INSURANCE 1,895.86 953,356.38 101.401.115.550 PREPAID W/C INSURANCE (18,257.58) (36,954.79) 101.401.115.575 PREPAID DEP REGULATORY FEES 22,587.47 38,599.96 101.401.115.600 PREPAID MAINTENANCE & EXPENSES 409,949.68 667,715.28 101.401.141.000 INVENTORY 905,601.21 583,088.58 101.401.141.100 UNUSED POSTAGE 22,883.40 20,776.03 Other Assets 1,654,762.48 2,497,702.36 Deferred Outflows 4 03/04/2024 05:26 PM BALANCE SHEET FOR CLAY COUNTY UTILITIES Page: 2/3 User: jwesselman Period Ending 12/31/2023 DB: Ccua Fund 101 GENERAL FUND Current Year GL Number Description Beg. Balance Balance *** Assets *** 101.401.158.201 Deferred Outflow of Resources 1,481,048.06 1,431,155.16 Deferred Outflows 1,481,048.06 1,431,155.16 Total Assets 548,879,245.81 547,592,076.73 *** Liabilities *** Liabilities-ST 101.401.202.000 ACCOUNTS PAYABLE 11,066,218.27 7,485,042.85 101.401.202.002 Retainage Payable 1,918,384.83 2,377,626.66 101.401.215.100 ACCRUED INTEREST 1,450,132.97 773,991.07 101.401.216.100 ACCRUED WAGES PAYABLE 217,379.05 573,032.66 101.401.216.200 ACCRUED SICK, VACATION PAYABLE 860,654.35 525,516.95 101.401.217.100 EMPLOYEE FIT,FICA,MEDICARE W/H 82,469.57 84,039.03 101.401.217.200 FLORIDA UNEMPLOYMENT/ABANDONED PROP 0.00 29,646.12 101.401.217.300 Employee Fund Withheld 2,076.48 2,082.48 101.401.217.500 ACCRUED PENSION DUE 107,803.34 109,854.97 101.401.217.600 ACCRUED W/C INS. DUE 26,627.43 27,134.20 101.401.218.100 MISC W/H (87.55) (152.65) 101.401.218.250 LIFE INSURANCE (1,073.85) (2,360.41) 101.401.218.703 HMO/PPO (787.67) (256,530.82) 101.401.218.705 DENTAL (297.13) (449.18) 101.401.218.706 VISION (377.78) (500.65) 101.401.218.707 ANCILLARY 5,705.04 11,114.98 101.401.218.900 ACCRUED ELECTRIC EXPENSE DUE 129,063.77 129,063.77 101.401.220.100 BOND DEPOSITS 110,871.10 115,472.19 101.401.220.150 CLEANING WATER DEPOSITS 145,499.72 146,782.81 101.401.220.175 W&S CUSTOMER DEPOSITS 3,801,466.06 3,831,158.56 101.401.220.180 DUE TO LEND A HELPING HAND 465.29 2,322.94 101.401.220.185 Refundable Development Agreements 4,608.41 4,608.41 101.401.223.100 DEFERRED REVENUES WATER 127,157.00 128,522.81 101.401.223.200 DEFERRED REVENUE SEWER 264,667.81 267,772.36 101.401.223.300 Deferred Reuse Revenue 52,959.80 54,065.02 101.401.229.200 JAX PUBLIC SERV.TAX COLLECTED 266.46 275.84 101.401.229.201 Keystone Public Service Tax 32.75 21.55 101.401.232.700 CURRENT BOND PRINCIPAL DUE 7,059,376.15 7,059,376.15 Liabilities-ST 27,431,261.67 23,478,530.67 Liabilities-LT (over 1 year) 101.401.232.569 2012 BBVA Compass Loan 1,901,056.00 0.00 101.401.232.571 SunTrust 2015 Adv Ref 2007 Bonds 33,133,178.00 31,575,245.00 101.401.232.572 2018 Revenue Bonds Payable DEP MIDCLAY 10,462,103.58 10,462,103.58 101.401.232.574 Suntrust 2019 Loan & Refinance 38,165,000.00 38,165,000.00 101.401.232.575 2023 Truist Revenue Bond 75,000,000.00 75,000,000.00 101.401.232.586 2014 DEP Payable 622,497.36 572,492.80 101.401.232.600 CONTRA CURRENT BOND PRINCIPAL (7,059,376.15) (7,059,376.15) Liabilities-LT (over 1 year) 152,224,458.79 148,715,465.23 Total Liabilities 179,655,720.46 172,193,995.90 *** Fund Balance *** Unassigned 101.401.272.000 RETAINED EARNINGS-UNRESERVED 62,657,550.17 62,657,550.17 Unassigned 62,657,550.17 62,657,550.17 Investment In Capital Assets 101.401.240.000 AWS CIAC 8,498,767.35 8,748,631.44 101.401.240.100 SJRWMD Black Creek CIAC 1,445,756.11 1,461,573.24 101.401.254.350 WATER CAPACITY CHARGES 11,856,865.36 11,928,685.36 101.401.254.351 FIRE CAPACITY CHARGES 2,132,781.82 2,148,591.82 5 03/04/2024 05:26 PM BALANCE SHEET FOR CLAY COUNTY UTILITIES Page: 3/3 User: jwesselman Period Ending 12/31/2023 DB: Ccua Fund 101 GENERAL FUND Current Year GL Number Description Beg. Balance Balance *** Fund Balance *** 101.401.254.352 WATER TAP IN CHARGE 2,479,403.92 2,514,428.66 101.401.254.353 WATER CONTRIBUTED ASSETS 61,270,367.19 62,777,300.16 101.401.254.354 WATER MAIN EXTENSION CHARGE 3,547,145.50 3,554,006.22 101.401.254.355 DEBT SERVICE CHARGE 1,720,422.96 1,811,709.46 101.401.254.360 SEWER CAPACITY CHARGES 55,213,975.78 55,907,416.16 101.401.254.361 GRANTS 27,658,205.44 27,748,778.30 101.401.254.362 SEWER TAP IN CHARGE 2,605,628.70 2,621,735.21 101.401.254.363 SEWER CONTRIBUTED ASSETS 122,106,574.53 124,781,953.59 101.401.254.364 SEWER MAIN EXTENSION CHARGE 6,030,080.52 6,036,583.77 Investment In Capital Assets 306,565,975.18 312,041,393.39 Total Fund Balance 369,223,525.35 374,698,943.56 Beginning Fund Balance 369,223,525.35 Net of Revenues VS Expenditures 699,137.27 Fund Balance Adjustments 5,475,418.21 Ending Fund Balance 375,398,080.83 Total Liabilities And Fund Balance 547,592,076.73 6 03/04/2024 05:27 PM REVENUE AND EXPENDITURE REPORT FOR CLAY COUNTY UTILITIES Page: 1/1 User: jwesselman DB: Ccua PERIOD ENDING 12/31/2023 YTD BALANCE YTD BALANCE GL NUMBER DESCRIPTION 12/31/2022 12/31/2023 Fund 101 - GENERAL FUND WATER REVENUES 5,902,292.63 6,619,453.24 SEWER REVENUES 7,485,465.84 8,286,428.93 MISCELLANEOUS REVENUES 481,613.99 432,139.33 INTEREST UNRESTRICTED 233,355.43 222,329.94 INTEREST RESTRICTED 0.00 466,769.88 SALE OF ASSETS 10,100.00 0.00 CONSTRUCTION INCOME 3,781.98 6,906.67 TOTAL REVENUES 14,116,609.87 16,034,027.99 BAD DEBT (2,534.00) 264.58 COMMUNICATION 96,842.74 98,697.32 DUE IN LIEU OF TAXES 602,449.13 670,766.15 ELECTRIC & FUEL EXPENSES 821,428.36 537,144.70 MISCELLANEOUS EXPENSES 91,675.19 123,874.52 PROPERTY & LIABILITY INSURANCE 256,174.65 495,383.54 PROFESSIONAL SERVICES 261,117.99 95,066.05 SLUDGE TREATMENT & DISPOSAL 551,244.82 589,072.24 SUBCONTRACTORS 837,317.11 587,701.76 SUPPLIES 1,150,223.61 1,876,617.11 TRANSPORTATION 135,589.23 168,901.79 WAGES & RELATED EXPENSES 5,008,512.61 5,151,697.06 DEPRECIATION 3,383,377.71 3,699,169.58 INTEREST EXPENSE 542,576.18 1,184,581.36 CONSTRUCTION EXPENSE 42,135.00 55,952.96 TOTAL EXPENDITURES 13,778,130.33 15,334,890.72 Fund 101 - GENERAL FUND: TOTAL REVENUES 14,116,609.87 16,034,027.99 TOTAL EXPENDITURES 13,778,130.33 15,334,890.72 NET OF REVENUES & EXPENDITURES 338,479.54 699,137.27 TOTAL REVENUES - ALL FUNDS 14,116,609.87 16,034,027.99 TOTAL EXPENDITURES - ALL FUNDS 13,778,130.33 15,334,890.72 NET OF REVENUES & EXPENDITURES 338,479.54 699,137.27 7 CLAY COUNTY UTILITY AUTHORITY STATEMENTS OF CASH FLOWS FOR THE THREE MONTHS ENDED DECEMBER 31,2022 AND 2023 December 31,2022 December 31,2023 Cash flows from operating activities $ 1,463,900 $ 2,449,546 Net cash provided by operating activities 1,463,900 2,449,546 Cash flows from capital and related financing activities Proceeds from issuance of bonds and loans - - Principal paid on long-term debt (3,549,928) (3,508,994) Interest paid on long-term debt (955,839) (1,810,830) Payments to acquire and construct plant property (7,522,821) (24,850,400) Capital contributions 2,018,208 1,202,533 Grants 1,369,459 90,573 Net cash used in capital and related financing activities (8,640,920) (28,877,118) Cash flows from investing activities Purchases of investments (195,630) (687,840) Sales of investments 2,000,000 20,000,000 Interest income 233,355 689,100 Net cash provided by investing activities 2,037,725 20,001,260 Net increase(decrease)in cash and cash equivalents (5,139,295) (6,426,311) Cash and cash equivalents,beginning of period 29,907,741 28,049,566 Cash and cash equivalents,end of period $ 24,768,447 $ 21,623,255 Reconciliation of operating income to net cash provided by operating activities Cash flows from operating activities Operating income $ 637,600 $ 1,194,619 Adjustments to reconcile operating income to net cash provided by operating activities: Depreciation expense 3,389,747 3,706,084 Changes in assets and liabilities Decrease(Increase)in accounts receivable 1,274,968 1,668,372 Decrease(Increase)in prepaid items and inventory (1,065,692) (881,921) Decrease(Increase)in notes/interest receivable (16,647) 38,982 Increase(Decrease)in accounts payable (2,710,086) (3,120,078) Increase(Decrease)in accrued expenses (80,140) (197,664) Increase(Decrease)in unearned revenue (20,854) 5,576 Increase(Decrease)in customer deposits 55,002 35,577 Total adjustments 826,300 1,254,927 Net cash provided by operating activities $ 1,463,900 $ 2,449,546 Supplemental schedule of noncash investing,capital,and financing activities Utility plant property contributed by developers $ (151,385,256) $ (178,240,778) 8 Cumulative Cash Flow $160,000,000 ' $140,000,000 lir k $120,000,000 '— $100,000,000 I I I $80,000,000 I I $60,000,000 $40,000,000 $20,000,000 $0 — — titi titi titi titi titi titi titi titi titi titi titi titi ;I?' ti,' ti'' ti� ti� ;I?' ti� ti� ti?' ti' ti, ;I?'a� FP' fat Pic 4\aJ >�� >�\ QJaO 49 Oc'c o"4 Oe, ,so <(e� `S,§ Pit • 4aJ 4' >o� pJa° 42 Oc� ,c, pec, Cash ■Investments CLAY COUNTY UTILITY AUTHORITY CASH AND CASH EQUIVALENTS REPORT As of December 31, 2023 BB&T Ameris SBA Investments Total Lend A Helping Hand Fund $2,323 $2,323 Operating Accounts ** $4,871,157 $4,871,157 FSA Account $28,932 $28,932 Emergency Accounts $63,899 $63,899 Petty Cash $2,906 $2,906 Total Operating Funds $4,966,894 $4,966,894 Public Funds Now: Water Plant Connection Fund $100,949 * $100,949 R Water Line Connection Fund $132,600 * $132,600 R Sewer Plant Connection Fund $2,398,138 * $2,398,138 R Sewer Lines Connection Fund $166,278 * $166,278 R Alternative Water Supply Fund $1,951,380 * $1,951,380 R Renewal&Replacement Fund $590,127 * $590,127 R Debt Stabilization and Reserve Account_Unrestricted $1,062,561 * - - $1,062,561 Truist Escrow Investment Account $40,960,533 $40,960,533 R Surplus Fund $1,767,190 $440,441 $112,634 $40,763,757 $43,084,021 Available For Construction $8,169,223 $440,441 $112,634 $81,724,291 $90,446,588 Debt Service Sinking Funds: 2007A Bond Sinking Fund $3,095,900 * $3,095,900 R DEP Loan Debt Service Sinking Acct $25,117 * $25,117 R BBVA Compass Loan Sinking Funds $404 * $404 R 2018 Bond Sinking Fund $357,397 * $357,397 R Debt Stabilization and Reserve Account_Restricted Letter of Credit_Financial Responsible Officer $102,419 $102,419 R Customer Deposits&Self Insurance Fund Customer Deposits - * $3,825,504 $3,825,504 R Self Insurance Fund_Sewage Backups * Health Insurance - * $500,000 $500,000 Unemployment * $25,000 $25,000 TOTAL Funds $3,581,237 $4,350,504 - - $7,931,741 TOTAL CASH&CASH EQUIVALENTS $16,719,677 $4,790,945 $112,634 $81,724,291 $103,347,546 Investment Accounts Maturity Date Balance APY US Bank Various $40,763,757 2.56% Truist Escrow Investment Account Monthly $40,960,533 3.55% $81,724,291 * BB&T Public Funds Money Checking Accounts $9,880,851 0.25% BB&T Public Funds Money Checking Accounts $4,871,157 0.25% Ameris Public Funds Money Checking Accounts $4,790,945 0.30% SBA $112,634 4.84% Construction Balance $90,446,588 Operating Cash $2,871,157 Available Construction Balance: $93,317,745 "R"indicates fund is Restricted by Bond Resolution,Enabling Legislation or Board Resolution. Printed 2/28/2024 Section B 10 CLAY COUNTY UTILITY AUTHORITY BUDGET REPORTS FISCAL YEAR 2023/2024 Section C 11 03/04/2024 REVENUE AND EXPENDITURE REPORT FOR CLAY COUNTY UTILITIES PERIOD ENDING 12/31/2023 OPERATING BUDGET REPORT 2023-24 YTD BALANCE AVAILABLE %BDGT GL NUMBER DESCRIPTION AMENDED BUDGET 12/31/2023 BALANCE USED OPERATING REVENUES Water Revenues Net Water Base Charges 9,149,204.00 2,235,840.97 6,913,363.03 24.44% Net Water Use Charges 12,140,254.00 2,857,822.62 9,282,431.38 23.54% Net Reuse Water Base Charges 3,758,600.00 934,540.77 2,824,059.23 24.86% Net Reuse Water Usage Charges 2,827,035.00 591,248.88 2,235,786.12 20.91% Net Water Revenues 27,875,093.00 6,619,453.24 21,255,639.76 23.75% Sewage Revenues Net Sewer Base Charges 18,609,426.00 4,645,989.69 13,963,436.31 24.97% Net Sewer Use Charges 15,452,807.00 3,640,439.24 11,812,367.76 23.56% Net Sewage Revenues 34,062,233.00 8,286,428.93 25,775,804.07 24.33% Other Revenues Net Miscellaneous 1,948,323.00 432,139.33 1,516,183.67 22.18% Net Other Revenues 1,948,323.00 432,139.33 1,516,183.67 22.18% Net OPERATING REVENUES 63,885,649.00 15,338,021.50 48,547,627.50 24.01% INTEREST INCOME Net Unrestricted 853,228.74 222,329.94 630,898.80 26.06% Net Restricted 2,396.82 466,769.88 (464,373.06) 19474.55% Net INTEREST INCOME 855,625.56 689,099.82 166,525.74 80.54% OPERATING EXPENSES Net Bad Debt Expenses 500.00 264.58 235.42 52.92% Net Wage Related Expenses 5,677,562.66 1,464,075.96 4,213,486.70 25.79% Net Communication Expenses 445,190.00 98,697.32 346,492.68 22.17% Net Due in Lieu of Taxes 2,787,180.00 670,766.15 2,116,413.85 24.07% Net Electric&Fuel Expenses 3,424,866.00 537,144.70 2,887,721.30 15.68% Net Miscellaneous Expenses 508,598.00 123,874.52 384,723.48 24.36% Net Property&Liability Insurance 1,715,193.00 495,383.54 1,219,809.46 28.88% Net Professional Services 1,372,189.24 175,696.31 1,196,492.93 12.80% Net Sludge Treatment&Disposal 2,805,750.00 589,072.24 2,216,677.76 21.00% Net Subcontractors 5,264,150.56 577,449.32 4,686,701.24 10.97% Net Supplies 6,221,646.64 1,876,617.11 4,345,029.53 30.16% Net Transportation Expenses 732,940.00 168,901.79 564,038.21 23.04% Net Wage Expense 14,855,843.19 3,617,243.28 11,238,599.91 24.35% Net OPERATING EXPENSES 45,811,609.29 10,395,186.82 35,416,422.47 22.69% NON-OPERATING EXPENSES Net Depreciation Expense 13,615,661.00 3,699,169.58 9,916,491.42 27.17% Net Interest Expense 2,914,754.00 1,184,581.36 1,730,172.64 40.64% Net Loss(Gain)on Sale of Assets 0.00 0.00 0.00 100.00% Net NON-OPERATING EXPENSES 16,530,415.00 4,883,750.94 11,646,664.06 29.54% Net CONSTRUCTION EXPENSES 526,841.46 55,952.96 470,888.50 10.62% Net CONSTRUCTION INCOME 526,841.00 6,906.67 519,934.33 1.31% Net CONTINGENCY 775,383.00 0.00 775,383.00 0.00% TOTAL REVENUES-ALL FUNDS 65,268,115.56 16,034,027.99 49,234,087.57 24.57% TOTAL EXPENDITURES-ALL FUNDS 63,644,248.75 15,334,890.72 48,309,358.03 24.09% NET OF REVENUES&EXPENDITURES 1,623,866.81 699,137.27 924,729.54 43.05% 12 03/04/2024 05:35 PM EXPENDITURE REPORT FOR CLAY COUNTY UTILITIES Page: 1/1 User: jwesselman DB: Ccua PERIOD ENDING 12/31/2023 OPERATING EXPENSE BUDGET REPORT 2023-24 YTD BALANCE AVAILABLE o BDGT GL NUMBER DESCRIPTION AMENDED BUDGET 12/31/2023 BALANCE USED Net WAGES & TEMP. LABOR 15,267,916.43 3,698,098.54 11,569,817.89 24.22 Net CAPITALIZED WAGES 156,165.96 2,472.69 153,693.27 1.58 Net HEALTH & LIFE INSURANCE 2,939,805.48 732,906.95 2,206,898.53 24.93 Net PENSION & BENEFITS 1,536,295.62 406,852.84 1,129,442.78 26.48 Net PAYROLL TAXES 1,077,965.81 262,226.30 815,739.51 24.33 Net W/C INSURANCE 201,395.25 63,333.82 138,061.43 31.45 Net PROPERTY & LIABILITY INSURANCE 1,805,580.00 527,003.76 1,278,576.24 29.19 Net TRANSPORTATION 760,940.00 174,049.45 586,890.55 22.87 Net RENTAL EXPENSE 62,767.00 9,137.56 53,629.44 14.56 Net COMMUNICATION EXPENSES 445,190.00 98,697.32 346,492.68 22.17 Net ELECTRIC & FUEL WATER PLANTS 1,057,800.00 145,887.44 911,912.56 13.79 Net ELECTRIC & FUEL LIFT STATIONS 540,000.00 82,201.61 457,798.39 15.22 Net ELECTRIC & FUEL SEWAGE PLANTS 1,781,000.00 300,024.49 1,480,975.51 16.85 Net ELECTRIC AT OFFICE 46,066.00 9,031.16 37,034.84 19.60 Net CHEMICALS FOR WATER 245,000.00 70,824.46 174,175.54 28.91 Net CHEMICALS FOR SEWAGE 998,000.00 286,342.17 711,657.83 28.69 Net SUPPLIES FOR WATER 1,462,375.00 689,246.38 773,128.62 47.13 Net SUPPLIES FOR SEWAGE 1,340,000.00 447,121.34 892,878.66 33.37 Net OFFICE SUPPLIES 2,189,221.64 390,560.64 1,798,661.00 17.84 Net ENGINEERING EXPENSES 272,200.00 36,593.08 235,606.92 13.44 Net LEGAL EXPENSES 661,000.00 40,401.54 620,598.46 6.11 Net AUDIT EXPENSES 34,500.00 20,000.00 14,500.00 57.97 Net SUBCONTRACTORS-WATER 1,500,040.00 150,077.38 1,349,962.62 10.00 Net SUBCONTRACTORS-SEWAGE 1,774,800.00 162,205.27 1,612,594.73 9.14 Net SUBCONTRACTORS-GENERAL 2,004,210.56 264,088.79 1,740,121.77 13.18 Net SLUDGE TREATMENT & DISPOSAL 2,805,750.00 589,072.24 2,216,677.76 21.00 Net BAD DEBT EXPENSE 500.00 264.58 235.42 52.92 Net MISCELLANEOUS 445,831.00 114,736.96 331,094.04 25.74 Net DUE IN LIEU OF TAXES 2,787,180.00 670,766.15 2,116,413.85 24.07 Net CONTINGENCY 809,953.00 0.00 809,953.00 0.00 TOTAL EXPENDITURES - ALL FUNDS 47,009,448.75 10,444,224.91 36,565,223.84 22.22 13 CLAY COUNTY UTILITY AUTHORITY CIAC REPORTS FISCAL YEAR 2023/2024 Section D 14 03/04/2024 05:36 PM TRIAL BALANCE REPORT FOR CLAY COUNTY UTILITIES Page: 1/2 User: jwesselman DB: Ccua PERIOD ENDING 12/31/2023 ACTIVITY FOR 2023-24 BEG. BALANCE MONTH YEAR-TO-DATE END BALANCE GL NUMBER DESCRIPTION AMENDED BUDGET 10/01/2023 12/31/2023 THRU 12/31/23 12/31/2023 Fund 101 - GENERAL FUND Fund Equity WATER CAPACITY 101.401.254.350 WATER CAPACITY CHARGES 11,856,865.36 18,900.00 71,820.00 11,928,685.36 WATER CAPACITY 11,856,865.36 18,900.00 71,820.00 11,928,685.36 SEWER CAPACITY 101.401.254.360 SEWER CAPACITY CHARGES 55,213,975.78 181,140.00 693,440.38 55,907,416.16 101.401.254.361 GRANTS 27,658,205.44 90,572.86 90,572.86 27,748,778.30 SEWER CAPACITY 82,872,181.22 271,712.86 784,013.24 83,656,194.46 AWS 101.401.240.000 AWS CIAC 8,498,767.35 78,175.62 249,864.09 8,748,631.44 AWS 8,498,767.35 78,175.62 249,864.09 8,748,631.44 SJRWMD BLACK CREEK 101.401.240.100 SJRWMD Black Creek CIAC 1,445,756.11 3,997.22 15,817.13 1,461,573.24 SJRWMD BLACK CREEK 1,445,756.11 3,997.22 15,817.13 1,461,573.24 WATER MAIN 101.401.254.354 WATER MAIN EXTENSION CHARGE 3,547,145.50 6,319.92 6,860.72 3,554,006.22 WATER MAIN 3,547,145.50 6,319.92 6,860.72 3,554,006.22 SEWER MAIN 101.401.254.364 SEWER MAIN EXTENSION CHARGE 6,030,080.52 5,428.78 6,503.25 6,036,583.77 SEWER MAIN 6,030,080.52 5,428.78 6,503.25 6,036,583.77 FIRE 101.401.254.351 FIRE CAPACITY CHARGES 2,132,781.82 0.00 15,810.00 2,148,591.82 FIRE 2,132,781.82 0.00 15,810.00 2,148,591.82 WATER TAP IN 101.401.254.352 WATER TAP IN CHARGE 2,479,403.92 13,203.00 35,024.74 2,514,428.66 WATER TAP IN 2,479,403.92 13,203.00 35,024.74 2,514,428.66 SEWER TAP IN 101.401.254.362 SEWER TAP IN CHARGE 2,605,628.70 3,822.94 16,106.51 2,621,735.21 SEWER TAP IN 2,605,628.70 3,822.94 16,106.51 2,621,735.21 WATER CONT PROP 101.401.254.353 WATER CONTRIBUTED ASSETS 61,270,367.19 400,421.19 1,506,932.97 62,777,300.16 WATER CONT PROP 61,270,367.19 400,421.19 1,506,932.97 62,777,300.16 SEWER CONT PROP 101.401.254.363 SEWER CONTRIBUTED ASSETS 122,106,574.53 1,039,401.38 2,675,379.06 124,781,953.59 SEWER CONT PROP 122,106,574.53 1,039,401.38 2,675,379.06 124,781,953.59 DEBT SERVICE 101.401.254.355 DEBT SERVICE CHARGE 1,720,422.96 955.00 91,286.50 1,811,709.46 15 03/04/2024 05:36 PM TRIAL BALANCE REPORT FOR CLAY COUNTY UTILITIES Page: 2/2 User: jwesselman DB: Ccua PERIOD ENDING 12/31/2023 ACTIVITY FOR 2023-24 BEG. BALANCE MONTH YEAR-TO-DATE END BALANCE GL NUMBER DESCRIPTION AMENDED BUDGET 10/01/2023 12/31/2023 THRU 12/31/23 12/31/2023 Fund 101 - GENERAL FUND Fund Equity DEBT SERVICE 1,720,422.96 955.00 91,286.50 1,811,709.46 TOTAL FUND EQUITY 306,565,975.18 1,842,337.91 5,475,418.21 312,041,393.39 Total Fund 101 - GENERAL FUND TOTAL ASSETS 0.00 0.00 0.00 0.00 BEG. FUND BALANCE 369,223,525.35 369,223,525.35 + NET OF REVENUES & EXPENDITURES + FUND BALANCE ADJUSTMENTS 6,570,167.13 6,570,167.13 = ENDING FUND BALANCE 306,565,975.18 1,842,337.91 5,475,418.21 312,041,393.39 + LIABILITIES 0.00 0.00 0.00 0.00 = TOTAL LIABILITIES AND FUND BALANCE 306,565,975.18 1,842,337.91 5,475,418.21 312,041,393.39 OUT OF BALANCE 0.00 (1,842,337.91) (5,475,418.21) (312,041,393.39) 16 CLAY COUNTY UTILITY AUTHORITY 2023/2024 Alternative Water Supply Surcharges Beginning October November December January February March April May June July August September Balance Established 10/1/2015 Balance 2023 2023 2023 2024 2024 2024 2024 2024 2024 2024 2024 2024 9/30/2024 Expenditures: Job 991 FCOB Stormwater Harvesting Pilot Project 883,128.55 883,128.55 Stormwater Harvesting Study 49,842.66 49,842.66 Job 00119WP Aquifer Storage&Recovery(ASR) 1,580,081.04 1,580,081.04 Project Development Advisor 212,388.00 212,388.00 Horizontal Well Feasibility Study 38,788.00 38,788.00 Aquifer Recharge Feasibility Study&Siting 138,059.36 138,059.36 Lake Agresti Reservoir Feasibility Study 5,798.00 5,798.00 Job 20022WL Treatability Pilot Project-AWS Development 3,343,971.00 520,551.78 590,728.56 249,458.91 4,704,710.25 New Development: - Total Expenditures 6,252,056.61 520,551.78 590,728.56 249,458.91 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 7,612,795.86 Existing Customers: Revenue: Surcharge Fund(Existing Customers) 4,816,047.72 59,942.60 61,597.18 61,691.58 4,999,279.08 Connection Charge Fund(Growth) 3,556,606.86 88,008.65 101,083.96 8,912.93 3,754,612.40 Interest Income 40,273.79 40,273.79 Total Revenue 8,412,928.37 147,951.25 162,681.14 70,604.51 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 8,794,165.27 Balance 2,160,871.76 (372,600.53)(428,047.42) (178,854.40) 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 1,181,369.41 Cash Balance 1,951,380.10 Done in following Month: Less Construction Costs transferred after month close (770,010.69) J/E-Adjustment True Up for Move-Ins/Move-Outs J/E-Interfund Transfer 1,181,369.41 Page D-la 17 CLAY COUNTY UTILITY AUTHORITY CAPITAL PROJECT BUDGET REPORT FISCAL YEAR 2023/2024 Section E 18 Clay County Utility Authority References Capital Projects Budget Report Prior Years Current Fiscal for Transfers Current Fiscal Financial Carry Over Current Fiscal Year Year Combined Transfers and Funds Spent @ Job Cost and Year Job Costs lob Description Job Number Budget Adopted Budget Budgets Amendments 12/31/23 Balances To Fund Amendments 2023/2024 RENEWAL,REPLACEMENT&BETTERMENT Departmental Capital 100 1,202,917.71 1,275,500.00 2,478,417.71 0.00 2,478,417.71 2,478,417.71 Upgrade Lift station 9-Meadowbrook 755 93,844.52 6,155.48 100,000.00 8,077.74 91,922.26 100,000.00 Rehab SP WW Clarifer#1/under drain 1-2 02519RR 1,549,176.20 0.00 1,549,176.20 1,433,823.38 115,352.82 1,549,176.20 Ridgecrest WTP-Replace Softstart&Crossline Starters with VFD's 20021RR 2,011,228.00 0.00 2,011,228.00 2,011,180.50 47.50 2,011,228.00 Fleming Island Reg.WWTP-2nd BCR Plant,Two Tanks 21010RR 7,200,000.00 1,680,000.00 8,880,000.00 4,640,650.16 4,239,349.84 8,880,000.00 Lift Station#2 Upgrade 21016RR 3,834,146.16 900,000.00 4,734,146.16 374,772.58 4,359,373.58 4,734,146.16 Ridaught WWTP Upgrades(Install Micro-screen,Grit Removal Equipment,r 21019RR 2,887,000.00 1,185,000.00 4,072,000.00 2,716,697.75 1,355,302.25 4,072,000.00 Meadowbrook Well Rehab 21028RR 366,895.00 366,895.00 0.00 366,895.00 366,895.00 Meadowbrook WTP Upgrades-(GST#3 repair,Transfer switch,GST#2 ro, 21029RR 2,082,308.00 2,517,692.00 4,600,000.00 533,636.92 4,066,363.08 4,600,000.00 Ridaught WTP-Phase I GST Upgrades 22007RR 54,103.26 54,103.26 54,103.26 0.00 54,103.26 Lift Station#4 Upgrades 22008RR 800,000.00 400,000.00 1,200,000.00 45,751.41 1,154,248.59 1,200,000.00 Lift Station#62 and#67-Rehabilitation 22009RR 320,000.00 900,000.00 1,220,000.00 76,869.25 1,143,130.75 1,220,000.00 Miller WRF Electrical Upgrades&WWTP Upgrades 23004RR 155,005.00 81,000.00 236,005.00 126,146.49 109,858.51 236,005.00 Spencers WTP-Ground Storage&High Service Pump&Electrical Upgrade 23005RR 237,848.00 3,000,000.00 3,237,848.00 281,685.31 2,956,162.69 3,237,848.00 Pace Island&Fleming Oaks WTP Electrical Upgrades 23007RR 192,107.00 250,000.00 442,107.00 119,113.39 322,993.61 442,107.00 SCADA System 23008RR 250,000.00 250,000.00 500,000.00 48,500.00 451,500.00 500,000.00 Fleming island WRF electrical upgrades Nault upgrades 23009RR 296,171.00 1,786,190.00 2,082,361.00 113,487.30 1,968,873.70 2,082,361.00 ERP Software Replacement 23010RR 2,843,782.00 1,622,922.00 4,466,704.00 3,970,557.17 496,146.83 4,466,704.00 Upgrade Lift Stations 11,41,69,51 23012RR 158,092.80 500,000.00 658,092.80 151,618.33 506,474.47 658,092.80 Sandridge Road widening from Henley to CR 209 and ForceMain Extension 23015SL 2,040,000.00 2,040,000.00 1,514,301.81 525,698.19 2,040,000.00 Gravity Sewer Lining 23016RR 406,692.68 1,000,000.00 1,406,692.68 0.00 1,406,692.68 1,406,692.68 Keystone Heights-Lakeside Street/Hilltop Street Water Main Rehabilitation 23024RR 237,600.00 237,600.00 21,600.00 216,000.00 237,600.00 Mid-Clay Entrance Road Stabilization 23025RR 50,000.00 50,000.00 17,315.43 32,684.57 50,000.00 Mid-Clay WRF Alternate Driveway 23028RR 1,200,000.00 1,200,000.00 4,209.96 1,195,790.04 1,200,000.00 Ravines Off-Site Mains-Middleburg W&S Extensions Not Started 1,238,000.00 1,238,000.00 0.00 1,238,000.00 1,238,000.00 Lift Station Bypass Pump Not Started 200,000.00 200,000.00 0.00 200,000.00 200,000.00 Manhole Rehab Not Started 150,000.00 150,000.00 300,000.00 0.00 300,000.00 300,000.00 Keystone Heights High School WM relocation Not Started 143,000.00 143,000.00 0.00 143,000.00 143,000.00 Water Plant Meters Retrofits Not Started 108,000.00 300,000.00 408,000.00 0.00 408,000.00 408,000.00 FH and Gate Valve replacement Not Started 105,000.00 210,000.00 315,000.00 0.00 315,000.00 315,000.00 Potable and Reclaimed Water Meter and backflow device replacement 23003RR 0.00 1,600,000.00 1,600,000.00 438,436.93 1,161,563.07 1,600,000.00 Lake Asbury WM Improvements(602 Lake Asbury Road&Aldersgate St.) 23030RR 1,530,000.00 1,530,000.00 24,190.45 1,505,809.55 1,530,000.00 Southern Baptist Hospital of Florida/cost participation w/development 24001RR 0.00 195,435.28 195,435.28 0.00 1 195,435.28 Keystone Wastewater Treatment Plant-Phase II Construction Not Started 0.00 500,000.00 500,000.00 0.00 500,000.00 500,000.00 Upgrade Lift Station 20&56 Not Started 0.00 500,000.00 500,000.00 0.00 500,000.00 500,000.00 Plant Generators Not Started 0.00 500,000.00 500,000.00 0.00 500,000.00 500,000.00 Miller St.WWTP Upgrades Influent Structure,Septage station&Electrical i Not Started 0.00 375,000.00 375,000.00 0.00 375,000.00 375,000.00 New Lift Station Generators Not Started 0.00 350,000.00 350,000.00 0.00 350,000.00 350,000.00 12"Main Connecting Postmaters WTP to Geneva Lakes WTP along CR214 Not Started 0.00 0.00 0.00 0.00 0.00 12"WM Extension Hwy.100 to Brooklyn Bay Rd.(Keystone) Not Started 0.00 0.00 0.00 0.00 0.00 6"WM Extension Woodland Dr.to Payne Rd.via SR21 Not Started 0.00 0.00 0.00 0.00 0.00 Old Jennings WTP Electrical Upgrade Not Started 0.00 0.00 0.00 0.00 0.00 Tanglewood Electrical Upgrade Not Started 0.00 0.00 0.00 0.00 0.00 Orange Park South Electrical Upgrade Not Started 0.00 0.00 0.00 0.00 0.00 Ridaught WRF Electrical Upgrades Not Started 0.00 0.00 0.00 0.00 0.00 Spencer's WRF Electrical Upgrades Not Started 0.00 0.00 0.00 0.00 0.00 Oakleaf WTP Electrical Upgrades Not Started 0.00 0.00 0.00 0.00 0.00 Server Lifecycle Replacement Not Started 0.00 0.00 0.00 0.00 0.00 Upgrade Lift Station 98 Not Started 0.00 0.00 0.00 0.00 0.00 Upgrade Lift Stations 43,24,59 Not Started 0.00 0.00 0.00 0.00 0.00 Upgrade Lift Station 111 Not Started 0.00 0.00 0.00 0.00 0.00 19 X:\Finance\Controllers Folder\Monthly Financial\Monthly Construction Reports\2023-2024\CIP_2024_December.xlsx Page 1 of 3 Clay County Utility Authority References Capital Projects Budget Report Prior Years Current Fiscal for Transfers Current Fiscal Financial Carry Over Current Fiscal Year Year Combined Transfers and Funds Spent @ Job Cost and Year Job Costs lob Description Job Number Budget Adopted Budget Budgets Amendments 12/31/23 Balances To Fund Amendments 2023/2024 SYSTEM EXPANSION Er Meadow Lake WTP-New Ground Storage Tank and Electrical Service upgra 00983WP 3,149,124.00 3,149,124.00 3,000,963.49 148,160.51 3,149,124.00 Henley Road 12"WM Loop-Sandridge to Small Lake 01119WL 11,258.64 94,758.06 106,016.70 11,258.64 94,758.06 106,016.70 North Middleburg Water&Sewer Extension and Interconnection(Water Int( 02419WL 560,554.67 2,750,000.00 3,310,554.67 394,377.66 2,916,177.01 3,310,554.67 Saratoga SpringsWTP-PhaseI 03018WP 16,591,000.00 16,591,000.00 16,773,116.48 (182,116.48) 16,591,000.00 CCUA Administrative Building Phase I 21013AD 5,125,089.00 100,000.00 5,225,089.00 1,811,410.25 3,413,678.75 5,225,089.00 Phase III Admin Building Not Started 0.00 0.00 0.00 0.00 0.00 Swimming Penn Creek WM Interconnect 21020WL 2,250,000.00 1,810,000.00 4,060,000.00 452,603.92 3,607,396.08 4,060,000.00 Ravines to Henly Road Water Main Extension 21023WL 2,250,000.00 2,400,000.00 4,650,000.00 424,419.27 4,225,580.73 4,650,000.00 Governor's Park WTP Design and Build 21026WP 5,125,000.00 4,250,000.00 9,375,000.00 2,338,649.32 7,036,350.68 9,375,000.00 Peters Creek WTP 2nd GST&3rd Well 21030WP 267,547.26 267,547.26 267,547.26 (0.00) 267,547.26 Peters Creek New Regional WRF 22003SP 46,523,968.83 41,600,000.00 88,123,968.83 39,011,899.45 49,112,069.38 88,123,968.83 CCUA North Campus Driveway 22010AD 786,341.00 786,341.00 101,485.12 684,855.88 786,341.00 LAMPA E/W Interconnect#1 Water(Cathedral Oaks West-Green) 22012WL 1,000,000.00 2,112,000.00 3,112,000.00 1,897,136.98 1,214,863.02 3,112,000.00 LAMPA E/W Interconnect#1 Wwtr-Reuse(Cathedral Oaks West-Green; 22013SL 2,000,000.00 4,337,000.00 6,337,000.00 3,892,011.98 2,444,988.02 6,337,000.00 LAMPA E/W Interconnect#2 Water (Cathedral Oaks East-Blue) 22014WL 28,105.29 28,105.29 28,105.29 (0.00) 28,105.29 LAMPA E/W Interconnect#2 Wwtr-Reuse(Cathedral Oaks East-Blue) 22015SL 57,964.36 57,964.36 57,964.36 0.00 57,964.36 LAMPA N/S Interconnect#1 Water(SS WTP to Cathedral Oaks West-Res 22016WL 17,319.95 17,319.95 17,319.95 0.00 17,319.95 LAMPA N/S Interconnect#1 Wwtr-Reuse(SS WTP to Cathedral Oaks W 22017SL 35,189.76 35,189.76 39,145.26 (3,955.50) 35,189.76 LAMPA N/S Interconnect#2 Water(Feed Mill Rd.-Black) 22018WL 10,298.93 10,298.93 10,298.93 (0.00) 10,298.93 LAMPA N/S Interconnect#2 Wwtr-Reuse (Feed Mill Rd.-Black) 22019SL 20,915.03 20,915.03 20,915.03 0.00 20,915.03 CR 315 Peters Creek Spur(Orange) Not Started 0.00 0.00 0.00 0.00 0.00 Emalyn Place 3 Single Family Units 22021WL 17,000.00 17,000.00 0.00 17,000.00 17,000.00 Postmaster WTP Electrical Upgrades 23001WP 181,657.00 181,657.00 63,579.95 118,077.05 181,657.00 Clay County-College Drive RRR Project 23014WL 35,000.00 35,000.00 0.00 35,000.00 35,000.00 Upsize Mains-Double Branch Cost Share 23018WL 316,169.64 316,169.64 316,169.64 0.00 316,169.64 Knight Boxx/Old Jennings Force Main Extension and Lift Station 56 23019SL 134,978.00 1,465,022.00 1,600,000.00 21,941.94 1,578,058.06 1,600,000.00 Water Service to 3255 Bliss Rd. 23020WL 91,790.21 91,790.21 103,815.71 (12,025.50) 91,790.21 Upsizing Mains fro Bradley Creek to Russell Retreat 23021WL 394,236.58 394,236.58 353,900.00 40,336.58 394,236.58 Water Service to 461 Creighton Rd. 23022WL 71,520.73 71,520.73 71,955.32 (434.59) 71,520.73 Home Depot-Lowes Interconnect 23026WL 23,664.53 23,664.53 22,465.48 1,199.05 23,664.53 Water Service to 879 Creighton Rd. 23027WL 25,000.00 25,000.00 15,294.86 9,705.14 25,000.00 Engineering Cost Allocation 9999999 0.00 0.00 94,980.75 (94,980.75) 0.00 16-inch WM Atlantis to Kindlewood Not Started 500,000.00 500,000.00 0.00 500,000.00 500,000.00 Upsizing pipes to accommodate Rookery GCS Not Started 0.00 466,000.00 466,000.00 0.00 466,000.00 466,000.00 Tanglewood Neighborhood Water Main Relocations Not Started 85,000.00 85,000.00 0.00 85,000.00 85,000.00 CR 218 widening from Pine Tree Lane to Cosmos 22020RR 675,000.00 675,000.00 424,394.80 250,605.20 675,000.00 CR 220 widening Baxley to Henley Rd Not Started 250,000.00 510,000.00 760,000.00 0.00 760,000.00 760,000.00 CR 220 widening from Henley to Knightbox Not Started 50,000.00 20,000.00 70,000.00 0.00 70,000.00 70,000.00 CR 315 widening-Utility Relocation(design FY 23 construct FY 24) 23017RR 922,000.00 922,000.00 0.00 922,000.00 922,000.00 CR220 Quadrant Intersection Not Started 578,000.00 578,000.00 0.00 578,000.00 578,000.00 Infill Projects Not Started 1,361,678.98 100,000.00 1,461,678.98 0.00 1,461,678.98 1,461,678.98 Well Rehab Not Started 0.00 150,000.00 150,000.00 0.00 150,000.00 150,000.00 Lead&Copper GSP replacement Not Started 0.00 60,000.00 60,000.00 0.00 60,000.00 60,000.00 Water Quality Lab Not Started 0.00 0.00 0.00 0.00 0.00 Chemical tanks Not Started 0.00 100,000.00 100,000.00 0.00 100,000.00 100,000.00 Facility Roof Repairs Not Started 0.00 100,000.00 100,000.00 0.00 100,000.00 100,000.00 -Reclaimed Transmission Main-Spencers to Oakleaf Not Started 0.00 0.00 0.00 0.00 0.00 -Reclaimed Transmission Main-Oakleaf to Challenger Not Started 0.00 0.00 0.00 0.00 0.00 -Reclaimed Transmission Main-Old Jennings Rd Bypass Not Started 0.00 0.00 0.00 0.00 0.00 -New Pumps-Old Jennings WRF pump station Not Started 0.00 0.00 0.00 0.00 200.00 X:\Finance\Controllers Folder\Monthly Financial\Monthly Construction Reports\2023-2024\CIP_2024_December.xlsx Page 2 of 3 Clay County Utility Authority References Capital Projects Budget Report Prior Years Current Fiscal for Transfers Current Fiscal Financial Carry Over Current Fiscal Year Year Combined Transfers and Funds Spent @ Job Cost and Year Job Costs Job Description Job Number Budget Adopted Budget Budgets Amendments 12/31/23 Balances To Fund Amendments 2023/2024 -Reclaimed Water SCADA Not Started 0.00 530,000.00 530,000.00 0.00 530,000.00 530,000.00 Mid-Clay Rib Recovery pH adjustment evaluation Not Started 0.00 30,000.00 30,000.00 0.00 30,000.00 30,000.00 Evaluate replacement of 16"AC Pipe by Orange Park mall Not Started 0.00 30,000.00 30,000.00 0.00 30,000.00 30,000.00 -Geneva Lake Estates(Watermain-B)7,605 LF 12-inch WM Not Started 0.00 0.00 0.00 0.00 0.00 -Looping Fire Hydrants(Area D)170 LF 12-inch WM Not Started 0.00 0.00 0.00 0.00 0.00 -Looping Fire Hydrants(Area G)35LF of 6-inch WM Not Started 0.00 0.00 0.00 0.00 0.00 -Booster Pump Station Not Started 0.00 0.00 0.00 0.00 0.00 Treatment plant R&R Studies Not Started 0.00 500,000.00 500,000.00 0.00 500,000.00 500,000.00 Fleming BTU#1 Rehab design and construction Not Started 0.00 500,000.00 500,000.00 0.00 500,000.00 500,000.00 Cost Participation w/Development Projects Not Started 0.00 1,659,369.32 1,659,369.32 (195,435.28) 0.00 1,463,934.04 1 1,463,934.04 Lift Station 88 Relocation Not Started 0.00 1,200,000.00 1,200,000.00 0.00 1,200,000.00 1,200,000.00 Commercial Meter Change outs Not Started 0.00 75,000.00 75,000.00 0.00 75,000.00 75,000.00 12-inch Wm Keystone RV to Geneva lakes WTP Not Started 0.00 2,300,000.00 2,300,000.00 0.00 2,300,000.00 2,300,000.00 Pier Station E/W WM Extension and Interconnect(State Road 16 and FCOB Not Started 0.00 50,000.00 50,000.00 0.00 50,000.00 50,000.00 Pier Station Force Main Extensions(State Road 16 and FCOB) Not Started 0.00 0.00 0.00 0.00 0.00 Pier Station Master Pump Station(State Road 16 and FCOB) Not Started 0.00 0.00 0.00 0.00 0.00 Pier Station WTP Expansion Not Started 0.00 0.00 0.00 0.00 0.00 Ravines WTP 2nd GST Not Started 0.00 0.00 0.00 0.00 0.00 Spencer's WWTP:Phase 6 Expansion Not Started 0.00 0.00 0.00 0.00 0.00 ALTERNATIVE WATER SUPPLY Purified Water Pilot Study 20022WL 4,769,000.00 2,000,000.00 6,769,000.00 4,829,145.02 1,939,854.98 6,769,000.00 AMI Demand Management Not Started 0.00 0.00 0.00 0.00 Onsite Stormwater Harvesting Not Started 0.00 0.00 0.00 0.00 Public Access Reuse Storage Not Started 1,822,500.00 1,822,500.00 0.00 1,822,500.00 1,822,500.00 Subtotals 128,704,289.72 96,491,108.86 225,195,398.58 0.00 95,790,432.91 129,404,965.67 225,195,398.58 Contingency 15,314,551.76 15,314,551.76 0.00 15,314,551.76 TOTAL CAPITAL EXPENDITURES 240,509,950.34 0.00 240,509,950.34 Construction In Progress 225,195,398.58 95,744,519.43 Not Started 17,661,113.02 Completed Jobs 45,913.48 2,000.00 Started 222,848,837.32 95,790,432.91 240,509,950.34 21 X:\Finance\Controllers Folder\Monthly Financial\Monthly Construction Reports\2023-2024\CIP_2024_December.xlsx Page 3 of 3 CLAY COUNTY UTILITY AUTHORITY OPERATING DETAIL BY MONTH FISCAL YEAR 2023/2024 Section F 22 03/04/2024 05:47 PM REVENUE REPORT FOR CLAY COUNTY UTILITIES Page: 1/1 User: jwesselman DB: Ccua PERIOD ENDING 12/31/2023 OPERATING REVENUE BUDGET REPORT ACTIVITY FOR 2023-24 MONTH YTD BALANCE o BDGT GL NUMBER DESCRIPTION AMENDED BUDGET 12/31/2023 12/31/2023 USED OPERATING REVENUES Water Revenues Water Base Charges 101.401.343.301 RESIDENTIAL WATER BASE CHARGE 7,416,070.00 659,482.75 1,831,829.61 24.70 101.401.343.303 GENERAL SERVICE WATER BASE 1,434,056.00 123,474.60 345,300.60 24.08 101.401.346.303 Commercial Potable Irrigation Base 299,078.00 21,097.55 58,710.76 19.63 Net Water Base Charges 9,149,204.00 804,054.90 2,235,840.97 23.75 Water Use Charges 101.401.344.303 Residential Water Usage Tier 1 3,803,923.00 318,871.39 980,291.20 25.77 101.401.344.304 Residential Water Usage Tier 2 2,647,457.00 172,322.98 621,955.49 23.49 101.401.344.305 Residential Water Usage Tier 3 1,110,181.00 54,240.14 239,643.76 21.59 101.401.344.306 Residential Water Usage Tier 4 1,267,451.00 46,762.24 232,701.24 18.36 101.401.345.305 Commercial Water Usage 2,633,109.00 189,125.06 621,869.50 23.62 101.401.346.306 Commercial Potable Irrigation Usage 130,452.00 9,522.24 31,431.68 24.09 101.401.346.307 Commercial Potable Irrigation Usage 234,846.00 17,848.50 61,450.86 26.17 101.401.346.308 Commercial Potable Irrigation Usage 180,017.00 10,655.23 39,894.58 22.16 101.401.346.309 Commercial Potable Irrigation Usage 132,818.00 5,983.46 28,584.31 21.52 Net Water Use Charges 12,140,254.00 825,331.24 2,857,822.62 23.75 Reuse Water Base Charges 101.401.343.601 Reuse Residential Base 3,421,315.00 308,347.57 854,084.72 24.96 101.401.343.602 Reuse Commercial Base 337,285.00 29,106.23 80,456.05 23.85 Net Reuse Water Base Charges 3,758,600.00 337,453.80 934,540.77 23.75 Reuse Water Usage Charges 101.401.347.403 Reuse Residential Usage Tier 1 1,112,329.00 61,219.91 244,011.79 21.94 101.401.347.404 Reuse Residential Usage Tier 2 292,253.00 13,174.72 57,505.23 19.68 101.401.347.405 Reuse Residential Usage Tier 3 812,616.00 33,320.94 150,978.36 18.58 101.401.347.406 Reuse Commercial Usage Tier 1 125,214.00 5,685.28 23,441.92 18.72 101.401.347.407 Reuse Commercial Usage Tier 2 43,385.00 (2,873.78) 3,950.27 9.11 101.401.347.408 Reuse Commercial Usage Tier 3 303,936.00 4,353.72 62,387.71 20.53 101.401.349.506 CROSSINGS RECLAIMED WATER CHRG 137,302.00 5,835.96 48,973.60 35.67 Net Reuse Water Usage Charges 2,827,035.00 120,716.75 591,248.88 23.75 Net Water Revenues 27,875,093.00 2,087,556.69 6,619,453.24 23.75 Sewage Revenues Sewer Base Charges 101.401.343.501 RESIDENTIAL SEWER BASE CHARGE 16,011,289.00 1,414,741.63 3,928,922.99 24.54 101.401.343.504 GENERAL SERVICE SEWER BASE 2,598,137.00 258,442.25 717,066.70 27.60 Net Sewer Base Charges 18,609,426.00 1,673,183.88 4,645,989.69 24.33 Sewer Use Charges 101.401.343.502 RESIDENTIAL SEWER USAGE CHARGE 11,541,975.00 855,706.52 2,682,897.99 23.24 101.401.343.505 GENERAL SERVICE SEWER USAGE 3,718,832.00 299,814.17 923,627.46 24.84 101.401.343.506 PORTALET SEWAGE REVENUE 192,000.00 21,628.94 33,913.79 17.66 Net Sewer Use Charges 15,452,807.00 1,177,149.63 3,640,439.24 24.33 Net Sewage Revenues 34,062,233.00 2,850,333.51 8,286,428.93 24.33 Net OPERATING REVENUES 61,937,326.00 4,937,890.20 14,905,882.17 24.33 TOTAL REVENUES - ALL FUNDS 61,937,326.00 4,937,890.20 14,905,882.17 24.07 23 Budgeted vs. Actual - Base & Use Charges, Total 35,000,000 30,000,000 25,000,000 20,000,000 15.11111 15,000,000 10,000,000 I 5,000,000 0 l October November December January February March April May June July August September Actual Base Charges Actual Use Charges Budgeted Base Charges ♦Budgeted Use Charges 24 Operating Revenue $7,000,000 I. $6,000,000 $5,000,000 .111 $4,000,000 h1 $3,000,000 $2,000,000 — $1,000,000 $0 October November December January February March April May June July August September Actual Optg Rev Prior Year Optg Rev Budgeted Optg Rev 25 Operating Net Income $3,000,000 -- $2,500,000 — $2,000,000 — $1,500,000 T . ,& N c, liTip . $1,000,000 _I, $500,000 rW— I $0 October November December January February March April May June July August September Actual Net Income Prior Year Net Income Budgeted Net Income 26 CLAY COUNTY UTILITY AUTHORITY OTHER REPORTS FISCAL YEAR 2023/2024 Section G 27 03/04/2024 05:51 PM REVENUE AND EXPENDITURE REPORT FOR CLAY COUNTY UTILITIES Page: 1/2 User: jwesselman DB: Ccua PERIOD ENDING 12/31/2023 CONSTRUCTION DEPARTMENT BUDGET ACTIVITY FOR 2023-24 MONTH YTD BALANCE ENCUMBERED UNENCUMBERED o BDGT GL NUMBER DESCRIPTION AMENDED BUDGET 12/31/23 12/31/2023 YEAR-TO-DATE BALANCE USED INTERNAL BILLINGS 101.401.349.609 BILLINGS TO CCUA-CAPITAL ASSET 526,841.00 0.00 6,906.67 0.00 519,934.33 1.31 Net INTERNAL BILLINGS 526,841.00 0.00 6,906.67 0.00 519,934.33 1.31 WAGES 101.401.536.128 C/D JOB PAYROLL 0.00 0.00 3,716.64 0.00 (3,716.64) 100.00 101.401.536.129 C/D CONTRA JOB PAYROLL 0.00 0.00 (3,716.64) 0.00 3,716.64 100.00 101.502.536.121 WAGES HOURLY 156,165.96 0.00 2,472.69 0.00 153,693.27 1.58 Net WAGES (156,165.96) 0.00 (2,472.69) 0.00 (153,693.27) 1.58 HEALTH/LIFE INSURANCE 101.502.536.230 EMPLOYEE HEALTH&LIFE INSURANCE 39,012.12 0.00 707.62 0.00 38,304.50 1.81 Net HEALTH/LIFE INSURANCE (39,012.12) 0.00 (707.62) 0.00 (38,304.50) 1.81 RETIREMENT & BENEFITS 101.502.536.220 EMPLOYEE RETIREMENT & BENEFITS 19,956.15 0.00 271.26 99.95 19,584.94 1.86 Net RETIREMENT & BENEFITS (19,956.15) 0.00 (271.26) (99.95) (19,584.94) 1.86 PAYROLL TAXES 101.502.536.210 EMPLOYER FICA PAYROLL TAXES 14,204.51 0.00 176.54 0.00 14,027.97 1.24 Net PAYROLL TAXES (14,204.51) 0.00 (176.54) 0.00 (14,027.97) 1.24 WORKMENS COMPENSATION INS. 101.502.536.240 W/C INSURANCE 4,726.72 0.00 88.53 0.00 4,638.19 1.87 Net WORKMENS COMPENSATION INS. (4,726.72) 0.00 (88.53) 0.00 (4,638.19) 1.87 PROPERTY/LIABILITY INSURANCE 101.502.536.451 PROPERTY INSURANCE-CONSTRUCTION 90,387.00 9,186.55 31,620.22 0.00 58,766.78 34.98 Net PROPERTY/LIABILITY INSURANCE (90,387.00) (9,186.55) (31,620.22) 0.00 (58,766.78) 34.98 OFFICE SUPPLIES 101.502.536.529 SUPPLIES OFFICE 250.00 0.00 0.00 0.00 250.00 0.00 Net OFFICE SUPPLIES (250.00) 0.00 0.00 0.00 (250.00) 0.00 TOOLS & SUPPLIES 101.502.536.407 JOB EQUIPMENT CHARGES 0.00 0.00 1,042.00 0.00 (1,042.00) 100.00 101.502.536.527 TOOLS & SUPPLIES 12,700.00 844.48 6,435.88 (23.39) 6,287.51 50.49 Net TOOLS & SUPPLIES (12,700.00) (844.48) (7,477.88) 23.39 (5,245.51) 58.70 FUEL, OIL, & REPAIRS 101.502.536.468 EQUIP REPAIR&MAINTENANCE 20,000.00 0.00 850.69 0.00 19,149.31 4.25 Net FUEL, OIL, & REPAIRS (20,000.00) 0.00 (850.69) 0.00 (19,149.31) 4.25 TRANSPORTATION 101.502.536.401 TRANSPORTATION EXPENSES 28,000.00 1,712.13 5,147.66 0.00 22,852.34 18.38 Net TRANSPORTATION (28,000.00) (1,712.13) (5,147.66) 0.00 (22,852.34) 18.38 MISCELLANEOUS 101.502.536.221 EMPLOYEE TRAINING & TRAVEL 384.00 0.00 225.00 0.00 159.0028 58.59 03/04/2024 05:51 PM REVENUE AND EXPENDITURE REPORT FOR CLAY COUNTY UTILITIES Page: 2/2 User: jwesselman DB: Ccua PERIOD ENDING 12/31/2023 CONSTRUCTION DEPARTMENT BUDGET ACTIVITY FOR 2023-24 MONTH YTD BALANCE ENCUMBERED UNENCUMBERED o BDGT GL NUMBER DESCRIPTION AMENDED BUDGET 12/31/23 12/31/2023 YEAR-TO-DATE BALANCE USED Net MISCELLANEOUS (384.00) 0.00 (225.00) 0.00 (159.00) 58.59 DEPRECIATION 101.401.536.595 CONSTRUCTION R&R (DEPRECIATION 104,385.00 2,304.96 6,914.87 0.00 97,470.13 6.62 Net DEPRECIATION (104,385.00) (2,304.96) (6,914.87) 0.00 (97,470.13) 6.62 MATERIALS & SUBCONTRACTORS 101.502.536.435 TRASH SERVICE 2,100.00 0.00 0.00 0.00 2,100.00 0.00 Net MATERIALS & SUBCONTRACTORS (2,100.00) 0.00 0.00 0.00 (2,100.00) 0.00 CONTINGENCY 101.401.536.990 CONTINGENCY 34,570.00 0.00 0.00 0.00 34,570.00 0.00 Net CONTINGENCY (34,570.00) 0.00 0.00 0.00 (34,570.00) 0.00 TOTAL REVENUES - ALL FUNDS 526,841.00 0.00 6,906.67 0.00 519,934.33 1.31 TOTAL EXPENDITURES - ALL FUNDS 526,841.46 14,048.12 55,952.96 76.56 470,811.94 10.63 NET OF REVENUES & EXPENDITURES (0.46) (14,048.12) (49,046.29) (76.56) 49,122.39 10,678,8 29 Deferred Connection Charges Report Board Summary As of December 31,2023 Subdivision Execution Date Deferred Charges Lots In Service Remaining Paid Pending Collection% In Process: Linda Lakes Subdivision 02/19/2016 $303,170 122 119 3 $295,715 $7,455 97.54% Jennings Farms 11/08/2022 $1,713,429 314 0 314 1 $1,713,429 0.00% Jennings Court Townhomes-28 Units 11/08/2022 $152,790 28 0 28 $152,790 0.00% Branan Field Village Townhomes 05/22/2023 $464,304 92 0 92 ' $464,304 0.00% Branan Field Village Townhomes 46 Units 07/21/2023 $232,152 46 0 46 $232,152 0.00% Challenger Townhomes 11/03/2023 $1,230,541 244 0 244 $1,230,541 0.00% Baxley Villas 01/05/2024 $392,630 72 0 72 $392,630 0.00% Goose Creek Estates 10/27/2020 $232,292 52 46 6 $200,864 $31,428 86.47% Jeremy's Hollow Subdivision-14 Lots 11/08/2022 $74,855 14 0 14 $74,855 0.00% The Rookery Subdivision 10/03/2023 $1,235,106 231 0 231 $1,235,106 0.00% Fleming Estates 05/11/2018 $174,682 40 38 2 $163,986 $10,696 93.88% Creighton Road Parcel • 10/25/2023 $60,025 11 0 11 $60,025 0.00% Cross Creek Subdivision Phase I,Unit 1A 04/17/2018 $1,113,161 263 253 10 $1,060,781 $52,380 95.29% Village Park _ 03/12/2019 $665,705 156 153 3 • $649,991 $15,714 97.64% Royal Pointe 04/10/2019 $273,356 58 51 7 $236,690 $36,666 86.59% Avonlea Hills Subdivision-Phase 1(238 Lots) 02/25/2021 $1,014,315 238 231 7 $977,649 $36,666 96.39% Cross Creek Subdivision Phase 2B-2 04/20/2021 $343,868 81 81 0 $343,868 100.00% Anabelle Island Subdivision-Phases 1A,1B&21 09/07/2021 $1,801,875 344 0 344 $1,801,875 0.00% Granary Park Subdivision Phase 11-279 Lots 03/14/2022 $1,458,806 279 73 206 $359,124 $1,099,682 24.62% Robinson Ranch Subdivision Phase 1-198 Lots 03/29/2022 $1,024,382 198 67 131 $325,070 $699,312 31.73% Creekview Trails Area 4 05/27/2022 $1,297,197 243 0 243 $1,297,197 0.00% Anabelle Island Subdivision-Phases 1A,1B&2 02/17/2023 $133,670 25 0 25 $133,670 0.00% Cross Creek 2D-2 101 Lots 02/28/2023 $539,975 101 14 87 $74,805 $465,170 13.85% Sandridge Hills Subdivision 02/28/2023 $1,015,888 190 0 190 $1,015,888 0.00% Cross Creek Subdivision-Phase 2E-2 05/09/2023 $278,033 52 0 52 $278,033 0.00% Cross Creek Subdivision-Phase 2E-1 05/09/2023 $187,137 35 0 35 $187,137 0.00% Bella Lago Subdivision,Phase 1 Consisting of 71 Lots,Lots 19-4 05/11/2023 $379,621 71 0 71 $379,621 0.00% Bella Lago Subdivision,Phase 1 Consisting of 167 Lots 05/25/2023 $892,912 167 0 167 $892,912 0.00% Creekview Trails Areas 1&2 06/02/2023 $1,630,768 305 0 305 $1,630,768 0.00% Russell Retreat Subdivision-51 Lots 06/26/2023 $272,686 51 0 51 $272,686 0.00% Granary Park Subdivision Phase III 08/03/2023 $1,358,082 254 0 254 $1,358,082 0.00% Holstein Crossing Subdivision 08/08/2023 $1,031,929 193 0 193 $1,031,929 0.00% Quiet Creek Condominium Bldg 5 09/27/2023 $38,197 7 0 7 $38,197 0.00% Eagle Landing at Oakleaf Plantation,Phase 5B 02/05/2019 $518,563 99 0 99 $518,563 0.00% Greyhawk Subdivision Units 2&3 11/19/2019 $1,283,462 300 283 17 $1,194,416 $89,046 93.06% Cameron Oaks Subdivision,Phase 3 -91 Lots 08/03/2020 $384,649 91 •90 1 $379,411 $5,238 98.64% Sugar Leaf Farms Subdivision-118 Lots 05/27/2021 $571,024 118 62 56 $277,696 $293,329 48.63% Wilford Preserve Subdivision,Phase 3A&3B-138 Lo 07/21/2021 $722,845 138 0 138 $722,845 0.00% Double Branch Subdivision 01/31/2022 $782,082 153 52 101 $242,918 $539,164 31.06% Cheswick South Subdivision-232 Lots 05/04/2022 $1,209,691 232 30 202 $131,362 $1,078,329 10.86% Wilford Preserve Phase 4 01/10/2023 $791,323 148 0 148 $791,323 0.00% In Process Totals $29,281,178 5,856 1,643 4,213 $6,914,345 $22,366,833 23.61% I 30 Deferred Connection Charges Report Board Summary As of December 31,2023 Subdivision Execution Date Deferred Charges Lots In Service Remaining Paid Pending Collection% Completed: Magnolia West Subdivision,Phase 2,3&4 08/16/2018 $488,305 126 126 0 $488,305 100.00% Osprey Landing Court Lots 1,2&3 01/25/2019 $12,914 3 3 0 $12,914 100.00% Somerset Subdivision 12/21/2018 $435,695 101 101 0 $435,695 100.00% Eagle Landing at Oakleaf Plantation,Phase 6 12/18/2018 $324,269 77 77 0 $324,269 100.00% Eagle Landing at Oakleaf Plantation,Phase 6,Part 2 10/11/2019 $358,919 85 85 0 $358,919 100.00% Cameron Oaks,Phase I 01/25/2019 $394,989 91 91 0 $394,989 100.00% Pine Ridge Plantation West 01/25/2019 $189,346 41 41 0 $189,346 100.00% Cross Creek Subdivision-Phase I,Unit 1B 01/23/2020 $147,142 35 35 0 $147,142 100.00% Cross Creek Subdivision-Phase 1,Unit 1C 01/23/2020 $493,166 117 117 0 $493,166 100.00% Willow Springs 11/19/2019 $633,586 150 150 0 $633,586 100.00% Pinewood Place Subdivision 12/08/2020 $355,607 82 82 0 $355,607 100.00% Cross Creek 2B-1 04/19/2021 $536,669 127 127 0 $536,669 100.00% Laurel Grove Estates 06/24/2020 $242,588 56 56 0 $242,588 100.00% Cross Creek Subdivision-Phase 2-100 Lots 11/16/2020 $422,574 100 100 0 $422,574 100.00% Cross Creek Subdivision Phase 2F-113 Lots 10/27/2021 $492,626 113 113 0 $492,626 100.00% Willow Springs Subdivision 2A,2B&3 01/21/2021 $968,572 229 229 0 $968,572 100.00% Wilford Preserve Phase 2 11/25/2019 $735,590 174 174 0 $735,590 100.00% Cross Creek Subdivision Phase 2C-226 Lots 10/05/2021 $957,496 226 226 0 $957,496 100.00% Cross Creek Subdivision Phase 2D-1 50 Lots 02/05/2019 $217,274 50 50 0 $217,274 100.00% Wilford Preserve 06/19/2018 $557,902 133 133 0 $557,902 100.00% Traceland 12/15/2017 $423,407 101 101 0 A $423,407 100.00% Discovery Trails at Oakleaf-76 Townhomes 12/14/2021 $284,780 76 76 0 $306,809 107.74% Completed Totals $9,673,416 2,293 2,293 0 $9,695,445 100.23% Grand Totals $38,954,594 8,149 3,936 4,213 $16,609,789 $22,366,833 42.64% Summary by FY Deferred Charges Lots In Service Remaining Paid Pending Collection% FY 2016 $303,170 122 119 3 $295,715 $7,455 97.54% FY 2017 0 0 0 ' FY 2018 $2,757,456 663 651 12 $2,694,380 $63,076 97.71% FY 2019 $2,814,838 626 517 109 $2,243,895 $570,943 79.72% FY 2020 $4,279,102 1,008 990 18 $4,184,818 $94,284 97.80% FY 2021 $6,969,642 1,509 958 551 $4,083,498 $2,886,144 58.59% FY 2022 $7,507,060 1,520 637 883 $2,815,405 $4,713,684 37.50% FY 2023 $11,405,024 2,143 64 2,079 $292,079 $11,112,946 2.56% FY 2024 $2,918,302 558 0 558 $2,918,302 0.00% Grand Totals $38,954,594 8,149 3,936 4,213 $16,609,789 $22,366,833 42.64% 31 Clay County Utility Authority-Connection Fees $14,000,000 $12,000,000 $10,000,000 $8,000,000 $7,610,757 $6,950,649 $6,648,170 $6,000,000 $3,171,113 $732,906 $4,000,000 $2,000,000 $3,839,463 $4,283,540 $4,212,683 $4,063,500 $2,705,336 $- 2020 2021 2022 2023 2024(Annualized) •Deferred Connections Fees •Non-Deferred Connections Fees 32 CLAY COUNTY UTILITY AUTHORITY KEY PERFORMANCE INDICATORS - PERIOD ENDING 12/31/2023 Ratio Calculation vs.Target Target Days of Cash on Hand Undesignated Cash 49,120,159 /Operating Expense per day / 115,502 Days of Cash on Hand = 425 300 In Years 1.17 Debt Ratio Total Liabilities 172,193,996 /Total Assets / 547,372,451 Debt Ratio(%) = 31% 40% Debt-Service Coverage Ratio Revenue,Annualized 61,352,086 -O&M Costs,Annualized - 41,580,747 /Total Debt Service / 9,919,127 Debt-Service Coverage Ratio 1.99 0 1.50 Operating Ratio Total O&M Costs 41,580,747 /Total Operating Revenue / 61,352,086 Operating Ratio 68% 0 74% Employee Turnover YTD#of Employee Departures 6 Rolling 12-month turnover 23 /Total#of FTE's / 197 Rolling 12-month Employee Turnover 11.7% Q 10.6% Current Ratio Current Assets 100,575,253 /Current Liabilities / 23,478,531 Current Ratio 4.28 0 2.00 Return on Assets Net Income 4,942,835 Net Income,Annualized 19,771,339 /Total Assets,Annualized 634,672,862 Return on Assets 3.1% 0 2.2% 33 CLAY COUNTY UTILITY AUTHORITY DAYS OF CASH ON HAND 1,000 900 896 — 800 700 666 600 500 489 458 400 300 , 300 200 100 SEP-21 I SEP-22 I SEP-23 OCT-23 NOV-23 DEC-23 CURRENT YEAR Days of Cash of Hand ! Target DEBT RATIO 50% 45% 40% 40% - 35% 25% 20% 15% 10% 5% 0% SEP-21 I SEP-22 I SEP-23 OCT-23 I NOV-23 I DEC-2 CURRENT YEAR Debt Ratio(%) • Target DEBT SERVICE COVERAGE 2.50 2.00 .03 1.87 1.50 1.00 0.50 0.00 SEP-21 I SEP-22 I SEP-23 OCT-23 I NOV-23 I DEC-23 CURRENT YEAR k_ —~Debt-Service Coverage Ratio —Target 34 CLAY COUNTY UTILITY AUTHORITY OPERATING RATIO 76% -- 74% 74% 73% 72% 70% 69% 68% 68% 67 66% 0 % 65% 65 64% 62% 60% SEP 21 I SEP-22 I SEP-23 OCT-23 I NOV-23 I DEC-23 CURRENT YEAR —0—Operating Ratio(%) — Target CURRENT RATIO 6.00 .39 5.00 `71 4.00 4,22 4.36 3.56 3.00 2.00 1.00 0.00 SEP-21 I SEP-22 I SEP-23 OCT-23 I NOV-23 I DEC-23 CURRENT YEAR Current Ratio Target RETURN ON ASSETS 5.0% 4.3% 4.5% 4.5% 3.6% EE . 3.1% . 3.0% 2.5% 2.5% 2.2% 2.0% 1.5% - 1.0 0.5% 0.0% SEP-21 I SEP-22 I SEP-23 OCT-23 I NOV-23 I DEC-23 CURRENT YEAR Return on Assets(%) —Target 35