|
COLORADO WATER CONSERVATION BOARD
<br /> LOAN REPAYMENT SCHEDULE
<br /> Borrower The Terrace Irrigation Company FINAL
<br /> Loan Contract Number C150332
<br /> Principal $2,751,968.00
<br /> Interest Rate 1.75%
<br /> Frequency Annual
<br /> Term(In Years) 30
<br /> First Payment Due June 1,2016
<br /> Payment Amount $118,691.71
<br /> Loan Annual
<br /> Annual Payment Principal
<br /> Payment Payment Due Principal Interest
<br /> No. Date Amount BALANCE
<br /> $ 2,751,968.00
<br /> Adjustment 1-Jun-15 $39,365.63 $ 39,365.63 $ - $ 2,712,602.37
<br /> 1 1-Jun-16 $118,691.71 $ 71,221.17 $ 47,470.54 $ 2,641,381.20
<br /> 2 1-Jun-17 $118,691.71 $ 72,467.54 $ 46,224.17 $ 2,568,913.66
<br /> 3 1-Jun-18 $118,691.71 $ 73,735.72 $ 44,955.99 $ 2,495,177.94
<br /> 4 1-Jun-19 $118,691.71 $ 75,026.10 $ 43,665.61 $ 2,420,151.84
<br /> 5 1-Jun-20 $118,691.71 $ 76,339.05 $ 42,352.66 $ 2,343,812.79
<br /> 6 1-Jun-21 $118,691.71 $ 77,674.99 $ 41,016.72 $ 2,266,137.80
<br /> 7 1-Jun-22 $118,691.71 $ 79,034.30 $ 39,657.41 $ 2,187,103.50
<br /> 8 1-Jun-23 $118,691.71 $ 80,417.40 $ 38,274.31 $ 2,106,686.10
<br /> 9 1-Jun-24 $118,691.71 $ 81,824.70 $ 36,867.01 $ 2,024,861.40
<br /> 10 1-Jun-25 $118,691.71 $ 83,256.64 $ 35,435.07 $ 1,941,604.76
<br /> 11 1-Jun-26 $118,691.71 $ 84,713.63 $ 33,978.08 $ 1,856,891.13
<br /> 12 1-Jun-27 $118,691.71 $ 86,196.12 $ 32,495.59 $ 1,770,695.01
<br /> 13 1-Jun-28 $118,691.71 $ 87,704.55 $ 30,987.16 $ 1,682,990.46
<br /> 14 1-Jun-29 $118,691.71 $ 89,239.38 $ 29,452.33 $ 1,593,751.08
<br /> 15 1-Jun-30 $118,691.71 $ 90,801.07 $ 27,890.64 $ 1,502,950.01
<br /> 16 1-Jun-31 $118,691.71 $ 92,390.08 $ 26,301.63 $ 1,410,559.93
<br /> 17 1-Jun-32 $118,691.71 $ 94,006.91 $ 24,684.80 $ 1,316,553.02
<br /> 18 1-Jun-33 $118,691.71 $ 95,652.03 $ 23,039.68 $ 1,220,900.99
<br /> 19 1-Jun-34 $118,691.71 $ 97,325.94 $ 21,365.77 $ 1,123,575.05
<br /> 20 1-Jun-35 $118,691.71 $ 99,029.15 $ 19,662.56 $ 1,024,545.90
<br /> 21 1-Jun-36 $118,691.71 $ 100,762.16 $ 17,929.55 $ 923,783.74
<br /> 22 1-Jun-37 $118,691.71 $ 102,525.49 $ 16,166.22 $ 821,258.25
<br /> 23 1-Jun-38 $118,691.71 $ 104,319.69 $ 14,372.02 $ 716,938.56
<br /> 24 1-Jun-39 $118,691.71 $ 106,145.29 $ 12,546.42 $ 610,793.27
<br /> 25 1-Jun-40 $118,691.71 $ 108,002.83 $ 10,688.88 $ 502,790.44
<br /> 26 1-Jun-41 $118,691.71 $ 109,892.88 $ 8,798.83 $ 392,897.56
<br /> 27 1-Jun-42 $118,691.71 $ 111,816.00 $ 6,875.71 $ 281,081.56
<br /> 28 1-Jun-43 $118,691.71 $ 113,772.78 $ 4,918.93 $ 167,308.78
<br /> 29 1-Jun-44 $118,691.71 $ 115,763.81 $ 2,927.90 $ 51,544.97
<br /> 30 1-Jun-45 $52,447.01 $ 51,544.97 $ 902.04 $ -
<br /> TOTALS $3,494,506.60 I $2,712,602.37 I $781,904.23 I $0.00
<br /> Amort Terrace C150332 0512.xlsx SSB 6/11/2015
<br />
|