|
2020 - 2025 Stormwater Fund Forecast less 100k for Culverts (phase in start 2022)
<br />2019
<br />2020
<br />2021
<br />2022
<br />2023
<br />2024
<br />2025
<br />Rate Increase
<br />90%
<br />2%
<br />2%
<br />2%
<br />2%
<br />2%
<br />Rate = $24.34
<br />Rate = $46.25
<br />Rate = $47.17
<br />Rate = $48.11
<br />Rate = $49.08
<br />Rate = $50.06
<br />Rate =
<br />$51.06
<br />Total
<br />Total
<br />Total
<br />Total
<br />Total
<br />Total
<br />Total
<br />Estimated Revenue
<br />352,218.06
<br />676,798.65
<br />690,334.62
<br />704,141.31
<br />718,224.14
<br />732,588.62
<br />747,240.40
<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 />891,425.00
<br />635,464.40
<br />780,073.43
<br />653,390.39
<br />792,232.55
<br />796,616.44
<br />Gain / (Loss) - Non-cash basis
<br />(4,591.94)
<br />303,798.65
<br />301,536.22
<br />302,092.88
<br />301,036.75
<br />302,291.08
<br />301,619.96
<br />Gain / (Loss) - Cash basis
<br />(624,466.95)
<br />(214,626.35)
<br />54,870.22
<br />(75,932.12)
<br />64,833.75
<br />(59,643.92)
<br />(49,376.04)
<br />Beg Cash
<br />1,293,812.81
<br />669,345.87
<br />454,719.51
<br />509,589.73
<br />433,657.62
<br />498,491.37
<br />438,847.44
<br />Year End Cash Balance
<br />669,345.87
<br />454,719.51
<br />509,589.73
<br />433,657.62
<br />498,491.37
<br />438,847.44
<br />389,471.40
<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 />361,469.51
<br />240,353.80
<br />155,948.08
<br />211,681.16
<br />143,284.30
<br />84,437.87
<br />
|