|
2020
<br />- 2025 Sewer Fund Forecast
<br />2019
<br />2020
<br />2021
<br />2022
<br />2023
<br />2024
<br />2025
<br />Rate Increase
<br />20%
<br />15%
<br />2%
<br />2%
<br />2%
<br />2%
<br />Rate By Unit
<br />$156.80; Add'I $138.60
<br />$188.16; Add'I $166.32
<br />$216.38; Add'I $191.27
<br />$220.71; Add'I $195.09
<br />$225.13; Add'I $199
<br />$229.63; Add'1 $202.98
<br />$234.22; Add'I $207.03
<br />Rate By Flow (Base & per thousand)
<br />15.00 5.80
<br />6.96
<br />8.00
<br />8.16
<br />8.33
<br />8.49
<br />8.66
<br />Rate Amount
<br />Rate Amount
<br />Rate Amount
<br />Rate Amount
<br />Rate Amount
<br />Rate Amount
<br />Rate Amount
<br />Total Estimated Revenue
<br />1,581,459.80
<br />1,893,777.96
<br />2,167,561.30
<br />2,206,871.17
<br />2,248,437.91
<br />2,285,575.63
<br />2,330,935.76
<br />Expenditure Inflation:
<br />Budgeted Amt
<br />2.04%
<br />2.07%
<br />2.12%
<br />2.07%
<br />2.07%
<br />Total Expenditure - Cash Basis
<br />2,324,243.00
<br />2,447,350.00
<br />2,352,427.04
<br />2,240,542.43
<br />2,499,585.03
<br />1,985,166.05
<br />2,688,992.26
<br />Beg. Cash
<br />2,578,241.13
<br />Gain / (Loss) - Cash basis
<br />(742,783.20)
<br />(553,572.04)
<br />(184,865.74)
<br />(33,671.26)
<br />(251,147.12)
<br />300,409.58
<br />(358,056.49)
<br />Estimated YE Cash Balance
<br />1,835,457.93
<br />1,281,885.89
<br />1,097,020.15
<br />1,063,348.89
<br />812,201.78
<br />1,112,611.36
<br />754,554.86
<br />average capital expenditure requirements
<br />with 3% inflation (2018-2034)
<br />..................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................
<br />792,795.00816,578.85
<br />841,076.22
<br />866,308.50
<br />892,297.76
<br />919,066.69
<br />946,638.69
<br />Operation Reserve Goal 2S% of Expenses
<br />406,043.75
<br />447,800.00
<br />461,006.76
<br />473,599.86
<br />484,792.76
<br />495,319.51
<br />505,949.31
<br />Capital Reserve 25% of expenses
<br />0.00
<br />0.00
<br />1 210,269.05
<br />216,577.13
<br />223,074.44
<br />229,766.67
<br />236,659.67
<br />Total Cash Reserve Required
<br />671,275.81
<br />690,176.98
<br />707,867.20
<br />725,086.19
<br />742,608.99
<br />Excess Funds over Cash Reserve
<br />425,744.34
<br />373,171.91
<br />104,334.58
<br />387,525.17
<br />11,945.88
<br />
|