--%>

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 : Estimate stock's current price A

    A company currently pays a dividend of $3.75 per share, D0 = 3.75. It is estimated that the company's dividend will grow at a rate of 15% percent per year for the next 2 years, then the dividend will grow at a constant rate of 7% the

  • Q : Explain definition of put–call parity

    Explain the definition of put–call parity described by Reinach.

  • Q : Problem on HIBOR Below are the

    Below are the three-month HIBOR and three-year EFN futures (that is, Exchange Fund Note) prices for the September 2010 contracts.a) Find out the HIBOR in three-months for settling the future contract utilizing the quotation on August 16.

    Q : Explain the branching structure of the

    Explain the branching structure of the binomial model.

  • Q : What is nonlinearity in option pricing

    What is nonlinearity in option pricing model?

  • Q : An example of use beta of Kinepolis in

    A financial consultant is valuing the company I set as an objective (an entertainment centre) by discounting the cash flows until the end of the dealership at 7.26% (interest rate on 30-year-bonds = 5.1%; market premium = 5%, and Beta = 0.47%). 0.47 is a beta provided

  • Q : What is real gross domestic product

    Real gross domestic product: If GDP of a particular year is estimated or evaluated on the basis of the base year prices it is termed as real gross domestic product.

  • Q : Problem on rules of the International

    RainFlower Trading Limited is a wholesaler of electronic calculators in Hong Kong. It has been importing goods from a Philippine manufacturer for eight years. The Philippine manufacturer had accepted payments in advance in the past. Recently, because of political turm

  • Q : How form a portfolio with higher

    Does this make any sense to form a portfolio comprised of companies along with a higher return/dividend?

  • Q : Explain method to analyze and to value

    Are there any methods to analyze and to value seasonal businesses?