|
COLORADO WATER CONSERVATION BOARD
<br /> LOAN REPAYMENT SCHEDULE
<br /> Borrower Santa Maria Reservoir Company FINAL
<br /> Loan Contract Number C150365
<br /> Principal $3,677,663.00
<br /> Interest Rate 1.75%
<br /> Frequency Annual
<br /> Term(In Years) 30
<br /> First Payment Due November 1,2016
<br /> Payment Amount $158,616.70
<br /> Loan Annual Annual Principal
<br /> Payment Payment Payment Principal Interest
<br /> No. Due Date Amount BALANCE
<br /> $ 3,677,663.00
<br /> 1 1-Nov-16 $158,616.70 $ 94,257.60 $ 64,359.10 $ 3,583,405.40
<br /> 2 1-Nov-17 $158,616.70 $ 95,907.11 $ 62,709.59 $ 3,487,498.29
<br /> 3 1-Nov-18 $158,616.70 $ 97,585.48 $ 61,031.22 $ 3,389,912.81
<br /> 4 1-Nov-19 $158,616.70 $ 99,293.23 $ 59,323.47 $ 3,290,619.58
<br /> 5 1-Nov-20 $158,616.70 $ 101,030.86 $ 57,585.84 $ 3,189,588.72
<br /> 6 1-Nov-21 $158,616.70 $ 102,798.90 $ 55,817.80 $ 3,086,789.82
<br /> 7 1-Nov-22 $158,616.70 $ 104,597.88 $ 54,018.82 $ 2,982,191.94
<br /> 8 1-Nov-23 $158,616.70 $ 106,428.34 $ 52,188.36 $ 2,875,763.60
<br /> 9 1-Nov-24 $158,616.70 $ 108,290.84 $ 50,325.86 $ 2,767,472.76
<br /> 10 1-Nov-25 $158,616.70 $ 110,185.93 $ 48,430.77 $ 2,657,286.83
<br /> 11 1-Nov-26 $158,616.70 $ 112,114.18 $ 46,502.52 $ 2,545,172.65
<br /> 12 1-Nov-27 $158,616.70 $ 114,076.18 $ 44,540.52 $ 2,431,096.47
<br /> 13 1-Nov-28 $158,616.70 $ 116,072.51 $ 42,544.19 $ 2,315,023.96
<br /> 14 1-Nov-29 $158,616.70 $ 118,103.78 $ 40,512.92 $ 2,196,920.18
<br /> 15 1-Nov-30 $158,616.70 $ 120,170.60 $ 38,446.10 $ 2,076,749.58
<br /> 16 1-Nov-31 $158,616.70 $ 122,273.58 $ 36,343.12 $ 1,954,476.00
<br /> 17 1-Nov-32 $158,616.70 $ 124,413.37 $ 34,203.33 $ 1,830,062.63
<br /> 18 1-Nov-33 $158,616.70 $ 126,590.60 $ 32,026.10 $ 1,703,472.03
<br /> 19 1-Nov-34 $158,616.70 $ 128,805.94 $ 29,810.76 $ 1,574,666.09
<br /> 20 1-Nov-35 $158,616.70 $ 131,060.04 $ 27,556.66 $ 1,443,606.05
<br /> 21 1-Nov-36 $158,616.70 $ 133,353.59 $ 25,263.11 $ 1,310,252.46
<br /> 22 1-Nov-37 $158,616.70 $ 135,687.28 $ 22,929.42 $ 1,174,565.18
<br /> 23 1-Nov-38 $158,616.70 $ 138,061.81 $ 20,554.89 $ 1,036,503.37
<br /> 24 1-Nov-39 $158,616.70 $ 140,477.89 $ 18,138.81 $ 896,025.48
<br /> 25 1-Nov-40 $158,616.70 $ 142,936.25 $ 15,680.45 $ 753,089.23
<br /> 26 1-Nov-41 $158,616.70 $ 145,437.64 $ 13,179.06 $ 607,651.59
<br /> 27 1-Nov-42 $158,616.70 $ 147,982.80 $ 10,633.90 $ 459,668.79
<br /> 28 1-Nov-43 $158,616.70 $ 150,572.50 $ 8,044.20 $ 309,096.29
<br /> 29 1-Nov-44 $158,616.70 $ 153,207.51 $ 5,409.19 $ 155,888.78
<br /> 30 1-Nov-45 $158,616.83 $ 155,888.78 $ 2,728.05 $ -
<br /> TOTALS $4,758,501.13 I $3,677,663.00 I $1,080,838.13 I $0.00
<br /> Amort Santa Maria C150365 1013.xlsx SSB 10/20/2015
<br />
|