|
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 />2016 2017 2018 2019 2020 2021 2022 2023 2024
<br />Expenses
<br />Personnel services 370,512$ 345,353$ 328,983$ 382,568$ 394,045$ 405,866$ 418,042$ 430,584$ 443,501$
<br />Supplies & materials 64,640 61,787 94,202 77,949 80,287 82,696 85,177 87,732 90,364
<br />Contractual services 242,961 229,717 237,948 281,123 289,557 298,243 307,191 316,406 325,899
<br />Water service line repairs 82,048 93,668 94,754 80,000 82,000 84,000 84,000 84,000 84,000
<br />Depreciation 240,583 237,949 240,717 238,000 238,000 323,000 408,000 408,000 408,000
<br />Debt service - interest - - - - 85,567 204,000 193,032 181,734 170,098
<br />Transfers to other funds - - 144,103 147,446 149,859 152,345 154,905 157,542 150,345
<br />Contingency - - - 15,000 15,000 15,000 15,000 15,000 15,000
<br />Total Expenses 1,000,744 968,474 1,140,707 1,222,086 1,334,315 1,565,151 1,665,347 1,680,998 1,687,207
<br />Revenues
<br />Metered water sales 971,654 1,016,067 1,161,536 1,135,660 1,225,018 1,279,351 1,333,684 1,401,182 1,578,830
<br />Meter charge 1,564 5,896 4,601 - - - - - -
<br />Water service line repair fee 87,775 88,165 88,775 85,000 85,000 85,000 85,000 85,000 85,000
<br />Investment income (charges)(648) 1,595 7,370 2,000 7,971 86,424 19,105 15,142 11,974
<br />Miscellaneous revenues 3,644 2,131 2,105 1,000 1,030 1,061 1,093 1,126 1,159
<br />Transfers from vehicle & equipment fund - 35,000 - - 163,000 - 4,400 - -
<br />Total Revenues 1,063,989 1,148,854 1,264,387 1,223,660 1,482,019 1,451,836 1,443,282 1,502,450 1,676,963
<br />Change in net position 63,245 180,380 123,680 1,574 147,703 (113,315) (222,065) (178,549) (10,244)
<br />Accounting change (GASB 68 pension)
<br />Net position - begining of year 3,741,942 3,805,187 3,985,567 4,109,247 4,110,821 4,258,525 4,145,209 3,923,145 3,744,596
<br />Net position - end of year 3,805,187$ 3,985,567$ 4,109,247$ 4,110,821$ 4,258,525$ 4,145,209$ 3,923,145$ 3,744,596$ 3,734,352$
<br />Cash flows
<br />Change in net position 63,245$ 180,380$ 123,680$ 1,574$ 147,703$ (113,315)$ (222,065)$ (178,549)$ (10,244)$
<br />Deduct:
<br />Capital outlays - equipment (29,263) (45,003) (4,150) - (160,000) - (7,500) - -
<br />Construction - (37,848) - (500,000) (3,160,000) (3,210,000) - - (50,000)
<br />Debt service - principal - - - - - (365,613) (376,581) (387,878) (399,515)
<br />Add back:
<br />Bonds issued - - - - 6,800,000 - -
<br />Depreciation 240,583 237,949 240,717 238,000 238,000 323,000 408,000 408,000 408,000
<br />Change in receivables/payables (cashflow stmt.)(161,548) (30,028) (67,566) - - - - - -
<br />Cash - Beginning of Year 4,765 117,782 423,232 715,913 455,487 4,321,191 955,263 757,117 598,690
<br />Cash - End of Year 117,782$ 423,232$ 715,913$ 455,487$ 4,321,191$ 955,263$ 757,117$ 598,690$ 546,931$
<br />Residential 15.36%4.44%12.45%11.07%6.57%4.57%4.37%5.65%5.34%
<br />Base rate per connection 6.00$ 8.00$ 12.00$ 16.00$ 18.00$ 19.00$ 20.00$ 22.00$ 24.00$
<br />Water rate 1st 12,000 gallons used 2.10 2.10 2.20 2.30 2.40 2.50 2.60 2.70 2.80
<br />Water rate 2nd 13,000 gallons used 2.31 2.31 2.42 2.53 2.64 2.75 2.86 2.97 3.08
<br />Water rate over 25,000 gallons used 2.66 2.66 2.78 2.91 3.04 3.16 3.29 3.42 3.54
<br />Residential annual based on 18,000 gal. per qtr.180.24 188.24 211.68 235.12 250.56 262.00 273.44 288.88 304.32
<br />C/I annual based on 150,000 gal. per qtr.1,305.00 1,334.00 1,412.00 1,490.00 1,560.00 1,626.00 1,692.00 1,762.00 1,804.00 17
|