EMI stands for equated monthly instalment: a fixed amount you pay every month until a loan is cleared. Each EMI is a mix of two parts, interest on the money you still owe and principal that reduces the loan. The amount stays the same, but the mix changes, because as the balance falls the interest part shrinks and the principal part grows.
How is an EMI worked out?
The standard formula is EMI = P × r × (1 + r)^n ÷ ((1 + r)^n - 1), where P is the loan amount, r is the interest rate for one month (annual rate divided by 12) and n is the number of months. In Excel or Google Sheets, the same result comes from =PMT(rate/12, months, -loan). You do not need to do it by hand, but it helps to know the three inputs: amount, rate, tenure.
Your lender's schedule is the final word, as rounding and the exact date calculations differ slightly. The aim here is to understand the pattern.
What does a small loan look like instalment by instalment?
Take an invented loan of ₹1,20,000 at 12% a year (1% a month) for 12 months. The EMI works out to about ₹10,662. Here is how three of the twelve instalments split:
| Instalment | Balance before (₹) | Interest (₹) | Principal (₹) | Total paid (₹) |
|---|---|---|---|---|
| 1st | 1,20,000 | 1,200 | 9,462 | 10,662 |
| 6th | 71,735 | 717 | 9,945 | 10,662 |
| 12th | 10,556 | 106 | 10,556 | 10,662 |
In the first month, interest is 1% of ₹1,20,000, which is ₹1,200, so ₹9,462 reduces the loan. By the sixth month the balance has fallen to about ₹71,735, so interest is only about ₹717. In the last month almost the whole instalment is principal. Over the 12 months you pay roughly 12 × 10,662 = ₹1,27,942, of which about ₹7,942 is interest.
Why does the interest share fall over time?
Interest is charged on what you still owe. Each month you repay some principal, so next month's balance is smaller and so is the interest on it. Since the EMI is fixed, the freed-up part goes to principal. This is why early instalments on long loans feel like they barely dent the debt: on a long home loan, the first years carry a large interest share.
How can I see the split in a sheet?
- EMI: =PMT(0.01, 12, -120000) gives about 10,661.85
- Interest in the 6th instalment: =IPMT(0.01, 6, 12, -120000)
- Principal in the 6th instalment: =PPMT(0.01, 6, 12, -120000)
- Check: the two should add up to the EMI
Change the 6 to any instalment number to see its split. These functions work the same way in Excel and Google Sheets.
What happens if the tenure is longer?
Keep the same invented ₹1,20,000 at 1% a month but stretch it to 24 months. The EMI falls to about ₹5,649, which feels lighter. But you now pay roughly 24 × 5,649 = ₹1,35,571 in total, so interest is about ₹15,571 instead of ₹7,942. A smaller EMI is not a cheaper loan; it is a slower one that costs more in interest. The reverse also holds: a shorter tenure raises the EMI but lowers total interest.
That trade-off is worth checking in a sheet with =PMT(0.01, 24, -120000) before you accept any tenure offered to you.
What should I do with this knowledge?
Three practical things. First, when comparing loans, look at total interest as well as the EMI. Second, if you ever make a prepayment, it works on the principal, so earlier prepayments save more interest than later ones. Third, when you track spending, decide whether to log the whole EMI or split it; that choice is covered in other articles. SpendixAI can record the full EMI debit from a statement as one transaction, which is enough for most monthly reviews.
Rates and terms differ by lender and loan, so treat all figures here as a learning example, not a quote.
Useful ideas start with a clearer picture of your own spending.
Explore your reports

