Loading...
HomeMy WebLinkAbout2020-01-27-D01_4 - Storm WaterCITY OF WAUKEE, IOWAStormwater Enterprise FundBudgetBudgetProjectedProjectedProjectedProjectedProjectedFY 2019-20 FY 2020-21 FY 2021-22 FY 2022-23 FY 2023-24 FY 2024-25 FY 2025-26 Average Residential Multiplier17,696 7,927 8,165 8,410 8,662 8,922 9,189Average Commercial Multiplier25,635 5,748 5,863 5,980 6,100 6,221 6,346Average $$ Per Res. ERU/Mo. 3 $6.10 $6.35 $6.35 $6.61 $6.61 $6.86 $6.86Average $$ Per Com. ERU./Mo. 4 $6.00 $6.25 $6.25 $6.50 $6.50 $6.76 $6.76Increase per Monthly Bill 5 $0.00 $0.25 $0.00 $0.25 $0.00 $0.25 $0.00Operating RevenuesResidential Fees6$563,380 $604,460 $622,593 $666,922 $686,930 $734,751 $756,793Commercial Fees7406,027 431,404 440,032 466,786 476,122 504,323 514,409Residential- Compliance Fees850,000 50,000 50,000 50,000 50,000 50,000 50,000Commercial- Compliance Fees910,000 10,000 10,000 10,000 10,000 10,000 10,000License, Permits, Fees10850850850850850850850Total Operating Revenues 11$1,030,257 $1,096,714 $1,123,476 $1,194,558 $1,223,902 $1,299,924 $1,332,053Operating ExpensesPersonnel12$511,488 $537,062 $563,916 $592,111 $621,717 $652,803 $685,443Repairs & Maintenance1361,750 64,838 68,079 71,483 75,058 78,810 82,751Public Works1413,378 14,047 14,749 15,487 16,261 17,074 17,928Contractual15183,991 193,191 202,850 212,993 223,642 234,824 246,566Depreciation1683,80483,80483,80483,80483,80483,80483,804Total Operating Expense 17$854,411 $892,941 $933,398 $975,878 $1,020,482 $1,067,316 $1,116,491Net Operating Income 18$175,846 $203,773 $190,078 $218,680 $203,420 $232,608 $215,562Interest Income1916,000 10,890 7,681 7,350 6,586 6,134 5,191Depreciation2083,80483,80483,80483,80483,80483,80483,804Net Revenue for Debt Service 21$275,650 $298,467 $281,562 $309,834 $293,810 $322,546 $304,557Total Revenue Debt Service 22$67,860 $72,020 $71,045 $70,005 $68,900 $72,730 $71,400Debt Service Coverage- Revenue Debt Only234.06 4.14 3.96 4.43 4.26 4.43 4.27Total G.O. Debt Paid By Stormwater24$179,131 $173,881 $173,631 $174,231 $174,631 $176,031 $177,125Debt Service Coverage- All Debt251.12 1.21 1.15 1.27 1.21 1.30 1.23Prepared by PFM Financial Advisors LLC Page 1 of 21/20/2020 CITY OF WAUKEE, IOWAStormwater Enterprise FundBudgetBudgetProjectedProjectedProjectedProjectedProjectedFY 2019-20 FY 2020-21 FY 2021-22 FY 2022-23 FY 2023-24 FY 2024-25 FY 2025-26Cashflow after Debt Service 26$28,659 $52,566 $36,886 $65,598 $50,279 $73,785 $56,032Capital Outlays27($844,155) ($1,573,500) ($70,000) ($142,000) ($95,500) ($168,000) ($75,000)Bond Proceeds280000000SRF Bond Proceeds29400,000 600,00000000Miscellaneous300000000Transfers (to)/from Other Funds31524,988600,1023759(415)20,7090Annual Surplus/ (Deficit) 32$109,492($320,832) ($33,077) ($76,343)($45,636) ($73,506) ($18,968)Beg. Operating Cash Balance 33$956,658 $1,066,151 $745,318 $712,241 $635,898 $590,262 $516,755Ending Operating Cash Balance 34$1,066,151 $745,318 $712,241 $635,898 $590,262 $516,755 $497,787Cash Balance as % of O & M35125% 83% 76% 65% 58% 48% 45%Restricted/Designated Cash 36$22,874 $22,772 $22,735 $22,676 $23,091 $2,382 $2,382Total Cash 37$1,089,024 $768,090 $734,976 $658,574 $613,353 $519,137 $500,169Capital Improvement ProjectsOther Capital Equipment/Vehicles3813,000Library BioRetention & Bioswale39800,000 1,200,000Vehicles40248,500 45,000 17,000 70,500 43,000 50,000Annual Sump Pump Line Project41100,000 100,000 100,000Annual Improvements4231,15525,00025,00025,00025,00025,00025,000Total43844,155 1,573,500 70,000 142,000 95,500 168,000 75,0001-Jul-190.00%1-Jul-230.00%1-Jul-204.17%1-Jul-243.85%1-Jul-210.00%1-Jul-250.00%1-Jul-224.00%STORMWATER REVENUE ADJUSTMENTSPrepared by PFM Financial Advisors LLC Page 2 of 21/20/2020