|
COLORADO WATER CONSERVATION BOARD
<br /> LOAN REPAYMENT SCHEDULE
<br /> Borrower Las Animas Consolidated Canal Final
<br /> Company
<br /> Loan Contract Number CT 2016-1007
<br /> Principal $95,054.27
<br /> Interest Rate 2.00%
<br /> Frequency Annual
<br /> Term(In Years) 30
<br /> First Payment Due June 1,2017
<br /> Payment Amount $4,244.17
<br /> Loan Annual Annual
<br /> Payment Payment Payment Principal Interest Principal
<br /> No. Due Date Amount BALANCE
<br /> $ 95,054.27
<br /> 1 1-Jun-17 $4,244.17 $ 2,343.08 $ 1,901.09 $ 92,711.19
<br /> 2 1-Jun-18 $4,244.17 $ 2,389.95 $ 1,854.22 $ 90,321.24
<br /> 3 1-Jun-19 $4,244.17 $ 2,437.75 $ 1,806.42 $ 87,883.49
<br /> 4 1-Jun-20 $4,244.17 $ 2,486.50 $ 1,757.67 $ 85,396.99
<br /> 5 1-Jun-21 $4,244.17 $ 2,536.23 $ 1,707.94 $ 82,860.76
<br /> 6 1-Jun-22 $4,244.17 $ 2,586.95 $ 1,657.22 $ 80,273.81
<br /> 7 1-Jun-23 $4,244.17 $ 2,638.69 $ 1,605.48 $ 77,635.12
<br /> 8 1-Jun-24 $4,244.17 $ 2,691.47 $ 1,552.70 $ 74,943.65
<br /> 9 1-Jun-25 $4,244.17 $ 2,745.30 $ 1,498.87 $ 72,198.35
<br /> 10 1-Jun-26 $4,244.17 $ 2,800.20 $ 1,443.97 $ 69,398.15
<br /> 11 1-Jun-27 $4,244.17 $ 2,856.21 $ 1,387.96 $ 66,541.94
<br /> 12 1-Jun-28 $4,244.17 $ 2,913.33 $ 1,330.84 $ 63,628.61
<br /> 13 1-Jun-29 $4,244.17 $ 2,971.60 $ 1,272.57 $ 60,657.01
<br /> 14 1-Jun-30 $4,244.17 $ 3,031.03 $ 1,213.14 $ 57,625.98
<br /> 15 1-Jun-31 $4,244.17 $ 3,091.65 $ 1,152.52 $ 54,534.33
<br /> 16 1-Jun-32 $4,244.17 $ 3,153.48 $ 1,090.69 $ 51,380.85
<br /> 17 1-Jun-33 $4,244.17 $ 3,216.55 $ 1,027.62 $ 48,164.30
<br /> 18 1-Jun-34 $4,244.17 $ 3,280.88 $ 963.29 $ 44,883.42
<br /> 19 1-Jun-35 $4,244.17 $ 3,346.50 $ 897.67 $ 41,536.92
<br /> 20 1-Jun-36 $4,244.17 $ 3,413.43 $ 830.74 $ 38,123.49
<br /> 21 1-Jun-37 $4,244.17 $ 3,481.70 $ 762.47 $ 34,641.79
<br /> 22 1-Jun-38 $4,244.17 $ 3,551.33 $ 692.84 $ 31,090.46
<br /> 23 1-Jun-39 $4,244.17 $ 3,622.36 $ 621.81 $ 27,468.10
<br /> 24 1-Jun-40 $4,244.17 $ 3,694.81 $ 549.36 $ 23,773.29
<br /> 25 1-Jun-41 $4,244.17 $ 3,768.70 $ 475.47 $ 20,004.59
<br /> 26 1-Jun-42 $4,244.17 $ 3,844.08 $ 400.09 $ 16,160.51
<br /> 27 1-Jun-43 $4,244.17 $ 3,920.96 $ 323.21 $ 12,239.55
<br /> 28 1-Jun-44 $4,244.17 $ 3,999.38 $ 244.79 $ 8,240.17
<br /> 29 1-Jun-45 $4,244.17 $ 4,079.37 $ 164.80 $ 4,160.80
<br /> 30 1-Jun-46 $4,244.02 $ 4,160.80 $ 83.22 $ -
<br /> TOTALS $127,324.95 $95,054.27 I $32,270.68 $0.00
<br /> AmortLasAnimasConCanalCo112014(2).xlsx SSB 6/3/2016
<br />
|