|
2020 - 2025 Water Fund Forecast with Antenna Lease Phase In
<br />Base Charge Increase
<br />2%
<br />or $
<br />50.00
<br />Active
<br />Rate Increase from Prior Year
<br />35%
<br />20%
<br />6%
<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 />$ 881,213.78
<br />$
<br />1,144,624.49
<br />$ 1,287,205.32
<br />$
<br />1,372,894.42
<br />1 $
<br />1,408,616.16
<br />$
<br />1,444,445.12
<br />$
<br />1,480,382.37
<br />*Antenna
<br />Lease Phase
<br />in Starts 2022
<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 />332,896.76
<br />327,867.40
<br />329,443.82
<br />337,974.05
<br />Gain / (Loss) - Cash basis
<br />(256,941.22)
<br />(109,110.51)
<br />(2,738.66)
<br />42,824.76
<br />77,148.40
<br />142,836.82
<br />111,135.05
<br />Beg. Cash
<br />610,690.31
<br />Cash Balance
<br />353,749.09
<br />244,638.58
<br />241,899.93
<br />284,724.69
<br />361,873.08
<br />504,709.90
<br />615,844.95
<br />average capital expenditure requirements with 3%
<br />inflation
<br />..................................................................................................................................................................................................................................................................................................................................................................................................................................................
<br />$ 234,966.00
<br />$
<br />242,014.98
<br />$ 249,275.43
<br />$
<br />256,753.69
<br />$
<br />264,456.30
<br />$
<br />272,389.99
<br />$
<br />280,561.69
<br />Operation Reserve Goal 25% of Expenses
<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 />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 />(950.10)
<br />52,017.45
<br />171,481.58
<br />260,102.45
<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.00
<br />$9.09
<br />$9.18
<br />$9.27
<br />Tier 2
<br />$7.33
<br />$9.90
<br />$11.87
<br />$12.59
<br />$12.71
<br />$12.84
<br />$12.97
<br />Tier 3
<br />$11.00
<br />$14.85
<br />$17.82
<br />$18.89
<br />$19.08
<br />$19.27
<br />$19.46
<br />
|