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 : 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 : APR of Loan When you take out an $8,000

    When you take out an $8,000 car loan that calls for 48 monthly payments of $225 each, then what is the APR of loan?

  • Q : Discretion can distort results Discuss

    Discuss how management’s discretion in applying accounting rules can mislead investors. Provide three examples and how the discretion can distort results?

  • Q : Set of conflicts in reducing working

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

  • Q : Explain influences of financial

    Does financial leverage (i.e. debt) have any influence on the Free Cash Flow, upon the Cash Flow to Shareholders, upon the growth of the company and upon the value of the shares?

  • Q : Is it possible to use a constant WACC

    Is this possible to use a constant WACC in the valuation of a company along with a changing debt?

  • Q : Weighted return and simple return to

    What is the difference between weighted return and simple return to shareholders?

  • Q : State capital formation Capital

    Capital formation: It is an increase in the stock of capital in particular period is termed as capital formation.

  • Q : Explain Corporate Development Corporate

    Corporate Development: Corporate development is a term which references the range of planning options and strategies which can assist to move a company toward its targets. The procedure of this kind of strategic development can be exerted to just abou

  • Q : How could we acquire an indisputable

    How could we acquire an indisputable discount rate?

©TutorsGlobe All rights reserved 2022-2023.