|
COLORADO WATER CONSERVATION BOARD
<br /> LOAN REPAYMENT SCHEDULE
<br /> Borrower Town of Gypsum FINAL
<br /> Loan Contract Number CT2015-058(C150296)
<br /> Principal $2,689,731.00
<br /> Interest Rate 4.50%
<br /> Frequency Annual
<br /> Term(In Years) 30
<br /> First Payment Due January 1,2018
<br /> Payment Amount $165,126.74
<br /> Loan Annual Annual Principal
<br /> Payment Payment Payment Principal Interest BALANCE
<br /> No. Due Date Amount
<br /> $ 2,689,731.00
<br /> 1 1-Jan-18 $165,126.74 $ 44,088.84 $ 121,037.90 $ 2,645,642.16
<br /> 2 1-Jan-19 $165,126.74 $ 46,072.84 $ 119,053.90 $ 2,599,569.32
<br /> 3 1-Jan-20 $165,126.74 $ 48,146.12 $ 116,980.62 $ 2,551,423.20
<br /> 4 1-Jan-21 $165,126.74 $ 50,312.70 $ 114,814.04 $ 2,501,110.50
<br /> 5 1-Jan-22 $165,126.74 $ 52,576.77 $ 112,549.97 $ 2,448,533.73
<br /> 6 1-Jan-23 $165,126.74 $ 54,942.72 $ 110,184.02 $ 2,393,591.01
<br /> 7 1-Jan-24 $165,126.74 $ 57,415.14 $ 107,711.60 $ 2,336,175.87
<br /> 8 1-Jan-25 $165,126.74 $ 59,998.83 $ 105,127.91 $ 2,276,177.04
<br /> 9 1-Jan-26 $165,126.74 $ 62,698.77 $ 102,427.97 $ 2,213,478.27
<br /> 10 1-Jan-27 $165,126.74 $ 65,520.22 $ 99,606.52 $ 2,147,958.05
<br /> 11 1-Jan-28 $165,126.74 $ 68,468.63 $ 96,658.11 $ 2,079,489.42
<br /> 12 1-Jan-29 $165,126.74 $ 71,549.72 $ 93,577.02 $ 2,007,939.70
<br /> 13 1-Jan-30 $165,126.74 $ 74,769.45 $ 90,357.29 $ 1,933,170.25
<br /> 14 1-Jan-31 $165,126.74 $ 78,134.08 $ 86,992.66 $ 1,855,036.17
<br /> 15 1-Jan-32 $165,126.74 $ 81,650.11 $ 83,476.63 $ 1,773,386.06
<br /> 16 1-Jan-33 $165,126.74 $ 85,324.37 $ 79,802.37 $ 1,688,061.69
<br /> 17 1-Jan-34 $165,126.74 $ 89,163.96 $ 75,962.78 $ 1,598,897.73
<br /> 18 1-Jan-35 $165,126.74 $ 93,176.34 $ 71,950.40 $ 1,505,721.39
<br /> 19 1-Jan-36 $165,126.74 $ 97,369.28 $ 67,757.46 $ 1,408,352.11
<br /> 20 1-Jan-37 $165,126.74 $ 101,750.90 $ 63,375.84 $ 1,306,601.21
<br /> 21 1-Jan-38 $165,126.74 $ 106,329.69 $ 58,797.05 $ 1,200,271.52
<br /> 22 1-Jan-39 $165,126.74 $ 111,114.52 $ 54,012.22 $ 1,089,157.00
<br /> 23 1-Jan-40 $165,126.74 $ 116,114.67 $ 49,012.07 $ 973,042.33
<br /> 24 1-Jan-41 $165,126.74 $ 121,339.84 $ 43,786.90 $ 851,702.49
<br /> 25 1-Jan-42 $165,126.74 $ 126,800.13 $ 38,326.61 $ 724,902.36
<br /> 26 1-Jan-43 $165,126.74 $ 132,506.13 $ 32,620.61 $ 592,396.23
<br /> 27 1-Jan-44 $165,126.74 $ 138,468.91 $ 26,657.83 $ 453,927.32
<br /> 28 1-Jan-45 $165,126.74 $ 144,700.01 $ 20,426.73 $ 309,227.31
<br /> 29 1-Jan-46 $165,126.74 $ 151,211.51 $ 13,915.23 $ 158,015.80
<br /> 30 1-Jan-47 $165,126.51 $ 158,015.80 $ 7,110.71 $ -
<br /> TOTALS $4,953,801.97 $2,689,731.00 $2,264,070.97 $0.00
<br /> Amort Gypsum C150296 0509.xls SSB 12/22/2016
<br />
|