|
COLORADO WATER CONSERVATION BOARD
<br /> LOAN REPAYMENT SCHEDULE
<br /> Borrower Lake Canal Reservoir Company Final
<br /> Loan Contract Number CT 2015-042 (C150322) RE2016-555
<br /> Principal $204,298.00
<br /> Interest Rate 2.10%
<br /> Frequency Annual
<br /> Term(In Years) 30
<br /> First Payment Due July 1,2017
<br /> Payment Amount $9,247.79
<br /> Loan Annual Annual Principal
<br /> Payment Payment Payment Principal Interest BALANCE
<br /> No. Due Date Amount
<br /> $ 204,298.00
<br /> 1 1-Jul-17 $9,247.79 $ 4,957.53 $ 4,290.26 $ 199,340.47
<br /> 2 1-Jul-18 $9,247.79 $ 5,061.64 $ 4,186.15 $ 194,278.83
<br /> 3 1-Jul-19 $9,247.79 $ 5,167.93 $ 4,079.86 $ 189,110.90
<br /> 4 1-Jul-20 $9,247.79 $ 5,276.46 $ 3,971.33 $ 183,834.44
<br /> 5 1-Jul-21 $9,247.79 $ 5,387.27 $ 3,860.52 $ 178,447.17
<br /> 6 1-Jul-22 $9,247.79 $ 5,500.40 $ 3,747.39 $ 172,946.77
<br /> 7 1-Jul-23 $9,247.79 $ 5,615.91 $ 3,631.88 $ 167,330.86
<br /> 8 1-Jul-24 $9,247.79 $ 5,733.84 $ 3,513.95 $ 161,597.02
<br /> 9 1-Jul-25 $9,247.79 $ 5,854.25 $ 3,393.54 $ 155,742.77
<br /> 10 1-Jul-26 $9,247.79 $ 5,977.19 $ 3,270.60 $ 149,765.58
<br /> 11 1-Jul-27 $9,247.79 $ 6,102.71 $ 3,145.08 $ 143,662.87
<br /> 12 1-Jul-28 $9,247.79 $ 6,230.87 $ 3,016.92 $ 137,432.00
<br /> 13 1-Jul-29 $9,247.79 $ 6,361.72 $ 2,886.07 $ 131,070.28
<br /> 14 1-Jul-30 $9,247.79 $ 6,495.31 $ 2,752.48 $ 124,574.97
<br /> 15 1-Jul-31 $9,247.79 $ 6,631.72 $ 2,616.07 $ 117,943.25
<br /> 16 1-Jul-32 $9,247.79 $ 6,770.98 $ 2,476.81 $ 111,172.27
<br /> 17 1-Jul-33 $9,247.79 $ 6,913.17 $ 2,334.62 $ 104,259.10
<br /> 18 1-Jul-34 $9,247.79 $ 7,058.35 $ 2,189.44 $ 97,200.75
<br /> 19 1-Jul-35 $9,247.79 $ 7,206.57 $ 2,041.22 $ 89,994.18
<br /> 20 1-Jul-36 $9,247.79 $ 7,357.91 $ 1,889.88 $ 82,636.27
<br /> 21 1-Jul-37 $9,247.79 $ 7,512.43 $ 1,735.36 $ 75,123.84
<br /> 22 1-Jul-38 $9,247.79 $ 7,670.19 $ 1,577.60 $ 67,453.65
<br /> 23 1-Jul-39 $9,247.79 $ 7,831.26 $ 1,416.53 $ 59,622.39
<br /> 24 1-Jul-40 $9,247.79 $ 7,995.72 $ 1,252.07 $ 51,626.67
<br /> 25 1-Jul-41 $9,247.79 $ 8,163.63 $ 1,084.16 $ 43,463.04
<br /> 26 1-Jul-42 $9,247.79 $ 8,335.07 $ 912.72 $ 35,127.97
<br /> 27 1-Jul-43 $9,247.79 $ 8,510.10 $ 737.69 $ 26,617.87
<br /> 28 1-Jul-44 $9,247.79 $ 8,688.81 $ 558.98 $ 17,929.06
<br /> 29 1-Jul-45 $9,247.79 $ 8,871.28 $ 376.51 $ 9,057.78
<br /> 30 1-Jul-46 $9,247.99 $ 9,057.78 $ 190.21 $ -
<br /> TOTALS $277,433.90 $204,298.00 $73,135.90 $0.00
<br /> Amort Lake Canal Res C150322 1011 xlsx SSB 7/7/2016
<br />
|