|
Water and Sewer 10 year operating projection EXHIBIT G
<br />Fiscal Year 2026 `
<br /> Assumptions 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036
<br />Water Rates
<br /> Flat Fee (1st yr 2017)27.00$ 30.00$ 31.00$ 32.25$ 33.75$ 35.25$ 37.00$ 38.75$ 40.25$ 42.00$ 44.00$ 0.03$
<br /> Usage (Tier one)3.44 3.56 3.68 3.80 3.92 4.05 4.18 4.31 4.45 4.60 4.75 4.45
<br />Sewer Rates
<br /> Flat Fee (1st yr 2017)23.25$ 24.75 26.50 27.75 28.75 29.75 30.75 31.75 32.75 33.75 34.75 0.06
<br /> Usage 5.12$ 5.25 5.54 5.84 6.16 6.50 6.86 7.24 7.64 8.06 8.50 8.97
<br />Expenses
<br />Met Council - $ Actual 949,408 975,966 1,029,644 1,086,275 1,146,020 1,209,051 1,275,549 1,345,704 1,419,717 1,497,802 1,580,181 1,667,091
<br />Met Council - % Increase 15.40%2.80%5.50%5.50%5.50%5.50%5.50%5.50%5.50%5.50%5.50%5.50%
<br />City Water Expenses - % Increase 9.35%4.50%4.00%4.00%4.00%4.00%4.00%4.00%4.00%4.00%4.00%4.00%
<br />City Sewer Expenses - % Increase 11.04%4.00%3.50%3.50%3.50%3.50%3.50%3.50%3.50%3.50%3.50%3.50%
<br />$528,186.04 $548,222.00 $567,409.77 $587,269.11 $607,823.53 $629,097.35 $651,115.76 $673,904.81 $697,491.48 $721,903.68 $747,170.31 $773,321.27
<br />Budgeted Budgeted Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected
<br /> REVENUES 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036
<br /> Water Operations 1,499,839 1,521,478 1,611,406 1,668,599 1,731,767 1,796,032 1,866,344 1,937,826 2,005,601 2,079,537 2,159,674 2,231,313
<br /> Sewer Operations 1,586,785 1,725,778 1,778,660 1,871,788 1,963,295 2,058,662 2,158,103 2,261,840 2,370,111 2,483,163 2,601,260 2,724,679
<br />Total Operating Revenues 3,086,624$ 3,247,256$ 3,390,066$ 3,540,387$ 3,695,062$ 3,854,694$ 4,024,447$ 4,199,666$ 4,375,712$ 4,562,700$ 4,760,935$ 4,955,992$
<br /> EXPENDITURES
<br /> Water Operations 1,296,858 1,447,128 1,505,013 1,565,214 1,627,823 1,692,935 1,760,653 1,831,079 1,904,322 1,980,495 2,059,715 2,142,103
<br /> Sewer Operations 1,477,594 1,524,188 1,597,054 1,673,544 1,753,843 1,838,148 1,926,664 2,019,609 2,117,209 2,219,706 2,327,351 2,440,412
<br />Total Operating Expenditures 2,774,452 2,971,316 3,102,067 3,238,758 3,381,666 3,531,084 3,687,317 3,850,687 4,021,531 4,200,201 4,387,066 4,582,516
<br /> Combined Operating Income 312,172$ 275,940$ 287,999$ 301,629$ 313,396$ 323,611$ 337,130$ 348,979$ 354,181$ 362,499$ 373,869$ 373,477$
<br />Other (Income)/Expense
<br /> Water 4,851 4,851 4,901 4,951 5,001 5,051 5,101 5,151 5,201 5,251 5,301 5,351
<br /> Sewer 450 450 500 550 600 650 700 750 800 850 900 950
<br />Interest income (6,000) (6,000) (27,638) (29,553) (32,241) (35,793) (40,048) (44,734) (49,616) (54,476) (59,159) (63,960)
<br /> Depreciation Expense 667,179 609,902 624,902 648,902 663,902 689,902 716,902 731,902 759,902 774,902 802,902 830,902
<br />Total Other (Income)/Expense 666,480 609,203 602,665 624,850 599,850 574,850 549,850 524,850 499,850 474,850 449,850 424,850
<br />Net Income/(Loss) (354,308)$ (333,263)$ (314,666)$ (323,221)$ (286,455)$ (251,239)$ (212,720)$ (175,872)$ (145,670)$ (112,351)$ (75,982)$ (51,374)$
<br />Other Sources and Uses:
<br />Transfers- in - - - - - - - - - - - -
<br />Transfers Out CIP - - - - - - - - - - - -
<br />Transfers Out - Public Utility Infrast.(250,000) (250,000) (260,420) (275,638) (294,078) (335,374) (390,037) (451,815) (506,043) (562,131) (611,929) (665,921)
<br />Army Reimbursements - - - - - - - - - - - -
<br />Debt Service Payments - - - - - - - - - - - -
<br />Net Change in Assets / Liabilities - - - - - - - - - - -
<br />Add back Depreciation Expense 667,179 609,902 624,902 648,902 663,902 689,902 716,902 731,902 759,902 774,902 802,902 830,902
<br />Total Other Sources and Uses 417,179 359,902 364,482 373,264 369,824 354,528 326,865 280,087 253,859 212,771 190,973 164,981
<br />Net increase (decrease) in cash 62,871$ 26,639$ 49,815$ 50,043$ 83,370$ 103,289$ 114,144$ 104,215$ 108,189$ 100,420$ 114,991$ 113,607$
<br />BEGINNING CASH BALANCE 3,254,013 3,316,883 3,343,522 3,393,338 3,443,381 3,526,750 3,630,039 3,744,184 3,848,399 3,956,588 4,057,008 4,171,999
<br />ENDING CASH BALANCE 3,316,883$ 3,343,522$ 3,393,338$ 3,443,381$ 3,526,750$ 3,630,039$ 3,744,184$ 3,848,399$ 3,956,588$ 4,057,008$ 4,171,999$ 4,285,606$
<br />MINIMUM CASH BALANCE 2,573,488 2,649,614 2,735,716 2,825,048 2,927,683 3,039,752 3,158,694 3,278,439 3,403,332 3,530,032 3,665,432 3,804,947
<br /> Depreciation Expense 712,679 737,679 762,679 787,679 812,679 837,679 862,679 887,679 912,679 937,679 962,679 987,679
<br />32
|