|
Water and Sewer 10 year operating projection EXHIBIT G
<br />Fiscal Year 2023
<br /> Assumptions 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032
<br />Water Rates
<br /> Flat Fee (1st yr 2017)6.70$ 10.05$ 13.40$ 17.75$ 21.25$ 24.25$ 26.19$ 27.50$ 28.87$ 30.17$ 31.53$ 32.95$ 34.43$ 35.98$ 37.60$
<br /> Usage (Tier one)3.07$ 3.07$ 3.07$ 3.13$ 3.19$ 3.27$ 3.37 3.47 3.57 3.68 3.79 3.90 4.02 4.14 4.27
<br />Sewer Rates
<br /> Flat Fee (1st yr 2017)6.40$ 9.64$ $12.80 15.25$ 17.20$ 19.25$ 20.25$ 20.96 21.69 22.51 23.35 24.23 25.13 26.08 27.05
<br /> Usage 4.69$ 4.69$ 4.64$ 4.64$ 4.64$ 4.73$ 4.73$ 4.99 5.26 5.55 5.86 6.18 6.52 6.88 7.26
<br />Expenses
<br />Met Council - $ Actual 708,567 733,670 712,664 719,437 711,023 760,026 798,027 841,919 888,224 937,077 988,616 1,042,990 1,100,354 1,160,874 1,224,722
<br />Met Council - % Increase 10.13% 3.54% -2.86% 0.95% -1.17% 6.89% 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%
<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%
<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 Est. Actual Budget Projected Projected Projected Projected Projected Projected Projected Projected Projected
<br /> REVENUES 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032
<br /> Water Operations 985,022 997,332 1,130,292 1,300,250 1,324,841 1,373,093 1,437,851 1,491,367 1,547,017 1,601,977 1,658,979 1,718,103 1,779,430 1,843,046 1,909,041
<br /> Sewer Operations 1,136,667 1,212,400 1,224,881 1,314,285 1,347,580 1,423,818 1,430,215 1,475,091 1,521,388 1,570,313 1,626,249 1,684,187 1,755,794 1,830,478 1,908,372
<br />Total Operating Revenues 2,121,689$ 2,209,732$ 2,355,173$ 2,614,535$ 2,672,421$ 2,796,911$ 2,868,066$ 2,966,457$ 3,068,406$ 3,172,291$ 3,285,228$ 3,402,290$ 3,535,224$ 3,673,524$ 3,817,413$
<br /> EXPENDITURES
<br /> Water Operations 1,077,197 1,091,922 1,026,775 920,311 1,134,600 1,186,921 1,234,397 1,283,773 1,335,124 1,388,529 1,444,070 1,501,833 1,561,907 1,624,383 1,689,358
<br /> Sewer Operations 1,133,409 1,134,511 1,118,027 1,103,140 1,140,118 1,221,274 1,283,800 1,344,694 1,408,597 1,475,662 1,546,052 1,619,936 1,697,493 1,778,913 1,864,392
<br />Total Operating Expenditures 2,210,606 2,226,432 2,144,802 2,023,451 2,274,718 2,408,195 2,518,198 2,628,467 2,743,721 2,864,191 2,990,122 3,121,769 3,259,400 3,403,296 3,553,750
<br /> Combined Operating Income (88,917)$ (16,700)$ 210,370$ 591,084$ 397,704$ 388,716$ 349,868$ 337,990$ 324,685$ 308,099$ 295,106$ 280,520$ 275,824$ 270,228$ 263,663$
<br />Other (Income)/Expense
<br /> Water (28,689)(12,036) 8,530 (12,181)3,451 4,851 4,901 4,951 5,001 5,051 5,101 5,151 5,201 5,251 5,301
<br /> Sewer (22,650)(2,250) (1,317) (1,216)350 450 (2,600) (2,550) (2,500) (2,450) (2,400) (2,350) (2,300) (2,250) (2,200)
<br />Interest income (24,620)(25,000) (27,781) 7,697 (1,500) (6,000) (13,080) (18,335) (21,085) (23,629) (25,955) (28,350) (33,000) (35,000) (34,999)
<br /> Depreciation Expense 371,766 611,728 631,728 612,058 627,258 647,258 657,258 679,258 702,258 717,258 741,258 756,258 782,258 809,258 824,258
<br />Total Other (Income)/Expense 295,807 572,442 611,160 606,358 629,559 646,559 646,479 663,324 683,674 696,230 718,004 693,004 668,004 643,004 618,004
<br />Net Income/(Loss) (384,724)$ (589,142)$ (400,789)$ (15,274)$ (231,855)$ (257,843)$ (296,611)$ (325,334)$ (358,989)$ (388,131)$ (422,898)$ (412,484)$ (392,180)$ (372,776)$ (354,341)$
<br />Other Sources and Uses:
<br />Transfers- in - - - - - - - - - - - - - - -
<br />Transfers Out CIP - - - - - - - - - - - - - - -
<br />Transfers Out - W/S Infrastructure - - - - - - - (210,000) (255,000) (290,000) (315,000) (340,000) (385,000) (430,000) (465,000)
<br />Army Reimbursements - - - - - - - - - - - - - - -
<br />Debt Service Payments (148,200) (145,600) (147,950) (150,200) ($147,400) (149,550) (156,550) - - - - - - - -
<br />Net Change in Assets / Liabilities 49,417 (18,684) 114,365 (120,563) - - - - - - - - - -
<br />Add back Depreciation Expense 371,766 611,728 631,728 612,058 627,258 647,258 657,258 679,258 702,258 717,258 741,258 756,258 782,258 809,258 824,258
<br />Total Other Sources and Uses 272,983 447,444 598,143 341,295 479,858 497,708 500,708 469,258 447,258 427,258 426,258 416,258 397,258 379,258 359,258
<br />Net increase (decrease) in cash (111,740)$ (141,698)$ 197,354$ 326,021$ 248,003$ 239,865$ 204,097$ 143,924$ 88,269$ 39,127$ 3,360$ 3,774$ 5,078$ 6,482$ 4,917$
<br />BEGINNING CASH BALANCE 1,915,415 1,803,675 1,661,977 1,859,331 2,185,352 2,433,356 2,673,221 2,877,317 3,021,242 3,109,510 3,148,638 3,151,997 3,155,772 3,160,850 3,167,332
<br />ENDING CASH BALANCE 1,803,675$ 1,661,977$ 1,859,331$ 2,185,352$ 2,433,356$ 2,673,221$ 2,877,317$ 3,021,242$ 3,109,510$ 3,148,638$ 3,151,997$ 3,155,772$ 3,160,850$ 3,167,332$ 3,172,249$
<br />MINIMUM CASH BALANCE 855,430 882,177 933,008 1,021,712 1,038,207 1,081,854 1,112,572 988,819 1,022,802 1,057,430 1,095,076 1,134,097 1,086,467 1,134,432 1,184,583
|