|
COLORADO WATER CONSERVATION BOARD
<br /> LOAN REPAYMENT SCHEDULE
<br /> Borrower City of Lamar FINAL
<br /> Loan Contract Number C150367 CT2015-007
<br /> Principal $616,993.65
<br /> Interest Rate 2.25%
<br /> Frequency Annual
<br /> Term(In Years) 30
<br /> First Payment Due October 1,2015
<br /> Payment Amount $28,504.70
<br /> Loan Annual Annual Principal
<br /> Payment Payment Payment Principal Interest BALANCE
<br /> No. Due Date Amount
<br /> $ 616,993.65
<br /> 1 1-Oct-15 $28,504.70 $ 14,622.34 $ 13,882.36 $ 602,371.31
<br /> 2 1-Oct-16 $28,504.70 $ 14,951.35 $ 13,553.35 $ 587,419.96
<br /> 3 1-Oct-17 $28,504.70 $ 15,287.75 $ 13,216.95 $ 572,132.21
<br /> 4 1-Oct-18 $28,504.70 $ 15,631.73 $ 12,872.97 $ 556,500.48
<br /> 5 1-Oct-19 $28,504.70 $ 15,983.44 $ 12,521.26 $ 540,517.04
<br /> 6 1-Oct-20 $28,504.70 $ 16,343.07 $ 12,161.63 $ 524,173.97
<br /> 7 1-Oct-21 $28,504.70 $ 16,710.79 $ 11,793.91 $ 507,463.18
<br /> 8 1-Oct-22 $28,504.70 $ 17,086.78 $ 11,417.92 $ 490,376.40
<br /> 9 1-Oct-23 $28,504.70 $ 17,471.23 $ 11,033.47 $ 472,905.17
<br /> 10 1-Oct-24 $28,504.70 $ 17,864.33 $ 10,640.37 $ 455,040.84
<br /> 11 1-Oct-25 $28,504.70 $ 18,266.28 $ 10,238.42 $ 436,774.56
<br /> 12 1-Oct-26 $28,504.70 $ 18,677.27 $ 9,827.43 $ 418,097.29
<br /> 13 1-Oct-27 $28,504.70 $ 19,097.51 $ 9,407.19 $ 398,999.78
<br /> 14 1-Oct-28 $28,504.70 $ 19,527.20 $ 8,977.50 $ 379,472.58
<br /> 15 1-Oct-29 $28,504.70 $ 19,966.57 $ 8,538.13 $ 359,506.01
<br /> 16 1-Oct-30 $28,504.70 $ 20,415.81 $ 8,088.89 $ 339,090.20
<br /> 17 1-Oct-31 $28,504.70 $ 20,875.17 $ 7,629.53 $ 318,215.03
<br /> 18 1-Oct-32 $28,504.70 $ 21,344.86 $ 7,159.84 $ 296,870.17
<br /> 19 1-Oct-33 $28,504.70 $ 21,825.12 $ 6,679.58 $ 275,045.05
<br /> 20 1-Oct-34 $28,504.70 $ 22,316.19 $ 6,188.51 $ 252,728.86
<br /> 21 1-Oct-35 $28,504.70 $ 22,818.30 $ 5,686.40 $ 229,910.56
<br /> 22 1-Oct-36 $28,504.70 $ 23,331.71 $ 5,172.99 $ 206,578.85
<br /> 23 1-Oct-37 $28,504.70 $ 23,856.68 $ 4,648.02 $ 182,722.17
<br /> 24 1-Oct-38 $28,504.70 $ 24,393.45 $ 4,111.25 $ 158,328.72
<br /> 25 1-Oct-39 $28,504.70 $ 24,942.30 $ 3,562.40 $ 133,386.42
<br /> 26 1-Oct-40 $28,504.70 $ 25,503.51 $ 3,001.19 $ 107,882.91
<br /> 27 1-Oct-41 $28,504.70 $ 26,077.33 $ 2,427.37 $ 81,805.58
<br /> 28 1-Oct-42 $28,504.70 $ 26,664.07 $ 1,840.63 $ 55,141.51
<br /> 29 1-Oct-43 $28,504.70 $ 27,264.02 $ 1,240.68 $ 27,877.49
<br /> 30 1-Oct-44 $28,504.73 $ 27,877.49 $ 627.24 $ -
<br /> TOTALS $855,141.03 I $616,993.65 I $238,147.38 I $0.00
<br /> Amort Lamar C150367 1013.xisx SSB 10/6/2014
<br />
|