--%>
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 : Vanilla Bonds-Corporate Bonds Define

    Define the term Vanilla Bonds regarding Corporate Bonds?

    		•
  • Q : Explain valuation method for

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

    		•
  • Q : How companies accuse investors make

    Sometimes, companies accuse investors of performing credit sales which they make their quotations fall. Is it true?

    		•
  • Q : Is it correct to use valuation of

    Is this correct to use in the valuation of the shares of a certain company the “the real net assets value” which, as per to the Institute of Accounting and Auditing (ICAC), shows the “book value of shareholder’s equity, corrected through increa

    		•
  • Q : Cost of Equity AB Corporation has 16%

    AB Corporation has 16% cost of equity, 35% tax rate, and debt-to-equity ratio of 30%. XY Corporation has 30% tax rate and debt-to-equity ratio of 40%. Both AB and XY are in the same business of selling automotive parts. If the riskless rate is 4% and the expected retu

    		•
  • Q : Why required return cannot computed by

    Why can we not compute the required return (Ke) by the Gordon-Shapiro model [P0 = Div0 (1+g) / (Ke – g)] in place of using the CAPM? As we identify the current dividend (Div0) and the current share price (P0), we can acquire the growth rate of the dividend by th

    		•
  • Q : Problem on exponential growth rate

    Atlanta Company stock is predicted to follow an exponential growth rate. The relationship among the current stock price P0, future price PT after time T, and continuously compounded rate of the return r, is: PT = P0eγT. The stock doesn’t pay any

    		•
  • Q : Intrnational financer what are the

    what are the objectives of international finance

    		•
  • Q : Define Effective Utilization of Funds

    Effective Utilization of Funds: It is just the decision to maximize the return on investment of funds. When finance manager is not capable to raise the return by investing fund in profitable assets or other profitable projects, company’s busines

    		•
  • Q : Is this possible to make money in the

    Is this possible to make money in the stock market while the quotations are going down? And what is credit sale?

    		•