|
City of Mounds View
<br />Street Light Utility Rate Study
<br />3%3%3%3%3%3%
<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 7,540$ 9,445$ 14,370$ 11,582$ 11,929$ 12,287$ 12,656$ 13,036$ 13,427$
<br />Supplies & materials 90 - - 1,000 1,030 1,061 1,093 1,126 1,159
<br />Contractual services 77,417 76,346 90,302 82,350 84,821 87,365 89,986 92,686 95,466
<br />Lease debt service 2,118 1,902 3,232 - - - - - -
<br />Transfer to other funds 2,771 2,854 2,940 3,028 3,119 3,212 3,309 3,408 3,510
<br />Total Expenses 89,936 90,547 110,844 97,960 100,899 103,926 107,044 110,255 113,562
<br />Revenues
<br />Street light service fee 104,322 104,867 104,410 105,112 104,412 104,412 104,412 110,213 110,213
<br />Investment income (charges)1,921 4,085 2,269 1,400 1,728 1,833 1,879 1,864 1,901
<br />Total Revenues 106,243 108,952 106,679 106,512 106,140 106,245 106,291 112,077 112,114
<br />Net change in position 16,307 18,405 (4,165) 8,552 5,241 2,319 (752) 1,822 (1,449)
<br />Net position - begining of year 73,757 90,064 108,469 104,304 112,856 118,098 120,417 119,665 121,487
<br />Net position - end of year 90,064$ 108,469$ 104,304$ 112,856$ 118,098$ 120,417$ 119,665$ 121,487$ 120,038$
<br />Cash flows
<br />Net change in position 16,307$ 18,405$ (4,165)$ 8,552$ 5,241$ 2,319$ (752)$ 1,822$ (1,449)$
<br />Add back:
<br />Change in receivables/payables (1,097) (5,252) (503) - - - - - -
<br />Debt service - principal (7,133) (7,349) (59,456) - - - - - -
<br />Lease proceeds
<br />Cash - Beginning of Year 128,092 136,169 141,973 77,849 86,401 91,643 93,962 93,210 95,032
<br />Cash - End of Year 136,169$ 141,973$ 77,849$ 86,401$ 91,643$ 93,962$ 93,210$ 95,032$ 93,583$
<br />0.00%0.00%0.00%0.00%0.00%0.00%0.00%5.56%0.00%
<br />Quarterly residential service fee 4.50$ 4.50$ 4.50$ 4.50$ 4.50$ 4.50$ 4.50$ 4.75$ 4.75$
<br />Annual fee 18.00$ 18.00$ 18.00$ 18.00$ 18.00$ 18.00$ 18.00$ 19.00$ 19.00$
|