|
COLORADO WATER CONSERVATION BOARD
<br /> LOAN REPAYMENT SCHEDULE
<br /> Borrower The Left Hand Ditch Company Final
<br /> Loan Contract Number CT2015-088 (C150336)
<br /> Principal $1,475,307.00 $1,332,562.39
<br /> Interest Rate 2.45% 2.45%
<br /> Frequency Annual Annual
<br /> Term(In Years) 30 26
<br /> First Payment Due June 1,2017
<br /> Payment Amount $70,017.61 $70,017.61
<br /> Annual Annual
<br /> Loan Principal
<br /> Payment No. Payment Payment Principal Interest BALANCE
<br /> Due Date Amount
<br /> $ 1,475,307.00
<br /> Adjustment 1-Jun-16 $142,744.61 $ 142,744.61 $ - $ 1,332,562.39
<br /> 1 1-Jun-17 $70,017.61 $ 37,369.83 $ 32,647.78 $ 1,295,192.56
<br /> 2 1-Jun-18 $70,017.61 $ 38,285.39 $ 31,732.22 $ 1,256,907.17
<br /> 3 1-Jun-19 $70,017.61 $ 39,223.38 $ 30,794.23 $ 1,217,683.79
<br /> 4 1-Jun-20 $70,017.61 $ 40,184.36 $ 29,833.25 $ 1,177,499.43
<br /> 5 1-Jun-21 $70,017.61 $ 41,168.87 $ 28,848.74 $ 1,136,330.56
<br /> 6 1-Jun-22 $70,017.61 $ 42,177.51 $ 27,840.10 $ 1,094,153.05
<br /> 7 1-Jun-23 $70,017.61 $ 43,210.86 $ 26,806.75 $ 1,050,942.19
<br /> 8 1-Jun-24 $70,017.61 $ 44,269.53 $ 25,748.08 $ 1,006,672.66
<br /> 9 1-Jun-25 $70,017.61 $ 45,354.13 $ 24,663.48 $ 961,318.53
<br /> 10 1-Jun-26 $70,017.61 $ 46,465.31 $ 23,552.30 $ 914,853.22
<br /> 11 1-Jun-27 $70,017.61 $ 47,603.71 $ 22,413.90 $ 867,249.51
<br /> 12 1-Jun-28 $70,017.61 $ 48,770.00 $ 21,247.61 $ 818,479.51
<br /> 13 1-Jun-29 $70,017.61 $ 49,964.86 $ 20,052.75 $ 768,514.65
<br /> 14 1-Jun-30 $70,017.61 $ 51,189.00 $ 18,828.61 $ 717,325.65
<br /> 15 1-Jun-31 $70,017.61 $ 52,443.13 $ 17,574.48 $ 664,882.52
<br /> 16 1-Jun-32 $70,017.61 $ 53,727.99 $ 16,289.62 $ 611,154.53
<br /> 17 1-Jun-33 $70,017.61 $ 55,044.32 $ 14,973.29 $ 556,110.21
<br /> 18 1-Jun-34 $70,017.61 $ 56,392.91 $ 13,624.70 $ 499,717.30
<br /> 19 1-Jun-35 $70,017.61 $ 57,774.54 $ 12,243.07 $ 441,942.76
<br /> 20 1-Jun-36 $70,017.61 $ 59,190.01 $ 10,827.60 $ 382,752.75
<br /> 21 1-Jun-37 $70,017.61 $ 60,640.17 $ 9,377.44 $ 322,112.58
<br /> 22 1-Jun-38 $70,017.61 $ 62,125.85 $ 7,891.76 $ 259,986.73
<br /> 23 1-Jun-39 $70,017.61 $ 63,647.94 $ 6,369.67 $ 196,338.79
<br /> 24 1-Jun-40 $70,017.61 $ 65,207.31 $ 4,810.30 $ 131,131.48
<br /> 25 1-Jun-41 $70,017.61 $ 66,804.89 $ 3,212.72 $ 64,326.59
<br /> 26 1-Jun-42 $65,902.59 $ 64,326.59 $ 1,576.00 $ -
<br /> 27 1-Jun-43 $0.00 $ - $ - $ -
<br /> 28 1-Jun-44 $0.00 $ - $ - $ -
<br /> 29 1-Jun-45 $0.00 $ - $ - $ -
<br /> 30 1-Jun-46 $0.00 $ - $ - $ -
<br /> TOTALS $1,959,087.45 $1,475,307.00 $483,780.45 $0.00
<br /> Amort Left Hand C150336 0712.xlsx SSB 5/5/2016
<br />
|