|
Table C-3
<br />Projected Cash Flow
<br />Beginning Fund Balance
<br />Revenues
<br />Sewer Service Charges
<br />Other Revenues
<br />General Fund Loan Repayment
<br />Interest Income
<br />Budget Budget Projected
<br />FY18 FY19 FY20 FY21 FY22 FY23 FY24
<br />30,070,299 27,397,504 18,041,376 14,344,216 12,702,073 11,048,699 11,607,926
<br />12,559, 635 12,933,970 13,477,000 14, 757,000 16,159,000 17, 694,000 19,375,000
<br />560,000 760,000 767,600 775,276 783,029 790,859 798,768
<br />490,109 504,812 519,957 535,556 551,622 568,171 583,539
<br />189,163 285,000 180,414 143,442 127,021 110,487 116,079
<br />Total
<br />13,798,907
<br />14,483,782
<br />14,944,971
<br />16,211,274
<br />17,620,672
<br />19,163,517
<br />20,873,386
<br />Expenditures
<br />Collection System
<br />1,513,274
<br />1,628,807
<br />1,677,671
<br />1,728,001
<br />1,779,841
<br />1,833,236
<br />1,888,233
<br />WPCP Operations
<br />6,702,207
<br />6,792,340
<br />6,996,110
<br />7,205,993
<br />7,422,173
<br />7,644,838
<br />7,874,183
<br />Administrative Support
<br />726,109
<br />726,109
<br />747,892
<br />770,329
<br />793,439
<br />817,242
<br />841,759
<br />EBDA
<br />912,619
<br />714,475
<br />735,909
<br />757,986
<br />780,726
<br />804,148
<br />828,272
<br />EBMUD
<br />97,916
<br />79,533
<br />81,919
<br />84,377
<br />86,908
<br />89,515
<br />92,200
<br />Transfers
<br />153,714
<br />132,782
<br />136,765
<br />140,868
<br />145,094
<br />149,447
<br />153,930
<br />Debt Service
<br />2,765,864
<br />2,765,864
<br />2,765,864
<br />2,765,864
<br />2,765,864
<br />2,765,864
<br />2,765,864
<br />Capital Projects
<br />3,600,000
<br />11,000,000
<br />5,500,000
<br />4,400,000
<br />5,500,000
<br />4,500,000
<br />3,500,000
<br />Total
<br />Annual Surplus / (Shortfall)
<br />Ending Fund Balance
<br />Debt Service Coverage Ratio
<br />Net Revenues
<br />Operating Revenues
<br />Operating O&M
<br />Net Revenues
<br />Debt Service
<br />Coverage Ratio
<br />Net Revenues
<br />Debt Service
<br />Coverage Ratio
<br />16,471,703 23,839,910 18,642,130 17,853,418 19,274,045 18,604,290 17,944,441
<br />(2,672,795) (9,356,128) (3,697,159) (1,642,144) (1,653,373) 559,227 2,928,945
<br />27,397,504 18,041,376 14,344,216 12,702,073 11,048,699 11,607,926 14,536,871
<br />13,798,907 14,483,782 14,944,971 16,211,274 17,620,672 19,163,517 20,873,386
<br />10,105,839 10,074,046 10,376,266 10,687,554 11,008,181 11,338,426 11,678,577
<br />3,693,069 4,409,736 4,568,705 5,523,720 6,612,491 7,825,091 9,194,809
<br />2,765,864 2,765,864 2,765,864 2,765,864 2,765,864 2,765,864 2,765,864
<br />3,693,069 4,409,736 4,568,705 5,523,720 6,612,491 7,825,091 9,194,809
<br />2,765,864 2,765,864 2,765,864 2,765,864 2,765,864 2,765,864 2,765,864
<br />1.34x 1.59x 1.65x 2.00x 2.39x 2.83x 3.32x
<br />
|