How the monthly payment and mortgage balance change

Assignment Help Financial Management

Reference no: EM131324721

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).

Reference no: EM131324721

Questions Cloud

The sum of net income and annual depreciation : Was Corp. is considering starting a new business involving short-term loans of magic amulets. This new business involves purchases of $14 million of new equipment. This new business is anticipated to generate net income of $1.43 million per year for ..

Scallops on the atlantic coast of north america : Explain why the removal of great sharks poses a threat to bay scallops on the Atlantic Coast of North America, despite the fact that large sharks do not feed on scallops. Include the concept of a trophic cascade in your discussion.

Find an arbitrage portfolio : The current price of a stock paying no income is 20.37 and the six-month continuous interest rate is 7.48%. European call and put options with strike price 24 and exercise date in six months are trading at 5.09 and 7.78, respectively. Find an arbitra..

Standard deviation and coefficient of variation : Consider each stock's average return, standard deviation, and coefficient of variation.

How the monthly payment and mortgage balance change : 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%. Develop a..

How financially healthy is this company : According to the balance sheet from 2015 annual report and 2016 proxy statement of Dollar General Corporation listed below: year 2016 year 2015 Assets year 2016 year 2015 total current assets $3,432,410 $3,532,609 net property and equipment $2,264,06..

Firm has debt issue outstanding with eight years : ICU Window, Inc., is trying to determine its cost of debt. The firm has a debt issue outstanding with eight years to maturity that is quoted at 96 percent of face value. The issue makes semiannual payments and has an embedded cost of 4.9 percent annu..

What should be the price of miller juice stock today : Miller Juice, Inc. is not paying a dividend right now, but is expected to pay a $2.1 dividend two years from now. Investors expect that dividend to grow by 5% every year forever. If the required return on the stock investment is 10%, what should be t..

Define or describe interest rate risk : What is the value of a 5% coupon bond maturing in 30 years if it is priced to yield 8%? Define or describe INTEREST RATE RISK. Be sure to include PRINCIPAL risk and REINVESTMENT risk in your discussion. Briefly compare the equity claims and the debt ..

User Account

All Pages