|
<br />I
<br />I
<br />I
<br />I
<br />I
<br />I
<br />I
<br />I
<br />I
<br />I
<br />I
<br />I
<br />I
<br />I
<br />I
<br />I
<br />I
<br />I
<br />I
<br />
<br /> Colorado Water Conservation Board
<br /> Amortization Schedule
<br /> Borrower Chipperfield Lane Loan Amount: $ 60,000.00
<br /> Contract #C1537 Interest Rate 3.75%
<br /> Term 30
<br /> Annual Payment $3,365.26
<br /> Beginning Principal Ending
<br />Year Payment # Balance Interest Reduction Balance
<br /> 1 60,000.00 2,250.00 1,115.26 58,884.74
<br /> 2 58,884.74 2,208.18 1,157.08 57,727.66
<br /> 3 57,727.66 2,164.79 1,200.47 56,527.19
<br /> 4 56,527.19 2,119.77 1,245.49 55,281.71
<br /> 5 55,281.71 2,073.06 1,292.19 53,989.51
<br /> 6 53,989.51 2,024.61 1,340.65 52,648.86
<br /> 7 52,648.86 1,974.33 1,390.93 51,257.94
<br /> 8 51,257.94 1,922.17 1,443.08 49,814.85
<br /> 9 49,814.85 1,868.06 1,497.20 48,317.65
<br /> 10 48,317.65 1,811.91 1,553.35 46,764.30
<br /> 11 46,764.30 1,753.66 1,611.60 45,152.71
<br /> 12 45,152.71 1,693.23 1,672.03 43,480.68
<br /> 13 43,480.68 1,630.53 1,734.73 41,745.95
<br /> 14 41,745.95 1,565.47 1,799.78 39,946.16
<br /> 15 39,946.16 1,497.98 1,867.28 38,078.88
<br /> 16 38,078.88 1,427.96 1,937.30 36,141.59
<br /> 17 36,141.59 1,355.31 2,009.95 34,131.64
<br /> 18 34,131.64 1,279.94 2,085.32 32,046.32
<br /> 19 32,046.32 1,201.74 2,163.52 29,882.80
<br /> 20 29,882.80 1,120.60 2,244.65 27,638.14
<br /> 21 27,638.14 1,036.43 2,328.83 25,309.32
<br /> 22 25,309.32 949.10 2,416.16 22,893.16
<br /> 23 22,893.16 858.49 2,506.76 20,386.39
<br /> 24 20,386.39 764.49 2,600.77 17,785.63
<br /> 25 17,785.63 666.96 2,698.30 15,087.33
<br /> 26 15,087.33 565.77 2,799.48 12,287.85
<br /> 27 12,287.85 460.79 2,904.46 9,383.38
<br /> 28 9,383.38 351.88 3,013.38 6,370.00
<br /> 29 6,370.00 238.88 3,126.38 3,243.62
<br /> 30 3,243.62 121.64 3,243.62 0.00
<br /> $ 40,957.72 $60,000.00
<br />
<br />Table showing loan payback cash flow
<br />
<br />Feasibility Study
<br />Chipperfield Lane Headgate and Pipeline
<br />June 1997
<br />
<br />8
<br />
<br />Prepared by J. Illian
<br />Updated (7/10/97)
<br />
|