Please show work in excel

Problem 5-1 A price level adjusted mortgage (PLAM) is made with the following terms: Amount = $96,900 Initial interest rate = 4 percent Term = 30 years Points = 6 percent Payments to be reset at the beginning of each year. Assuming inflation is expected to increase at the rate of 6 percent per year for the next five years: Required: a. Compute the payments at the beginning of each year (BOY). b. What is the loan balance at the end of the fifth year? c. What is the yield to the lender on such a mortgage? Required A Required B Required C Compute the payments at the beginning of each year (BOY). (Do not round intermediate calculations. Round your final answers to the nearest dollar amount. Enter negative values with a minus sign) BOY Balance Year 0 Year 1 Year 3 Year 4 Year 5 Complete this question by entering your answers in the tabs below. Required A Required B Required C What is the loan balance at the end of the fifth year? (Do not round intermediate calculations. Round your final answer to t nearest dollar amount.) Loan balance Complete this question by entering your answers in the tabs below. Required A Required B Required C What is the yield to the lender on such a mortgage? (Do not round intermediate calculations. Round your percentage answ to 2 decimal places.) Yield %