WS - D - Tiffin Water Study $15 Base Rate & 50-50 Increase Summary

City of Tiffin Water Enterprise Fund Cash Basis Cash Flow Analysis Rate increase Option 2 - cash flow analysis Audited Audited Audited 2% 2% Historical Projection Rate and Usage Information FY 2022 FY 2023 FY 2024 FY 2025 FY 2026 FY 2027 FY 2028 FY 2029 FY 2030 Number of Meters Res 2,700 2,813 3,080 3,400 3,570 3,749 3,936 4,133 4,339 Rate per 1,000 $5.50 $5.50 $5.50 $5.50 $7.18 $8.87 $10.55 $10.76 $10.98 Minimum Bill Per Gallons $7.00 $7.00 $7.00 $7.00 $9.15 $11.30 $13.45 $13.72 $13.99 Total Water Gallons Sold 150,000,000 157,500,000 165,375,000 173,643,750 182,325,938 191,442,234 Operating Revenues Total Operating Revenues 1,134,566 1,194,464 1,297,345 1,272,236 1,729,741 2,217,571 2,749,860 2,942,790 3,149,303 Operating Expenditures Total Operating Expenditures 954,252 837,767 949,823 1,200,000 1,284,000 1,373,880 1,470,052 1,572,955 1,683,062 Non Operating Total Non-Operating - - 177,907 5,000 5,000 5,000 5,000 5,000 5,000 Revenue for Debt Service 180,314 356,697 525,429 77,236 450,741 848,691 1,284,808 1,374,835 1,471,241 2025 Water Rev - $14.308M SRF 20 Year 3.09% - 400,000 744,000 1,032,000 1,032,000 1,032,000 2003 Water SRF - PD Off 2023 22,880 22,440 Total Parity Debt 22,880 22,440 - - 400,000 744,000 1,032,000 1,032,000 1,032,000 2020 GO - Water portion paid off in FY2032 - Well 113,400 111,500 111,500 111,500 111,500 111,500 111,500 Total Combined WaterDebt 22,880 22,440 113,400 111,500 511,500 855,500 1,143,500 1,143,500 1,143,500 D/S Coverage - Parity 7.88 x 15.90 x 0.00 x 0.00 x 1.13 x 1.14 x 1.24 x 1.33 x 1.43 x D/S Coverage - All WaterDebt 7.88 x 15.90 x 4.63 x 0.69 x 0.88 x 0.99 x 1.12 x 1.20 x 1.29 x Capital Expenditures and Transfers Capital Outlays (147,298) (966,170) (744,108) (550,000) (100,000) (100,000) (100,000) (100,000) (100,000) Bond Proceeds Transfers In 138,000 88,000 88,000 88,000 Transfers Out water meters Annual Surplus/Deficit 148,136 (543,913) (244,079) (496,264) (160,759) (106,809) 41,308 131,335 227,741 Fund Balances Beginning Cash Balance 2,154,764 2,302,900 1,758,987 1,514,908 1,018,644 857,885 751,075 792,384 923,719 Ending Cash Balance 2,302,900 1,758,987 1,514,908 1,018,644 857,885 751,075 792,384 923,719 1,151,460 *Internal Loan paid of FY2025 Assumptions *Estimate and subject to change Sales Growth 5.0% Meter Growth 5.0% Operating Expenses 7.0% Gallons in Base Rate -