|
COLORADO WATER CONSERVATION BOARD
<br /> LOAN REPAYMENT SCHEDULE
<br /> Borrower Town of Windsor FINAL
<br /> Loan Contract Number CT2015-057(C150366)
<br /> Principal $4,545,000.00
<br /> Interest Rate 2.75%
<br /> Frequency Annual
<br /> Term(in Years) 20
<br /> First Payment Due February 1,2018
<br /> Payment Amount $298,478.02
<br /> Loan Annual Annual Principal
<br /> Payment Payment Payment Principal Interest BALANCE
<br /> No. Due Date Amount
<br /> $ 4,545,000.00
<br /> 1 1-Feb-18 $298,478.02 $ 173,490.52 $ 124,987.50 $ 4,371,509.48
<br /> 2 1-Feb-19 $298,478.02 $ 178,261.51 $ 120,216.51 $ 4,193,247.97
<br /> 3 I-Feb-20 $298,478.02 $ 183,163.70 $ 115,314.32 $ 4,010,084.27
<br /> 4 i-Feb-21 $298,478.02 $ 188,200.70 $ 110,277.32 $ 3,821,883.57
<br /> 5 1-Feb-22 $298,478.02 $ 193,376.22 $ 105,101.80 $ 3,628,507.35
<br /> 6 1-Feb-23 $298,478.02 $ 198,694.07 $ 99,78395 $ 3,429,813 28
<br /> 7 I-Feb-24 $298,478.02 $ 204,158.15 $ 94,319.87 $ 3,225,655.13
<br /> 8 I-Feb-25 $298,478.02 $ 209,772.50 $ 88,705.52 $ 3,015,882.63
<br /> 9 I-Feb-26 $298,478.02 $ 215,541.25 $ 82,936.77 $ 2,800,341.38
<br /> 10 I-Feb-27 $298,478.02 $ 221,468.63 $ 77,009.39 $ 2,578,872.75
<br /> 11 I-Feb-28 $298,478.02 $ 227,559.02 $ 70,919.00 $ 2,351,313.73
<br /> 12 I-Feb-29 $298,478.02 $ 233,816.89 $ 64,661.13 $ 2,117,496.84
<br /> 13 I-Feb-30 $298,478.02 $ 240,246.86 $ 58,231.16 $ 1,877,249.98
<br /> 14 I-Feb-31 $298,478.02 $ 246,853.65 $ 51,624.37 $ 1,630,396.33
<br /> IS I-Feb-32 $298,478.02 $ 253,642.12 $ 44,835.90 $ 1,376,75421
<br /> 16 i-Feb-33 $298,478.02 $ 260,617.28 $ 37,860.74 $ 1,116,136.93
<br /> 17 I-Feb-34 $298,478.02 $ 267,78425 $ 30,693.77 $ 848,352.68
<br /> 18 I-Feb-35 $298,478.02 $ 275,148.32 $ 23,329.70 $ 573,204.36
<br /> 19 1-Feb-36 $298,478.02 $ 282,71490 $ 15,763.12 $ 290,489.46
<br /> 20 I-Feb-37 $298,477.92 $ 290,489.46 $ 7,988.46 $
<br /> --------------
<br /> TOTALS $5,969,560,30 $4,545,000.00 $1,424,560.30 $0.00
<br /> Amort Windsor 0150366 1013.xlsx SSB 3!912017
<br />
|