|
COLORADO WATER CONSERVATION BOARD
<br /> LOAN REPAYMENT SCHEDULE
<br /> Borrower North Delta Irrigation Company FINAL
<br /> Loan Contract Number C150331
<br /> Principal $808,000.00
<br /> Interest Rate 3.10%
<br /> Frequency Annual
<br /> Term(In Years) 30
<br /> First Payment Due April 1,2015
<br /> Payment Amount $41,758.21
<br /> Loan Annual Annual Principal
<br /> Payment Payment Payment Principal Interest BALANCE
<br /> No. Due Date Amount
<br /> $ 808,000.00
<br /> 1 1-Apr-15 $41,758.21 $ 16,710.21 $ 25,048.00 $ 791,289.79
<br /> 2 1-Apr-16 $41,758.21 $ 17,228.23 $ 24,529.98 $ 774,061.56
<br /> 3 1-AI'r-17 $41,758.21 $ 17,762.30 $ 23,995.91 $ 756,299.26
<br /> 4 1-Apr-18 $41,758.21 $ 18,312.93 $ 23,445.28 $ 737,986.33
<br /> 5 1-AIr-19 $41,758.21 $ 18,880.63 $ 22,877.58 $ 719,105.70
<br /> 6 1-Apr-20 $41,758.21 $ 19,465.93 $ 22,292.28 $ 699,639.77
<br /> 7 1-Apr-21 $41,758.21 $ 20,069.38 $ 21,688.83 $ 679,570.39
<br /> 8 1-Apr-22 $41,758.21 $ 20,691.53 $ 21,066.68 $ 658,878.86
<br /> 9 1-Apr-23 $41,758.21 $ 21,332.97 $ 20,425.24 $ 637,545.89
<br /> 10 1-Apr-24 $41,758.21 $ 21,994.29 $ 19,763.92 $ 615,551.60
<br /> 11 -Apr-25 $41,758.21 $ 22,676.11 $ 19,082.10 $ 592,875.49
<br /> 12 -Apr-26 $41,758.21 $ 23,379.07 $ 18,379.14 $ 569,496.42
<br /> 13 1-Apr-27 $41,758.21 $ 24,103.82 $ 17,654.39 $ 545,392.60
<br /> 14 1-Ay-28 $41,758.21 $ 24,851.04 $ 16,907.17 $ 520,541.56
<br /> 15 1-Ap--29 $41,758.21 $ 25,621.42 $ 16,136.79 $ 494,920.14
<br /> 16 1-ApL-30 $41,758.21 $ 26,415.69 $ 15,342.52 $ 468,504.45
<br /> 17 1-Ap--31 $41,758.21 $ 27,234.57 $ 14,523.64 $ 441,269.88
<br /> 18 1-Apt-32 $41,758.21 $ 28,078.84 $ 13,679.37 $ 413,191.04
<br /> 19 1-Ap -33 $41,758.21 $ 28,949.29 $ 12,808.92 $ 384,241.75
<br /> 20 1-Ap -34 $41,758.21 $ 29,846.72 $ 11,911.49 $ 354,395.03
<br /> 21 1-Ap -35 $41,758.21 $ 30,771.96 $ 10,986.25 $ 323,623.07
<br /> 22 1-Apt-36 $41,758.21 $ 31,725.89 $ 10,032.32 $ 291,897.18
<br /> 23 1-Ap -37 $41,758.21 $ 32,709.40 $ 9,048.81 $ 259,187.78
<br /> 24 1-Ap -38 $41,758.21 $ 33,723.39 $ 8,034.82 $ 225,464.39
<br /> 25 1-Api-39 $41,758.21 $ 34,768.81 $ 6,989.40 $ 190,695.58
<br /> 26 1-Api-40 $41,758.21 $ 35,846.65 $ 5,911.56 $ 154,848.93
<br /> 27 1-Ap1 41 $41,758.21 $ 36,957.89 $ 4,800.32 $ 117,891.04
<br /> 28 1-Api 42 $41,758.21 $ 38,103.59 $ 3,654.62 $ 79,787.45
<br /> 29 1-Ap 43 $41,758.21 $ 39,284.80 $ 2,473.41 $ 40,502.65
<br /> 30 1-Apr-44 $41,758.23 $ 40,502.65 $ 1,255.58 $ -
<br /> TOTALS $1,252,746.32 $808,000.00 I $444,746.32 $0.00
<br /> Amort No Delta C 1 50331 0312.xlsx SSB 3/27/2014
<br />
|