|
2020 - 2025 Water Fund Forecast With Minnetonka Beach
<br />Base Charge Increase
<br />2%
<br />or $
<br />50.00
<br />Active
<br />Rate Increase from Prior Year
<br />20%
<br />16%
<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 />$
<br />881,213.78
<br />$
<br />1,233,320.47
<br />$ 1,356,376.50
<br />$
<br />1,377,989.62
<br />$
<br />1,400,035.00
<br />$
<br />1,422,521.30
<br />$
<br />1,445,457.32
<br />Estimated Cash Expenses
<br />1,138,155.00
<br />1,378,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 />346,987.52
<br />337,991.96
<br />319,286.24
<br />307,520.00
<br />303,049.00
<br />Gain / (Loss) - Cash basis
<br />(256,941.22)
<br />(145,414.53)
<br />66,432.52
<br />47,919.96
<br />68,567.24
<br />120,913.00
<br />76,210.00
<br />Beg. Cash
<br />610,690.31
<br />Cash Balance
<br />353,749.09
<br />208,334.57
<br />274,767.08
<br />322,687.04
<br />391,254.28
<br />512,167.27
<br />588,377.27
<br />average capital expenditure requirements with
<br />3% inflation
<br />........................................................................................................................................................................
<br />$
<br />234,966.00
<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 />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 />60,097.07
<br />72,889.29
<br />(1,500.80)
<br />54,953.01
<br />165,319.45
<br />232,634.77
<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 />$7.29
<br />$7.44
<br />$7.59
<br />$7.74
<br />$7.90
<br />Tier 2
<br />$7.33
<br />$8.80
<br />$10.20
<br />$10.41
<br />$10.62
<br />$10.83
<br />$11.04
<br />Tier 3
<br />$11.00
<br />$13.20
<br />$15.31
<br />$15.62
<br />$15.93
<br />$16.25
<br />$16.57
<br />Minnetonka Beach Water Rate
<br />6.29
<br />$7.29
<br />$7.44
<br />$7.59
<br />$7.74
<br />$7.90
<br />
|