|
COLORADO WATER CONSERVATION BOARD
<br /> LOAN REPAYMENT SCHEDULE
<br /> Borrower Lone Cabin Ditch and Reservoir FINAL
<br /> Company
<br /> Loan Contract Number C150361
<br /> Principal $123,447.55
<br /> Interest Rate 1.75%
<br /> Frequency Annual
<br /> Term(In Years) 30
<br /> First Payment Due February 1,2016
<br /> Payment Amount $5,324.26
<br /> Loan Annual Annual Principal
<br /> Payment Payment Payment Principal Interest BALANCE
<br /> No. Due Date Amount
<br /> $ 123,447.55
<br /> 1 1-Feb-16 $5,324.26 $ 3,163.93 $ 2,160.33 $ 120,283.62
<br /> 2 1-Feb-17 $5,324.26 $ 3,219.30 $ 2,104.96 $ 117,064.32
<br /> 3 1-Feb-18 $5,324.26 $ 3,275.63 $ 2,048.63 $ 113,788.69
<br /> 4 1-Feb-19 $5,324.26 $ 3,332.96 $ 1,991.30 $ 110,455.73
<br /> 5 1-Feb-20 $5,324.26 $ 3,391.28 $ 1,932.98 $ 107,064.45
<br /> 6 1-Feb-21 $5,324.26 $ 3,450.63 $ 1,873.63 $ 103,613.82
<br /> 7 1-Feb-22 $5,324.26 $ 3,511.02 $ 1,813.24 $ 100,102.80
<br /> 8 1-Feb-23 $5,324.26 $ 3,572.46 $ 1,751.80 $ 96,530.34
<br /> 9 1-Feb-24 $5,324.26 $ 3,634.98 $ 1,689.28 $ 92,895.36
<br /> 10 1-Feb-25 $5,324.26 $ 3,698.59 $ 1,625.67 $ 89,196.77
<br /> 11 1-Feb-26 $5,324.26 $ 3,763.32 $ 1,560.94 $ 85,433.45
<br /> 12 1-Feb-27 $5,324.26 $ 3,829.17 $ 1,495.09 $ 81,604.28
<br /> 13 1-Feb-28 $5,324.26 $ 3,896.19 $ 1,428.07 $ 77,708.09
<br /> 14 1-Feb-29 $5,324.26 $ 3,964.37 $ 1,359.89 $ 73,743.72
<br /> 15 1-Feb-30 $5,324.26 $ 4,033.74 $ 1,290.52 $ 69,709.98
<br /> 16 1-Feb-31 $5,324.26 $ 4,104.34 $ 1,219.92 $ 65,605.64
<br /> 17 1-Feb-32 $5,324.26 $ 4,176.16 $ 1,148.10 $ 61,429.48
<br /> 18 1-Feb-33 $5,324.26 $ 4,249.24 $ 1,075.02 $ 57,180.24
<br /> 19 1-Feb-34 $5,324.26 $ 4,323.61 $ 1,000.65 $ 52,856.63
<br /> 20 1-Feb-35 $5,324.26 $ 4,399.27 $ 924.99 $ 48,457.36
<br /> 21 1-Feb-36 $5,324.26 $ 4,476.26 $ 848.00 $ 43,981.10
<br /> 22 1-Feb-37 $5,324.26 $ 4,554.59 $ 769.67 $ 39,426.51
<br /> 23 1-Feb-38 $5,324.26 $ 4,634.30 $ 689.96 $ 34,792.21
<br /> 24 1-Feb-39 $5,324.26 $ 4,715.40 $ 608.86 $ 30,076.81
<br /> 25 1-Feb-40 $5,324.26 $ 4,797.92 $ 526.34 $ 25,278.89
<br /> 26 1-Feb-41 $5,324.26 $ 4,881.88 $ 442.38 $ 20,397.01
<br /> 27 1-Feb-42 $5,324.26 $ 4,967.31 $ 356.95 $ 15,429.70
<br /> 28 1-Feb-43 $5,324.26 $ 5,054.24 $ 270.02 $ 10,375.46
<br /> 29 1-Feb-44 $5,324.26 $ 5,142.69 $ 181.57 $ 5,232.77
<br /> 30 1-Feb-45 $5,324.34 $ 5,232.77 $ 91.57 $ -
<br /> TOTALS $159,727.88 I $123,447.55 I $36,280.33 I $0.00
<br /> Amort Lone Cabin C150361 1013.xlsx SSB 1/5/2015
<br />
|