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

Being In Someone's Shoes

I am back here after a long break. Many things happened in those years. I have changed a little i guess in those years. Maybe I will write a...