--%>
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 : What is the value of stock Brushy

    Brushy Mountain Mining Company's ore reserves are being depleted, so its sales are falling. Also, its pit is getting deeper each year, so its costs are rising. As a result, the company's earnings and dividends are declining at the constant rate of 5% per year. I

    		•
  • 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 : Public Finance which type of tax,

    which type of tax, direct or indirect is applicable in underdeveloped countries? Why? Show your critical areas and weaknesses.

    		•
  • Q : Explain merits and demerits of standard

    Explain merits and demerits of standard market practice to find the volatility as a function of underlying.

    		•
  • Q : Does the equity of shareholders have

    Does the equity of shareholders represents the savings a company has accumulated by the years?

    		•
  • Q : Finance You expect KT industries (KTI)

    You expect KT industries (KTI) will have earnings per share of $3 this year and expect that they will pay out $1.50 of these earnings to shareholders in the form of a dividend. KTI's return on new investments is 15% and their equity cost of capital is 12%. The value of a share of KTI's stock is clos

    		•
  • Q : PV of Dividends PV of dividends:

    PV of dividends: Cortez, Inc., is expecting to pay out a dividend of $2.50 next year. After that it expects its dividend to grow at 7 percent for the next four years. What is the present value of dividends over the next five-year period if the required rate of return is 10 percent?

    		•
  • Q : Long-Term Financing Needed Long-Term

    Long-Term Financing Needed : - At year-end 2012, total assets for Ambrose Inc. were $1.2 million and accounts payable were $375,000. Sales, which in 2012 were $2.5 million, are expected to increase by 25% in 2013. Total ass

    		•
  • Q : Data Case Please assist with the

    Please assist with the attached Data Case assignment

    		•
  • Q : Why is Split useful Why is Split useful?

    Why is Split useful?

    		•