--%>

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 Indenture Explain the term

    Explain the term Indenture and also describe their provisions?

  • Q : Convertible Bonds-Corporate Bonds State

    State the term Convertible Bonds in Corporate Bonds?

  • Q : Explain Financial Management Financial

    Financial Management: It means organizing, planning, directing and controlling the financial activities like procurement and use of funds of enterprise. This means exerting general management principles to the financial resources of enterprise. <

  • Q : CAPM-Project Evaluation and Risk

    UCD Vet Products – a hypothetical publicly traded corporation (UCDV) — is considering investing in a new line of equine DNA analysis technology for race horse breeders. The project will yield the net cash flows listed in the table below. Assume that this p

  • Q : How can auditor spot acts of creative

    How can auditor spot acts of creative accounting? Means let an illustration, the excess of provisions or the non-elimination of intra group transactions along with value added.

  • Q : Does value of the company increase when

    According to the valuation method depends on tax shields, the value of the company (Vl) is the value of the unleveraged company (Vu) in addition with the value of tax shields (VTS), thus, the higher the interest and the higher the VTS. Therefore, does

  • Q : Problem on implied exchange rate a) The

    a) The Australian firm sold a ship to a Swiss firm and gave the Swiss client an option of paying either AUS10,000 or SF15,000 in 9 months. (i) In above, the Australian firm efficiently gave the Swiss client a free option to buy up

  • Q : Bank assignment You have just been

    You have just been hired as the branch manager for a big bank in XYZ. You were told that the bank is going to open a new branch at Island Learning Centre of the Open University of XYZ. The management of the bank is much concerned that the new branch might not be able

  • Q : Problem on financial manager

    Assume that you are a financial manager of Yuen Cheong Manufacturng Company. Due to the rising demand of product X, Yuen Cheong Manufacturng Company decides to open a new production plant in China, so it needs to take a loan of US$1 million. Bank A offers Yuen Cheong

  • Q : All rates are stated annually with

    1 Assume the following (all rates are stated annually with semiannual compounding) a. Six Month Spot Rate is 2% b. Six Month Forward rate starting at month six is 2.2% c. Six Month Forward rate starting at month 12 is 2.4% d. Six Month Forward rate starting at mont