|
2020 - 2025 Water Fund Forecast
<br />Base Charge Increase
<br />2%
<br />or $
<br />50.00
<br />Active
<br />Rate Increase from Prior Year
<br />35%
<br />20%
<br />10%
<br />1%
<br />1%
<br />1%
<br />Inflation - 5 Yr Forecast
<br />Budgeted Amt
<br />2.04%
<br />2.07%
<br />2.12%
<br />2.07%
<br />2.07%
<br />Tier 1 to 2 Rate Increase
<br />26%
<br />Inactive
<br />Tier 2 to 3 Rate Increase
<br />50%
<br />Inactive
<br />Based on 2013-2018 Avg Consumption
<br />2019
<br />2020
<br />2021
<br />2022
<br />2023
<br />2024
<br />2025
<br />Calculated
<br />Calculated
<br />Calculated
<br />Calculated
<br />Calculated
<br />Calculated
<br />Calculated
<br />Amount
<br />Amount
<br />Amount
<br />Amount
<br />Amount
<br />Amount
<br />Amount
<br />Total Estimated Revenue
<br />$
<br />881,213.78
<br />$
<br />1,144,624.49
<br />$ 1,287,205.32
<br />$
<br />1,388,353.82
<br />$
<br />1,399,480.16
<br />$
<br />1,410,717.75
<br />$
<br />1,422,067.73
<br />Estimated Cash Expenses
<br />1,138,155.00
<br />1,253,735.00
<br />1,289,943.98
<br />1,330,069.66
<br />1,331,467.77
<br />1,301,608.30
<br />1,369,247.32
<br />Gain / (Loss) - Non-cash basis
<br />(48,496.22)
<br />156,374.49
<br />277,816.34
<br />348,356.16
<br />318,731.39
<br />295,716.45
<br />279,659.41
<br />Gain / (Loss) - Cash basis
<br />(256,941.22)
<br />(109,110.51)
<br />(2,738.66)
<br />58,284.16
<br />68,012.39
<br />109,109.45
<br />52,820.41
<br />Beg. Cash
<br />610,690.31
<br />Cash Balance
<br />353,749.09
<br />244,638.58
<br />241,899.93
<br />300,184.09
<br />368,196.48
<br />477,305.93
<br />530,126.34
<br />average capital expenditure requirements with
<br />3% inflation
<br />...................................................................................................................................................................
<br />$
<br />234,966.00
<br />.....
<br />$
<br />.............................................
<br />242,014.98
<br />$ 249,275.43
<br />.............................................
<br />$
<br />.............................................
<br />256,753.69
<br />$
<br />.............................................
<br />264,456.30
<br />$
<br />.............................................
<br />272,389.99
<br />$
<br />............................................
<br />280,561.69
<br />Operation Reserve Goal 25% of Expenses
<br />$
<br />92,971.00
<br />$
<br />148,237.50
<br />$ 201,877.80
<br />$
<br />259,999.42
<br />$
<br />270,187.19
<br />$
<br />278,750.33
<br />$
<br />285,602.08
<br />Capital Reserve 25% of expenses
<br />$
<br />-
<br />$
<br />-
<br />$ -
<br />$
<br />25,675.37
<br />$
<br />39,668.45
<br />$
<br />54,478.00
<br />$
<br />70,140.42
<br />Total Cash Reserve Required
<br />92,971.00
<br />148,237.50
<br />201,877.80
<br />285,674.78
<br />309,855.64
<br />333,228.32
<br />355,742.50
<br />Excess Funds over Cash Reserve
<br />260,778.09
<br />96,401.08
<br />40,022.13
<br />14,509.30
<br />58,340.84
<br />144,077.60
<br />174,383.83
<br />Flat Rate
<br />$50.00
<br />$50.00
<br />$50.00
<br />$50.00
<br />$50.00
<br />$50.00
<br />$50.00
<br />Tier 1
<br />$5.24
<br />$7.07
<br />$8.49
<br />$9.34
<br />$9.43
<br />$9.53
<br />$9.62
<br />Tier 2
<br />$7.33
<br />$9.90
<br />$11.87
<br />$13.06
<br />$13.19
<br />$13.32
<br />$13.46
<br />Tier 3
<br />$11.00
<br />$14.85
<br />$17.82
<br />$19.60
<br />$19.80
<br />$20.00
<br />$20.20
<br />
|