Question

Suppose that you took a mortgage of Rs.1,00, 000 on a house to be paid back...

Suppose that you took a mortgage of Rs.1,00, 000 on a house to be paid back in full by 5 equal annual instalments, each consisting of the interest due on the outstanding balance plus a repayment of a part of the amount borrowed. If you decided to clear the mortgage after second year, how much money would you need to pay on top of the 2nd instalment, assuming that a constant annual compounding rate of 8% applies throughout the period of the mortgage?

Homework Answers

Answer #1

Formulas Used:-

Annual Installment required=PMT(B77,B76,-B75)


upfront to be paid in 2nd installment=FV(B77,2,B79,-B75)

Answer without excel:-

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
8. When you purchased your​ house, you took out a​ 30-year annual-payment mortgage with an interest...
8. When you purchased your​ house, you took out a​ 30-year annual-payment mortgage with an interest rate of 10 % per year. The annual payment on the mortgage is $ 10,918. You have just made a payment and have now decided to pay the mortgage off by repaying the outstanding balance. a. What is the payoff amount if you have lived in the house for 10 years​ (so there are 20 years left on the​ mortgage)? b. What is the...
When you purchased your​ house, you took out a​ 30-year annual-payment mortgage with an interest rate...
When you purchased your​ house, you took out a​ 30-year annual-payment mortgage with an interest rate of 10% per year. The annual payment on the mortgage is $14,909. You have just made a payment and have now decided to pay the mortgage off by repaying the outstanding balance. a. What is the payoff amount if you have lived in the house for 18 years​ (so there are 12 years left on the​ mortgage)? b. What is the payoff amount if...
Question 2. You have approached Commonwealth Bank for a loan to buy a house. The bank...
Question 2. You have approached Commonwealth Bank for a loan to buy a house. The bank offers you a $500 000 loan, repayable in equal monthly instalments at the end of each month for the next 30 years. Required: a. If the interest rate on the loan is 4.5% per annum, compounded monthly, what is your monthly repayment (to the nearest dollar)? b. What is your weekly payment if you wish to pay weekly instalments and the interest rate is...
1. You receive a ​$5 comma 000 check from your grandparents for graduation. You decide to...
1. You receive a ​$5 comma 000 check from your grandparents for graduation. You decide to save it toward a down payment on a house. You invest it earning 6​% per year and you think you will need to have ​$10 comma 000 saved for the down payment. How long will it be before the ​$5 comma 000 has grown to ​$10 comma 000 ​? To double the money you received from your​ grandparents, it will take nothing years.  ​(Round...
Why do you suppose the marketing of the tax shelters at KPMG grew so fast? a.Transformational...
Why do you suppose the marketing of the tax shelters at KPMG grew so fast? a.Transformational leadership b. Moral manager c. Social learning theory d. Moral intensity [The following information applies to the question.] In Chapter 4 we discussed the artificial tax shelter arrangements developed by KPMG LLP for wealthy clients that led to the settlement of a legal action with the Department of Treasury and the Internal Revenue Service. On August 29, 2005, KPMG admitted to criminal wrongdoing and...
Please read the article and answear about questions. Determining the Value of the Business After you...
Please read the article and answear about questions. Determining the Value of the Business After you have completed a thorough and exacting investigation, you need to analyze all the infor- mation you have gathered. This is the time to consult with your business, financial, and legal advis- ers to arrive at an estimate of the value of the business. Outside advisers are impartial and are more likely to see the bad things about the business than are you. You should...
Chick-fil-A is dominating the U.S. fast-food market. Whereas McDonald’s, Subway, Burger King, and Taco Bell trudge...
Chick-fil-A is dominating the U.S. fast-food market. Whereas McDonald’s, Subway, Burger King, and Taco Bell trudge along at the top of the heap, Chick-fil-A has quietly risen from a South- east regional favorite to become the largest chicken chain and the eighth-largest quick-service food purveyor in the country. The chain sells significantly more food per restaurant than any of its competitors—twice that of Taco Bell or Wendy’s and more than three times what the KFC Colonel fries up. And it...
Fueling Indonesians: Window of Opportunity or Regret? Kerosene is widely used as cooking fuel by Indonesian...
Fueling Indonesians: Window of Opportunity or Regret? Kerosene is widely used as cooking fuel by Indonesian households, with an annual usage of 10 million Kiloliters. It is a major subsidized fuel for household cooking, where its usage is over sixty percent of the 230 million population. The subsidy program costs the government heavily, where it amounts up to U.S.$4 billion a year. As the practice tends to bleed government expenditures quite heavily, the Indonesian government is embarking on a change...
Mattel Responds to Ethical Challenges Business Ethics This case was written by Debbie Thorne, John Fraedrich,...
Mattel Responds to Ethical Challenges Business Ethics This case was written by Debbie Thorne, John Fraedrich, O. C. Ferrell, and Jennifer Jackson, with the editorial assistance of Jennifer Sawayda. This case was developed for classroom discussion rather than to illustrate either effective or ineffective handling of an administrative, ethical, or legal discussion by management. All sources used for this case were obtained through publicly available material. Mattel, Inc. is a world leader in the design, manufacture, and marketing of family...
What tools could AA leaders have used to increase their awareness of internal and external issues?...
What tools could AA leaders have used to increase their awareness of internal and external issues? ???ALASKA AIRLINES: NAVIGATING CHANGE In the autumn of 2007, Alaska Airlines executives adjourned at the end of a long and stressful day in the midst of a multi-day strategic planning session. Most headed outside to relax, unwind and enjoy a bonfire on the shore of Semiahmoo Spit, outside the meeting venue in Blaine, a seaport town in northwest Washington state. Meanwhile, several members of...