|
Fiscal Year 2020
<br /> Assumptions 2015 2016 2017 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031
<br />Water Rates
<br /> Flat Fee N/A N/A 3.35$ 6.70$ 10.05$ 13.40$ 16.75$ 20.10$ 23.45$ 24.39$ 25.36$ 26.38$ 27.43$ 28.53$ 29.67$ 30.86$ 32.09$
<br /> Usage (Tier one)3.10$ 3.10$ 3.07$ 3.07$ 3.07$ 3.04$ 3.01$ 2.98$ 3.10 3.22 3.35 3.48 3.62 3.77 3.92 4.08
<br />Sewer Rates
<br /> Flat Fee N/A 3.20$ 6.40$ 9.60$ 12.80$ 16.00$ 19.20$ 22.40$ 25.60$ 26.50 27.42 28.38 29.38 30.40 31.47 32.57
<br /> Usage 4.62$ 4.69$ 4.69$ 4.64$ 4.60$ 4.60$ 4.60$ 4.60$ 4.85 5.12 5.40 5.69 6.01 6.34 6.69
<br />Expenses
<br />Met Council - $ Actual 593,381 576,237 643,390 708,567 5.50%5.50%5.50%5.50%5.50%5.50%5.50%5.50%5.50%5.50%5.50%5.50%5.50%
<br />Met Council - % Increase -4.57%-2.89%11.65%10.13%NA NA NA NA NA NA NA NA NA NA NA NA NA
<br />City Water Expenses - % Increase 4.00%4.00%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 3.50% 3.50% 3.50% 3.50% 3.50% 3.50% 3.50% 3.50% 3.50% 3.50% 3.50% 3.50% 3.50%
<br />Actual Actual Actual Actual Est. Actual Projected 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
<br /> Water Operations 897,232$ 917,927 945,788 985,022 1,010,174 1,095,004 1,214,736 1,271,707 1,328,814 1,381,967 1,437,246 1,494,735 1,554,525 1,616,706 1,681,374 1,748,629 1,818,574
<br /> Sewer Operations 947,618 1,005,329 1,098,938 1,136,667 1,197,583 1,249,355 1,327,371 1,388,557 1,449,742 1,526,225 1,600,071 1,677,491 1,758,657 1,843,750 1,932,960 2,026,487 2,124,539
<br />Total Operating Revenues 1,844,850$ 1,923,256$ 2,044,726$ 2,121,689$ 2,207,757$ 2,344,358$ 2,542,107$ 2,660,264$ 2,778,557$ 2,908,191$ 3,037,317$ 3,172,226$ 3,313,182$ 3,460,456$ 3,614,334$ 3,775,116$ 3,943,113$
<br /> EXPENDITURES
<br /> Water Operations 618,069$ 787,497 841,508 1,077,197 1,073,371 1,123,286 1,168,218 1,214,946 1,263,544 1,314,086 1,366,650 1,421,316 1,478,168 1,537,295 1,598,787 1,662,738 1,729,248
<br /> Sewer Operations 963,621 930,659 1,029,372 1,133,409 1,139,219 1,141,359 1,286,921 1,348,604 1,413,361 1,481,350 1,552,737 1,627,698 1,706,416 1,789,085 1,875,910 1,967,105 2,062,896
<br />Total Operating Expenditures 1,581,690 1,718,156 1,870,880 2,210,606 2,212,590 2,264,645 2,455,139 2,563,551 2,676,905 2,795,436 2,919,387 3,049,013 3,184,584 3,326,380 3,474,696 3,629,843 3,792,144
<br /> Combined Operating Income 263,160$ 205,100$ 173,846$ (88,917)$ (4,833)$ 79,713$ 86,968$ 96,714$ 101,652$ 112,755$ 117,930$ 123,213$ 128,598$ 134,076$ 139,638$ 145,273$ 150,969$
<br />Other (Income)/Expense
<br /> Water (1,938)(11,143)(40,051)(28,689)(33,900) (33,900)(15,000)(14,950)(14,900)(14,850)(14,800)(14,750)(14,700)(14,650)(14,600)(14,550)(14,500)
<br /> Sewer (21,139) (14,045) (36,189) (22,650)(34,550) (34,550) (15,000) (14,950) (14,900) (14,850) (14,800) (14,750) (14,700) (14,650) (14,600) (14,550) (14,500)
<br />Interest income (499) (23,907) (11,500) (24,620)(25,000) (23,000) (33,041) (37,055) (40,344) (44,777) (46,505) (48,497) (50,762) (53,306) (56,139) (59,267) (59,564)
<br /> Depreciation Expense 308,955 332,399 352,399 371,766 396,766 416,766 461,766 496,766 531,766 566,766 601,766 636,766 671,766 706,766 741,766 776,766 811,766
<br />Total Other (Income)/Expense 285,380 283,304 264,659 295,807 303,316 325,316 398,725 429,811 461,622 492,289 525,661 558,769 591,604 624,160 656,427 688,399 723,202
<br />Net Income/(Loss) (22,220)$ (78,204)$ (90,813)$ (384,724)$ (308,149)$ (245,603)$ (311,756)$ (333,097)$ (359,971)$ (379,533)$ (407,731)$ (435,556)$ (463,007)$ (490,084)$ (516,789)$ (543,126)$ (572,233)$
<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 - - - - - - - (75,000) (115,000) (140,000) (175,000) (175,000) (175,000) (175,000) (175,000) (175,000) (175,000)
<br />Army Reimbursements - 130,932 - - - - - - - - - - - - - - -
<br />Debt Service Payments (140,450) (138,150) (145,750) (148,200) (145,600) (145,600) (150,200) (147,400) (149,550) (156,550) - - - - - - -
<br />Net Change in Assets / Liabilities (46,105) 49,451 (30,728) 49,417 - - - - - - - - - - - - -
<br />Add back Depreciation Expense 308,955 332,399 352,399 371,766 396,766 416,766 461,766 496,766 531,766 566,766 601,766 636,766 671,766 706,766 741,766 776,766 811,766
<br />Total Other Sources and Uses 107,400 1,782,494 175,921 272,983 251,166 271,166 311,566 274,366 267,216 270,216 426,766 461,766 496,766 531,766 566,766 601,766 636,766
<br />Net increase (decrease) in cash 85,180$ 1,704,290$ 85,108$ (111,740)$ (56,983)$ 25,563$ (190)$ (58,731)$ (92,755)$ (109,317)$ 19,035$ 26,210$ 33,759$ 41,682$ 49,977$ 58,640$ 64,533$
<br />BEGINNING CASH BALANCE 40,837 126,017 1,830,307 1,915,415 1,803,675 1,746,693 1,772,256 1,772,066 1,713,334 1,620,579 1,511,262 1,530,297 1,556,507 1,590,266 1,631,948 1,681,925 1,740,565
<br />ENDING CASH BALANCE 126,017$ 1,830,307$ 1,915,415$ 1,803,675$ 1,746,693$ 1,772,256$ 1,772,066$ 1,713,334$ 1,620,579$ 1,511,262$ 1,530,297$ 1,556,507$ 1,590,266$ 1,631,948$ 1,681,925$ 1,740,565$ 1,805,098$
<br />MINIMUM CASH BALANCE 755,400 779,235 827,325 855,430 881,519 927,053 997,569 1,034,155 1,075,736 1,125,947 1,012,439 1,057,409 1,104,394 1,153,485 1,204,778 1,209,948 1,264,048
<br />EXHIBIT D
|