To track your EMI ratio over time, list each month's take-home pay and total EMIs in a sheet, divide one by the other, and draw a line chart of the result. A single ratio is a snapshot; the line shows whether you are drifting towards trouble or away from it.
Set up the sheet
- In column A, write the months. Use April to March if you follow the financial year.
- In column B, put the take-home pay credited that month.
- In column C, put the total EMIs paid that month.
- In D2, write =C2/B2 and fill it down. Format column D as a percentage with one decimal.
- Optionally, in column E, repeat your own ceiling, say 40 percent, in every row so the chart can show it as a flat line.
This works the same way in Excel and in Google Sheets.
Six months of invented data
Say your take-home is ₹60,000 and EMIs total ₹21,000. In July your income dips to ₹52,000 because of lower variable pay. In August a ₹6,000 EMI closes. In September income returns.
| Month | Take-home | EMIs | Ratio |
|---|---|---|---|
| April | ₹60,000 | ₹21,000 | 35.0% |
| May | ₹60,000 | ₹21,000 | 35.0% |
| June | ₹60,000 | ₹21,000 | 35.0% |
| July | ₹52,000 | ₹21,000 | 40.4% |
| August | ₹52,000 | ₹15,000 | 28.8% |
| September | ₹60,000 | ₹15,000 | 25.0% |
How do I draw the chart?
Select the month column and the ratio column. In Excel, use the Insert menu and choose a line chart. In Google Sheets, use Insert, then Chart, and pick the line type. If the chart takes the wrong columns, set the horizontal axis to the month column and the series to the ratio column. If you added the ceiling column, include it as a second series.
What does the drift tell me?
The two kinds of movement look different. A dip in income makes the line spike up, as in July, from 35.0 to 40.4 percent. An EMI closing makes the line drop in a step, as in August, from 40.4 to 28.8 percent, because the EMI closed while income was still low. Once income recovers in September, the ratio settles at 25.0 percent, lower than where you started, because the EMI is gone for good.
A drift that stays above your ceiling for two or three months deserves attention. One spike on a one-off month may not.
Why watch rupees as well as the ratio?
A ratio can improve because income rose, even when you owe the same amount. In the table, EMIs in rupees fell from ₹21,000 to ₹15,000, a real drop of ₹6,000 a month. If you keep an EMI column next to the ratio, you can tell a genuine reduction in debt from a flattering rise in pay. Draw the EMI rupees as a second chart if the two stories matter to you.
Three patterns to look for
- A flat line: income and EMIs are steady, which is a calm sign.
- A sudden spike: income dipped or a new EMI began; check whether it is temporary.
- A staircase down: EMIs are closing one by one, so decide what to do with the freed money.
What should I do each month?
- Enter income and EMIs within a week of the salary and the debit dates.
- Glance at the line and compare it with your ceiling.
- Note the reason for any move next to that month, such as a pay dip or an EMI closing.
- Archive the sheet in March and start a new tab in April.
If your statements are in SpendixAI, the Report builder can filter and group your records, and its CSV download lets you bring monthly totals into the sheet instead of adding them by hand.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


