--%>
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 : Long-Term Debt What are Long-Term Debt

    What are Long-Term Debt and what are their main parts.

    		•
  • Q : How economic doctrine relies on

    I read in a sentence passed through the Supreme Court that, so as to value companies, economic doctrine relies upon intermediary methods among ‘Anglo-Saxon’ theoretical models and the practical models common in the United

    		•
  • Q : Is the given affirmation of an

    Is the given affirmation of an accountancy expert true? “There valuation criterion that reflects the value of the shares of a company in the most accurate way is based on the amount of the equity of shareholder of its balance sheet. Stating that the value of sha

    		•
  • Q : Data Case Please Assist with the

    Please Assist with the attached Data Case Assignment

    		•
  • Q : Yield to maturity problem Jenny is

    Jenny is looking to invest in some 5-year bonds which pay annual coupons of 6.25 % and are presently selling at $912.34. What is the present market yield on these bonds? (Round to the closest Answer.) (1) 9.5%  (2) 8.5%  (3) 6.5%  (4) 7.5%

  • Q : Is it possible to use a constant WACC

    Is this possible to use a constant WACC in the valuation of a company along with a changing debt?

    		•
  • Q : What is Project Budget Project Budget :

    Project Budget: Collecting all costs related with completing a project is budget process. The Project Management Institute states that "aggregating the predictable costs of individual actions or work projects (establishing) an authorized cost baseline

    		•
  • Q : Define stock variable Stock variable :

    Stock variable: It is a variable whose value is measured or evaluated at a point of time.

    		•
  • 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.

  • Q : Is the price of futures the excellent

    Is the price of futures the excellent estimate of €/$ exchange rate?

    		•