|
COLORADO WATER CONSERVATION BOARD
<br /> LOAN REPAYMENT SCHEDULE
<br /> Borrower Santa Maria Reservoir Company FINAL
<br /> Loan Contract Number C150350
<br /> Principal $1,405,163.00
<br /> Interest Rate 1.75%
<br /> Frequency Annual
<br /> Term(In Years) 30
<br /> First Payment Due November 1,2016
<br /> Payment Amount $60,604.34
<br /> Loan Annual Annual Principal
<br /> Payment Payment Payment Principal Interest
<br /> BALANCE
<br /> No. Due Date Amount 1
<br /> $ 1,405,163.00
<br /> 1 1-Nov-16 $60,604.34 $ 36,013.99 $ 24,590.35 $ 1,369,149.01
<br /> 2 1-Nov-17 $60,604.34 $ 36,644.23 $ 23,960.11 $ 1,332,504.78
<br /> 3 1-Nov-18 $60,604.34 $ 37,285.51 $ 23,318.83 $ 1,295,219.27
<br /> 4 1-Nov-19 $60,604.34 $ 37,938.00 $ 22,666.34 $ 1,257,281.27
<br /> 5 1-Nov-20 $60,604.34 $ 38,601.92 $ 22,002.42 $ 1,218,679.35
<br /> 6 1-Nov-21 $60,604.34 $ 39,277.45 $ 21,326.89 $ 1,179,401.90
<br /> 7 1-Nov-22 $60,604.34 $ 39,964.81 $ 20,639.53 $ 1,139,437.09
<br /> 8 1-Nov-23 $60,604.34 $ 40,664.19 $ 19,940.15 $ 1,098,772.90
<br /> 9 1-Nov-24 $60,604.34 $ 41,375.81 $ 19,228.53 $ 1,057,397.09
<br /> 10 1-Nov-25 $60,604.34 $ 42,099.89 $ 18,504.45 $ 1,015,297.20
<br /> 11 1-Nov-26 $60,604.34 $ 42,836.64 $ 17,767.70 $ 972,460.56
<br /> 12 1-Nov-27 $60,604.34 $ 43,586.28 $ 17,018.06 $ 928,874.28
<br /> 13 1-Nov-28 $60,604.34 $ 44,349.04 $ 16,255.30 $ 884,525.24
<br /> 14 1-Nov-29 $60,604.34 $ 45,125.15 $ 15,479.19 $ 839,400.09
<br /> 15 1-Nov-30 $60,604.34 $ 45,914.84 $ 14,689.50 $ 793,485.25
<br /> 16 1-Nov-31 $60,604.34 $ 46,718.35 $ 13,885.99 $ 746,766.90
<br /> 17 1-Nov-32 $60,604.34 $ 47,535.92 $ 13,068.42 $ 699,230.98
<br /> 18 1-Nov-33 $60,604.34 $ 48,367.80 $ 12,236.54 $ 650,863.18
<br /> 19 1-Nov-34 $60,604.34 $ 49,214.23 $ 11,390.11 $ 601,648.95
<br /> 20 1-Nov-35 $60,604.34 $ 50,075.48 $ 10,528.86 $ 551,573.47
<br /> 21 1-Nov-36 $60,604.34 $ 50,951.80 $ 9,652.54 $ 500,621.67
<br /> 22 1-Nov-37 $60,604.34 $ 51,843.46 $ 8,760.88 $ 448,778.21
<br /> 23 1-Nov-38 $60,604.34 $ 52,750.72 $ 7,853.62 $ 396,027.49
<br /> 24 1-Nov-39 $60,604.34 $ 53,673.86 $ 6,930.48 $ 342,353.63
<br /> 25 1-Nov-40 $60,604.34 $ 54,613.15 $ 5,991.19 $ 287,740.48
<br /> 26 1-Nov-41 $60,604.34 $ 55,568.88 $ 5,035.46 $ 232,171.60
<br /> 27 1-Nov-42 $60,604.34 $ 56,541.34 $ 4,063.00 $ 175,630.26
<br /> 28 1-Nov-43 $60,604.34 $ 57,530.81 $ 3,073.53 $ 118,099.45
<br /> 29 1-Nov-44 $60,604.34 $ 58,537.60 $ 2,066.74 $ 59,561.85
<br /> 30 1-Nov-45 $60,604.18 $ 59,561.85 $ 1,042.33 $ -
<br /> TOTALS $1,818,130.04 I $1,405,163.00 I $412,967.04 I $0.00
<br /> Amort Santa Maria C150350 0313.xlsx SSB 10/20/2015
<br />
|