|
COLORADO WATER CONSERVATION BOARD
<br /> LOAN REPAYMENT SCHEDULE
<br /> Borrower Parker Water and Sanitation FINAL
<br /> District
<br /> Loan Contract Number C150410A
<br /> Principal $4,426,830.00
<br /> Interest Rate 2.75%
<br /> Frequency Annual
<br /> Term(In Years) 20
<br /> First Payment Due February 1,2016
<br /> Payment Amount $290,717.59
<br /> Loan Annual Annual
<br /> Principal
<br /> Payment Payment Payment Principal Interest BALANCE
<br /> No. Due Date Amount
<br /> $ 4,426,830.00
<br /> 1 1-Feb-16 $290,717.59 $ 168,979.76 $ 121,737.83 $ 4,257,850.24
<br /> 2 1-Feb-17 $290,717.59 $ 173,626.71 $ 117,090.88 $ 4,084,223.53
<br /> 3 1-Feb-18 $290,717.59 $ 178,401.44 $ 112,316.15 $ 3,905,822.09
<br /> 4 1-Feb-19 $290,717.59 $ 183,307.48 $ 107,410.11 $ 3,722,514.61
<br /> 5 1-Feb-20 $290,717.59 $ 188,348.44 $ 102,369.15 $ 3,534,166.17
<br /> 6 1-Feb-21 $290,717.59 $ 193,528.02 $ 97,189.57 $ 3,340,638.15
<br /> 7 1-Feb-22 $290,717.59 $ 198,850.04 $ 91,867.55 $ 3,141,788.11
<br /> 8 1-Feb-23 $290,717.59 $ 204,318.42 $ 86,399.17 $ 2,937,469.69
<br /> 9 1-Feb-24 $290,717.59 $ 209,937.17 $ 80,780.42 $ 2,727,532.52
<br /> 10 1-Feb-25 $290,717.59 $ 215,710.45 $ 75,007.14 $ 2,511,822.07
<br /> 11 1-Feb-26 $290,717.59 $ 221,642.48 $ 69,075.11 $ 2,290,179.59
<br /> 12 1-Feb-27 $290,717.59 $ 227,737.65 $ 62,979.94 $ 2,062,441.94
<br /> 13 1-Feb-28 $290,717.59 $ 234,000.44 $ 56,717.15 $ 1,828,441.50
<br /> 14 1-Feb-29 $290,717.59 $ 240,435.45 $ 50,282.14 $ 1,588,006.05
<br /> 15 1-Feb-30 $290,717.59 $ 247,047.42 $ 43,670.17 $ 1,340,958.63
<br /> 16 1-Feb-31 $290,717.59 $ 253,841.23 $ 36,876.36 $ 1,087,117.40
<br /> 17 1-Feb-32 $290,717.59 $ 260,821.86 $ 29,895.73 $ 826,295.54
<br /> 18 1-Feb-33 $290,717.59 $ 267,994.46 $ 22,723.13 $ 558,301.08
<br /> 19 1-Feb-34 $290,717.59 $ 275,364.31 $ 15,353.28 $ 282,936.77
<br /> 20 1-Feb-35 $290,717.53 $ 282,936.77 $ 7,780.76 $ -
<br /> TOTALS $5,814,351.74 I $4,426,830.00 I $1,387,521.74 $0.00
<br /> AmortParkerC1504100614.xlsx SSB 2/3/2015
<br />
|