--%>
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 : Define reasonable things that a company

    There are four methods a company can utilize the money this generates: a) Buying other assets or companies; b) Reducing debt of it; c) Distribute this to shareholders, and d) Increasing cash holdings of it.

  • Q : Commercial bank problems For an

    For an enhanced understanding of banking industry, it is significant to look at the atmosphere in which commercial banks operate. Production growth and globalization are two main forces reshaping the banking industry nowadays. The following two questions are associate

    		•
  • 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 : Problem on Bond Price Kevin is

    Kevin is interested in buying a 5-year bond which pays a coupon of 10 % on a semi-annual basis. The present market rate for similar bonds is 8.8 %. What must be the present price of this bond? (Round to the closest dollar.) (a) $1,048  (b) $965  (c) $1,099&n

    		•
  • 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 : Calculated Free Cash Flow I think Free

    I think Free Cash Flow (FCF) can be acquired from the Equity Cash Flow (CFac) using the relation as: FCF = CFac + Interests – ΔD. Is it true?

    		•
  • 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

    		•
  • 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 : Calculating the Cost of Equity You are

    You are an analyst in the financial division of Flipper Industries (FI) which has a beta of 1.80 (you are risk-philic, so you enjoy the thrill of working somewhere so risky). The company just paid a dividend of $1 and dividends are expected to grow at 5% per year. The

    		•
  • Q : What did better mean specified by

    What did ‘better’ mean specified with Markowitz questioned regarding portfolio selection?

    		•