|
<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 Cotton Creek Water Com Loan Amount: $ 100,000.00
<br /> Contract #C153772 I nterest Rate 3.75%
<br /> Term 30
<br /> Annual Payment $5,608.76
<br /> Beginning Principal Ending
<br />Year Payment # Balance Interest Reduction Balance
<br /> 1 100,000.00 3,750.00 1,858.76 98,141.24
<br /> 2 98,141.24 3,680.30 1,928.47 96,212.77
<br /> 3 96,212.77 3,607.98 2,000.78 94,211 .99
<br /> 4 94,211.99 3,532.95 2,075.81 92,136.18
<br /> 5 92,136.18 3,455.11 2,153.66 89,982.52
<br /> 6 89,982.52 3,374.34 2,234.42 87,748.10
<br /> 7 87,748.10 3,290.55 2,318.21 85,429.89
<br /> 8 85,429.89 3,203.62 2,405.14 83,024.75
<br /> 9 83,024.75 3,113.43 2,495.33 80,529.42
<br /> 10 80,529.42 3,019.85 2,588.91 77,940.51
<br /> 11 77,940.51 2,922.77 2,685.99 75,254.51
<br /> 12 75,254.51 2,822.04 2,786.72 72,467.80
<br /> 13 72,467.80 2,717.54 2,891.22 69,576.58
<br /> 14 69,576.58 2,609.12 2,999.64 66,576.94
<br /> 15 66,576.94 2,496.64 3,112.13 63,464.81
<br /> 16 63,464.81 2,379.93 3,228.83 60,235.98
<br /> 17 60,235.98 2,258.85 3,349.91 56,886.06
<br /> 18 56,886.06 2,133.23 3,4 75.54 53,410.53
<br /> 19 53,410.53 2,002.89 3,605.87 49,804.66
<br /> 20 49,804.66 1 .867.67 3,741.09 46,063.57
<br /> 21 46,063.57 1,727.38 3,881.38 42,182.19
<br /> 22 42,182.19 1,581.83 4,026.93 38,155.26
<br /> 23 38,155.26 1,430.82 4,177.94 33,977.32
<br /> 24 33,977.32 1,274.15 4,334.61 29,642.71
<br /> 25 29,642.71 1,111.60 4,497.16 25,145.55
<br /> 26 25,145.55 942.96 4,665.80 20,479.75
<br /> 27 20,479.75 767.99 4,840.77 15,638.97
<br /> 28 15,638.97 586.46 5,022.30 10,616.67
<br /> 29 10,616.67 398.13 5,210.64 5,406.04
<br /> 30 5,406.04 202.73 5,406.04 0.00
<br /> $ 68,262.87 $100,000.00
<br />
<br />Table showing loan payback cash flow
<br />
<br />Feasibility of Rehabilitation of the
<br />Cotton Creek Airline Ditch
<br />March 1997
<br />
<br />9
<br />
<br />Prepared by J. IIlian
<br />Updated (5/30/97)
<br />
|