--%>
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 : Calculating Beta when market

    A company with a market capitalization of $100 million has no debt and a beta of 0.8. What will its beta be after it borrows $50 million (giving that there are no other changes and no taxes)?

    		•
  • Q : What is optimal capital structure What

    What is optimal capital structure?

    		•
  • Q : Is there any optimal capital structure

    Is there any optimal capital structure?

    		•
  • Q : Explain usual value of the sales of net

    Does the usual value of the sales and of the net income of Spanish companies have anything to do along with sustainable growth?

    		•
  • Q : Is book value the excellent proxy to

    Is book value the excellent proxy to the value of the shares?

    		•
  • Q : Commercial Banking Assignment Part I

    Part I Guidelines and requirements: The questions in Part I of this assignment are based on the materials covered in Units 1 and 2. Please write a short-ess

    		•
  • Q : Explain the structure

    Our company (A) is going to buy the other company (B). We need to value the shares of B and, thus, we will use three options of the structure Debt/Shareholders’ Equity in order to obtain the WACC as: 1) Present structure of A

    		•
  • Q : Sinking Fund problem Berks Corporation

    Berks Corporation is expecting to have EBIT next year of $12 million, with a standard deviation of $6 million. Berks have $30 million in bonds with coupon of 10%, selling at par, which are being retired at the rate of $2 million annually. Berks also have 100,000 share

    		•
  • Q : Standard deviation of portfolios returns

    Assume that you have $50,000 which you want to invest in two companies, XYZ Books and ABC Audio. XYZ has a return of 10% and standard deviation 15%, while ABC has return of 15% with a standard deviation of 20%. The correlation coefficient between them is .5. Your port

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

    		•