Debt

Finding your total monthly EMI burden, loan by loan

Find your total monthly EMI burden by adding each loan, then divide by take-home pay to see your share, with a worked example and a refresh routine.

Editorial illustration for Finding your total monthly EMI burden, loan by loan

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?

LoanEMI (₹)Last EMI
Home loan22,0002041
Two-wheeler loan3,800Mar 2027
Phone EMI2,200Aug 2026
Card EMI on a laptop1,500Jan 2027
Total29,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 endsNew total (₹)Share of ₹85,000
Phone EMI27,300about 32.1%
Card EMI as well25,800about 30.4%
Two-wheeler as well22,000about 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.

SPENDIXAI JOURNAL

Useful ideas start with a clearer picture of your own spending.

Explore your reports