|
COLORADO WATER CONSERVATION BOARD
<br /> LOAN REPAYMENT SCHEDULE
<br /> Borrower The Union Ditch Company
<br /> Final
<br /> Loan Contract Number C150172
<br /> Principal $100,061.53
<br /> Interest Rate 2.50%
<br /> Frequency Annual
<br /> Term(In Years) 30
<br /> First Payment Due December 1,2014
<br /> Payment Amount $4,780.70
<br /> Loan Annual Annual Payment Principal
<br /> Payment Payment Due Amount Principal Interest BALANCE
<br /> No. Date
<br /> $ 100,061.53
<br /> 1 1-Dec-14 $4,780.70 $ 2,279.16 $ 2,501.54 $ 97,782.37
<br /> 2 1-Dec-15 $4,780.70 $ 2,336.14 $ 2,444.56 $ 95,446.23
<br /> 3 1-Dec-16 $4,780.70 $ 2,394.54 $ 2,386.16 $ 93,051.69
<br /> 4 1-Dec-17 $4,780.70 $ 2,454.41 $ 2,326.29 $ 90,597.28
<br /> 5 1-Dec-18 $4,780.70 $ 2,515.77 $ 2,264.93 $ 88,081.51
<br /> 6 1-Dec-19 $4,780.70 $ 2,578.66 $ 2,202.04 $ 85,502.85
<br /> 7 1-Dec-20 $4,780.70 $ 2,643.13 $ 2,137.57 $ 82,859.72
<br /> 8 1-Dec-21 $4,780.70 $ 2,709.21 $ 2,071.49 $ 80,150.51
<br /> 9 1-Dec-22 $4,780.70 $ 2,776.94 $ 2,003.76 $ 77,373.57
<br /> 10 1-Dec-23 $4,780.70 $ 2,846.36 $ 1,934.34 $ 74,527.21
<br /> 11 1-Dec-24 $4,780.70 $ 2,917.52 $ 1,863.18 $ 71,609.69
<br /> 12 1-Dec-25 $4,780.70 $ 2,990.46 $ 1,790.24 $ 68,619.23
<br /> 13 1-Dec-26 $4,780.70 $ 3,065.22 $ 1,715.48 $ 65,554.01
<br /> 14 1-Dec-27 $4,780.70 $ 3,141.85 $ 1,638.85 $ 62,412.16
<br /> 15 1-Dec-28 $4,780.70 $ 3,220.40 $ 1,560.30 $ 59,191.76
<br /> 16 1-Dec-29 $4,780.70 $ 3,300.91 $ 1,479.79 $ 55,890.85
<br /> 17 1-Dec-30 $4,780.70 $ 3,383.43 $ 1,397.27 $ 52,507.42
<br /> 18 1-Dec-31 $4,780.70 $ 3,468.01 $ 1,312.69 $ 49,039.41
<br /> 19 1-Dec-32 $4,780.70 $ 3,554.71 $ 1,225.99 $ 45,484.70
<br /> 20 1-Dec-33 $4,780.70 $ 3,643.58 $ 1,137.12 $ 41,841.12
<br /> 21 1-Dec-34 $4,780.70 $ 3,734.67 $ 1,046.03 $ 38,106.45
<br /> 22 1-Dec-35 $4,780.70 $ 3,828.04 $ 952.66 $ 34,278.41
<br /> 23 1-Dec-36 $4,780.70 $ 3,923.74 $ 856.96 $ 30,354.67
<br /> 24 1-Dec-37 $4,780.70 $ 4,021.83 $ 758.87 $ 26,332.84
<br /> 25 1-Dec-38 $4,780.70 $ 4,122.38 $ 658.32 $ 22,210.46
<br /> 26 1-Dec-39 $4,780.70 $ 4,225.44 $ 555.26 $ 17,985.02
<br /> 27 1-Dec-40 $4,780.70 $ 4,331.07 $ 449.63 $ 13,653.95
<br /> 28 1-Dec-41 $4,780.70 $ 4,439.35 $ 341.35 $ 9,214.60
<br /> 29 1-Dec-42 $4,780.70 $ 4,550.34 $ 230.36 $ 4,664.26
<br /> 30 1-Dec-43 $4,780.87 $ 4,664.26 $ 116.61 $ -
<br /> TOTALS $143,421.17 I $100,061.53 I $43,359.64 $0.00
<br /> Amort Union C150172 1113.xlsx SSB 11/21/2013
<br />
|