|
COLORADO WATER CONSERVATION BOARD
<br /> LOAN REPAYMENT SCHEDULE
<br /> Borrower Twenty Two Road Lateral FINAL
<br /> Company
<br /> Loan Contract Number C150345
<br /> Principal $117,609.02
<br /> Interest Rate 2.35%
<br /> Frequency Annual
<br /> Term(In Years) 30
<br /> First Payment Due June 1,2015
<br /> Payment Amount $5,507.30
<br /> Loan Annual Annual
<br /> Payment Payment Payment Principal Interest Principal
<br /> No. Due Date Amount BALANCE
<br /> $ 117,609.02
<br /> 1 1-Jun-15 $5,507.30 $ 2,743.49 $ 2,763.81 $ 114,865.53
<br /> 2 1-Jun-16 $5,507.30 $ 2,807.96 $ 2,699.34 $ 112,057.57
<br /> 3 1-Jun-17 $5,507.30 $ 2,873.95 $ 2,633.35 $ 109,183.62
<br /> 4 1-Jun-18 $5,507.30 $ 2,941.48 $ 2,565.82 $ 106,242.14
<br /> 5 1-Jun-19 $5,507.30 $ 3,010.61 $ 2,496.69 $ 103,231.53
<br /> 6 1-Jun-20 $5,507.30 $ 3,081.36 $ 2,425.94 $ 100,150.17
<br /> 7 1-Jun-21 $5,507.30 $ 3,153.77 $ 2,353.53 $ 96,996.40
<br /> 8 1-Jun-22 $5,507.30 $ 3,227.88 $ 2,279.42 $ 93,768.52
<br /> 9 1-Jun-23 $5,507.30 $ 3,303.74 $ 2,203.56 $ 90,464.78
<br /> 10 1-Jun-24 $5,507.30 $ 3,381.38 $ 2,125.92 $ 87,083.40
<br /> 11 1-Jun-25 $5,507.30 $ 3,460.84 $ 2,046.46 $ 83,622.56
<br /> 12 1-Jun-26 $5,507.30 $ 3,542.17 $ 1,965.13 $ 80,080.39
<br /> 13 1-Jun-27 $5,507.30 $ 3,625.41 $ 1,881.89 $ 76,454.98
<br /> 14 1-Jun-28 $5,507.30 $ 3,710.61 $ 1,796.69 $ 72,744.37
<br /> 15 1-Jun-29 $5,507.30 $ 3,797.81 $ 1,709.49 $ 68,946.56
<br /> 16 1-Jun-30 $5,507.30 $ 3,887.06 $ 1,620.24 $ 65,059.50
<br /> 17 1-Jun-31 $5,507.30 $ 3,978.40 $ 1,528.90 $ 61,081.10
<br /> 18 1-Jun-32 $5,507.30 $ 4,071.89 $ 1,435.41 $ 57,009.21
<br /> 19 1-Jun-33 $5,507.30 $ 4,167.58 $ 1,339.72 $ 52,841.63
<br /> 20 1-Jun-34 $5,507.30 $ 4,265.52 $ 1,241.78 $ 48,576.11
<br /> 21 1-Jun-35 $5,507.30 $ 4,365.76 $ 1,141.54 $ 44,210.35
<br /> 22 1-Jun-36 $5,507.30 $ 4,468.36 $ 1,038.94 $ 39,741.99
<br /> 23 1-Jun-37 $5,507.30 $ 4,573.36 $ 933.94 $ 35,168.63
<br /> 24 1-Jun-38 $5,507.30 $ 4,680.84 $ 826.46 $ 30,487.79
<br /> 25 1-Jun-39 $5,507.30 $ 4,790.84 $ 716.46 $ 25,696.95
<br /> 26 1-Jun-40 $5,507.30 $ 4,903.42 $ 603.88 $ 20,793.53
<br /> 27 1-Jun-41 $5,507.30 $ 5,018.65 $ 488.65 $ 15,774.88
<br /> 28 1-Jun-42 $5,507.30 $ 5,136.59 $ 370.71 $ 10,638.29
<br /> 29 1-Jun-43 $5,507.30 $ 5,257.30 $ 250.00 $ 5,380.99
<br /> 30 1-Jun-44 $5,507.44 $ 5,380.99 $ 126.45 $ -
<br /> TOTALS $165,219.14 I $117,609.02 I $47,610.12 I $0.00
<br /> Amort Twenty Two C150345 0113.xlsx SSB 5/28/2014
<br />
|