Table 2-20: Proposed Financial Plan
<br /> Line 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 $4,526,147 $13,309,054 $20,807,425
<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 $84,406 $85,804
<br /> 9 Interest Income-Recycled Water $0 $0 $20,118
<br /> 10 Total-Revenues $38,664,960 $46,353,753 $54,831,914
<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 ($3,546,501) $1,454,573 $7,515,068
<br /> 28 Net Revenue $3,259,883 $8,780,957 $16,988,312
<br /> 29
<br /> 30 Debt Coverage
<br /> 31 Calculated 2.30 6.20 39.06
<br /> 32 Required 1.25 1.25 1.25
<br /> 33
<br /> 34 Water Operating and Capital
<br /> 35 Beginning Balance $9,852,554 $9,510,379 $7,455,290
<br /> 36 Ending Balance $9,510,379 $7,455,290 $9,791,334
<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,077,365) $432,297
<br /> 41 Ending Balance ($1,077,365) $432,297 $3,611,321
<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 $8,433,014 $7,887,587
<br /> 46 Ending Balances $8,433,014 $7,887,587 $13,402,655
<br /> 47 Reserve Target $12,452,547 $13,201,248 $13,284,780
<br /> WATER AND RECYCLED WATER RATE STUDY REPORT 29
<br />
|