Please show steps in excel

FIN 36085 Excel Homework #5 Can be done in groups of two or three students Must be submitted electronically 1. Consider a 15-year mortgage loan for $180,000 with a fixed annual interest rate of 7.50% and monthly payments. Using MS Excel, A) Construct the amortization table for this loan for its entire term of 15 years, month by month. Your table must have the following columns: (1) month, (2) beginning balance, (3) payment, (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, month by month, over 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, over the loan's 15-year term