|
COLORADO WATER CONSERVATIONBOARD
<br /> LOAN REPAYMENT SCHEDULE
<br /> Borrower WRCC,Inc.
<br /> Loan Contract Number C150271 RE2016-197
<br /> Principal $1,285,730.00
<br /> Interest Rate 2.55%
<br /> Frequency Annual
<br /> Term(In Years) 30
<br /> First Payment Due March 1,2011
<br /> Payment Amount $61,839.41
<br /> Loan Annual Annual Principal
<br /> Payment Payment Payment Principal Interest BALANCE
<br /> No. Due Date Amount
<br /> $ 1,285,730.00
<br /> Adjust 1-Mar-10 $17,713.41 $ 17,713.41 $ - $ 1,268,016.59
<br /> 1 1-Mar-I1 $61,839.41 $ 29,504.99 $ 32,334.42 $ 1,238,511.60
<br /> 2 1-Mar-12 $61,839.41 $ 30,257.36 $ 31,582.05 $ 1,208,254.24
<br /> 3 1-Mar-13 $61,839.41 $ 31,028.93 $ 30,810.48 $ 1,177,225.31
<br /> 4 1-Mar-14 $61,839.41 $ 31,820.16 $ 30,019.25 $ 1,145,405.15
<br /> 5 1-Mar-15 $61,839.41 $ 32,631.58 $ 29,207.83 $ 1,112,773.57
<br /> 6 1-Mar-16 $61,839.41 $ 33,463.68 $ 28,375.73 $ 1,079,309.89
<br /> 7 1-Mar-17 $61,839.41 $ 34,317.01 $ 27,522.40 $ 1,044,992.88
<br /> 8 1-Mar-18 $61,839.41 $ 35,192.09 $ 26,647.32 $ 1,009,800.79
<br /> 9 1-Mar-19 $61,839.41 $ 36,089.49 $ 25,749.92 $ 973,711.30
<br /> 10 1-Mar-20 $61,839.41 $ 37,009.77 $ 24,829.64 $ 936,701.53
<br /> 11 1-Mar-21 $61,839.41 $ 37,953.52 $ 23,885.89 $ 898,748.01
<br /> 12 1-Mar-22 $61,839.41 $ 38,921.34 $ 22,918.07 $ 859,826.67
<br /> 13 1-Mar-23 $61,839.41 $ 39,913.83 $ 21,925.58 $ 819,912.84
<br /> 14 1-Mar-24 $61,839.41 $ 40,931.63 $ 20,907.78 $ 778,981.21
<br /> 15 1-Mar-25 $61,839.41 $ 41,975.39 $ 19,864.02 $ 737,005.82
<br /> 16 1-Mar-26 $61,839.41 $ 43,045.76 $ 18,793.65 $ 693,960.06
<br /> 17 1-Mar-27 $61,839.41 $ 44,143.43 $ 17,695.98 $ 649,816.63
<br /> 18 1-Mar-28 $61,839.41 $ 45,269.09 $ 16,570.32 $ 604,547.54
<br /> 19 1-Mar-29 $61,839.41 $ 46,423.45 $ 15,415.96 $ 558,124.09
<br /> 20 1-Mar-30 $61,839.41 $ 47,607.25 $ 14,232.16 $ 510,516.84
<br /> 21 1-Mar-31 $61,839.41 $ 48,821.23 $ 13,018.18 $ 461,695.61
<br /> 22 1-Mar-32 $61,839.41 $ 50,066.17 $ 11,773.24 $ 411,629.44
<br /> 23 1-Mar-33 $61,839.41 $ 51,342.86 $ 10,496.55 $ 360,286.58
<br /> 24 I-Mar-34 $61,839.41 $ 52,652.10 $ 9,187.31 $ 307,634.48
<br /> 25 1-Mar-35 $61,839.41 $ 53,994.73 $ 7,844.68 $ 253,639.75
<br /> 26 1-Mar-36 $61,839.41 $ 55,371.60 $ 6,467.81 $ 198,268.15
<br /> 27 1-Mar-37 $61,839.41 $ 56,783.57 $ 5,055.84 $ 141,484.58
<br /> 28 1-Mar-38 $61,839.41 $ 58,231.55 $ 3,607.86 $ 83,253.03
<br /> 29 1-Mar-39 $61,839.41 $ 59,716.46 $ 2,122.95 $ 23,536.57
<br /> 30 1-Mar-40 $24,136.75 $ 23,536.57 $ 600.18 $ -
<br /> TOTALS x$1,835,193.05 $1,285,730.00 $549,463.05 $0.00
<br /> Amort WRCC C150271 1008.xls SSB 2/10/2017
<br />
|