|
Water and Sewer 10 year operating projection EXHIBIT G
<br />Fiscal Year 2022
<br /> Assumptions 2015 2016 2017 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032
<br />Water Rates
<br /> Flat Fee N/A N/A 3.35$ 6.70$ 10.05$ 13.40$ 17.75$ 21.25$ 23.45$ 25.33$ 26.59$ 27.92$ 29.18$ 30.49$ 31.86$ 33.30$ 34.80$ 36.36$
<br /> Usage (Tier one) 3.10$ 3.10$ 3.07$ 3.07$ 3.07$ 3.13$ 3.19$ 3.26$ 3.35 3.45 3.56 3.67 3.78 3.89 4.01 4.13 4.25
<br />Sewer Rates
<br /> Flat Fee N/A 3.20$ 6.40$ 9.64$ $12.80 15.25$ 17.20$ 18.20$ 19.20$ 19.87 20.57 21.34 22.14 22.97 23.83 24.72 25.65
<br /> Usage 4.62$ 4.69$ 4.69$ 4.64$ 4.64$ 4.64$ 4.64$ 4.64$ 4.90 5.16 5.45 5.75 6.06 6.40 6.75 7.12
<br />Expenses
<br />Met Council - $ Actual 593,381 576,237 643,390 708,567 733,670 712,664 719,437 711,023 743,019 780,170 823,079 868,349 916,108 966,494 1,019,651 1,075,732 1,134,897 1,197,316
<br />Met Council - % Increase -4.57% -2.89% 11.65% 10.13% 3.54% -2.86% 0.95% -1.17% 4.50% 5.00% 5.50% 5.50% 5.50% 5.50% 5.50% 5.50% 5.50% 5.50%
<br />City Water Expenses - % Increase EST ACTUAL 4.00% 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 EST ACTUAL 3.50% 3.50% 3.50% 3.50% 3.50% 3.50% 3.50% 3.50% 3.50% 3.50% 3.50%
<br />$469,346.00 $485,773.11 $502,775.17 $520,372.30 $538,585.33 $557,435.82 $576,946.07 $597,139.18 $618,039.05 $639,670.42
<br />Actual Actual Actual Actual Actual Actual Est. Actual Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected
<br /> REVENUES 2015 2016 2017 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032
<br /> Water Operations 897,232$ 917,927 945,788 985,022 997,332 1,130,292 1,285,510 1,291,631 1,355,688 1,418,599 1,470,654 1,524,755 1,578,316 1,633,844 1,691,415 1,751,108 1,813,002 1,877,185
<br /> Sewer Operations 947,618 1,005,329 1,098,938 1,136,667 1,212,400 1,224,881 1,310,608 1,319,981 1,368,609 1,419,209 1,463,648 1,509,492 1,563,198 1,618,825 1,687,816 1,759,778 1,778,947 1,798,835
<br />Total Operating Revenues 1,844,850$ 1,923,256$ 2,044,726$ 2,121,689$ 2,209,732$ 2,355,173$ 2,596,118$ 2,611,611$ 2,724,297$ 2,837,808$ 2,934,302$ 3,034,247$ 3,141,514$ 3,252,669$ 3,379,232$ 3,510,886$ 3,591,949$ 3,676,020$
<br /> EXPENDITURES
<br /> Water Operations 618,069$ 787,497 841,508 1,077,197 1,091,922 1,026,775 1,097,552 1,188,258 1,235,788 1,285,220 1,336,628 1,390,094 1,445,697 1,503,525 1,563,666 1,626,213 1,691,261 1,758,912
<br /> Sewer Operations 963,621 930,659 1,029,372 1,133,409 1,134,511 1,118,027 1,117,214 1,164,498 1,212,365 1,265,943 1,325,855 1,388,721 1,454,693 1,523,930 1,596,597 1,672,871 1,752,936 1,836,987
<br />Total Operating Expenditures 1,581,690 1,718,156 1,870,880 2,210,606 2,226,432 2,144,802 2,214,766 2,352,755 2,448,153 2,551,163 2,662,483 2,778,815 2,900,390 3,027,455 3,160,263 3,299,084 3,444,197 3,595,899
<br /> Combined Operating Income 263,160$ 205,100$ 173,846$ (88,917)$ (16,700)$ 210,370$ 381,351$ 258,856$ 276,144$ 286,646$ 271,819$ 255,432$ 241,123$ 225,215$ 218,968$ 211,802$ 147,752$ 80,122$
<br />Other (Income)/Expense
<br /> Water (1,938) (11,143) (40,051) (28,689) (12,036) 8,530 500 500 (2,550) (2,500) (2,450) (2,400) (2,350) (2,300) (2,250) (2,200) (2,150) (2,100)
<br /> Sewer (21,139) (14,045) (36,189) (22,650) (2,250) (1,317) 752 400 450 (2,600) (2,550) (2,500) (2,450) (2,400) (2,350) (2,300) (2,250) (2,200)
<br />Interest income (499) (23,907) (11,500) (24,620) (25,000) (27,781) (12,450) (6,250) (11,749) (13,080) (18,335) (21,085) (23,629) (25,955) (28,350) (33,000) (35,000) (34,999)
<br /> Depreciation Expense 308,955 332,399 352,399 371,766 611,728 631,728 656,728 673,146 698,146 723,146 748,146 773,146 798,146 823,146 848,146 873,146 898,146 923,146
<br />Total Other (Income)/Expense 285,380 283,304 264,659 295,807 572,442 611,160 645,530 667,796 684,297 704,966 724,811 747,161 769,717 792,491 767,491 742,491 717,491 692,491
<br />Net Income/(Loss) (22,220)$ (78,204)$ (90,813)$ (384,724)$ (589,142)$ (400,789)$ (264,179)$ (408,940)$ (408,154)$ (418,320)$ (452,992)$ (491,729)$ (528,594)$ (567,276)$ (548,523)$ (530,689)$ (569,740)$ (612,370)$
<br />Other Sources and Uses:
<br />Transfers- in - 1,632,862 - - - - - - - - - - - - - - - -
<br />Transfers Out CIP (15,000) (225,000) - - - - - - - - - - - - - - - -
<br />Transfers Out - W/S Infrastructure - - - - - - - - (50,000) (175,000) (210,000) (255,000) (300,000) (345,000) (390,000) (435,000) (480,000) (525,000)
<br />Army Reimbursements - 130,932 - - - - - - - - - - - - - - - -
<br />Debt Service Payments (140,450) (138,150) (145,750) (148,200) (145,600) (147,950) (150,200) ($147,400) (149,550) (156,550) - - - - - - - -
<br />Net Change in Assets / Liabilities (46,105) 49,451 (30,728) 49,417 (18,684) 114,365 - - - - - - - - - -
<br />Add back Depreciation Expense 308,955 332,399 352,399 371,766 611,728 631,728 656,728 673,146 698,146 723,146 748,146 773,146 798,146 823,146 848,146 873,146 898,146 923,146
<br />Total Other Sources and Uses 107,400 1,782,494 175,921 272,983 447,444 598,143 506,528 525,746 498,596 391,596 538,146 518,146 498,146 478,146 458,146 438,146 418,146 398,146
<br />Net increase (decrease) in cash 85,180$ 1,704,290$ 85,108$ (111,740)$ (141,698)$ 197,354$ 242,349$ 116,806$ 90,443$ (26,724)$ 85,154$ 26,417$ (30,448)$ (89,130)$ (90,377)$ (92,543)$ (151,593)$ (214,223)$
<br />BEGINNING CASH BALANCE 40,837 126,017 1,830,307 1,915,415 1,803,675 1,661,977 1,859,331 2,101,681 2,218,488 2,308,930 2,282,206 2,367,360 2,393,778 2,363,330 2,274,200 2,183,823 2,091,280 1,939,687
<br />ENDING CASH BALANCE 126,017$ 1,830,307$ 1,915,415$ 1,803,675$ 1,661,977$ 1,859,331$ 2,101,681$ 2,218,488$ 2,308,930$ 2,282,206$ 2,367,360$ 2,393,778$ 2,363,330$ 2,274,200$ 2,183,823$ 2,091,280$ 1,939,687$ 1,725,463$
<br />MINIMUM CASH BALANCE 755,400 779,235 827,325 855,430 882,177 933,008 1,015,573 1,017,937 1,057,649 1,102,486 978,101 1,011,416 1,047,171 1,084,223 1,126,411 1,099,695 1,148,066 1,198,633
|