|
COLORADO WATER CONSERVATION BOARD
<br /> EMERGENCY LOAN REPAYMENT SCHEDULE
<br /> Borrower Consolidated Home Supply Ditch Final
<br /> and Reservoir Company
<br /> Loan Contract Number CT2015-020(C150380)
<br /> Principal $519,140.00 $434,411.61
<br /> Interest Rate 1.95% 1.95%
<br /> Frequency Annual Annual
<br /> Payment Initiation Date January 1,2014 January 1,2014
<br /> Term(In Years) 30 27
<br /> First Payment Due January 1,2018
<br /> Payment Amount $24,913.79 $20,847.63
<br /> Loan Annual Annual Principal
<br /> Payment Payment Payment Principal Interest BALANCE
<br /> No. Due Date Amount
<br /> $ 434,411.61
<br /> 1 1-Jan-15 $0.00 $ - $ - $ 434,411.61
<br /> 2 1-Jan-16 $0.00 $ - $ - $ 434,411.61
<br /> 3 1-Jan-17 $0.00 $ - $ - $ 434,411.61
<br /> 4 1-Jan-18 $20,847.63 $ 12,376.60 $ 8,471.03 $ 422,035.01
<br /> 5 1-Jan-19 $20,847.63 $ 12,617.95 $ 8,229.68 $ 409,417.06
<br /> 6 1-Jan-20 $20,847.63 $ 12,864.00 $ 7,983.63 $ 396,553.06
<br /> 7 1-Jan-21 $20,847.63 $ 13,114.85 $ 7,732.78 $ 383,438.21
<br /> 8 1-Jan-22 $20,847.63 $ 13,370.58 $ 7,477.05 $ 370,067.63
<br /> 9 1-Jan-23 $20,847.63 $ 13,631.31 $ 7,216.32 $ 356,436.32
<br /> 10 1-Jan-24 $20,847.63 $ 13,897.12 $ 6,950.51 $ 342,539.20
<br /> 11 1-Jan-25 $20,847.63 $ 14,168.12 $ 6,679.51 $ 328,371.08
<br /> 12 1-Jan-26 $20,847.63 $ 14,444.39 $ 6,403.24 $ 313,926.69
<br /> 13 1-Jan-27 $20,847.63 $ 14,726.06 $ 6,121.57 $ 299,200.63
<br /> 14 1-Jan-28 $20,847.63 $ 15,013.22 $ 5,834.41 $ 284,187.41
<br /> 15 1-Jan-29 $20,847.63 $ 15,305.98 $ 5,541.65 $ 268,881.43
<br /> 16 1-Jan-30 $20,847.63 $ 15,604.44 $ 5,243.19 $ 253,276.99
<br /> 17 1-Jan-31 $20,847.63 $ 15,908.73 $ 4,938.90 $ 237,368.26
<br /> 18 1-Jan-32 $20,847.63 $ 16,218.95 $ 4,628.68 $ 221,149.31
<br /> 19 1-Jan-33 $20,847.63 $ 16,535.22 $ 4,312.41 $ 204,614.09
<br /> 20 1-Jan-34 $20,847.63 $ 16,857.66 $ 3,989.97 $ 187,756.43
<br /> 21 1-Jan-35 $20,847.63 $ 17,186.38 $ 3,661.25 $ 170,570.05
<br /> 22 1-Jan-36 $20,847.63 $ 17,521.51 $ 3,326.12 $ 153,048.54
<br /> 23 1-Jan-37 $20,847.63 $ 17,863.18 $ 2,984.45 $ 135,185.36
<br /> 24 1-Jan-38 $20,847.63 $ 18,211.52 $ 2,636.11 $ 116,973.84
<br /> 25 1-Jan-39 $20,847.63 $ 18,566.64 $ 2,280.99 $ 98,407.20
<br /> 26 1-Jan-40 $20,847.63 $ 18,928.69 $ 1,918.94 $ 79,478.51
<br /> 27 1-Jan-41 $20,847.63 $ 19,297.80 $ 1,549.83 $ 60,180.71
<br /> 28 1-Jan-42 $20,847.63 $ 19,674.11 $ 1,173.52 $ 40,506.60
<br /> 29 1-Jan-43 $20,847.63 $ 20,057.75 $ 789.88 $ 20,448.85
<br /> 30 1-Jan-44 $20,847.60 $ 20,448.85 $ 398.75 $ -
<br /> TOTALS $562,885.98 $434,411.61 $128,474.37 $0.00
<br /> Amort Con Home Supply C150380 1113.xlsx SSB 12/29/2016
<br />
|