|
<br />COLORADO WATER CONSERVATION BOARD
<br />
<br />LOAN REPAYMENT SCHEDULE
<br />
<br />Borrower
<br />
<br />Kern Resel'\loir and Ditcb Company
<br />
<br />Loan Contract Number
<br />Principal
<br />Interest Rate
<br />Frequency
<br />Term (In Years)
<br />First Payment Dne
<br />Payment Amonnt
<br />
<br />C1501l2
<br />$1,000,000.00
<br />5.10%
<br />Annual
<br />30
<br />November 1, 2004
<br />$65,794.84
<br />
<br />Loan Annual Annual Payment Principal
<br />Payment Payment Due Principal Interest
<br />No. Date Amount BALANCE
<br />
<br /> $ 1,000,000.00
<br />1 1-Nov-04 $65,794.84 $ 14,794.84 $ 51,000.00 $ 985,205.16
<br />2 1-Nov-05 $65,794.84 $ 15,549.38 $ 50,245.46 $ 969,655.78
<br />3 1-Nov-06 $65,794.84 $ 16,342.40 $ 49,452.44 $ 953,313.38
<br />4 1-Nov-07 $65,794.84 $ 17,175.86 $ 48,618.98 $ 936,137.52
<br />5 1-Nov-08 $65,794.84 $ 18,051.83 $ 47,743.01 $ 918,085.69
<br />6 1-Nov-09 $65,794.84 $ 18,972.47 $ 46,822.37 $ 899,113.22
<br />7 1-Nov-10 $65,794.84 $ 19,940.07 $ 45,854.77 $ . 879,173.15
<br />8 1-Nov-11 $65,794.84 $ 20,957.01 $ 44,837.83 $ 858,216.14
<br />9 1-Nov-12 $65,794.84 $ 22,025.82 $ 43.769.02 9; R::lR 1Qn 32
<br />,
<br />10 l-Nuv-13 $00,194.84 $ 23,149.13 $ 42,645.71 $ 813,041.19
<br />11 1-Nov-14 $65,794.84 $ 24,329.74 $ 41,465.10 $ 788,711.45
<br />12 1-Nov-15 $65,794.84 $ 25,570.56 $ 40,224.28 $ 763,140.89
<br />13 1-Nov-16 $65,794,84 $ 26,874.65 $ 38.920.19 $ 736,266.24
<br />14 1-Nov-17 $65,794,84 $ 28,245.26 $ 37,549.58 $ 708,020.98
<br />15 1-Nov-18 $65,794.84 $ 29,685.77 $ 36,109.07 $ 678,335.21
<br />16 1-Nov-19 $65,794.84 $ 31,199.74 $ 34,595.10 $ 647,135.47
<br />17 1-Nov-20 $65,794.84 $ 32,790.93 $ 33,003.91 $ 614,344.54
<br />. 18 1-Nov-21 ~65, 794.84 $ 34,463.27 ' $ 31,331.57 $ 579,881.27
<br />19 1-Nov-22 $65.794.84 $ 36,220.90 $ 29,573.94 $ 543,660.37
<br />20 1-Nov-23 $65,794.84 $ 38,068.16 $ 27,726.68 $ 505,592.21
<br />21 1-Nov-24 $65,794.84 $ 40,009.64 $ 25,785.20 $ 465,582.57
<br />22 1-Nov-25 $65,794.84 $ 42,050.13 $ 23,744.71 $ 423,532.44
<br />23 1-Nov-26 $65,794.84 $ 44,194.69 $ 21,600.15 $ 379,337.75
<br />24 1-Nov-27 $65,794.84 $ 46,448.61 $ 19,346.23 $ 332,889.14
<br />25 1-Nov-28 $65)94.84 $ 48,817.49 $ 16,977.35 $ 284,071.65
<br />26 1-Nov-29 $65,794.84 $ 51,307.19 $ 14,487.65 $ 232,764.46
<br />27 1-Nov-30 $65,794.84 $ 53.923.85 $ 11,870.99 $ 178,840.61
<br />28 1-Nov-31 $65,794.84 $ 56,673.97 $ 9,120,87 $ 122,166.64
<br />29 1-Nov-32 $65,794.84 $ 59,564.34 $ 6,230.50 $ 62,602.30
<br />30 1-Nov-33 $65,795.02 $ 62,602.30 $ 3,192.72 $
<br />TOTALS I $1,973,845,38 I $1,000,000.00 I $973,845.38 I $0.00
<br />
<br />EXAMPLE REPA YMENT.xls
<br />
<br />SSB 11117/03
<br />11/\7/2003
<br />
|