|
<br /> PRELIMINARY
<br />. COLORADO WATER CONSERVATION BOARD
<br /> AMORTIZATION SCHEDULE
<br /> Model Land &
<br /> Irrigaation
<br /> Borrower Company
<br /> Contract Number C150012
<br /> Principal $335,000.00
<br /> Interest Rate 3.75%
<br /> Frequency Annual
<br /> Term (In Years) 30
<br /> First Payment Due Open
<br /> Payment Amount $18,789.35
<br /> Annual
<br /> Payment Payment
<br /> No. Amount Principal Interest BALANCE
<br /> $ 335,000.00
<br /> 1 $18,789.35 $ 6,226.85 $ 12,562.50 $ 328,773.15
<br /> 2 $18,789.35 $ 6,460.36 $ 12,328.99 $ 322,312.79
<br /> 3 $18,789.35 $ 6,702.62 $ 12,086.73 $ 315,610.17
<br /> 4 $18,789.35 $ 6,953.97 $ 11,835.38 $ 308,656.20
<br /> 5 $18,789.35 $ 7,214.74 $ 11,574.61 $ 301 ,441 .46
<br /> 6 $18,789.35 $ 7,485.30 $ 11,304.05 $ 293,956.16
<br /> 7 $18,789.35 $ 7,765.99 $ 11,023.36 $ 286,190.17
<br /> 8 $18,789.35 $ 8,057.22 $ 10,732.13 $ 278,132.95
<br /> 9 $18,789.35 $ 8,359.36 $ 10,429.99 $ 269,773.59
<br /> 10 $18,789.35 $ 8,672.84 $ 10,116.51 $ 261,100.75
<br /> 11 $18,789.35 $ 8,998.07 $ 9,791.28 $ 252,102.68
<br /> 12 $18,789.35 $ 9,335.50 $ 9,453.85 $ 242,767.18
<br /> 13 $18,789.35 $ 9,685.58 $ 9,103.77 $ 233,081.60
<br /> 14 $18,789.35 $ 10,048.79 $ 8,740.56 $ 223,032.81
<br /> 15 $18,789.35 $ 10,425.62 $ 8,363.73 $ 212,607.19
<br /> 16 $18,789.35 $ 10,816.58 $ 7,972.77 $ 201,790.61
<br /> 17 $18,789.35 $ 11 ,222.20 $ 7,567.15 $ 190,568.41
<br /> 18 $18,789.35 $ 11,643.03 $ 7,146.32 $ 178,925.38
<br /> 19 $18,789.35 $ 12,079.65 $ 6,709.70 $ 166,845.73
<br /> 20 $18,789.35 $ 12,532.64 $ 6,256.71 $ 154,313.09
<br /> 21 $18,789.35 $ 13,002.61 $ 5,786.74 $ 141,310.48
<br /> 22 $18,789.35 $ 13,490.21 $ 5,299.14 $ 127,820.27
<br /> 23 $18,789.35 $ 13,996.09 $ 4,793.26 $ 113,824.18
<br /> 24 $18,789.35 $ 14,520.94 $ 4,268.41 $ 99,303.24
<br /> 25 $18,789.35 $ 15,065.48 $ 3,723.87 $ 84,237.76
<br /> 26 $18,789.35 $ 15,630.43 $ 3,158.92 $ 68,607.33
<br /> 27 $18,789.35 $ 16,216.58 $ 2,572.77 $ 52,390.75
<br /> 28 $18,789.35 $ 16,824.70 $ 1,964.65 $ 35,566.05
<br /> 29 $18,789.35 $ 17,455.62 $ 1,333.73 $ 18,110.43
<br /> 30 $18,789.57 $ 18,110.43 $ 679.14 $ 0.00
<br /> TOTALS I $563,680.72 I $335,000.00 I $228,680.72 I $0.00 I
<br />Amort Model C150012,xls sse 10/31/2000
<br />
|