|
COLORADO WATER CONSERVATION BOARD
<br /> LOAN REPAYMENT SCHEDULE
<br /> Borrower Lower Latham Reservoir FINAL
<br /> Company
<br /> Loan Contract Number C150304
<br /> Principal $2,417,359.17
<br /> Interest Rate 2.75%
<br /> Frequency Annual
<br /> Term(In Years) 30
<br /> First Payment Due June 1,2015
<br /> Payment Amount $119,379.88
<br /> Loan Annual Annual
<br /> Payment Payment Payment Principal Interest Principal
<br /> No. Due Date Amount BALANCE
<br /> $ 2,417,359.17
<br /> 1 1-Jun-15 $119,379.88 $ 52,902.50 $ 66,477.38 $ 2,364,456.67
<br /> 2 1-Jun-16 $119,379.88 $ 54,357.32 $ 65,022.56 $ 2,310,099.35
<br /> 3 1-Jun-17 $119,379.88 $ 55,852.15 $ 63,527.73 $ 2,254,247.20
<br /> 4 1-Jun-18 $119,379.88 $ 57,388.08 $ 61,991.80 $ 2,196,859.12
<br /> 5 1-Jun-19 $119,379.88 $ 58,966.25 $ 60,413.63 $ 2,137,892.87
<br /> 6 1-Jun-20 $119,379.88 $ 60,587.83 $ 58,792.05 $ 2,077,305.04
<br /> 7 1-Jun-21 $119,379.88 $ 62,253.99 $ 57,125.89 $ 2,015,051.05
<br /> 8 1-Jun-22 $119,379.88 $ 63,965.98 $ 55,413.90 $ 1,951,085.07
<br /> 9 1-Jun-23 $119,379.88 $ 65,725.04 $ 53,654.84 $ 1,885,360.03
<br /> 10 1-Jun-24 $119,379.88 $ 67,532.48 $ 51,847.40 $ 1,817,827.55
<br /> 11 1-Jun-25 $119,379.88 $ 69,389.62 $ 49,990.26 $ 1,748,437.93
<br /> 12 1-Jun-26 $119,379.88 $ 71,297.84 $ 48,082.04 $ 1,677,140.09
<br /> 13 1-Jun-27 $119,379.88 $ 73,258.53 $ 46,121.35 $ 1,603,881.56
<br /> 14 1-Jun-28 $119,379.88 $ 75,273.14 $ 44,106.74 $ 1,528,608.42
<br /> 15 1-Jun-29 $119,379.88 $ 77,343.15 $ 42,036.73 $ 1,451,265.27
<br /> 16 1-Jun-30 $119,379.88 $ 79,470.09 $ 39,909.79 $ 1,371,795.18
<br /> 17 1-Jun-31 $119,379.88 $ 81,655.51 $ 37,724.37 $ 1,290,139.67
<br /> 18 1-Jun-32 $119,379.88 $ 83,901.04 $ 35,478.84 $ 1,206,238.63
<br /> 19 1-Jun-33 $119,379.88 $ 86,208.32 $ 33,171.56 $ 1,120,030.31
<br /> 20 1-Jun-34 $119,379.88 $ 88,579.05 $ 30,800.83 $ 1,031,451.26
<br /> 21 1-Jun-35 $119,379.88 $ 91,014.97 $ 28,364.91 $ 940,436.29
<br /> 22 1-Jun-36 $119,379.88 $ 93,517.88 $ 25,862.00 $ 846,918.41
<br /> 23 1-Jun-37 $119,379.88 $ 96,089.62 $ 23,290.26 $ 750,828.79
<br /> 24 1-Jun-38 $119,379.88 $ 98,732.09 $ 20,647.79 $ 652,096.70
<br /> 25 1-Jun-39 $119,379.88 $ 101,447.22 $ 17,932.66 $ 550,649.48
<br /> 26 1-Jun-40 $119,379.88 $ 104,237.02 $ 15,142.86 $ 446,412.46
<br /> 27 1-Jun-41 $119,379.88 $ 107,103.54 $ 12,276.34 $ 339,308.92
<br /> 28 1-Jun-42 $119,379.88 $ 110,048.88 $ 9,331.00 $ 229,260.04
<br /> 29 1-Jun-43 $119,379.88 $ 113,075.23 $ 6,304.65 $ 116,184.81
<br /> 30 1-Jun-44 $119,379.89 $ 116,184.81 $ 3,195.08 $ -
<br /> TOTALS I $3,581,396.41 I $2,417,359.17 I $1,164,037.24 I $0.00
<br /> Amort Lower Latham C150304 0110.xls SSB 6/4/2014
<br />
|