reserve targets of 35% of annual water and recycled water O&M expenses are derived from the City's existing
<br /> reserve policies. Under the status quo scenario, the water utility as a whole will not meet reserve targets in any year
<br /> of the Study period.
<br /> Table 2-18: Status Quo Financial Plan
<br /> 1 Revenues
<br /> 2 Rate Revenues
<br /> 3 Water $26,918,811 $27,734,889 $28,578,405
<br /> 4 Recycled Water $3,255,500 $3,216,401 $3,256,700
<br /> 5 Revenue Adjustments $0 $0 $0
<br /> 6 Other Revenues-Water $2,720,041 $1,021,041 $1,047,000
<br /> 7 Other Revenues-Recycled Water $969,462 $987,962 $1,036,462
<br /> 8 Interest Income-Water $275,000 $0 $0
<br /> 9 Interest Income-Recycled Water $0 $0 $0
<br /> 10 Total-Revenues $34,138,814 $32,960,292 $33,918,568
<br /> 11
<br /> 12 O&M Expenses
<br /> 13 Purchased Water Fixed-Water $9,314,331 $9,873,191 $10,465,582
<br /> 14 Purchased Water Variable-Water $12,795,669 $13,735,207 $12,747,969
<br /> 15 Purchased Water-Recycled Water $1,690,021 $1,809,337 $1,937,076
<br /> 16 O&M Expenses-Water $10,842,999 $11,358,431 $11,863,986
<br /> 17 O&M Expenses-Recycled Water $762,057 $796,631 $828,990
<br /> 18 Total-O&M Expenses $35,405,077 $37,572,796 $37,843,602
<br /> 19
<br /> 20 Debt and Capital
<br /> 21 Debt Service-Water $1,385,849 $1,385,849 $1,385,849
<br /> 22 Debt Service-Recycled Water $1,415,535 $1,415,535 $434,895
<br /> 23 Rate Funded CIP-Water $3,955,000 $4,468,750 $7,590,625
<br /> 24 Rate Funded CIP-Recycled Water $50,000 $56,250 $61,875
<br /> 25 Total-Debt and Capital $6,806,384 $7,326,384 $9,473,244
<br /> 26
<br /> 27 Net Cash Flow ($8,072,648) ($11,938,888) ($13,398,278)
<br /> 28 Net Revenue ($1,266,264) ($4,612,504) ($3,925,035)
<br /> 29
<br /> 30 Debt Coverage
<br /> 31 Calculated (0.89) (3.26) (9.03)
<br /> 32 Required 1.25 1.25 1.25
<br /> 33
<br /> 34 Water Operating and Capital
<br /> 35 Beginning Balance $9,852,554 $5,472,557 ($8,592,940)
<br /> 36 Ending Balance $5,472,557 ($8,592,940) ($25,021,546)
<br /> 37 Reserve Target $11,533,550 $12,238,390 $12,277,138
<br /> 38
<br /> 39 Recycled Water Operating
<br /> 40 Beginning Balance ($1,873,039) ($1,565,690) ($1,439,080)
<br /> 41 Ending Balance ($1,565,690) ($1,439,080) ($408,753)
<br /> 42 Reserve Target $918,997 $962,858 $1,007,642
<br /> 43
<br /> 44 Combined Financial Plan
<br /> 45 Beginning Balances $7,979,515 $3,906,867 ($10,032,020)
<br /> 46 Ending Balances $3,906,867 ($10,032,020) ($25,430,299)
<br /> 47 Reserve Target $12,452,547 $13,201,248 $13,284,780
<br /> Figure 2-1 and Figure 2-2 show the projected status quo financial plans for water and recycled water in graphical
<br /> format, respectively. The bars represent the water utility's cash needs: O&M expenses (light gray), debt service
<br /> (dark gray), rate funded capital (yellow), reserve funding(green), and purchased water(blue). The solid line
<br /> WATER AND RECYCLED WATER RATE STUDY REPORT 25
<br />
|