|
City of Mounds View
<br />Street Light Utility Rate Study
<br />3%3%3%3%3%
<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 7,550$ 7,540$ 9,445$ 9,728$ 10,020$ 10,321$ 10,630$ 10,949$ 11,278$
<br />Supplies & materials 1,334 90 - - - - - - -
<br />Contractual services 76,592 77,417 76,346 78,636 80,995 83,425 85,928 88,506 91,161
<br />Lease debt service 2,328 2,118 1,902 9,252 9,252 9,252 9,252 9,252 9,252
<br />Transfer to other funds 2,690 2,771 2,854 2,940 3,028 3,119 3,212 3,309 3,408
<br />Total Expenses 90,494 89,936 90,547 100,556 103,295 106,117 109,023 112,016 115,099
<br />Revenues
<br />Street light service fee 104,224 104,322 104,867 104,412 104,412 110,213 110,213 110,213 110,213
<br />Investment income (charges)1,480 1,921 4,085 2,485 2,966 3,048 3,191 3,278 3,308
<br />Total Revenues 105,704 106,243 108,952 106,897 107,378 113,261 113,404 113,491 113,521
<br />Net change in position 15,210 16,307 18,405 6,340 4,083 7,144 4,381 1,475 (1,578)
<br />Net position - begining of year 58,547 73,757 90,064 108,469 114,810 118,893 126,037 130,418 131,893
<br />Net position - end of year 73,757$ 90,064$ 108,469$ 114,810$ 118,893$ 126,037$ 130,418$ 131,893$ 130,315$
<br />Cash flows
<br />Net change in position 15,210$ 16,307$ 18,405$ 6,340$ 4,083$ 7,144$ 4,381$ 1,475$ (1,578)$
<br /> Add back:
<br />Change in receivables/payables (3,053) (1,097) (5,252) - - - - - -
<br />Debt service - principal (6,923) (7,133) (7,349) - - - - - -
<br />Lease proceeds
<br />Cash - Beginning of Year 122,858 128,092 136,169 141,973 148,314 152,397 159,541 163,922 165,397
<br />Cash - End of Year 128,092$ 136,169$ 141,973$ 148,314$ 152,397$ 159,541$ 163,922$ 165,397$ 163,819$
<br />6.25%0.00%0.00%0.00%0.00%5.56%0.00%0.00%0.00%
<br />Quarterly residential service fee 4.50$ 4.50$ 4.50$ 4.50$ 4.50$ 4.75$ 4.75$ 4.75$ 4.75$
<br />Annual fee 18.00$ 18.00$ 18.00$ 18.00$ 18.00$ 19.00$ 19.00$ 19.00$ 19.00$ 17
|