Loading...
HomeMy WebLinkAbout10.a EDB 2024-04 Board Financial Package (CONATIM-Dcl. cot/A/ Clay County Utility Authorityworking together to 3176 Old Jennings Road protect public health, Middleburg,FL 32068-3907 conserve our natural Telephone(904)272-5999 resources,and create AintA www.clayutility.org long-term value for our ratepayers. September 5, 2024 To: Board of Supervisors From: Karen Osborne Re: April 2024 Financial Package I have enclosed the following financial information: A) Comparative Financial Statements for the seven months of fiscal years 2023/2024 and 2022/2023. Comparative Balance Sheet Revenue & Expenditure Report Cash-flow Statement B) Cash &Cash Equivalents Report as of April 30, 2024 C) Budget Reports for the seven months of Fiscal Year 2023/2024 Operating and Interest Revenue Detail Budget Report Operating Expense Detail Budget Report D) Contributions In Aid of Construction (CIAC) Reports: Summary of total CIAC through April 30, 2024 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—Work in Progress Operating income is$1,278,026 (13%) over budget due to an unfavorable revenue and favorable expense variance. Operating revenue is$585,064 (2%) under budget and Operating expenses are$1,863,090 (7%) under budget. Itemized operating expense variances are in Section C. We gained 799 active (Residential 793, General Service 6)water accounts and 805 active sewer(788 Residential, General Service 17) accounts for the fiscal year 2023/2024 as compared to an increase of 524 active water accounts and an increase of 528 active sewer accounts for the same time in fiscal year 2022/2023. 1 CLAY COUNTY UTILITY AUTHORITY COMPARATIVE FINANCIAL STATEMENTS FISCAL YEAR 2023/2024 Section A CCUA Balance Sheet 08:53 PM 09/05/2024 Page 1 of 1 Period: FY2024-Apr Ledger Account Summary Current Year YTD Prior Year YTD Assets Cash 25,860,355.84 25,931,383.58 Investments 84,574,734.00 49,147,659.88 Accounts Receivable 6,628,431.19 4,460,800.30 Current Receivables 77,680.65 61,045.77 Other Current Assets 1,525,730.64 929,868.06 Inventory 665,559.55 712,175.40 Net Fixed Assets 349,490,787.90 308,115,088.48 Construction in Progress 130,962,913.02 64,903,750.47 Other Long-Term Assets 299,169.77 301,709.88 Deferred Outflow of Resources 1,369,309.48 1,575,898.56 Total Assets 601,454,672.04 456,139,380.38 Liabilities Current Liabilities 30,952,362.61 21,780,269.71 Long-Term Liabilities 178,401,176.06 80,518,569.94 Total Liabilities 209,353,538.67 102,298,839.65 Fund Balance Retained Earnings- Unreserved 62,657,550.17 57,795,484.23 Investment in Capital Assets 328,788,969.08 294,490,763.77 Total Fund Balance 391,446,519.25 352,286,248.00 Net of Revenues&Expenditures 654,614.12 1,554,292.73 Total Liabilities&Fund Balance 601,454,672.04 456,139,380.38 3 Page 1 of 3 CCUA Balance Sheet - Detail Period: FY2024-Apr Ledger Account Summary _ Current Year YTD Prior Year YTD Assets Cash 1000:Cash 25,567,410.64 25,929,381.83 1015:Cash in Transit 20,180.35 0.00 1016:Cash in Transit-Billing 269,858.94 0.00 1050:Petty Cash 2,905.91 2,001.75 Total Cash 25,860,355.84 25,931,383.58 Investments 1500:Investments 41,109,185.19 49,147,659.88 1501:Truist Escrow Investment Account 22,896,960.59 0.00 1502:Investments - LAMPA 20,568,588.22 0.00 Total Investments 84,574,734.00 49,147,659.88 Accounts Receivable 1100:Accounts Receivable W&S Cust 1,709,246.47 2,220,547.79 1101:Unbilled Receivables 4,837,421.49 912,161.85 1102:Accrued Accounts Receivable 0.00 986,521.85 1103:Accounts Receivable Unbilled Reuse Revenue 0.00 170,719.46 1104:A/R CIAC & Misc Repair Invs 272,712.09 391,453.16 1105:Accounts Receivable Clearing Account 2,705.69 (1,627.89) 1150:Allowance for Doubtful Accounts (193,654.55) (218,975.92) Total Accounts Receivable 6,628,431.19 4,460,800.30 Current Receivables 1620:Unused Postage 20,287.87 20,462.18 1630:Loans To Customers 57,392.78 40,583.59 Total Current Receivables 77,680.65 61,045.77 Other Current Assets 1160:Interest Receivable 258,302.84 145,724.79 1170:Prepaid Assets 1,267,427.80 770,964.44 1250:Other Receivable 0.00 13,178.83 Total Other Current Assets 1,525,730.64 929,868.06 Inventory 1600:Inventory 665,559.55 712,175.40 Total Inventory 665,559.55 712,175.40 Net Fixed Assets 1700:Buildings 15,240,674.68 11,016,436.58 1701:Intangible Assets 7,511,306.90 3,866,031.40 1702:Land 5,268,724.07 5,268,724.07 1703:Machinery& Equipment 528,601,185.91 480,426,672.37 1790:Accumulated Depreciation (206,949,481.76) (192,462,775.94) 1791:Accumulated Amortization (181,621.90) 0.00 Total Net Fixed Assets 349,490,787.90 308,115,088.48 Construction in Progress 1750:Construction in Progress 130,962,913.02 64,903,750.47 Total Construction in Progress 130,962,913.02 64,903,750.47 Other Long-Term Assets 1800:Loan to Customers_Long-term 299,169.77 301,709.88 Total Other Long-Term Assets 299,169.77 301,709.88 4 Page 2 of 3 CCUA Balance Sheet - Detail Period: FY2024-Apr _ Ledger Account Summary _ Current Year YTD Prior Year YTD Deferred Outflow of Resources 1200: Deferred Outflow of Resources 1,369,309.48 1,575,898.56 Total Deferred Outflow of Resources 1,369,309.48 1,575,898.56 Total Assets 601,454,672.04 456,139,380.38 Liabilities Current Liabilities 2000:Accounts Payable 10,557,828.74 6,912,901.86 2310:Retainage Payable 2,832,410.88 1,349,405.97 2005:Due to Eagle Harbor (13,791.00) 0.00 2011:Procurement Card Payable 40,145.79 0.00 2012:Expenses Payable 3,835.89 0.00 2014:Virtual Card Payable 2,058,976.30 0.00 2020:Accrued Electric Expense Due 129,063.77 131,366.93 2030:Accrued Interest 2,434,820.20 932,416.98 2280:Florida Unemployment/Abandoned Property (50.62) 20.27 2290:JAX Public Service Tax Collected 241.42 313.81 2100:Accrued Pension Due 0.00 87,736.98 2101:Accrued Sick and Vacation Payable 718,794.56 633,662.17 2102:Payroll Liabilities Payable 5,947.52 (4,971.57) 2103:Accrued Worker's Comp Insurance Due 0.00 21,671.04 2104:Accrued Wages Payable 0.00 243,707.69 2108:Employee FIT, FICA, Medicare Withholding 0.00 67,118.79 2109:Employee Fund Withheld 1,967.50 2,065.48 2060:Due to Lend a Helping Hand 879.69 567.75 2117:Net Payroll Payable 0.00 0.00 2118:Payroll Forward Accrual 505,902.69 0.00 2200:Bond Deposits 158,199.25 109,885.19 2210:Current Bond Principal Due 7,059,376.15 7,092,768.01 2220:Cleaning Water Deposits 152,342.60 140,404.43 2300:Refundable Development Agreements 8,380.16 6,643.19 2330:W&S Customer Deposits 4,135,804.30 3,712,705.06 2340:Keystone Public Service Tax (2,245.09) 53.04 9999:Cash Conversion Clearing 163,531.91 0.00 2240:Deferred Reuse Revenue 0.00 40,205.44 2250:Deferred Revenue Sewer 0.00 201,930.33 2260:Deferred Revenue Water 0.00 97,690.87 Total Current Liabilities 30,952,362.61 21,780,269.71 Long-Term Liabilities 2500:2012 BBVA Compass Loan 0.00 1,901,056.00 2501:2014 DEP Payable 572,492.80 672,181.46 2502:2018 Revenue Bonds Payable DEP 10,147,814.41 10,774,922.49 2504:Contra Current Bond Principal (7,059,376.15) (7,092,768.01) 2505:Dell Financing Lease 0.00 0.00 2506:SunTrust 2015 Adv Ref 2007 Bonds 31,575,245.00 33,133,178.00 2507:Suntrust 2019 Loan & Refinance 38,165,000.00 41,130,000.00 2508:2023 Truist Revenue Bond 75,000,000.00 0.00 2510:2024 Webster Revenue Bond 30,000,000.00 0.00 Total Long-Term Liabilities 178,401,176.06 80,518,569.94 5 Page 3 of 3 CCUA Balance Sheet - Detail Period: FY2024-Apr Ledger Account Summary Current Year YTD Prior Year YTD Total Liabilities 209,353,538.67 102,298,839.65 Fund Balance Retained Earnings - Unreserved 62,657,550.17 57,795,484.23 Investment in Capital Assets 2710:Grants 27,748,778.30 27,696,844.88 2720:AWS CIAC 9,215,019.33 8,018,809.12 2721:Debt Service Charges 1,853,389.04 1,506,372.70 2722:Fire Capacity Charges 2,211,831.82 2,103,720.00 2723:Sewer Capacity Charges 58,524,304.03 53,530,791.46 2724:Sewer Contributed Assets 133,891,594.46 116,892,984.66 2725:Sewer Main Extension Charge 6,099,309.17 5,180,559.91 2726:Sewer TAP in Charge 2,662,222.50 2,552,081.66 2727:SJRWMD Black Creek CIAC 1,509,169.29 1,140,681.67 2728:Water Capacity Charges 12,204,079.96 11,681,907.00 2729:Water Contributed Assets 66,756,886.60 58,463,161.06 2730:Water Main Extension Charge 3,571,560.73 3,284,467.28 2731:Water Tap in Charge 2,540,823.85 2,438,382.37 Total Investment in Capital Assets 328,788,969.08 294,490,763.77 Total Fund Balance 391,446,519.25 352,286,248.00 Net of Revenues & Expenditures 654,614.12 1,554,292.73 Total Liabilities & Fund Balance 601,454,672.04 456,139,380.38 6 CCUA Income Statement 08:23 AM 09/04/2024 Page 1 of 1 Period: FY2024-Apr Ledger Account Current Year YTD Prior Year YTD Revenue Water Revenues 15,404,731.19 14,149,596.71 Sewer Revenue 19,685,664.11 17,746,924.76 Miscellaneous Revenue 1,277,259.18 1,467,073.01 Interest Unrestricted 1,566,516.64 560,669.80 Sale of Assets 0 58,625.00 Construction Income 50,256.75 12,876.87 Total Revenue 37,984,427.87 33,995,766.15 Expenditures Salary&Benefits Salaries 8,492,109.43 7,641,665.75 Benefits 3,314,279.30 3,058,165.04 Project Labor Recovery (18,022.85) 0 Total Salary&Benefits 11,788,365.88 10,699,830.79 General&Administrative Expenditures Bad Debt (683.93) (3,485.09) Communications 248,161.09 231,604.02 Due in Lieu of Taxes 1,579,620.03 1,435,343.36 Electric& Fuel Expenses 1,591,222.74 1,819,510.89 Miscellaneous Expense 496,888.60 157,302.13 Property&Liability Insurance 1,136,004.01 633,146.59 Professional Services 484,263.18 732,179.89 Sludge Treatment& Disposal 1,683,259.82 1,556,727.41 Subcontractors 1,740,589.23 1,884,775.24 Supplies 4,212,402.13 3,692,092.44 Transportation 425,484.96 364,607.79 Depreciation 8,715,876.38 7,956,499.08 Amortization 181,621.90 0 Interest Expense 2,990,667.99 1,258,455.36 Construction Expense 15,769.74 22,883.52 Debt Issuance Costs 40,300.00 0 Total G&A Expenditures 25,541,447.87 21,741,642.63 Total Expenditures 37,329,813.75 32,441,473.42 Net of Revenue&Expenditures 654,614.12 1,554,292.73 7 CLAY COUNTY UTILITY AUTHORITY STATEMENTS OF CASH FLOWS FOR THE SEVEN MONTHS ENDED APRIL 30,2023 AND 2024 April 30,2024 April 30,2023 Cash flows from operating activities $ 10,815,439 $ 10,255,824 Net cash provided by operating activities 10,815,439 10,255,824 Cash flows from capital and related financing activities Proceeds from issuance of bonds and loans 30,000,000 - Principal paid on long-term debt (3,823,283) (3,861,283) Interest paid on long-term debt (1,894,242) (1,012,912) Payments to acquire and construct plant property (60,556,852) (22,199,385) Capital contributions 4,860,882 7,069,844 Grants 90,573 1,730,563 Net cash used in capital and related financing activities (31,322,922) (18,273,174) Cash flows from investing activities Purchases of investments (22,038,283) (519,677) Sales of investments 38,500,000 4,000,000 Interest income 1,566,517 560,670 Net cash provided by investing activities 18,028,234 4,040,992 Net increase(decrease)in cash and cash equivalents (2,479,250) (3,976,358) Cash and cash equivalents,beginning of period 28,049,566 29,907,741 Cash and cash equivalents,end of period $ 25,570,317 $ 25,931,384 Reconciliation of operating income to net cash provided by operating activities Cash flows from operating activities Operating income $ 2,078,765 $ 2,193,453 Adjustments to reconcile operating income to net cash provided by operating activities: Depreciation and Amortization expense 8,911,254 7,970,845 Changes in assets and liabilities Decrease(Increase)in notes and accounts receivable (2,154,179) 81,389 Decrease(Increase)in prepaid items and inventory (608,615) (568,272) Decrease(Increase)in interest receivable 51,800 14,853 Increase(Decrease)in accounts payable 2,496,687 912,845 Increase(Decrease)in accrued expenses 96,002 (288,795) Increase(Decrease)in unearned revenue (444,785) (162,869) Increase(Decrease)in customer deposits 388,509 102,375 Total adjustments 8,736,673 8,062,370 Net cash provided by operating activities $ 10,815,439 $ 10,255,824 Supplemental schedule of noncash investing,capital,and financing activities Utility plant property contributed by developers $ 17,271,539 $ 19,082,618 8 Cumulative Cash Flow $160,000,000 $140,000,000 $120,000,000 $100,000,000 $80,000,000 1 $60,000,000 $40,000,000 $20,000,000 —$0 — — — L� L L L L L L� 'L?' aJ �� �\ J� c f, 0`� fie, ��` �a� ke, 4ac Q�� aJ ��� ��\ J� c4e', Oe� �, e5 a� key fat Pit Cash •Investments CLAY COUNTY UTILITY AUTHORITY CASH AND CASH EQUIVALENTS REPORT As of April 30, 2024 Truist Ameris SBA Investments Total Lend A Helping Hand Fund $407 $407 Operating Accounts ** $7,012,688 $7,012,688 FSA Account $23,801 $23,801 Emergency Accounts $8,208 $8,208 Petty Cash $2,906 $2,906 Total Operating Funds $7,047,603 $7,047,603 Public Funds Now: Water Plant Connection Fund $724,324 * $724,324 R Water Line Connection Fund $488,827 * $488,827 R Sewer Plant Connection Fund $1,694,872 * $1,694,872 R Sewer Lines Connection Fund $76,921 * $76,921 R Alternative Water Supply Fund $1,080,035 * $1,080,035 R Renewal&Replacement Fund $593,988 * $593,988 R Debt Stabilization and Reserve Account_Unrestricted $1,100,894 * $1,100,894 Truist Escrow Investment Account $22,896,961 $22,896,961 R LAMPA Investment Account $20,568,588 $20,568,588 R Surplus Fund $1,743,154 $445,151 $114,716 $41,109,185 $43,412,206 Available For Construction $7,503,015 $445,151 $114,716 $84,574,734 $92,637,616 Debt Service Sinking Funds: 2015 Refunding Sinking Fund $5,683,245 * $5,683,245 R DEP Loan Debt Service Sinking Acct $61,129 * $61,129 R 2018 Bond Sinking Fund $236,241 * $236,241 R Debt Stabilization and Reserve Account_Restricted Letter of Credit_Financial Responsible Officer $102,436 $102,436 R Customer Deposits&Self Insurance Fund Customer Deposits $3,851,373 $3,851,373 R Self Insurance Fund Sewage Backups $500,000 $500,000 Unemployment $25,000 $25,000 TOTAL Funds $6,083,051 $4,376,373 - - $10,459,424 TOTAL CASH&CASH EQUIVALENTS $20,634,076 $4,821,524 $114,716 $84,574,734 $110,145,051 Investment Accounts Maturity Date Balance APY US Bank Various $41,109,185 2.56% US Bank-LAMPA Immediate $20,568,588 4.91% Truist Escrow Investment Account Monthly $22,896,961 3.55% $84,574,734 * BB&T Public Funds Money Checking Accounts $11,740,476 0.25% BB&T Public Funds Money Checking Accounts $7,012,688 0.25% Ameris Public Funds Money Checking Accounts $4,821,524 0.30% SBA $114,716 4.84% Construction Balance $92,637,616 Operating Cash $5,012,688 Available Construction Balance: $97,650,305 "R"indicates fund is Restricted by Bond Resolution,Enabling Legislation or Board Resolution. Section B Printed 9/4/2024 CLAY COUNTY UTILITY AUTHORITY BUDGET REPORTS FISCAL YEAR 2023/2024 Section C CCUA Operating Budget Report 09:56 AM 09/04/2024 Page 1 of 1 Organization: Fund: General Fund Plan Structure:Amended Budget by Period Time Period: Current Year Period: FY2024-Apr Ledger Account Budget Current Year YTD Available Balance %Budget Used Operating Revenues Water Revenues Water Base Charges 9,149,204.00 5,157,524.45 3,991,679.55 56.37% Water Use Charges 12,140,254.00 6,732,783.94 5,407,470.06 55.46% Reuse Water Base Charges 3,758,600.00 2,196,719.48 1,561,880.52 58.45% Reuse Water Use Charges 2,827,035.00 1,317,703.32 1,509,331.68 46.61% Total Water Revenues 27,875,093.00 15,404,731.19 12,470,361.81 55.26% Sewer Revenues Sewer Base Charges 18,609,426.00 10,361,802.41 8,247,623.59 55.68% Sewer Use Charges 15,452,807.00 9,323,861.70 6,128,945.30 60.34% Total Sewer Revenues 34,062,233.00 19,685,664.11 14,376,568.89 57.79% Miscellaneous Revenue 1,948,323.00 1,277,259.18 671,063.82 65.56% Total Operating Revenues 63,885,649.00 36,367,654.48 27,517,994.52 56.93% Interest Income 855,625.56 1,566,516.64 (710,891.08) 183.08% Operating Expenses Salary&Benefits Salaries&Wages 15,012,009.15 8,492,109.43 6,519,899.72 56.57% Employee Benefits 5,755,462.25 3,314,279.30 2,441,182.95 57.58% Project Labor Recovery 0 (18,022.85) 18,022.85 0.00% Bad Debt 500.00 (683.93) 1,183.93 (136.79%) Communications 445,190.00 248,161.09 197,028.91 55.74% Due in Lieu of Taxes 2,787,180.00 1,579,620.03 1,207,559.97 56.67% Electric& Fuel Expenses 3,424,866.00 1,591,222.74 1,833,643.26 46.46% Miscellaneous Expense 508,598.00 496,888.60 11,709.40 97.70% Property&Liability Insurance 1,805,580.00 1,136,004.01 669,575.99 62.92% Professional Services 1,372,573.24 484,263.18 888,310.06 35.28% Sludge Treatment& Disposal 2,805,750.00 1,683,259.82 1,122,490.18 59.99% Subcontractors 5,266,250.56 1,740,589.23 3,525,661.33 33.05% Supplies 6,234,596.64 4,212,402.13 2,022,194.51 67.57% Transportation 760,940.00 425,484.96 335,455.04 55.92% Total Operating Expenses 46,179,495.84 25,385,577.74 20,793,918.10 54.97% Non-Operating Expenses Depreciation 13,615,661.00 8,715,876.38 4,899,784.62 64.01% Amortization 0 181,621.90 (181,621.90) 0.00% Interest Expense 2,914,754.00 2,990,667.99 (75,913.99) 102.60% Sale of Assets 0 0 0.00 0.00% Debt Issuance Costs 0 40,300.00 (40,300.00) 0.00% Total Non-Operating Expenses 16,530,415.00 11,928,466.27 4,601,948.73 72.16% Construction Income 526,841.00 50,256.75 476,584.25 9.54% Construction Expense 158,955.00 15,769.74 143,185.26 9.92% Contingency 775,383.00 0 775,383.00 0.00% Net of Revenue,tip Fxpenditures 1,691,866 79 R54,R14 19 969252 60 40.31% 12 CCUA Operating Expense Report 10:11 AM 09/04/2024 Page 1 of 2 Organization: Fund: General Fund Plan Structure:Amended Budget by Period Time Period: Current Year Period: FY2024-Apr Ledger Account Budget Current Year YTD Available Balance % Budget Used SALARIES&WAGES Accrued wages 0 (359,238.85) 359,238.85 0.00% Capitalized Wages 0 (16,790.83) 16,790.83 0.00% Emergency Pay 0 9,102.78 (9,102.78) 0.00% Overtime Wages 670,966.84 393,170.23 277,796.61 58.60% Wages Hourly 9,101,666.55 4,353,802.13 4,747,864.42 47.84% Wages Salary 5,239,375.76 2,989,874.88 2,249,500.88 57.07% (Blank) 0 1,122,189.09 (1,122,189.09) 0.00% SUBTOTAL 15,012,009.15 8,492,109.43 6,519,899.72 56.57% EMPLOYEE BENEFITS Employee Health and Life Insurance 2,889,805.53 1,492,245.17 1,397,560.36 51.64% Employee Retirement and Benefits 1,536,295.62 725,748.71 810,546.91 47.24% Employer Fica Payroll Taxes 1,077,965.81 488,173.99 589,791.82 45.29% Job Pension Expense 0 35,606.77 (35,606.77) 0.00% Wellness 50,000.00 19,311.23 30,688.77 38.62% Workers Comp Insurance 201,395.29 102,212.70 99,182.59 50.75% (Blank) 0 450,980.73 (450,980.73) 0.00% SUBTOTAL 5,755,462.25 3,314,279.30 2,441,182.95 57.58% PROJECT LABOR RECOVERY Employee Health and Life Insurance 0 (3,122.77) 3,122.77 0.00% Employer Fica Payroll Taxes 0 (936.16) 936.16 0.00% Job Pension Expense 0 (958.04) 958.04 0.00% Wages Salary 0 (12,747.89) 12,747.89 0.00% Workers Comp Insurance 0 (257.99) 257.99 0.00% SUBTOTAL 0 (18,022.85) 18,022.85 0.00% BAD DEBT Bad Debt Expense 500.00 (683.93) 1,183.93 (136.79%) SUBTOTAL 500.00 (683.93) 1,183.93 (136.79%) COMMUNICATIONS Communication Expenses 445,190.00 248,161.09 197,028.91 55.74% SUBTOTAL 445,190.00 248,161.09 197,028.91 55.74% DUE IN LIEU OF TAXES Due in Lieu of Taxes 2,787,180.00 1,579,620.03 1,207,559.97 56.67% SUBTOTAL 2,787,180.00 1,579,620.03 1,207,559.97 56.67% ELECTRIC&FUEL EXPENSES Electric and Fuel 3,424,866.00 1,591,222.74 1,833,643.26 46.46% SUBTOTAL 3,424,866.00 1,591,222.74 1,833,643.26 46.46% MISCELLANEOUS EXPENSE Advertising Expense 76,137.00 13,718.92 62,418.08 18.02% Bank Fees 57,625.00 26,587.17 31,037.83 46.14% Miscellaneous Expense 312,069.00 440,139.25 (128,070.25) 141.04% Rental Expense 62,767.00 16,443.26 46,323.74 26.20% SUBTOTAL 508,598.00 496,888.60 11,709.40 97.70% PROPERTY&LIABILITY INSURANCE Property Insurance 1,805,580.00 1,126,879.90 678,700.10 62.41% Property Insurance-Construction 0 9,124.11 (9,124.11) 0.00% SUBTOTAL 1,805,580.00 1,136,004.01 669,575.99 62.92% PROFESSIONAL SERVICES Accounting Audit Expense 34,500.00 27,500.00 7,000.00 79.71% Employee Training and Travel 359,879.00 96,032.87 263,846.13 26.68% 13 CCUA Operating Expense Report 10:11 AM 09/04/2024 Page 2 of 2 Ledger Account Budget Current Year YTD Available Balance % Budget Used Engineering Expense 265,000.00 184,555.87 80,444.13 69.64% Legal Expenses 661,000.00 146,659.84 514,340.16 22.19% Salaries for Board Members 52,194.24 29,514.60 22,679.64 56.55% SUBTOTAL 1,372,573.24 484,263.18 888,310.06 35.28% SLUDGE TREATMENT& DISPOSAL Sludge Removal 2,220,000.00 1,358,976.32 861,023.68 61.22% Sludge Treatment 585,750.00 324,283.50 261,466.50 55.36% SUBTOTAL 2,805,750.00 1,683,259.82 1,122,490.18 59.99% SUBCONTRACTORS Subcontractors 4,757,128.56 1,516,662.39 3,240,466.17 31.88% Subcontractors Testing 350,000.00 131,334.61 218,665.39 37.52% Trash Service 159,122.00 92,592.23 66,529.77 58.19% SUBTOTAL 5,266,250.56 1,740,589.23 3,525,661.33 33.05% SUPPLIES Brass Fittings 0 26,315.97 (26,315.97) 0.00% Chemicals 1,243,000.00 1,031,236.38 211,763.62 82.96% Furniture 15,150.00 264.88 14,885.12 1.75% Inventory 0 0.00 0.00 0.00% Software 1,516,844.93 548,145.62 968,699.31 36.14% Supplies Field 2,847,084.71 2,329,824.92 517,259.79 81.83% Supplies Office 599,817.00 268,814.07 331,002.93 44.82% Tools and Supplies 12,700.00 7,800.29 4,899.71 61.42% SUBTOTAL 6,234,596.64 4,212,402.13 2,022,194.51 67.57% TRANSPORTATION Fleet Repair and Maintenance 0 136,438.62 (136,438.62) 0.00% Transportation Expenses 760,940.00 289,046.34 471,893.66 37.99% SUBTOTAL 760,940.00 425,484.96 335,455.04 55.92% Total Operating Expenses 46,179,495.84 25,385,577.74 20,793,918.10 54.97% 14 CLAY COUNTY UTILITY AUTHORITY CIAC REPORTS FISCAL YEAR 2023/2024 Section D CCUA CIAC Report 09:20 AM 09/05/2024 Page 1 of 1 Period: FY2024-Apr Ledger Account Beginning Year Balance Activity for the Month Year To Date Ending Balance Contributions in Aid of Construction Grants 27,658,205.44 0 90,572.86 27,748,778.30 Water Capacity Charges 11,856,865.36 96,091.74 347,214.60 12,204,079.96 Sewer Capacity Charges 55,213,975.78 887,190.51 3,310,328.25 58,524,304.03 Fire Capacity Charges 2,132,781.82 15,810.00 79,050.00 2,211,831.82 Alternative Water Supply Charge 8,498,767.35 126,491.82 716,251.98 9,215,019.33 SJRWMD Black Creek Charge 1,445,756.11 14,993.49 63,413.18 1,509,169.29 Debt Service Charge 1,720,422.96 4,304.60 132,966.08 1,853,389.04 Water Tap-In Charge 2,479,403.92 6,460.59 61,419.93 2,540,823.85 Sewer Tap-In Charge 2,605,628.70 0 56,593.80 2,662,222.50 Water Main Extension Charge 3,547,145.50 767.26 24,415.23 3,571,560.73 Sewer Main Extension Charge 6,030,080.52 1,286.35 69,228.65 6,099,309.17 Water Contributed Assets 61,270,367.19 0 5,486,519.41 66,756,886.60 Sewer Contributed Assets 122,106,574.49 0 11,785,019.97 133,891,594.46 Total Contributions in Aid of 306,565,975.14 1,153,396.36 22,222,993.94 328,788,969.08 Construction 16 CLAY COUNTY UTILITY AUTHORITY 2023/2024 Alternative Water Supply Surcharges Beginning October November December January February March April May June July August September Balance Established 10/1/2015 Balance 2023 2023 2023 2024 2024 2024 2024 2024 2024 2024 2024 2024 9/30/2024 Expenditures: Job 991 FCOB Stormwater Harvesting Pilot Project 883,128.55 883,128.55 Stormwater Harvesting Study 49,842.66 49,842.66 Job 00119WP Aquifer Storage&Recovery(ASR) 1,580,081.04 1,580,081.04 Project Development Advisor 212,388.00 212,388.00 Horizontal Well Feasibility Study 38,788.00 38,788.00 Aquifer Recharge Feasibility Study&Siting 138,059.36 138,059.36 Lake Agresti Reservoir Feasibility Study 5,798.00 5,798.00 Job 20022WL Treatability Pilot Project-AWS Development 3,343,971.00 520,551.78 590,728.56 249,458.91 201,618.69 211,249.70 131,777.30 160,836.58 5,410,192.52 New Development: - Total Expenditures 6,252,056.61 520,551.78 590,728.56 249,458.91 201,618.69 211,249.70 131,777.30 160,836.58 0.00 0.00 0.00 0.00 0.00 8,318,278.13 Existing Customers: Revenue: Surcharge Fund(Existing Customers) 4,816,047.72 59,942.60 61,597.18 61,691.58 61,874.48 61,909.88 61,925.22 62,027.88 5,247,016.54 Connection Charge Fund(Growth) 3,556,606.86 88,008.65 101,083.96 8,912.93 16,301.14 29,876.78 40,802.51 108,593.05 3,950,185.88 Interest Income 40,273.79 40,273.79 Total Revenue 8,412,928.37 147,951.25 162,681.14 70,604.51 78,175.62 91,786.66 102,727.73 170,620.93 0.00 0.00 0.00 0.00 0.00 9,237,476.21 Balance 2,160,871.76 (372,600.53)(428,047.42) (178,854.40) (123,443.07) (119,463.04) (29,049.57) 9,784.35 0.00 0.00 0.00 0.00 0.00 919,198.08 Cash Balance 1,080,034.66 Done in following Month: Less Construction Costs transferred after month close (160,836.58) J/E-Adjustment True Up for Move-Ins/Move-Outs J/E-Interfund Transfer 919,198.08 Page D-la 17 CLAY COUNTY UTILITY AUTHORITY CAPITAL PROJECT BUDGET REPORT FISCAL YEAR 2023/2024 Section E 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 Balances and Year Job Costs Job Description 1Project Phase Job Number Budget Adopted Budget Budgets Amendments 04/30/24 To Fund Amendments 2023/2024 RENEWAL,REPLACEMENT&BETTERMENT Departmental Capital 100 1,202,917.71 1,275,500.00 2,478,417.71 377,078.67 2,101,339.04 2,478,417.71 Upgrade Lift station 9-Meadowbrook Design 755 93,844.52 6,155.48 100,000.00 8,365.93 91,634.07 100,000.00 Rehab SP WW Clarifer#1/under drain 1-2 Construction 02519RR 1,549,176.20 0.00 1,549,176.20 1,436,025.38 113,150.82 1,549,176.20 Ridgecrest WTP-Replace Softstart&Crossline Starters with VFD's Construction 20021RR 2,011,228.00 0.00 2,011,228.00 2,017,268.39 (6,040.39) 2,011,228.00 Fleming Island Reg.WWTP-2nd BCR Plant,Two Tanks Construction 21010RR 7,200,000.00 1,680,000.00 8,880,000.00 5,506,556.96 3,373,443.04 8,880,000.00 Lift Station#2&#3 Upgrade Construction 21016RR 3,834,146.16 900,000.00 4,734,146.16 1,965,853.84 1,100,505.08 5,599,494.92 7 6,700,000.00 Ridaught WWTP Upgrades(Install Micro-screen,Grit Removal Equipmer Construction 21019RR 2,887,000.00 1,185,000.00 4,072,000.00 3,545,787.90 526,212.10 4,072,000.00 Meadowbrook WTP Upgrades-(GST#3 repair,Transfer switch,GST#2 Design 21029RR 2,082,308.00 2,517,692.00 4,600,000.00 544,735.91 4,055,264.09 4,600,000.00 Ridaught WTP-Phase I GST Upgrades Design 22007RR 54,103.26 54,103.26 54,103.26 0.00 54,103.26 Lift Station#4 Upgrades Design 22008RR 800,000.00 400,000.00 1,200,000.00 46,443.91 1,153,556.09 1,200,000.00 Lift Station#62 and#67-Rehabilitation Design 22009RR 320,000.00 900,000.00 1,220,000.00 76,869.25 1,143,130.75 1,220,000.00 Miller WRF Electrical Upgrades&WWTP Upgrades Design 23004RR 155,005.00 81,000.00 236,005.00 191,194.07 44,810.93 236,005.00 Spencers WTP-Ground Storage&High Service Pump&Electrical Upgr Design 23005RR 237,848.00 3,000,000.00 3,237,848.00 297,829.82 2,940,018.18 3,237,848.00 Pace Island&Fleming Oaks WTP Electrical Upgrades Design 23007RR 192,107.00 250,000.00 442,107.00 119,113.39 322,993.61 442,107.00 SCADA System Design 23008RR 250,000.00 250,000.00 500,000.00 48,500.00 451,500.00 500,000.00 Fleming island WRF electrical upgrades Nault upgrades Design 23009RR 296,171.00 1,786,190.00 2,082,361.00 279,125.39 1,803,235.61 2,082,361.00 ERP Software Replacement Construction 23010RR 2,843,782.00 1,622,922.00 4,466,704.00 4,388,745.99 77,958.01 4,466,704.00 Upgrade Lift Stations 11,41,69,51 Design 23012RR 158,092.80 500,000.00 658,092.80 194,756.52 463,336.28 658,092.80 Sandridge Road widening from Henley to CR 209 and ForceMain Extensis Construction 23015SL 2,040,000.00 2,040,000.00 1,541,500.24 498,499.76 2,040,000.00 Gravity Sewer Lining Construction 24005RR 406,692.68 1,000,000.00 1,406,692.68 349,945.40 1,056,747.28 1,406,692.68 Keystone Heights-Lakeside Street/Hilltop Street Water Main Rehabilitatii Design 23024RR 237,600.00 237,600.00 21,600.00 216,000.00 237,600.00 Mid-Clay Entrance Road Stabilization Design 23025RR 50,000.00 50,000.00 30,052.31 19,947.69 50,000.00 Mid-Clay WRF Alternate Driveway Design 23028RR 1,200,000.00 1,200,000.00 51,764.48 1,148,235.52 1,200,000.00 Water Plant Meters Retrofits Construction 23029RR 108,000.00 300,000.00 408,000.00 176,476.73 231,523.27 408,000.00 FH and Gate Valve replacement Construction 24008RR 105,000.00 210,000.00 315,000.00 318.16 314,681.84 315,000.00 Potable and Reclaimed Water Meter and backflow device replacement Construction 23003RR 0.00 1,600,000.00 1,600,000.00 945,270.36 654,729.64 1,600,000.00 Lake Asbury WM Improvements(602 Lake Asbury Road&Aldersgate Si Construction 23030RR 1,530,000.00 1,530,000.00 74,548.52 1,455,451.48 1,530,000.00 Southern Baptist Hospital of Florida/cost participationw/development Construction 24001RR 0.00 195,435.28 195,435.28 0.00 1 195,435.28 Keystone Wastewater Treatment Plant-Phase II Construction Construction 24007SP 0.00 500,000.00 500,000.00 62,882.16 437,117.84 500,000.00 Upgrade Lift Station 20 Design 24003RR 0.00 0.00 125,000.00 18,248.63 106,751.37 2 125,000.00 SYSTEM EXPANSION Meadow Lake WTP-New Ground Storage Tank and Electrical Service upl Construction 00983WP 3,149,124.00 3,149,124.00 3,130,923.57 18,200.43 3,149,124.00 Henley Road 12"WM Loop-Sandridge to Small Lake Construction 01119 WL 11,258.64 94,758.06 106,016.70 11,258.64 94,758.06 106,016.70 North Middleburg Water&Sewer Extension and Interconnection(Water I Construction 02419WL 560,554.67 2,750,000.00 3,310,554.67 506,439.51 2,804,115.16 3,310,554.67 Saratoga Springs WTP-Phase I Construction 03018WP 16,591,000.00 16,591,000.00 16,850,478.47 (259,478.47) 16,591,000.00 CCUA Administrative Building Phase I Construction 21013AD 5,125,089.00 100,000.00 5,225,089.00 2,509,799.59 2,715,289.41 5,225,089.00 Swimming Penn Creek WM Interconnect Construction 21020WL 2,250,000.00 1,810,000.00 4,060,000.00 2,600,000.00 1,653,672.88 5,006,327.12 6 6,660,000.00 Ravines to Henly Road Water Main Extension Construction 21023WL 2,250,000.00 2,400,000.00 4,650,000.00 1,486,187.02 3,163,812.98 4,650,000.00 Governor's Park WTP Design and Build Construction 21026WP 5,125,000.00 4,250,000.00 9,375,000.00 625,000.00 4,446,629.12 5,553,370.88 5 10,000,000.00 Peters Creek WTP 2nd GST&3rd Well Design 21030WP 267,547.26 267,547.26 267,547.26 (0.00) 267,547.26 Peters Creek New Regional WRF Construction 22003SP 46,523,968.83 41,600,000.00 88,123,968.83 59,802,918.94 28,321,049.89 88,123,968.83 CCUA North Campus Driveway Design 22010AD 786,341.00 786,341.00 149,506.35 636,834.65 786,341.00 LAMPA E/W Interconnect#1 Water(Cathedral Oaks West-Green) Construction 22012WL 1,000,000.00 2,112,000.00 3,112,000.00 3,002,458.26 109,541.74 3,112,000.00 LAMPA E/W Interconnect#1 Wwtr-Reuse(Cathedral Oaks West-Gre Construction 22013SL 2,000,000.00 4,337,000.00 6,337,000.00 6,155,442.19 181,557.81 6,337,000.00 LAMPA E/W Interconnect#2 Water (Cathedral Oaks East-Blue) Design 22014WL 28,105.29 28,105.29 28,105.29 (0.00) 28,105.29 LAMPA E/W Interconnect#2 Wwtr-Reuse(Cathedral Oaks East-Blue;Design 22015SL 57,964.36 57,964.36 57,964.36 0.00 57,964.36 LAMPA N/S Interconnect#1 Water(SS WTP to Cathedral Oaks West-I Design 22016WL 17,319.95 17,319.95 17,319.95 0.00 17,319.95 LAMPA N/S Interconnect#1 Wwtr-Reuse(SS WTP to Cathedral Oaks Design 22017SL 35,189.76 35,189.76 39,145.26 (3,955.50) 35,189.76 LAMPA N/S Interconnect#2 Water(Feed Mill Rd.-Black) Design 22018WL 10,298.93 10,298.93 10,298.93 (0.00) 10,298.93 LAMPA N/S Interconnect#2 Wwtr-Reuse (Feed Mill Rd.-Black) Design 22019SL 20,915.03 20,915.03 20,915.03 0.00 20,915.03 Postmaster WTP Electrical Upgrades Construction 23001WP 181,657.00 181,657.00 136,244.95 45,412.05 181,657.00 Upsize Mains-Double Branch Cost Share Construction 23018WL 316,169.64 316,169.64 316,169.64 0.00 316,169.64 Knight Boxx/Old Jennings Force Main Extension and Lift Station 56 Design 23019SL 134,978.00 1,465,022.00 1,600,000.00 35,047.46 1,564,952.54 1,600,000.00 Water Service to 3255 Bliss Rd. Construction 23020WL 91,790.21 91,790.21 103,815.71 (12,025.50) 91,790.21 19 X:\Finance\Controllers Folder\Monthly Financial\Monthly Construction Reports\2023-2024\CIP_2024_April.xlsx Page 1 of 2 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 Balances and Year Job Costs Job Description Project Phase Job Number Budget Adopted Budget Budgets Amendments 04/30/24 To Fund Amendments 2023/2024 Upsizing Mains fro Bradley Creek to Russell Retreat Construction 23021WL 394,236.58 394,236.58 354,229.37 40,007.21 394,236.58 Water Service to 461 Creighton Rd. Construction 23022WL 71,520.73 71,520.73 71,955.32 (434.59) 71,520.73 Home Depot-Lowes Interconnect Construction 23026WL 23,664.53 23,664.53 22,465.48 1,199.05 23,664.53 Water Service to 879 Creighton Rd. Construction 23027WL 25,000.00 25,000.00 22,863.76 2,136.24 25,000.00 Water Service to 646 Harrison Rd. Construction 24002WL 0.00 0.00 28,000.00 21,555.64 6,444.36 9 28,000.00 Engineering Cost Allocation Construction 9999999 0.00 0.00 198,715.09 (198,715.09) 0.00 CR 218 widening from Pine Tree Lane to Cosmos Construction 22020RR 675,000.00 675,000.00 1,331,879.47 424,394.80 1,582,484.67 8 2,006,879.47 Sugar Leaf Farms/cost participation w/development Construction 24004SL 0.00 260,834.63 260,834.63 0.00 3 260,834.63 Jeremy Hollow Subdivision/cost participation w/development Construction 24006WL 0.00 16,487.20 16,487.20 0.00 4 16,487.20 ALTERNATIVE WATER SUPPLY Purified Water Pilot Study Construction 20022WL 4,769,000.00 2,000,000.00 6,769,000.00 5,553,067.41 1,215,932.59 6,769,000.00 Subtotals 122,807,715.74 84,413,239.54 207,220,955.28 7,148,490.42 131,385,905.17 82,983,540.53 214,369,445.70 Contingency 15,314,551.76 15,314,551.76 (6,550,733.31) 5-9 8,763,818.45 TOTAL CAPITAL EXPENDITURES 222,535,507.04 597,757.11 223,133,264.15 Construction In Progress 207,220,955.28 130,962,913.02 Not Started 14,957,791.19 Completed Jobs 422,992.15 Started 208,175,472.96 131,385,905.17 223,133,264.15 20 X:\Finance\Controllers Folder\Monthly Financial\Monthly Construction Reports\2023-2024\CIP_2024_April.xlsx Page 2 of 2 CLAY COUNTY UTILITY AUTHORITY OPERATING DETAIL BY MONTH FISCAL YEAR 2023/2024 Section F 21 CCUA Operating Revenue Budget Report 10:46 AM 09/05/2024 Page 1 of 1 Organization: Fund: General Fund Plan Structure:Amended Budget by Period Time Period: Current Year Period: FY2024-Apr Revenue by Category FY2024-Sep(YE_Sep) Current Month Current Year YTD % Budget Budget Used Water Base Charges Commercial Potable Irrigation Base 299,078.00 17,266.45 134,012.43 44.81% General Service Water Base 1,434,056.00 101,990.45 798,538.91 55.68% Residential Water Base Charges 7,416,070.00 554,655.29 4,224,973.11 56.97% SUBTOTAL 9,149,204.00 673,912.19 5,157,524.45 56.37% Water Usage Charges Commercial Potable Irrigation Usage 678,133.00 55,909.03 345,386.18 50.93% Commercial Water Usage 2,633,109.00 248,392.93 1,500,126.60 56.97% General Service Water Usage 0 0.00 0.00 0.00% Residential Water Usage 8,829,012.00 996,058.07 4,887,271.16 55.35% Residential Water Usage Charge 0 0.00 0.00 0.00% SUBTOTAL 12,140,254.00 1,300,360.03 6,732,783.94 55.46% Reuse Base Charges Reuse Commercial Base 337,285.00 29,310.53 191,107.47 56.66% Reuse Residential Base 3,421,315.00 288,102.99 2,005,612.01 58.62% SUBTOTAL 3,758,600.00 317,413.52 2,196,719.48 58.45% Reuse Usage Charges Crossings Reclaimed Water Charges 137,302.00 16,916.99 84,775.95 61.74% Reuse Commercial Usage 472,535.00 50,171.60 196,163.24 41.51% Reuse Residential Usage 2,217,198.00 256,097.98 1,036,764.13 46.76% SUBTOTAL 2,827,035.00 323,186.57 1,317,703.32 46.61% Total Water Revenues 27,875,093.00 2,614,872.31 15,404,731.19 55.26% Sewer Base Charges General Service Sewer Base 2,598,137.00 215,994.26 1,650,595.05 63.53% Residential Sewer Base Charge 16,011,289.00 840,272.38 8,711,207.36 54.41% SUBTOTAL 18,609,426.00 1,056,266.64 10,361,802.41 55.68% Sewer Usage Charges General Service Sewer Usage 3,718,832.00 381,807.09 2,302,879.10 61.92% Portalet Sewage Revenue 192,000.00 0 103,071.67 53.68% Residential Sewer Usage Charge 11,541,975.00 1,564,138.28 6,917,910.93 59.94% SUBTOTAL 15,452,807.00 1,945,945.37 9,323,861.70 60.34% Total Sewer Revenues 34,062,233.00 3,002,212.01 19,685,664.11 57.79% Total Base&Usage Charges 61,937,326.00 5,617,084.32 35,090.395.30 56.65% Miscellaneous Revenue Asbuilt Drawing Revenue 44,537.00 560.00 18,579.55 41.72% Cut for Non Pay Service Charge 131,405.00 0 62,505.00 47.57% Guaranteed Revenue 4,544.00 0 2,983.50 65.66% Meter Installation Fee 868,500.00 104,137.33 554,135.74 63.80% Miscellaneous Repair Charges 11,997.00 0 10,169.23 84.76% Miscellaneous Revenue 0 56,890.14 133,074.27 0.00% Miscellaneous Service Charge 318,232.00 37,269.07 207,599.07 65.24% New Construction Inspection Charge 99,222.00 1,526.66 29,828.03 30.06% New Customer Service Charge 315,550.00 21,120.00 159,690.00 50.61% Plan Review Charge 44,964.00 2,260.31 22,281.00 49.55% Returned Check Service Charge 53,680.00 5,023.79 37,093.79 69.10% Trip Service Charge 42,219.00 12,690.00 31,620.00 74.90% Water-Sewer Line Permitting Revenue 13,473.00 1,960.00 7,700.00 57.15% SUBTOTAL 1,948,323.00 243,437.30 1,277,259.18 65.56% Total Operating Revenues 63,885,649.00 5,860,591 69 36,367,654.48 56 93% 22 Budgeted vs. Actual - Base & Use Charges, Total 35,000,000 30,000,000 25,000,000 20,000,000 15,000,000 4 10,000,000 I 5,000,000 — 0 ihlIl 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 $6,000,000 $5,000,000 $4,000,000 _ _ 4 $3,000,000 $2,000,000 IpIlI__I _ _ _ _ $1,000,000 $0 October November December January February March April May June July August September Actual Optg Rev ♦Prior Year Optg Rev ♦Budgeted Optg Rev Operating Net Income $3,000,000 $2,500,000 lei $2,000,000 $1,500,000 111 $1,000,000 $500,000 $0 October November December January February March April May June July August September Actual Net Income — Prior Year Net Income Budgeted Net Income