--%>
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 : Define the term Commercial Paper

    Commercial Paper: It is an unsecured obligation issued by the corporation or bank to finance its short-term credit requirements, like accounts inventory and receivable. Maturities usually range from 2 to 270 days. The commercial paper is accessible in

    		•
  • 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 : Working Capital - Current Assets and

    I do not know the meaning of Working Capital Requirements. I think this should be same to Working Capital (Current Assets – Current Liabilities). There am I right?

    		•
  • Q : Portfolio return probability XY Company

    XY Company has made a portfolio of such three securities: The correlation coeffic

    		•
  • Q : What is Financial Analysis Financial

    Financial Analysis: It is the investigation and interpretation of financial statements and associated financial reports. Trained and certified accountants generally complete this kind of analysis. The role of a financial analyst is to

    		•
  • Q : What is the impact of auto portfolio

    What is the impact of auto portfolio into the quotation of the shares?

    		•
  • Q : Finc . A&B Enterprises is trying to

    . A&B Enterprises is trying to select the best investment from among four alternatives. Each alternative involves an initial outlay of $100,000. Their cash flows follow: Year A B C D 1 $10,000 $50,000 $25,000 $ 0 2 20,000 40,000 25,000 0 3 30,000 30,000 25,000 45,0

    		•
  • Q : Problem on leasing Johnathan Lewis is

    Johnathan Lewis is looking into the possibility of buying several coin-operated vending machines and put them in local hospitals. Each machine costs $2000, that he will depreciate on a straight-line basis over 8 years. The machine will dispense soft-drink cans at 75 c

    		•
  • Q : Evaluating Beta of a Corporation

    Baldwin Corporation is planning to expand into the business of providing on-demand movies. Baldwin has debt-to-equity ratio of .25, its pretax cost of debt is 9%, and its marginal tax rate is 40%. The Harrington Corporation is already in the on-demand movie business,

    		•
  • Q : Set of conflicts in reducing working

    Give an illustration of a set of conflicts encountered when attempting to reduce working capital?

    		•