<br /> EXHlsrr IV
<br /> UPPER EAGLE REGIONAL WATER AUTHORITY WORKING DRAFT 11- Ig- g8
<br /> CASH FLOW PROJECTION - WHOLESALE WI,TER TREATMENT OPERATIONS
<br /> FOR THE YEARS ENDING DECEMBER 51, Ig05 THROUGH DECEMBER 51. 2015
<br /> NON-INFLATED (CURRENT 10075)
<br /> ACTUAL BUDGET
<br /> 1904 1007 llKlB 10011 2000 2001 2002 2005 2004 200 2008 2007 2008 20011 2010 2011
<br /> 0811,545 1,057,280 I, leT ,053 1.220,8el1 I, I,SI7,8ee 1,558.121 1.508.771 1,455,0114 I. I 1.502,053 1,527.811l1 1.552,171 1,575.0811 1,5117,475 1,818.012 ~
<br /> 118'll. loe'll. 87'll. 74'll. 77'll. 80'll. 85'll. 88'll. 88'll. 8S'll. 84'll. 88'll. 87'll. 88'll. 80'll. 70'll. 71'll. t'\
<br /> 7,405 8,872 g,725 10.118 10,844 11,0011 11.4111 11,842 12,1711 12.521 12,840 15.007 15,521 15,554 15,742 15,11211 14,OGO
<br /> 807 1.255 454 448 -AaL.. 424 580 542 552 552 285 250 217 210 205 170 tell
<br /> S2.27 52.27 S2.S5 S2.55 ~ 52.55 S2.55 S2.75 52.75 ".00 SS.OO 52.40 52.40 S2.40 52.40 S2.40 52.40 "-
<br /> SO.OO SO.OI SO.OI SO.14 ~ SO.IS SO. 15 SO.13 SO.12 SO.12 SO.12 SO.12 SO. 11 SO. 11 SO.l1 SO. 11 SO.l1 ^
<br /> SO.OO SO.OO So.oo SO.OO SO.OO SO.OO SO.OO SO.S5 SO.84 SO.82 SO.80 SO.811 SO.1I1 SO.811 SO.88 $0.88 $0.88
<br /> SO S500 5500 1500 5500 5500 1500 $SOO S500 5500 5SOO a500 S500 5500 S!lOO SSOO 1500
<br /> REV ENU E:
<br /> WATER SALES 2,213,807 1.004.0!55 2,400,001 2,484,582 2,078,088 5,112,70ll 5,245,018 5,580,5!le 5,754.834 5,841,120 4.307,081 4,417.584 5,804,028 3,888,448 5,728,211 3,782,328 3,833.03/5 5.880.8S
<br /> 51.50IMONTH SFE SURCHARGE 0 148.105 182,000 178,080 183.188 101,885 '00,782 208,838 213,188 210,222 228,578 251.1\1 258,748 230,7811 243,812 247,347 250,722 255,775 ~
<br />{I \ INTEREST tNCOME@ 4,O'll. 88,237 204,1\0 80.000 70,000 50,085 44,888 48.1\1 51,282 88,783 8\,188 80,071 50,871 82,8110 44,718 fe,888 43.088 48,700 48,300
<br />PLAi'If INVESTMENT FEES @ 5500 PER SFE 0 238,084 380,000 227.000 224,000 243,800 212,000 180.000 17 1,000 u,e,aoo 178,000 142.800 1\8.000 108,800 108.000 102,500 88,000 84,800
<br /> ,",ul'ftJilt1~rrON INTERt:~T IN~UMt:: 0 77 ,513 280,000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 ~
<br />1 OTHER !!.ll! J! MQJ! ~ !.J!J!!l MJ!!! ~ !.J!J!!l ~ MQJ! !m2 MJ!Q !.J!J!!l MJ!J! MJ!Q !..Q.2R M22 ~
<br />TOTAL REVENUE 2 2QO ..ee 2 750 774 3 228 001 2,082 832 3 428 238 35;8"75 3711811 3,804 840 .. 183773 .. 2;3 527 .. 7G!5 430 .. 847 748 4,014575 .. oes 433 .. 123 o4eo .. 182.t!57 .. 221.:Se8 ~ ~
<br />OPERATIONS a ADMIN. EXPEND.:
<br />WATER TREATMENT (SCH. A) 830,78Cl 881,4811 700,133 888,828 025,710 087.288 I,007.8eG 1,042,047 1,074,4\l1l 1,104,80:! 1,288.7\l1l 1.314,727 1.538,400 1,880,10:! 1,870,210 1,508,814 1,418,787 1,433.514
<br />~ ACCTGJADMIN MANAGEMEi'If (0) 83,072 20,880 52,138 38,550 38,080 38.880 40.344 41,780 43,048 44,270 45,'513 48,871 47,807 48,420 40. \08 40,080 80,831 51.248
<br />~ AUDIT(') 8,000 4.000 8,400 8,800 8,080 8,348 8,810 8,853 7.083 7,284 7,488 7.857 7.8t1 7.044 8.072 8,108 8,507 8,408
<br />ENGINEERING 75,280 3.820 20,000 20,000 20,000 20.000 20.000 20,000 20,000 20,000 20,000 20,000 20,000 20,000 20,000 20,000 20,000 20,000 Y\
<br />LEGAL - GENERAL 33,047 33,081 25,000 25,000 28,000 25.000 28,000 25,000 28,000 28,000 28,000 28,000 25,000 25,000 28.000 28,000 25,000 28,000
<br />WATER RtGHTS - PROTo & ENGINEERING 44.315 23,881 28,000 20,000 28.000 28,000 28,000 28.000 25,000 25.000 25.000 25,000 25.000 28,000 25,000 28,000 25,000 25,000
<br />'k WATER RfGHTS - PLANNING & EXPANSION 17,855 1.250 8.000 8,000 5.000 8,000 8,000 8.000 5,000 5,000 8.000 8,000 8,000 8,000 5.000 8.000 5,000 5,000 't
<br />CONSULTING 25,825 1,084 7,000 10,000 10,000 10.000 10,000 10.000 10,000 10.000 10,000 10,000 10.000 10,000 10,000 10,000 10,000 10,000
<br />'" INSURANCE (') 15,485 15,310 20.000 20.000 20,028 21.880 22,828 25,852 24,584 28.047 25,750 28,405 28,055 27,5g4 27.835 28,280 28,848 28,004
<br /> M EMB ERSHIP FEES (0) 208 2.588 8,000 5.000 5,130 3,283 3,424 3,848 3,853 5,757 5,883 3,081 4,040 ..tOg 4,175 4.230 4,2g7 4,340 t
<br />"l MISCEUANEOUS (') 1.283 5,824 2,000 2,000 2,003 2,180 2,283 2,383 2,455 2,805 2,878 2,841 2,803 2,750 2,785 2,828 2,885 2,BOO
<br />"- COMMUNITY RELATtONS 18,105 8,102 7,300 7.500 7,800 7.800 7,800 7,500 7,500 7,800 7,500 7,500 7,500 7,800 7,500 7,500 7.500 7,500
<br />~ DIRECTOR'S FEES & EXPENSES 8,Og8 5,328 8.800 8,800 8,800 8,800 8.800 8.800 8.800 8,800 8,800 8,800 8,800 8,800 8,800 8,800 8,800 8,800
<br />PAYING AGEi'If FEES 1.852 3,080 3.800 4,000 8,000 8,000 8,000 8,000 8,000 8.000 8,000 8,000 8,000 8,000 8,000 8,000 8,000 8.000
<br />~ AVON 80.000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
<br /> 0 0 10,000 12.000 18,500 10,9.58 10,827 20,215 20,822 21,447 22,000 22.753 23,455 24,138 24,882 28,808 28,377 27,188
<br /> J! J! J! 14000 1510S8 83:8151 ae.S84 1580415 ~ 7307. 75128 ZLm run 70 023 !1.lli 82 440 n.m u.ID ~
<br />TOTAL OPERATIONS a ADMIN. EXPEND. 074 O~ - 800 542 084280 1 078 B78, 117g se:s 12'17.701. 48 ll1U!1 ~ 15875!lS .LID.n\!. ~ ~ ~ ~ .LZ2M!! 1.728,B85 ~
<br />NET OPER REVENUES BEFORE DEBT SERVICE ~ 1 o~o 232 2 2153 732 18B87!lS 2 248 8~ 2,70.Gn 2.437 -,'28 2 480 278 2 831, 751 2008 172 3 102 147 3 240 7l1!l 2370 780 2400 475 ~ 247e7Ul 2 404 782 2 B27.01lO
<br />DEBT SERVICE (SCH. D): ~
<br />V) REVENUE BONDS - 1988 382.732 370,853 4~ 1,800 51B.401l 2 ".800 0 0 0 0 0 0 0 0 0 0 0
<br />REVENUE BONDS -lOgO 125,4112 52,187 0 0 0 0 0 0 0 0 0 0 0 0 0 0
<br />~ REVENUE BONDS - REFUNDtNG - 1004 237.533 438,285 438,2115 838.288 1,028,772 1,242,775 1,247,287 '.24~.g 12 1,240,513 1,24B,7~ 8~7.800 0 0 0 0 0 "-
<br />~ DEFEASE 1088 BONDS lNCUJDING COI 7.350,000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 ~
<br />REVENUE BONDS - 1004 (52,0 MILUON) 0 2,020,418 0 0 0 0 0 0 0 0 0 0 0 0 0 0
<br />VI REVENUE BONDS - 1005 10.00 MILUON 0 230.~85 84~. log 848,805 843.502 845,378 B44,085 842.872 844,428 B44,207 847,B\lIl 844,180 B4~.071l 847.204 843,518 845,235
<br />--t REVENUE B NDS EAGLE PARK - 1908 2.128 MILLION 0 0 0 lBO,452 150,452 "0,452 150,452 "0,452 150.452 IBO,452 lBO,452 180,452 IBO,452 IBO,452 150,452 150,452
<br />REVENUE BON S - 2002 ($ 12.84 MILUON) 2 J! J! l 2 J! 474000 BSO 800 8S0 4ro seD 100 U!n!! UM.!Q2 1 3B5 400 ~ ~ I 383 3~
<br />TOTAL DEBT SERVICE 8 058 787 4 02e 15M 2048845 2 235 3211 2 27115.15;2 3 120038 5.12".1543 3 I 2 B24 500 2 378.012 2.~77.851 2.178.l501!1 ~ ~ ~
<br />"~ ANNUAL DEBT SERVICE COVERAGE .11!!l! .1QU 104'll. 05'll. 102% ~ ~ 103'll. .1J!!!r ~ ~
<br />'WJ.TE1l"llVSTEM 1M PROVEMENTS (SCH. C) 1 283 350 31440W 2 182 ~oo 85 000
<br /> TOTAL TREATMENT EXPENDlfURES < 10313148 ~ Olj0283/5 3"3'2~ MlQll!! 115 71537'4 4 ~71 501 .. 7~2.0215 4213004 .. 001 a72 ".1 " 2e8 4 150.047 .. 1~81501 !.1ZUl!2
<br /> EXCESS REVENUES OVER EXPENDrrURES (8 022 87B) (8 222.484)~ B74 834) (488 807) (I 082.4001 188 278 /12570,041) (277M4) 12.504 ~ ~ ~ ..3110 M.ill 05 053
<br /> /
<br /> OTHER FUNDING SOU ROES: /
<br /> REVENUE BONDS o 330 000 1000rOO 2 2 2 127 500 2 J! t2 a..o 000 J! J! J! J! J! 2 2 2
<br /> ~ .!A.!1.m 1 117 040 1001401 1 000 81B
<br /> BEGINNING FUNDS AVAILABLE - JAN I 1238803 ~ 7 320 5~1 1.445717 1281300 1 480,878 1 ~20 835 1.142724 1 207 "88
<br /> ENDING FUNDS AVAILABLE - DEC 31 ~ /~ .1llUJZ ~ .u&.m ~ .1.nI.ZZ1 .1.llZ.iJ2 J.W.W. J.2.iU..m .1..W.22! .1.m.!ll!l ~
<br /> ~
<br /> ANA SI OF E 01 G FU OS" 1l<<.04r -- ;4~,880
<br /> GENERAL RESERVES 850,380 572,511l1,~c8M.1I4L 8~!.U7 ',854:350 ,584,08B' , 588,4llS . '350,7112 ' 525.3~JI ,328.083 ,,381,B5,1 420,027 50\1,145 /
<br /> REPLACEMENT RESERVES 178.~!ioC ~ '17.~,Ooo' --- 175,000 ' ' 175.000 175:000 175.000 175,000 175,000 '175,000, _ '175,000 '175._ 175,000 175,_'--175,_- - 175;000
<br /> DEBT RESERVE - 11111l11SSUE 28.750 2B.750 B4.188 38.750 58,750 3B,750 3B,750 38,780 58,750 38,750 B8,750 38,780 38,750 38,750 58,750
<br /> OPERATING RESERVE - 3 MONTH 30,(008 387.BllS 3117.1111 418,442 435,807 448,348 481,535 473,D38 585,257 544.40\1 852,282 580,801 587,123 573.71~ 570,848
<br /> CONSTRUCTION RESERVES ~ !.J!!!UH J! .2 l! .2 R i J! lP. lP. lP. lP. lP. .2 .2
<br /> TOTAL ENDING FUNDS AVAILABLE ~ UZlP..W ~ U22.ZZZ ~ .Jai.m ~ .!.&ll.lll .1AI.L!Zl J..1.t.Z.U2 .LlP.IJ.U.l ..l..l!2I.Ia .1..1U.lii J.a!ll.!a .uJIUll
<br /> (') EXPENDITURES BASED ON 'll. INCREASE OF WATEf!~ELNEREO. G-
<br /> .I
<br /> TOTAt.S MAY NOT ADD DUE TO ROUNDING. THE ND,TES AND ASSUMPTIONS CONTAINED IN.THE A PANYING REPDHT ARE AN INTEGRAL PART OF THIS SIIMMARY EX ISIT.
<br /> THERE WIll USUAllY BE DIFFERENCES BETWEEN,'FORECASTED AND ACTUAL RESI/LTS BECAUSE ENTS AND CIRCIJJIIlTANCES FREQUENTLY DO NOT OCCUR AS EXP CTED
<br /> AND THOSE DIFFERENCES WAY BE MATERiAL. ,/
<br /> THE ABOVE INFORMATION HAS NOT BEEN INrNDENTlY AUDITED, EXAMINED. REVIEWED. CO PILED, OR TESTED.
<br /> HI' /VtI ~s / II O.qq fJll~
<br /> J.Ot!
<br /> --
<br />
<br />
<br />
<br />
<br />
<br />
|