Actionable insights on equities, fixed-income, macros and personal finance Start 14-Days Free Trial
Actionable investing insights Get Free Trial
Charts & Analysis

EMI Principal and Interest Calculator


I was asked how EMI interest and principal works – the idea of that is kinda complex, like the calculation describes. But the essential funda is: Take the total amount payable, pay the interest first and the remaining part of your EMI is the principal. You can calculate this easily using spreadsheet functions like PMT, PPMT and IPMT. I have demonstrated this, on a monthly basis, by using this excel sheet:

This is just for 12 months but you can extend it for any number of months.

You can find out exactly how much you’ve repaid at any month and how much is left, and of course, you see how your interest is front loaded on any such loan.

You can view the spreadsheet or download in Excel format.


Like our content? Join Capitalmind Premium.

  • Equity, fixed income, macro and personal finance research
  • Model equity and fixed-income portfolios
  • Exclusive apps, tutorials, and member community
Subscribe Now Or start with a free-trial