|
COLORADO WATER CONSER DATION BOARD
<br /> LOAN REPAYMENT SCHEDULE
<br /> Borrower Plum Valley Heights Subdistrict FINAL
<br /> Loan Contract Number CT 2015-176
<br /> Principal $2,248,260.00
<br /> Interest Rate 3.05%
<br /> Frequency Annual
<br /> Term(In Years) 30
<br /> First Payment Due February 1,2018
<br /> Payment Amount $115,447.15
<br /> Loan Annual Annual Principal
<br /> Payment Payment Payment Principal Interest BALANCE
<br /> No. Due Date Amount
<br /> $ 2,248,260.00
<br /> 1 1-Feb-18 $115,447.15 $ 46,875.22 $ 68,571.93 $ 2,201,384.78
<br /> 2 1-Feb-19 $115,447.15 $ 48,304.91 $ 67,142.24 $ 2,153,079.87
<br /> 3 1-Feb-20 $115,447.15 $ 49,778.21 $ 65,668.94 $ 2,103,301.66
<br /> 4 1-Feb-21 $115,447.15 $ 51,296.45 $ 64,150.70 $ 2,052,005.21
<br /> 5 1-Feb-22 $115,447.15 $ 52,860.99 $ 62,586.16 $ 1,999,144.22
<br /> 6 1-Feb-23 $115,447.15 $ 54,473.25 $ 60,973.90 $ 1,944,670.97
<br /> 7 1-Feb-24 $115,447.15 $ 56,134.69 $ 59,312.46 $ 1,888,536.28
<br /> 8 1-Feb-25 $115,447.15 $ 57,846.79 $ 57,600.36 $ 1,830,689.49
<br /> 9 1-Feb-26 $115,447.15 $ 59,611.12 $ 55,836.03 $ 1,771,078.37
<br /> 10 1-Feb-27 $115,447.15 $ 61,429.26 $ 54,017.89 $ 1,709,649.11
<br /> 11 1-Feb-28 $115,447.15 $ 63,302.85 $ 52,144.30 $ 1,646,346.26
<br /> 12 1-Feb-29 $115,447.15 $ 65,233.59 $ 50,213.56 $ 1,581,112.67
<br /> 13 1-Feb-30 $115,447.15 $ 67,223.21 $ 48,223.94 $ 1,513,889.46
<br /> 14 1-Feb-31 $115,447.15 $ 69,273.52 $ 46,173.63 $ 1,444,615.94
<br /> 15 1-Feb-32 $115,447.15 $ 71,386.36 $ 44,060.79 $ 1,373,229.58
<br /> 16 1-Feb-33 $115,447.15 $ 73,563.65 $ 41,883.50 $ 1,299,665.93
<br /> 17 1-Feb-34 $115,447.15 $ 75,807.34 $ 39,639.81 $ 1,223,858.59
<br /> 18 1-Feb-35 $115,447.15 $ 78,119.46 $ 37,327.69 $ 1,145,739.13
<br /> 19 1-Feb-36 $115,447.15 $ 80,502.11 $ 34,945.04 $ 1,065,237.02
<br /> 20 l-Feb-37 $115,447.15 $ 82,957.42 $ 32,489.73 $ 982,279.60
<br /> 21 1-Feb-38 $115,447.15 $ 85,487.62 $ 29,959.53 $ 896,791.98
<br /> 22 1-Feb-39 $115,447.15 $ 88,094.99 $ 27,352.16 $ 808,696.99
<br /> 23 1-Feb-40 $115,447.15 $ 90,781.89 $ 24,665.26 $ 717,915.10
<br /> 24 1-Feb-41 $115,447.15 $ 93,550.74 $ 21,896.41 $ 624,364.36
<br /> 25 1-Feb-42 $115,447.15 $ 96,404.04 $ 19,043.11 $ 527,960.32
<br /> 26 1-Feb-43 $115,447.15 $ 99,344.36 $ 16,102.79 $ 428,615.96
<br /> 27 1-Feb-44 $115,447.15 $ 102,374.36 $ 13,072.79 $ 326,241.60
<br /> 28 1-Feb-45 $115,447.15 $ 105,496.78 $ 9,950.37 $ 220,744.82
<br /> 29 1-Feb-46 $115,447.15 $ 108,714.43 $ 6,732.72 $ 112,030.39
<br /> 30 1-Feb-47 $115,447.32 $ 112,030.39 $ 3,416.93 $ -
<br /> TOTALS $3,463,414.67 $2,248,260.00 $1,215,154.67 $0.00
<br /> AmortPlumValleyHeightsSD0515.xisx SSB 3/1/2017
<br />
|