NEED FORMULAS FOR EACH CATEGORY AND ROW,

Until very recently, 15-year mortgages had been affordable thanks to historically low interest rates. In March 2022, John Smith was considering buying a $400,000 house located in the Brecksville, OH. After 20% down payment, he needed a loan of $320,000. A Fifth Third Bank loan officer offered John two choices: a 30-year loan with a fixed interest rate of 3.625% and a 15 -year loan with a fixed interest rate of 2.5% Please compare the monthly payments and total interest payments under the two plans (Please ignore all refinancing costs). (Hint: Construct the two amortization tables like the one in our example, and the total interest payment would be the sum of interest payments in all the months. Highlight the monthly payments and the total interest payments under the two plans.)