|
COLORADO WATER CONSERVATION BOARD
<br /> EMERGENCY LOAN REPAYMENT SCHEDULE
<br /> Borrower Sylvan Dale Ranch FINAL
<br /> Loan Contract Number C150392
<br /> Principal $105,171.00
<br /> Interest Rate 1.75%
<br /> Frequency Annual
<br /> Payment Initiation Date June 1,2014
<br /> Term(In Years) 30
<br /> First Payment Due June 1,2018
<br /> Payment Amount $4,921.03 Based on 27 Years
<br /> Loan Annual Annual
<br /> Payment Payment Payment Principal Interest Principal
<br /> No. Due Date Amount BALANCE
<br /> $ 105,171.00
<br /> 1 1-Jun-15 $0.00 $ - $ - $ 105,171.00
<br /> 2 1-Jun-16 $0.00 $ - $ - $ 105,171.00
<br /> 3 1-Jun-17 $0.00 $ - $ - $ 105,171.00
<br /> 4 1-Jun-18 $4,921.03 $ 3,080.54 $ 1,840.49 $ 102,090.46
<br /> 5 1-Jun-19 $4,921.03 $ 3,134.45 $ 1,786.58 $ 98,956.01
<br /> 6 1-Jun-20 $4,921.03 $ 3,189.30 $ 1,731.73 $ 95,766.71
<br /> 7 1-Jun-21 $4,921.03 $ 3,245.11 $ 1,675.92 $ 92,521.60
<br /> 8 1-Jun-22 $4,921.03 $ 3,301.90 $ 1,619.13 $ 89,219.70
<br /> 9 1-Jun-23 $4,921.03 $ 3,359.69 $ 1,561.34 $ 85,860.01
<br /> 10 1-Jun-24 $4,921.03 $ 3,418.48 $ 1,502.55 $ 82,441.53
<br /> 11 1-Jun-25 $4,921.03 $ 3,478.30 $ 1,442.73 $ 78,963.23
<br /> 12 1-Jun-26 $4,921.03 $ 3,539.17 $ 1,381.86 $ 75,424.06
<br /> 13 1-Jun-27 $4,921.03 $ 3,601.11 $ 1,319.92 $ 71,822.95
<br /> 14 1-Jun-28 $4,921.03 $ 3,664.13 $ 1,256.90 $ 68,158.82
<br /> 15 1-Jun-29 $4,921.03 $ 3,728.25 $ 1,192.78 $ 64,430.57
<br /> 16 1-Jun-30 $4,921.03 $ 3,793.50 $ 1,127.53 $ 60,637.07
<br /> 17 1-Jun-31 $4,921.03 $ 3,859.88 $ 1,061.15 $ 56,777.19
<br /> 18 1-Jun-32 $4,921.03 $ 3,927.43 $ 993.60 $ 52,849.76
<br /> 19 1-Jun-33 $4,921.03 $ 3,996.16 $ 924.87 $ 48,853.60
<br /> 20 1-Jun-34 $4,921.03 $ 4,066.09 $ 854.94 $ 44,787.51
<br /> 21 1-Jun-35 $4,921.03 $ 4,137.25 $ 783.78 $ 40,650.26
<br /> 22 1-Jun-36 $4,921.03 $ 4,209.65 $ 711.38 $ 36,440.61
<br /> 23 1-Jun-37 $4,921.03 $ 4,283.32 $ 637.71 $ 32,157.29
<br /> 24 1-Jun-38 $4,921.03 $ 4,358.28 $ 562.75 $ 27,799.01
<br /> 25 1-Jun-39 $4,921.03 $ 4,434.55 $ 486.48 $ 23,364.46
<br /> 26 1-Jun-40 $4,921.03 $ 4,512.15 $ 408.88 $ 18,852.31
<br /> 27 1-Jun-41 $4,921.03 $ 4,591.11 $ 329.92 $ 14,261.20
<br /> 28 1-Jun-42 $4,921.03 $ 4,671.46 $ 249.57 $ 9,589.74
<br /> 29 1-Jun-43 $4,921.03 $ 4,753.21 $ 167.82 $ 4,836.53
<br /> 30 1-Jun-44 $4,921.17 $ 4,836.53 $ 84.64 $ -
<br /> TOTALS $132,867.95 I $105,171.00 I $27,696.95
<br /> Amort Sylvan Dale C150392 0114.xlsx SSB 6/2/2014
<br />
|