|
COLORADO WATER CONSERVATION BOARD
<br /> LOAN REPAYMENT SCHEDULE
<br /> Borrower Platte Valley Irrigation FINAL
<br /> Company
<br /> Loan Contract Number CT 2015-139
<br /> Principal $745,380.00
<br /> Interest Rate 2.00%
<br /> Frequency Annual
<br /> Term(In Years) 30
<br /> First Payment Due May 1,2016
<br /> Payment Amount $33,281.16
<br /> Loan Annual Annual
<br /> Payment Payment Payment Principal Interest Principal
<br /> No. Due Date Amount BALANCE
<br /> $ 745,380.00
<br /> Adjustment 1-May-15 $6,913.75 $ 6,913.75 $ - $ 738,466.25
<br /> 1 1-May-16 $33,281.16 $ 18,511.83 $ 14,769.33 $ 719,954.42
<br /> 2 1-May-17 $33,281.16 $ 18,882.07 $ 14,399.09 $ 701,072.35
<br /> 3 1-May-18 $33,281.16 $ 19,259.71 $ 14,021.45 $ 681,812.64
<br /> 4 1-May-19 $33,281.16 $ 19,644.91 $ 13,636.25 $ 662,167.73
<br /> 5 1-May-20 $33,281.16 $ 20,037.81 $ 13,243.35 $ 642,129.92
<br /> 6 1-May-21 $33,281.16 $ 20,438.56 $ 12,842.60 $ 621,691.36
<br /> 7 1-May-22 $33,281.16 $ 20,847.33 $ 12,433.83 $ 600,844.03
<br /> 8 1-May-23 $33,281.16 $ 21,264.28 $ 12,016.88 $ 579,579.75
<br /> 9 1-May-24 $33,281.16 $ 21,689.56 $ 11,591.60 $ 557,890.19
<br /> 10 1-May-25 $33,281.16 $ 22,123.36 $ 11,157.80 $ 535,766.83
<br /> 11 1-May-26 $33,281.16 $ 22,565.82 $ 10,715.34 $ 513,201.01
<br /> 12 1-May-27 $33,281.16 $ 23,017.14 $ 10,264.02 $ 490,183.87
<br /> 13 1-May-28 $33,281.16 $ 23,477.48 $ 9,803.68 $ 466,706.39
<br /> 14 1-May-29 $33,281.16 $ 23,947.03 $ 9,334.13 $ 442,759.36
<br /> 15 1-May-30 $33,281.16 $ 24,425.97 $ 8,855.19 $ 418,333.39
<br /> 16 1-May-31 $33,281.16 $ 24,914.49 $ 8,366.67 $ 393,418.90
<br /> 17 1-May-32 $33,281.16 $ 25,412.78 $ 7,868.38 $ 368,006.12
<br /> 18 1-May-33 $33,281.16 $ 25,921.04 $ 7,360.12 $ 342,085.08
<br /> 19 1-May-34 $33,281.16 $ 26,439.46 $ 6,841.70 $ 315,645.62
<br /> 20 1-May-35 $33,281.16 $ 26,968.25 $ 6,312.91 $ 288,677.37
<br /> 21 1-May-36 $33,281.16 $ 27,507.61 $ 5,773.55 $ 261,169.76
<br /> 22 1-May-37 $33,281.16 $ 28,057.76 $ 5,223.40 $ 233,112.00
<br /> 23 1-May-38 $33,281.16 $ 28,618.92 $ 4,662.24 $ 204,493.08
<br /> 24 1-May-39 $33,281.16 $ 29,191.30 $ 4,089.86 $ 175,301.78
<br /> 25 1-May-40 $33,281.16 $ 29,775.12 $ 3,506.04 $ 145,526.66
<br /> 26 1-May-41 $33,281.16 $ 30,370.63 $ 2,910.53 $ 115,156.03
<br /> 27 1-May-42 $33,281.16 $ 30,978.04 $ 2,303.12 $ 84,177.99
<br /> 28 1-May-43 $33,281.16 $ 31,597.60 $ 1,683.56 $ 52,580.39
<br /> 29 1-May-44 $33,281.16 $ 32,229.55 $ 1,051.61 $ 20,350.84
<br /> 30 1-May-45 $20,757.86 $ 20,350.84 $ 407.02 $ -
<br /> TOTALS I $985,911.50 I $738,466.25 I $247,445.25 I $0.00 I
<br /> AmortPlatteValleyCo112014.xlsx SSB 5/1/2015
<br />
|