|
COLORADO WATER CONSERVATION BOARD
<br /> LOAN REPAYMENT SCHEDULE
<br /> Borrower East Mesa Water Company Final
<br /> Loan Contract Number C150360
<br /> Principal $367,418.42
<br /> Interest Rate 1.75%
<br /> Frequency Annual
<br /> Term(In Years) 30
<br /> First Payment Due July 1,2016
<br /> Payment Amount $15,846.67
<br /> Loan Annual Annual
<br /> Payment Payment Payment Principal Interest Principal
<br /> No. Due Date Amount BALANCE
<br /> $ 367,418.42
<br /> 1 1-Jul-16 $15,846.67 $ 9,416.85 $ 6,429.82 $ 358,001.57
<br /> 2 1-Jul-17 $15,846.67 $ 9,581.64 $ 6,265.03 $ 348,419.93
<br /> 3 1-Jul-18 $15,846.67 $ 9,749.32 $ 6,097.35 $ 338,670.61
<br /> 4 1-Jul-19 $15,846.67 $ 9,919.93 $ 5,926.74 $ 328,750.68
<br /> 5 1-Jul-20 $15,846.67 $ 10,093.53 $ 5,753.14 $ 318,657.15
<br /> 6 1-Jul-21 $15,846.67 $ 10,270.17 $ 5,576.50 $ 308,386.98
<br /> 7 1-Jul-22 $15,846.67 $ 10,449.90 $ 5,396.77 $ 297,937.08
<br /> 8 1-Jul-23 $15,846.67 $ 10,632.77 $ 5,213.90 $ 287,304.31
<br /> 9 1-Jul-24 $15,846.67 $ 10,818.84 $ 5,027.83 $ 276,485.47
<br /> 10 1-Jul-25 $15,846.67 $ 11,008.17 $ 4,838.50 $ 265,477.30
<br /> 11 1-Jul-26 $15,846.67 $ 11,200.82 $ 4,645.85 $ 254,276.48
<br /> 12 1-Jul-27 $15,846.67 $ 11,396.83 $ 4,449.84 $ 242,879.65
<br /> 13 1-Jul-28 $15,846.67 $ 11,596.28 $ 4,250.39 $ 231,283.37
<br /> 14 1-Jul-29 $15,846.67 $ 11,799.21 $ 4,047.46 $ 219,484.16
<br /> 15 1-Jul-30 $15,846.67 $ 12,005.70 $ 3,840.97 $ 207,478.46
<br /> 16 1-Jul-31 $15,846.67 $ 12,215.80 $ 3,630.87 $ 195,262.66
<br /> 17 1-Jul-32 $15,846.67 $ 12,429.57 $ 3,417.10 $ 182,833.09
<br /> 18 1-Jul-33 $15,846.67 $ 12,647.09 $ 3,199.58 $ 170,186.00
<br /> 19 1-Jul-34 $15,846.67 $ 12,868.41 $ 2,978.26 $ 157,317.59
<br /> 20 1-Jul-35 $15,846.67 $ 13,093.61 $ 2,753.06 $ 144,223.98
<br /> 21 1-Jul-36 $15,846.67 $ 13,322.75 $ 2,523.92 $ 130,901.23
<br /> 22 1-Jul-37 $15,846.67 $ 13,555.90 $ 2,290.77 $ 117,345.33
<br /> 23 1-Jul-38 $15,846.67 $ 13,793.13 $ 2,053.54 $ 103,552.20
<br /> 24 1-Jul-39 $15,846.67 $ 14,034.51 $ 1,812.16 $ 89,517.69
<br /> 25 1-Jul-40 $15,846.67 $ 14,280.11 $ 1,566.56 $ 75,237.58
<br /> 26 1-Jul-41 $15,846.67 $ 14,530.01 $ 1,316.66 $ 60,707.57
<br /> 27 1-Jul-42 $15,846.67 $ 14,784.29 $ 1,062.38 $ 45,923.28
<br /> 28 1-Jul-43 $15,846.67 $ 15,043.01 $ 803.66 $ 30,880.27
<br /> 29 1-Jul-44 $15,846.67 $ 15,306.27 $ 540.40 $ 15,574.00
<br /> 30 1-Jul-45 $15,846.55 $ 15,574.00 $ 272.55 $ -
<br /> TOTALS ( $475,399.98 I $367,418.42 I $107,981.56 I $0.00
<br /> Amort East Mesa C 150360 0713.xlsx SSB 6/29/2015
<br />
|