|
COLORADO WATER CONSERVATION BOARD
<br /> LOAN REPAYMENT SCHEDULE
<br /> Lower Arkansas Valley Water
<br /> Borrower FINAL
<br /> Conservancy Distirct
<br /> Loan Contract Number CT 2015-175 RE2016-354
<br /> Principal $2,560,350.00
<br /> Interest Rate 1.45%
<br /> Frequency Annual
<br /> Term(In Years) 20
<br /> First Payment Due January 1,2017
<br /> Payment Amount $148,395.46
<br /> Loan Annual Annual Principal
<br /> Payment Payment Payment Principal Interest BALANCE
<br /> No. Due Date Amount
<br /> $ 2,560,350.00
<br /> 1 1-Jan-17 $148,395.46 $ 111,270.38 $ 37,125.08 $ 2,449,079.62
<br /> 2 1-Jan-18 $148,395.46 $ 112,883.81 $ 35,511.65 $ 2,336,195.81
<br /> 3 1-Jan-19 $148,395.46 $ 114,520.62 $ 33,874.84 $ 2,221,675.19
<br /> 4 1-Jan-20 $148,395.46 $ 116,181.17 $ 32,214.29 $ 2,105,494.02
<br /> 5 1-Jan-21 $148,395.46 $ 117,865.80 $ 30,529.66 $ 1,987,628.22
<br /> 6 1-Jan-22 $148,395.46 $ 119,574.85 $ 28,820.61 $ 1,868,053.37
<br /> 7 1-Jan-23 $148,395.46 $ 121,308.69 $ 27,086.77 $ 1,746,744.68
<br /> 8 1-Jan-24 $148,395.46 $ 123,067.66 $ 25,327.80 $ 1,623,677.02
<br /> 9 I-Jan-25 $148,395.46 $ 124,852.14 $ 23,543.32 $ 1,498,824.88
<br /> 10 I-Jan-26 $148,395.46 $ 126,662.50 $ 21,732.96 $ 1,372,162.38
<br /> 11 I-Jan-27 $148,395.46 $ 128,499.11 $ 19,896.35 $ 1,243,663.27
<br /> 12 1-Jan-28 $148,395.46 $ 130,362.34 $ 18,033.12 $ 1,113,300.93
<br /> 13 1-Jan-29 $148,395.46 $ 132,252.60 $ 16,142.86 $ 981,048.33
<br /> 14 1-Jan-30 $148,395.46 $ 134,170.26 $ 14,225.20 $ 846,878.07
<br /> 15 1-Jan-31 $148,395.46 $ 136,115.73 $ 12,279.73 $ 710,762.34
<br /> 16 1-Jan-32 $148,395.46 $ 138,089.41 $ 10,306.05 $ 572,672.93
<br /> 17 1-Jan-33 $148,395.46 $ 140,091.70 $ 8,303.76 $ 432,581.23
<br /> 18 1-Jan-34 $148,395.46 $ 142,123.03 $ 6,272.43 $ 290,458.20
<br /> 19 1-Jan-35 $148,395.46 $ 144,183.82 $ 4,211.64 $ 146,274.38
<br /> 20 1-Jan-36 $148,395.36 $ 146,274.38 $ 2,120.98 $ -
<br /> TOTALS I $2,967,909.10 $2,560,350.00 $407,559.10 $0.00
<br /> AmortLowerArkansasValleyWCD0515.xlsx SSB 2/5/2016
<br />
|