|
COLORADO WATER CONSERVATION BOARD
<br /> LOAN REPAYMENT SCHEDULE
<br /> Louden Irrigating Canal and
<br /> Borrower Final
<br /> Reservoir Company
<br /> L _
<br /> Loan Contract Number CT 2015-151 (C150398)
<br /> Principal $161,600.00 $126,250.00
<br /> Interest Rate 2.70% 2.70%
<br /> Frequency Annual Annual
<br /> Term(In Years) 30 30
<br /> First Payment Due July 1,2017
<br /> Payment Amount $6,193.93
<br /> Loan Annual Annual
<br /> Payment Payment Payment Principal Interest Principal
<br /> No. Due Date Amount BALANCE
<br /> $ 126,250.00
<br /> 1 1-Jul-17 $6,193.93 $ 2,785.18 $ 3,408.75 $ 123,464.82
<br /> 2 1-Jul-18 $6,193.93 $ 2,860.38 $ 3,333.55 $ 120,604.44
<br /> 3 1-Jul-19 $6,193.93 $ 2,937.61 $ 3,256.32 $ 117,666.83
<br /> 4 1-Jul-20 $6,193.93 $ 3,016.93 $ 3,177.00 $ 114,649.90
<br /> 5 1-Jul-21 $6,193.93 $ 3,098.38 $ 3,095.55 $ 111,551.52
<br /> 6 1-Jul-22 $6,193.93 $ 3,182.04 $ 3,011.89 $ 108,369.48
<br /> 7 1-Jul-23 $6,193.93 $ 3,267.95 $ 2,925.98 $ 105,101.53
<br /> 8 1-Jul-24 $6,193.93 $ 3,356.19 $ 2,837.74 $ 101,745.34
<br /> 9 1-Jul-25 $6,193.93 $ 3,446.81 $ 2,747.12 $ 98,298.53
<br /> 10 1-Jul-26 $6,193.93 $ 3,539.87 $ 2,654.06 $ 94,758.66
<br /> 11 1-Jul-27 $6,193.93 $ 3,635.45 $ 2,558.48 $ 91,123.21
<br /> 12 1-Jul-28 $6,193.93 $ 3,733.60 $ 2,460.33 $ 87,389.61
<br /> 13 1-Jul-29 $6,193.93 $ 3,834.41 $ 2,359.52 $ 83,555.20
<br /> 14 1-Jul-30 $6,193.93 $ 3,937.94 $ 2,255.99 $ 79,617.26
<br /> 15 1-Jul-31 $6,193.93 $ 4,044.26 $ 2,149.67 $ 75,573.00
<br /> 16 1-Jul-32 $6,193.93 $ 4,153.46 $ 2,040.47 $ 71,419.54
<br /> 17 1-Jul-33 $6,193.93 $ 4,265.60 $ 1,928.33 $ 67,153.94
<br /> 18 1-Jul-34 $6,193.93 $ 4,380.77 $ 1,813.16 $ 62,773.17
<br /> 19 1-Jul-35 $6,193.93 $ 4,499.05 $ 1,694.88 $ 58,274.12
<br /> 20 1-Jul-36 $6,193.93 $ 4,620.53 $ 1,573.40 $ 53,653.59
<br /> 21 1-Jul-37 $6,193.93 $ 4,745.28 $ 1,448.65 $ 48,908.31
<br /> 22 1-Jul-38 $6,193.93 $ 4,873.41 $ 1,320.52 $ 44,034.90
<br /> 23 1-Jul-39 $6,193.93 $ 5,004.99 $ 1,188.94 $ 39,029.91
<br /> 24 1-Jul-40 $6,193.93 $ 5,140.12 $ 1,053.81 $ 33,889.79
<br /> 25 1-Jul-41 $6,193.93 $ 5,278.91 $ 915.02 $ 28,610.88
<br /> 26 1-Jul-42 $6,193.93 $ 5,421.44 $ 772.49 $ 23,189.44
<br /> 27 1-Jul-43 $6,193.93 $ 5,567.82 $ 626.11 $ 17,621.62
<br /> 28 1-Jul-44 $6,193.93 $ 5,718.15 $ 475.78 $ 11,903.47
<br /> 29 1-Jul-45 $6,193.93 $ 5,872.54 $ 321.39 $ 6,030.93
<br /> 30 1-Jul-46 $6,193.77 $ 6,030.93 $ 162.84 $ -
<br /> TOTALS $185,817.74 $126,250.00 $59,567.74 $0.00
<br /> Amort Louden C150398 0514.xlsx SSB 10/14/2016
<br />
|