|
Table 5: Cash Flow Projections (Scenario 1)
<br /> Line Cash Flow Projections FY 2019 FY 2020 FY 2021 FY 2022
<br /> 1 Revenue
<br /> 2 Volume-Based Rate Revenue $30,010,113 $31,789,243 $33,648,218 $35,668,479
<br /> 3 Fixed Charge Revenue $16,087,355 $16,569,978 $17,067,078 $17,579,088
<br /> 4 Total Additional Revenue $0 $0 $0 $0
<br /> 5
<br /> 6 Total Rate Revenue $46,097,468 $48,359,221 $50,715,296 $53,247,567
<br /> 7 Investment Earnings $127,019 $105,557 $63,770 $18,456
<br /> 8 Other Revenue $1,146,345 $1,177,925 $1,207,666 $1,238,300
<br /> 9 Total Revenue $47,370,832 $49,642,703 $51,986,733 $54,504,323
<br /> 10
<br /> 11 Expenses
<br /> 12 O&M Expenses $32,649,908 $35,524,235 $37,238,845 $39,022,338
<br /> 13 Water Supply Reliability Projects $1,500,000 $2,000,000 $2,500,000 $3,000,000
<br /> 14 Existing Debt Service $1,692,410 $3,123,338 $3,122,338 $3,124,213
<br /> 15 Proposed Debt Service $0 $0 $0 $0
<br /> 16 Total Expenses $35,842,318 $40,647,573 $42,861,183 $45,146,551
<br /> 17
<br /> 18 Net Cash Flow before Capital Funding $11,528,514 $8,995,130 $9,125,550 $9,357,772
<br /> 19 ACO Transfers $197,406 $203,328 $203,328 $203,328
<br /> 20 Capital Funding $12,300,000 $12,792,000 $13,303,680 $13,835,827
<br /> 21
<br /> 22 Net Cash Flow ($968,892) ($4,000,198) ($4,381,458) ($4,681,383)
<br /> 23
<br /> 24 Fund 100
<br /> 25 Ending Balance $12,567,960 $8,567,762 $4,186,304 ($495,080)
<br /> 26 Target(no Rate Stabilization) $17,974,479 $18,909,392 $19,567,781 $20,260,773
<br /> Under Scenario 1, the Agency will have negative reserve levels in Fund 100 by the end of FY 2022. Figure 1 shows
<br /> the projected fund balances(green bars)with target reserve levels(blue line)and target reserve levels without the
<br /> Rate Stabilization Reserve(black line).
<br /> ZONE 7 WATER AGENCY TREATED WATER WHOLESALE RATE STUDY REPORT 6
<br />
|