|
2020 - 2025 Stormwater Fund Forecast
<br />2019
<br />2020
<br />2021
<br />2022
<br />2023
<br />2024
<br />2025
<br />Rate Increase
<br />95%
<br />7%
<br />2%
<br />2%
<br />2%
<br />2%
<br />Rate = $24.34
<br />Rate = $47.46
<br />Rate = $50.79
<br />Rate = $51.8
<br />Rate = $52.84
<br />Rate = $53.89
<br />Rate =
<br />$54.97
<br />Total
<br />Total
<br />Total
<br />Total
<br />Total
<br />Total
<br />Total
<br />Estimated Revenue
<br />352,218.06
<br />694,609.14
<br />743,231.78
<br />758,096.41
<br />773,258.34
<br />788,723.51
<br />804,497.98
<br />Inflation
<br />Budgeted Amt
<br />2.04%
<br />2.07%
<br />2.12%
<br />2.07%
<br />2.07%
<br />Total Cash Expenditure
<br />976,685.00
<br />991,425.00
<br />735,464.40
<br />855,073.43
<br />703,390.39
<br />817,232.55
<br />796,616.44
<br />Gain / (Loss) - Non-cash basis
<br />(4,591.94)
<br />321,609.14
<br />354,433.38
<br />356,047.99
<br />356,070.95
<br />358,425.96
<br />358,877.54
<br />Gain / (Loss) - Cash basis
<br />(624,466.95)
<br />(296,815.86)
<br />7,767.38
<br />(96,977.01)
<br />69,867.95
<br />(28,509.04)
<br />7,881.54
<br />Beg Cash
<br />1,293,812.81
<br />669,345.87
<br />372,530.00
<br />380,297.38
<br />283,320.37
<br />353,188.32
<br />324,679.28
<br />Year End Cash Balance
<br />669,345.87
<br />372,530.00
<br />380,297.38
<br />283,320.37
<br />353,188.32
<br />324,679.28
<br />332,560.82
<br />average capital expenditure requirements with
<br />3% inflation (2018-2034)
<br />.........................................................................................................................................................................................................................................................................................................................................................................................................................................................
<br />648,643.00
<br />668,102.29
<br />688,145.36
<br />708,789.72
<br />730,053.41
<br />751,955.01
<br />774,513.66
<br />Operation Reserve Goal 25% of Expenses
<br />89,202.50
<br />93,250.00
<br />97,199.60
<br />100,512.11
<br />104,296.85
<br />107,574.39
<br />111,405.11
<br />Capital Reserve 25% of expenses
<br />0.00
<br />0.00
<br />172,036.34
<br />177,197.43
<br />182,513.35
<br />187,988.75
<br />193,628.42
<br />Total Cash Reserve Required
<br />89,202.50
<br />93,250.00
<br />269,235.94
<br />277,709.54
<br />286,810.20
<br />295,563.14
<br />305,033.53
<br />Excess Funds over Cash Reserve
<br />580,143.37
<br />279,280.00
<br />111,061.44
<br />5,610.83
<br />66,378.12
<br />29,116.14
<br />27,527.30
<br />
|