|
Water and Sewer 10 year operating projection EXHIBIT G
<br />Fiscal Year 2025 `
<br /> Assumptions 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035
<br />Water Rates
<br /> Flat Fee (1st yr 2017)10.05$ 13.40$ 17.75$ 21.25$ 24.25$ 25.50$ 27.00$ 28.35$ 29.75$ 31.25$ 32.75$ 34.25$ 36.00$ 37.75$ 39.25$ 41.00$ 43.00$
<br /> Usage (Tier one)3.07$ 3.07$ 3.13$ 3.19$ 3.27$ 3.32 3.44 3.55 3.67 3.79 3.91 4.04 4.17 4.30 4.44 4.59 4.74
<br />Sewer Rates
<br /> Flat Fee (1st yr 2017)9.64$ $12.80 15.25$ 17.20$ 19.25$ 21.25$ 23.25 25.00 26.50 27.75 28.75 29.75 30.75 31.75 32.75 33.75 34.75
<br /> Usage 4.69$ 4.64$ 4.64$ 4.64$ 4.73$ 4.85$ 5.12 5.40 5.70 6.01 6.34 6.69 7.06 7.44 7.85 8.28 8.74
<br />Expenses
<br />Met Council - $ Actual 733,670 712,664 719,437 711,023 760,026 822,704 949,408 1,001,625 1,056,715 1,114,834 1,176,150 1,240,838 1,309,084 1,381,084 1,457,044 1,537,181 1,621,726
<br />Met Council - % Increase 3.54%-2.86%0.95%-1.17%6.89%8.25%15.40%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 EST ACTUAL 9.35%4.50%4.00%4.00%4.00%4.00%4.00%4.00%4.00%4.00%4.00%
<br />City Sewer Expenses - % Increase EST ACTUAL 11.04%4.00%3.50%3.50%3.50%3.50%3.50%3.50%3.50%3.50%3.50%
<br />528,186.04 $549,313.48 $568,539.45 $588,438.33 $609,033.67 $630,349.85 $652,412.10 $675,246.52 $698,880.15 $723,340.95 $748,657.89
<br /> Actual Actual Actual Actual Actual Est. Actual Budgeted Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected
<br /> REVENUES 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035
<br /> Water Operations 997,332 1,130,292 1,300,250 1,347,275 1,513,076 1,436,885 1,499,839 1,557,946 1,618,588 1,682,336 1,747,144 1,813,046 1,885,278 1,958,677 2,028,081 2,103,929 2,186,262
<br /> Sewer Operations 1,212,400 1,224,881 1,314,285 1,337,972 1,440,378 1,487,143 1,586,785 1,683,719 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
<br />Total Operating Revenues 2,209,732$ 2,355,173$ 2,614,535$ 2,685,247$ 2,953,455$ 2,924,028$ 3,086,624$ 3,241,665$ 3,397,247$ 3,554,124$ 3,710,438$ 3,871,708$ 4,043,381$ 4,220,518$ 4,398,192$ 4,587,093$ 4,787,522$
<br /> EXPENDITURES
<br /> Water Operations 1,091,922 1,026,775 920,311 1,102,354 1,099,888 1,202,688 1,296,858 1,355,216 1,409,425 1,465,802 1,524,434 1,585,412 1,648,828 1,714,781 1,783,372 1,854,707 1,928,896
<br /> Sewer Operations 1,134,511 1,118,027 1,103,140 1,164,982 1,203,188 1,298,331 1,477,594 1,550,939 1,625,254 1,703,272 1,785,184 1,871,188 1,961,496 2,056,331 2,155,924 2,260,522 2,370,384
<br />Total Operating Expenditures 2,226,432 2,144,802 2,023,451 2,267,336 2,303,077 2,501,019 2,774,452 2,906,155 3,034,679 3,169,075 3,309,618 3,456,600 3,610,324 3,771,112 3,939,296 4,115,229 4,299,279
<br /> Combined Operating Income (16,700)$ 210,370$ 591,084$ 417,911$ 650,378$ 423,010$ 312,172$ 335,510$ 362,568$ 385,049$ 400,820$ 415,108$ 433,056$ 449,406$ 458,896$ 471,863$ 488,243$
<br />Other (Income)/Expense
<br /> Water (12,036) 8,530 (12,181)1,351 2,731 7,451 7,570 7,620 7,670 7,720 7,770 7,820 7,870 7,920 7,970 8,020 8,070
<br /> Sewer (2,250) (1,317) (1,216)400 140 (50) - 50 100 150 200 250 300 350 400 450 500
<br />Interest income (25,000) (27,781) 7,697 (6,250) (125,116) (80,723) (40,361) (26,393) (27,638) (29,553) (32,241) (35,793) (40,048) (44,734) (49,616) (54,476) (59,159)
<br /> Depreciation Expense 611,728 631,728 612,058 637,679 688,452 711,774 711,774 734,774 749,774 773,774 788,774 814,774 841,774 856,774 884,774 899,774 927,774
<br />Total Other (Income)/Expense 572,442 611,160 606,358 633,180 566,207 638,452 678,982 716,051 729,906 752,091 727,091 702,091 677,091 652,091 627,091 602,091 577,091
<br />Net Income/(Loss) (589,142)$ (400,789)$ (15,274)$ (215,269)$ 84,171$ (215,442)$ (366,811)$ (380,541)$ (367,338)$ (367,042)$ (326,271)$ (286,983)$ (244,035)$ (202,685)$ (168,195)$ (130,228)$ (88,848)$
<br />Other Sources and Uses:
<br />Transfers- in - - - - - - - - - - - - - - - - -
<br />Transfers Out CIP - - - - - - - - - - - - - - - - -
<br />Transfers Out - Public Utility Infrast.- - - - - (696,961) (306,907) (265,521) (260,420) (275,638) (294,078) (335,374) (390,037) (451,815) (506,043) (562,131) (611,929)
<br />Army Reimbursements - - - - - - - - - - - - - - - - -
<br />Debt Service Payments (145,600) (147,950) (150,200) ($147,400)(155,376) (156,550) - - - - - - - - - - -
<br />Net Change in Assets / Liabilities (18,684) 114,365 (120,563) (49,263) (114,117) - - - - - - - - - - -
<br />Add back Depreciation Expense 611,728 631,728 612,058 637,679 688,452 711,774 711,774 734,774 749,774 773,774 788,774 814,774 841,774 856,774 884,774 899,774 927,774
<br />Total Other Sources and Uses 447,444 598,143 341,295 441,016 418,959 (141,737) 404,867 469,253 489,354 498,136 494,696 479,400 451,737 404,959 378,731 337,643 315,844
<br />Net increase (decrease) in cash (141,698)$ 197,354$ 326,021$ 225,747$ 503,130$ (357,179)$ 38,056$ 88,712$ 122,015$ 131,094$ 168,425$ 192,417$ 207,702$ 202,273$ 210,535$ 207,415$ 226,996$
<br />BEGINNING CASH BALANCE 1,803,675 1,661,977 1,859,331 2,185,353 2,411,101 2,914,231 2,557,052 2,595,108 2,683,820 2,805,836 2,936,930 3,105,355 3,297,772 3,505,474 3,707,747 3,918,283 4,125,698
<br />ENDING CASH BALANCE 1,661,977$ 1,859,331$ 2,185,352$ 2,411,101$ 2,914,231$ 2,557,052$ 2,595,108$ 2,683,820$ 2,805,836$ 2,936,930$ 3,105,355$ 3,297,772$ 3,505,474$ 3,707,747$ 3,918,283$ 4,125,698$ 4,352,694$
<br />MINIMUM CASH BALANCE 882,177 933,008 1,021,712 1,042,482 1,139,861 2,250,145 2,329,588 2,423,400 2,530,198 2,642,852 2,769,981 2,907,735 3,053,659 3,201,704 3,356,152 3,513,768 3,830,371
<br />30
|