|
COLORADO WATER CONSERVATION BOARD
<br /> LOAN REPAYMENT SCHEDULE
<br /> Cottonwood Water and
<br /> Borrower FINAL
<br /> Sanitation District
<br /> Loan Contract Number C150408A
<br /> Principal $381,780.00
<br /> Interest Rate 3.00%
<br /> Frequency Annual
<br /> Term(In Years) 30
<br /> First Payment Due January 1,2018
<br /> Payment Amount $19,478.13
<br /> Loan Annual Annual Principal
<br /> Payment No. Payment Payment Principal Interest BALANCE
<br /> Due Date Amount
<br /> $ 381,780.00
<br /> Adjustment 1-Jan-17 $38,858.95 $ 38,858.95 $ - $ 342,921.05
<br /> 1 1-Jan-18 $19,478.13 $ 9,190.50 $ 10,287.63 $ 333,730.55
<br /> 2 1-Jan-19 $19,478.13 $ 9,466.21 $ 10,011.92 $ 324,264.34
<br /> 3 1-Jan-20 $19,478.13 $ 9,750.20 $ 9,727.93 $ 314,514.14
<br /> 4 1-Jan-21 $19,478.13 $ 10,042.71 $ 9,435.42 $ 304,471.43
<br /> 5 1-Jan-22 $19,478.13 $ 10,343.99 $ 9,134.14 $ 294,127.44
<br /> 6 1-Jan-23 $19,478.13 $ 10,654.31 $ 8,823.82 $ 283,473.13
<br /> 7 1-Jan-24 $19,478.13 $ 10,973.94 $ 8,504.19 $ 272,499.19
<br /> 8 1-Jan-25 $19,478.13 $ 11,303.15 $ 8,174.98 $ 261,196.04
<br /> 9 1-Jan-26 $19,478.13 $ 11,642.25 $ 7,835.88 $ 249,553.79
<br /> 10 1-Jan-27 $19,478.13 $ 11,991.52 $ 7,486.61 $ 237,562.27
<br /> 11 1-Jan-28 $19,478.13 $ 12,351.26 $ 7,126.87 $ 225,211.01
<br /> 12 1-Jan-29 $19,478.13 $ 12,721.80 $ 6,756.33 $ 212,489.21
<br /> 13 1-Jan-30 $19,478.13 $ 13,103.45 $ 6,374.68 $ 199,385.76
<br /> 14 1-Jan-31 $19,478.13 $ 13,496.56 $ 5,981.57 $ 185,889.20
<br /> 15 1-Jan-32 $19,478.13 $ 13,901.45 $ 5,576.68 $ 171,987.75
<br /> 16 1-Jan-33 $19,478.13 $ 14,318.50 $ 5,159.63 $ 157,669.25
<br /> 17 1-Jan-34 $19,478.13 $ 14,748.05 $ 4,730.08 $ 142,921.20
<br /> 18 1-Jan-35 $19,478.13 $ 15,190.49 $ 4,287.64 $ 127,730.71
<br /> 19 1-Jan-36 $19,478.13 $ 15,646.21 $ 3,831.92 $ 112,084.50
<br /> 20 1-Jan-37 $19,478.13 $ 16,115.59 $ 3,362.54 $ 95,968.91
<br /> 21 1-Jan-38 $19,478.13 $ 16,599.06 $ 2,879.07 $ 79,369.85
<br /> 22 1-Jan-39 $19,478.13 $ 17,097.03 $ 2,381.10 $ 62,272.82
<br /> 23 1-Jan-40 $19,478.13 $ 17,609.95 $ 1,868.18 $ 44,662.87
<br /> 24 1-Jan-41 $19,478.13 $ 18,138.24 $ 1,339.89 $ 26,524.63
<br /> 25 1-Jan-42 $19,478.13 $ 18,682.39 $ 795.74 $ 7,842.24
<br /> 26 1-Jan-43 $8,077.51 $ 7,842.24 $ 235.27 $ -
<br /> 27 1-Jan-44 $0.00 $ - $ - $ -
<br /> 28 1-Jan-45 $0.00 $ - $ - $ -
<br /> 29 1-Jan-46 $0.00 $ - $ - $ -
<br /> 30 1-Jan-47 $0.00 $ - $ - $ -
<br /> TOTALS $533,889.71 $381,780.00 $152,109.71 $0.00
<br /> AmortCottonwoodC 1 504080614.xlsx SSB 12/16/2016
<br />
|