|
COLORADO WATER CONSERVATION BOARD
<br /> LOAN REPAYMENT SCHEDULE
<br /> Borrower City of Cortez ( Final
<br /> Loan Contract Number CT 2015-152
<br /> Principal $858,500.00
<br /> Interest Rate 2.10%
<br /> Frequency Annual
<br /> Term(In Years) 10
<br /> First Payment Due December 1,2017
<br /> Payment Amount $96,074.56
<br /> Loan Payment Annual Annual Principal
<br /> No. Payment Payment Principal Interest BALANCE
<br /> Due Date Amount
<br /> $ 858,500.00
<br /> Adjustment 1-Dec-16 $8,287.70 $ 8,287.70 $ - $ 850,212.30
<br /> 1 1-Dec-17 $96,074.56 $ 78,220.10 $ 17,854.46 $ 771,992.20
<br /> 2 1-Dec-18 $96,074.56 $ 79,862.72 $ 16,211.84 $ 692,129.48
<br /> 3 1-Dec-19 $96,074.56 $ 81,539.84 $ 14,534.72 $ 610,589.64
<br /> 4 1-Dec-20 $96,074.56 $ 83,252.18 $ 12,822.38 $ 527,337.46
<br /> 5 1-Dec-21 $96,074.56 $ 85,000.47 $ 11,074.09 $ 442,336.99
<br /> 6 1-Dec-22 $96,074.56 $ 86,785.48 $ 9,289.08 $ 355,551.51
<br /> 7 1-Dec-23 $96,074.56 $ 88,607.98 $ 7,466.58 $ 266,943.53
<br /> 8 1-Dec-24 $96,074.56 $ 90,468.75 $ 5,605.81 $ 176,474.78
<br /> 9 1-Dec-25 $96,074.56 $ 92,368.59 $ 3,705.97 $ 84,106.19
<br /> 10 1-Dec-26 $85,872.42 $ 84,106.19 $ 1,766.23 $ -
<br /> TOTALS I $958,831.16 $858,500.00 $100,331.16 $0.00
<br /> AmortCortezJan20150115.xlsx SSB 12/8/2016
<br />
|