--%>
Assignment Help - homework help

Problem on annual mortgage payment

You just took out a variable-rate mortgage on your new home. The mortgage value is $100,000, the term is 30 years, and initially the interest rate is 8%. The interest rate is fixed for 5 years, after which the time rate will be adjusted according to the prevailing rates. The latest rate can be exerted to your loan either by changing the amount payment or by changing the length of mortgage.

a) Supposing annual payments, what is the original annual mortgage payment?

b) Make an amortization schedule for the first 5 years. Then What is the mortgage balance after 5 years?

c) When the interest rate on mortgage changes to 9% after 5 years, then what will be the latest annual payment which keeps the similar termination time?

d) Under the interest change in part (c), what will be the new term if the payments remain the same?

E

Expert

Verified

a) The annual payment , M, can be computed using the following equation

1651_mp1.jpg

From the question, PV=$100,000 and r = 8% , substituting to the equation and we get
M = 100,000 / annuality factor (30,8%)
=> M = 100,000 / 11.26
=> M = $8,882.74

b)

1633_mp2.jpg

The balance after year 5 will be $96022.26-$1200.96 = $94,821.30

c) The PV of mortgage after year 5 is $94,821.30
Using the same formula as part a), let the new mortgage payment by M1

2430_mp3.jpg

From the question, PV= $94,821.30 and   = 9% , substituting to the equation and we get
 $94,821.30 / annulity factor (25,9%)
From Excel, we can compute the annuality factor, which is 9.823

M1 = $94,821.30/9.823 = $9,653.40

d) Using the same result in part (c ),

1636_mp4.jpg


From the question, PV= $94,821.30 and   = 9% , substituting to the equation and we get

1800_mp5.jpg

Solving the equation and we get T = 37.57
Therefore, it requires a total of 38 years to repay the mortgage if the payment remains the same.

   Related Questions in Corporate Finance

  • Q : Convertible Bonds-Corporate Bonds State

    State the term Convertible Bonds in Corporate Bonds?

    		•
  • Q : Strategy of Bear Spread State when

    State when markets are anticipated to go down then what is the Strategy of Bear Spread?

    		•
  • Q : Analysis on Stock Prices Using the last

    Using the last 3 years of closing stock prices on the first trading day of each month from January,  2010 through December 2012 for Apple (APPL) and the S&P 500 (market) for the same date range 1)    &n

    		•
  • Q : Assignment help for Financial Statement

    HW I: Show your approach to each problem (formulas, variables, etc.) You can use Excel sheet formulas to show the work or use the Finance calculator terms. For the ABC answers: choose the correct answer and delete the rest.

  • Q : Illustrates financial consultant has

    A financial consultant obtains various valuations of my company when this discounts the Free Cash Flow (FCF) as opposed to when this uses the Equity Cash Flow. Is it correct?

    		•
  • Q : Shall we use the arithmetic mean or the

    The market risk premium is the difference between the historical return on the stock market and the return on bonds. But how many years does “historical” imply? Shall we use the arithmetic mean or the geometric one?

    		•
  • Q : Define Strong form market efficiency

    Strong form market efficiency: Strong form market efficiency defines that the price of a security in the market replicates all information—public and also private or within information. Strong form efficiency

    		•
  • Q : Calculating the Cost of Equity You are

    You are an analyst in the financial division of Flipper Industries (FI) which has a beta of 1.80 (you are risk-philic, so you enjoy the thrill of working somewhere so risky). The company just paid a dividend of $1 and dividends are expected to grow at 5% per year. The

    		•
  • Q : Minimum pretax earnings XYZ Company is

    XYZ Company is planning to acquire a machine which will cost $200,000, that will last for 4 years. The company employs straight-line depreciation. The tax rate of XYZ is 35% and the proper discount rate in this situation is 12%. (A

    		•
  • Q : How could prestigious investment bank

    I have a doubt about the Enron case. How could this prestigious investment bank advice investing while the quotations of the shares were falling?

    		•