Please demonstrate using excel functions. Excel functions are required for this problem and I need help determining which specific ones 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 using excel functions. Excel functions are required for this problem and I need help determining which specific ones to use.