--%>
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 : Valuation & Merger analysis Problem

    Problem 21-1 Valuation Harrison Corporation is interested in acquiring Van Buren Corporation. Assume t

    		•
  • 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 : Determine the future value What would

    What would the future value after 5 years of $100 be at 10% compound interest?

    		•
  • Q : Financial statements The concept of

    The concept of conservatism has been influential in the development of accounting theory and practice.  A major effect of conservatism is that accountants tend to recognize losses but not gains.  For example, when the value of an asset is impaired, it is wri

    		•
  • Q : Explain value of shares is Is this

    Is this correct that the value of the shares is, the “value of the results’ capitalization” that, as per to the Institute of Accounting and Auditing (ICAC) shows “the sum of the expected future results of the company throughout a certain period

    		•
  • Q : Expected return and standard deviation

    If an investor is considered to be risk-averse, what is his/her attitude towards expected return and standard deviation?

    		•
  • Q : Explain the Monte Carlo evaluation of

    Explain the Monte Carlo evaluation of integrals.

    		•
  • Q : Financial problem regarding acquistion

    My Company paid an extremely higher price for the acquisition of other company; the price was recommended through the valuation of an investment bank. Now we have financial problems. So is there any way to make this bank legally responsible for such situation?

    		•
  • Q : What is the impact of auto portfolio

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

    		•
  • Q : Who was the first to quantify the idea

    Who was the first to quantify the idea of Brownian motion?

    		•