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?
Formulas Used:-
Annual Installment required=PMT(B77,B76,-B75)
upfront to be paid in 2nd
installment=FV(B77,2,B79,-B75)
Answer without excel:-
Get Answers For Free
Most questions answered within 1 hours.