|
2020 - 2025 Water Fund Forecast with Antenna Lease
<br />Base Charge Increase
<br />2%
<br />or $
<br />50.00
<br />Active
<br />Rate Increase from Prior Year
<br />25%
<br />20%
<br />2%
<br />2%
<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,182,187.15
<br />$ 1,312,280.51
<br />$
<br />1,331,011.71
<br />$
<br />1,350,117.54
<br />$
<br />1,359,861.51
<br />$
<br />1,369,702.92
<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 />193,937.15
<br />302,891.53
<br />291,014.05
<br />269,368.77
<br />244,860.21
<br />227,294.60
<br />Gain / (Loss) - Cash basis
<br />(256,941.22)
<br />(71,547.85)
<br />22,336.53
<br />942.05
<br />18,649.77
<br />58,253.21
<br />455.60
<br />Beg. Cash
<br />610, 690.31
<br />Cash Balance
<br />353,749.09
<br />282,201.24
<br />304,537.77
<br />305,479.82
<br />324,129.59
<br />382,382.80
<br />382,838.40
<br />average capital expenditure requirements with
<br />3% 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 />..................................................................................I..............................
<br />Operation Reserve Goal 25% of Expenses
<br />.......................................................
<br />$
<br />92,971.00
<br />............................................
<br />$
<br />148,237.50
<br />............................................
<br />$ 201,877.80
<br />.............................................
<br />$
<br />259,999.42
<br />.............................................
<br />$
<br />270,187.19
<br />.............................................
<br />$
<br />278,750.33
<br />.............................................
<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 />133,963.74
<br />102,659.97
<br />19,805.03
<br />14,273.95
<br />49,154.48
<br />27,095.90
<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 />$6.55
<br />$7.86
<br />$8.02
<br />$8.18
<br />$8.26
<br />$8.34
<br />Tier 2
<br />$7.33
<br />$9.16
<br />$11.00
<br />$11.21
<br />$11.44
<br />$11.55
<br />$11.67
<br />Tier 3
<br />$11.00
<br />$13.75
<br />$16.50
<br />$16.83
<br />$17.17
<br />$17.34
<br />$17.51
<br />
|