|
Seven-Year Financial Forecast-Water Fund
<br /> 6/02/2008-20%+15%+15%-No CPI-No Lake-Capital Bond Issue
<br /> FY08 FY08 FY09 FY10 FY11 FY12 FY13 FY14 FY15
<br /> Bud et Actual Forecast Forecast Forecast Forecast Forecast Forecast Forecast
<br /> Revenues
<br /> Water Sales 14,400,000 11,402,702 13,700,000 15,755,000 18,118,250 18,118,250 18,118,250 18,118,250 18,118,250
<br /> Tapping Fees 75,000 85,794 120,000 120,000 120,000 120,000 120,000 120,000 120,000
<br /> DUATS Reimbursement 29,190 29,190 29,190 29,190 29,190 29,190 29,190 29,190 29,190
<br /> Investment Income 2,200,000 868,417 900,000 1,200,000 1,100,000 900,000 750,000 750,000 700,000
<br /> ADM Cost Share 1,000,000 801,948 1,072,900 772,063 1,251,838 807,173 3,738,084 1,494,592 826,715
<br /> IEPA Loan Reimbursement - - 4,222,000 4,175,000 - - - - -
<br /> New Bond Issue 36,000,000 - 20,000,000 - - - - - -
<br /> Federal and State Grants - - - - - - - - -
<br /> Other Revenue 63,400 131,976 75,000 75,000 75,000 75,000 75,000 75,000 75,000
<br /> Total Revenue 53,767,590 13,320,027 40,119,090 22,126,253 20,694,278 20,049,613 22,830,524 20,587,032 19,869,155
<br /> Oqeretinq Expenses
<br /> Water Production Personnel 1,358,708 1,264,662 1,445,100 1,495,679 1,548,027 1,602,208 1,658,285 1,716,325 1,776,397
<br /> Water Production Operating 4,500,148 3,443,258 3,850,985 3,966,515 4,085,510 4,208,075 4,334,318 4,464,347 4,598,277
<br /> Lake Services Personnel 310,989 261,674 348,650 360,853 373,483 386,554 400,084 414,087 428,580
<br /> Lake Services Operating 543,932 468,185 543,120 559,414 576,196 593,482 611,286 629,625 648,514
<br /> WaterAdministration Personnel 347,754 310,287 394,186 407,983 422,262 437,041 452,338 468,169 484,555
<br /> WaterAdministrationOperating 2,219,458 2,206,399 2,250,188 2,317,694 2,387,224 2,458,841 2,532,606 2,608,585 2,686,842
<br /> Water Services Personnel 1,474,924 1,225,944 1,566,979 1,621,823 1,678,587 1,737,338 1,798,144 1,861,079 1,926,217
<br /> Water Service Operating 1,036,207 869,893 896,523 923,419 951,121 979,655 1,009,045 1,039,316 1,070,495
<br /> Dredging Services Personnel 440,656 252,786 465,405 481,694 498,553 516,003 534,063 552,755 572,102
<br /> Dredging Services Operating 677,525 506,715 608,721 626,983 645,792 665,166 685,121 705,674 726,845
<br /> Total Opereting Expenses 12,910,307 10,809,803 12,369,857 12,762,054 13,166,756 13,584,363 14,015,290 74,459,963 14,918,824
<br /> Caoital&Debt Service
<br /> New Alternative Water Sources 7,400,000 298,222 - - - - - - -
<br /> Lake Decatur Dredgi�g 200,000 112,058 200,000 1,200,000 200,000 5,800,000 1,500,000 200,000 1,000,000
<br /> ___ 100 000 _____ 100 000 1 O50 000 - - - - __
<br /> Other Lake Capital 170,000 58,680 270,000 195,000 270,000 495,000 270,000 195,000 270,000
<br /> Non-LakeCapitalProjects 9,340,096 1,631,646 9,961,296 6,561,572 1,661,862 2,094,923 2,668,513 1,239,141 1,274,315
<br /> DebtService 4,150,302 4,145,786 4,182,058 4,312,672 4,309,107 5,818,832 4,358,199 3,232,487 2,532,587
<br /> New Bond Debt Service - - - 1,538,250 1,538,250 1,538,250 1,538,250 1,538,250 1,538,250
<br /> IEPA Loan Debt Service - - - 602,678 602,278 602,678 602,678 602,678 602,678
<br /> Totat Capital 8 Debt Service 21,360,398 6,246,392 14,713,354 15,460,172 8,581,497 16,349,683 10,937,640 7,007,556 7,217,830
<br /> ToWI Expenditures 34,270,699 17,056,195 27,083,211 28,222,226 21,748,253 29,934,046 24,952,930 21,467,519 22,136,654 �
<br /> Anticipated Budget Under Run 1,236,986 1,276,205 1,316,676 1,358,436 1,401,529 1,445,996 1,491,882 �
<br /> Percent of Operating Expenses 10.0°/a 10.0% 10.0°/a 10.0% 10.0% 10.0°� 10.0°k �
<br /> Net Expenditures 25,846,225 26,946,021 20,431,577 28,575,610 23,551,401 20,021,523 20,644,772 r�j.
<br /> N
<br /> H:\Five Year Plan\Fund 80-7 Year Water-20%+15%+15%-No CPi-No Lake-June 2,2008
<br />
|