|
COLORADO WATER CONSERVATION BOARD
<br /> LOAN REPAYMENT SCHEDULE
<br /> Borrower Henrylyn Irrigation District FINAL
<br /> Loan Contract Number C150358
<br /> Principal $1,824,204.41
<br /> Interest Rate 1.75%
<br /> Frequency Annual
<br /> Term(In Years) 30
<br /> First Payment Due June 1,2015
<br /> Payment Amount $78,677.49
<br /> Loan Annual Annual
<br /> Payment Payment Payment Principal Interest Principal
<br /> No. Due Date Amount BALANCE
<br /> $ 1,824,204.41
<br /> 1 1-Jun-15 $78,677.49 $ 46,753.91 $ 31,923.58 $ 1,777,450.50
<br /> 2 1-Jun-16 $78,677.49 $ 47,572.11 $ 31,105.38 $ 1,729,878.39
<br /> 3 1-Jun-17 $78,677.49 $ 48,404.62 $ 30,272.87 $ 1,681,473.77
<br /> 4 1-Jun-18 $78,677.49 $ 49,251.70 $ 29,425.79 $ 1,632,222.07
<br /> 5 1-Jun-19 $78,677.49 $ 50,113.60 $ 28,563.89 $ 1,582,108.47
<br /> 6 1-Jun-20 $78,677.49 $ 50,990.59 $ 27,686.90 $ 1,531,117.88
<br /> 7 1-Jun-21 $78,677.49 $ 51,882.93 $ 26,794.56 $ 1,479,234.95
<br /> 8 1-Jun-22 $78,677.49 $ 52,790.88 $ 25,886.61 $ 1,426,444.07
<br /> 9 1-Jun-23 $78,677.49 $ 53,714.72 $ 24,962.77 $ 1,372,729.35
<br /> 10 1-Jun-24 $78,677.49 $ 54,654.73 $ 24,022.76 $ 1,318,074.62
<br /> 11 1-Jun-25 $78,677.49 $ 55,611.18 $ 23,066.31 $ 1,262,463.44
<br /> 12 1-Jun-26 $78,677.49 $ 56,584.38 $ 22,093.11 $ 1,205,879.06
<br /> 13 1-Jun-27 $78,677.49 $ 57,574.61 $ 21,102.88 $ 1,148,304.45
<br /> 14 1-Jun-28 $78,677.49 $ 58,582.16 $ 20,095.33 $ 1,089,722.29
<br /> 15 1-Jun-29 $78,677.49 $ 59,607.35 $ 19,070.14 $ 1,030,114.94
<br /> 16 1-Jun-30 $78,677.49 $ 60,650.48 $ 18,027.01 $ 969,464.46
<br /> 17 1-Jun-31 $78,677.49 $ 61,711.86 $ 16,965.63 $ 907,752.60
<br /> 18 1-Jun-32 $78,677.49 $ 62,791.82 $ 15,885.67 $ 844,960.78
<br /> 19 1-Jun-33 $78,677.49 $ 63,890.68 $ 14,786.81 $ 781,070.10
<br /> 20 1-Jun-34 $78,677.49 $ 65,008.76 $ 13,668.73 $ 716,061.34
<br /> 21 1-Jun-35 $78,677.49 $ 66,146.42 $ 12,531.07 $ 649,914.92
<br /> 22 1-Jun-36 $78,677.49 $ 67,303.98 $ 11,373.51 $ 582,610.94
<br /> 23 1-Jun-37 $78,677.49 $ 68,481.80 $ 10,195.69 $ 514,129.14
<br /> 24 1-Jun-38 $78,677.49 $ 69,680.23 $ 8,997.26 $ 444,448.91
<br /> 25 1-Jun-39 $78,677.49 $ 70,899.63 $ 7,777.86 $ 373,549.28
<br /> 26 1-Jun-40 $78,677.49 $ 72,140.38 $ 6,537.11 $ 301,408.90
<br /> 27 1-Jun-41 $78,677.49 $ 73,402.83 $ 5,274.66 $ 228,006.07
<br /> 28 1-Jun-42 $78,677.49 $ 74,687.38 $ 3,990.11 $ 153,318.69
<br /> 29 1-Jun-43 $78,677.49 $ 75,994.41 $ 2,683.08 $ 77,324.28
<br /> 30 1-Jun-44 $78,677.45 $ 77,324.28 $ 1,353.17 $ -
<br /> TOTALS $2,360,324.66 $1,824,204.41 I $536,120.25 I $0.00
<br /> Amort Henrylyn C150358 0713.xlsx SSB 5/16/2014
<br />
|