|
Increases 601-_____-___12/31/2019 Base Charge Increase 11%or Flat Base Rate 50.00$ Active
<br />2019 - 30%Rate Increase from Prior Year 30%30%25%3%3%(if rate increase year to year differs)(if rate increase year to year differs)(if rate increase year to year differs)
<br />2020 - 25%Inflation - 5 Yr Forecast 2%Tier 1 to 2 Rate Increase 40%active
<br />2021 - 25%Tier 2 to 3 Rate Increase 50%active
<br />2022+ 3%12/31/2019 12/31/2020 12/31/2021 12/31/2022 12/31/2023 12/31/2024 12/31/2025
<br />Consumption
<br />Per Level Rate Calculated Amount Consumption
<br />Per Level Rate Calculated Amount Consumption
<br />Per Level Rate Calculated
<br />Amount
<br />Consumption
<br />Per Level Rate Calculated
<br />Amount
<br />Consumption
<br />Per Level Rate Calculated
<br />Amount
<br />Consumption
<br />Per Level Rate Calculated
<br />Amount
<br />Consumption
<br />Per Level Rate Calculated
<br />Amount
<br />Total Estimated Service Revenue 825,015.60 0.36 1,124,832.03 0.20 1,353,290.04 0.03 1,387,558.74 0.02 1,418,205.50 0.03 1,454,561.16 0.03 1,492,007.50
<br />Estimated Misc. Revenue 10,000.00 10,000.00 10,000.00 10,000.00 10,000.00 10,000.00 10,000.00
<br />Estimated Assessment 10,387.00 10,387.00 10,387.00 10,387.00 10,387.00 10,387.00 10,387.00
<br />Supplemented Revenue 20,000.00 100,000.00 - - -
<br />Total Estimated Revenue 865,402.60$ 1,245,219.03$ 1,373,677.04$ 1,407,945.74$ 1,438,592.50$ 1,474,948.16$ 1,512,394.50$
<br />Budgeted Expenses w/ Dep.929,710.00 Budgeted expense 962,556.20 Budgeted expense 992,891.32 Budgeted expense 1,029,221.15 Budgeted expense 1,054,151.57 Budgeted expense 1,069,788.60 Budgeted expense 1,085,738.38
<br />Less Depreciation 207,400.00 Less Dep.225,800.00 Less Dep.241,400.00 Less Dep.262,700.00 Less Dep.272,300.00 Less Dep.272,300.00 Less Dep.272,300.00
<br />Budgeted Expenses - Cash 722,310.00$ 736,756.20$ 751,491.32$ 766,521.15$ 781,851.57$ 797,488.60$ 813,438.38$
<br />Gain / (Loss) - Non-cash basis (64,307.40) 162,275.83 360,398.71 358,337.59 364,053.93 384,772.56 406,269.12
<br />Debt Service (Cash Expense)157,000.00 155,000.00 267,000.00 277,000.00 100,430.00 98,570.00 101,550.00
<br />CIP Amount (Cash Expense)428,700.00 242,014.98 249,275.43 296,845.00 264,456.30 272,389.99 280,561.69
<br />Gain / (Loss) - Cash basis (442,607.40)$ 111,447.85$ 105,910.28$ 67,579.59$ 291,854.62$ 306,499.57$ 316,844.43$
<br />Beg. Cash
<br />537,000.00$
<br />Operation Reserve Goal 25% of Expenses 92,971.00$ 192,511.24$ 248,222.83$ 257,305.29$ 263,537.89$ 267,447.15$ 271,434.59$
<br />Capital Reserve 25% of expenses -$ -$ 62,318.86$ 64,188.42$ 66,114.08$ 68,097.50$ 70,140.42$
<br />Total Cash Reserve Required 92,971.00$ 192,511.24$ 310,541.69$ 321,493.71$ 329,651.97$ 335,544.65$ 341,575.02$
<br />Cash Balance 94,392.60$ 205,840.45$ 311,750.73$ 379,330.32$ 671,184.94$ 977,684.51$ 1,294,528.94$
<br />Surplus (Deficit) for reserve amt 1,421.60$ 13,329.21$ 1,209.05$ 57,836.61$ 341,532.98$ 642,139.86$ 952,953.93$
<br />Flat Rate 45.11 50.00 50.00 50.00 50.00 50.00 50.00 50.00
<br />Tier 1 4.03 5.24 6.81 8.51 8.77 9.03 9.30 9.58
<br />Tier 2 5.06 7.33 9.53 11.92 12.28 12.64 13.02 13.41
<br />Tier 3 7.59 11.00 14.30 17.88 18.41 18.97 19.54 20.12
<br />2025 (2013-2018 Avg Consumption)2025 (2013-2018 Avg Consumption)
<br />Water 7 Year Forecast
<br />2019 (2013-2018 Avg Consumption)2020 (2013-2018 Avg Consumption)2021 (2013-2018 Avg Consumption)2022 (2013-2018 Avg Consumption)2023 (2013-2018 Avg Consumption)
<br />Exhibit B - Water Fund Projections
|