--%>

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 : Which model was great breakthrough for

    Which one model was great breakthrough for side of finance theory?

  • Q : Affect the value of the stock Is the

     Is the value of this stock dependent on how long you plan to hold it? In other words, if your planned holding period were 2 years or 5 years rather than 3 years, would this affect the value of the stock today, P0? Explain your answer.<

  • Q : Is book value the excellent proxy to

    Is book value the excellent proxy to the value of the shares?

  • Q : Corporate Earnings Analysis exercise

    Identify two comparable corporations.  Explain why you think they are comparable to your corporation. Earnings analysis:  Do an earnings analysis of your corporation.  Calculate and plot.

    Q : Difference between capitalization and

    Is the difference for the value creation in a company among the market value of the shares (capitalization) and their book value a good measure since its foundation?

  • Q : Expected return and standard deviation

    If an investor is considered to be risk-averse, what is his/her attitude towards expected return and standard deviation?

  • Q : Investors are irrational or naive

    Explain how companies with substandard financial history can draw the attention of investors. Are investors irrational or naive?

  • Q : Relationship between flow to

    Is there any relationship in between the flow to shareholders and the net income?

  • Q : How much confidence can an investor

    I heard conversation of the Earnings Yield Gap ratio, that is the difference among the inverse of the PER and the TIR on 10-year-bonds. This is said that if this ratio is positive then this is more advantageous to invest in equity. How much confidence can an investor

  • 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