|
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%25%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.32 1,089,684.64 0.20 1,309,355.80 0.03 1,342,306.48 0.02 1,371,595.67 0.03 1,406,553.04 0.03 1,442,559.13
<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 125,000.00 - - -
<br />Total Estimated Revenue 865,402.60$ 1,235,071.64$ 1,329,742.80$ 1,362,693.48$ 1,391,982.67$ 1,426,940.04$ 1,462,946.13$
<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) 127,128.44 316,464.48 313,085.33 317,444.10 336,764.44 356,820.76
<br />Debt Service (Cash Expense)157,000.00 155,000.00 202,000.00 257,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)$ 101,300.46$ 126,976.05$ 42,327.33$ 245,244.80$ 258,491.45$ 267,396.07$
<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$ 195,693.07$ 322,669.12$ 364,996.44$ 610,241.24$ 868,732.69$ 1,136,128.75$
<br />Surplus (Deficit) for reserve amt 1,421.60$ 3,181.83$ 12,127.43$ 43,502.73$ 280,589.27$ 533,188.04$ 794,553.73$
<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.55 8.19 8.43 8.68 8.94 9.21
<br />Tier 2 5.06 7.33 9.17 11.46 11.80 12.16 12.52 12.90
<br />Tier 3 7.59 11.00 13.75 17.19 17.71 18.24 18.78 19.35
<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
|