Your total monthly EMI burden is simply every instalment that leaves your accounts each month added together, and its share of income is that total divided by your take-home pay. The only trick is to include the small ones, such as a phone EMI or a card EMI, because they are easy to forget and they add up.
What exactly goes into the total?
List every fixed instalment you are paying right now: home loan, vehicle loan, personal loan, education loan, gold loan, and any no-cost or card EMI on a purchase. Use the amount that actually leaves your account, which you can read off the last statement, not the amount in the sanction letter. If an EMI changed because of a rate revision, the statement shows the new figure.
What does the sum look like with invented numbers?
| Loan | EMI (₹) | Last EMI |
|---|---|---|
| Home loan | 22,000 | 2041 |
| Two-wheeler loan | 3,800 | Mar 2027 |
| Phone EMI | 2,200 | Aug 2026 |
| Card EMI on a laptop | 1,500 | Jan 2027 |
| Total | 29,500 | - |
22,000 + 3,800 + 2,200 + 1,500 = ₹29,500 a month. If take-home pay is ₹85,000, the share is 29,500 ÷ 85,000 = 0.347, so about 34.7%, or roughly a third of what lands in the account.
How do I show the number in a sheet?
Put the loans in A2:A6 and amounts in B2:B6, then:
- Total EMIs: =SUM(B2:B6)
- Take-home pay in a cell, say B8, then share of income: =B7/B8, formatted as a percentage
- Remaining money after EMIs: =B8-B7
For our example, 85,000 minus 29,500 leaves ₹55,500 for rent, food, school, transport and everything else.
What happens to the number when one EMI ends?
Add a column for the last EMI month and sort by it. In the example, the phone EMI ends first (₹2,200), then the card EMI, then the two-wheeler. Re-run the total after each one finishes:
| After this ends | New total (₹) | Share of ₹85,000 |
|---|---|---|
| Phone EMI | 27,300 | about 32.1% |
| Card EMI as well | 25,800 | about 30.4% |
| Two-wheeler as well | 22,000 | about 25.9% |
The drop is real money that can go to a different use, such as a prepayment, savings or an emergency reserve, only if you decide in advance. Otherwise it quietly gets absorbed by regular spending.
How often should I refresh the figure?
Once a month when you review statements, and whenever you take a new EMI, prepay, or a floating-rate loan changes. A quick way: filter your last statement for EMI debits and tick each against your list. SpendixAI's Report builder lets you filter and group transactions, so if you categorise EMIs consistently you can read the monthly total from a report. Check the amounts against your lender's records before relying on them.
What changes if I use gross pay instead?
Say gross pay is ₹1,10,000 a month and take-home is ₹85,000 after deductions. The same ₹29,500 of EMIs is 29,500 ÷ 1,10,000 = 0.268, or about 26.8% of gross, against 34.7% of take-home. Neither is wrong; they answer different questions. A lender-style view uses the bigger income, while your monthly budget feels the smaller one.
- Write both figures on the page, labelled gross and take-home.
- Use take-home when deciding what you can comfortably add.
- Use the same basis every time you compare, or the trend will mislead you.
What is the number good for?
It is a personal self-check, not a rule. It tells you how much of each month is already spoken for before you buy groceries. Many people feel the pinch well before any official ratio is reached, so pay attention to how your month feels as well as to the percentage. If the figure is rising, pause before taking the next EMI and look at the full monthly picture first.
Useful ideas start with a clearer picture of your own spending.
Explore your reports

