|
City of Mounds View
<br /> Sewer Utility Rate Study
<br /> 5.0% 4.5% 4.5% 4.5% 4.5%
<br /> Actual Actual Actual Budget Projected Projected Projected Projected Projected
<br /> 2020 2021 2022 2023 2024 2025 2026 2027 2028
<br /> Expense
<br /> Personnel services $ 403,553 $ 387,160 $ 447,648 $ 464,984 $ 513,233.20 $ 536,329 $ 560,463 $ 585,684 $ 612,040
<br /> Supplies&materials 17,925 22,937 44,908 34,922 36,668 38,318 40,042 41,844 43,727
<br /> Contractual services 72,784 77,515 246,501 163,795 171,985 179,724 187,812 196,263 205,095
<br /> MCES disposal charges 1,026,404 1,025,642 1,082,913 1,150,734 1,208,271 1,262,643 1,319,462 1,378,838 1,440,885
<br /> Depreciation 113,690 122,346 111,520 125,000 150,000 175,000 190,000 200,000 210,000
<br /> Transfers to other funds 137,859 140,345 142,905 142,542 153,258 156,056 158,938 161,906 161,906
<br /> Contingency - - - 15,000 15,000 15,000 15,000 15,000 15,000
<br /> Total Expenses 1,772,215 1,775,945 2,076,395 2,096,977 2,248,415 2,363,070 2,471,717 2,579,535 2,688,654
<br /> Revenues 4.00% 4.00% 4.00% 4.00% 7.00% 7.00% 7.00% 7.00% 7.00%
<br /> Sanitary sewer service 1,855,335 1,918,458 1,994,017 2,013,740 2,101,806 2,248,933 2,406,358 2,574,803 2,755,039
<br /> Service availability charges - - 12,700 - - - - - -
<br /> Investment income 39,503 (12,515) (110,711) 20,000 10,504 8,465 2,673 219 (871)
<br /> Miscellaneous revenues 11,986 - 1,431 - - - - - -
<br /> Transfers from vehicle fund - - - - - - 500,000 - -
<br /> Total Revenues 1,906,824 1,905,943 1,897,437 2,033,740 2,112,310 2,257,398 2,909,031 2,575,022 2,754,168
<br /> v
<br /> Change in net position 134,609 129,998 (178,958) (63,237) (136,104) (105,672) 437,314 (4,513) 65,514
<br /> Accounting change(GASB 68 pension)
<br /> Net position-beginning of year 4,310,139 4,444,748 4,574,746 4,395,788 4,332,551 4,196,447 4,090,775 4,528,088 4,523,575
<br /> Net position-end of year 4,444,748 4,574,746 4,395,788 4,332,551 4,196,447 4,090,775 4,528,088 4,523,575 4,589,089
<br /> Cash Flows
<br /> Change in net position 134,609 129,998 (178,958) (63,237) (136,104) (105,672) 437,314 (4,513) 65,514
<br /> Deduct:
<br /> Capital outlays-equipment - - (27,822) (25,000) - - (500,000) - -
<br /> Construction (109,958) (399,104) - (1,030,000) (500,000) (500,000) (250,000) (250,000) (250,000)
<br /> Add back:
<br /> Depreciation 113,690 122,346 111,520 125,000 150,000 175,000 190,000 200,000 210,000
<br /> Change in receivables/payables 89,357 (136,880) (101,540) - - - - - -
<br /> Cash-Beginning of Year 2,296,408 2,524,106 2,240,466 2,043,666 1,050,429 564,325 133,652 10,966 (43,547)
<br /> Cash-End of Year $ 2,524,106 $ 2,240,466 $ 2,043,666 $ 1,050,429 $ 564,325 $ 133,652 $ 10,966 $ (43,547) $ (18,033)
<br /> Residential equivalent connection rate $ 93.24 $ 96.97 $ 100.85 $ 104.88 $ 112.22 $ 120.08 $ 128.48 $ 137.48 $ 147.10
<br /> Residential fixed rate 37.96 39.48 41.06 42.70 45.69 48.89 52.31 55.97 59.89
<br /> Residential variable rate 3.02 3.14 3.27 3.40 3.64 3.89 4.17 4.46 4.77
<br /> Annual based on 18,000 gal.per quarter 369.53 384.31 399.68 415.67 444.77 475.90 509.21 544.86 583.00
<br /> MCES Rate increase 3.24% -0.07% 5.58% 6.26% 5.00% 4.50% 4.50% 4.50% 4.50%
<br />
|