Loading...
HomeMy WebLinkAboutEDB 2022-09 Board Financial Package Clay County Utility Authority Working together to 3176 Old Jennings Road protect public health, Middleburg,FL 32068-3907 conserve our natural GJI Telephone(904)272-5999 resources,and create ♦ long-term value for Ili'AUTNOQ' www.clayutility.org our ratepayers. November 28, 2022 To: Board of Supervisors From: Jeffrey Wesselman Re: September 2022 Financial Package I have enclosed the following financial information: A) Comparative Financial Statements for the twelve months of fiscal years 2021/2022 and 2020/2021. Comparative Balance Sheet 03 = Revenue & Expenditure Report Cash-flow Statement ea o B) Cash &Cash Equivalents Report at September 30, 2022 L C) Budget Reports for the twelve months of Fiscal Year 2021/2022 3 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, 2022 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 Bond Test Report Construction Department Budget Deferred Connection Report Key Performance Indicators Operating income is$3,242,227 (21%) over budget due to a unfavorable revenue and favorable expense variance. Operating revenue is$14,890 (0.0%) under budget and Operating expenses are$3,257,117 (8%) under budget. Itemized operating expense variances are in Section C. We gained 1,229 active (Residential 1,189, General Service, 40)water accounts and 1,249 active sewer (Residential 1,215, General Service, 34) accounts for the fiscal year 2021/2022 as compared to an increase of 1,215 active water accounts and an increase of 1,190 active sewer accounts for the same time in fiscal year 2020/2021. 1 CLAY COUNTY UTILITY AUTHORITY COMPARATIVE FINANCIAL STATEMENTS t° FISCAL YEAR 2021 /2022 Section A 11/30/2022 08:31 AM COMPARATIVE BALANCE SHEET FOR CLAY COUNTY UTILITIES Page: 1/1 User: kosborne DB: CCUA Fund 101 GENERAL FUND PERIOD ENDED PERIOD ENDED GL Number Description 09/30/2021 09/30/2022 *** Assets *** Cash 41,874,592.55 29,907,741.39 Investments 52,053,609.04 52,627,982.40 Accounts Receivable 3,525,880.15 4,897,661.82 Fixed Assets 471,662,944.43 524,340,267.25 Accum. Depreciation (171,907,306.15) (184,691,210.99) Other Assets 974,532.54 1,095,907.13 Deferred Outflows 1,938,184.25 1,708,823.20 Total Assets 400,122,436.81 429,887,172.20 *** Liabilities *** Liabilities-ST 15,543,488.92 21,104,095.26 Liabilities-LT (over 1 year) 91,472,621.00 84,379,852.99 Total Liabilities 107,016,109.92 105,483,948.25 *** Fund Balance *** Unassigned 50,926,382.11 53,823,792.64 Investment In Capital Assets 239,282,534.25 266,607,739.72 Total Fund Balance 290,208,916.36 320,431,532.36 Beginning Fund Balance 270,357,546.96 293,106,326.89 Net of Revenues VS Expenditures 2,897,410.53 3,971,691.59 Fund Balance Adjustments 19,851,369.40 27,325,205.47 Ending Fund Balance 293,106,326.89 324,403,223.95 Total Liabilities And Fund Balance 400,122,436.81 429,887,172.20 Lo 11/30/2022 08:32 AM COMPARATIVE BALANCE SHEET FOR CLAY COUNTY UTILITIES Page: 1/3 User: kosborne DB: CCUA Fund 101 GENERAL FUND PERIOD ENDED PERIOD ENDED GL Number Description 09/30/2021 09/30/2022 *** Assets *** Cash 101.401.101.110 Cash-BB&T L.A.H.H. Account 2,752.83 400.92 101.401.101.125 '12 BBVA Compass Debt Service 1,151,165.91 1,302,399.40 101.401.101.160 Cash-BB&T Operating Account 13,670,944.62 3,572,630.03 101.401.101.161 Cash-BB&T Emergency Account 29,697.36 21,946.19 101.401.101.200 CASH-FSA 44,924.35 11,436.71 101.401.101.329 Debt Stabilization Reserve Unrestricted 902,055.62 1,308,417.77 101.401.101.331 2015/2019 Bond Sinking Fund 4,075,832.80 3,962,908.14 101.401.101.333 SBA - 2001 DEP Loan Debt Service Acct 52,136.10 52,132.62 101.401.101.335 CUSTOMER DEPOSIT FUND 3,466,895.76 3,594,107.18 101.401.101.336 SURPLUS FUND 4,813,165.99 4,251,312.38 101.401.101.337 SELF INSURANCE FUND 525,000.00 525,000.00 101.401.101.338 RENEWAL & REPLACEMENT FUND 3,761,607.18 1,343,254.99 101.401.101.340 WATER PLANT FUND (76%) 131,114.38 407,539.06 101.401.101.342 WATER LINE FUND (24%) 134,342.21 262,993.60 101.401.101.343 AWS Cash 2,237,105.59 3,517,876.71 101.401.101.344 SEWER PLANT FUND (53.33%) 5,941,839.62 5,267,865.81 101.401.101.346 SEWER LINE FUND (46.67%) 757,170.89 328,847.53 101.401.101.351 2018 Bond Sinking Fund 175,674.04 175,670.60 101.401.102.100 PETTY CASH FUND 1,167.30 1,001.75 Cash 41,874,592.55 29,907,741.39 Investments 101.401.101.323 Short Term Investments - Surplus 52,053,609.04 52,627,982.40 Investments 52,053,609.04 52,627,982.40 Accounts Receivable 101.401.115.100 ACCOUNTS RECEIVABLE W&S CUST 1,651,557.10 2,146,262.84 101.401.115.110 A/R CIAC & MISC REPAIR INVS. 352,471.79 1,008,714.36 101.401.115.120 Loans To Customers 42,710.85 38,983.11 101.401.115.121 Loan to Customers Long-term 330,339.77 301,709.88 101.401.115.200 A/R UNBILLED WATER REVENUE 494,765.28 619,856.74 101.401.115.250 A/R Unbilled Reuse Revenue 110,532.12 110,653.16 101.401.115.300 A/R UNBILLED SEWER REVENUE 720,817.74 869,171.21 101.401.115.400 A/R CLEARING ACCOUNT (985.57) 21,286.44 101.401.117.100 ALLOWANCE FOR DOUBTFULL A/R (176,328.93) (218,975.92) Accounts Receivable 3,525,880.15 4,897,661.82 Fixed Assets 101.401.161.900 LAND 5,268,724.07 5,482,317.47 101.401.162.900 BUILDINGS 8,797,355.84 9,706,793.42 101.401.166.900 MACHINERY & EQUIPMENT 440,618,388.66 461,538,814.74 101.401.168.900 Intangible Assets 0.00 3,652,438.00 101.401.169.900 CONSTRUCTION IN PROGRESS 16,978,475.86 43,959,903.62 Fixed Assets 471,662,944.43 524,340,267.25 Accum. Depreciation 101.401.163.900 ACCUM.DEPRECIATION BUILDINGS (8,322,535.55) (9,006,781.88) 101.401.167.900 ACCUM.DEPR. MACHINERY & EQUIPT (163,584,770.60) (175,684,429.11) Accum. Depreciation (171,907,306.15) (184,691,210.99) Other Assets 101.401.115.150 INTEREST RECEIVABLE 96,448.23 160,577.29 101.401.115.500 PREPAID INSURANCE 12,561.06 11,311.30 101.401.115.550 PREPAID W/C INSURANCE (8,043.39) (31,113.98) 101.401.115.575 PREPAID DEP REGULATORY FEES 22,137.47 22,587.49 101.401.115.600 PREPAID MAINTENANCE & EXPENSES 514,111.57 383,619.22 101.401.141.000 INVENTORY 316,074.62 526,361.19 101.401.141.100 UNUSED POSTAGE 21,242.98 22,564.62 Other Assets 974,532.54 1,095,907.13 Deferred Outflows 101.401.158.201 Deferred Outflow of Resources 1,938,184.25 1,708,823.20 Deferred Outflows 1,938,184.25 1,708,823420 11/30/2022 08:32 AM COMPARATIVE BALANCE SHEET FOR CLAY COUNTY UTILITIES Page: 2/3 User: kosborne DB: CCUA Fund 101 GENERAL FUND PERIOD ENDED PERIOD ENDED GL Number Description 09/30/2021 09/30/2022 *** Assets *** Total Assets 400,122,436.81 429,887,172.20 *** Liabilities *** Liabilities-ST 101.401.202.000 ACCOUNTS PAYABLE 2,095,947.44 6,430,581.91 101.401.202.002 Retainage Payable 181,396.71 907,020.23 101.401.215.100 ACCRUED INTEREST 896,510.32 819,798.04 101.401.216.100 ACCRUED WAGES PAYABLE 126,990.51 336,654.64 101.401.216.200 ACCRUED SICK, VACATION PAYABLE 699,543.84 779,987.53 101.401.217.100 EMPLOYEE FIT,FICA,MEDICARE W/H 63,229.88 85,423.13 101.401.217.300 Employee Fund Withheld 1,644.33 2,140.78 101.401.217.500 ACCRUED PENSION DUE 82,653.44 111,664.22 101.401.217.600 ACCRUED W/C INS. DUE 20,415.40 27,581.06 101.401.218.100 MISC W/H (131.38) (126.77) 101.401.218.250 LIFE INSURANCE (493.29) (528.62) 101.401.218.703 HMO/PPO 1,757.28 (3,062.07) 101.401.218.705 DENTAL 25.32 520.10 101.401.218.706 VISION (87.43) (215.70) 101.401.218.707 ANCILLARY (858.98) (232.08) 101.401.218.900 ACCRUED ELECTRIC EXPENSE DUE 97,007.93 131,366.93 101.401.220.100 BOND DEPOSITS 85,427.98 105,336.00 101.401.220.150 CLEANING WATER DEPOSITS 114,385.88 127,458.95 101.401.220.175 W&S CUSTOMER DEPOSITS 3,478,081.47 3,627,824.56 101.401.220.180 DUE TO LEND A HELPING HAND 2,733.48 400.92 101.401.220.185 Refundable Development Agreements 8,363.28 18,735.89 101.401.223.100 DEFERRED REVENUES WATER 160,698.72 144,888.04 101.401.223.200 DEFERRED REVENUE SEWER 332,177.41 300,559.61 101.401.223.300 Deferred Reuse Revenue 60,509.13 57,248.16 101.401.229.200 JAX PUBLIC SERV.TAX COLLECTED 426.67 314.30 101.401.229.201 Keystone Public Service Tax 4.38 (12.51) 101.401.232.700 CURRENT BOND PRINCIPAL DUE 7,035,129.20 7,092,768.01 Liabilities-ST 15,543,488.92 21,104,095.26 Liabilities-LT (over 1 year) 101.401.232.569 2012 BBVA Compass Loan 4,510,637.00 3,293,841.00 101.401.232.571 SunTrust 2015 Adv Ref 2007 Bonds 36,895,642.00 34,964,955.00 101.401.232.572 2018 Revenue Bonds Payable DEP MIDCLAY 11,704,626.36 11,086,278.04 101.401.232.573 Dell Financing Lease 542,513.39 275,999.81 101.401.232.574 Suntrust 2019 Loan & Refinance 44,035,000.00 41,130,000.00 101.401.232.586 2014 DEP Payable 819,331.45 721,547.15 101.401.232.600 CONTRA CURRENT BOND PRINCIPAL (7,035,129.20) (7,092,768.01) Liabilities-LT (over 1 year) 91,472,621.00 84,379,852.99 Total Liabilities 107,016,109.92 105,483,948.25 *** Fund Balance *** Unassigned 101.401.272.000 RETAINED EARNINGS-UNRESERVED 50,926,382.11 53,823,792.64 Unassigned 50,926,382.11 53,823,792.64 Investment In Capital Assets 101.401.240.000 AWS CIAC 5,389,271.45 7,130,813.49 101.401.240.100 SJRWMD Black Creek CIAC 0.00 707,501.13 101.401.254.350 WATER CAPACITY CHARGES 10,148,402.33 11,224,067.36 101.401.254.351 FIRE CAPACITY CHARGES 1,903,723.50 2,035,389.18 101.401.254.352 WATER TAP IN CHARGE 2,226,386.48 2,340,817.16 101.401.254.353 WATER CONTRIBUTED ASSETS 48,671,992.34 52,464,976.63 101.401.254.354 WATER MAIN EXTENSION CHARGE 2,781,061.91 3,109,856.87 101.401.254.355 DEBT SERVICE CHARGE 895,986.87 1,305,259.70 101.401.254.360 SEWER CAPACITY CHARGES 42,567,255.88 49,245,421.62 5 11/30/2022 08:32 AM COMPARATIVE BALANCE SHEET FOR CLAY COUNTY UTILITIES Page: 3/3 User: kosborne DB: CCUA Fund 101 GENERAL FUND PERIOD ENDED PERIOD ENDED GL Number Description 09/30/2021 09/30/2022 *** Fund Balance *** 101.401.254.361 GRANTS 23,110,851.53 25,966,282.30 101.401.254.362 SEWER TAP IN CHARGE 2,414,030.19 2,503,301.88 101.401.254.363 SEWER CONTRIBUTED ASSETS 95,026,058.13 103,808,551.24 101.401.254.364 SEWER MAIN EXTENSION CHARGE 4,147,513.64 4,765,501.16 Investment In Capital Assets 239,282,534.25 266,607,739.72 Total Fund Balance 290,208,916.36 320,431,532.36 Beginning Fund Balance 270,357,546.96 293,106,326.89 Net of Revenues VS Expenditures 2,897,410.53 3,971,691.59 Fund Balance Adjustments 19,851,369.40 27,325,205.47 Ending Fund Balance 293,106,326.89 324,403,223.95 Total Liabilities And Fund Balance 400,122,436.81 429,887,172.20 11/28/2022 09:22 AM REVENUE AND EXPENDITURE REPORT FOR CLAY COUNTY UTILITIES Page: 1/1 User: kosborne DB: CCUA PERIOD ENDING 09/30/2022 YTD BALANCE YTD BALANCE GL NUMBER DESCRIPTION 09/30/2021 09/30/2022 Fund 101 - GENERAL FUND WATER REVENUES 20,117,492.71 22,930,684.99 SEWER REVENUES 27,663,387.70 29,199,221.73 MISCELLANEOUS REVENUES 1,658,717.60 1,887,946.18 INTEREST UNRESTRICTED 601,009.23 674,636.68 INTEREST RESTRICTED 125,171.25 52.99 SALE OF ASSETS 120,287.30 112,277.73 CONSTRUCTION INCOME 278,762.65 235,976.94 TOTAL REVENUES 50,564,828.44 55,040,797.24 BAD DEBT (9,554.72) 25,704.96 COMMUNICATION 366,592.73 391,120.78 DUE IN LIEU OF TAXES 2,150,139.62 2,345,845.80 ELECTRIC & FUEL EXPENSES 2,363,472.68 2,852,121.45 MISCELLANEOUS EXPENSES 120,262.14 153,463.54 PROPERTY & LIABILITY INSURANCE 793,773.26 873,930.90 PROFESSIONAL SERVICES 792,641.18 1,347,305.90 SLUDGE TREATMENT & DISPOSAL 2,137,067.89 2,287,832.59 SUBCONTRACTORS 2,692,345.88 2,570,900.08 SUPPLIES 4,645,930.83 4,935,080.53 TRANSPORTATION 612,962.70 711,800.28 WAGES & RELATED EXPENSES 15,564,608.87 16,875,353.72 DEPRECIATION 12,674,299.53 13,176,982.86 INTEREST EXPENSE 2,484,112.67 2,285,685.32 CONSTRUCTION EXPENSE 278,762.65 235,976.94 TOTAL EXPENDITURES 47,667,417.91 51,069,105.65 Fund 101 - GENERAL FUND: TOTAL REVENUES 50,564,828.44 55,040,797.24 TOTAL EXPENDITURES 47,667,417.91 51,069,105.65 NET OF REVENUES & EXPENDITURES 2,897,410.53 3,971,691.59 TOTAL REVENUES - ALL FUNDS 50,564,828.44 55,040,797.24 TOTAL EXPENDITURES - ALL FUNDS 47,667,417.91 51,069,105.65 NET OF REVENUES & EXPENDITURES 2,897,410.53 3,971,691.59 7 CLAY COUNTY UTILITY AUTHORITY STATEMENTS OF CASH FLOWS FOR THE TWELVE MONTHS ENDED SEPTEMBER 30,2021 AND 2022 September 30,2021 September 30,2022 Cash flows from operating activities $ 16,452,104 $ 22,774,886 Net cash provided by operating activities 16,452,104 22,774,886 Cash flows from capital and related financing activities Proceeds from issuance of bonds and loans - - Principal paid on long-term debt (6,919,567) (7,035,129) Interest paid on long-term debt (2,314,749) (2,133,037) Payments to acquire and construct plant property (12,432,565) (40,423,616) Capital contributions 10,487,634 11,894,297 Grants 1,355,529 2,855,431 Net cash used in capital and related financing activities (9,823,719) (34,842,053) Cash flows from investing activities Purchases of investments (11,988,100) (574,373) Sales of investments 6,151,250 - Interest income 726,180 674,690 Net cash provided by investing activities (5,110,670) 100,316 Net increase(decrease)in cash and cash equivalents 1,517,715 (11,966,851) Cash and cash equivalents,beginning of period 40,356,878 41,874,593 Cash and cash equivalents,end of period $ 41,874,593 $ 29,907,741 Reconciliation of operating income to net cash provided by operating activities Cash flows from operating activities Operating income $ 4,535,055 $ 5,470,410 Adjustments to reconcile operating income to net t0 cash provided by operating activities: Depreciation expense 12,743,603 13,217,953 Changes in assets and liabilities Decrease(Increase)in accounts receivable (785,685) (1,371,782) Decrease(Increase)in prepaid items and inventory 43,573 (57,246) Decrease(Increase)in notes/interest receivable 150,166 (64,129) Increase(Decrease)in accounts payable (462,086) 5,102,528 Increase(Decrease)in accrued expenses (10,906) 345,117 Increase(Decrease)in unearned revenue 122,766 (50,689) Increase(Decrease)in customer deposits 115,619 182,724 Total adjustments 11,917,049 17,304,476 Net cash provided by operating activities $ 16,452,104 $ 22,774,886 Supplemental schedule of noncash investing,capital,and financing activities Utility plant property contributed by developers $ 8,008,207 $ 12,575,477 8 Cumulative Cash Flow $100,000,000 $90,000,000 $80,000,000 $70,000,000 — $60,000,000 I I $50,000,000 I I $40,000,000 $30,000,000 tO $20,000,000 — $10,000,000 $o " — 'L° 'L° 'L° o titi 'I> 1> '> titi titi '1> Otiti titi 1> o`> '1> 'L' ti ',' ',' ',' titi 'L1' titi titi e , � `' J > 0 Q e � c t % Qp Cf' afie4` P- �aJ P� cieO O' >a < ' 4\ 4<6J P� c,e V Cash A Investments CLAY COUNTY UTILITY AUTHORITY CASH AND CASH EQUIVALENTS REPORT As of September 30, 2022 BB&T Ameris SBA Investments Total Lend A Helping Hand Fund $401 $401 Operating Accounts ** $3,572,630 $3,572,630 FSA Account $11,437 $11,437 Emergency Accounts $21,946 $21,946 Petty Cash $1,002 $1,002 Total Operating Funds $3,607,015 $3,607,015 Public Funds Now: Water Plant Connection Fund $407,539 * $407,539 R Water Line Connection Fund $262,994 * $262,994 R Sewer Plant Connection Fund $5,267,866 * $5,267,866 R Sewer Lines Connection Fund $328,848 * $328,848 R Alternative Water Supply Fund $3,517,877 * $3,517,877 R Renewal&Replacement Fund $1,343,255 * $1,343,255 R Debt Stabilization and Reserve Account_Unrestricted $1,308,418 * - - $1,308,418 Surplus Fund $3,170,903 $872,203 $105,851 $52,627,982 $56,776,940 Available For Construction $15,607,699 $872,203 $105,851 $52,627,982 $69,213,735 Debt Service Sinking Funds: 2007A Bond Sinking Fund $3,962,908 * $3,962,908 R DEP Loan Debt Service Sinking Acct $52,133 * $52,133 R BBVA Compass Loan Sinking Funds $1,302,399 * $1,302,399 R 2018 Bond Sinking Fund $175,671 * $175,671 R Debt Stabilization and Reserve Account_Restricted Letter of Credit_Financial Responsible Officer $102,355 $102,355 Customer Deposits&Self Insurance Fund Customer Deposits - * $3,594,107 $3,594,107 Self Insurance Fund_Sewage Backups * Health Insurance - * $500,000 $500,000 Unemployment * $25,000 $25,000 TOTAL Funds $5,595,466 $4,119,107 - - $9,714,573 TOTAL CASH&CASH EQUIVALENTS $24,810,580 $4,991,310 $105,851 $52,627,982 $82,535,724 Investment Accounts Maturity Date Balance APY US Bank Various $52,627,982 1.76% $52,627,982 * BB&T Public Funds Money Checking Accounts $17,929,906 0.25% BB&T Public Funds Money Checking Accounts_Earnings Credit waives bank fees $3,572,630 0.25% Ameris Public Funds Money Checking Accounts $4,991,310 0.30% SBA $105,851 2.61% •w Operating Account has significant Surplus Funds due to Earnings Credit offsetting fees greater than interest Construction Balance $69,213,735 Operating Cash $1,572,630 Available Construction Balance: $70,786,365 "R"indicates fund is Restricted by Bond Resolution,Enabling Legislation or Board Resolution. Printed 11/28/2022 Section B CLAY COUNTY UTILITY AUTHORITY BUDGET REPORTS FISCAL YEAR 2021 /2022 to Section C 11/07/2022 REVENUE AND EXPENDITURE REPORT FOR CLAY COUNTY UTILITIES PERIOD ENDING 09/30/2022 OPERATING BUDGET REPORT 2021-22 YTD BALANCE AVAILABLE %BDGT GL NUMBER DESCRIPTION AMENDED BUDGET 09/30/2022 BALANCE USED OPERATING REVENUES Water Revenues Net Water Base Charges 7,870,135.00 7,804,197.73 65,937.27 99.16% Net Water Use Charges 9,778,356.00 9,962,596.16 (184,240.16) 101.88% Net Reuse Water Base Charges 2,743,539.00 3,003,533.40 (259,994.40) 109.48% Net Reuse Water Usage Charges 2,135,303.00 2,160,357.70 (25,054.70) 101.17% Net Water Revenues 22,527,333.00 22,930,684.99 (403,351.99) 101.79% Sewage Revenues Net Sewer Base Charges 15,923,690.00 16,055,826.06 (132,136.06) 100.83% Net Sewer Use Charges 13,994,637.00 13,143,395.67 851,241.33 93.92% Net Sewage Revenues 29,918,327.00 29,199,221.73 719,105.27 97.60% Other Revenues Net Miscellaneous 1,587,083.00 1,887,946.18 (300,863.18) 118.96% Net Other Revenues 1,587,083.00 1,887,946.18 (300,863.18) 118.96% Net OPERATING REVENUES 54,032,743.00 54,017,852.90 14,890.10 99.97% INTEREST INCOME Net Unrestricted 784,689.00 674,636.68 110,052.32 85.98% Net Restricted 2,666.00 52.99 2,613.01 1.99% Net INTEREST INCOME 787,355.00 674,689.67 112,665.33 85.69% OPERATING EXPENSES Net Bad Debt Expenses 5,000.00 25,704.96 (20,704.96) 514.10% Net Wage Related Expenses 4,760,166.66 4,826,765.05 (66,598.39) 101.40% Net Communication Expenses 485,154.00 391,120.78 94,033.22 80.62% Net Due in Lieu of Taxes 2,360,055.00 2,345,845.80 14,209.20 99.40% Net Electric&Fuel Expenses 2,482,468.00 2,852,121.45 (369,653.45) 114.89% Net Miscellaneous Expenses 439,234.00 153,463.54 285,770.46 34.94% Net Property&Liability Insurance 859,395.00 873,930.90 (14,535.90) 101.69% Net Professional Services 2,287,389.43 1,530,106.35 757,283.08 66.89% Net Sludge Treatment&Disposal 1,924,160.00 2,287,832.59 (363,672.59) 118.90% Net Subcontractors 3,683,466.00 2,518,705.84 1,164,760.16 68.38% Net Supplies 5,702,144.00 4,935,080.53 767,063.47 86.55% Net Transportation Expenses 502,451.00 711,800.28 (209,349.28) 141.67% Net Wage Expense 12,000,173.97 11,917,982.46 82,191.51 99.32% Net OPERATING EXPENSES 37,491,257.06 35,370,460.53 2,120,796.53 94.34% NON-OPERATING EXPENSES Net Depreciation Expense 12,504,881.00 13,176,982.86 (672,101.86) 105.37% Net Interest Expense 2,074,592.00 2,285,685.32 (211,093.32) 110.18% Net Loss(Gain)on Sale of Assets 0.00 (112,277.73) 112,277.73 100.00% Net NON-OPERATING EXPENSES 14,579,473.00 15,350,390.45 (770,917.45) 105.29% Net CONSTRUCTION EXPENSES 624,519.85 235,976.94 388,542.91 37.79% Net CONSTRUCTION INCOME 624,519.00 235,976.94 388,542.06 37.79% Net CONTINGENCY 1,136,320.00 0.00 1,136,320.00 0.00% TOTAL REVENUES-ALL FUNDS 55,444,617.00 54,928,519.51 516,097.49 99.07% TOTAL EXPENDITURES-ALL FUNDS 53,831,569.91 50,956,827.92 2,874,741.99 94.66% NET OF REVENUES&EXPENDITURES 1,613,047.09 3,971,691.59 (2,358,644.50) 246.22% 12 11/28/2022 09:23 AM EXPENDITURE REPORT FOR CLAY COUNTY UTILITIES Page: 1/1 User: kosborne DB: CCUA PERIOD ENDING 09/30/2022 OPERATING EXPENSE BUDGET REPORT 2021-22 YTD BALANCE AVAILABLE % BDGT GL NUMBER DESCRIPTION AMENDED BUDGET 09/30/2022 BALANCE USED Net WAGES & TEMP. LABOR 12,402,362.97 12,103,052.91 299,310.06 97.59 Net CAPITALIZED WAGES 241,797.65 32,485.54 209,312.11 13.44 Net HEALTH & LIFE INSURANCE 2,473,615.98 2,418,912.52 54,703.46 97.79 Net PENSION & BENEFITS 1,269,561.37 1,382,884.16 (113,322.79) 108.93 Net PAYROLL TAXES 897,582.26 888,224.37 9,357.89 98.96 Net W/C INSURANCE 235,749.25 159,003.50 76,745.75 67.45 Net PROPERTY & LIABILITY INSURANCE 914,250.00 930,013.33 (15,763.33) 101.72 Net TRANSPORTATION 527,951.00 745,150.72 (217,199.72) 141.14 Net RENTAL EXPENSE 43,194.00 32,078.97 11,115.03 74.27 Net COMMUNICATION EXPENSES 485,154.00 391,120.78 94,033.22 80.62 Net ELECTRIC & FUEL WATER PLANTS 734,000.00 803,838.56 (69,838.56) 109.51 Net ELECTRIC & FUEL LIFT STATIONS 400,000.00 459,050.83 (59,050.83) 114.76 Net ELECTRIC & FUEL SEWAGE PLANTS 1,310,865.00 1,543,422.75 (232,557.75) 117.74 Net ELECTRIC AT OFFICE 37,603.00 45,809.31 (8,206.31) 121.82 Net CHEMICALS FOR WATER 185,000.00 194,343.59 (9,343.59) 105.05 Net CHEMICALS FOR SEWAGE 821,203.00 847,750.28 (26,547.28) 103.23 Net SUPPLIES FOR WATER 1,775,024.00 1,245,434.53 529,589.47 70.16 Net SUPPLIES FOR SEWAGE 1,258,076.00 1,187,122.48 70,953.52 94.36 Net OFFICE SUPPLIES 1,668,741.00 1,487,929.69 180,811.31 89.16 Net ENGINEERING EXPENSES 1,317,690.43 929,050.29 388,640.14 70.51 Net LEGAL EXPENSES 545,535.00 399,883.06 145,651.94 73.30 Net AUDIT EXPENSES 33,500.00 23,500.00 10,000.00 70.15 Net SUBCONTRACTORS-WATER 1,295,475.00 858,875.41 436,599.59 66.30 Net SUBCONTRACTORS-SEWAGE 717,863.00 748,792.55 (30,929.55) 104.31 Net SUBCONTRACTORS-GENERAL 1,680,028.00 926,969.44 753,058.56 55.18 Net SLUDGE TREATMENT & DISPOSAL 1,924,160.00 2,287,832.59 (363,672.59) 118.90 Net BAD DEBT EXPENSE 5,000.00 25,704.96 (20,704.96) 514.10 Net MISCELLANEOUS 396,040.00 121,384.57 274,655.43 30.65 Net DUE IN LIEU OF TAXES 2,360,055.00 2,345,845.80 14,209.20 99.40 Net CONTINGENCY 1,190,635.00 0.00 1,190,635.00 0.00 TOTAL EXPENDITURES - ALL FUNDS 39,147,711.91 35,565,467.49 3,582,244.42 90.85 13 CLAY COUNTY UTILITY AUTHORITY CIAC REPORTS t° FISCAL YEAR 2021 /2022 Section D 11/30/2022 08:47 AM TRIAL BALANCE REPORT FOR CLAY COUNTY UTILITIES Page: 1/2 User: kosborne DB: CCUA PERIOD ENDING 09/30/2022 ACTIVITY FOR 2021-22 BEG. BALANCE MONTH YEAR-TO-DATE END BALANCE GL NUMBER DESCRIPTION AMENDED BUDGET 10/01/2021 09/30/2022 THRU 09/30/22 09/30/2022 Fund 101 - GENERAL FUND Fund Equity WATER CAPACITY 101.401.254.350 WATER CAPACITY CHARGES 10,148,402.33 32,760.00 1,075,665.03 11,224,067.36 WATER CAPACITY 10,148,402.33 32,760.00 1,075,665.03 11,224,067.36 SEWER CAPACITY 101.401.254.360 SEWER CAPACITY CHARGES 42,567,255.88 236,610.00 6,678,165.74 49,245,421.62 101.401.254.361 GRANTS 23,110,851.53 783,336.96 2,855,430.77 25,966,282.30 SEWER CAPACITY 65,678,107.41 1,019,946.96 9,533,596.51 75,211,703.92 AWS 101.401.240.000 AWS CIAO 5,389,271.45 90,041.70 1,741,542.04 7,130,813.49 AWS 5,389,271.45 90,041.70 1,741,542.04 7,130,813.49 SJRWMD BLACK CREEK 101.401.240.100 SJRWMD Black Creek CIAC 0.00 57,214.18 707,501.13 707,501.13 SJRWMD BLACK CREEK 0.00 57,214.18 707,501.13 707,501.13 WATER MAIN 101.401.254.354 WATER MAIN EXTENSION CHARGE 2,781,061.91 3,506.72 328,794.96 3,109,856.87 WATER MAIN 2,781,061.91 3,506.72 328,794.96 3,109,856.87 SEWER MAIN 101.401.254.364 SEWER MAIN EXTENSION CHARGE 4,147,513.64 6,963.57 617,987.52 4,765,501.16 SEWER MAIN 4,147,513.64 6,963.57 617,987.52 4,765,501.16 FIRE 101.401.254.351 FIRE CAPACITY CHARGES 1,903,723.50 17,596.53 131,665.68 2,035,389.18 FIRE 1,903,723.50 17,596.53 131,665.68 2,035,389.18 WATER TAP IN 101.401.254.352 WATER TAP IN CHARGE 2,226,386.48 18,626.03 114,430.68 2,340,817.16 WATER TAP IN 2,226,386.48 18,626.03 114,430.68 2,340,817.16 SEWER TAP IN 101.401.254.362 SEWER TAP IN CHARGE 2,414,030.19 102.35 89,271.69 2,503,301.88 SEWER TAP IN 2,414,030.19 102.35 89,271.69 2,503,301.88 WATER CONT PROP 101.401.254.353 WATER CONTRIBUTED ASSETS 48,671,992.34 (97,006.44) 3,792,984.29 52,464,976.63 WATER CONT PROP 48,671,992.34 (97,006.44) 3,792,984.29 52,464,976.63 SEWER CONT PROP 101.401.254.363 SEWER CONTRIBUTED ASSETS 95,026,058.13 (189,125.37) 8,782,493.11 103,808,551.24 SEWER CONT PROP 95,026,058.13 (189,125.37) 8,782,493.11 103,808,551.24 DEBT SERVICE 101.401.254.355 DEBT SERVICE CHARGE 895,986.87 4,091.50 409,272.83 1,305,259.70 15 11/30/2022 08:47 AM TRIAL BALANCE REPORT FOR CLAY COUNTY UTILITIES Page: 2/2 User: kosborne DB: CCUA PERIOD ENDING 09/30/2022 ACTIVITY FOR 2021-22 BEG. BALANCE MONTH YEAR-TO-DATE END BALANCE GL NUMBER DESCRIPTION AMENDED BUDGET 10/01/2021 09/30/2022 THRU 09/30/22 09/30/2022 Fund 101 - GENERAL FUND Fund Equity DEBT SERVICE 895,986.87 4,091.50 409,272.83 1,305,259.70 TOTAL FUND EQUITY 239,282,534.25 964,717.73 27,325,205.47 266,607,739.72 Total Fund 101 - GENERAL FUND TOTAL ASSETS 0.00 0.00 0.00 0.00 BEG. FUND BALANCE 293,106,326.89 293,106,326.89 + NET OF REVENUES & EXPENDITURES + FUND BALANCE ADJUSTMENTS (53,823,792.64) (26,498,587.17) = ENDING FUND BALANCE 239,282,534.25 964,717.73 27,325,205.47 266,607,739.72 + LIABILITIES 0.00 0.00 0.00 0.00 = TOTAL LIABILITIES AND FUND BALANCE 239,282,534.25 964,717.73 27,325,205.47 266,607,739.72 OUT OF BALANCE 0.00 (964,717.73) (27,325,205.47) (266,607,739.72) 16 CLAY COUNTY UTILITY AUTHORITY 2021/2022 Alternative Water Supply Surcharges Beginning October November December January February March April May June July August September Balance Established 10/1/2015 Balance 2021 2021 2021 2022 2022 2022 2022 2022 2022 2022 2022 2022 9/30/2022 Expenditures: Job 991_FCOB Stormwater Harvesting Pilot Project 752,127.03 8,491.92 7,359.24 2,759.72 4,599.53 3,679.62 4,599.53 3,679.62 4,139.58 8,739.11 800,174.90 Stormwater Harvesting Study 49,842.66 49,842.66 Job 00119WP Aquifer Storage&Recovery(ASR) 1,554,488.01 0.00 25,593.03 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 327,302.47 34,787.31 111,425.02 30,334.51 43,865.61 92,024.45 22,416.64 15,064.51 14,314.51 8,397.76 8,925.12 708,857.91 I New Development: - Total Expenditures 3,078,793.53 34,787.31 145,509.97 37,693.75 46,625.33 0.00 4,599.53 95,704.07 27,016.17 18,744.13 18,454.09 17,136.87 8,925.12 3,533,989.87 Existing Customers: Revenue: Surcharge Fund(Existing Customers) 3,438,711.41 53,863.44 55,443.36 55,538.56 55,748.00 55,860.00 55,820.80 55,868.96 55,923.84 56,154.56 56,336.00 56,418.88 56,603.68 4,108,291.49 Connection Charge Fund(Growth) 1,836,928.17 21,664.31 492,122.50 70,217.45 26,038.59 15,869.77 64,944.47 49,485.38 106,437.06 61,628.31 79,548.45 42,060.10 27,431.62 2,894,376.18 Interest Income 40,259.54 5.84 1.36 1.25 0.14 0.76 2.67 1.67 0.56 40,273.79 Total Revenue 5,315,899.12 75,533.59 547,565.86 125,757.37 81,787.84 71,729.91 120,765.27 105,354.34 162,360.90 117,783.63 135,887.12 98,480.65 84,035.86 7,042,941.46 Balance 2,237,105.59 40,746.28 402,055.89 88,063.62 35,162.51 71,729.91 116,165.74 9,650.27 135,344.73 99,039.50 117,433.03 81,343.78 75,110.74 3,508,951.59 Cash Balance 3,517,876.71 Done in following Month: Less Construction Costs transferred after month close (8,925.12) J/E-Adjustment True Up for Move-Ins/Move-Outs J/E-Interfund Transfer 3,508,951.59 Page D-la 17 CLAY COUNTY UTILITY AUTHORITY CAPITAL PROJECT BUDGET t° REPORT FISCAL YEAR 2021 /2022 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 Job Description Job Number Budget Adopted Budget Budgets Amendments 09/30/22 Balances To Fund Amendments 2021 /2022 RENEWAL, REPLACEMENT & BETTERMENT Departmental Capital 100 1,122,764.59 1,052,400.00 2,175,164.59 1,269,498.40 905,666.19 2,175,164.59 Upgrade Lift station 9-Meadowbrook 755 110,000.00 110,000.00 8,077.74 101,922.26 110,000.00 CCUA Main Office Paving and Stripping Rehab 839 105,000.00 105,000.00 0.00 105,000.00 105,000.00 Knight Boxx/Old Jennings Force Main Extension 967 100,000.00 100,000.00 9,114.95 90,885.05 100,000.00 LS 40 Orange Park Country Club Rehab 1052 60,000.00 60,000.00 (28,503.40) 31,496.60 0.00 25 31,496.60 Lucy Branch Maintenance Building Repairs and Renovations 02018RR 120,000.00 120,000.00 0.00 120,000.00 120,000.00 Holly Ridge Dr.Force Main Installation 02119SL 280,000.00 280,000.00 (280,000.00) 0.00 0.00 25 0.00 Woodland Drive Force Main Installation 02219SL 239,000.00 239,000.00 (239,000.00) 0.00 0.00 25 0.00 Rehab SP WW Clarifer Wunder drain 1-2 02519RR 100,000.00 900,000.00 1,000,000.00 66,725.02 933,274.98 1,000,000.00 CL2 Storage Tanks-Multiple WTPS 02619WP 50,000.00 50,000.00 100,000.00 (67,422.46) 32,577.54 0.00 25 32,577.54 Task Order No. 33 -Gravity Rehab in Bellair 20020RR 952,800.54 952,800.54 952,800.54 0.00 952,800.54 Ridgecrest WTP-Replace Softstart&Crossline Starters with VFD's 20021RR 985,000.00 568,016.26 1,553,016.26 645,505.61 907,510.65 1,553,016.26 New Lift Station Generators: 172, 165, 151, 142, 163, 124 21002RR 400,000.00 400,000.00 343,891.24 56,108.76 400,000.00 Keystone Club Estates WTP Well No. 1 &@ Well and Pump Evalaution 21008RR 98,263.96 98,263.96 (29,425.92) 68,838.04 0.00 25 68,838.04 Fleming Island Reg.WWTP-2nd BCR Plant,Two Tanks 21010RR 200,000.00 5,000,000.00 5,200,000.00 3,464,630.46 1,735,369.54 5,200,000.00 Fleming WRF Clarifier No. 1 Upgrade 21014RR 50,000.00 1,158,000.00 1,208,000.00 106,499.86 1,101,500.14 1,208,000.00 Long Bay Rd.Water and Reclaimed Interconnect(Pine Ridge) 21015RR 60,000.00 60,000.00 8,031.14 68,031.14 0.00 25 68,031.14 Lift Station#2-Upgrade 21016RR 700,000.00 50,791.41 649,208.59 5 700,000.00 Ridgecrest WTP GST#2 Repair 21017RR 120,750.00 120,750.00 0.00 10,25 120,750.00 Wastewater Extension to 1045 Live Ok Ln. 21018RR 27,000.00 27,000.00 21,145.27 35,895.27 12,250.00 25 48,145.27 Ridaught WWTP Upgrades(Install Micro-screen,Grit Removal Equipment,a 21019RR 103,936.00 1,663,706.00 1,767,642.00 262,634.87 1,505,007.13 1,767,642.00 Lift Station#3 Foxbay Upgrade 21022RR 750,000.00 36,297.00 713,703.00 6 750,000.00 Coopergate-TO#7 LS 56&MH 1 21024RR 17,023.15 17,023.15 0.00 3 17,023.15 TO#36-Sandalwood,Fireside&Walgreen 21025RR 24,232.41 24,232.41 0.00 4 24,232.41 Meadowbrook Well Rehab 21028RR 70,000.00 630,000.00 700,000.00 (145,000.00) 0.00 555,000.00 12 555,000.00 Meadowbrook WTP Upgrades-(GST#3 repair,Transfer switch,GST#2 roo 21029RR 72,000.00 1,000,000.00 1,072,000.00 122,929.70 949,070.30 1,072,000.00 Insituform R&R-Task Order 37 Rolling Hills&Tanglewood 1A CIPP Linin 21031RR 0.00 1,000,000.00 1,000,000.00 (87,949.45) 598,865.90 313,184.65 14 912,050.55 Wastewater Extension to 3000 Pony Lane 21032RR 0.00 0.00 32,955.20 32,955.20 0.00 7,25 32,955.20 Dunster Court Water Main Replacement 22001RR 45,461.82 45,461.82 0.00 8,25 45,461.82 Sharone Court Water Main Replacement 22002RR 36,872.58 36,872.58 0.00 9,25 36,872.58 Vortex Task Order#8 Fy21-22 Manhole Rehabilitation 22004R 87,943.65 87,943.65 0.00 14,25 87,943.65 Oakleaf WTP Well No.2 22005RR 0.00 145,000.00 69,854.92 75,145.08 12 145,000.00 Water Main Replacement-Boxwood&Baytree 22006RR 0.00 56,898.10 56,898.10 0.00 13 56,898.10 Ridaught WTP-Phase I GST Upgrades 22007RR 50,000.00 1,100,000.00 1,150,000.00 54,103.26 1,095,896.74 1,150,000.00 Lift Station#4 Upgrades 22008RR 0.00 200,000.00 200,000.00 300,000.00 12,015.00 487,985.00 16 500,000.00 Lift Station#62 and#67-Rehabilitation 22009RR 0.00 0.00 500,000.00 25,862.04 474,137.96 17 500,000.00 2"Water Main Replacement-Taurus Lan 22011RR 0.00 0.00 40,354.70 40,354.70 0.00 15 40,354.70 CR 218 widening from Pine Tree Lane to Cosmos 22022RR 425,000.00 425,000.00 424,394.80 605.20 425,000.00 CR 220 widening Baxley to Henley Rd Not Started 0.00 575,000.00 575,000.00 0.00 575,000.00 575,000.00 CR 220 widening from Henley to Knightbox Not Started 0.00 420,000.00 420,000.00 0.00 420,000.00 420,000.00 . X:\Finance\Controllers Folder\Monthly Financial\Monthly Construction Reports\2021-2022\CIP_2022-September.xlsx Page 1 of 4 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/22 Balances To Fund Amendments 2021 /2022 ERP Software Replacement Not Started 0.00 1,400,000.00 1,400,000.00 0.00 1,400,000.00 1,400,000.00 Fleming Oaks WTP Electrical Upgrades&Hydro Tank Not Started 0.00 0.00 0.00 0.00 0.00 Fleming Oaks WTP: Replace roof on the pump,bleach,and generator buildin Not Started 30,000.00 30,000.00 0.00 30,000.00 30,000.00 Keystone Heights-Brooklyn Bay Road Water Main Rehabilitation Not Started 0.00 9,000.00 9,000.00 0.00 9,000.00 9,000.00 Keystone Heights-Lakeside Street/Hilltop Street Water Main Rehabilitation Not Started 0.00 0.00 0.00 0.00 0.00 Kingsley Cove WTP Well Rehab Not Started 0.00 0.00 0.00 0.00 0.00 Lake Asbury WM Improvements(602 Lake Asbury Road to Aldersgate Drive Not Started 0.00 0.00 0.00 0.00 0.00 Lift Station SCADA System Not Started 0.00 0.00 0.00 0.00 0.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 WTP: Electrical&Hydro Tank Upgrades(Replace Hydrotank Ta Not Started 0.00 0.00 0.00 0.00 0.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 Spencers WTP-Ground Storage&High Service Pump Not Started 0.00 0.00 0.00 0.00 0.00 Sandridge Road widening from Henley to CR 209 Not Started 0.00 150,000.00 150,000.00 0.00 150,000.00 150,000.00 Server Lifecycle Replacement Not Started 0.00 0.00 0.00 0.00 0.00 Upgrade Lift Stations 11,41,69,51 Not Started 1,000,000.00 1,000,000.00 0.00 1,000,000.00 1,000,000.00 Upgrade Lift Station 98 Not Started 0.00 0.00 0.00 0.00 0.00 Upgrade Lift Stations 9,43,24, 59 Not Started 0.00 0.00 0.00 0.00 0.00 WRF SCADA System Not Started 0.00 0.00 0.00 0.00 0.00 Water SCADA System Not Started 0.00 0.00 0.00 0.00 0.00 Wesley RD WM Improvements(Branscomb Road to Arthur Moore Drive) Not Started 0.00 0.00 0.00 0.00 WTP Ground Storage Tanks: add Handrails Not Started 0.00 576,000.00 576,000.00 576,000.00 576,000.00 Water Plant Meters Retrofits Not Started 0.00 0.00 0.00 0.00 0.00 Ridaught/Greenwood/Lucy Branch/Orange Park South WTP Consolidation a Not Started 0.00 250,000.00 250,000.00 250,000.00 250,000.00 SYSTEM EXPANSION Meadow Lake WTP-New Ground Storage Tank and Electrical Service upgrad 00983WP 363,093.00 1,834,953.00 2,198,046.00 1,847,602.33 350,443.67 2,198,046.00 Peters Creek WTP-Hydro Tank Painting 01118RR 75,000.00 75,000.00 0.00 75,000.00 75,000.00 Henley Road 12"WM Loop-Sandridge to Small Lake 01119WL 106,000.00 106,000.00 11,258.64 94,741.36 106,000.00 North Middleburg Water&Sewer Extension and Interconnection(Water Inte 02419WL 169,191.77 1,700,000.00 1,869,191.77 347,734.63 1,521,457.14 1,869,191.77 Saratoga Springs WTP-Phase I 03018WP 1,211,426.55 1,137,327.00 2,348,753.55 6,160,730.22 (3,811,976.67) 2,348,753.55 Saratoga Springs RWP-Phase I 03118RP 1,160,831.00 446,202.00 1,607,033.00 3,862,806.17 (2,255,773.17) 1,607,033.00 FCOB Utility Crossings 03218WL 3,900,000.00 3,900,000.00 (1,685,101.88) 2,214,898.12 0.00 25 2,214,898.12 Middleburg Water and Sewer Relocations 03319WL 602,241.10 602,241.10 273,197.44 329,043.66 602,241.10 Saratoga Springs Offsite Main Extensions 03419WL 485,323.00 2,299,677.00 2,785,000.00 1,365,728.77 1,419,271.23 2,785,000.00 Mid Clay WWTP-Phase II Plant Expansion 20003SP 582,615.00 4,500,000.00 5,082,615.00 5,848,639.95 (766,024.95) 5,082,615.00 Fleming Island Reg.WWTP-#3 BTU Installation,Design 20004SP 2,149,000.00 4,371,000.00 6,520,000.00 6,765,093.36 (245,093.36) 6,520,000.00 Meadowbrook WTP Chlorine Room Roll-Up Door Addition 20006WP 50,000.00 50,000.00 (18,998.92) 31,001.08 0.00 25 31,001.08 Fleming Island WWTF Clarifier No.2 Evaluation and Repair 20007SP 140,000.00 140,000.00 (29,555.43) 110,444.57 0.00 25 110,444.57 2019-054 Doctors Lake Restoration Project 20011SL 236,340.52 175,000.00 411,340.52 1,644,738.54 (1,233,398.02) 411,340.52 Brannen Mill Extension-Challenger Center 20012WL 2,200,000.00 2,200,000.00 (1,091,171.43) 1,108,828.57 0.00 25 1,108,828.57 ■ X:\Finance\Controllers Folder\Monthly Financial\Monthly Construction Reports\2021-2022\CIP_2022-September.xlsx Page 2 of 4 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/22 Balances To Fund Amendments 2021 /2022 Peters Creek WRF-Phase II 20027SP 50,000.00 1,600,000.00 1,650,000.00 (1,408,025.02) 255,152.72 (13,177.74) 11 241,974.98 CCUA Storage Building and Site Improvements 21001AD 254,095.00 3,480,750.00 3,734,845.00 3,125,095.78 609,749.22 3,734,845.00 Aquarius Concourse Relocation Utility Relocations 21004WL 2,852,544.14 2,852,544.14 2,166,611.25 685,932.89 2,852,544.14 Cross Creek-315 Cost Share&Easement 21005WL 420,000.00 420,000.00 94,807.55 514,807.55 0.00 25 514,807.55 Governor's Park WWTF Design and Build 21012SP 25,000.00 25,000.00 45,339.84 (20,339.84) 25,000.00 CCUA Administrative Building Phase I Not Started 0.00 214,907.00 214,907.00 192,556.31 22,350.69 214,907.00 Swimming Penn Creek WM Interconnect 21020WL 2,000,000.00 2,000,000.00 127,662.80 1,872,337.20 2,000,000.00 Water and Wastewater Service to 7065 Artis Rd 21021WL 30,416.86 30,416.86 0.00 2,25 30,416.86 Ravines to Henly Road Water Main Extension 21023WL 2,640,000.00 2,640,000.00 214,740.01 2,425,259.99 2,640,000.00 Governor's Park WTP Design and Build 21026WP 2,400.00 975,000.00 977,400.00 315,672.05 661,727.95 977,400.00 Water Service Extension to 3173 Park Ave 21027WL 0.00 89,115.55 89,115.55 0.00 1 89,115.55 Peters Creek WTP 2nd GST&3rd Well 21030WP 100,000.00 875,000.00 975,000.00 158,719.17 816,280.83 975,000.00 Peters Creek New Regional WRF 22003SP 0.00 0.00 1,408,025.02 2,028,433.46 (620,408.44) 11 1,408,025.02 CCUA North Campus Driveway 22010AD 0.00 0.00 36,340.73 28,577.80 7,762.93 18 36,340.73 LAMPA E/W Interconnect#1 -Water Lines 22012WL 247,500.00 3,914.12 243,585.88 20 247,500.00 LAMPA E/W Interconnect#1 -Wwtr-Reuse 22013SL 495,000.00 7,952.03 487,047.97 20 495,000.00 LAMPA E/W Interconnect#2-Water Lines 22014WL 165,000.00 7,834.14 157,165.86 21 165,000.00 LAMPA E/W Interconnect#2-Wwtr-Reuse 22015SL 330,000.00 15,909.96 314,090.04 21 330,000.00 LAMPA N/S Interconnect#1 -Water Lines 22016WL 305,250.00 4,827.81 300,422.19 22 305,250.00 LAMPA N/S Interconnect#2 Wwtr&Reuse 22017SL 610,500.00 9,808.88 600,691.12 22 610,500.00 LAMPA N/S Interconnect#2 Water Lines 22018WL 181,500.00 2,870.75 178,629.25 23 181,500.00 LAMPA N/S Interconnect#2 Wwtr&Reuse 22019SL 363,000.00 5,829.91 357,170.09 23 363,000.00 Emalyn Place 3 Single Family Units 22021WL 17,000.00 8,589.95 8,410.05 24 17,000.00 Peter's Creek WWTP-Land Acquisition 22022SP 4,200,000.00 4,035.00 4,195,965.00 19 4,200,000.00 Engineering Cost Allocation 9999999 0.00 0.00 0.00 0.00 Bradley Creek Crossing Cost Share Not Started 129,500.00 129,500.00 0.00 129,500.00 129,500.00 Bradley Creek Crossing-Cost Share Not Started 79,000.00 79,000.00 0.00 79,000.00 79,000.00 Cost Share-Extension from Mayfield Annex to Blanding Not Started 37,800.00 37,800.00 37,800.00 37,800.00 CR218 Utility Main Extensions Not Started 2,500,000.00 2,500,000.00 2,500,000.00 2,500,000.00 Infill Projects Not Started 1,161,679.98 100,000.00 1,261,679.98 1,261,679.98 1,261,679.98 Keystone-Master Plan WM-Mossy Oaks to Geneva Lake Est. Not Started 900,000.00 900,000.00 900,000.00 900,000.00 Keystone Wastewater Treatment Plant-Phase II Construction Not Started 0.00 0.00 0.00 0.00 Mid-Clay&Oakleaf Reclaimed WP Upgrades(Install 3rd High Service Puml Not Started 350,000.00 350,000.00 350,000.00 350,000.00 Old Jennings Rd-Estimated Cost Share on oversizing to Commercial stub Not Started 40,000.00 40,000.00 40,000.00 40,000.00 Peters Creek WWTP-Land Acquisition Not Started 0.00 0.00 (634,050.00) (634,050.00) 19 (634,050.00) Peters Creek Reclaimed Additions Not Started 0.00 0.00 0.00 Pier Station E/W WM Extension and Interconnect(State Road 16 and FCOB; Not Started 0.00 750,000.00 750,000.00 750,000.00 750,000.00 Pier Station Force Main Extensions(State Road 16 and FCOB) Not Started 0.00 0.00 0.00 0.00 Pier Station Master Pump Station(State Road 16 and FCOB) Not Started 0.00 250,000.00 250,000.00 250,000.00 250,000.00 Pier Station WTP Expansion Not Started 0.00 0.00 0.00 0.00 Ravines WTP 2nd GST Not Started 0.00 0.00 0.00 0.00 21 X:\Finance\Controllers Folder\Monthly Financial\Monthly Construction Reports\2021-2022\CIP_2022-September.xlsx Page 3 of 4 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/22 Balances To Fund Amendments 2021 /2022 Ridaught RWP-750K Ground Storage Tank Not Started 0.00 0.00 0.00 0.00 Ridaught RWP-Install 3rd High Service Pump Not Started 0.00 0.00 0.00 0.00 Spencer's WWTP: Phase 6 Expansion Not Started 0.00 0.00 0.00 0.00 Water System Interconnects-Misc Not Started 0.00 660,000.00 660,000.00 660,000.00 660,000.00 Ridaught/Greenwood/Lucy Branch/Orange Park South WTP Consolidation a Not Started 0.00 50,000.00 50,000.00 50,000.00 50,000.00 Longbay Rd. Master Pump Station and Force Main Not Started 0.00 0.00 0.00 0.00 Village Park&Bradley Creek(Developer Agreement MU18/19-1) Not Started 258,078.00 258,078.00 258,078.00 258,078.00 ALTERNATIVE WATER SUPPLY Aquifer Storage&Recovery(ASR)-Hydrogeologic Well Construction and 7 00119WP 2,321,500.00 2,321,500.00 1,580,081.04 741,418.96 2,321,500.00 Potable Reuse Pilot Project 20022WL 429,261.99 185,000.00 614,261.99 731,208.01 (116,946.02) 614,261.99 2 MGD Potable Reuse Not Started Other AWS(Stormwater,RIBs,Reclaimed Storage,etc) Not Started Subtotals 38,030,686.14 43,306,938.26 81,337,624.40 5,715,919.82 52,492,288.06 34,561,256.16 87,053,544.22 Contingency 13,719,293.47 13,719,293.47 (5,715,919.82) (1-25) 8,003,373.65 TOTAL CAPITAL EXPENDITURES 95,056,917.87 0.00 95,056,917.87 Construction In Progress 43,959,903.62 Not Started 12,494,914.98 Completed Jobs 8,532,384.44 Started 82,562,002.89 52,492,288.06 95,056,917.87 22 X:\Finance\Controllers Folder\Monthly Financial\Monthly Construction Reports\2021-2022\CIP_2022-September.xlsx Page 4 of 4 CLAY COUNTY UTILITY AUTHORITY OPERATING DETAIL BY MONTH t° FISCAL YEAR 2021 /2022 Section F 23 11/28/2022 09:29 AM REVENUE REPORT FOR CLAY COUNTY UTILITIES Page: 1/1 User: kosborne DB: CCUA PERIOD ENDING 09/30/2022 OPERATING REVENUE BUDGET REPORT ACTIVITY FOR 2021-22 MONTH YTD BALANCE % BDGT GL NUMBER DESCRIPTION AMENDED BUDGET 09/30/2022 09/30/2022 USED OPERATING REVENUES Water Revenues Water Base Charges 101.401.343.301 RESIDENTIAL WATER BASE CHARGE 6,379,316.00 551,337.05 6,382,493.90 100.05 101.401.343.303 GENERAL SERVICE WATER BASE 1,226,278.00 107,941.23 1,206,791.36 98.41 101.401.346.303 Commercial Potable Irrigation Base 264,541.00 18,321.33 214,912.47 81.24 Net Water Base Charges 7,870,135.00 677,599.61 7,804,197.73 101.79 Water Use Charges 101.401.344.303 Residential Water Usage Tier 1 3,485,504.00 308,045.15 3,523,178.16 101.08 101.401.344.304 Residential Water Usage Tier 2 2,060,486.00 165,066.38 2,103,740.27 102.10 101.401.344.305 Residential Water Usage Tier 3 864,211.00 64,265.46 916,166.67 106.01 101.401.344.306 Residential Water Usage Tier 4 1,007,439.00 67,609.82 1,043,726.41 103.60 101.401.345.305 Commercial Water Usage 1,787,785.00 180,167.34 1,801,885.43 100.79 101.401.346.306 Commercial Potable Irrigation Usage T 124,838.00 10,550.59 118,536.44 94.95 101.401.346.307 Commercial Potable Irrigation Usage T 199,467.00 17,477.09 167,759.29 84.10 101.401.346.308 Commercial Potable Irrigation Usage T 155,689.00 15,049.26 123,157.61 79.10 101.401.346.309 Commercial Potable Irrigation Usage T 92,937.00 16,471.64 164,445.88 176.94 Net Water Use Charges 9,778,356.00 844,702.73 9,962,596.16 101.79 Reuse Water Base Charges 101.401.343.601 Reuse Residential Base 2,486,808.00 242,438.31 2,748,784.34 110.53 101.401.343.602 Reuse Commercial Base 256,731.00 22,716.80 254,749.06 99.23 Net Reuse Water Base Charges 2,743,539.00 265,155.11 3,003,533.40 101.79 Reuse Water Usage Charges 101.401.347.403 Reuse Residential Usage Tier 1 807,652.00 71,296.71 864,239.01 107.01 101.401.347.404 Reuse Residential Usage Tier 2 220,440.00 17,164.41 219,918.27 99.76 101.401.347.405 Reuse Residential Usage Tier 3 635,232.00 47,534.47 609,076.30 95.88 101.401.347.406 Reuse Commercial Usage Tier 1 95,776.00 7,000.14 80,989.91 84.56 101.401.347.407 Reuse Commercial Usage Tier 2 32,826.00 2,396.68 29,579.43 90.11 101.401.347.408 Reuse Commercial Usage Tier 3 229,727.00 15,131.46 215,553.37 93.83 101.401.349.506 CROSSINGS RECLAIMED WATER CHRG 113,650.00 7,707.53 141,001.41 124.07 Net Reuse Water Usage Charges 2,135,303.00 168,231.40 2,160,357.70 101.79 Net Water Revenues 22,527,333.00 1,955,688.85 22,930,684.99 101.79 Sewage Revenues Sewer Base Charges 101.401.343.501 RESIDENTIAL SEWER BASE CHARGE 13,725,981.00 1,178,806.37 13,613,850.80 99.18 101.401.343.504 GENERAL SERVICE SEWER BASE 2,197,709.00 212,824.24 2,441,975.26 111.11 Net Sewer Base Charges 15,923,690.00 1,391,630.61 16,055,826.06 97.60 Sewer Use Charges 101.401.343.502 RESIDENTIAL SEWER USAGE CHARGE 10,261,010.00 842,079.22 9,731,519.07 94.84 101.401.343.505 GENERAL SERVICE SEWER USAGE 3,524,827.00 315,302.30 3,215,952.81 91.24 101.401.343.506 PORTALET SEWAGE REVENUE 208,800.00 17,110.03 195,923.79 93.83 Net Sewer Use Charges 13,994,637.00 1,174,491.55 13,143,395.67 97.60 Net Sewage Revenues 29,918,327.00 2,566,122.16 29,199,221.73 97.60 Net OPERATING REVENUES 52,445,660.00 4,521,811.01 52,129,906.72 97.60 TOTAL REVENUES - ALL FUNDS 52,445,660.00 4,521,811.01 52,129,906.72 99.40 24 Operating Net Income $2,500,000 -1._ $2,000,000 lang7,41eell 1111T-- $1,500,000 • 'AirA°1 -- -- J1 ill , _ III 00 ., 00 11 . $0 October November December January February March April May June July August September Actual Net Income Prior Year Net Income Budgeted Net Income Operating Revenue $6,000,000 $5,000,000 $4,000,000 I • 4 $3,000,000 1.1 $2,000,000 p - t0 $1,000,000 I $0 October November December January February March April May June July August September Actual Optg Rev - Prior Year Optg Rev Budgeted Optg Rev 26 Budgeted vs. Actual - Base & Use Charges, Total 30,000,000 25,000,000 V 20,000,000 15,000,000 — - - F 11 10,000,000 - - fO 5,000,000 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 CLAY COUNTY UTILITY AUTHORITY OTHER REPORTS t° FISCAL YEAR 2021 /2022 Section G 28 CLAY COUNTY UTILITY AUTHORITY Covenant Regarding Rates & Additional Debt Using Twelve Months' Income Data at September 30, 2022 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. 2021/2022 Annual Debt Service $9,168,010 105% $9,626,410 2021/2022 Renewal&Replacement Deposit $2,414,518 100% $2,414,518 Required Net Revenues $12,040,929 Twelve Months'Net Revenues $19,347,787 Less Bad Debt Expense $25,705 Twelve Months'Net Revenues(Operating Income less bad debt exp) $19,322,082 Annualized Net Revenues $19,322,082 Debt Coverage Ratio 166.82% NET REVENUES OVER BOND TEST AVAILABLE FOR BONDING $7,281,154 Additional Bonds That Can Be Issued for 30 Years @ 5% with an annual principal and interest payment of $7,281,154 $111,929,176 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 16,466,511 7,625,964 104,940,951 tO 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 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 2021-22 Bond Test Report.xlsx 29 11/28/2022 09:30 AM REVENUE AND EXPENDITURE REPORT FOR CLAY COUNTY UTILITIES Page: 1/2 User: kosborne DB: CCUA PERIOD ENDING 09/30/2022 CONSTRUCTION DEPARTMENT BUDGET ACTIVITY FOR 2021-22 MONTH YTD BALANCE ENCUMBERED UNENCUMBERED % BDGT GL NUMBER DESCRIPTION AMENDED BUDGET 09/30/22 09/30/2022 YEAR-TO-DATE BALANCE USED INTERNAL BILLINGS 101.401.349.609 BILLINGS TO CCUA-CAPITAL ASSET 624,519.00 146,586.09 235,976.94 0.00 388,542.06 37.79 Net INTERNAL BILLINGS 624,519.00 146,586.09 235,976.94 0.00 388,542.06 37.79 WAGES 101.401.536.128 C/D JOB PAYROLL 0.00 2,805.53 47,460.68 0.00 (47,460.68) 100.00 101.401.536.129 C/D CONTRA JOB PAYROLL 0.00 (2,805.53) (47,460.68) 0.00 47,460.68 100.00 101.502.536.121 WAGES HOURLY 241,797.65 1,855.05 32,485.54 0.00 209,312.11 13.44 Net WAGES (241,797.65) (1,855.05) (32,485.54) 0.00 (209,312.11) 13.44 HEALTH/LIFE INSURANCE 101.502.536.230 EMPLOYEE HEALTH&LIFE INSURANCE 63,804.38 539.18 7,777.29 0.00 56,027.09 12.19 Net HEALTH/LIFE INSURANCE (63,804.38) (539.18) (7,777.29) 0.00 (56,027.09) 12.19 RETIREMENT & BENEFITS 101.502.536.220 EMPLOYEE RETIREMENT & BENEFITS 25,643.32 414.44 5,441.52 0.00 20,201.80 21.22 Net RETIREMENT & BENEFITS (25,643.32) (414.44) (5,441.52) 0.00 (20,201.80) 21.22 PAYROLL TAXES 101.502.536.210 EMPLOYER FICA PAYROLL TAXES 18,088.12 138.11 2,422.08 0.00 15,666.04 13.39 Net PAYROLL TAXES (18,088.12) (138.11) (2,422.08) 0.00 (15,666.04) 13.39 WORKMENS COMPENSATION INS. 101.502.536.240 W/C INSURANCE 8,806.38 (324.34) 807.16 0.00 7,999.22 9.17 101.502.536.246 W/C INSURANCE 0.00 (4.56) 9.43 0.00 (9.43) 100.00 101.508.536.246 CONSTRUCTION W/C INSURANCE 0.00 (61.71) 127.48 0.00 (127.48) 100.00 101.509.536.246 CONSTRUCTION W/C INSURANCE 0.00 (2,066.57) 5,476.52 0.00 (5,476.52) 100.00 101.517.536.246 CONSTRUCTION W/C INSURANCE 0.00 (95.87) 198.02 0.00 (198.02) 100.00 Net WORKMENS COMPENSATION INS. (8,806.38) 2,553.05 (6,618.61) 0.00 (2,187.77) 75.16 PROPERTY/LIABILITY INSURANCE 101.502.536.451 PROPERTY INSURANCE-CONSTRUCTION 54,855.00 4,675.14 56,082.43 0.00 (1,227.43) 102.24 Net PROPERTY/LIABILITY INSURANCE (54,855.00) (4,675.14) (56,082.43) 0.00 1,227.43 102.24 OFFICE SUPPLIES 101.502.536.529 SUPPLIES OFFICE 900.00 0.00 146.26 0.00 753.74 16.25 Net OFFICE SUPPLIES (900.00) 0.00 (146.26) 0.00 (753.74) 16.25 TOOLS & SUPPLIES 101.502.536.407 JOB EQUIPMENT CHARGES 0.00 493.50 18,620.50 0.00 (18,620.50) 100.00 101.502.536.527 TOOLS & SUPPLIES 5,000.00 434.94 8,733.28 (23.39) (3,709.89) 174.20 Net TOOLS & SUPPLIES (5,000.00) (928.44) (27,353.78) 23.39 22,330.39 546.61 FUEL, OIL, & REPAIRS 101.502.536.468 EQUIP REPAIR&MAINTENANCE 15,000.00 0.00 20,889.32 2,865.00 (8,754.32) 158.36 Net FUEL, OIL, & REPAIRS (15,000.00) 0.00 (20,889.32) (2,865.00) 8,754.32 158.36 TRANSPORTATION 101.502.536.401 TRANSPORTATION EXPENSES 25,500.00 2,944.01 33,350.44 0.00 (7,850.44) 130.79 30 11/28/2022 09:30 AM REVENUE AND EXPENDITURE REPORT FOR CLAY COUNTY UTILITIES Page: 2/2 User: kosborne DB: CCUA PERIOD ENDING 09/30/2022 CONSTRUCTION DEPARTMENT BUDGET ACTIVITY FOR 2021-22 MONTH YTD BALANCE ENCUMBERED UNENCUMBERED % BDGT GL NUMBER DESCRIPTION AMENDED BUDGET 09/30/22 09/30/2022 YEAR-TO-DATE BALANCE USED Net TRANSPORTATION (25,500.00) (2,944.01) (33,350.44) 0.00 7,850.44 130.79 MISCELLANEOUS 101.502.536.221 EMPLOYEE TRAINING & TRAVEL 4,325.00 0.00 2,270.00 0.00 2,055.00 52.49 Net MISCELLANEOUS (4,325.00) 0.00 (2,270.00) 0.00 (2,055.00) 52.49 DEPRECIATION 101.401.536.595 CONSTRUCTION R&R (DEPRECIATION 104,385.00 2,123.24 40,969.98 0.00 63,415.02 39.25 Net DEPRECIATION (104,385.00) (2,123.24) (40,969.98) 0.00 (63,415.02) 39.25 MATERIALS & SUBCONTRACTORS 101.502.536.435 TRASH SERVICE 2,100.00 0.00 0.00 0.00 2,100.00 0.00 101.502.536.461 SUBCONTRACTORS 0.00 0.00 169.69 0.00 (169.69) 100.00 Net MATERIALS & SUBCONTRACTORS (2,100.00) 0.00 (169.69) 0.00 (1,930.31) 8.08 CONTINGENCY 101.401.536.990 CONTINGENCY 54,315.00 0.00 0.00 0.00 54,315.00 0.00 Net CONTINGENCY (54,315.00) 0.00 0.00 0.00 (54,315.00) 0.00 TOTAL REVENUES - ALL FUNDS 624,519.00 146,586.09 235,976.94 0.00 388,542.06 37.79 TOTAL EXPENDITURES - ALL FUNDS 624,519.85 11,064.56 235,976.94 2,841.61 385,701.30 38.24 NET OF REVENUES & EXPENDITURES (0.85) 135,521.53 0.00 (2,841.61) 2,840.76 ;4,307.06 31 Deferred Connection Charges Report Board Summary As of September 30,2022 Subdivision Execution Date Deferred Charges Lots In Service Remaining Paid Pending Collection% In Process: Linda Lakes Subdivision 02/19/2016 $303,170 122 117 5 $290,745 $12,425 95.90% Pinewood Place Subdivision 12/08/2020 $355,607 82 75 7 $325,181 $30,427 91.44% Willow Springs 11/19/2019 $632,584 150 146 4 $615,637 $16,947 97.32% Goose Creek Estates IllM10/27/2020 $220,276 52 16 36 $67,754 $152,522 30.76% Willow Springs Subdivision 2A,2B&3 01/21/2021 $968,572 229 151 78 $638,109 $330,463 65.88% Fleming Estates 05/11/2018 $172,679 '40 33 7 $142,252 $30,427 82.38% Cross Creek Subdivision Phase I,Unit 1A 04/17/2018 $1,101,145 263 251 12 $1,050,305 $50,841 95.38% Village Park 03/12/2019 $658,707 156 122 34 $514,659 $144,048 78.13% Royal Pointe 04/10/2019 $263,295 58 46 12 $212,455 $50,841 80.69% Avonlea Hills Subdivision-Phase 1(238 Lots) 02/25/2021 $1,007,306 238 106 132 $448,060 $559,246 44.48% Cross Creek 2B-1 04/19/2021 $536,669 127 127 0 $536,669 100.00% Cross Creek Subdivision Phase 2B-2 _A 04/20/2021 $342,866 81 30 51 $126,794 $216,072 36.98% Anabelle Island Subdivision-Phases 1A,1B&2 09/07/2021 $1,457,428 344 0 344 $1,457,428 0.00% Cross Creek Subdivision Phase 2C-226 Lots 10/05/2021 $957,496 226 0 226 $957,496 0.00% Cross Creek Subdivision Phase 2F-113 Lots 10/27/2021 $490,076 113 0 113 $490,076 0.00% Granary Park Subdivision Phase II 279 Lots 03/14/2022 $1,210,012 279 0 279 $1,210,012 0.00% Robinson Ranch Subdivision Phase 1-198 Lots 03/29/2022 $858,718 198 0 198 $858,718 0.00% Creekview Trails Area 4 705/27/2022 $1,053,881 243 0 243 . $1,053,881 0.00% Eagle Landing at Oakleaf Plantation,Phase 6 12/18/2018 $324,269 77 75 2 $315,796 $8,473 97.39% Eagle Landing at Oakleaf Plantation,Phase 5B i 02/05/2019 $419,434 99 0 99 $419,434 0.00% Eagle Landing at Oakleaf Plantation,Phase 6,Part 2 10/11/2019 $358,919 85 76 9 $320,789 $38,130 89.38% Greyhawk Subdivision Units 2&3 11/19/2019 $1,266,440 300 281 19 $1,185,943 $80,497 93.64% Wilford Preserve Phase 2 11/25/2019 $734,599 174 167 7 $704,942 $29,657 95.96% Cameron Oaks Subdivision,Phase 3 -91 Lots 08/03/2020 $383,648 91 90 1 $379,411 $4,237 98.90% Sugar Leaf Farms Subdivision-118 Lots 05/27/2021 $499,932 118 0 118 $499,932 0.00% Wilford Preserve Subdivision,Phase 3A&3B-138 Lo 07/21/2021 $584,666 138 0 138 $584,666 0.00% Discovery Trails at Oakleaf-76 Townhomes 12/14/2021 $217,996 54 0 54 $217,996 0.00% Double Branch Subdivision il . 01/31/2022 $663,555 153 0 153 $663,555 0.00% Cheswick South Subdivision-232 Lots 05/04/2022 $1,006,175 232 0 232 $1,006,175 0.00% In Process Totals $19,050,124 4,522 1,909 2,613 $7,875,502 $11,174,623 41.34% 32 Deferred Connection Charges Report Board Summary As of September 30,2022 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% 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% 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% 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% Completed Totals $3,808,027 904 904 0 $3,808,027 100.00% Grand Totals $22,858,152 5,426 2,813 2,613 $11,683,529 $11,174,623 51.11% Summary by FY Deferred Charges Lots In Service Remaining Paid Pending Collection% FY 2016 $303,170 122 117 5 $290,745 $12,425 95.90% FY 2017 0 0 0 11M I IM FY 2018 $2,743,438 663 644 19 $2,662,170 $81,267 97.04% FY 2019 $2,698,651 626 479 147 $2,075,855 $622,796 76.92% FY 2020 $4,259,087 1,008 968 40 $4,089,618 $169,468 96.02% FY 2021 $6,395,897 1,509 605 I 904 $2,565,141 $3,830,756 40.11% FY 2022 $6,457,910 1,498 0 1,498 $6,457,910 0.00% Grand Totals $22,858,152 5,426 2,813 2,613 $11,683,529 $11,174,623 51.11% 33 CLAY COUNTY UTILITY AUTHORITY KEY PERFORMANCE INDICATORS- PERIOD ENDING 09/30/2022 Ratio Calculation vs.Target Target Days of Cash on Hand Undesignated Cash 65,388,234 /Operating Expense per day / 98,251 Days of Cash on Hand = 666 w', 322 In Years 1.82 Debt Ratio Total Liabilities 105,483,948 /Total Assets / 411,746,266 Debt Ratio(%) = 26% 0 43% Debt-Service Coverage Ratio Revenue,Annualized 54,017,853 -O&M Costs,Annualized - 35,370,461 /Total Debt Service / 9,170,073 Debt-Service Coverage Ratio 2.03 0 2.00 Operating Ratio Total O&M Costs 35,370,461 /Total Operating Revenue / 54,017,853 Operating Ratio 65% 72% Employee Turnover tO YTD#of Employee Departures 22 Rolling 12-month turnover 22 /Total#of FTE's / 181 Rolling 12-month Employee Turnover 12.2% ® 9.1% Current Ratio Current Assets 75,231,457 /Current Liabilities / 21,104,095 Current Ratio 3.56 0 2 Return on Assets Net Income 18,647,392 Net Income,Annualized 18,647,392 /Total Assets,Annualized 411,746,266 Return on Assets 4.5% 0 2.2% 34 CLAY COUNTY UTILITY AUTHORITY DAYS OF CASH ON HAND 1,000 900 896 800 772 788-w752 767 803 771`777''..763758 738 700 713 698-666 600 500 400 322 300 200 100 SEP-20 SEP-21 OCT-21 NOV-21 DEC-21 JAN-22 FEB-22 MAR-22 APR-22 MAY-22 JUN-22 JUL-22 AUG-22 SEP-22 Days of Cash of Hand Target DEBT RATIO 50% 45% 43% 40% 35% 30% 30% 0 25% 27%27%26%-26%-26%-26%-26%-26%— 25% 25% 25% 25% 26% 20% 15% 10% 5% 0%Li SEP-20 SEP-21 OCT-21 NOV-21 DEC-21 JAN-22 FEB-22 MAR-22 APR-22 MAY-22 JUN-22 JUL-22 AUG-22 SEP-22 tDebt Ratio(%) Target DEBT SERVICE COVERAGE 3.00 .. 2.50 .39 2.00 1. 2.07— 2.04 1.95 1.95 1.99 .01 -2.08�.13_2.07- .03 95 1 87 1.96 2.00 1.50 1.00 0.50 0.00 SEP-20 SEP-21 OCT-21 NOV-21 DEC-21 JAN-22 FEB-22 MAR-22 APR-22 MAY-22 JUN-22 JUL-22 AUG-22 SEP-22 I —~Debt-Service Coverage Ratio —Target 35 CLAY COUNTY UTILITY AUTHORITY OPERATING RATIO 74% 72% 72% 70% 68% 67% 66% 65%Mir 65%='66% 65%w65% 65% 0 65%lilig65% 64% 64% 65% 64/0 •4% 62% 62% 60% 58% 56% i . SEP-20 SEP-21 OCT-21 NOV-21 DEC-21 JAN-22 FEB-22 MAR-22 APR-22 MAY-22 JUN-22 JUL-22 AUG-22 SEP-22 I16, -Operating Ratio(%) -Target CURRENT RATIO 6.00 - -- 5.3`�5.15�5.22�5.13 5.00 4.94 4.91-'w 4.73 4.67 .51 4.20 4.17 4.00 4.09 3.56 t0 3.00 2.00 2.00 - 1.00 0.00 SEP-20 SEP-21 OCT-21 NOV-21 DEC-21 JAN-22 FEB-22 MAR-22 APR-22 MAY-22 JUN-22 JUL-22 AUG-22 SEP-22 Current Ratio Target RETURN ON ASSETS 6.0% 5.2% 0 4.5% 4.3% 4.4% 4.6% 4.6% 4.4% 4.4% 4.5% 4.5% 4.6% 4.7% 4.6% 4.5% 5.0% 4.0% 3.0% 2.2% 2.0% 1.0% 0.0% SEP-20 SEP-21 OCT-21 NOV-21 DEC-21 JAN-22 FEB-22 MAR-22 APR-22 MAY-22 JUN-22 JUL-22 AUG-22 SEP-22 +Return on Assets(%) Target 36