|
City of Santa Ana, CA 1 MATER RATE STUDY
<br />Table -11: Operating Fund Financing Plan in Thousands of Dollars— Scenario 1
<br />BLACK & VEATCH I Water Rate Si udy
<br />65B -47
<br />35
<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 2.8%
<br />464.7
<br />1,394.0
<br />1,394.0
<br />1,394.0
<br />1,394.0
<br />3
<br />FY 15/16 12 2.8%
<br />0.0
<br />1,433.0
<br />1,433.0
<br />1,433.0
<br />1,433.0
<br />4
<br />FY 16/17 12 2.8%
<br />0.0
<br />0.0
<br />1,473.1
<br />1,473.1
<br />1,473.1
<br />5
<br />FY 17/18 12 2.8%
<br />0.0
<br />0.0
<br />0.0
<br />1,514.4
<br />1,514.4
<br />6
<br />FY 18/19 12 2.8%
<br />0.0
<br />0.0
<br />0.0
<br />0.0
<br />1,556.8
<br />7
<br />Increase from Adjustments
<br />0.0
<br />464.7
<br />2,827.0
<br />4,300.1
<br />5,814.5
<br />7,371.3
<br />8
<br />Total Rate Revenue
<br />51,193.9
<br />50,282.6
<br />52,816.6
<br />54,401.1
<br />56,033.1
<br />57,714.1
<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 />256.9
<br />252.8
<br />202.9
<br />167.2
<br />139.6
<br />11
<br />Total Other Operating Rev.
<br />3,385.2
<br />19,979.2
<br />1,781.2
<br />1,731.3
<br />1,695.6
<br />1,668.0
<br />12
<br />Total Revenue
<br />$54,579.1
<br />$70,228.7
<br />$54,393.0
<br />$55,815.2
<br />$57,294.9
<br />$58,824.1
<br />Revenue Requirements
<br />13
<br />0 &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 />1,171.5
<br />2,008.3
<br />2,008.3
<br />2,008.3
<br />18
<br />Total Debt Service
<br />1,712.4
<br />12,496.4
<br />2,746.6
<br />3,582.8
<br />3,586.2
<br />3,586.4
<br />Transfers
<br />19
<br />Transferto Capital Fund
<br />2,534.9
<br />5,900.4
<br />7,350.0
<br />7,350.0
<br />7,350.0
<br />7,350.0
<br />20
<br />Transfer to NPDES Fund
<br />1,446.8
<br />1,507.5
<br />1,578.4
<br />1,622.5
<br />1,668.0
<br />1,714.7
<br />21
<br />Total Transfers
<br />3,981.7
<br />7,407.9
<br />8,928.4
<br />8,972.5
<br />9,018.0
<br />9,064.7
<br />22
<br />Total Revenue Requirements
<br />$48,101.0
<br />$65,008.7
<br />$60,421.9
<br />$59,780.3
<br />$60,466.0
<br />$51,167.2
<br />Operating Fund Balance
<br />23
<br />Net Cash Balance
<br />6,478.1
<br />5,220.0
<br />(6,028.9)
<br />(3,964.1)
<br />(3,171.1)
<br />(2,343.1)
<br />24
<br />Beginning Fund Balance
<br />16,598.4
<br />23,076.5
<br />28,296.5
<br />22,267.6
<br />18,303.5
<br />15,132.4
<br />25
<br />Cumulative Fund Balance
<br />$23,076.5
<br />$28,296.5
<br />$22,267.6
<br />$18,303.5
<br />$15,132.4
<br />$12,789.3
<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 />BLACK & VEATCH I Water Rate Si udy
<br />65B -47
<br />35
<br />
|