|
<br />. Colorado Water Conservation Board
<br /> Amortization Schedule
<br /> Borrower Decker Lateral Company Loan Amount: $ 100,000.00
<br /> Contract # #C1537 I nterest Rate 4.25%
<br /> Term 30
<br /> Annual Payment $5,959.82
<br /> Beginning Principal Ending
<br />Year ayment Balance Interest Reduction Balance
<br /> 1 100,000.00 4,250,00 1,709,82 98,290.18
<br /> 2 98,290.18 4,177,33 1,782.49 96,507.68
<br /> 3 96,507.68 4,101.58 1,858.25 94,649.44
<br /> 4 94,649.44 4,022.60 1,937.22 92,712.21
<br /> 5 92,712,21 3,940.27 2,019.56 90,692,66
<br /> 6 90,692,66 3,854.44 2,105.39 88,587,27
<br /> 7 88,587,27 3,764.96 2,194.87 86,392.40
<br /> 8 86,392.40 3,671,68 2,288.15 84,104,26
<br /> 9 84,104.26 3,574.43 2,385,39 81,718.86
<br /> 10 81,718.86 3,473,05 2,486,77 79,232.09
<br /> 11 79,232.09 3,367,36 2,592.46 76,639.63
<br /> 12 76,639.63 3,257,18 2,702.64 73,936.99
<br />. 13 73,936.99 3,142.32 2,817.50 71,119.48
<br />14 71,119.48 3,022.58 2,937.25 68,182.24
<br /> 15 68,182,24 2,897.75 3,062.08 65,120.16
<br /> 16 65,120,16 2,767.61 3,192.22 61,927.94
<br /> 17 61,927,94 2,631.94 3,327.89 58,600.05
<br /> 18 58,600,05 2,490.50 3,469.32 55,130.73
<br /> 19 55,130,73 2,343.06 3,616.77 51,513.96
<br /> 20 51,513,96 2,189.34 3,770.48 47,743.48
<br /> 21 47,743.48 2,029.10 3,930.73 43,812,76
<br /> 22 43,812.76 1,862.04 4,097.78 39,714.97
<br /> 23 39,714.97 1,687.89 4,271.94 35,443,03
<br /> 24 35,443.03 1,506.33 4,453.50 30,989,54
<br /> 25 30,989.54 1,317.06 4,642.77 26,346,77
<br /> 26 26,346.77 1,119.74 4,840.09 21,506.68
<br /> 27 21,506.68 914.03 5,045.79 16,460,89
<br /> 28 16,460.89 699.59 5,260.24 11,200.65
<br /> 29 11,200,65 476.03 5,483,80 5,716.86
<br /> 30 5,716.86 242.97 5,716,86 (0,00)
<br /> $ 78,794.74 $ 100,000,00
<br />
<br />Table 1
<br />Loan payback cash flow for $100,000
<br />
<br />.
<br />
<br />Feasibility Study
<br />Rehabilitation of the Lower Decker Lateral
<br />July 1997
<br />
<br />Prepared by J. lIIian
<br />Updated (7/18/97)
<br />
<br />9
<br />
|