|
COLORADO WATER CONSERVATION BOARD
<br /> LOAN REPAYMENT SCHEDULE
<br /> Borrower Pinery Water and Wastewater
<br /> District Final
<br /> Loan Contract Number C150411A
<br /> Principal $1,845,270.00
<br /> Interest Rate 3.00%
<br /> Frequency Annual
<br /> Term(In Years) 30
<br /> First Payment Due February 1,2016
<br /> Payment Amount $94,144.31
<br /> Loan Annual Annual
<br /> Principal
<br /> Payment Payment Payment Principal Interest BALANCE
<br /> No. Due Date Amount
<br /> $ 1,845,270.00
<br /> 1 1-Feb-16 $94,144.31 $ 38,786.21 $ 55,358.10 $ 1,806,483.79
<br /> 2 1-Feb-17 $94,144.31 $ 39,949.80 $ 54,194.51 $ 1,766,533.99
<br /> 3 1-Feb-18 $94,144.31 $ 41,148.29 $ 52,996.02 $ 1,725,385.70
<br /> 4 1-Feb-19 $94,144.31 $ 42,382.74 $ 51,761.57 $ 1,683,002.96
<br /> 5 1-Feb-20 $94,144.31 $ 43,654.22 $ 50,490.09 $ 1,639,348.74
<br /> 6 1-Feb-21 $94,144.31 $ 44,963.85 $ 49,180.46 $ 1,594,384.89
<br /> 7 1-Feb-22 $94,144.31 $ 46,312.76 $ 47,831.55 $ 1,548,072.13
<br /> 8 1-Feb-23 $94,144.31 $ 47,702.15 $ 46,442.16 $ 1,500,369.98
<br /> 9 1-Feb-24 $94,144.31 $ 49,133.21 $ 45,011.10 $ 1,451,236.77
<br /> 10 1-Feb-25 $94,144.31 $ 50,607.21 $ 43,537.10 $ 1,400,629.56
<br /> 11 1-Feb-26 $94,144.31 $ 52,125.42 $ 42,018.89 $ 1,348,504.14
<br /> 12 1-Feb-27 $94,144.31 $ 53,689.19 $ 40,455.12 $ 1,294,814.95
<br /> 13 1-Feb-28 $94,144.31 $ 55,299.86 $ 38,844.45 $ 1,239,515.09
<br /> 14 1-Feb-29 $94,144.31 $ 56,958.86 $ 37,185.45 $ 1,182,556.23
<br /> 15 1-Feb-30 $94,144.31 $ 58,667.62 $ 35,476.69 $ 1,123,888.61
<br /> 16 1-Feb-31 $94,144.31 $ 60,427.65 $ 33,716.66 $ 1,063,460.96
<br /> 17 1-Feb-32 $94,144.31 $ 62,240.48 $ 31,903.83 $ 1,001,220.48
<br /> 18 1-Feb-33 $94,144.31 $ 64,107.70 $ 30,036.61 $ 937,112.78
<br /> 19 1-Feb-34 $94,144.31 $ 66,030.93 $ 28,113.38 $ 871,081.85
<br /> 20 1-Feb-35 $94,144.31 $ 68,011.85 $ 26,132.46 $ 803,070.00
<br /> 21 1-Feb-36 $94,144.31 $ 70,052.21 $ 24,092.10 $ 733,017.79
<br /> 22 1-Feb-37 $94,144.31 $ 72,153.78 $ 21,990.53 $ 660,864.01
<br /> 23 1-Feb-38 $94,144.31 $ 74,318.39 $ 19,825.92 $ 586,545.62
<br /> 24 1-Feb-39 $94,144.31 $ 76,547.94 $ 17,596.37 $ 509,997.68
<br /> 25 1-Feb-40 $94,144.31 $ 78,844.38 $ 15,299.93 $ 431,153.30
<br /> 26 1-Feb-41 $94,144.31 $ 81,209.71 $ 12,934.60 $ 349,943.59
<br /> 27 1-Feb-42 $94,144.31 $ 83,646.00 $ 10,498.31 $ 266,297.59
<br /> 28 1-Feb-43 $94,144.31 $ 86,155.38 $ 7,988.93 $ 180,142.21
<br /> 29 1-Feb-44 $94,144.31 $ 88,740.04 $ 5,404.27 $ 91,402.17
<br /> 30 1-Feb-45 $94,144.24 $ 91,402.17 $ 2,742.07 $ -
<br /> TOTALS $2,824,329.23 I $1,845,270.00 I $979,059.23 I $0.00
<br /> AmortPineryC1504110614.xlsx SSB 4/30/2015
<br />
|