To see how much of this month's EMI is interest, multiply your outstanding balance by the monthly interest rate, then divide that by the EMI. The result is the interest share. On a typical loan it falls over time, which is why early instalments feel like they barely touch the balance.
What is the formula?
- Find the monthly rate: take the yearly rate printed on your statement and divide it by 12. A 9 per cent yearly rate becomes 0.75 per cent a month, which is 0.0075.
- Interest this month = outstanding balance at the start of the month x monthly rate.
- Interest share = interest this month divided by the EMI, shown as a percentage.
- Principal in this month's EMI = EMI minus the interest.
Your lender may calculate interest by the day, or use a slightly different method, so your statement can differ by a few rupees. Treat this as a check that you understand the loan, and rely on the statement for exact numbers.
What does it look like at three points of a loan?
Take an invented loan of ₹10,00,000 at 9 per cent a year for ten years, with an EMI of about ₹12,668. The figures below are rounded to the nearest rupee.
| Point in the loan | Balance at start of month | Interest this month | Interest share of EMI | Principal in the EMI |
|---|---|---|---|---|
| Month 1 | ₹10,00,000 | ₹7,500 | about 59 per cent | about ₹5,168 |
| Month 60 (year 5) | ₹6,18,239 | ₹4,637 | about 37 per cent | about ₹8,031 |
| Month 108 (year 9) | ₹1,56,279 | ₹1,172 | about 9 per cent | about ₹11,496 |
In month 1, ₹10,00,000 times 0.0075 is ₹7,500, and ₹7,500 divided by ₹12,668 is about 0.59. In month 60, ₹6,18,239 times 0.0075 is about ₹4,637, and that is about 37 per cent of the EMI. In month 108 the interest is just ₹1,172, a small part of the same EMI.
Why does the share fall as the loan ages?
Interest is charged on what you still owe. Each EMI repays a bit of principal, so next month's balance is lower, so next month's interest is lower, and more of the same EMI goes to principal. The EMI stays the same while the split moves.
How do you find the monthly rate from your own statement?
If your statement shows the yearly rate, divide it by 12. If it does not, work it backwards from one month. Take a month's interest from the statement, divide it by the balance at the start of that month, and you have the monthly rate. For example, ₹3,150 of interest on a balance of ₹4,20,000 gives 0.0075, or 0.75 per cent a month.
In a sheet, with the balance in B2, the yearly rate as a percentage in B3 and the EMI in B4, these formulas work in Excel and Google Sheets:
- =B2*(B3/100)/12 gives this month's interest.
- =(B2*(B3/100)/12)/B4 gives the interest share, which you can format as a percentage.
- =B4-(B2*(B3/100)/12) gives the principal part of the EMI.
Why does this check matter?
It tells you how much of each rupee of EMI is reducing what you owe. It also helps when you are deciding whether to make a prepayment, because you can see how much interest sits in the next few instalments. Whether to prepay is a financial decision for you, ideally with advice from someone who can see your whole picture.
SpendixAI can total the EMI debits from an imported bank statement, but the interest and principal split has to come from the lender's own loan statement.
A quick routine
- Pick this month's statement balance, rate and EMI.
- Run the three formulas above.
- Compare the interest figure with the statement.
- Write the interest share down once a quarter to see it fall.
Useful ideas start with a clearer picture of your own spending.
Explore your reports

