|
COLORADO WATER CONSERVATION BOARD
<br /> LOAN REPAYMENT SCHEDULE
<br /> Borrower Boulder and Left Hand FINAL
<br /> Irrigation Company
<br /> Loan Contract Number C150357
<br /> Principal $202,000.00
<br /> Interest Rate 2.35%
<br /> Frequency Annual
<br /> Term(In Years) 30
<br /> First Payment Due July 1,2015
<br /> Payment Amount $9,459.10
<br /> Loan Annual Annual
<br /> Payment Payment Payment Principal Interest Principal
<br /> No. Due Date Amount BALANCE
<br /> $ 202,000.00
<br /> 1 1-Jul-15 $9,459.10 $ 4,712.10 $ 4,747.00 $ 197,287.90
<br /> 2 1-Jul-16 $9,459.10 $ 4,822.83 $ 4,636.27 $ 192,465.07
<br /> 3 1-Jul-17 $9,459.10 $ 4,936.17 $ 4,522.93 $ 187,528.90
<br /> 4 1-Jul-18 $9,459.10 $ 5,052.17 $ 4,406.93 $ 182,476.73
<br /> 5 1-Jul-19 $9,459.10 $ 5,170.90 $ 4,288.20 $ 177,305.83
<br /> 6 1-Jul-20 $9,459.10 $ 5,292.41 $ 4,166.69 $ 172,013.42
<br /> 7 1-Jul-21 $9,459.10 $ 5,416.78 $ 4,042.32 $ 166,596.64
<br /> 8 1-Jul-22 $9,459.10 $ 5,544.08 $ 3,915.02 $ 161,052.56
<br /> 9 1-Jul-23 $9,459.10 $ 5,674.36 $ 3,784.74 $ 155,378.20
<br /> 10 1-Jul-24 $9,459.10 $ 5,807.71 $ 3,651.39 $ 149,570.49
<br /> 11 1-Jul-25 $9,459.10 $ 5,944.19 $ 3,514.91 $ 143,626.30
<br /> 12 1-Jul-26 $9,459.10 $ 6,083.88 $ 3,375.22 $ 137,542.42
<br /> 13 1-Jul-27 $9,459.10 $ 6,226.85 $ 3,232.25 $ 131,315.57
<br /> 14 1-Jul-28 $9,459.10 $ 6,373.18 $ 3,085.92 $ 124,942.39
<br /> 15 1-Jul-29 $9,459.10 $ 6,522.95 $ 2,936.15 $ 118,419.44
<br /> 16 1-Jul-30 $9,459.10 $ 6,676.24 $ 2,782.86 $ 111,743.20
<br /> 17 1-Jul-31 $9,459.10 $ 6,833.13 $ 2,625.97 $ 104,910.07
<br /> 18 1-Jul-32 $9,459.10 $ 6,993.71 $ 2,465.39 $ 97,916.36
<br /> 19 1-Jul-33 $9,459.10 $ 7,158.07 $ 2,301.03 $ 90,758.29
<br /> 20 1-Jul-34 $9,459.10 $ 7,326.28 $ 2,132.82 $ 83,432.01
<br /> 21 1-Jul-35 $9,459.10 $ 7,498.45 $ 1,960.65 $ 75,933.56
<br /> 22 1-Jul-36 $9,459.10 $ 7,674.66 $ 1,784.44 $ 68,258.90
<br /> 23 1-Jul-37 $9,459.10 $ 7,855.02 $ 1,604.08 $ 60,403.88
<br /> 24 1-Jul-38 $9,459.10 $ 8,039.61 $ 1,419.49 $ 52,364.27
<br /> 25 1-Jul-39 $9,459.10 $ 8,228.54 $ 1,230.56 $ 44,135.73
<br /> 26 1-Jul-40 $9,459.10 $ 8,421.91 $ 1,037.19 $ 35,713.82
<br /> 27 1-Jul-41 $9,459.10 $ 8,619.83 $ 839.27 $ 27,093.99
<br /> 28 1-Jul-42 $9,459.10 $ 8,822.39 $ 636.71 $ 18,271.60
<br /> 29 1-Jul-43 $9,459.10 $ 9,029.72 $ 429.38 $ 9,241.88
<br /> 30 1-Jul-44 $9,459.06 $ 9,241.88 $ 217.18 $ -
<br /> TOTALS $283,772.96 I $202,000.00 I $81,772.96 I $0.00
<br /> Amort Boulder Left C150357 0713.xlsx SSB 6/23/2014
<br />
|