|
City of Mounds View
<br /> Water Utility Rate Study
<br /> 5.00% 4.50% 4.50% 4.50% 4.50%
<br /> Actual Actual Actual Budget Projected Projected Projected Projected Projected
<br /> 2020 2021 2022 2023 2024 2025 2026 2027 2028
<br /> Expenses
<br /> Personnel services $ 457,321 $ 423,219 $ 495,022 $ 504,222 $ 554,433 $ 579,383 $ 605,455 $ 632,700 $ 661,172
<br /> Supplies&materials 53,320 68,368 81,164 80,052 84,055 87,837 91,790 95,920 100,237
<br /> Contractual services 225,957 239,676 285,051 171,202 179,762 187,851 196,305 205,138 214,370
<br /> Water service line repairs 94,981 90,444 147,997 90,000 100,000 108,000 116,000 116,000 124,000
<br /> Depreciation 198,159 194,481 186,181 220,000 408,000 408,000 408,000 408,000 408,000
<br /> Debt service-interest/issuance costs 100,764 77,350 71,186 86,173 76,173 69,023 61,723 54,273 46,673
<br /> Transfers to other funds 149,859 155,345 157,905 170,542 173,258 176,056 178,938 181,906 150,345
<br /> Contingency - - - 15,000 15,000 15,000 15,000 15,000 15,000
<br /> Total Expenses 1,280,361 1,248,883 1,424,506 1,337,191 1,590,681 1,631,150 1,673,210 1,708,938 1,719,796
<br /> Revenues
<br /> Metered water sales 1,261,207 1,362,622 1,357,766 1,369,584 1,461,952 1,550,109 1,604,147 1,658,184 1,712,222
<br /> Meter charge 660 146 270 - - - -
<br /> Water service line repair fee 93,774 95,441 95,282 92,000 100,000 110,000 110,000 120,000 120,000
<br /> Investment income(charges) 6,257 4,157 (83,778) 2,000 (8,217) (9,214) (8,577) (8,886) (7,734)
<br /> Miscellaneous revenues 10,605 1,571 2,767 2,000 2,060 2,122 2,185 2,251 2,319
<br /> Transfers from vehicle&equipment fund - 125,000 - 82,500 - - 150,000 142,000 -
<br /> Total Revenues 1,372,503 1,588,937 1,372,307 1,548,084 1,555,795 1,653,017 1,857,755 1,913,549 1,826,806
<br /> CD Change in net position 92,142 340,054 (52,199) 210,893 (34,886) 21,867 184,545 204,611 107,010
<br /> Accounting change(GASB 68 pension)
<br /> Net position-beginning of year 4,181,479 4,273,621 4,613,675 4,561,476 4,772,369 4,737,483 4,759,350 4,943,895 5,148,506
<br /> Net position-end of year $ 4,273,621 $ 4,613,675 $ 4,561,476 $ 4,772,369 $ 4,737,483 $ 4,759,350 $ 4,943,895 $ 5,148,506 $ 5,255,516
<br /> Cash flows
<br /> Change in net position $ 92,142 $ 340,054 $ (52,199) $ 210,893 $ (34,886) $ 21,867 $ 184,545 $ 204,611 $ 107,010
<br /> Deduct:
<br /> Capital outlays-equipment - - (16,238) (1,472,500) - - (150,000) (142,000) -
<br /> Construction (2,959,544) (1,772,293) (1,048,732) (235,000) (80,000) (50,000) (100,000) (50,000) (50,000)
<br /> Debt service-principal - - (335,000) (350,000) (355,000) (360,000) (370,000) (375,000) (385,000)
<br /> Add back:
<br /> Bonds issued 6,101,528 - - - -
<br /> Depreciation 198,159 194,481 186,181 220,000 420,000 420,000 420,000 420,000 408,000
<br /> Change in receivables/payables(cash flow stmt.) 169,266 (164,281) (394,035) - - -
<br /> Cash-Beginning of Year 676,292 4,277,843 2,875,804 1,215,781 (410,826) (460,712) (428,845) (444,300) (386,689)
<br /> Cash-End of Year $ 4,277,843 $ 2,875,804 $ 1,215,781 $ (410,826) $ (460,712) $ (428,845) $ (444,300) $ (386,689) $ (306,679)
<br /> Residential 6.57% 4.57% 4.37% 4.18% 6.73% 6.30% 3.54% 3.42% 3.31%
<br /> Base rate per connection $ 18.00 $ 19.00 $ 20.00 $ 21.00 $ 23.00 $ 25.00 $ 26.00 $ 27.00 $ 28.00
<br /> Water rate 1st 12,000 gallons used 2.40 2.50 2.60 2.70 2.85 3.00 3.10 3.20 3.30
<br /> Water rate 2nd 13,000 gallons used 2.64 2.75 2.86 2.97 3.14 3.30 3.41 3.52 3.63
<br /> Water rate over 25,000 gallons used 3.04 3.16 3.29 3.42 3.61 3.80 3.92 4.05 4.17
<br /> Water Line Insurance per quarter(residential only) 7.50 8.00 8.00 9.00 9.00 9.00 9.00 9.00 9.00
<br /> Residential annual based on 18,000 gal.per qtr. 250.56 262.00 273.44 284.88 304.04 323.20 334.64 346.08 357.52
<br /> C/I annual based on 150,000 gal.per qtr. 1,560.00 1,626.00 1,692.00 1,758.00 1,830.50 1,930.00 1,995.00 2,060.00 2,125.00
<br /> Change in tiers residential
<br /> Change in tiers commercial
<br />
|