|
<br />, I IAmortization Schedule for Cons~lidated Extension Canal Loan
<br /> I I For Siphon Replac~ment
<br />Assumptions: 30 year loan I
<br /> 4% interest rate I
<br /> Loan payments begin, March 1997
<br />MONTH YEAR BOM REGULAR INTEREST PRINCIPAL ADDITIONAL NEW
<br /> PRINCIPAL PAYMENT PAYMENT PAYMENT PRINCIPAL PRINCIPAL
<br /> BALANCE BALANCE
<br />DECEMBER 2011 $195,972.21 $1,432.25 $653,24 $779.01 $0,00 $195,193.20
<br />JANUARY 2011 $195,193.20 $1,432,25 $650.64 $781. 61 $0,00 $194,411.60
<br />FEBRUARY 2011 $194,411.60 $1,432.25 $648.04 $784,21 $0,00 $193,627,39
<br />MARCH 2011 $193,627.39 $1,432,25 $645.42 $786.83 $0,00 $192,840.56
<br />APRIL 2011 $192,840,56 $1,432,25 $642,80 $789,45 $0,00 $192,051.11
<br />MAY 2011 $192,051.11 $1,432,25 $640,17 $792,08 $0,00 $191,259.03
<br />JUNE 2011 $191,259.03 $1,432.25 $637,53 $794,72 $0,00 $190,464.31
<br />JULY 2011 $190,464.31 $1,432,25 $634,88 $797,37 $0.00 $189,666,94
<br />AUGUST 2011 $189,666,94 $1,432,25 $632,22 $800,03 $0.00 $188,866,92
<br />SEPTEMBER 2011 $188,866.92 $1,432.25 $629,56 $802.69 $0,00 $188,064.22
<br />OCTOBER 2011 $188,064.22 $1,432,25 $626,88 $805,37 $0,00 $187,258,85
<br />NOVEMBER 2011 $187,258.85 $1,432.25 $624.20 $808.05 $0,00 $186,450.80
<br />DECEMBER 2011 $186,450.80 $1,432.25 $621. SO $810.75 $0,00 $185,640.05
<br />JANUARY 2012 $185,640.05 $1,432.25 $618,80 $813,45 $0,00 $184,826.60
<br />FEBRUARY 2012 $184,826,60 $1,432,25 $616.09 $816,16 $0,00 $184,010.44
<br />MARCH 2012 $184,010.44 $1,432,25 $613.37 $818.88 $0.00 $183,191.56
<br />APRIL 2012 $183,191.56 $1,432,25 $610,64 $821.61 $0,00 $182,369.95
<br />MAY 2012 $182,369,95 $1,432,25 $607,90 $824,35 $0,00 $181,545.60
<br />JUNE 2012 $181,545.60 $1,432,25 $605,15 $827,10 $0,00 $180,718.50
<br />JULY 2012 $180,718.50 $1,4:;2,25 $602.40 $829.85 $0,00 $179,888.65
<br />AUGUST 2012 $179,888.65 $1,432,25 $599,63 $832,62 $0,00 $179,056.02
<br />SEPTEMBER 2012 $179,056.02 $1,4)2,25 $596,85 $835.40 $0,00 $178,220.63
<br />OCTOBER 2012 $178,220.63 $1,432,25 $594.07 $838.18 $0,00 $177,382.45
<br />NOVEMBER 2012 $177,382.45 $1,4)2,25 $591,27 $840.98 $0,00 $176,541.47
<br />DECEMBER 2012 $176,541.47 $1,4)2,25 $588,47 $843,78 $0,00 $175,697.69
<br />JANUARY 2013 $175,697.69 $1,4:;2,25 $585,66 $846.59 $0,00 $174,851.10
<br />FEBRUARY 2013 $174,851.10 $1,4:;2,25 $582,84 $849.41 $0,00 $174,001. 69
<br />MARCH 2013 $174,001.69 $1,4:;2,25 $580,01 $852,24 $0,00 $173,149.45
<br />APRIL 2013 $173,149.45 $1,4:;2,25 $577,16 $855,09 $0,00 $172,294,36
<br />MAY 2013 $172,294.36 $1,432.25 $574.31 $857.94 $0,00 $171,436.42
<br />JUNE 2013 $171,436.42 $1,4:;2.25 $571.45 $860.80 $0,00 $170,575.63
<br />JULY 2013 $170,575.63 $1,432.25 $568.59 $863.66 $0,00 $169,711. 96
<br />AUGUST 2013 $169,711.96 $1,4:;2,25 $565,71 $866.54 $0,00 $168,845.42
<br />SEPTEMBER 2013 $168,845.42 $1,432,25 $562.82 $869.43 $0,00 $167,975.99
<br />OCTOBER 2013 $167,975,99 $1,432,25 $559,92 $872,33 $0,00 $167,103.66
<br />NOVEMBER 2013 $167,103,66 $1,432,25 $557,01 $875,24 $0,00 $166,228,42
<br />DECEM!ER 2013 $166,228.42 $1,432,25 $554,09 $878.16 $0,00 $165,350.27
<br />JANUARY 2014 $165,350.27 $1,432,25 $551.17 $881. 08 $0,00 $164,469.18
<br />FEBRUARY 2014 $164,469,18 $1,432,25 $548,23 $884,02 $0,00 $163,585,16
<br />MARCH 2014 $163,585.16 $1,4~2.25 $545,28 $886.97 $0.00 $162,698.20
<br />APRIL 2014 $162,698.20 $1,432,25 $542.33 $889.92 $0,00 $161,808.28
<br />MAY 2014 $161,808.28 $1,432,25 $539,36 $892,89 $0,00 $160,915.39
<br />JUNE 2014 $160,915,39 $1,432,25 $536,38 $895,87 $0,00 $160,019.52
<br />JULY 2014 $160,019.52 $1,432,25 $533,40 $898,85 $0,00 $159,120,67
<br />AUGUST 2014 $159,120.67 $1,432,25 $530,40 $901. 85 $0,00 $158,218.82
<br />SEPTEMBER 2014 $158,218,82 $1,432,25 $527.40 $904,85 $0,00 $157,313.97
<br />OCTOBER 2014 $157,313,97 $1,432,25 $524,38 $907,87 $0,00 $156,406.10
<br />NOVEMBER 2014 $156,406.10 $1,432,25 $521. 35 $910,90 $0,00 $155,495,20
<br />DECEMBER 2014 $155,495.20 $1,432,25 $518,32 $913,93 $0,00 $154,581.27
<br />JANUARY 2015 $154,581. 27 $1,432,25 $515,27 $916,98 $0.00 $153,664.29
<br />FEBRUARY 2015 $153,664.29 $1,432,25 $512.21 $920.04 $0,00 $152,744.25
<br />MARCH 2015 $152,744.25 $1,432,25 $509,15 $923.10 $0,00 $151,821. 15
<br />APRIL 2015 $151,821.15 $1,432,25 $506,07 $926,18 $0,00 $150,894.97
<br />MAY 2015 $150,894,97 $1,432,25 $502,98 $929,27 $0,00 $149,965.71
<br />JUNE 2015 $149,965.71 $1,432,25 $499.89 $932.36 $0,00 $149,033.34
<br />JULY 2015 $149,033.34 $1,432,25 $496,78 $935,47 $0,00 $148,097.87
<br />AUGUST 2015 $148,097.87 $1,432,25 $493,66 $938.59 $0,00 $147,159.28
<br />SEPTEMBER 2015 $147,159,28 $1,432,25 $490,53 $941. 72 $0,00 $146,217.56
<br />OCTOBER 2015 $146,217.56 $1,4:32.25 $487.39 $944.86 $0.00 $145,272.70
<br />
|