You take out a 20-year mortgage for $275,000 to buy a new house. What will your monthly payments be if the interest rate on your mortgage is 8 percent? Use a spreadsheet to calculate your answer.Now, calculate the portion of the 60th monthly payment that goes toward interest and principal. Use five decimal places for the monthly interest rate in your calculations.

A: Using a spreadsheet to calculate your answer, your monthly payments will be $ 2,300.22

B: The portion of the 60th monthly payment towards interest is $

C: principal portion $

Would like the financial calculator or excel formula.