|
2020 - 2025 Water Fund Forecast With Minnetonka Beach and Antenna Lease Phase In
<br />Base Charge Increase
<br />2%
<br />or $
<br />50.00
<br />Active
<br />Rate Increase from Prior Year
<br />20%
<br />9%
<br />2%
<br />2%
<br />2%
<br />2%
<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,233,320.47
<br />$ 1,291,164.49
<br />$
<br />1,336,473.37
<br />$
<br />1,382,188.43
<br />$
<br />1,428,317.79
<br />$
<br />1,474,869.74
<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 />245,070.47
<br />281,775.51
<br />296,475.71
<br />301,439.66
<br />313,316.49
<br />332,461.42
<br />Gain / (Loss) - Cash basis
<br />(256,941.22)
<br />(20,414.53)
<br />1,220.51
<br />6,403.71
<br />50,720.66
<br />126,709.49
<br />105,622.42
<br />Beg. Cash
<br />610, 690.31
<br />Cash Balance
<br />353,749.09
<br />333,334.57
<br />334,555.07
<br />340,958.78
<br />391,679.44
<br />518,388.93
<br />624,011.35
<br />average capital expenditure requirements with
<br />3% inflation
<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 />$ 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 />64,188.42
<br />$
<br />66,114.08
<br />$
<br />68,097.50
<br />$
<br />70,140.42
<br />Total Cash Reserve Required
<br />92,971.00
<br />148,237.50
<br />201,877.80
<br />324,187.84
<br />336,301.27
<br />346,847.82
<br />355,742.50
<br />Excess Funds over Cash Reserve
<br />260,778.09
<br />185,097.07
<br />132,677.28
<br />16,770.94
<br />55,378.18
<br />171,541.11
<br />268,268.85
<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.29
<br />$6.85
<br />$6.99
<br />$7.13
<br />$7.27
<br />$7.42
<br />Tier 2
<br />$7.33
<br />$8.80
<br />$9.59
<br />$9.78
<br />$9.97
<br />$10.17
<br />$10.38
<br />Tier 3
<br />$11.00
<br />$13.20
<br />$14.39
<br />$14.68
<br />$14.97
<br />$15.27
<br />$15.57
<br />Minnetonka Beach Water Rate
<br />6.29
<br />$6.85
<br />$6.99
<br />$7.13
<br />$7.27
<br />$7.42
<br />
|