--%>
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 : Explain the working of breakthrough for

    Explain the working of breakthrough in low-discrepancy sequences used for option valuation.

    		•
  • Q : Bond Price Information What is Bond

    What is Bond Price Information: Answer: Corporate bond market is not considered to be much transparent as it trades predominantly over the counter and investors do n

    		•
  • Q : Who was the first to quantify the idea

    Who was the first to quantify the idea of Brownian motion?

    		•
  • Q : Explain the Monte Carlo evaluation of

    Explain the Monte Carlo evaluation of integrals.

    		•
  • Q : Did you see Vueling case Did you notice

    Did you notice the Vueling case? How is this possible that an investment bank sets the objective price of its shares in €2.50 per share upon the 2nd of October, 2007, just after replacing Vueling shares at €31 per share in J

    		•
  • Q : Widgets You are required to submit a

    You are required to submit a bid to supply 200,000,000 widgets per year to the State of Illinois for the next five years. Your company has an idle tract of real estate that cost $1,500,000 ten years ago; if your company sold the land today, it would generate $3,000,000 after the taxes were paid. The

    		•
  • Q : Finance I need the answers for the

    I need the answers for the midterm exam for FIN6000

    		•
  • Q : Explain accurately value bond options

    If the model could not even find bond prices right, how could this hope to accurately value bond options?

    		•
  • Q : State Exploitation of favorable market

    Exploitation of favorable market conditions: The firms after estimating WCR are in a position to clearly identify their status of excess current assets. After this realization they can use this knowledge to encash conditions arising in market even for

    		•
  • Q : Explain Value Chain Value Chain : The

    Value Chain: The value chain is a theory from business management that was first described and popularized Michel Porter in his 1985 best seller, Competitive Advantage: Creating and Sustaining Superior Performance.