|
TAB�E 1, FINANCIAL PLAN
<br />Total Project Cost
<br />Source Share
<br />Cash 25 %
<br />CWCB Loan 75 %
<br />Existing
<br />CWCB Loan 100%
<br />Total
<br />CWCB Loan
<br />$1.100,000
<br />Princioal interest Years
<br />$275,000 n/a
<br />$825,000 4.80%
<br />$130,000 4.80%
<br />$955,000 4.80%
<br />Pavment
<br />30 $52,148
<br />30 $8,217
<br />30 $60.365
<br />CITY OF �DAHO SPRINGS
<br />WATER ENTERPRISE
<br />SCHEDULE OF REVENUE AND EXPENDITURES
<br />ANNUALREVENUE ANNUALEXPENDITURES
<br />Operetion, Existlng Capital improv.,
<br />Year of Water Fund Wastewater Other Total Maintenance, Loan/Bond Payments on Reserve and Total Water Enterprise
<br />Operation Revenue Fund Revenue Revenue Revenue Replacement Repayments CWCB Loan Emergency Expenditures Fund Balance
<br />$163,402
<br />1994(A) $318,600 $291,700 $493,538 $1,103,838 $430,205 $433,995 $0 $864,200 $403,040
<br />1995(A) $365,994 $297.800 $232,366 $896,160 $397,263 $437,920 $108,417 $943,600 $355,600
<br />1996(A) $336,675 $550,790 $323,385 $1,210,850 $558,540 $443,115 $85,195 $1,086;850 $479,600
<br />1997(B) $310,200 $533,000 $997,600 $1,840,800 $477,900 $487,285 $882,300 $1,847,485 $472,915
<br />1998 $347,424 $596,960 $217,500 $1,161,884 $494,627 $598,498 $6,240 $200,000 $1,299,365 $335,435
<br />1999 $354,372 $608,899 $220,000 $1,183,272 $511,938 $659,293 $6,240 $207,000 $1,384,471 $134,235
<br />2000 $361,460 $621,077 $440,900 $1,423,437 $529,856 $609,816 $6,240 $214,245 $1,360,157 $197,515
<br />2D01 $368,689 $633,499 $111,354 $1,113,542 $548,401 $167,199 $6,240 $221,744 $943,584 $367,473
<br />2002 1 $376,063 $646,169 $113,581 $1,135,813 $567,595 $170,793 $60,365 5229,505 $1,028,258 $475,028
<br />2003 $383,584 $659,092 $115,853 $1,158,529 $587,461 $168,844 $60,365 $237,537 $1,054,207 $579.350
<br />2004 $391,258 $672,274 $118,170 $1,181,700 $608,022 $166,830 $60,365 $245,851 $1,081,068 $679,981
<br />2005 $399,081 $685,719 $120,533 $1,205,334 $629,303 $170,052 $60,365 $254,456 $1,114,176 $771,139
<br />2006 5 $407,063 $699,434 $122,944 $1,229,440 $651,329 $167,708 $60,365 $263,362 $1,142,763 $857,816
<br />2007 $415,204 $713,422 $125,403 $1,254,029 $674,125 $170,627 $60,365 $272,579 $1,177,697 $934,148
<br />2D08 $423,508 $727,691 $127,911 $1,279,110 $697,720 $167,965 $60,365 $282,120 $1,208,169 $1,005,089
<br />2009 $43�,978 $742,245 $130,469 $1,304,692 $722,140 $170,562 $60,365 $291,994 $1,245,061 $1,064,720
<br />2010 $440,618 $757,090 $133,079 $1,330,786 $747,415 $167,483 $60,365 $302,214 $1,277,476 $1,718,030
<br />2011 10 $449,430 $772,231 $135,740 $1,357,402 $773,574 $169,737 $60,365 $312,791 $1,3'16,467 $1,158,964
<br />2012 $458,419 $787,676 $138,455 $1,384,550 $800,649 $161,649 $60;365 $323,739 $1,346,402 $1,197,112
<br />2013 $467,587 $803,430 $141,224 $1,412,241 $828,672 $163,541 $60,365 $335,070 $1,387,648 $1,221,704
<br />2014 $476,939 $819,498 $144,049 $1,440,485 $857,675 $165,230 $60,365 $346,797 $1,430,068 $1,232,122
<br />2015 $486,477 $835,888 $146,930 $1,469,295 $887,694 $166,482 $60,365 $358,935 $1,473,476 $1,227,941
<br />2016 15 $496,207 $852,606 S149,668 $7,498,681 $918,763 $161,836 $60,365 $371,498 $7,512,462 $1,214,160
<br />2017 $506,131 $869,858 $152,865 $1,528,655 $950,920 $19,714 $60,365 $384,500 $1,475,499 $1,327,315
<br />2018 $516,254 $887,051 $155,923 $1,559,228 $984,202 $0 $60,365 $397,958 $1,442,525 $1,444,018
<br />2019 $526,579 $904,792 $159,041 $1,590,412 $1,018,649 $0 $60,365 $411,886 $1,490,901 $1,543,529
<br />2020 $537,110 $922,888 $162,222 $1,622,221 $1,054,302 $0 $60,365 3426,302 $1,540,969 $1,624,780
<br />2021 20 $547,853 $941,346 $165,466 $1,654,665 51.091,203 $0 $60,365 $441,223 $1,592,791 $1,686,655
<br />2022 $558,810 $960,173 $188,776 $1,687,758 $1,129,395 $0 $60,365 $456,666 $1,646,425 $1,727,988
<br />2023 $569,986 3979,376 $172,151 $1,727,513 $1,168,924 $0 $60,365 $472,649 $1,701,938 $1,747,563
<br />2024 $581,386 5998,964 $175,594 31,755,944 $1,209,836 $0 $60,365 $489,192 $1.759,393 $1,744,114
<br />2025 $593,013 $1,018,943 $179,106 $1,791,063 $1,252,180 $0 $60,365 5506,3t3 $1,818,859 $1,716,318
<br />2026 25 $604,874 $1,039,322 $182.688 $1,826,884 $1,296,006 30 $60,365 $524,034 $1,880,406 $1,662,796
<br />2027 $616,971 $1,060,108 $186,342 $7,863,421 $1,341,387 $0 $60,365 $542,376 $1,944,107 $1,582,110
<br />2028 $629,310 $1,081,310 $190,069 E1.900.690 $1,388,315 $0 $60,365 5561,359 $2,010,038 $1,472,762
<br />2029 $841,897 $1,102,937 E193,870 51.938,704 31,436,906 $0 360,365 $581,006 $2,078,277 $1,333,189
<br />2030 $654,735 $1,124,995 $197,748 51,977,478 $1,487,197 30 $60,365 $601,342 $2,148,904 $1,161,763
<br />2031 30 $667,829 $1,147,495 3201,703 52,017,027 51,539,249 $0 560,365 $622,388 $2,222,003 $956,788
<br />ToWI 51,895,910
<br />NOTES:
<br />(A) Actual values for 1994, 1995, and 1998
<br />(B) Budgeted values for 1997
<br />1. Fund revenues are based on a projected 12% rate inaease for 1998, and growth/escalation of 2%lyear.
<br />2. Operation, Maintenance, and Replacement are based on escaladon of 3.5%/year.
<br />3. Payments on CWCB Loans are based on interest ony for epsting loan through 2001, and principal and interest payments for 30 years thereafter.
<br />4. CapiWl Improvement Reserve and Emergenc,y Funds are based on escalation of 3.5%tyear.
<br />Page 10
<br />
|