|
COLORADO WATER CONSERVATION BOARD
<br /> EMERGENCY LOAN REPAYMENT SCHEDULE
<br /> Borrower Butte Irrigating and Milling PRELIMINARY
<br /> Company
<br /> Loan Contract Number C150382
<br /> Principal $277,750.00
<br /> Interest Rate 2.30%
<br /> Frequency Annual
<br /> Payment Initiation Date May 1,2014
<br /> Term(In Years) 30
<br /> First Payment Due May 1,2018
<br /> Payment Amount $13,923.83 Based on 27 Years
<br /> Loan Annual Annual Principal
<br /> Payment Payment Payment Principal Interest BALANCE
<br /> No. Due Date Amount
<br /> $ 277,750.00
<br /> 1 1-May-15 $0.00 $ - $ - $ 277,750.00
<br /> 2 1-May-16 $0.00 $ - $ - $ 277,750.00
<br /> 3 1-May-17 $0.00 $ - $ - $ 277,750.00
<br /> 4 1-May-18 $13,923.83 $ 7,535.58 $ 6,388.25 $ 270,214.42
<br /> 5 1-May-19 $13,923.83 $ 7,708.90 $ 6,214.93 $ 262,505.52
<br /> 6 1-May-20 $13,923.83 $ 7,886.20 $ 6,037.63 $ 254,619.32
<br /> 7 1-May-21 $13,923.83 $ 8,067.59 $ 5,856.24 $ 246,551.73
<br /> 8 1-May-22 $13,923.83 $ 8,253.14 $ 5,670.69 $ 238,298.59
<br /> 9 1-May-23 $13,923.83 $ 8,442.96 $ 5,480.87 $ 229,855.63
<br /> 10 1-May-24 $13,923.83 $ 8,637.15 $ 5,286.68 $ 221,218.48
<br /> 11 1-May-25 $13,923.83 $ 8,835.80 $ 5,088.03 $ 212,382.68
<br /> 12 1-May-26 $13,923.83 $ 9,039.03 $ 4,884.80 $ 203,343.65
<br /> 13 1-May-27 $13,923.83 $ 9,246.93 $ 4,676.90 $ 194,096.72
<br /> 14 1-May-28 $13,923.83 $ 9,459.61 $ 4,464.22 $ 184,637.11
<br /> 15 1-May-29 $13,923.83 $ 9,677.18 $ 4,246.65 $ 174,959.93
<br /> 16 1-May-30 $13,923.83 $ 9,899.75 $ 4,024.08 $ 165,060.18
<br /> 17 1-May-31 $13,923.83 $ 10,127.45 $ 3,796.38 $ 154,932.73
<br /> 18 1-May-32 $13,923.83 $ 10,360.38 $ 3,563.45 $ 144,572.35
<br /> 19 1-May-33 $13,923.83 $ 10,598.67 $ 3,325.16 $ 133,973.68
<br /> 20 1-May-34 $13,923.83 $ 10,842.44 $ 3,081.39 $ 123,131.24
<br /> 21 1-May-35 $13,923.83 $ 11,091.81 $ 2,832.02 $ 112,039.43
<br /> 22 1-May-36 $13,923.83 $ 11,346.92 $ 2,576.91 $ 100,692.51
<br /> 23 1-May-37 $13,923.83 $ 11,607.90 $ 2,315.93 $ 89,084.61
<br /> 24 1-May-38 $13,923.83 $ 11,874.88 $ 2,048.95 $ 77,209.73
<br /> 25 1-May-39 $13,923.83 $ 12,148.01 $ 1,775.82 $ 65,061.72
<br /> 26 I-May-40 $13,923.83 $ 12,427.41 $ 1,496.42 $ 52,634.31
<br /> 27 1-May-41 $13,923.83 $ 12,713.24 $ 1,210.59 $ 39,921.07
<br /> 28 1-May-42 $13,923.83 $ 13,005.65 $ 918.18 $ 26,915.42
<br /> 29 1-May-43 $13,923.83 $ 13,304.78 $ 619.05 $ 13,610.64
<br /> 30 1-May-44 $13,923.68 $ 13,610.64 $ 313.04 $ -
<br /> TOTALS $375,943.26 $277,750.00 $98,193.26
<br /> Amort Butte Irrigating C150382 1113.xlsx SSB 5/16/2014
<br />
|