|
City of Mounds View
<br />Water Utility Rate Study
<br />3.00%3.00%3.00%3.00%3.00%
<br />Actual Actual Actual Budget Projected Projected Projected Projected Projected
<br />2017 2018 2019 2020 2021 2022 2023 2024 2025
<br />Expenses
<br />Personnel services 345,353$ 328,983$ 401,656$ 448,387$ 461,839$ 475,694$ 489,965$ 504,664$ 519,803$
<br />Supplies & materials 61,787 94,202 57,107 76,899 79,206 81,582 84,030 86,551 89,147
<br />Contractual services 229,717 237,948 253,328 288,971 297,640 306,569 315,766 325,239 334,997
<br />Water service line repairs 93,668 94,754 62,764 90,000 90,000 90,000 90,000 90,000 90,000
<br />Depreciation 237,949 240,717 230,683 240,000 323,000 408,000 408,000 408,000 408,000
<br />Debt service - interest - - - - 204,000 193,032 181,734 170,098 85,112
<br />Transfers to other funds - 144,103 147,446 149,859 152,345 154,905 157,542 150,345 150,345
<br />Contingency - - - 15,000 15,000 15,000 15,000 15,000 15,000
<br />Total Expenses 968,474 1,140,707 1,152,984 1,309,116 1,623,030 1,724,782 1,742,037 1,749,896 1,692,404
<br />Revenues
<br />Metered water sales 1,016,067 1,161,536 1,035,481 1,273,305 1,279,351 1,333,684 1,401,182 1,578,830 1,623,087
<br />Meter charge 5,896 4,601 3,675 - - - - - -
<br />Water service line repair fee 88,165 88,775 89,385 89,385 89,385 89,385 89,385 89,385 89,385
<br />Investment income (charges)1,595 7,370 21,328 5,000 71,655 2,991 (2,374) (7,005) (9,564)
<br />Miscellaneous revenues 2,131 2,105 75,347 2,000 2,060 2,122 2,185 2,251 2,319
<br />Transfers from vehicle & equipment fund 35,000 - - - - 4,400 - - -
<br />Total Revenues 1,148,854 1,264,387 1,225,216 1,369,690 1,442,451 1,432,583 1,490,378 1,663,461 1,705,227
<br />Change in net position 180,380 123,680 72,232 60,574 (180,578) (292,200) (251,659) (86,435) 12,823
<br />Accounting change (GASB 68 pension)
<br />Net position - begining of year 3,805,187 3,985,567 4,109,247 4,181,479 4,242,053 4,061,475 3,769,275 3,517,616 3,431,181
<br />Net position - end of year 3,985,567$ 4,109,247$ 4,181,479$ 4,242,053$ 4,061,475$ 3,769,275$ 3,517,616$ 3,431,181$ 3,444,004$
<br />Cash flows
<br />Change in net position 180,380$ 123,680$ 72,232$ 60,574$ (180,578)$ (292,200)$ (251,659)$ (86,435)$ 12,823$
<br />Deduct:
<br />Capital outlays - equipment (45,003) (4,150) - (85,000) - (7,500) - - -
<br />Construction (37,848) - (367,321) (3,309,104) (3,210,000) - - (50,000) -
<br />Debt service - principal - - - - (365,613) (376,581) (387,878) (399,515) (280,000)
<br />Add back:
<br />Bonds issued - - - 6,000,000 - -
<br />Depreciation 237,949 240,717 230,683 240,000 323,000 408,000 408,000 408,000 408,000
<br />Change in receivables/payables (cashflow stmt.)(30,028) (67,566) 24,785 - - - - - -
<br />Cash - Beginning of Year 117,782 423,232 715,913 676,292 3,582,762 149,571 (118,710) (350,246) (478,197)
<br />Cash - End of Year 423,232$ 715,913$ 676,292$ 3,582,762$ 149,571$ (118,710)$ (350,246)$ (478,197)$ (337,374)$
<br />Residential 4.44%12.45%11.07%6.57%4.57%4.37%5.65%5.34%2.44%
<br />Base rate per connection 8.00$ 12.00$ 16.00$ 18.00$ 19.00$ 20.00$ 22.00$ 24.00$ 24.00$
<br />Water rate 1st 12,000 gallons used 2.10 2.20 2.30 2.40 2.50 2.60 2.70 2.80 2.90
<br />Water rate 2nd 13,000 gallons used 2.31 2.42 2.53 2.64 2.75 2.86 2.97 3.08 3.19
<br />Water rate over 25,000 gallons used 2.66 2.78 2.91 3.04 3.16 3.29 3.42 3.54 3.67
<br />Residential annual based on 18,000 gal. per qtr.188.24 211.68 235.12 250.56 262.00 273.44 288.88 304.32 311.76
<br />C/I annual based on 150,000 gal. per qtr.1,334.00 1,412.00 1,490.00 1,560.00 1,626.00 1,692.00 1,762.00 1,804.00 1,865.00 15
|