Please demonstrate the solution with Excel functions. Excel functions are required for this problem and I need help determining which functions to use.

1. A price level adjusted mortgage (PLAM) is made with the following terms:

Amount = $95,000

Initial Interest rate = 4%

Term = 30 years

Points = 6%

Payment to be reset at the beginning of the year.

Assuming inflation is expected to increase at the rate of 6% per year for the next five years, Compute:

a. Payments at the beginning of each year (BOY)

b. Loan balance at the end of the fifth year

Please demonstrate the solution with Excel functions. Excel functions are required for this problem and I need help determining which functions to use.