|
<br /> I \Amortization Schedule for Consolidated Extension Canal Loan
<br /> I For Siphon Replacement
<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 />NOVEMBER 2015 $145,272.70 $1,432.25 $484.24 $948.01 $0,00 $144,324.69
<br />DEcEMBER 2015 $144,324,69 $1,432,25 $481. 08 $951.17 $0,00 $143,373,53
<br />JANUARY 2016 $143,373,53 $1,432,25 $477.91 $954,34 $0,00 $142,419,19
<br />FEBRUARY 2016 $142,419.19 $1,432,25 $474,73 $957,52 $0,00 $141,461.67
<br />MARCH 2016 $141,461.67 $1,432,25 $471. 54 $960.71 $0,00 $140,500.96
<br />APRIL 2016 $140,500.96 $1,432,25 $468,34 $963.91 $0.00 $139,537.04
<br />MAY 2016 $139,537.04 $1,432.25 $465,12 $967.13 $0,00 $138,569.92
<br />JUNE 2016 $138,569.92 $1,432,25 $461. 90 $970,35 $0,00 $137,599.57
<br />JULY 2016 $137,599.57 $1,432,25 $458.67 $973.58 $0,00 $136,625.98
<br />AUGUST 2016 $136,625.98 $1,432,25 $455,42 $976,83 $0,00 $135,649.15
<br />SEPTEMBER 2016 $135,649.15 $1,432,25 $452,16 $980,09 $0,00 $134,669.07
<br />OCTOBER 2016 $134,669.07 $1,432,25 $448.90 $983.35 $0,00 $133,685.71
<br />NOVEMBER 2016 $133,6~S,71 $1,432,25 $445,62 $986,63 $0,00 $132,699.08
<br />DECEMBER 2016 $132,699,08 $1,432,25 $442,33 $989,92 $0,00 $131,709.16
<br />JANUARY 2017 $131,709.16 $1,432,25 $439.03 $993.22 $0,00 $130,715.94
<br />FEBRUARY 2017 $130,715,94 $1,432,25 $435,72 $996,53 $0,00 $129,719.41
<br />MARCH 2017 $129,719.41 $1,432,25 $432,40 $999,85 $0,00 $128,719,56
<br />APRIL 2017 $128,719.56 $1,432.25 $429.07 $1,003.18 $0.00 $127,716.38
<br />MAY 2017 $127,716.38 $1,432,25 $425,72 $1,006,53 $0,00 $126,709.85
<br />JUNE 2017 $126,709.85 $1,432,25 $422.37 $1,009.88 $0,00 $125,699.96
<br />JULY 2017 $125,699.96 $1,432,25 $419,00 $1,013.25 $0,00 $124,686.71
<br />AUGUST 2017 $124,686.71 $1,432,25 $415,62 $1,016.63 $0,00 $123,670.08
<br />SEPTEMBER 2017 $123,670.08 $1,432.25 $412.23 $1,020.02 $0.00 $122,650.07
<br />OCTOBER 2017 $122,650.07 $1,432.25 $408.83 $1,023.42 $0,00 $121,626.65
<br />NOVEMBER 2017 $121,626.65 $1,432.25 $405,42 $1,026,83 $0,00 $120,599.82
<br />DECEMBER 2017 $120,599.82 $1,432.25 $402.00 $1,030.25 $0,00 $119,569.57
<br />JANUARY 2018 $119,569.57 $1,432,25 $398,57 $1,033,68 $0,00 $118,535.89
<br />FEBRUARY 2018 $118,535,89 $1,432,25 $395,12 $1,037,13 $0,00 $117,498.76
<br />MARCH 2018 $117,498.76 $1,432.25 $391. 66 $1,040.59 $0,00 $116,458.17
<br />APRIL 2018 $116,458.17 $1,432.25 $388.19 $1,044.06 $0.00 $115,414.12
<br />MAY 2018 $115,414,12 $1,432,25 $384,71 $1,047,54 $0,00 $114,366.58
<br />JUNE 2018 $114,366.58 $1,432.25 $381. 22 $1,051. 03 $0,00 $113,315.55
<br />JULY 2018 $113,315.55 $1,432.25 $377,72 $1,054.53 $0,00 $112,261.02
<br />AUGUST 2018 $112,261.02 $1,432,25 $374,20 $1,058,05 $0,00 $111,202.97
<br />SEPTEMBER 2018 $111,202.97 $1,432.25 $370.68 $1,061.57 $0,00 $110,141.40
<br />OCTOBER 2018 $110,141.40 $1,432,25 $367,14 $1,065,11 $0,00 $109,076,29
<br />NOVEMBER 2018 $109,076.29 $1,432,25 $363.59 $1,068,66 $0,00 $108,007,62
<br />DECEMBER 2018 $108,007.62 $1,432,25 $360.03 $1,072.22 $0.00 $106,935.40
<br />JANUARY 2019 $106,935.40 $1,432,25 $356,45 $1,075,80 $0,00 $105,859.60
<br />FEBRUARY 2019 $105,859.60 $1,432,25 $352.87 $1,079.38 $0,00 $104,780.22
<br />MARCH 2019 $104,780.22 $1,432,25 $349.27 $1,082.98 $0,00 $103,697.23
<br />APRIL 2019 $103,697.23 $1,432.25 $345,66 $1,086.59 $0,00 $102,610.64
<br />MAY 2019 $102,610.64 $1,432,25 $342,04 $1,090.21 $0,00 $101,520.43
<br />JUNE 2019 $101,520.43 $1,432.25 $338.40 $1,093,85 $0,00 $100,426,58
<br />JULY 2019 $100,426.58 $1,432,25 $334.76 $1,097,49 $0.00 $99,329,08
<br />AUGUST 2019 $99,329.08 $1,432.25 $331.10 $1,101.15 $0,00 $98,227.93
<br />SEPTEMBER 2019 $98,227,93 $1,432,25 $327,43 $1,104,82 $0,00 $97,123.11
<br />OCTOBER 2019 $97,123.11 $1,432,25 $323,74 $1,108,51 $0,00 $96,014,60
<br />NOVEMBER 2019 $96,014.60 $1,432.25 $320,05 $1,112.20 $0,00 $94,902.40
<br />DECEMBER 2019 $94,902.40 $1,432,25 $316.34 $1,115.91 $0,00 $93,786.49
<br />JANUARY 2020 $93,786.49 $1,432,25 $312,62 $1,119,63 $0.00 $92,666.86
<br />FEBRUARY 2020 $92,666,86 $1,432,25 $308.89 $1,123.36 $0,00 $91,543.50
<br />MARCH 2020 $91,543.50 $1,432,25 $305,15 $1,127.10 $0,00 $90,416.40
<br />APRIL 2020 $90,416.40 $1,432.25 $301. 39 $1,130.86 $0,00 $89,285,54
<br />MAY 2020 $89,285,54 $1,432,25 $297.62 $1,134.63 $0,00 $88,150.90
<br />JUNE 2020 $88,150,90 $1,432,25 $293,84 $1,138,41 $0,00 $87,012.49
<br />JULY 2020 $87,012.49 $1,432,25 $290,04 $1,142.21 $0,00 $85,870.28
<br />AUGUST 2020 $85,870.28 $1,432,25 $286,23 $1,146,02 $0,00 $84,724,27
<br />SEPTEMBER 2020 $84,724.27 $1,432.25 $282.41 $1,149.84 $0.00 $83,574.43
<br />
|