2. Consider a 15 -year mortgage loan for $180,000 with a fixed annual interest rate of 7.50% and monthly payments (the same loan as above). Using MS Excel. A) Construct the amortization table for this loan for its entire term of 15 years, year by year. Your table must have the following columns: (1) year, (2) beginning balance, (3) annual spending on mortgage, (4) principal reduction, (5) interest paid, (6) ending balance. B) Plot a chart of the evolution of the loan's remaining mortgage balance over its 15 -year term. C) Plot a chart showing the evolution of the mortgage payment, interest paid and principal reduction, year by year, oyer the loan's 15 -year term. 2. Consider a 15 -year mortgage loan for $180,000 with a fixed annual interest rate of 7.50% and monthly payments (the same loan as above). Using MS Excel. A) Construct the amortization table for this loan for its entire term of 15 years, year by year. Your table must have the following columns: (1) year, (2) beginning balance, (3) annual spending on mortgage, (4) principal reduction, (5) interest paid, (6) ending balance. B) Plot a chart of the evolution of the loan's remaining mortgage balance over its 15 -year term. C) Plot a chart showing the evolution of the mortgage payment, interest paid and principal reduction, year by year, oyer the loan's 15 -year term