|
34
<br />WATER RATE STUDY I City of Santa Ana, CA
<br />Table -10: Operating Fund Financing Plan in Thousands of Dollars — Status Quo Scenario
<br />M �l i •
<br />NOVEMBER 2014
<br />PROJECTED
<br />Revenue
<br />1
<br />Revenue from Existing Rates
<br />51,193.9
<br />49,784.8
<br />49,784.8
<br />49,784.8
<br />49,784.8
<br />49,784.8
<br />Year Month Inc.
<br />2
<br />FY 14/15 4 0.0%
<br />0
<br />0
<br />0
<br />0
<br />0
<br />3
<br />FY 15/16 12 0.0%
<br />0
<br />0
<br />0
<br />4
<br />FY 16/17 12 0.0%
<br />0
<br />0
<br />5
<br />FY 17/18 12 0.0%
<br />0
<br />6
<br />FY 18/19 12 0.0%
<br />7
<br />Increase from Adjustments
<br />0
<br />0
<br />0
<br />0
<br />0
<br />0
<br />8
<br />Total Rate Revenue
<br />51,193.9
<br />49,784.8
<br />49,784.8
<br />49,784.8
<br />49,784.8
<br />49,784.8
<br />9
<br />Other Operating Revenue
<br />3,090.3
<br />19,722.3
<br />1,528.4
<br />1,528.4
<br />1,528.4
<br />1,528.4
<br />10
<br />Interest Income
<br />294.9
<br />254.6 -
<br />229.6
<br />139.0
<br />52.0
<br />0.0
<br />11
<br />Total Other Operating Rev.
<br />3,385.2
<br />19,976.9
<br />1,758.0
<br />1,667.4
<br />1,580.4
<br />1,528.4
<br />12
<br />Total Revenue
<br />$54,579.1.
<br />$69,761.7
<br />$51,542.8
<br />$51,452.2
<br />$51,365.2
<br />$51,313.2
<br />Revenue Requirements
<br />13
<br />O &M Expenses
<br />24,068.0
<br />22,236.4
<br />23,555.8
<br />24,674.2
<br />24,934.2
<br />25,588.5
<br />14
<br />Water Purchase
<br />17,994.8
<br />21,711.1
<br />21,892.7
<br />21,393.9
<br />21,770.7
<br />21,770.7
<br />15
<br />Routine Capital Outlay
<br />344.1
<br />1,156.9
<br />3,298.4
<br />1,156.9
<br />1,156.9
<br />1,156.9
<br />Debt Service
<br />16
<br />Existing Debt
<br />1,712.4
<br />12,496.4
<br />1,575.1
<br />1,574.5
<br />1,577.9
<br />1,578.1
<br />17
<br />Proposed Debt
<br />0.0
<br />0.0
<br />0.0
<br />0.0
<br />0.0
<br />0.0
<br />18
<br />Total Debt Service
<br />1,712.4
<br />12,496.4
<br />1,575.1
<br />1,574.5
<br />1,577.9
<br />1,5781
<br />Transfers
<br />19
<br />Transfer to Capital Fund
<br />2,534.9
<br />5,900.4
<br />9,500.0
<br />9,500.0
<br />9,500.0
<br />9,500.0
<br />20
<br />Transfer to NPDES Fund
<br />1,446.8
<br />1,493.5
<br />1,493.5
<br />1,493.5
<br />1,493.5
<br />1,493.5
<br />21
<br />Total Transfers
<br />3,981.7
<br />7,393.9
<br />10,993.5
<br />10,993.5
<br />10,993.5
<br />10,993.5
<br />22
<br />Total Revenue Requirements
<br />$48,101.0
<br />$64,994.7
<br />$61,315.5
<br />$59,793.0
<br />$60,433.2
<br />$61,087.7
<br />Operating Fund Balance
<br />23
<br />Net Cash Balance
<br />6,478.1
<br />4,767.0
<br />(9,772.7)
<br />(8,340.8)
<br />(9,068.0)
<br />(9,774.5)
<br />24
<br />Beginning Fund Balance
<br />16,598.4
<br />23,076.5
<br />27,843.5
<br />18,070.8
<br />9,730.0
<br />662.0
<br />25
<br />Cumulative Fund Balance
<br />$23,076.5
<br />$27,843.5
<br />$18,070.8
<br />$9,730.0
<br />$662.0
<br />($9,112.5)
<br />Target Minimum Fund Balance
<br />26
<br />(25% O&M) + $1M Emergency
<br />11,371.6
<br />11,836.4
<br />12,206.5
<br />12,359.3
<br />12,516.3
<br />12,677.6
<br />M �l i •
<br />NOVEMBER 2014
<br />
|