|
COLORADO WATER CONSERVATION BOARD
<br /> LOAN REPAYMENT SCHEDULE
<br /> Borrower Ephraim Ditch Company Final
<br /> Loan Contract Number CT2015-090(C150402)
<br /> Principal $101,000.00
<br /> Interest Rate 1.75%
<br /> Frequency Annual
<br /> Term(In Years) 30
<br /> First Payment Due November 1,2017
<br /> Payment Amount $4,356.11
<br /> Loan Annual Annual
<br /> Payment Payment Payment Principal Interest Principal
<br /> No. Due Date Amount BALANCE
<br /> $ 101,000.00
<br /> 1 1-Nov-17 $4,356.11 $ 2,588.61 $ 1,767.50 $ 98,411.39
<br /> 2 1-Nov-18 $4,356.11 $ 2,633.91 $ 1,722.20 $ 95,777.48
<br /> 3 1-Nov-19 $4,356.11 $ 2,680.00 $ 1,676.11 $ 93,097.48
<br /> 4 1-Nov-20 $4,356.11 $ 2,726.90 $ 1,629.21 $ 90,370.58
<br /> 5 1-Nov-21 $4,356.11 $ 2,774.62 $ 1,581.49 $ 87,595.96
<br /> 6 1-Nov-22 $4,356.11 $ 2,823.18 $ 1,532.93 $ 84,772.78
<br /> 7 1-Nov-23 $4,356.11 $ 2,872.59 $ 1,483.52 $ 81,900.19
<br /> 8 1-Nov-24 $4,356.11 $ 2,922.86 $ 1,433.25 $ 78,977.33
<br /> 9 1-Nov-25 $4,356.11 $ 2,974.01 $ 1,382.10 $ 76,003.32
<br /> 10 1-Nov-26 $4,356.11 $ 3,026.05 $ 1,330.06 $ 72,977.27
<br /> 11 1-Nov-27 $4,356.11 $ 3,079.01 $ 1,277.10 $ 69,898.26
<br /> 12 1-Nov-28 $4,356.11 $ 3,132.89 $ 1,223.22 $ 66,765.37
<br /> 13 1-Nov-29 $4,356.11 $ 3,187.72 $ 1,168.39 $ 63,577.65
<br /> 14 1-Nov-30 $4,356.11 $ 3,243.50 $ 1,112.61 $ 60,334.15
<br /> 15 1-Nov-31 $4,356.11 $ 3,300.26 $ 1,055.85 $ 57,033.89
<br /> 16 1-Nov-32 $4,356.11 $ 3,358.02 $ 998.09 $ 53,675.87
<br /> 17 1-Nov-33 $4,356.11 $ 3,416.78 $ 939.33 $ 50,259.09
<br /> 18 1-Nov-34 $4,356.11 $ 3,476.58 $ 879.53 $ 46,782.51
<br /> 19 1-Nov-35 $4,356.11 $ 3,537.42 $ 818.69 $ 43,245.09
<br /> 20 1-Nov-36 $4,356.11 $ 3,599.32 $ 756.79 $ 39,645.77
<br /> 21 1-Nov-37 $4,356.11 $ 3,662.31 $ 693.80 $ 35,983.46
<br /> 22 1-Nov-38 $4,356.11 $ 3,726.40 $ 629.71 $ 32,257.06
<br /> 23 1-Nov-39 $4,356.11 $ 3,791.61 $ 564.50 $ 28,465.45
<br /> 24 1-Nov-40 $4,356.11 $ 3,857.96 $ 498.15 $ 24,607.49
<br /> 25 1-Nov-41 $4,356.11 $ 3,925.48 $ 430.63 $ 20,682.01
<br /> 26 1-Nov-42 $4,356.11 $ 3,994.17 $ 361.94 $ 16,687.84
<br /> 27 1-Nov-43 $4,356.11 $ 4,064.07 $ 292.04 $ 12,623.77
<br /> 28 1-Nov-44 $4,356.11 $ 4,135.19 $ 220.92 $ 8,488.58
<br /> 29 1-Nov-45 $4,356.11 $ 4,207.56 $ 148.55 $ 4,281.02
<br /> 30 1-Nov-46 $4,355.94 $ 4,281.02 $ 74.92 $ -
<br /> TOTALS $130,683.13 $101,000.00 $29,683.13 $0.00
<br /> AmortEphraimDitchCo0714.xlsx SSB 1/30/2017
<br />
|