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 : Calculating Super normal profit The

    The case study of an economic analysis is done for Schlumberger, oilfield Service Company.  They are No. 1 in terms of market caps, revenue and employees globally. When any references are used/outside sources (except for Schlumberger's annual reports and financia

  • Q : Problem on stock market John Wong is a

    John Wong is a fresh graduate and has a limited amount of funds for investments. He expects that the Hong Kong stock market will fall soon but he is not familiar with derivatives. In order to gain more money to buy a car, he explores engaging in Hang Seng Index (HSI)

  • Q : Explain market efficiency hypothesis

    According to what I read inside a book, market efficiency hypothesis means that the expected average value of variations is zero in the shares price. Thus, the best estimate of the future price of a share is its price now, as this incorporates all the available inform

  • Q : Define the term Stock Market crash

    Stock Market Crash was responsible for the Great Depression. Middle class families lost all their savings as they had gambled the market on margin.Those banks which were under the loan ofbrokers’ started removing money out of the savings account

  • Q : Determining Profitable purchasing ABC

    ABC Corporation is interested in purchasing a machine which will cost $50,000, and it will depreciate it on the straight-line basis over a 5-year period. The machine is predicted to last for 7 years and then Milan will sell it for $5,000. The expected earnings before

  • Q : Regarding WACC Regarding the WACC which

    Regarding the WACC which has to be applied to a project, must it be an expected return, the average historical return or an opportunity cost on similar projects?

  • Q : Financial engineering financial

    financial engineering examples,benifits,disadvantages

  • Q : Problem on exponential growth rate

    Atlanta Company stock is predicted to follow an exponential growth rate. The relationship among the current stock price P0, future price PT after time T, and continuously compounded rate of the return r, is: PT = P0eγT. The stock doesn’t pay any

  • Q : Profitability Ratios Profitability

    Profitability Ratios: These ratios comprise the Gross profit Margin, Net profit Margin, Operating Margin, Return on Equity (ROE), and Return on Total Assets. Such ratios help the firm to examine its profitability, the trend in profits and aid to take

  • Q : Does value of the company increase when

    According to the valuation method depends on tax shields, the value of the company (Vl) is the value of the unleveraged company (Vu) in addition with the value of tax shields (VTS), thus, the higher the interest and the higher the VTS. Therefore, does

2015 ©TutorsGlobe All rights reserved. TutorsGlobe Rated 4.8/5 based on 34139 reviews.