|
City of Mounds View
<br />Water Utility Rate Study
<br />3.50%3.50%3.50%3.50%3.50%
<br />Actual Actual Actual Budget Projected Projected Projected Projected Projected
<br />2018 2019 2020 2021 2022 2023 2024 2025 2026
<br />Expenses
<br />Personnel services 328,983$ 401,656$ 457,321$ 464,116$ 480,360$ 497,173$ 514,574$ 532,584$ 551,224$
<br />Supplies & materials 94,202 57,107 53,320 76,469 79,145 81,916 84,783 87,750 90,821
<br />Contractual services 237,948 253,328 225,957 281,319 291,165 301,356 311,903 322,820 334,119
<br />Water service line repairs 94,754 62,764 94,981 90,000 94,000 94,000 96,000 98,000 100,000
<br />Depreciation 240,717 230,683 198,159 240,000 335,000 408,000 408,000 408,000 408,000
<br />Debt service - interest/issuance costs - - 100,764 44,950 90,073 83,223 76,173 69,023 61,723
<br />Transfers to other funds 144,103 147,446 149,859 155,345 157,905 160,542 163,258 166,056 168,938
<br />Contingency - - - 15,000 15,000 15,000 15,000 15,000 15,000
<br />Total Expenses 1,140,707 1,152,984 1,280,361 1,367,199 1,542,649 1,641,209 1,669,691 1,699,233 1,729,825
<br />Revenues
<br />Metered water sales 1,161,536 1,035,481 1,261,207 1,155,305 1,333,684 1,401,182 1,564,679 1,623,087 1,681,496
<br />Meter charge 4,601 3,675 660 - - - - - -
<br />Water service line repair fee 88,775 89,385 93,774 92,000 92,000 100,000 100,000 100,000 100,000
<br />Investment income (charges)7,370 21,328 6,257 1,000 9,139 7,065 5,651 5,811 7,454
<br />Miscellaneous revenues 2,105 75,347 10,605 4,000 4,120 4,244 4,371 4,502 4,637
<br />Transfers from vehicle & equipment fund - - - 160,000 7,500 - - - 150,000
<br />Total Revenues 1,264,387 1,225,216 1,372,503 1,412,305 1,446,443 1,512,490 1,674,700 1,733,400 1,943,587
<br />Change in net position 123,680 72,232 92,142 45,106 (96,205) (128,719) 5,010 34,167 213,762
<br />Accounting change (GASB 68 pension)
<br />Net position - begining of year 3,985,567 4,109,247 4,181,479 4,273,621 4,318,727 4,222,522 4,093,803 4,098,813 4,132,980
<br />Net position - end of year 4,109,247$ 4,181,479$ 4,273,621$ 4,318,727$ 4,222,522$ 4,093,803$ 4,098,813$ 4,132,980$ 4,346,741$
<br />Cash flows
<br />Change in net position 123,680$ 72,232$ 92,142$ 45,106$ (96,205)$ (128,719)$ 5,010$ 34,167$ 213,762$
<br />Deduct:
<br />Capital outlays - equipment (4,150) - - (210,000) (7,500) - - - (150,000)
<br />Construction - (367,321) (2,959,544) (3,896,000) - - (50,000) - -
<br />Debt service - principal - - - - (335,000) (350,000) (355,000) (360,000) (370,000)
<br />Add back:
<br />Bonds issued - - 6,101,528 - -
<br />Depreciation 240,717 230,683 198,159 240,000 335,000 408,000 408,000 408,000 408,000
<br />Change in receivables/payables (cashflow stmt.)(67,566) 24,785 169,266 - - - - - -
<br />Cash - Beginning of Year 423,232 715,913 676,292 4,277,843 456,949 353,244 282,525 290,535 372,702
<br />Cash - End of Year 715,913$ 676,292$ 4,277,843$ 456,949$ 353,244$ 282,525$ 290,535$ 372,702$ 474,464$
<br />Residential 12.45%11.07%6.57%4.57%4.37%5.65%3.96%3.81%3.67%
<br />Base rate per connection 12.00$ 16.00$ 18.00$ 19.00$ 20.00$ 22.00$ 23.00$ 24.00$ 25.00$
<br />Water rate 1st 12,000 gallons used 2.20 2.30 2.40 2.50 2.60 2.70 2.80 2.90 3.00
<br />Water rate 2nd 13,000 gallons used 2.42 2.53 2.64 2.75 2.86 2.97 3.08 3.19 3.30
<br />Water rate over 25,000 gallons used 2.78 2.91 3.04 3.16 3.29 3.42 3.54 3.67 3.80
<br />Water Line Insurance per quarter (residential only)7.50 7.50 7.50 7.50 7.50 8.00 8.00 8.00 8.00
<br />Residential annual based on 18,000 gal. per qtr.211.68 235.12 250.56 262.00 273.44 288.88 300.32 311.76 323.20
<br />C/I annual based on 150,000 gal. per qtr.1,412.00 1,490.00 1,560.00 1,626.00 1,692.00 1,762.00 1,800.00 1,865.00 1,930.00
|