|
COLORADO WATER CONSERVATION BOARD
<br /> LOAN REPAYMENT SCHEDULE
<br /> Farmers'High Line Canal and
<br /> Borrower Final
<br /> Reservoir Company
<br /> Loan Contract Number C150314
<br /> Principal $2,209,597.00
<br /> Interest Rate 4.65%
<br /> Frequency Annual
<br /> Term(In Years) 30
<br /> First Payment Due May 1,2016
<br /> Payment Amount $138,054.23
<br /> Annual Annual
<br /> Loan Principal
<br /> Payment No. Payment Payment Principal Interest BALANCE
<br /> Due Date Amount
<br /> $ 2,209,597.00
<br /> Adjustment 1-May-15 $79,678.70 $ 79,678.70 $ - $ 2,129,918.30
<br /> 1 1-May-16 $138,054.23 $ 39,013.03 $ 99,041.20 $ 2,090,905.27
<br /> 2 1-May-17 $138,054.23 $ 40,827.13 $ 97,227.10 $ 2,050,078.14
<br /> 3 1-May-18 $138,054.23 $ 42,725.60 $ 95,328.63 $ 2,007,352.54
<br /> 4 1-May-19 $138,054.23 $ 44,712.34 $ 93,341.89 $ 1,962,640.20
<br /> 5 1-May-20 $138,054.23 $ 46,791.46 $ 91,262.77 $ 1,915,848.74
<br /> 6 1-May-21 $138,054.23 $ 48,967.26 $ 89,086.97 $ 1,866,881.48
<br /> 7 1-May-22 $138,054.23 $ 51,244.24 $ 86,809.99 $ 1,815,637.24
<br /> 8 1-May-23 $138,054.23 $ 53,627.10 $ 84,427.13 $ 1,762,010.14
<br /> 9 1-May-24 $138,054.23 $ 56,120.76 $ 81,933.47 $ 1,705,889.38
<br /> 10 1-May-25 $138,054.23 $ 58,730.37 $ 79,323.86 $ 1,647,159.01
<br /> 11 1-May-26 $138,054.23 $ 61,461.34 $ 76,592.89 $ 1,585,697.67
<br /> 12 1-May-27 $138,054.23 $ 64,319.29 $ 73,734.94 $ 1,521,378.38
<br /> 13 1-May-28 $138,054.23 $ 67,310.14 $ 70,744.09 $ 1,454,068.24
<br /> 14 1-May-29 $138,054.23 $ 70,440.06 $ 67,614.17 $ 1,383,628.18
<br /> 15 1-May-30 $138,054.23 $ 73,715.52 $ 64,338.71 $ 1,309,912.66
<br /> 16 1-May-31 $138,054.23 $ 77,143.29 $ 60,910.94 $ 1,232,769.37
<br /> 17 1-May-32 $138,054.23 $ 80,730.45 $ 57,323.78 $ 1,152,038.92
<br /> 18 1-May-33 $138,054.23 $ 84,484.42 $ 53,569.81 $ 1,067,554.50
<br /> 19 1-May-34 $138,054.23 $ 88,412.95 $ 49,641.28 $ 979,141.55
<br /> 20 1-May-35 $138,054.23 $ 92,524.15 $ 45,530.08 $ 886,617.40
<br /> 21 1-May-36 $138,054.23 $ 96,826.52 $ 41,227.71 $ 789,790.88
<br /> 22 1-May-37 $138,054.23 $ 101,328.95 $ 36,725.28 $ 688,461.93
<br /> 23 1-May-38 $138,054.23 $ 106,040.75 $ 32,013.48 $ 582,421.18
<br /> 24 1-May-39 $138,054.23 $ 110,971.65 $ 27,082.58 $ 471,449.53
<br /> 25 1-May-40 $138,054.23 $ 116,131.83 $ 21,922.40 $ 355,317.70
<br /> 26 1-May-41 $138,054.23 $ 121,531.96 $ 16,522.27 $ 233,785.74
<br /> 27 1-May-42 $138,054.23 $ 127,183.19 $ 10,871.04 $ 106,602.55
<br /> 28 1-May-43 $111,559.57 $ 106,602.55 $ 4,957.02 $ -
<br /> 29 1-May-44 $0.00 $ - $ - $ -
<br /> 30 1-May-45 $0.00 $ - $ - $ -
<br /> TOTALS $3,839,023.78 I $2,129,918.30 I $1,709,105.48 I $0.00
<br /> Amort Farmers High Line C150314 112410.xls SSB 4/29/2015
<br />
|