|
<br />COLORADO WATER CONSERVATION BOARD
<br />
<br />LOAN REPAYMENT SCHEDULE
<br />
<br />Borrower
<br />
<br />Guenzi Farms, Inc.
<br />
<br />Loan Contract Number
<br />Principal
<br />Interest Rate
<br />Frequency
<br />Term (In Years)
<br />First Payment Due
<br />Payment Amount
<br />
<br />C150174
<br />$352,000.00
<br />2.50%
<br />Annual
<br />30
<br />January 1, 2007
<br />$16,817.73
<br />
<br />Loan Annual Annual Payment Principal
<br />Payment Payment Due Principal Interest
<br />No. Date Amount BALANCE
<br />
<br /> $ 352,000.00
<br />1 l-J an-07 $16,817.73 $ 8,017.73 $ 8,800.00 $ 343,982.27
<br />2 I-Jan-08 $16,817.73 $ 8,218.17 $ 8,599.56 $ 335,764.10
<br />3 1-Jan-09 $16,817.73 $ 8,423.63 $ 8,394.10 $ 327,340.47
<br />4 I-Jan-1O $16,817.73 $ 8,634.22 $ 8,183.51 $ 318,706.25
<br />5 l-Jan-11 $16,817.73 $ 8,850.07 $ 7,967.66 $ 309,856.18
<br />6 I-Jan-12 $16,817.73 $ 9,071.33 $ 7,746.40 $ 300,784.85
<br />7 I-Jan-13 $16,817.73 $ 9,298.11 $ 7,519.62 $ 291,486.74
<br />8 I-Jan-14 $16,817.73 $ 9,530.56 $ 7,287.17 $ 281,956.18
<br />9 l-Jan-15 $16,817.73 $ 9,768.83 $ 7,048.90 $ 272,187.35
<br />10 l-Jan-16 $16,817.73 $ 10,013.05 $ 6,804.68 $ 262,174.30
<br />11 l-Jan-17 $16,817.73 $ 10,263.37 $ 6,554.36 $ 251,910.93
<br />12 I-Jan-18 $16,817.73 $ 10,519.96 $ 6,297.77 $ 241,390.97
<br />13 I-Jan-19 $16,817.73 $ 10,782.96 $ 6,034.77 $ 230,608.01
<br />14 I-Jan-20 $16,817.73 $ 11,052.53 $ 5,765.20 $ 219,555.48
<br />15 I-Jan-21 $16,817.73 $ 11,328.84 $ 5,488.89 $ 208,226.64
<br />16 I-Jan-22 $16,817.73 $ 11,612.06 $ 5,205.67 $ 196,614.58
<br />17 l-Jan-23 $16,817.73 $ 11,902.37 $ 4,915.36 $ 184,712.21
<br />18 l-Jan-24 $16,817.73 $ 12,199.92 $ 4,617.81 $ 172,512.29
<br />19 1-Jan-25 $16,817.73 $ 12,504.92 $ 4,312.81 $ 160,007.37
<br />20 l-Jan-26 $16,817.73 $ 12,817.55 $ 4,000.18 $ 147,189.82
<br />21 l-Jan-27 $16,817.73 $ 13,137.98 $ 3,679.75 $ 134,051.84
<br />22 l-Jan-28 $16,817.73 $ 13,466.43 $ 3,351.30 $ 120,585.41
<br />23 I-Jan-29 $16,817.73 $ 13,803.09 $ 3,014.64 $ 106,782.32
<br />24 1-Jan-30 $16,817.73 $ 14,148.17 $ 2,669.56 $ 92,634.15
<br />25 1-Jan-31 $16,817.73 $ 14,501.88 $ 2,315.85 $ 78,132.27
<br />26 1-Jan-32 $16,817.73 $ 14,864.42 $ 1,953.31 $ 63,267.85
<br />27 1-Jan-33 $16,817.73 $ 15,236.03 $ 1,581.70 $ 48,031.82
<br />28 I-Jan-34 $16,817.73 $ 15,616.93 $ 1,200.80 $ 32,414.89
<br />29 1-Jan-35 $16,817.73 $ 16,007.36 $ 810.37 $ 16,407.53
<br />30 l-Jan-36 $16,817.72 $ 16,407.53 $ 410.19 $
<br />TOTALS $504,531.89 I $352,000.00 I $152,531.89 $0.00
<br />
<br />Amort Guenzi C1S0174 060S.xls
<br />
<br />SSB 1/11/2006
<br />
|