|
COLORADO WATER CONSERVATION BOARD
<br /> LOAN REPAYMENT SCHEDULE
<br /> Borrower Tri-County Water Conservancy FINAL
<br /> District
<br /> Loan Contract Number C150324
<br /> Principal $13,130,000.00
<br /> Interest Rate 2.00%
<br /> Frequency Annual
<br /> Term(In Years) 30
<br /> First Payment Due October 1,2015
<br /> Payment Amount $586,253.48
<br /> Loan Annual Annual
<br /> Payment Payment Payment Principal Principal
<br /> Pa
<br /> y y yment Princi al Interest BALANCE
<br /> No. Due Date Amount
<br /> $ 13,130,000.00
<br /> Adjust 1-Oct-14 $213,633.34 $ 213,633.34 $ - $ 12,916,366.66.
<br /> 1 1-Oct-15 $586,253.48 $ 323,653.48 $ 262,600.00 $ 12,592,713.18
<br /> 2 1-Oct-16 $586,253.48 $ 334,399.22 $ 251,854.26 $ 12,258,313.96
<br /> 3 1-Oct-17 $586,253.48 $ 341,087.20 $ 245,166.28 $ 11,917,226.76
<br /> 4 1-Oct-18 $586,253.48 $ 347,908.94 $ 238,344.54 $ 11,569,317.82
<br /> 5 1-Oct-19 $586,253.48 $ 354,867.12 $ 231,386.36 $ 11,214,450.70
<br /> 6 1-Oct-20 $586,253.48 $ 361,964.47 $ 224,289.01 $ 10,852,486.23
<br /> 7 1-Oct-21 $586,253.48 $ 369,203.76 $ 217,049.72 $ 10,483,282.47
<br /> 8 1-Oct-22 $586,253.48 $ 376,587.83 $ 209,665.65 $ 10,106,694.64
<br /> 9 1-Oct-23 $586,253.48 $ 384,119.59 $ 202,133.89 $ 9,722,575.05
<br /> 10 1-Oct-24 $586,253.48 $ 391,801.98 $ 194,451.50 $ 9,330,773.07
<br /> 11 1-Oct-25 $586,253.48 $ 399,638.02 $ 186,615.46 $ 8,931,135.05
<br /> 12 1-Oct-26 $586,253.48 $ 407,630.78 $ 178,622.70 $ 8,523,504.27
<br /> 13 1-Oct-27 $586,253.48 $ 415,783.39 $ 170,470.09 $ 8,107,720.88
<br /> 14 1-Oct-28 $586,253.48 $ 424,099.06 $ 162,154.42 $ 7,683,621.82
<br /> 15 1-Oct-29 $586,253.48 $ 432,581.04 $ 153,672.44 $ 7,251,040.78
<br /> 16 1-Oct-30 $586,253.48 $ 441,232.66 $ 145,020.82 $ 6,809,808.12
<br /> 17 1-Oct-31 $586,253.48 $ 450,057.32 $ 136,196.16 $ 6,359,750.80
<br /> 18 1-Oct-32 $586,253.48 $ 459,058.46 $ 127,195.02 $ 5,900,692.34
<br /> 19 1-Oct-33 $586,253.48 $ 468,239.63 $ 118,013.85 $ 5,432,452.71
<br /> 20 1-Oct-34 $586,253.48 $ 477,604.43 $ 108,649.05 $ 4,954,848.28
<br /> 21 1-Oct-35 $586,253.48 $ 487,156.51 $ 99,096.97 $ 4,467,691.77
<br /> 22 1-Oct-36 $586,253.48 $ 496,899.64 $ 89,353.84 $ 3,970,792.13
<br /> 23 1-Oct-37 $586,253.48 $ 506,837.64 $ 79,415.84 $ 3,463,954.49
<br /> 24 1-Oct-38 $586,253.48 $ 516,974.39 $ 69,279.09 $ 2,946,980.10
<br /> 25 1-Oct-39 $586,253.48 $ 527,313.88 $ 58,939.60 $ 2,419,666.22
<br /> 26 1-Oct-40 $586,253.48 $ 537,860.16 $ 48,393.32 $ 1,881,806.06
<br /> 27 1-Oct-41 $586,253.48 $ 548,617.36 $ 37,636.12 $ 1,333,188.70
<br /> 28 1-Oct-42 $586,253.48 $ 559,589.71 $ 26,663.77 $ 773,598.99
<br /> 29 1-Oct-43 $586,253.48 $ 570,781.50 $ 15,471.98 $ 202,817.49
<br /> 30 1-Oct-44 $206,873.84 $ 202,817.49 $ 4,056.35 $ -
<br /> TOTALS I$17,421,858.101$13,130,000.001 $4,291,858.10 .1 $0.00
<br /> Tri-County WCD C150324 1011.xlsx SSB 10/10/2014
<br />
|