RATE SCENARIOS
<br /> Scenario 1: (3% CPI +53M for Water Supply Reliability Projects+ Fully Funding Three Reserves
<br /> at Target Levels+3.7% Rate Adjustments)
<br /> > Includes 3%CPI
<br /> > Includes$3 million(Water Supply Reliability Projects)
<br /> > Funding three reserves at Target Levels(Operating, Emergency and Drought Contingency ), no
<br /> funding for the Rate Stabilization Reserve
<br /> > Includes Fixed Component gradually increasing to 45%
<br /> Scenario 1 —Month! Customer Rate Im pacts
<br /> CY 2018 CY 2019 CY 2020 CY 2021 CY 2022
<br /> Variable Charge ($/ccf) $2.04 $2.01 $2.10 $2.06 $2.15
<br /> Weighted Fixed Charge($/ccf) $1.14 $1.32 $1.43 $1.67 $1.81
<br /> Total Charge ($/ccf) $3.18 $3.33 $3.53 $3.73 $3.96
<br /> Dollar Amount Difference
<br /> 10 ccf $1.50 $2.03 $2.02 $2.31
<br /> 15 ccf $2.24 $3.04 $3.03 $3.47
<br /> 20 ccf $2.99 $4.06 $4.03 $4.63
<br /> Scenario 1 —Proforma Cash Flow
<br /> FY 2019 FY 2020 FY 2021 FY 2022
<br /> Revenue
<br /> Volume-Based Rate Revenue $30,010,113 $31,789,243 $33,648,218 $35,668,479
<br /> Fixed Charge Revenue $16,087,355 $16,569,978 $17,067,078 $17,579,088
<br /> Total Additional Revenue $852,803 $2,717,039 $4,831,308 $7,230,384
<br /> Total Rate Revenue $46,950,271 $51,076,260 $55,546,604 $60,477,951
<br /> Investment Earnings $127,019 $142,463 $154,054 $187,846
<br /> Other Revenuer $1,146,345 $1,177,925 $1,207,666 $1,238,300
<br /> Total Revenue $48,223,635 $52,396,647 $56,908,324 $61,904,097
<br /> Expenses
<br /> O&M Expenses $32,649,908 $35,524,235 $37,238,845 $39,022,338
<br /> Water Supply Reliability Projects $500,000 $500,000 $1,000,000 $1,000,000
<br /> Existing Debt Service $1,692,410 $3,123,338 $3,122,338 $3,124,213
<br /> Proposed Debt Service $0 $0 $0 $0
<br /> Total Expenses $34,842,318 $39,147,573 $41,361,183 $43,146,551
<br /> Net Cash Flow before Capital Funding $13,381,317 $13,249,074 $15,547,141 $18,757,546
<br /> ACO Transfers $197,406 $203,328 $203,328 $203,328
<br /> Capital Funding $12,300,000 $12,792,000 $13,303,680 $13,835,827
<br /> Net Cash Flow $883,911 $253,746 $2,040,133 $4,718,391
<br /> Fund 100
<br /> Ending Balance $14,131,548 $14,385,295 $16,425,428 $21,143,819
<br /> Target(no Rate Stabilization) $18,059,759 $19,181,096 $20,050,911 $20,983,811
<br /> 'Other revenue include untreated revenue at approx.$1M annually and other miscellaneous revenue(rents,royalties,well permit fees,
<br /> inspection fees etc.)
<br /> 8
<br />
|