Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

You are considering a $495,000, 15 year, monthly amortizing price level adjusted mortgage (PLAM) at 3% real interest rate. The inflation in first 5 years

You are considering a $495,000, 15 year, monthly amortizing price level adjusted mortgage (PLAM) at 3% real interest rate. The inflation in first 5 years is expected to be at 4%, in the next 5 years at 5%, and in the final five years at 2%.

**post spreadsheet with all work/forumulas visible**

a) Develop an annual amortization table for this contract as shown below.

b) Consider 1.25% commitment fees, 2 points and 4.5% closing cost on the loan. Calculate the APR. Use Excel functions for ALL calculations. For simplicity, consider only the annually aggregated cash flows when calculating the APR.

c) Draw an annual graph of how the monthly payment and mortgage balance change over the 15 years (as shown below).

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

The Oxford Handbook Of Pricing Management

Authors: Ozalp Ozer, Robert Phillips

1st Edition

0199543178, 978-0199543175

More Books

Students also viewed these Finance questions