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

Popular Posts

Featured Post

Can't You Take A Few More Steps

Recently a friend of mine asked his sister whether she couldn't take a few steps to help him out. It happens that she had done plenty fo...