--%>

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 : All rates are stated annually with

    1 Assume the following (all rates are stated annually with semiannual compounding) a. Six Month Spot Rate is 2% b. Six Month Forward rate starting at month six is 2.2% c. Six Month Forward rate starting at month 12 is 2.4% d. Six Month Forward rate starting at mont

  • Q : Explain the branching structure of the

    Explain the branching structure of the binomial model.

  • Q : Could we explain that the shares’ value

    Could we explain that the shares’ value is intangible?

  • Q : Is depreciation is the loss of value of

    Is the depreciation is the loss of value of fixed assets?

  • Q : Problem on annual lease payments Taurus

    Taurus Corporation needs a computer, which it can buy for $100,000. Taurus will depreciate the computer uniformly over its useful life of 5 years. An investment tax credit of 7% is also available, and the computer will have no residual value. Taurus plans to borrow th

  • 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 : Low-discrepancy sequence or quasi

    Who proposed definition and development of low-discrepancy sequence theory or quasi random number theory?

  • Q : Marketing Decisions & Profitability

    Marketing Decisions Assignment:  Email the answers to the following questions in an attached word document using the proper file name format as follows:  1   

  • Q : Relationship between the preferred

    Quetion: A private equity fund invests $100 million into a portfolio company and receives 100% of the preferred stock and 80% of the common stock of the company.  The preferred stock carries a face value of $1

  • Q : Efficiency Ratios Efficiency Ratios :

    Efficiency Ratios: These ratios comprise Receivables Turnover, Inventory Turnover, Asset Turnover and Net Working Capital Turnover ratios. Efficiency ratios show the utilization of Assets of the company thus as to generate Revenue that is, the best ut