|
COLORADO WATER CONSERVATION BOARD
<br /> LOAN REPAYMENT SCHEDULE
<br /> Borrower Owl Creek Reservoir Company
<br /> Loan Contract Number C150089 (CT2015-048)
<br /> Principal $485,000.00
<br /> Interest Rate 2.75%
<br /> Frequency Annual
<br /> Term (In Years) 22
<br /> First Payment Due May 1,2017
<br /> Payment Amount $30,000.00
<br /> Loan Annual
<br /> Annual Payment Principal
<br /> Payment Payment Due Principal Interest
<br /> No. Date Amount BALANCE
<br /> $ 485,000.00
<br /> 1 1-May-17 $30,000.00 $ 16,662.50 $ 13,337.50 $ 468,337.50
<br /> 2 1-May-18 $30,000.00 $ 17,120.72 $ 12,879.28 $ 451,216.78
<br /> 3 1-May-19 $30,000.00 $ 17,591.54 $ 12,408.46 $ 433,625.24
<br /> 4 1-May-20 $30,000.00 $ 18,075.31 $ 11,924.69 $ 415,549.93
<br /> 5 1-May-21 $30,000.00 $ 18,572.38 $ 11,427.62 $ 396,977.55
<br /> 6 1-May-22 $30,000.00 $ 19,083.12 $ 10,916.88 $ 377,894.43
<br /> 7 1-May-23 $30,000.00 $ 19,607.90 $ 10,392.10 $ 358,286.53
<br /> 8 1-May-24 $30,000.00 $ 20,147.12 $ 9,852.88 $ 338,139.41
<br /> 9 1-May-25 $30,000.00 $ 20,701.17 $ 9,298.83 $ 317,438.24
<br /> 10 1-May-26 $30,000.00 $ 21,270.45 $ 8,729.55 $ 296,167.79
<br /> 11 1-May-27 $30,000.00 $ 21,855.39 $ 8,144.61 $ 274,312.40
<br /> 12 1-May-28 $30,000.00 $ 22,456.41 $ 7,543.59 $ 251,855.99
<br /> 13 1-May-29 $30,000.00 $ 23,073.96 $ 6,926.04 $ 228,782.03
<br /> 14 1-May-30 $30,000.00 $ 23,708.49 $ 6,291.51 $ 205,073.54
<br /> 15 1-May-31 $30,000.00 $ 24,360.48 $ 5,639.52 $ 180,713.06
<br /> 16 1-May-32 $30,000.00 $ 25,030.39 $ 4,969.61 $ 155,682.67
<br /> 17 1-May-33 $30,000.00 $ 25,718.73 $ 4,281.27 $ 129,963.94
<br /> 18 1-May-34 $30,000.00 $ 26,425.99 $ 3,574.01 $ 103,537.95
<br /> 19 1-May-35 $30,000.00 $ 27,152.71 $ 2,847.29 $ 76,385.24
<br /> 20 1-May-36 $30,000.00 $ 27,899.41 $ 2,100.59 $ 48,485.83
<br /> 21 1-May-37 $30,000.00 $ 28,666.64 $ 1,333.36 $ 19,819.19
<br /> 22 1-May-38 $20,364.22 $ 19,819.19 $ 545.03 $ -
<br /> TOTALS 1 $650,364.22 $485,000.00 $165,364.22 $0.00
<br /> Amort Owl Creek C150089.xls SSB 4/18/2016
<br />
|