|
2020 - 2025 Stormwater Fund Forecast
<br />2019
<br />2020
<br />2021
<br />2022
<br />2023
<br />2024
<br />2025
<br />Rate Increase
<br />60%
<br />40%
<br />3%
<br />2%
<br />2%
<br />2%
<br />Rate = $24.34
<br />Rate = $38.94
<br />Rate = $54.52
<br />Rate = $56.16
<br />Rate = $57.28
<br />Rate = $58.43
<br />Rate =
<br />$59.59
<br />Total
<br />Total
<br />Total
<br />Total
<br />Total
<br />Total
<br />Total
<br />Estimated Revenue
<br />352,218.06
<br />569,935.70
<br />797,909.99
<br />821,847.29
<br />838,284.23
<br />855,049.92
<br />872,150.91
<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 />196,935.70
<br />409,111.59
<br />419,798.86
<br />421,096.84
<br />424,752.37
<br />426,530.48
<br />Gain / (Loss) - Cash basis
<br />(624,466.95)
<br />(421,489.30)
<br />62,445.59
<br />(33,226.14)
<br />134,893.84
<br />37,817.37
<br />75,534.48
<br />Beg Cash
<br />1,293,812.81
<br />669,345.87
<br />247,856.57
<br />310,302.15
<br />277,076.01
<br />411,969.85
<br />449,787.22
<br />Year End Cash Balance
<br />669,345.87
<br />247,856.57
<br />310,302.15
<br />277,076.01
<br />411,969.85
<br />449,787.22
<br />525,321.69
<br />average capital expenditure requirements with
<br />3% inflation (2018-2034)
<br />.................................................................................................................
<br />648,643.00
<br />.......................................................................................................................................................................................................................................................................................................................................
<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 />154,606.57
<br />41,066.21
<br />(633.53)
<br />125,159.65
<br />154,224.08
<br />220,288.17
<br />
|