Suppose you have the option to take out a 15-year mortgage with an annual interest rate of 3.55%. What will the new monthly payment be? - Present a new amortization schedule (Beginning balance, Monthly payment, Principal payment, Interest payment, Ending balance) on a new excel worksheet. - Calculate the total amount of interest paid throughout the life of the loan (sum up the amounts in the Interest column). Create a graph depicting the changes in the portions of interest and principal for each monthly payment throughout the life of the loan. Suppose you have the option to take out a 15-year mortgage with an annual interest rate of 3.55%. What will the new monthly payment be? - Present a new amortization schedule (Beginning balance, Monthly payment, Principal payment, Interest payment, Ending balance) on a new excel worksheet. - Calculate the total amount of interest paid throughout the life of the loan (sum up the amounts in the Interest column). Create a graph depicting the changes in the portions of interest and principal for each monthly payment throughout the life of the loan