--%>
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 : Minimum annual savings problem XYZ

    XYZ Company is interested in purchasing a new corporate jet for $6 million. This will depreciate the jet completely in 5 years and then sell it for $5 million. The jet will utilize $60,000 in fuel annually, and its maintenance will be $40,000 yearly. The tax rate of X

    		•
  • Q : Explain the Monte Carlo evaluation of

    Explain the Monte Carlo evaluation of integrals.

    		•
  • Q : Explain Cost of capital aspect Cost of

    Cost of capital aspect: Estimation of WCR is beneficial from the point of view of cost of capital too. A sound working capital position is beneficial from the point of view of both owners and lenders of the company. A sufficiently positive position me

    		•
  • Q : Explain valuation method for

    We were assigned a valuation of a pharmaceutical laboratory’ shares. Which valuation method is further convenient?

    		•
  • Q : CAPM-Project Evaluation and Risk

    UCD Vet Products – a hypothetical publicly traded corporation (UCDV) — is considering investing in a new line of equine DNA analysis technology for race horse breeders. The project will yield the net cash flows listed in the table below. Assume that this p

    		•
  • Q : How present value of tax shields be

    I have two valuations of the company that we set as an objective. Within one of them, the present value of tax shields (D Kd T) computed using Ku (required return to unlevered equity) and, in one, by using Kd (required return to debt). The second valuation is too high

    		•
  • Q : Financial engineering financial

    financial engineering examples,benifits,disadvantages

    		•
  • Q : Iterative System Solvers Iterative

    Iterative System Solvers, Power Methods, and the Inverse Power Method for Boundary Value Problems. 1. Code and test Jacobi and Gauss-Sidel solvers for arbitrary diagonally dominant linear systems. 2. Compare performance/results with tridiagonal Gaussian elimination so

    		•
  • Q : Problem on Stock per share value ABC

    ABC Company plans to buy back 1 million shares of its own stock from its cash reserves at $50 a share. This will raise the bankruptcy costs by $10 million, and the debt/assets ratio from 35% to 40%. The income tax rate of the company is 30%. Determine the value of the

    		•
  • Q : Explain few Spanish mutual funds

    Is this true that very little Spanish mutual funds outperform their benchmark? Isn’t this strange?

    		•