1. Suppose you take out a $80,000 house mortgage from your local savings bank when the annual percentage rate is 6% compounded semiannually. The bank requires you to repay the mortgage in semiannually installments over the next 10 years. Please pay attention: Solve questions a-d in your notebook and upload to Canvas as a pdf file Solve questions a-e in excel file. a. What is the semiannually mortgage payment? b. What is the interest amount at the end of the fourth year? c. What is the amortization of the loan at the end of the fourth year? d. What is the remaining balance of your mortgage after 10 payments? e. Create an Amortization Loan Table with the titles: Interest payment, constant cash flow, amortization of the loan, and Balance. Calculate each variable for the next 10 years