|
COLORADO WATER CONSERVATION BOARD
<br /> LOAN REPAYMENT SCHEDULE
<br /> Borrower Union Well Augmentation Coup Final
<br /> Loan Contract Number CT 2017-913
<br /> Principal $248,157.00
<br /> Interest Rate 1.45%
<br /> Frequency Annual
<br /> Term(In Years) 20
<br /> First Payment Due November 1,2017
<br /> Payment Amount $14,382.94
<br /> Loan Annual Annual Principal
<br /> Payment No. Payment Payment Principal Interest BALANCE
<br /> Due Date Amount
<br /> $ 248,157.00
<br /> Adjustment 1-Nov-16 $20,907.00 $ 20,907.00 $ - $ 227,250.00
<br /> 1 1-Nov-17 $14,382.94 $ 11,087.81 $ 3,295.13 $ 216,162.19
<br /> 2 1-Nov-18 $14,382.94 $ 11,248.59 $ 3,134.35 $ 204,913.60
<br /> 3 1-Nov-19 $14,382.94 $ 11,411.69 $ 2,971.25 $ 193,501.91
<br /> 4 1-Nov-20 $14,382.94 $ 11,577.16 $ 2,805.78 $ 181,924.75
<br /> 5 1-Nov-21 $14,382.94 $ 11,745.03 $ 2,637.91 $ 170,179.72
<br /> 6 1-Nov-22 $14,382.94 $ 11,915.33 $ 2,467.61 $ 158,264.39
<br /> 7 1-Nov-23 $14,382.94 $ 12,088.11 $ 2,294.83 $ 146,176.28
<br /> 8 1-Nov-24 $14,382.94 $ 12,263.38 $ 2,119.56 $ 133,912.90
<br /> 9 1-Nov-25 $14,382.94 $ 12,441.20 $ 1,941.74 $ 121,471.70
<br /> 10 1-Nov-26 $14,382.94 $ 12,621.60 $ 1,761.34 $ 108,850.10
<br /> 11 1-Nov-27 $14,382.94 $ 12,804.61 $ 1,578.33 $ 96,045.49
<br /> 12 1-Nov-28 $14,382.94 $ 12,990.28 $ 1,392.66 $ 83,055.21
<br /> 13 1-Nov-29 $14,382.94 $ 13,178.64 $ 1,204.30 $ 69,876.57
<br /> 14 1-Nov-30 $14,382.94 $ 13,369.73 $ 1,013.21 $ 56,506.84
<br /> 15 1-Nov-31 $14,382.94 $ 13,563.59 $ 819.35 $ 42,943.25
<br /> 16 1-Nov-32 $14,382.94 $ 13,760.26 $ 622.68 $ 29,182.99
<br /> 17 1-Nov-33 $14,382.94 $ 13,959.79 $ 423.15 $ 15,223.20
<br /> 18 1-Nov-34 $14,382.94 $ 14,162.20 $ 220.74 $ 1,061.00
<br /> 19 1-Nov-35 $1,076.38 $ 1,061.00 $ 15.38 $ -
<br /> 20 1-Nov-36 $0.00 $ - $ - $ -
<br /> TOTALS $280,876.30 $248,157.00 $32,719.30 $0.00
<br /> AmortUnionWellAugCT20160516.xlsx SSB 10/25/2016
<br />
|