--%>
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 : How economic doctrine relies on

    I read in a sentence passed through the Supreme Court that, so as to value companies, economic doctrine relies upon intermediary methods among ‘Anglo-Saxon’ theoretical models and the practical models common in the United

    		•
  • Q : Broad research methodologies Various

    Various broad research methodologies are available with which to study the development of accounting theory. a. Discuss the deductive, inductive, normative, and empirical research methods.  

  • Q : Understand and interpret financial

    Our purpose this week: learning how to understand and interpret financial statements. Assignment: The class should discuss all of the questions listed below as they rel

    		•
  • Q : Historical return on stock market and

    The market risk premium is difference among the historical return upon the stock market and the risk-free rate, for yearly. Why is this negative for some years?

    		•
  • Q : What is Net Operating Profit after Tax

    What is Net Operating Profit after Tax (NOPAT)?

    		•
  • Q : Compute betas against local indexes

    Does it make any sense to compute betas against local indexes while a company has a great part of its operations outside such local market? I have two illustrations: BBVA and Santander.

    		•
  • Q : Low-discrepancy sequence or quasi

    Who proposed definition and development of low-discrepancy sequence theory or quasi random number theory?

    		•
  • Q : How WACC should be computed to begin a

    I cannot seem to begin a valuation. In order to compute E + D = VA (FCF; WACC) I require the WACC and to compute the WACC I need D and E. Where must I start?

    		•
  • Q : Which data is the most suitable for

    Which data is the most suitable for finding betas?

    		•
  • Q : Data races-critical sections-processor

    A) Research the phenomena of data races. Give an illustration of how an unprotected data race can give mount to data inconsistency.How do OpenMP and Cilk resolve this problem? B) Present your own fully documented and tested program

    		•