Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
08.b September 2023 Financial Packet
E47 Clay County Utility Authority working together to 3176 Old Jennings Road protect public health, Middleburg,FL 32068-3907T conserve our natural �i elephone(904)272 5999 resources,and create /Ty A11INOS� www.clayutility.org long-term value for our ratepayers. January 11, 2024 To: Board of Supervisors From: Jeffrey Wesselman Re: September 2023 Financial Package I have enclosed the following financial information: A) Comparative Financial Statements for the twelve months of fiscal years 2022/2023 and 2021/2022. Comparative Balance Sheet Revenue & Expenditure Report Cash-flow Statement B) Cash &Cash Equivalents Report at September 30, 2023 C) Budget Reports for the twelve months of Fiscal Year 2022/2023 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 September 30, 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 Bond Test Report Deferred Connection Report Key Performance Indicators 1 Operating income is$5,537,265 (39%) over budget due to a favorable revenue and favorable expense variance. Operating revenue is$2,049,710 (3.5%) over budget and Operating expenses are$3,486,355 (8%) under budget. Operating revenue has a significant increase in September due to $1,400,000 of Miscellaneous Revenue recorded for lawsuit settlements. This is reflected on Revenue and Expenditure Report on Page 13. The total revenue vs budget for the year is summarized as follows: Favorable/(Unfavorable) Net Water Revenues 388,431.36 Net Sewage Revenues (276,645.99) Net Miscellaneous Revenues 1,937,924.97 Net Operating revenue 2,049,710.3 The amount of operating revenue over budget August YTD was$319,301,the September amount over budget is $1,730,409 resulting in the total amount over budget of$2,049,710. All Operating expense under budget are summarized as follows: Favorable/(Unfavorable) Net Operating Expenses (Page 13) 2,496,186.02 Contingency Expenses (Page 13) 990,168.95 Operating Expenses before Construction 3,486,354.97 Construction Expenses less Depreciation (Page 13&30) 270,524.07 Total Expenditures (Page 14) 3,756,879.04 Subcontractors are $2,304,060.32 under budget accounting for 61.3%of the variance and Contingency at $1,035,501.95 is 27.5%of the expenses variance. All Itemized operating expense variances are in Section C, page 14. We gained 1,429 active (Residential 1,386, General Service,43) water accounts and 1,435 active sewer(Residential 1,398, General Service, 37) accounts for the fiscal year 2022/2023 as compared to an increase of 1,229 active water accounts and an increase of 1,249 active sewer accounts for the same time in fiscal year 2021/2022. 2 CLAY COUNTY UTILITY AUTHORITY COMPARATIVE FINANCIAL STATEMENTS FISCAL YEAR 2022/2023 Section A 01/06/2024 09:38 AM 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 09/30/2022 09/30/2023 *** Assets *** Cash 29,907,741.39 28,049,566.48 Investments 52,627,982.40 101,036,451.10 Accounts Receivable 4,897,661.82 5,120,854.01 Fixed Assets 524,340,267.25 609,756,413.14 Accum. Depreciation (184,691,210.99 (198,219,849.46) Other Assets 1,095,907.13 1,654,762.48 Deferred Outflows 1,708,823.20 1,481,048.06 Total Assets 429,887,172.20 548,879,245.81 *** Liabilities *** Liabilities-ST 21,104,095.26 27,431,261.67 Liabilities-LT (over 1 year) 84,379,852.99 152,224,458.79 Total Liabilities 105,483,948.25 179,655,720.46 *** Fund Balance *** Unassigned 53,823,792.64 57,795,484.23 Investment In Capital Assets 266,607,739.72 306,565,975.18 Total Fund Balance 320,431,532.36 364,361,459.41 Beginning Fund Balance 293,106,326.89 324,403,223.95 Net of Revenues VS Expenditures 3,971,691.59 4,862,065.94 Fund Balance Adjustments 27,325,205.47 39,958,235.46 Ending Fund Balance 324,403,223.95 369,223,525.35 Total Liabilities And Fund Balance 429,887,172.20 548,879,245.81 01/06/2024 09:43 AM BALANCE SHEET FOR CLAY COUNTY UTILITIES Page: 1/3 User: jwesselman Period Ending 09/30/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 400.92 465.29 101.401.101.125 '12 BBVA Compass Debt Service 1,302,399.40 1,757,496.40 101.401.101.160 Cash-BB&T Operating Account 3,572,630.03 9,489,949.87 101.401.101.161 Cash-BB&T Emergency Account 21,946.19 28,883.05 101.401.101.200 CASH-FSA 11,436.71 12,020.88 101.401.101.329 Debt Stabilization Reserve Unrestricted 1,308,417.77 963,662.12 101.401.101.331 2015/2019 Bond Sinking Fund 3,962,908.14 3,690,361.06 101.401.101.333 SBA - 2001 DEP Loan Debt Service Acct 52,132.62 52,129.09 101.401.101.335 CUSTOMER DEPOSIT FUND 3,594,107.18 3,792,115.96 101.401.101.336 SURPLUS FUND 4,251,312.38 3,288,855.18 101.401.101.337 SELF INSURANCE FUND 525,000.00 525,000.00 101.401.101.338 RENEWAL & REPLACEMENT FUND 1,343,254.99 230,495.15 101.401.101.340 WATER PLANT FUND (76%) 407,539.06 120,483.96 101.401.101.342 WATER LINE FUND (24%) 262,993.60 35,371.79 101.401.101.343 AWS Cash 3,517,876.71 2,337,912.19 101.401.101.344 SEWER PLANT FUND (53.33%) 5,267,865.81 1,356,949.47 101.401.101.346 SEWER LINE FUND (46.67%) 328,847.53 188,842.01 101.401.101.351 2018 Bond Sinking Fund 175,670.60 175,667.10 101.401.102.100 PETTY CASH FUND 1,001.75 2,905.91 Cash 29,907,741.39 28,049,566.48 Investments 101.401.101.323 Short Term Investments - Surplus 52,627,982.40 40,593,185.66 101.401.101.324 Truist Escrow Investment Account 0.00 60,443,265.44 Investments 52,627,982.40 101,036,451.10 Accounts Receivable 101.401.115.100 ACCOUNTS RECEIVABLE W&S CUST 2,146,262.84 1,078,203.10 101.401.115.110 A/R CIAC & MISC REPAIR INVS. 1,008,714.36 1,922,765.10 101.401.115.120 Loans To Customers 38,983.11 37,974.82 101.401.115.121 Loan to Customers Long-term 301,709.88 312,002.83 101.401.115.200 A/R UNBILLED WATER REVENUE 619,856.74 852,819.40 101.401.115.250 A/R Unbilled Reuse Revenue 110,653.16 191,252.91 101.401.115.300 A/R UNBILLED SEWER REVENUE 869,171.21 920,632.60 101.401.115.400 A/R CLEARING ACCOUNT 21,286.44 (1,142.20) 101.401.117.100 ALLOWANCE FOR DOUBTFULL A/R (218,975.92) (193,654.55) Accounts Receivable 4,897,661.82 5,120,854.01 Fixed Assets 101.401.161.900 LAND 5,482,317.47 5,268,724.07 101.401.162.900 BUILDINGS 9,706,793.42 15,240,674.68 101.401.166.900 MACHINERY & EQUIPMENT 461,538,814.74 510,633,695.66 101.401.168.900 Intangible Assets 3,652,438.00 3,866,031.40 101.401.169.900 CONSTRUCTION IN PROGRESS 43,959,903.62 74,747,287.33 Fixed Assets 524,340,267.25 609,756,413.14 Accum. Depreciation 101.401.163.900 ACCUM.DEPRECIATION BUILDINGS (9,006,781.88) (9,748,296.50) 101.401.167.900 ACCUM.DEPR. MACHINERY & EQUIPT (175,684,429.11 (188,471,552.96) Accum. Depreciation (184,691,210.99 (198,219,849.46) Other Assets 101.401.115.150 INTEREST RECEIVABLE 160,577.29 310,102.44 101.401.115.500 PREPAID INSURANCE 11,311.30 1,895.86 101.401.115.550 PREPAID W/C INSURANCE (31,113.98) (18,257.58) 101.401.115.575 PREPAID DEP REGULATORY FEES 22,587.49 22,587.47 101.401.115.600 PREPAID MAINTENANCE & EXPENSES 383,619.22 409,949.68 101.401.141.000 INVENTORY 526,361.19 905,601.21 101.401.141.100 UNUSED POSTAGE 22,564.62 22,883.40 Other Assets 1,095,907.13 1,654,762.48 Deferred Outflows 5 01/06/2024 09:43 AM BALANCE SHEET FOR CLAY COUNTY UTILITIES Page: 2/3 User: jwesselman Period Ending 09/30/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,708,823.20 1,481,048.06 Deferred Outflows 1,708,823.20 1,481,048.06 Total Assets 429,887,172.20 548,879,245.81 *** Liabilities *** Liabilities-ST 101.401.202.000 ACCOUNTS PAYABLE 6,430,581.91 11,066,218.27 101.401.202.002 Retainage Payable 907,020.23 1,918,384.83 101.401.215.100 ACCRUED INTEREST 819,798.04 1,450,132.97 101.401.216.100 ACCRUED WAGES PAYABLE 336,654.64 217,379.05 101.401.216.200 ACCRUED SICK, VACATION PAYABLE 779,987.53 860,654.35 101.401.217.100 EMPLOYEE FIT,FICA,MEDICARE W/H 85,423.13 82,469.57 101.401.217.300 Employee Fund Withheld 2,140.78 2,076.48 101.401.217.500 ACCRUED PENSION DUE 111,664.22 107,803.34 101.401.217.600 ACCRUED W/C INS. DUE 27,581.06 26,627.43 101.401.218.100 MISC W/H (126.77) (87.55) 101.401.218.250 LIFE INSURANCE (528.62) (1,073.85) 101.401.218.703 HMO/PPO (3,062.07) (787.67) 101.401.218.705 DENTAL 520.10 (297.13) 101.401.218.706 VISION (215.70) (377.78) 101.401.218.707 ANCILLARY (232.08) 5,705.04 101.401.218.900 ACCRUED ELECTRIC EXPENSE DUE 131,366.93 129,063.77 101.401.220.100 BOND DEPOSITS 105,336.00 110,871.10 101.401.220.150 CLEANING WATER DEPOSITS 127,458.95 145,499.72 101.401.220.175 W&S CUSTOMER DEPOSITS 3,627,824.56 3,801,466.06 101.401.220.180 DUE TO LEND A HELPING HAND 400.92 465.29 101.401.220.185 Refundable Development Agreements 18,735.89 4,608.41 101.401.223.100 DEFERRED REVENUES WATER 144,888.04 127,157.00 101.401.223.200 DEFERRED REVENUE SEWER 300,559.61 264,667.81 101.401.223.300 Deferred Reuse Revenue 57,248.16 52,959.80 101.401.229.200 JAX PUBLIC SERV.TAX COLLECTED 314.30 266.46 101.401.229.201 Keystone Public Service Tax (12.51) 32.75 101.401.232.700 CURRENT BOND PRINCIPAL DUE 7,092,768.01 7,059,376.15 Liabilities-ST 21,104,095.26 27,431,261.67 Liabilities-LT (over 1 year) 101.401.232.569 2012 BBVA Compass Loan 3,293,841.00 1,901,056.00 101.401.232.571 SunTrust 2015 Adv Ref 2007 Bonds 34,964,955.00 33,133,178.00 101.401.232.572 2018 Revenue Bonds Payable DEP MIDCLAY 11,086,278.04 10,462,103.58 101.401.232.573 Dell Financing Lease 275,999.81 0.00 101.401.232.574 Suntrust 2019 Loan & Refinance 41,130,000.00 38,165,000.00 101.401.232.575 2023 Truist Revenue Bond 0.00 75,000,000.00 101.401.232.586 2014 DEP Payable 721,547.15 622,497.36 101.401.232.600 CONTRA CURRENT BOND PRINCIPAL (7,092,768.01) (7,059,376.15) Liabilities-LT (over 1 year) 84,379,852.99 152,224,458.79 Total Liabilities 105,483,948.25 179,655,720.46 *** Fund Balance *** Unassigned 101.401.272.000 RETAINED EARNINGS-UNRESERVED 57,795,484.23 57,795,484.23 Unassigned 57,795,484.23 57,795,484.23 Investment In Capital Assets 101.401.240.000 AWS CIAC 7,130,813.49 8,498,767.35 101.401.240.100 SJRWMD Black Creek CIAC 707,501.13 1,445,756.11 101.401.254.350 WATER CAPACITY CHARGES 11,224,067.36 11,856,865.36 101.401.254.351 FIRE CAPACITY CHARGES 2,035,389.18 2,132,781.82 6 01/06/2024 09:43 AM BALANCE SHEET FOR CLAY COUNTY UTILITIES Page: 3/3 User: jwesselman Period Ending 09/30/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,340,817.16 2,479,403.92 101.401.254.353 WATER CONTRIBUTED ASSETS 52,464,976.63 61,270,367.19 101.401.254.354 WATER MAIN EXTENSION CHARGE 3,109,856.87 3,547,145.50 101.401.254.355 DEBT SERVICE CHARGE 1,305,259.70 1,720,422.96 101.401.254.360 SEWER CAPACITY CHARGES 49,245,421.62 55,213,975.78 101.401.254.361 GRANTS 25,966,282.30 27,658,205.44 101.401.254.362 SEWER TAP IN CHARGE 2,503,301.88 2,605,628.70 101.401.254.363 SEWER CONTRIBUTED ASSETS 103,808,551.24 122,106,574.53 101.401.254.364 SEWER MAIN EXTENSION CHARGE 4,765,501.16 6,030,080.52 Investment In Capital Assets 266,607,739.72 306,565,975.18 Total Fund Balance 324,403,223.95 364,361,459.41 Beginning Fund Balance 324,403,223.95 Net of Revenues VS Expenditures 4,862,065.94 Fund Balance Adjustments 39,958,235.46 Ending Fund Balance 369,223,525.35 Total Liabilities And Fund Balance 548,879,245.81 01/06/2024 09:45 AM REVENUE AND EXPENDITURE REPORT FOR CLAY COUNTY UTILITIES Page: 1/1 User: jwesselman DB: Ccua PERIOD ENDING 09/30/2023 YTD BALANCE YTD BALANCE GL NUMBER DESCRIPTION 09/30/2022 09/30/2023 Fund 101 - GENERAL FUND WATER REVENUES 22,930,684.99 25,503,114.36 SEWER REVENUES 29,199,221.73 30,694,286.01 MISCELLANEOUS REVENUES 1,887,946.18 3,722,133.97 INTEREST UNRESTRICTED 674,636.68 1,032,685.61 INTEREST RESTRICTED 52.99 633,161.44 SALE OF ASSETS 112,277.73 94,751.80 CONSTRUCTION INCOME 235,976.94 196,624.07 TOTAL REVENUES 55,040,797.24 61,876,757.26 BAD DEBT 25,704.96 29,052.90 COMMUNICATION 391,120.78 390,655.84 DUE IN LIEU OF TAXES 2,345,845.80 2,529,048.53 ELECTRIC & FUEL EXPENSES 2,852,121.45 3,034,130.36 MISCELLANEOUS EXPENSES 153,463.54 271,641.02 PROPERTY & LIABILITY INSURANCE 873,930.90 1,017,810.36 PROFESSIONAL SERVICES 1,347,305.90 985,472.05 SLUDGE TREATMENT & DISPOSAL 2,287,832.59 2,636,199.67 SUBCONTRACTORS 2,570,900.08 3,529,466.57 SUPPLIES 4,935,080.53 6,368,955.21 TRANSPORTATION 711,800.28 657,530.84 WAGES & RELATED EXPENSES 16,875,353.72 18,580,210.13 DEPRECIATION 13,176,982.86 13,818,246.60 INTEREST EXPENSE 2,285,685.32 2,828,397.17 CONSTRUCTION EXPENSE 235,976.94 196,624.07 DEBT ISSUANCE COSTS 0.00 141,250.00 TOTAL EXPENDITURES 51,069,105.65 57,014,691.32 Fund 101 - GENERAL FUND: TOTAL REVENUES 55,040,797.24 61,876,757.26 TOTAL EXPENDITURES 51,069,105.65 57,014,691.32 NET OF REVENUES & EXPENDITURES 3,971,691.59 4,862,065.94 TOTAL REVENUES - ALL FUNDS 55,040,797.24 61,876,757.26 TOTAL EXPENDITURES - ALL FUNDS 51,069,105.65 57,014,691.32 NET OF REVENUES & EXPENDITURES 3,971,691.59 4,862,065.94 8 CLAY COUNTY UTILITY AUTHORITY STATEMENTS OF CASH FLOWS FOR THE TWELVE MONTHS ENDED SEPTEMBER 30,2022 AND 2023 September 30,2022 September 30,2023 Cash flows from operating activities $ 22,774,886 $ 24,722,158 Net cash provided by operating activities 22,774,886 24,722,158 Cash flows from capital and related financing activities Proceeds from issuance of bonds and loans - 75,000,000 Principal paid on long-term debt (7,035,129) (7,188,786) Interest paid on long-term debt (2,133,037) (1,970,287) Payments to acquire and construct plant property (40,423,616) (58,533,459) Capital contributions 11,894,297 11,162,898 Grants 2,855,431 1,691,923 Net cash used in capital and related financing activities (34,842,053) 20,162,289 Cash flows from investing activities Purchases of investments (574,373) (71,408,469) Sales of investments - 23,000,000 Interest income 674,690 1,665,847 Net cash provided by investing activities 100,316 (46,742,622) Net increase(decrease)in cash and cash equivalents (11,966,851) (1,858,175) Cash and cash equivalents,beginning of period 41,874,593 29,907,741 Cash and cash equivalents,end of period $ 29,907,741 $ 28,049,566 Reconciliation of operating income to net cash provided by operating activities Cash flows from operating activities Operating income $ 5,470,410 $ 5,929,864 Adjustments to reconcile operating income to net cash provided by operating activities: Depreciation expense 13,217,953 13,844,118 Changes in assets and liabilities Decrease(Increase)in accounts receivable (1,371,782) (223,192) Decrease(Increase)in prepaid items and inventory (57,246) (409,330) Decrease(Increase)in notes/interest receivable (64,129) (149,525) Increase(Decrease)in accounts payable 5,102,528 5,630,632 Increase(Decrease)in accrued expenses 345,117 (39,715) Increase(Decrease)in unearned revenue (50,689) (57,911) Increase(Decrease)in customer deposits 182,724 197,217 Total adjustments 17,304,476 18,792,293 Net cash provided by operating activities $ 22,774,886 $ 24,722,158 Supplemental schedule of noncash investing,capital,and financing activities Utility plant property contributed by developers $ 12,575,477 $ 27,103,414 9 Cumulative Cash Flow $160,000,000 $140,000,000 / $120,000,000 $100,000,000 $80,000,000 $60,000,000 $40,000,000 i $20,000,000 $0 titi titi titi titi titi titi titi titi titi titi titi titi titi titi titi titi ti? ti� ti� ti> ti, ti� ti, ti? ti� 49 0'4 , o- Oe` a� Qe`Q fat PQ� �a2 Jo �'\ P��o cie9 o.4- +o- cr a� <? 4a� P�� �aJ ,,�o •,\ ,e0 5eQ v Cash ■Investments CLAY COUNTY UTILITY AUTHORITY CASH AND CASH EQUIVALENTS REPORT As of September 30, 2023 BB&T Ameris SBA Investments Total Lend A Helping Hand Fund $465 $465 Operating Accounts ** $9,489,950 $9,489,950 FSA Account $12,021 $12,021 Emergency Accounts $28,883 $28,883 Petty Cash $2,906 $2,906 Total Operating Funds $9,533,760 $9,533,760 Public Funds Now: Water Plant Connection Fund $120,484 * $120,484 R Water Line Connection Fund $35,372 * $35,372 R Sewer Plant Connection Fund $1,356,949 * $1,356,949 R Sewer Lines Connection Fund $188,842 * $188,842 R Alternative Water Supply Fund $2,337,912 * $2,337,912 R Renewal&Replacement Fund $230,495 * $230,495 R Debt Stabilization and Reserve Account_Unrestricted $963,662 * - - $963,662 Truist Escrow Investment Account $60,443,265 $60,443,265 R Surplus Fund $2,623,639 $451,755 $111,055 $40,593,186 $43,779,634 Available For Construction $7,857,356 $451,755 $111,055 $101,036,451 $109,456,617 Debt Service Sinking Funds: 2007A Bond Sinking Fund $3,690,361 * $3,690,361 R DEP Loan Debt Service Sinking Acct $52,129 * $52,129 R BBVA Compass Loan Sinking Funds $1,757,496 * $1,757,496 R 2018 Bond Sinking Fund $175,667 * $175,667 R Debt Stabilization and Reserve Account_Restricted Letter of Credit_Financial Responsible Officer $102,406 $102,406 R Customer Deposits&Self Insurance Fund Customer Deposits - * $3,792,116 $3,792,116 R Self Insurance Fund_Sewage Backups * Health Insurance - * $500,000 $500,000 Unemployment * $25,000 $25,000 TOTAL Funds $5,778,060 $4,317,116 - - $10,095,176 TOTAL CASH&CASH EQUIVALENTS $23,169,641 $4,768,871 $111,055 $101,036,451 $129,086,018 Investment Accounts Maturity Date Balance APY US Bank Various $40,593,186 2.23% Truist Escrow Investment Account Monthly $60,443,265 3.55% $101,036,451 * BB&T Public Funds Money Checking Accounts $10,909,370 0.25% BB&T Public Funds Money Checking Accounts $9,489,950 0.25% Ameris Public Funds Money Checking Accounts $4,768,871 0.30% SBA $111,055 4.84% Construction Balance $109,456,617 Operating Cash $7,489,950 Available Construction Balance: $116,946,566 "R"indicates fund is Restricted by Bond Resolution,Enabling Legislation or Board Resolution. Section B Printed 12/11/2023 CLAY COUNTY UTILITY AUTHORITY BUDGET REPORTS FISCAL YEAR 2022/2023 Section C 01/06/2024 REVENUE AND EXPENDITURE REPORT FOR CLAY COUNTY UTILITIES PERIOD ENDING 09/30/2023 OPERATING BUDGET REPORT 2022-23 YTD BALANCE AVAILABLE %BDGT GL NUMBER DESCRIPTION AMENDED BUDGET 09/30/2023 BALANCE USED OPERATING REVENUES Water Revenues Net Water Base Charges 8,192,383.00 8,207,665.53 (15,282.53) 100.19% Net Water Use Charges 11,345,365.00 11,584,702.12 (239,337.12) 102.11% Net Reuse Water Base Charges 3,164,349.00 3,314,480.34 (150,131.34) 104.74% Net Reuse Water Usage Charges 2,412,586.00 2,396,266.37 16,319.63 99.32% Net Water Revenues 25,114,683.00 25,503,114.36 (388,431.36) 101.55% Sewage Revenues Net Sewer Base Charges 16,615,838.00 16,927,479.94 (311,641.94) 101.88% Net Sewer Use Charges 14,355,094.00 13,766,806.07 588,287.93 95.90% Net Sewage Revenues 30,970,932.00 30,694,286.01 276,645.99 99.11% Other Revenues Net Miscellaneous 1,784,209.00 3,722,133.97 (1,937,924.97) 208.62% Net Other Revenues 1,784,209.00 3,722,133.97 (1,937,924.97) 208.62% Net OPERATING REVENUES 57,869,824.00 59,919,534.34 (2,049,710.34) 103.54% INTEREST INCOME Net Unrestricted 584,214.00 1,032,685.61 (448,471.61) 176.76% Net Restricted 2,335.00 633,161.44 (630,826.44) 27116.12% Net INTEREST INCOME 586,549.00 1,665,847.05 (1,079,298.05) 284.01% OPERATING EXPENSES Net Bad Debt Expenses 500.00 29,052.90 (28,552.90) 5810.58% Net Wage Related Expenses 5,230,405.84 5,121,544.21 108,861.63 97.92% Net Communication Expenses 524,779.00 390,655.84 134,123.16 74.44% Net Due in Lieu of Taxes 2,523,853.00 2,529,048.53 (5,195.53) 100.21% Net Electric&Fuel Expenses 2,689,374.00 3,034,130.36 (344,756.36) 112.82% Net Miscellaneous Expenses 204,561.00 271,641.02 (67,080.02) 132.79% Net Property&Liability Insurance 966,619.00 1,017,810.36 (51,191.36) 105.30% Net Professional Services 1,410,459.05 1,256,186.25 154,272.80 89.06% Net Sludge Treatment&Disposal 2,684,753.00 2,636,199.67 48,553.33 98.19% Net Subcontractors 6,150,795.00 3,479,757.77 2,671,037.23 56.57% Net Supplies 5,879,439.00 6,368,955.21 (489,516.21) 108.33% Net Transportation Expenses 723,366.00 657,530.84 65,835.16 90.90% Net Wage Expense 13,537,455.61 13,237,660.52 299,795.09 97.79% Net OPERATING EXPENSES 42,526,359.50 40,030,173.48 2,496,186.02 94.13% NON-OPERATING EXPENSES Net Depreciation Expense 13,170,852.00 13,818,246.60 (647,394.60) 104.92% Net Interest Expense 1,920,828.00 2,828,397.17 (907,569.17) 147.25% Net Loss(Gain)on Sale of Assets 0.00 (94,751.80) 94,751.80 100.00% Net NON-OPERATING EXPENSES 15,091,680.00 16,693,141.97 (1,601,461.97) 110.61% Net CONSTRUCTION EXPENSES 545,662.15 196,624.07 349,038.08 36.03% Net CONSTRUCTION INCOME 545,662.00 196,624.07 349,037.93 36.03% Net CONTINGENCY 990,168.95 0.00 990,168.95 0.00% TOTAL REVENUES-ALL FUNDS 59,002,035.00 61,782,005.46 (2,779,970.46) 104.71% TOTAL EXPENDITURES-ALL FUNDS 59,153,870.60 56,919,939.52 2,233,931.08 96.22% NET OF REVENUES&EXPENDITURES (151,835.60) 4,862,065.94 (5,013,901.54) -3202.19% 13 12/11/2023 05:23 PM EXPENDITURE REPORT FOR CLAY COUNTY UTILITIES Page: 1/1 User: jwesselman DB: Ccua PERIOD ENDING 09/30/2023 OPERATING EXPENSE BUDGET REPORT 2022-23 YTD BALANCE AVAILABLE o BDGT GL NUMBER DESCRIPTION AMENDED BUDGET 09/30/2023 BALANCE USED Net WAGES & TEMP. LABOR 13,991,272.66 13,509,373.72 481,898.94 96.56 Net CAPITALIZED WAGES 176,342.47 24,865.23 151,477.24 14.10 Net HEALTH & LIFE INSURANCE 2,680,227.61 2,497,458.76 182,768.85 93.18 Net PENSION & BENEFITS 1,435,295.57 1,482,315.42 (47,019.85) 103.28 Net PAYROLL TAXES 1,006,069.57 1,001,241.41 4,828.16 99.52 Net W/C INSURANCE 198,880.77 155,670.04 43,210.73 78.27 Net PROPERTY & LIABILITY INSURANCE 1,020,619.00 1,082,777.04 (62,158.04) 106.09 Net TRANSPORTATION 753,366.00 687,715.10 65,650.90 91.29 Net RENTAL EXPENSE 49,706.00 36,275.21 13,430.79 72.98 Net COMMUNICATION EXPENSES 524,779.00 390,655.84 134,123.16 74.44 Net ELECTRIC & FUEL WATER PLANTS 744,000.00 883,612.60 (139,612.60) 118.77 Net ELECTRIC & FUEL LIFT STATIONS 440,000.00 485,780.46 (45,780.46) 110.40 Net ELECTRIC & FUEL SEWAGE PLANTS 1,466,000.00 1,619,996.42 (153,996.42) 110.50 Net ELECTRIC AT OFFICE 39,374.00 44,740.88 (5,366.88) 113.63 Net CHEMICALS FOR WATER 233,400.00 292,643.87 (59,243.87) 125.38 Net CHEMICALS FOR SEWAGE 950,000.00 1,174,276.57 (224,276.57) 123.61 Net SUPPLIES FOR WATER 1,850,390.00 1,567,066.68 283,323.32 84.69 Net SUPPLIES FOR SEWAGE 1,240,684.00 1,752,968.27 (512,284.27) 141.29 Net OFFICE SUPPLIES 1,617,915.00 1,601,899.31 16,015.69 99.01 Net ENGINEERING EXPENSES 393,200.00 334,843.47 58,356.53 85.16 Net LEGAL EXPENSES 537,126.00 610,708.36 (73,582.36) 113.70 Net AUDIT EXPENSES 34,000.00 44,000.00 (10,000.00) 129.41 Net SUBCONTRACTORS-WATER 1,333,056.00 1,143,927.86 189,128.14 85.81 Net SUBCONTRACTORS-SEWAGE 993,729.00 801,597.45 192,131.55 80.67 Net SUBCONTRACTORS-GENERAL 3,848,910.00 1,544,849.68 2,304,060.32 40.14 Net SLUDGE TREATMENT & DISPOSAL 2,684,753.00 2,636,199.67 48,553.33 98.19 Net BAD DEBT EXPENSE 500.00 29,052.90 (28,552.90) 5,810.58 Net MISCELLANEOUS 154,855.00 235,365.81 (80,510.81) 151.99 Net DUE IN LIEU OF TAXES 2,523,853.00 2,529,048.53 (5,195.53) 100.21 Net CONTINGENCY 1,035,501.95 0.00 1,035,501.95 0.00 TOTAL EXPENDITURES - ALL FUNDS 43,957,805.60 40,200,926.56 3,756,879.04 91.45 14 CLAY COUNTY UTILITY AUTHORITY CIAC REPORTS FISCAL YEAR 2022/2023 Section D 12/11/2023 05:24 PM TRIAL BALANCE REPORT FOR CLAY COUNTY UTILITIES Page: 1/2 User: jwesselman DB: Ccua PERIOD ENDING 09/30/2023 ACTIVITY FOR 2022-23 BEG. BALANCE MONTH YEAR-TO-DATE END BALANCE GL NUMBER DESCRIPTION AMENDED BUDGET 10/01/2022 09/30/2023 THRU 09/30/23 09/30/2023 Fund 101 - GENERAL FUND Fund Equity WATER CAPACITY 101.401.254.350 WATER CAPACITY CHARGES 11,224,067.36 26,820.00 632,798.00 11,856,865.36 WATER CAPACITY 11,224,067.36 26,820.00 632,798.00 11,856,865.36 SEWER CAPACITY 101.401.254.360 SEWER CAPACITY CHARGES 49,245,421.62 254,495.00 5,968,554.16 55,213,975.78 101.401.254.361 GRANTS 25,966,282.30 (113,598.08) 1,691,923.14 27,658,205.44 SEWER CAPACITY 75,211,703.92 140,896.92 7,660,477.30 82,872,181.22 AWS 101.401.240.000 AWS CIAC 7,130,813.49 88,008.65 1,367,953.86 8,498,767.35 AWS 7,130,813.49 88,008.65 1,367,953.86 8,498,767.35 SJRWMD BLACK CREEK 101.401.240.100 SJRWMD Black Creek CIAC 707,501.13 61,402.25 738,254.98 1,445,756.11 SJRWMD BLACK CREEK 707,501.13 61,402.25 738,254.98 1,445,756.11 WATER MAIN 101.401.254.354 WATER MAIN EXTENSION CHARGE 3,109,856.87 106,879.01 437,288.63 3,547,145.50 WATER MAIN 3,109,856.87 106,879.01 437,288.63 3,547,145.50 SEWER MAIN 101.401.254.364 SEWER MAIN EXTENSION CHARGE 4,765,501.16 292,536.61 1,264,579.36 6,030,080.52 SEWER MAIN 4,765,501.16 292,536.61 1,264,579.36 6,030,080.52 FIRE 101.401.254.351 FIRE CAPACITY CHARGES 2,035,389.18 29,061.82 97,392.64 2,132,781.82 FIRE 2,035,389.18 29,061.82 97,392.64 2,132,781.82 WATER TAP IN 101.401.254.352 WATER TAP IN CHARGE 2,340,817.16 5,414.61 138,586.76 2,479,403.92 WATER TAP IN 2,340,817.16 5,414.61 138,586.76 2,479,403.92 SEWER TAP IN 101.401.254.362 SEWER TAP IN CHARGE 2,503,301.88 22,712.57 102,326.82 2,605,628.70 SEWER TAP IN 2,503,301.88 22,712.57 102,326.82 2,605,628.70 WATER CONT PROP 101.401.254.353 WATER CONTRIBUTED ASSETS 52,464,976.63 372,437.66 8,805,390.56 61,270,367.19 WATER CONT PROP 52,464,976.63 372,437.66 8,805,390.56 61,270,367.19 SEWER CONT PROP 101.401.254.363 SEWER CONTRIBUTED ASSETS 103,808,551.24 465,847.85 18,298,023.29 122,106,574.53 SEWER CONT PROP 103,808,551.24 465,847.85 18,298,023.29 122,106,574.53 DEBT SERVICE 101.401.254.355 DEBT SERVICE CHARGE 1,305,259.70 8,567.50 415,163.26 1,720,422.96 16 12/11/2023 05:24 PM TRIAL BALANCE REPORT FOR CLAY COUNTY UTILITIES Page: 2/2 User: jwesselman DB: Ccua PERIOD ENDING 09/30/2023 ACTIVITY FOR 2022-23 BEG. BALANCE MONTH YEAR-TO-DATE END BALANCE GL NUMBER DESCRIPTION AMENDED BUDGET 10/01/2022 09/30/2023 THRU 09/30/23 09/30/2023 Fund 101 - GENERAL FUND Fund Equity DEBT SERVICE 1,305,259.70 8,567.50 415,163.26 1,720,422.96 TOTAL FUND EQUITY 266,607,739.72 1,620,585.45 39,958,235.46 306,565,975.18 Total Fund 101 - GENERAL FUND TOTAL ASSETS 0.00 0.00 0.00 0.00 BEG. FUND BALANCE 324,403,223.95 324,403,223.95 + NET OF REVENUES & EXPENDITURES + FUND BALANCE ADJUSTMENTS (57,795,484.23) (17,837,248.77) = ENDING FUND BALANCE 266,607,739.72 1,620,585.45 39,958,235.46 306,565,975.18 + LIABILITIES 0.00 0.00 0.00 0.00 = TOTAL LIABILITIES AND FUND BALANCE 266,607,739.72 1,620,585.45 39,958,235.46 306,565,975.18 OUT OF BALANCE 0.00 (1,620,585.45) (39,958,235.46) (306,565,975.18) 17 CLAY COUNTY UTILITY AUTHORITY 2022/2023 Alternative Water Supply Surcharges Beginning October November December January February March April May June July August September Balance Established 10/1/2015 Balance 2022 2022 2022 2023 2023 2023 2023 2023 2023 2023 2023 2023 9/30/2023 Expenditures: Job 991 FCOB Stormwater Harvesting Pilot Project 800,174.90 20,548.61 12.531.42 4,599.53 19,936.35 8,544.15 16,793.59 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 708,857.91 206,433.56 206,108.72 215,418.18 177,601.55 257,337.78 328,463.08 75,375.73 355,846.34 222,758.80 34,401.52 378,327.40 177,040.43 3,343,971.00 New Development: - Total Expenditures 3,533,989.87 226,982.17 218,640.14 220,017.71 177,601.55 277,274.13 328,463.08 75,375.73 355,846.34 222,758.80 42,945.67 395,120.99 177,040.43 6,252,056.61 Existing Customers: Revenue: Surcharge Fund(Existing Customers) 4,108,291.49 56,754.88 59,482.10 58,466.00 58,608.60 59,697.15 58,783.40 58,834.00 59,105.40 59,260.65 59,520.55 59,604.50 59,639.00 4,816,047.72 Connection Charge Fund(Growth) 2,894,376.18 33,286.82 30,833.86 53,408.52 28,817.17 39,843.78 82,978.07 138,363.05 100,774.53 20,573.28 50,656.95 35,976.86 46,717.79 3,556,606.86 Interest Income 40,273.79 40,273.79 Total Revenue 7,042,941.46 90,041.70 90,315.96 111,874.52 87,425.77 99,540.93 141,761.47 197,197.05 159,879.93 79,833.93 110,177.50 95,581.36 106,356.79 8,412,928.37 Balance 3,508,951.59 (136,940.47)(128,324.18) (108,143.19) (90,175.78) (177,733.20) (186,701.61) 121,821.32 (195,966.41) (142,924.87) 67,231.83 (299,539.63) (70,683.64) 2,160,871.76 Cash Balance 2,337,912.19 Done in following Month: Less Construction Costs transferred after month close (177,040.43) J/E-Adjustment True Up for Move-Ins/Move-Outs J/E-Interfund Transfer 2,160,871.76 Page D-la 18 CLAY COUNTY UTILITY AUTHORITY CAPITAL PROJECT BUDGET REPORT FISCAL YEAR 2022/2023 Section E 19 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 09/30/23 Balances To Fund Amendments 2022/2023 RENEWAL,REPLACEMENT&BETTERMENT Departmental Capital 100 804,787.06 1,386,263.08 2,191,050.14 1,066,761.20 1,124,288.94 2,191,050.14 Upgrade Lift station 9-Meadowbrook 755 101,922.26 101,922.26 8,077.74 93,844.52 101,922.26 Rehab SP WW Clarifer#1/under drain 1-2 02519RR 933,274.98 615,901.22 1,549,176.20 1,407,175.38 142,000.82 1,549,176.20 Ridgecrest WTP-Replace Softstart&Crossline Starters with VFD's 20021RR 907,510.65 1,103,717.35 2,011,228.00 1,866,342.45 144,885.55 2,011,228.00 New Lift Station Generators:172,165,151,142,163,124 21002RR 56,108.76 1,713.37 57,822.13 286,069.11 343,891.24 0.00 25 343,891.24 Fleming Island Reg.WWTP-2nd BCR Plant,Two Tanks 2101ORR 5,200,000.00 2,000,000.00 7,200,000.00 0.00 4,074,218.16 3,125,781.84 7 7,200,000.00 Fleming WRF Clarifier No.1 Upgrade 21014RR 1,101,500.14 106,499.86 1,208,000.00 (419,142.38) 788,857.62 0.00 7,25 788,857.62 Lift Station#2 Upgrade 21016RR 1,362,911.59 2,471,234.57 3,834,146.16 0.00 374,772.58 3,459,373.58 1 3,834,146.16 Ridaught WWTP Upgrades(Install Micro-screen,Grit Removal Equipment,z 21019RR 1,505,007.13 1,381,992.87 2,887,000.00 2,097,257.28 789,742.72 2,887,000.00 Lift Station No.3 Foxbay Upgrade 0.00 750,000.00 0.00 750,000.00 8 750,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 949,070.30 1,133,237.70 2,082,308.00 0.00 533,636.92 1,548,671.08 7 2,082,308.00 Gravity Sewer Lining 21031RR 692,096.12 0.00 692,096.12 692,096.12 0.00 692,096.12 Gravity Sewer Lining FY 23 23016RR 307,903.88 1,000,000.00 1,307,903.88 901,211.20 406,692.68 1,307,903.88 Oakleaf WTP Well No.2 22005RR 75,145.08 75,145.08 (1,944.64) 73,200.44 0.00 25 73,200.44 Ridaught WTP-Phase I GST Upgrades 22007RR 872,000.00 872,000.00 (817,896.74) 54,103.26 0.00 1 54,103.26 Lift Station#4 Upgrades 22008RR 487,985.00 312,015.00 800,000.00 0.00 45,751.41 754,248.59 1 800,000.00 Lift Station#62 and#67-Rehabilitation 22009RR 320,000.00 320,000.00 76,869.25 243,130.75 320,000.00 Fleming Oaks WTP Electrical Upgrades&Hydro Tank Not Started 0.00 190,000.00 190,000.00 (190,000.00) 0.00 0.00 4 0.00 Lake Asbury WM Improvements(602 Lake Asbury Road&Aldersgate St.) Not Started 170,000.00 170,000.00 (170,000.00) 0.00 0.00 1 0.00 Wesley RD WM Improvements(Branscomb Road to Arthur Moore Drive) Not Started 200,000.00 200,000.00 (200,000.00) 0.00 0.00 1 0.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 Booster Station(Hwy.100 @ Commercial Dr.-Keystone) Not Started 0.00 0.00 0.00 0.00 0.00 Keystone Wastewater Treatment Plant-Phase II Construction Not Started 0.00 0.00 0.00 0.00 0.00 Keystone Heights High School WM relocation Not Started 0.00 143,000.00 143,000.00 0.00 143,000.00 143,000.00 Keystone Heights-Lakeside Street/Hilltop Street Water Main Rehabilitation 23024RR 0.00 237,600.00 237,600.00 21,600.00 216,000.00 237,600.00 Miller St.WWTP Upgrades(Complete Paving of Loop Road,Refurbish Influ Not Started 0.00 0.00 0.00 0.00 0.00 Pace Island&Fleming Oaks WTP Electrical Upgrades 23007RR 0.00 220,000.00 220,000.00 (27,893.00) 119,113.39 72,993.61 4&6 192,107.00 Old Jennings WTP Electrical Upgrade Not Started 0.00 0.00 0.00 0.00 0.00 Spencer's 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 Fleming island WRF electrical upgrades/Vault upgrades 23009RR 0.00 296,171.00 296,171.00 113,219.63 182,951.37 296,171.00 Miller WRF Electrical Upgrades&WWTP Upgrades 23004RR 0.00 125,005.00 125,005.00 30,000.00 61,375.56 93,629.44 14 155,005.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 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 Spencers WTP-Ground Storage&High Service Pump&Electrical Upgrade 23005RR 0.00 565,000.00 565,000.00 (327,152.00) 214,650.64 23,197.36 6 237,848.00 Sandridge Road widening from Henley to CR 209 and ForceMain Extension 23015SL 40,000.00 1,040,000.00 1,080,000.00 960,000.00 1,514,301.81 525,698.19 6 2,040,000.00 Server Lifecycle Replacement Not Started 0.00 0.00 0.00 0.00 0.00 ERP Software Replacement 23010RR 0.00 1,400,000.00 1,400,000.00 1,443,782.00 2,533,402.67 310,379.33 3 2,843,782.00 Upgrade Lift Stations 11,41,69,51 23012RR 542,000.00 542,000.00 (383,907.20) 122,387.25 35,705.55 6 158,092.80 Upgrade Lift Station 98 Not Started 0.00 0.00 0.00 0.00 0.00 Mid-Clay Entrance Road Stabilization 23025RR 0.00 0.00 50,000.00 12,220.68 37,779.32 20 50,000.00 Upgrade Lift Stations 9,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 Upgrade Lift Station 56 Not Started 0.00 125,000.00 125,000.00 (125,000.00) 0.00 0.00 6 0.00 Lift Station Bypass Pump Not Started 0.00 200,000.00 200,000.00 0.00 200,000.00 200,000.00 20 X:\Finance\Controllers Folder\Monthly Financial\Monthly Construction Reports\2022-2023\CIP_2023_September.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 Job Description Job Number Budget Adopted Budget Budgets Amendments 09/30/23 Balances To Fund Amendments 2022/2023 SCADA System 23008RR 0.00 1,260,048.00 1,260,048.00 (1,010,048.00) 48,500.00 201,500.00 7 250,000.00 WTP Ground Storage Tanks:add Handrails Not Started 576,000.00 576,000.00 (576,000.00) 0.00 0.00 6 0.00 Water Plant Meters Retrofits Not Started 0.00 108,000.00 108,000.00 0.00 108,000.00 108,000.00 Manhole Rehab Not Started 150,000.00 150,000.00 0.00 150,000.00 150,000.00 FH and Gate Valve replacement Not Started 105,000.00 105,000.00 0.00 105,000.00 105,000.00 Potable and Reclaimed Water Meter and backflow device replacement 23003RR 761,250.00 761,250.00 631,379.21 129,870.79 761,250.00 Mid-Clay WRF Alternate Driveway 23028RR 0.00 1,200,000.00 1,200,000.00 24 I 1,200,000.00 SYSTEM EXPANSION Meadow Lake WTP-New Ground Storage Tank and Electrical Service upgra 00983WP 2,198,046.00 951,078.00 3,149,124.00 2,937,694.19 211,429.81 3,149,124.00 Henley Road 12"WM Loop-Sandridge to Small Lake 01119WL 106,000.00 106,000.00 (94,741.36) 11,258.64 0.00 6 11,258.64 North Middleburg Water&Sewer Extension and Interconnection(Water Intr 02419WL 1,869,191.77 1,130,808.23 3,000,000.00 (2,439,445.33) 362,528.17 198,026.50 7,18 560,554.67 Saratoga SpringsWTP-PhaseI 03018WP 6,740,786.55 9,850,213.45 16,591,000.00 16,621,199.53 (30,199.53) 16,591,000.00 Middleburg Water and Sewer Relocations 03319WL 602,241.10 602,241.10 (329,043.66) 273,197.44 0.00 6,25 273,197.44 Mid Clay W WTP-Phase II Plant Expansion 20003SP 5,082,615.00 2,167,385.00 7,250,000.00 396,695.14 7,646,695.14 0.00 18,25 7,646,695.14 Fleming Island Reg.W WTP-#3 BTU Installation,Design 20004SP 6,520,000.00 6,520,000.00 358,340.65 6,878,340.65 0.00 6,25 6,878,340.65 2019-054 Doctors Lake Restoration Project 20011 SL 411,340.52 1,471,992.48 1,883,333.00 (865,343.17) 1,017,989.83 0.00 6,25 1,017,989.83 CCUA Storage Building and Site Improvements 21001AD 3,734,845.00 178,471.00 3,913,316.00 301,547.10 4,214,863.10 0.00 17,25 4,214,863.10 CCUA Administrative Building Phase I 21013AD 214,907.00 3,910,182.00 4,125,089.00 1,000,000.00 1,448,583.48 3,676,505.52 16 5,125,089.00 CCUA Administrative Building Phase II Not Started 0.00 350,000.00 350,000.00 (350,000.00) 0.00 0.00 6 0.00 Aquarius Concourse Relocation Utility Relocations 21004WL 1,948,637.00 195,000.00 2,143,637.00 46,702.41 2,190,339.41 (0.00)18,25 2,190,339.41 Swimming Penn Creek WM Interconnect 21020WL 2,000,000.00 250,000.00 2,250,000.00 0.00 425,229.55 1,824,770.45 7 2,250,000.00 Ravines to Henly Road Water Main Extension 21023WL 2,250,000.00 2,250,000.00 0.00 416,265.77 1,833,734.23 7 2,250,000.00 Governor's Park WTP Design and Build 21026WP 977,400.00 4,147,600.00 5,125,000.00 2,168,088.51 2,956,911.49 5,125,000.00 Peters Creek WTP 2nd GST&3rd Well 21030WP 975,000.00 2,075,000.00 3,050,000.00 (2,795,073.08) 267,547.26 (12,620.34) 7 254,926.92 Peters Creek New Regional WRF 22003SP 4,675,000.00 24,796,152.00 29,471,152.00 17,052,816.83 27,022,886.24 19,501,082.59 1 46,523,968.83 CCUA North Campus Driveway 22010AD 36,340.73 750,000.27 786,341.00 0.00 39,161.35 747,179.65 7 786,341.00 LAMPA E/W Interconnect#1-Water Lines 22012WL 247,500.00 752,500.00 1,000,000.00 917,544.19 82,455.81 1,000,000.00 LAMPA E/W Interconnect#1-Wwtr-Reuse 22013SL 495,000.00 1,505,000.00 2,000,000.00 1,880,036.47 119,963.53 2,000,000.00 LAMPA E/W Interconnect#2-Water Lines 22014WL 165,000.00 501,667.00 666,667.00 (644,134.40) 28,105.29 (5,572.69) 6 22,532.60 LAMPA E/W Interconnect#2-Wwtr-Reuse 22015SL 330,000.00 1,003,333.00 1,333,333.00 (1,287,572.67) 57,964.36 (12,204.03) 6 45,760.33 LAMPA N/S Interconnect#1-Water Lines 22016WL 305,250.00 928,083.00 1,233,333.00 (1,219,447.23) 17,319.95 (3,434.18) 6 13,885.77 LAMPA N/S Interconnect#2 Wwtr&Reuse 22017SL 610,500.00 1,856,167.00 2,466,667.00 (2,438,454.63) 35,189.76 (6,977.39) 6 28,212.37 LAMPA N/S Interconnect#2 Water Lines 22018WL 181,500.00 181,500.00 (173,243.13) 10,298.93 (2,042.06) 6 8,256.87 LAMPA N/S Interconnect#2 Wwtr&Reuse 22019SL 363,000.00 363,000.00 (346,231.98) 20,915.03 (4,147.01) 6 16,768.02 Emalyn Place 3 Single Family Units 22021WL 17,000.00 17,000.00 12,650.92 4,349.08 17,000.00 Postmaster WTP Electrical Upgrades 23001WP 0.00 181,657.00 63,579.95 118,077.05 9 181,657.00 Wwtr Service 633 Simmons Trail 23002SL 0.00 13,536.97 13,536.97 0.00 2,25 13,536.97 Silo Oaks to Nautilis Place Water Main Interconnect 23006WL 0.00 37,034.31 37,034.31 0.00 5,18,25 37,034.31 Fairgrounds Master LS-Study&Design 23011SL 0.00 100,000.00 0.00 100,000.00 22 100,000.00 Water Service to 1014&998 Floyd St. 23013WL 0.00 53,384.73 53,384.73 0.00 10,25 53,384.73 Clay County-College Drive RRR Project 23014WL 0.00 35,000.00 0.00 35,000.00 15 35,000.00 Upsize Mains-Double Branch Cost Share 23018WL 0.00 316,169.64 316,169.64 0.00 11 316,169.64 Knight Boxx/Old Jennings Force Main Extension and Lift Station 56 23019SL 90,885.05 368,229.90 459,114.95 (324,136.95) 16,085.13 118,892.87 7 134,978.00 Water Service to 3255 Bliss Rd. 23020WL 0.00 91,790.21 71,190.82 20,599.39 12,25 91,790.21 Upsizing Mains fro Bradley Creek to Russell Retreat 23021WL 0.00 394,236.58 353,900.00 40,336.58 13 394,236.58 Water Service to 461 Creighton Rd. 23022WL 0.00 71,520.73 70,991.05 529.68 19,25 71,520.73 Home Depot-Lowes Interconnect 23026WL 0.00 23,664.53 22,465.48 1,199.05 21,25 23,664.53 Water Service to 879 Creighton Rd. 23027WL 0.00 25,000.00 10,394.46 14,605.54 23 25,000.00 Engineering Cost Allocation 9999999 0.00 0.00 0.00 0.00 Reinhold Projects E/W interconnect#1 (W,WW&Reclaimed Mains from F Not Started 0.00 0.00 0.00 0.00 0.00 Reinhold Projects E/W interconnect#2(W,WW&Reclaimed Mains along I Not Started 0.00 0.00 0.00 0.00 0.00 21 X:\Finance\Controllers Folder\Monthly Financial\Monthly Construction Reports\2022-2023\CIP_2023_September.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 09/30/23 Balances To Fund Amendments 2022/2023 Reinhold Projects N/S interconnect#1 Saratoga WM to West of 1st Coast Ex Not Started 0.00 0.00 0.00 0.00 0.00 Reinhold Projects N/S interconnect#2(W&Reclaimed Mains from Saratoga Not Started 0.00 0.00 0.00 0.00 16-inch WM Challenger Dr Interconnect to Atlantis dr.-Atlantis to Brannan Not Started 1,000,000.00 1,000,000.00 (1,000,000.00) 0.00 0.00 1 0.00 16-inch WM Atlantis to Kindlewood Not Started 500,000.00 500,000.00 (500,000.00) 0.00 0.00 1 0.00 Upsizing pipes to accommodate Rookery GCS Not Started 0.00 0.00 0.00 0.00 FDOT 447180-1:US17 from Eagle Harbor to Doctors Inlet Bridge Not Started 310,000.00 310,000.00 0.00 310,000.00 310,000.00 FDOT 443302-1:SRI 5(US17)From Water Oak Lane to Eagle Harbor Parks Not Started 0.00 0.00 0.00 0.00 CR-220 at Old Hard Rd.Intersection Not Started 410,000.00 410,000.00 0.00 410,000.00 410,000.00 Tanglewood Neighborhood Water Main Relocations Not Started 85,000.00 85,000.00 0.00 85,000.00 85,000.00 Habitat Drive Water Main Relocations Not Started 265,000.00 265,000.00 0.00 265,000.00 265,000.00 CR 218 widening from Pine Tree Lane to Cosmos 22020RR 425,000.00 250,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 250,000.00 0.00 250,000.00 250,000.00 CR 220 widening from Henley to Knightbox Not Started 150,000.00 150,000.00 (100,000.00) 0.00 50,000.00 6 50,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 College Drive RRR Not Started 200,000.00 200,000.00 (200,000.00) 0.00 0.00 6 I 0.00 Infill Projects Not Started 1,261,678.98 100,000.00 1,361,678.98 0.00 1,361,678.98 1,361,678.98 Pier Station E/W WM Extension and Interconnect(State Road 16 and FCOB Not Started 0.00 0.00 0.00 0.00 0.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 Water System Interconnects-Misc Not Started 660,000.00 15,000.00 675,000.00 (675,000.00) 0.00 0.00 6 0.00 Longbay Rd.Master Pump Station and Force Main Not Started 0.00 200,000.00 200,000.00 (200,000.00) 0.00 0.00 6 0.00 ALTERNATIVE WATER SUPPLY Purified Water Pilot Study 20022WL 614,261.99 4,154,738.01 4,769,000.00 3,411,323.27 1,357,676.73 4,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 Irrigation CUP Not Started 510,000.00 510,000.00 (510,000.00) 0.00 0.00 1 0.00 Public Access Reuse Storage Not Started 2,042,000.00 2,042,000.00 (2,042,000.00) 0.00 0.00 0.00 Subtotals 64,949,044.64 89,489,249.36 154,438,294.00 2,436,096.39 101,582,716.86 55,291,673.53 156,874,390.39 Contingency 12,056,826.16 12,056,826.16 (2,436,096.39) (1-25) 9,620,729.77 TOTAL CAPITAL EXPENDITURES 166,495,120.16 0.00 166,495,120.16 Construction In Progress 154,438,294.00 74,747,287.33 Not Started 5,253,678.98 Completed Jobs 16,238,441.00 26,835,429.53 Started 161,241,441.18 814,375.83 101,582,716.86 166,495,120.16 22 X:\Finance\Controllers Folder\Monthly Financial\Monthly Construction Reports\2022-2023\CIP_2023_September.xlsx Page 3 of 3 CLAY COUNTY UTILITY AUTHORITY OPERATING DETAIL BY MONTH FISCAL YEAR 2022/2023 Section F 23 12/11/2023 05:42 PM REVENUE REPORT FOR CLAY COUNTY UTILITIES Page: 1/1 User: jwesselman DB: Ccua PERIOD ENDING 09/30/2023 OPERATING REVENUE BUDGET REPORT ACTIVITY FOR 2022-23 MONTH YTD BALANCE o BDGT GL NUMBER DESCRIPTION AMENDED BUDGET 09/30/2023 09/30/2023 USED OPERATING REVENUES Water Revenues Water Base Charges 101.401.343.301 RESIDENTIAL WATER BASE CHARGE 6,650,811.00 588,217.70 6,691,707.83 100.61 101.401.343.303 GENERAL SERVICE WATER BASE 1,273,001.00 112,880.67 1,297,572.40 101.93 101.401.346.303 Commercial Potable Irrigation Base 268,571.00 19,060.00 218,385.30 81.31 Net Water Base Charges 8,192,383.00 720,158.37 8,207,665.53 101.55 Water Use Charges 101.401.343.304 GENERAL SERVICE WATER USAGE 0.00 0.00 2.35 100.00 101.401.344.303 Residential Water Usage Tier 1 3,563,059.00 309,845.90 3,653,041.55 102.53 101.401.344.304 Residential Water Usage Tier 2 2,473,019.00 244,949.56 2,591,932.03 104.81 101.401.344.305 Residential Water Usage Tier 3 1,037,236.00 115,369.89 1,087,488.72 104.84 101.401.344.306 Residential Water Usage Tier 4 1,184,957.00 127,029.54 1,142,137.81 96.39 101.401.345.305 Commercial Water Usage 2,455,117.00 214,389.27 2,516,821.30 102.51 101.401.346.306 Commercial Potable Irrigation Usage 123,817.00 10,074.60 111,535.31 90.08 101.401.346.307 Commercial Potable Irrigation Usage 223,841.00 20,404.37 202,455.74 90.45 101.401.346.308 Commercial Potable Irrigation Usage 171,240.00 15,900.78 154,139.56 90.01 101.401.346.309 Commercial Potable Irrigation Usage 113,079.00 17,838.44 125,147.75 110.67 Net Water Use Charges 11,345,365.00 1,075,802.35 11,584,702.12 101.55 Reuse Water Base Charges 101.401.343.601 Reuse Residential Base 2,890,097.00 272,536.24 3,028,089.17 104.77 101.401.343.602 Reuse Commercial Base 274,252.00 25,751.26 286,391.17 104.43 Net Reuse Water Base Charges 3,164,349.00 298,287.50 3,314,480.34 101.55 Reuse Water Usage Charges 101.401.347.403 Reuse Residential Usage Tier 1 934,528.00 94,833.16 949,596.99 101.61 101.401.347.404 Reuse Residential Usage Tier 2 250,847.00 24,802.15 233,226.69 92.98 101.401.347.405 Reuse Residential Usage Tier 3 714,664.00 74,872.95 659,984.72 92.35 101.401.347.406 Reuse Commercial Usage Tier 1 100,963.00 9,335.93 91,214.19 90.34 101.401.347.407 Reuse Commercial Usage Tier 2 35,037.00 3,745.30 32,179.68 91.84 101.401.347.408 Reuse Commercial Usage Tier 3 248,766.00 41,417.53 287,659.15 115.63 101.401.349.506 CROSSINGS RECLAIMED WATER CHRG 127,781.00 14,417.76 142,404.95 111.44 Net Reuse Water Usage Charges 2,412,586.00 263,424.78 2,396,266.37 101.55 Net Water Revenues 25,114,683.00 2,357,673.00 25,503,114.36 101.55 Sewage Revenues Sewer Base Charges 101.401.343.501 RESIDENTIAL SEWER BASE CHARGE 14,324,559.00 1,260,802.28 14,320,986.12 99.98 101.401.343.504 GENERAL SERVICE SEWER BASE 2,291,279.00 229,961.44 2,606,493.82 113.76 Net Sewer Base Charges 16,615,838.00 1,490,763.72 16,927,479.94 99.11 Sewer Use Charges 101.401.343.502 RESIDENTIAL SEWER USAGE CHARGE 10,787,637.00 872,154.91 10,143,285.05 94.03 101.401.343.505 GENERAL SERVICE SEWER USAGE 3,383,857.00 292,849.58 3,422,599.17 101.14 101.401.343.506 PORTALET SEWAGE REVENUE 183,600.00 12,053.17 200,921.85 109.43 Net Sewer Use Charges 14,355,094.00 1,177,057.66 13,766,806.07 99.11 Net Sewage Revenues 30,970,932.00 2,667,821.38 30,694,286.01 99.11 Net OPERATING REVENUES 56,085,615.00 5,025,494.38 56,197,400.37 99.11 TOTAL REVENUES - ALL FUNDS 56,085,615.00 5,025,494.38 56,197,400.37 100.20 24 Budgeted vs. Actual - Base & Use Charges, Total 30,000,000 25,000,000 .."11/1 20,000,000 — - 15,000,000 — 10,000,000 - r I 111 5,000,000 - 11- d - 0 October November December January February March April May June July August September Actual Base Charges Actual Use Charges Budgeted Base Charges Budgeted Use Charges Operating Revenue _ $7,000,000 millik.1111 — — $6,000,000 $5,000,000 r i $4,000,000 - - - II _ _ _ $3,000,000 , Itgi $2,000,000 si,000,000 $o October November December January February March April May June July August September Actual Optg Rev Prior Year Optg Rev Budgeted Optg Rev Operating Net Income $3,000,000 $2,500,000 — $2,000,000 - — u A $1,500,000 "r „„ ,.. ii N.-, p _..., $1,000,000 - I ip i■ PI $500,000 - I — d _ . _ ■ $0 _ October November December January February March April May June July August September Actual Net Income Prior Year Net Income Budgeted Net Income 27 CLAY COUNTY UTILITY AUTHORITY OTHER REPORTS FISCAL YEAR 2022/2023 Section G 28 12/11/2023 05:56 PM REVENUE AND EXPENDITURE REPORT FOR CLAY COUNTY UTILITIES Page: 1/2 User: jwesselman DB: Ccua PERIOD ENDING 09/30/2023 CONSTRUCTION DEPARTMENT BUDGET ACTIVITY FOR 2022-23 MONTH YTD BALANCE ENCUMBERED UNENCUMBERED o BDGT GL NUMBER DESCRIPTION AMENDED BUDGET 09/30/23 09/30/2023 YEAR-TO-DATE BALANCE USED INTERNAL BILLINGS 101.401.349.609 BILLINGS TO CCUA-CAPITAL ASSET 545,662.00 134,749.59 196,624.07 0.00 349,037.93 36.03 Net INTERNAL BILLINGS 545,662.00 134,749.59 196,624.07 0.00 349,037.93 36.03 WAGES 101.401.536.128 C/D JOB PAYROLL 0.00 1,911.93 35,318.40 0.00 (35,318.40) 100.00 101.401.536.129 C/D CONTRA JOB PAYROLL 0.00 (1,911.93) (35,318.40) 0.00 35,318.40 100.00 101.502.536.121 WAGES HOURLY 176,342.47 1,357.92 24,561.39 0.00 151,781.08 13.93 101.502.536.127 WAGES SALARY 0.00 0.00 303.84 0.00 (303.84) 100.00 Net WAGES (176,342.47) (1,357.92) (24,865.23) 0.00 (151,477.24) 14.10 HEALTH/LIFE INSURANCE 101.502.536.230 EMPLOYEE HEALTH&LIFE INSURANCE 46,856.78 271.83 5,883.06 0.00 40,973.72 12.56 Net HEALTH/LIFE INSURANCE (46,856.78) (271.83) (5,883.06) 0.00 (40,973.72) 12.56 RETIREMENT & BENEFITS 101.502.536.220 EMPLOYEE RETIREMENT & BENEFITS 21,712.77 145.98 3,283.48 99.95 18,329.34 15.58 Net RETIREMENT & BENEFITS (21,712.77) (145.98) (3,283.48) (99.95) (18,329.34) 15.58 PAYROLL TAXES 101.502.536.210 EMPLOYER FICA PAYROLL TAXES 15,281.80 99.85 1,803.66 0.00 13,478.14 11.80 Net PAYROLL TAXES (15,281.80) (99.85) (1,803.66) 0.00 (13,478.14) 11.80 WORKMENS COMPENSATION INS. 101.502.536.240 W/C INSURANCE 6,216.33 (382.72) 427.21 0.00 5,789.12 6.87 101.509.536.246 CONSTRUCTION W/C INSURANCE 0.00 (2,792.99) 3,744.01 0.00 (3,744.01) 100.00 Net WORKMENS COMPENSATION INS. (6,216.33) 3,175.71 (4,171.22) 0.00 (2,045.11) 67.10 PROPERTY/LIABILITY INSURANCE 101.502.536.451 PROPERTY INSURANCE-CONSTRUCTION 54,000.00 5,395.57 64,966.68 0.00 (10,966.68) 120.31 Net PROPERTY/LIABILITY INSURANCE (54,000.00) (5,395.57) (64,966.68) 0.00 10,966.68 120.31 OFFICE SUPPLIES 101.502.536.529 SUPPLIES OFFICE 250.00 0.00 42.75 0.00 207.25 17.10 Net OFFICE SUPPLIES (250.00) 0.00 (42.75) 0.00 (207.25) 17.10 TOOLS & SUPPLIES 101.502.536.407 JOB EQUIPMENT CHARGES 0.00 842.50 9,405.50 0.00 (9,405.50) 100.00 101.502.536.527 TOOLS & SUPPLIES 12,700.00 491.75 10,451.24 (23.39) 2,272.15 82.11 Net TOOLS & SUPPLIES (12,700.00) (1,334.25) (19,856.74) 23.39 7,133.35 156.17 FUEL, OIL, & REPAIRS 101.502.536.468 EQUIP REPAIR&MAINTENANCE 30,000.00 267.51 14,697.00 2,865.00 12,438.00 58.54 Net FUEL, OIL, & REPAIRS (30,000.00) (267.51) (14,697.00) (2,865.00) (12,438.00) 58.54 TRANSPORTATION 101.502.536.401 TRANSPORTATION EXPENSES 30,000.00 1,510.74 30,184.26 0.00 (184.26) 100.61 Net TRANSPORTATION (30,000.00) (1,510.74) (30,184.26) 0.00 184.26 100.61 29 12/11/2023 05:56 PM REVENUE AND EXPENDITURE REPORT FOR CLAY COUNTY UTILITIES Page: 2/2 User: jwesselman DB: Ccua PERIOD ENDING 09/30/2023 CONSTRUCTION DEPARTMENT BUDGET ACTIVITY FOR 2022-23 MONTH YTD BALANCE ENCUMBERED UNENCUMBERED o BDGT GL NUMBER DESCRIPTION AMENDED BUDGET 09/30/23 09/30/2023 YEAR-TO-DATE BALANCE USED MISCELLANEOUS 101.502.536.221 EMPLOYEE TRAINING & TRAVEL 484.00 0.00 999.00 0.00 (515.00) 206.40 Net MISCELLANEOUS (484.00) 0.00 (999.00) 0.00 515.00 206.40 DEPRECIATION 101.401.536.595 CONSTRUCTION R&R (DEPRECIATION 104,385.00 2,304.95 25,870.99 0.00 78,514.01 24.78 Net DEPRECIATION (104,385.00) (2,304.95) (25,870.99) 0.00 (78,514.01) 24.78 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 45,333.00 0.00 0.00 0.00 45,333.00 0.00 Net CONTINGENCY (45,333.00) 0.00 0.00 0.00 (45,333.00) 0.00 TOTAL REVENUES - ALL FUNDS 545,662.00 134,749.59 196,624.07 0.00 349,037.93 36.03 TOTAL EXPENDITURES - ALL FUNDS 545,662.15 9,512.89 196,624.07 2,941.56 346,096.52 36.57 NET OF REVENUES & EXPENDITURES (0.15) 125,236.70 0.00 (2,941.56) 2,941.41 1,961,04 30 CLAY COUNTY UTILITY AUTHORITY Covenant Regarding Rates & Additional Debt Using Twelve Months' Income Data at September 30, 2023 Net Revenues(Operating Income),excluding connection fees, must be greater than or equal to 105%of the annual debt service and 100%of the required renewal&replacement deposit for the year. 2022/2023 Annual Debt Service $11,839,976 105% $12,431,975 2022/2023 Renewal&Replacement Deposit $2,734,625 100% $2,734,625 Required Net Revenues $15,166,599 Twelve Months'Net Revenues $20,951,099 Less Bad Debt Expense $29,053 Twelve Months'Net Revenues(Operating Income less bad debt exp) $20,922,046 Annualized Net Revenues $20,922,046 Debt Coverage Ratio 143.55% NET REVENUES OVER BOND TEST AVAILABLE FOR BONDING $5,755,447 Additional Bonds That Can Be Issued for 30 Years @ 5% with an annual principal and interest payment of $5,755,447 $88,475,330 Estimated Estimated Net Revenues Additional Net Revenues Additional Report Period Annual Net Available For Bonding Report.Period Annual Net Available For Bonding Ending Oper.Revenues _Bonding Capacity _Ending Oper.Revenues Bonding Capacity Sep 1999 5,967,543 1,427,487 I 17,713,744 I Sep 2018 14,196,001 7,746,174 I 119,077,688 Sep 2000 7,092,674 2,386,330 29,612,064 Sep 2019 16,466,511 7,625,964 117,229,753 Sep 2001 5,858,183 1,022,833 12,692,374 Sep 2020 18,717,594 6,826,559 104,940,951 Sep 2002 6,660,167 1,641,164 20,365,266 Sep 2021 17,933,372 5,895,493 90,628,176 Sep 2003 7,017,284 1,798,307 22,315,264 Sep 2022 19,322,082 7,281,154 111,929,176 Sep 2004 7,702,775 2,813,160 34,908,621 Sep 2023 209,922,046 5,755,447 88,475,330 Sep 2005 7,584,548 2,292,712 28,450,357 Sep 2006 9,032,710 2,460,180 30,528,472 Sep 2007 11,972,947 5,671,548 70,378,479 Sep 2008 10,741,016 2,777,119 34,461,379 Sep 2009 11,514,174 2,978,859 36,964,783 Sep 2010 12,351,404 3,552,549 45,448,415 Sep 2011 17,319,520 8,352,997 103,652,686 Sep 2012 15,337,497 6,111,721 75,840,595 Sep 2013 14,636,513 5,780,413 71,729,383 Sep 2014 13,629,860 4,584,499 56,889,238 Sep 2015 15,544,720 9,744,827 120,923,963 Sep 2016 16,180,385 10,422,477 129,332,941 Sep 2017 15,110,670 8,471,395 105,121,884 31 2022-23 Bond Test Report.xlsx Deferred Connection Charges Report Board Summary As of September 30,2023 Subdivision Execution Date Deferred Charges Lots In Service Remaining Paid Pending Collection% In Process: A Linda Lakes Subdivision 02/19/2016 $303,170 122 119 3 $295,715 $7,455 97.54% Jennings Farms L 11/08/2022 $1,713,429 314 0 314 $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% Willow Springs 11/19/2019 $633,586 150 149 1 $628,348 $5,238 99.17% Goose Creek Estates 10/27/2020 $232,292 52 40 12 $169,435 $62,856 72.94% Jeremy's Hollow Subdivision-14 Lots 11/08/2022 $74,855 14 0 14 $74,855 0.00% Fleming Estates 05/11/2018 $174,682 40 38 2 $163,986 $10,696 93.88% Cross Creek Subdivision Phase I,Unit 1A 04/17/2018 $1,113,161 263 251 12 $1,050,305 $62,856 94.35% Village Park 03/12/2019 $665,705 156 149 7 $629,039 $36,666 94.49% Royal Pointe ' 04/10/2019 $272,946 58 50 8 $231,042 $41,904 84.65% 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 80 1 $338,630 $5,238 98.48% Anabelle Island Subdivision-Phases 1A,1B&21 09/07/2021 $1,801,875 344 0 344 $1,801,875 0.00% Cross Creek Subdivision Phase 2F-113 Lots 10/27/2021 $492,616 113 111 2 $481,939 $10,677 97.83% Granary Park Subdivision Phase II-279 Lots 03/14/2022 $1,460,584 279 29 250 $126,019 $1,334,565 8.63% Robinson Ranch Subdivision Phase 1-198 Lots 03/29/2022 $1,025,207 198 32 166 $139,055 $886,151 13.56% 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 $540,025 101 0 101 $540,025 0.00% 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-4V 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 pm $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% Wilford Preserve Phase 2 11/25/2019 $735,590 174 173 1 $730,352 $5,238 99.29% 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 47 71 $199,125 $371,899 34.87% Wilford Preserve Subdivision,Phase 3A&3B-138 Lot 07/21/2021 $722,845 138 0 138 $722,845 0.00% Double Branch Subdivision III 01/31/2022 $781,998 153 35 118 $152,083 $629,915 19.45% Cheswick South Subdivision-232 Lots 05/04/2022 $1,209,686 232 29 203 $126,019 $1,083,667 10.42% Wilford Preserve Phase 4 01/10/2023 $791,323 148 0 148 $791,323 0.00% In Process Totals $28,226,821 5,735 1,936 3,799 $8,012,569 $20,214,252 28.39% 32 Deferred Connection Charges Report Board Summary As of September 30,2023 Subdivision Execution Date Deferred Charges Lots In Service Remaining Paid Pending Collection% CorttpleteCM. IMIIMINI il 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 18 • 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% Pinewood Place Subdivision 12/08/2020 $355,607 82 82 0 $355,607 100.00% Cross Creek 28-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% Willow Springs Subdivision 2A,2B&3 01/21/2021 $968,572 229 229 0 $968,572 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 $423,407 100.00% Discovery Trails at Oakleaf-76 Townhomes 12/14/2021 $284,780 76 76 0 $306,809 107.74% Completed Totals $7,811,615 1,856 1,856 0 $7,833,644 100.28% Grand Totals $36,038,436 7,591 3,792 3,799 $15,846,212 $20,214,252 43.97% 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 649 14 $2,683,904 $73,552 97.33% FY 2019 $2,814,428 626 512 114 $2,217,295 $597,133 78.78% FY 2020 $4,279,102 1,008 988 20 $4,174,342 $104,760 97.55% FY 2021 $6,969,642 1,509 936 573 $3,968,262 $3,001,380 56.94% FY 2022 $7,509,564 1,520 538 982 $2,289,421 $5,242,171 30.49% FY 2023 $11,405,075 2,143 50 2,093 $217,274 $11,187,801 1.91% Grand Totals $36,038,436 7,591 3,792 3,799 $15,846,212 $20,214,252 43.97% 33 CLAY COUNTY UTILITY AUTHORITY - CONNECTION FEES $14,000,000 $11,894,297 $12,000,000 $11,163,332 $10,487,633 $10,000,000 $8,000,000 $7,610,757 $6,950,649 $6,648,170 $5,876,449 $6,000,000 $5,313,405 $3,171,113 $4,000,000 $2,575,988 $2,505,499 $5,313,405 $2,319,158 $2,000,000 $1,474,480 $1,476,202 $3,839,463 $4,283,540 $4,212,683 $1,700,309 $2,319,158 $2,575,988 $2,705,33. $1,474,480 $1,476,202 $805,190 $- 2014 2015 2016 2017 2018 2019 2020 2021 2022 2023 (ANNUALIZED) •Deferred Connections Fees •Non-Deferred Connections Fees 34 CLAY COUNTY UTILITY AUTHORITY KEY PERFORMANCE INDICATORS - PERIOD ENDING 09/30/2023 Ratio Calculation vs.Target Target Days of Cash on Hand Undesignated Cash 54,335,653 /Operating Expense per day / 111,195 Days of Cash on Hand = 489 455 In Years 1.34 Debt Ratio Total Liabilities 179,655,720 /Total Assets / 548,879,246 Debt Ratio(%) = 33% 40% Debt-Service Coverage Ratio Revenue,Annualized 59,919,534 -O&M Costs,Annualized - 40,030,173 /Total Debt Service / 9,925,701 Debt-Service Coverage Ratio 2.00 0 2.21 Operating Ratio Total O&M Costs 40,030,173 /Total Operating Revenue / 59,919,534 Operating Ratio 67% 72% Employee Turnover YTD#of Employee Departures 24 Rolling 12-month turnover 24 /Total#of FTE's / 188 Rolling 12-month Employee Turnover 12.8% ® 10.6% Current Ratio Current Assets 129,233,244 /Current Liabilities / 27,431,262 Current Ratio 4.71 0 2.00 Return on Assets Net Income 19,889,361 Net Income,Annualized 19,889,361 /Total Assets,Annualized 548,879,246 Return on Assets 3.6% 0 2.2% 35 CLAY COUNTY UTILITY AUTHORITY DAYS OF CASH ON HAND 1,000 900 896 800 772 700 666 600 568 572 567 560 No...582W 500 _ 1 53 527463--489 400 322 300 200 — J� 100 ■■■ SEP-20ISEP-21ISEP-22 CT-22I NOV-Z IDEC-22IJAN-23IFEB-23I MAR-IAPR-23I MAY-IJUN-23IJUL-23I AUG-23 ISEP-23 2PRIOR YEAR ENDS CURRENT YEAR Days of Cash of Hand Target 1 DEBT RATIO 50% 43% 45%40% 40% 35% 33% 33% 33% 33% 30% 30% — 27% 25% 5% 24% 23% 23% 23% 23% 22% 22% 21% 20% 15% 10% 50/% I I SEP-20ISEP-21ISEP-22 OCT-221'VOV-221DEC-22IJAN-23IFEB-23I MAR-IAPR-23I MA3 I IY- IJUN-23IJUL-23�AUG-231SEP-23 PRIOR YEAR ENDS I CURRENT YEAR -Debt Ratio(%) Target DEBT SERVICE COVERAGE 2.50 2.21 2.00 2.00 1.95 1.87 2.03 1.90 1.97 1.90 1.87 .00 1.67 69 1.76 1.72 1.72 1.77 1.85 1.50 1.00 0.50 0.00 SEP-20 SEP-21 SEP-22 OCT-221\10V-2 DEC-22 AN-23 IFEB-23I MAR- APR-23I MAY- 1JUN-231JUL-23 bUG21SEP23 23 23 PRIOR YEAR ENDS CURRENT YEAR tDebt-Service Coverage Ratio —Target 36 CLAY COUNTY UTILITY AUTHORITY OPERATING RATIO 76% 74% 74% 72% 72% 72% 71%�71% 71% 71% 70% 69% 68% 68% 68% 68% 68% -w 67% 0 65% 65% 64% 64% 62% 60% 58% SEP-20ISEP-21ISEP-22 OCT-22OV-2 DEC-22IJAN-23IFEB-23I MAR- APR-23I MAY- IJUN-231JUL-2314UG-21SEP-23 hi. 23 23 PRIOR YEAR ENDS CURRENT YEAR tOperating Ratio(%) -Target CURRENT RATIO 7.00 6.00 5.39 5.54 .73 .40 5.00 - 4.71 - 4.38ak 4.00 3.56_3.75 3.81 4.07 4.09 3.72 4.05...1111 '54 3.00 3.40= 2.00 2.00 - 1.00 0.00 SEP-20 SEP-21 SEP-22 OCT-22 OV-2 A DEC-22 JAN-23 FEB-23 MAR- APR-23 MAY- JUN-23 JUL-23 ,UG-2 SEP-23 23 23 PRIOR YEAR ENDS CURRENT YEAR Current Ratio Target RETURN ON ASSETS 4.5% 4.3% 4.5% 5.0% 4.5% 3.9% 3.7% 3.9% 3.8% 3.7% .3.9% 4.0% 3.9% 3.6% 4.0% 3.2% 3.4% 3.4% 3.5% 3.0% 2.5% 2.2% 2.0% 1.5% 1.0% 0.5% 0.0% SEP-20 SEP-21 SEP-22 OCT-22 NOV- DEC-22 JAN-23 FEB-23 MAR- APR-23 MAY- JUN-23 JUL-23 'UG-2 SEP-23 22 23 23 PRIOR YEAR ENDS 11 CURRENT YEAR Return on Assets(%) -Target 37