NEEDS TO BE DONE IN EXCEL.
A price level adjusted mortage (PLAM) is made with thefollowing terms:
Amount=$95,000
Initial interest rate= 4 percent
Term= 30 Years
Points= 6 percent
Payments to be reset at the beginning of eachyear.
Assuming inflation is expected to increase at the rate of 6 percentper year for the next five years:
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?
