--%>

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 Initial public offering or IPO

    Initial public offering: An initial public offering (IPO) otherwise called as stock market launch, is the first time company selling stock to public. Usually raised for capital expansion and to become publicly traded company. Investment banking firms

  • Q : Public Finance which type of tax,

    which type of tax, direct or indirect is applicable in underdeveloped countries? Why? Show your critical areas and weaknesses.

  • Q : WCR lower cost of storage Inventory is

    Inventory is an important part of WCR estimation. It is a current asset, which depletes over period of time. Also, it requires creation of facility, which would help in storing the inventory and estimate the associated cost of maintaining and transporting it. The esti

  • Q : DCF Analysis AB Corp. is in the

    AB Corp. is in the business of making white-board markers. They are computing the potential of investing in some new equipment that will enhance their manufacturing process.  The initial cost of the latest machinery is $470,000 plus a one-time installation cost o

  • Q : How present value of tax shields be

    I have two valuations of the company that we set as an objective. Within one of them, the present value of tax shields (D Kd T) computed using Ku (required return to unlevered equity) and, in one, by using Kd (required return to debt). The second valuation is too high

  • Q : Relationship between the preferred

    Quetion: A private equity fund invests $100 million into a portfolio company and receives 100% of the preferred stock and 80% of the common stock of the company.  The preferred stock carries a face value of $1

  • 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 : Calculating Super normal profit The

    The case study of an economic analysis is done for Schlumberger, oilfield Service Company.  They are No. 1 in terms of market caps, revenue and employees globally. When any references are used/outside sources (except for Schlumberger's annual reports and financia

  • Q : Overview of capital market efficiency

    Provide a brief overview of Capital Market Efficiency?

  • Q : Problem regarding purchasing machine

    Alger Corp needs to buy some construction equipment for $50,000 that has a helpful life of 4 years with no salvage value. The Alger utilizes straight-line depreciation. Alger contains a tax rate of 30%, and it employs a discount rate of 10%. The equipment will produce