Friday, October 12, 2018

Maths Puzzle - Compound Interest Calculation - Housing Loan, Tenure - EMI

I was discussing the housing loan tenure calculation when the loan amount, Compound Interest Rate, EMI (equated monthly installment). 

Work out the tenure showing the principal outstanding at the end of each year.

The spreadsheet below provides a solution:
https://docs.google.com/spreadsheets/d/1D_wv710bVzbO86KSoVVjizWQExN8FwYxp4BKNJtx_MA/edit?usp=drivesdk 

This being the auspicious week of Navratri, this puzzle is dedicated to all feelers.

No comments:

Post a Comment