|
COLORADO WATER CONSERVATION BOARD
<br /> LOAN REPAYMENT SCHEDULE
<br /> Borrower McDonald Ditch Company Final
<br /> Loan Contract Number CT2015-044 (C150334)
<br /> Principal $101,000.00
<br /> Interest Rate 2.50%
<br /> Frequency Annual
<br /> Term(In Years) 20
<br /> First Payment Due May 1,2017
<br /> Payment Amount $6,478.86
<br /> Loan Annual Annual
<br /> Payment Payment Payment Principal Interest Principal
<br /> No. Due Date Amount BALANCE
<br /> $ 101,000.00
<br /> 1 1-May-17 $6,478.86 $ 3,953.86 $ 2,525.00 $ 97,046.14
<br /> 2 1-May-18 $6,478.86 $ 4,052.71 $ 2,426.15 $ 92,993.43
<br /> 3 1-May-19 $6,478.86 $ 4,154.02 $ 2,324.84 $ 88,839.41
<br /> 4 1-May-20 $6,478.86 $ 4,257.87 $ 2,220.99 $ 84,581.54
<br /> 5 1-May-21 $6,478.86 $ 4,364.32 $ 2,114.54 $ 80,217.22
<br /> 6 1-May-22 $6,478.86 $ 4,473.43 $ 2,005.43 $ 75,743.79
<br /> 7 1-May-23 $6,478.86 $ 4,585.27 $ 1,893.59 $ 71,158.52
<br /> 8 1-May-24 $6,478.86 $ 4,699.90 $ 1,778.96 $ 66,458.62
<br /> 9 1-May-25 $6,478.86 $ 4,817.39 $ 1,661.47 $ 61,641.23
<br /> 10 1-May-26 $6,478.86 $ 4,937.83 $ 1,541.03 $ 56,703.40
<br /> 11 1-May-27 $6,478.86 $ 5,061.27 $ 1,417.59 $ 51,642.13
<br /> 12 1-May-28 $6,478.86 $ 5,187.81 $ 1,291.05 $ 46,454.32
<br /> 13 1-May-29 $6,478.86 $ 5,317.50 $ 1,161.36 $ 41,136.82
<br /> 14 1-May-30 $6,478.86 $ 5,450.44 $ 1,028.42 $ 35,686.38
<br /> 15 1-May-31 $6,478.86 $ 5,586.70 $ 892.16 $ 30,099.68
<br /> 16 1-May-32 $6,478.86 $ 5,726.37 $ 752.49 $ 24,373.31
<br /> 17 1-May-33 $6,478.86 $ 5,869.53 $ 609.33 $ 18,503.78
<br /> 18 1-May-34 $6,478.86 $ 6,016.27 $ 462.59 $ 12,487.51
<br /> 19 1-May-35 $6,478.86 $ 6,166.67 $ 312.19 $ 6,320.84
<br /> 20 1-May-36 $6,478.86 $ 6,320.84 $ 158.02 $ -
<br /> TOTALS $129,577.20 $101,000.00 $28,577.20 $0.00
<br /> Amort McDonald Ditch C 150334 0712.xlsx SSB 6/1/2016
<br />
|