Loading...
HomeMy WebLinkAbout97.Item 4 Handout Steering Committee 11-15-17_Budget Worksheet.pdf Cash Flow Projection Orange County Sanitation District Consolidated Cash Flow Projections Preliminary Preliminary PreWnirwry Preliminary Preliminary Preiminary Ref Descri0tion 17-18 19-19 19&20 20,21 21_22 22Y23 Revenues: 1 General User Fees 291,158,000 297,643,000 305,095,000 312,580,000 326124,000 327,701,000 2 FerMged liner Fees 12,925,000 13,159,000 13,4339W 13,706,000 13,979,000 14,253.000 3 RMAssessnenls 15,807,B00 15,095,800 13,305,290 15.063,790 17.927,400 19,146.500 4 SA9lPA AssessneMa 3,263,000 3,394,000 3,53D,000 3,671,000 3,818,000 3,971,000 5 Prowny Taxes 93,666.000 98.349.000 103,266,000 108,429,000 113,850,ODO 119,543,000 6 New COP Isis. - - - - - - 7 Interest Revenues 8,398,DD0 12231,ODD 16,369,000 17,038,000 16,749,000 15,609,000 8 Capital Facilities Capacity Charges 9,900,000 9,089,000 9,534,000 10,004,000 %494,000 11,0081000 9 Other Revenues 8,088.900 10,489,000 15,739,000 16,132,000 24.763.000 24,532.000 10 Revenues ,700 491,631,T10 521,7M,400 05,752,500 Requirements: 11 Oper B lAce Fxp(4.0%yr) 151,919,380 157,996,000 164,316,000 170,889,000 177,725,000 194,834,000 12 Capital inprovelnsM Program(OF) 166,976,000 187705,ODD 213,753,000 253,475,000 319,777,000 336,477,000 13 Less:CP savings S Defenses (10,915,000) (10,00g000) (21,400,000) (20,300,000) (19200000) (10,100,ODO) 14 Repl,Rehab BRefut, - - 3g000 9%,000 5,196.000 5,460,00D 15 WPService 82,033,000 80,464.000 n,956,000 76,01%000 72,472,000 72,466,000 10 Other Requirenems 3.615,000 2,375.000 2,375,000 2,375,000 2,375,000 2,375.000 17 Pequiremante 385,628,380 409,820,000 09,311,000 483,414,000 558,345,000 591,612,000 13 Revenues-Requirements 6716702D 49,629,900 40,960,290 13,211,790 (36,640,tsm) (55,749,500) Accwniested Funds: 19 Beginning of Year 535,274.550 592,052,870 642,182,670 683,442,W 696,660,750 660,020,150 20 End of Year 592,852,870 642,482,670 683,442,960 696,660,750 660,020,150 604270,650 21 Consolidated Reserve PoaY 519,558,000 519,04 ,000 519,642,000 517,217,000 515,564,000 517,495.000 22 Over(Under)Reserve Policy' 73,294,870 123,442,670 163,900,960 179,443,750 144,466,150 86,775,650 Sewer Service User Free: 23 Avg SR Annual User Fee $331.00 $337.00 $344.00 $351.00 $358.00 $36500 24 Percentage Change 122% 1.81% 2.08% 2.03% 1.99% 196% 25 Equrvaent Davellig Units 924,950 927,725 930.508 933,300 936.100 938.908 26 SFR Connection Fee $3,855 $4.032 $4,217 $4,411 $4,814 $4,026 27 Ouslandlrg 001% $1.004,684,000 $966,640,000 $925.258.000 $887,211.000 $851,126,000 $813.576,000 Reserve Policy 28 50%Next Year Operating 75,960,000 78,998,000 02,158,000 85.445,000 88,863,000 92.417.000 29 10%Next Year Operating 15,192.000 15.800.000 16,432,000 17.089,000 17,73,000 18,483,000 30 100%text Year AUG(SIP Svc. 82.033.000 80,464,000 79,956,000 76,019,000 M,4n,000 72,466,000 31 50%average ten-year CP Sol. 122,932,000 122,932,000 122,932,000 122,932,000 122,932,000 122,932,000 32 DSR @ 10%Outstanding COR 100,468,00D 96,554,000 92,526,000 88,721,000 85,113,000 81.358,000 33 SR®$57mm 57,000,000 57,000,000 57,000,000 57.000.000 57,000,000 57,000900 34 Rapl6 Refurb@Myr 65,973,0c0 67292,000 68,638,000 70,011,000 71,411,000 72.839,000 35 Total 519,550,000 519,040,000 519,642,000 517217,000 515,564,000 517A95,000 COP Ratos 16 Sr Lien Coverge,Mn 1.25 3.43 3.63 3.83 4.15 4.60 4.69 A-2 2017-18 Budget Update Orange County Sanitation District Consolidated Cash Flow Projections Preliminary Preliminary Preliminary Preliminary 10-Yaar Raf I3escrlpUon 2Y24 24-2$ 2526 28-27 Total Revenues: — 1 General User Fees 338,283,000 343,929,000 M,585000 361,28%000 3248.375,000 2 Perm0ed User Fees 14,565,000 14.839.000 15,152,000 15,464.000 141.475.000 3 RADAssessrrens 16,922,510 17,6M.M 18,463,090 17,402,580 166,806.640 4 SAWRA Assessimems 4,130,000 4,295.000 4,467.000 4,645p00 39.184.000 5 Roperty,Taxes 125,5M." 131.796.000 138,386,000 145,305.000 1.IM,110.M 6 New IMP Issues - - - - 7 Merest Revenues 15,014,000 15,007,000 14]38p00 15,010,000 146,163,000 8 cartel Faei r..Capac,Charges 11.M1.000 8,651,000 9.078.000 am," MA2,000 9 Other Revenues 13,433,000 5,687,000 4,644,000 4,905,000 128,612,900 10 Revenues 537,3911,510 541,a76,a90 557,713,090 573,SI3,580 5,147,558,510 lequireme n4: 11 Oper B W.Eap(4.0%yr) 192227,000 199,916,000 M7.913,000 216=.M 1,823,965,380 12 Capyal sprovereeI Program(CP) 258,761,000 241,072,000 257.5108,000 222,509,000 2,458.231,000 13 Las:CP Savigs B Oefens6 (7,800,030) (4.800.000) (520a,000) (5.500.000) (132,015.000) 14 Repl,RNel,a Were 11.794.000 39.010,00) 36200AW 33,491,000 132,118.000 15 COPService 72.470,000 M.460,000 M,467,000 68,667.000 749A74,000 16 COrr Requie.need 2,375,000 2,375.000 2.375.000 2,375,000 24.990.000 17 Requirements MIUM7,000 550,033,000 SM,341,000 537.832000 $,O ,M,300 19 Rewnues-Requirements 7,6M,510 (a.iWills0) (13,827,910) 35,711,580 MA"'160 Accumulated Funds: 19 Beginning of Year 604270,650 611.842,160 603.686,040 590,058.130 535274550 20 End of Year 611,612,160 603,686,040 590,058,130 625,769,710 825,709,710 21 Cmsofdatad Reserve Policy 519,491 521.M3,000 523,662,000 522.411.001 522.411,001 22 Over(Under)Reserve Polity` 92,3M,160 a2.153.OW 66,396,130 103,358,709 103,35a,709 Sewer Service User Frees: 23 Avg SFR Annual User Fee $MM $380.00 $38800 $306.30 24 Placenlage Charge 2.19% 1.88% 211% 206% 25 Fpuivalerd Dave"Ukis 941,725 944,550 947,304 950,226 28 SPRCiansdion Fee $5,048 115.280 $5,523 $5.M7 27 QBsiandyw WR $774,625.000 $734.093,000 5892,165.000 $552.304.000 Reserve Poky 28 50%Next Year Operating 96,114,000 99.M." 103,957,000 106.115,ow 29 10%Next Year Operating 19,2 .= 19.992.0110 20,791,000 21.623,000 30 100%Next Year AUG OCP Svc. M.4M,OW M,160,000 72,467,000 68.667,000 31 50%average Mn-year CP BaL 122.932,000 1M.932.O110 122932,ON 122.932,000 32 OSR@ 10%Cufsendig COFs T7,463,000 73,409.000 69,217,000 65,230,000 M SR@$57. 57.000.000 57,OD0,000 57.00D,000 57,000,001 M Repl$Ref urS@Myr 74.296.000 75,7t12,000 T7,298,000 78.844,000 35 Total 519,498,000 521.533,000 523,662000 522,411.001 COPRe os 36 Sr Lien Ceverge,W 125 460 4.60 470 5.06 A-3