|
City of Mounds View
<br /> Street Light Utility Rate Study
<br /> 5.0% 4.5% 4.5% 4.5%
<br /> Actual Actual Actual Budget Projected Projected Projected Projected
<br /> 2020 2021 2022 2023 2024 2025 2026 2027
<br /> Expenses
<br /> Personnel services $ 14,370 $ 13,863 $ 14,767 $ 14,502 $ 15,227 $ 15,912 $ 16,628 $ 17,377
<br /> Supplies&materials - 855 - 1,000 1,050 1,097 1,147 1,198
<br /> Contractual services 90,302 80,991 101,195 86,350 90,668 94,748 99,011 103,467
<br /> Lease debt service 3,232 - - - - - - -
<br /> Transfer to other funds 2,940 3,028 3,119 3,213 3,309 3,408 3,510 3,616
<br /> Total Expenses 110,844 98,737 119,081 105,065 110,254 115,165 120,297 125,657
<br /> Revenues
<br /> Street light service fee 104,410 105,072 105,179 105,112 116,014 116,014 127,615 127,615
<br /> Investment income(charges) 2,269 (846) (4,402) 1,400 1,008 1,110 1,139 1,266
<br /> Total Revenues 106,679 104,226 100,777 106,512 117,022 117,123 128,754 128,881
<br /> Net change in position (4,165) 5,489 (18,304) 1,447 6,768 1,958 8,457 3,224
<br /> O0 Net position-beginning of year 108,469 104,304 109,793 91,489 92,937 99,705 101,663 110,120
<br /> Net position-end of year $ 104,304 $ 109,793 $ 91,489 $ 92,937 $ 99,705 $ 101,663 $ 110,120 $ 113,344
<br /> Cash flows
<br /> Net change in position $ (4,165) $ 5,489 $ (18,304) $ 1,447 $ 6,768 $ 1,958 $ 8,457 $ 3,224
<br /> Add back:
<br /> Change in receivables/payables (503) 1,118 (387) - - - - -
<br /> Debt service-principal (59,456) - - - - - - -
<br /> Cash-Beginning of Year 141,973 77,849 84,456 65,765 67,213 73,981 75,939 84,396
<br /> Cash-End of Year $ 77,849 $ 84,456 $ 65,765 $ 67,213 $ 73,981 $ 75,939 $ 84,396 $ 87,620
<br /> 0.00% 0.00% 0.00% 0.00% 11.11% 0.00% 10.00% 0.00%
<br /> Quarterly residential service fee $ 4.50 $ 4.50 $ 4.50 $ 4.50 $ 5.00 $ 5.00 $ 5.50 $ 5.50
<br /> Annual fee $ 18.00 $ 18.00 $ 18.00 $ 18.00 $ 20.00 $ 20.00 $ 22.00 $ 22.00
<br />
|