|
8.A. - Page 28
<br />Table A10
<br />Redwood City Sewer Enterprise Cash Flow Projections
<br />Fiscal Year Ending June 30
<br />Rate Increase
<br />Beginning Fund Reserves
<br />REVENUES
<br />Sewer Service Charges
<br />Contract Agency Charges
<br />Connection Fees
<br />Investment Earnings
<br />Other Revenues
<br />Total
<br />EXPENSES
<br />Operating & Maintenance
<br />City Operating Expenses
<br />SVCW Operating Expenses
<br />Subtotal
<br />Net Revenues
<br />Debt Service
<br />Senior Debt Service
<br />City Share of SVCW 2009 Bonds (Net)
<br />City Share of SVCW 2014 Bonds
<br />City Share of SVCW 2015 Bonds
<br />City Share of SVCW 2018 Bonds
<br />City Share of Future SVCW Bonds
<br />Total Senior Debt Service
<br />Senior Debt Service Coverage
<br />Subordinate Debt Service
<br />City Share of Outstanding SVCW SRF Loans
<br />City Share of Future SVCW SRF Loans
<br />City Share of SFR Reserve Contributions
<br />Total Subordinate Debt Service
<br />Total Combined Debt Service
<br />Total Debt Service Coverage
<br />Capital & Other Non-Ooeratinq
<br />City Capital Improvements
<br />SVCW Pay -Go Capital Funding
<br />SVCW SRF Reserve Contributions
<br />Subtotal
<br />Total Expenses
<br />Revenues Less Expenses
<br />Ending fund Reserve
<br />Days Cash on Hand
<br />Source: Bartle Wells Associates and the City of Redwood City
<br />2017-18
<br />2018-19
<br />2019-20
<br />2020-21
<br />2021-22
<br />Adopted
<br />Adopted
<br />Projected
<br />Projected
<br />Projected
<br />2%
<br />2%
<br />5%
<br />5%
<br />5%
<br />$31,507,971
<br />$34,272,263
<br />$32,958,789
<br />$32,785,723
<br />$32,932,288
<br />$29,767,000
<br />$30,408,000
<br />$31,976,000
<br />$33,625,000
<br />$33,359,000
<br />6,506,000
<br />7,216,000
<br />8,202,000
<br />9,279,000
<br />10, 012, 000
<br />100,000
<br />100,000
<br />100,000
<br />100,000
<br />100,000
<br />270,000
<br />276,000
<br />422,000
<br />560,000
<br />542,000
<br />50,000
<br />50,000
<br />50,000
<br />50,000
<br />50,000
<br />36, 693, 000
<br />38, 050, 000
<br />40, 750, 000
<br />43, 614, 000
<br />46, 063, 000
<br />8,570,000
<br />8,827,000
<br />9,095,000
<br />9,373,000
<br />9,663,000
<br />10, 830, 466
<br />11, 232, 486
<br />11, 644, 530
<br />12, 095, 049
<br />12,145, 653
<br />19,400,466
<br />20,059,486
<br />20,739,530
<br />21,468,049
<br />21,808,653
<br />17,292,534
<br />17,990,514
<br />20,010,470
<br />22,145,951
<br />24,254,347
<br />2,189,509
<br />2,185,415
<br />1,482,626
<br />-
<br />-
<br />2,070,514
<br />2,071,587
<br />2,071,801
<br />2,072,874
<br />2,072,338
<br />1,016,300
<br />1,005,050
<br />1,567,650
<br />2,795,250
<br />2,789,000
<br />-
<br />4,475,000
<br />4,475,000
<br />4,475,000
<br />4,475,000
<br />-
<br />-
<br />1,004,204
<br />3,815,533
<br />6,830,960
<br />5,276,323
<br />9,737,051
<br />10,601,281
<br />13,158,657
<br />16,167,298
<br />3.28
<br />1.85
<br />1.89
<br />1.68
<br />1.50
<br />1,315,327
<br />1,315,327
<br />1,315,327
<br />1,315,327
<br />1,602,495
<br />0
<br />0
<br />0
<br />0
<br />0
<br />0
<br />0
<br />0
<br />0
<br />397,622
<br />1,315,327
<br />1,315,327
<br />1,315,327
<br />1,315,327
<br />2,000,117
<br />6,591,650
<br />11, 052, 378
<br />11, 916, 608
<br />14, 473, 984
<br />18,167, 415
<br />2.62
<br />1.63
<br />1.68
<br />1.53
<br />1.34
<br />6,700,000
<br />7,000,000
<br />7,000,000
<br />6,000,000
<br />7,000,000
<br />750,892
<br />765,910
<br />781,228
<br />796,853
<br />812,790
<br />485,700
<br />485,700
<br />485,700
<br />728,550
<br />971,400
<br />7,936,592
<br />8,251,610
<br />8,266,928
<br />7,525,403
<br />8,784,190
<br />33,928,708
<br />39,363,474
<br />40,923,066
<br />43,467,435
<br />48,760,258
<br />2,764,292
<br />(1,313,474)
<br />(173,066)
<br />146,565
<br />(2,697,258)
<br />$34,272,263
<br />$32,958,789
<br />$32,785,723
<br />$32,932,288
<br />$30,235,030
<br />645
<br />600
<br />577
<br />560
<br />506
<br />A-19
<br />
|