--%>

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 : Who explained market-neutral delta

    Who explained market-neutral delta hedging?

  • Q : What is the sales of the firm The

    The financial ratios of a firm are as follows. Current ratio = 1.33 Acid-test ratio = 0.80 Current liabilities = 40,000 Inventory turnover ratio = 6  What is the sales of the firm?

  • Q : Problem on price share and stock

    Brittney and Kim Wan Sun have successfully launched a successful talent agency, ABC. They expect the firm’s earnings and dividends to grow by 20% annually for the next 10 years and they establish a strong base and to grow at a constant 5% per year thereafter. AB

  • Q : Efficient Market Hypotheses Write

    Write Efficient Market Hypotheses in brief?

  • Q : When the dividend shows real money The

    The dividend is the part of the net income which the company distributes to shareholders. When the dividend shows real money, the net income is also real money. Is it true?

  • Q : Determine the future value What would

    What would the future value after 5 years of $100 be at 10% compound interest?

  • Q : Data Case Please assist with the

    Please assist with the attached Data Case assignment

  • Q : Convertible Bonds-Corporate Bonds State

    State the term Convertible Bonds in Corporate Bonds?

  • Q : Problem on Decision variables A factory

    A factory has three distinct systems for making similar product: System 1: Worker runs 3 machines of type-A, each of which costs $20 per day to run, each generates 100 units per day and the worker is paid $40 per day.System 2

  • 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