Please show excel work.

A price level adjusted mortgage (PLAM) is made with the following terms: Amount =$95,800 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? Complete this question by entering your answers in the tabs below. Compute the payments at the beginning of each year (BOY). Note: Do not round intermediate calculations. Round your final answers to 2 decimal places. Complete this question by entering your answers in the tabs below. What is the loan balance at the end of the fifth year? Note: Do not round intermediate calculations. Round your final answer to the nearest dollar amount. Complete this question by entering your answers in the tabs below. What is the yield to the lender on such a mortgage? Note: Do not round intermediate calculations. Round your percentage answer to 2 decimal places. A price level adjusted mortgage (PLAM) is made with the following terms: Amount =$95,800 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? Complete this question by entering your answers in the tabs below. Compute the payments at the beginning of each year (BOY). Note: Do not round intermediate calculations. Round your final answers to 2 decimal places. Complete this question by entering your answers in the tabs below. What is the loan balance at the end of the fifth year? Note: Do not round intermediate calculations. Round your final answer to the nearest dollar amount. Complete this question by entering your answers in the tabs below. What is the yield to the lender on such a mortgage? Note: Do not round intermediate calculations. Round your percentage answer to 2 decimal places