|
<br />I"":'~
<br />~P.....7
<br />
<br />EAGLE PARK RESERVOIR PROJECT
<br />Amortization Schedule and Implied Value of Collateral by Year
<br />
<br />Principal $8,500,000.00
<br />Interest: 5.43%
<br />Term: 30 years
<br />
<br />Annual Payment $580,331.89
<br />
<br />------ ------------ ------------- ------------ ------------ -------------
<br />------ ------------ ------------- ------------ ------------ -------------
<br />
<br />Period
<br />
<br />Loan
<br />Balance
<br />
<br />Annual
<br />Payment
<br />
<br />Amount to
<br />Interest
<br />
<br />Amount to
<br />Principal
<br />
<br />Implied Value
<br />$ per Ac-Ft
<br />
<br />------ ------------ ------------- ------------ ------------ -------------
<br />------ ------------ ------------- ------------ ------------ -------------
<br />
<br />1 $8,500,000.00 580,331.89 $461,550.00 $118,781.89 $5,667
<br />2 8,381,218.11 580,331.89 455,100.14 125,231.75 $5,587
<br />3 8,255,986.36 580,331.89 448,300.06 132,031.83 $5,504
<br />4 8,123,954.52 580,331.89 441,130.73 139,201.16 $5,416
<br />5 7,984,753.36 580,331.89 433,572.11 146,759.79 $5,323
<br />6 '7,837,993.57 580,331.89 425,603.05 154,728.84 $5,225
<br />7 7,683,264.73 580,331.89 417 ,201 .27 163,130.62 $5,122
<br />8 7,520,134.11 580,331.89 408,343.28 171,988.61 $5,013
<br />9 7,348,145.50 580,331.89 399,004.30 181,327.59 $4,899
<br />10 7,166,817.91 580,331.89 389,158.21 191,173.68 $4,718
<br />11 6,975,644.23 580,331.89 378 777.48 201,554.41 $4,650
<br />12 6,714,089.82 580,331.89 367,833.08 212,498.82 $4,516
<br />13 6,561,591.00 580,331.89 356,294.39 224,037.50 $4,374
<br />14 6,337,553.50 580,331.89 344,129.16 236,202.74 $4,225
<br />15 6,101,350.76 580,331.89 331,303.35 249,028.55 $4,068
<br />16 5,852,322.21 580,331.89 317,781.10 262,550.80 $3,902
<br />17 5,589,171.42 580,331.89 303,524.59 276,807.31 $3,727
<br />18 5,312,964.11 580,331.89 288,493.95 291,837.94 $3,542
<br />19 5,021,126.17 580,331.89 272,647.15 307,684.74 $3,347
<br />20 4,713,441.43 580,331.89 255,939.87 324,392.02 $3,142
<br />21 4,389,049.40 580,331.89 238,325.38 342,006.51 $2,926
<br />22 4,047,042.89 580,331.89 219,754.43 360,571.46 $2,698
<br />23 3,686,465.43 580,331.89 200,175.07 380,156.82 $2,458
<br />24 3,306,308.61 580,331.89 179,532.56 400,799.34 $2,204
<br />25 2,905,509.27 580,331.89 157,769.15 422,562.74 $1,937
<br />26 2,482,946.53 580,331.89 134,824.00 445,507.90 $1,655
<br />27 2,037,438.64 580,331.89 110,632.92 469,698.98 $1,358
<br />28 1,567,739.66 580,331.89 85,128.26 495,203.63 $1,045
<br />29 1,072,536.03 580,331.89 58,238.71 522,093.19 $715
<br />30 550,442.85 580,331.89 29,889.05 550,442.85 $367
<br />
<br />Totals $17,409,956.80 $8,909,956.80 $8,500,000.00
<br />
|