|
COLORADO WATER CONSERVATION BOARD
<br /> LOAN REPAYMENT SCHEDULE
<br /> Wadley Farms Filing No.3
<br /> Borrower FINAL
<br /> Homeowner's Association
<br /> Loan Contract Number C150379
<br /> Principal $727,200.00
<br /> Interest Rate 3.00%
<br /> Frequency Annual
<br /> Term(In Years) 30
<br /> First Payment Due June 1,2015
<br /> Payment Amount $37,101.21
<br /> Loan Annual Annual
<br /> Payment Payment Payment Principal Interest Principal
<br /> No. Due Date Amount BALANCE
<br /> $ 727,200.00
<br /> 1 1-Jun-15 $37,101.21 $ 15,285.21 $ 21,816.00 $ 711,914.79
<br /> 2 1-Jun-16 $37,101.21 $ 15,743.77 $ 21,357.44 $ 696,171.02
<br /> 3 1-Jun-17 $37,101.21 $ 16,216.08 $ 20,885.13 $ 679,954.94
<br /> 4 1-Jun-18 $37,101.21 $ 16,702.56 $ 20,398.65 $ 663,252.38
<br /> 5 1-Jun-19 $37,101.21 $ 17,203.64 $ 19,897.57 $ 646,048.74
<br /> 6 1-Jun-20 $37,101.21 $ 17,719.75 $ 19,381.46 $ 628,328.99
<br /> 7 1-Jun-21 $37,101.21 $ 18,251.34 $ 18,849.87 $ 610,077.65
<br /> 8 1-Jun-22 $37,101.21 $ 18,798.88 $ 18,302.33 $ 591,278.77
<br /> 9 1-Jun-23 $37,101.21 $ 19,362.85 $ 17,738.36 $ 571,915.92
<br /> 10 1-Jun-24 $37,101.21 $ 19,943.73 $ 17,157.48 $ 551,972.19
<br /> 11 1-Jun-25 $37,101.21 $ 20,542.04 $ 16,559.17 $ 531,430.15
<br /> 12 1-Jun-26 $37,101.21 $ 21,158.31 $ 15,942.90 $ 510,271.84
<br /> 13 1-Jun-27 $37,101.21 $ 21,793.05 $ 15,308.16 $ 488,478.79
<br /> 14 1-Jun-28 $37,101.21 $ 22,446.85 $ 14,654.36 $ 466,031.94
<br /> 15 1-Jun-29 $37,101.21 $ 23,120.25 $ 13,980.96 $ 442,911.69
<br /> 16 1-Jun-30 $37,101.21 $ 23,813.86 $ 13,287.35 $ 419,097.83
<br /> 17 1-Jun-31 $37,101.21 $ 24,528.28 $ 12,572.93 $ 394,569.55
<br /> 18 1-Jun-32 $37,101.21 $ 25,264.12 $ 11,837.09 $ 369,305.43
<br /> 19 1-Jun-33 $37,101.21 $ 26,022.05 $ 11,079.16 $ 343,283.38
<br /> 20 1-Jun-34 $37,101.21 $ 26,802.71 $ 10,298.50 $ 316,480.67
<br /> 21 1-Jun-35 $37,101.21 $ 27,606.79 $ 9,494.42 $ 288,873.88
<br /> 22 1-Jun-36 $37,101.21 $ 28,434.99 $ 8,666.22 $ 260,438.89
<br /> 23 1-Jun-37 $37,101.21 $ 29,288.04 $ 7,813.17 $ 231,150.85
<br /> 24 1-Jun-38 $37,101.21 $ 30,166.68 $ 6,934.53 $ 200,984.17
<br /> 25 1-Jun-39 $37,101.21 $ 31,071.68 $ 6,029.53 $ 169,912.49
<br /> 26 1-Jun-40 $37,101.21 $ 32,003.84 $ 5,097.37 $ 137,908.65
<br /> 27 1-Jun-41 $37,101.21 $ 32,963.95 $ 4,137.26 $ 104,944.70
<br /> 28 1-Jun-42 $37,101.21 $ 33,952.87 $ 3,148.34 $ 70,991.83
<br /> 29 1-Jun-43 $37,101.21 $ 34,971.46 $ 2,129.75 $ 36,020.37
<br /> 30 1-Jun-44 $37,100.98 $ 36,020.37 $ 1,080.61 $ -
<br /> TOTALS I $1,113,036.07 I $727,200.00 I $385,836.07 I $0.00
<br /> Amort Wadley C150379 1213.xlsx SSB 5/30/2014
<br />
|