|
COLORADO WATER CONSERVATION BOARD
<br /> LOAN REPAYMENT SCHEDULE
<br /> Borrower Brighton Ditch Company Final
<br /> Loan Contract Number CT 2016-2040
<br /> Principal $225,000.00
<br /> Interest Rate 2.55%
<br /> Frequency Annual
<br /> Term(In Years) 30
<br /> First Payment Due May 1,2017
<br /> Payment Amount $10,821.76
<br /> Loan Annual Annual Principal
<br /> Payment Payment Payment Principal Interest BALANCE
<br /> No. Due Date Amount
<br /> $ 225,000.00
<br /> 1 1-May-17 $10,821.76 $ 5,084.26 $ 5,737.50 $ 219,915.74
<br /> 2 1-May-18 $10,821.76 $ 5,213.91 $ 5,607.85 $ 214,701.83
<br /> 3 1-May-19 $10,821.76 $ 5,346.86 $ 5,474.90 $ 209,354.97
<br /> 4 1-May-20 $10,821.76 $ 5,483.21 $ 5,338.55 $ 203,871.76
<br /> 5 1-May-21 $10,821.76 $ 5,623.03 $ 5,198.73 $ 198,248.73
<br /> 6 1-May-22 $10,821.76 $ 5,766.42 $ 5,055.34 $ 192,482.31
<br /> 7 1-May-23 $10,821.76 $ 5,913.46 $ 4,908.30 $ 186,568.85
<br /> 8 1-May-24 $10,821.76 $ 6,064.25 $ 4,757.51 $ 180,504.60
<br /> 9 1-May-25 $10,821.76 $ 6,218.89 $ 4,602.87 $ 174,285.71
<br /> 10 1-May-26 $10,821.76 $ 6,377.47 $ 4,444.29 $ 167,908.24
<br /> 11 1-May-27 $10,821.76 $ 6,540.10 $ 4,281.66 $ 161,368.14
<br /> 12 1-May-28 $10,821.76 $ 6,706.87 $ 4,114.89 $ 154,661.27
<br /> 13 1-May-29 $10,821.76 $ 6,877.90 $ 3,943.86 $ 147,783.37
<br /> 14 1-May-30 $10,821.76 $ 7,053.28 $ 3,768.48 $ 140,730.09
<br /> 15 1-May-31 $10,821.76 $ 7,233.14 $ 3,588.62 $ 133,496.95
<br /> 16 1-May-32 $10,821.76 $ 7,417.59 $ 3,404.17 $ 126,079.36
<br /> 17 1-May-33 $10,821.76 $ 7,606.74 $ 3,215.02 $ 118,472.62
<br /> 18 1-May-34 $10,821.76 $ 7,800.71 $ 3,021.05 $ 110,671.91
<br /> 19 1-May-35 $10,821.76 $ 7,999.63 $ 2,822.13 $ 102,672.28
<br /> 20 1-May-36 $10,821.76 $ 8,203.62 $ 2,618.14 $ 94,468.66
<br /> 21 1-May-37 $10,821.76 $ 8,412.81 $ 2,408.95 $ 86,055.85
<br /> 22 1-May-38 $10,821.76 $ 8,627.34 $ 2,194.42 $ 77,428.51
<br /> 23 1-May-39 $10,821.76 $ 8,847.33 $ 1,974.43 $ 68,581.18
<br /> 24 1-May-40 $10,821.76 $ 9,072.94 $ 1,748.82 $ 59,508.24
<br /> 25 1-May-41 $10,821.76 $ 9,304.30 $ 1,517.46 $ 50,203.94
<br /> 26 1-May-42 $10,821.76 $ 9,541.56 $ 1,280.20 $ 40,662.38
<br /> 27 1-May-43 $10,821.76 $ 9,784.87 $ 1,036.89 $ 30,877.51
<br /> 28 1-May-44 $10,821.76 $ 10,034.38 $ 787.38 $ 20,843.13
<br /> 29 1-May-45 $10,821.76 $ 10,290.26 $ 531.50 $ 10,552.87
<br /> 30 1-May-46 $10,821.97 $ 10,552.87 $ 269.10 $ -
<br /> TOTALS $324,653.01 $225,000.00 $99,653.01 $0.00
<br /> AmortBrightonDitch1015.xlsx SSB 4/29/2016
<br />
|