NEEDS TO BE DONE IN EXCEL. A price level adjusted mortage (PLAM) is made with the following...

90.2K

Verified Solution

Question

Accounting

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?

Answer & Explanation Solved by verified expert

4.1 Ratings (546 Votes)

Step 1 Price level adjusted mortgage PLAM is a kind of mortgage wherethe mortgage payments get adjusted for inflation The new mortgagepayments after the adjustments are computed using the adjustedbalance In this kind of mortgages interest rate does not getvaried while the principal changes Usually the changes arereflected by indexCPI For implementation of these changes theintervals are agreed upon by lender and borrower at See Answer

Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:

Unlimited Question Access with detailed Answers
Zin AI - 3 Million Words
10 Dall-E 3 Images
20 Plot Generations
Conversation with Dialogue Memory
No Ads, Ever!
Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!

Become a Member

NEEDS TO BE DONE IN EXCEL. A price level adjusted mortage (PLAM) is made with the following...

90.2K

Verified Solution

Question

Accounting

Answer & Explanation Solved by verified expert

Get Answers to Unlimited Questions

Membership Benefits:

Other questions asked by students

Consider the following information on three stocks: State of Economy Probability of State of Economy Rate of Return if State Occurs Stock...

Growth Option: Decision-Tree Analysis Fethe's Funny Hats is considering selling trademarked, orange-haired curly wigs for University of...

President Trump promised many times that he would revive the economy through tax reform. His theory...

If there are 3 quantum wells separated by the same distance in a 1-D array with...

The events in the last question should result in the following OTh cell releases perforin...

from an ordinary deck of cards find the probability of ge the following a A...

Assume that the population standard deviation is o=0.7. If appropriate, perform a hypothesis test at...

Select the correct answer The table contains data on the number of people visiting a...

Journalize the following transactions for the month of September. Assume this is an accrual company....

rom inception until this year the Rapid Coaster had been FFs main attraction, but as...

Low regular and extra dividend policy Bennett Farm Equipment Sales Inc. Is in a highly...

Use the following information to determine the break-even point in sales dollars: $396,774. $414,490. $418,971....