--%>

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 : Intrnational financer what are the

    what are the objectives of international finance

  • Q : Data Case Please assist with the

    Please assist with the attached Data Case assignment

  • Q : Which taxes do I have to use for

    Which taxes do I have to utilize when calculating Free Cash Flow (FCF) – is this the medium tax rate or the marginal tax rate of the leveraged company?

  • Q : Explain Butterfly Spread Strategies

    Butterfly Spread Strategies: In this strategy, there is no limit on the number of options that can be combined to form the butterfly spread. This strategy essentially combines both the bear spread and the bull spread. In this case, options with three

  • 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 : Commercial bank problems For an

    For an enhanced understanding of banking industry, it is significant to look at the atmosphere in which commercial banks operate. Production growth and globalization are two main forces reshaping the banking industry nowadays. The following two questions are associate

  • Q : Vanilla Bonds-Corporate Bonds Define

    Define the term Vanilla Bonds regarding Corporate Bonds?

  • Q : Price per share for Corporation For XYZ

    For XYZ Corporation debt-to-equity ratio, marginal tax rate, and dividend payout ratio are all of 40%. The cost of debt is 10%. Cambria contains 1 million shares of common stock, and $25 million in long-term bonds. Its dividend is $1 per share. Determine the EBIT and

  • 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 : How companies accuse investors make

    Sometimes, companies accuse investors of performing credit sales which they make their quotations fall. Is it true?