--%>
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 : Explain undervaluation of share on the

    Suppose we calculate g as ROE (1–p)/(1–ROE (1–p)) and the Ke by the CAPM. We replace both values into the formula PER = (ROE (1+g) – g)/ROE (Ke-g) but there PER we obtain is fully different from the one we get by dividing the quotation of the s

    		•
  • Q : What is Net Operating Profit after Tax

    What is Net Operating Profit after Tax (NOPAT)?

    		•
  • Q : What is optimal capital structure What

    What is optimal capital structure?

    		•
  • Q : Zero coupon bonds problem Shana wants

    Shana wants to purchase 5-year zero coupon bonds with a face value of $1,000. Her opportunity cost is 8.5 %. Supposing annual compounding, what would be the present market price of such bonds? (Round to the closest dollar.) (a) $1,023  (b) $665  (c) $890&nbs

    		•
  • Q : Which parameter good measures value

    Which parameter good measures value creation; the Economic Value Added (EVA), the CVA (Cash Value Added) or the economic profit?

    		•
  • Q : Data Case Please Assist with the

    Please Assist with the attached Data Case Assignment

    		•
  • Q : Illustrates cost of its equity is zero

    Is this true that the cost of its equity is zero, if a company does not distribute dividends?

    		•
  • Q : Profitability Ratios Profitability

    Profitability Ratios: These ratios comprise the Gross profit Margin, Net profit Margin, Operating Margin, Return on Equity (ROE), and Return on Total Assets. Such ratios help the firm to examine its profitability, the trend in profits and aid to take

    		•
  • Q : Define the term Stock Market crash

    Stock Market Crash was responsible for the Great Depression. Middle class families lost all their savings as they had gambled the market on margin.Those banks which were under the loan ofbrokers’ started removing money out of the savings account

    		•
  • Q : Is this better to repurchase shares or

    Assuming a company needs to distribute money to shareholders of it, is this better to repurchase shares or to distribute dividends?

    		•