Your personal debt-service ratio is everything you pay each month towards debt divided by your monthly take-home pay. For a made-up ₹18,500 of payments against ₹70,000 of take-home, the ratio is about 26%. The number is useful because it shows how much of your income is committed before the month begins, and it gives you a way to decide when to stop borrowing.
What is the formula?
Debt-service ratio = total monthly debt payments ÷ monthly take-home pay. Use take-home pay, not gross, since you spend what you receive. Count the payments you actually make: EMIs, the amount you pay on credit cards, instalments to relatives or friends, and buy-now-pay-later instalments. In a sheet with payments in B2:B6 and take-home in B8, use =SUM(B2:B6)/B8.
What counts as debt service?
- Every loan EMI: home, vehicle, personal, education, gold or consumer loan.
- Credit card payments: use what you really pay each month, not only the minimum due. If you only pay the minimum, use the minimum, and notice that this is a signal itself.
- Informal loans: money you repay to family, a chit fund or a friend on a schedule.
- Not counted: rent, regular bills and savings contributions such as a recurring deposit, because those are not debt.
Buy-now-pay-later and no-cost EMI instalments on a card count for as long as they last, because they are payments you owe whatever the month looks like. Add each one to the list with its end date so the ratio can fall visibly when it finishes.
If you hold a home loan, treat its EMI as debt service even though it also buys an asset; the ratio measures commitment, not value. Lenders use their own formulas for eligibility, so this is a personal figure, not a prediction of what a bank will do.
How do you work it out?
| Payment | Monthly amount |
|---|---|
| Personal loan EMI | ₹7,200 |
| Two-wheeler EMI | ₹4,800 |
| Credit card payment | ₹2,500 |
| Instalment to a relative | ₹4,000 |
| Total debt payments | ₹18,500 |
₹18,500 ÷ ₹70,000 = 0.264, so the ratio is about 26.4%. Of every ₹100 you take home, about ₹26 is already committed to lenders.
How do you set a rule for when to stop borrowing?
There is no official number to copy, so build your own using a stress test. Ask how high the ratio could go before a bad month becomes a problem. Suppose your income fell by 20%, from ₹70,000 to ₹56,000. The same ₹18,500 would then be ₹18,500 ÷ ₹56,000, about 33%. Perhaps you decide that you can live with that, but not with anything higher. Working backwards, a personal rule might read: no new loan if it takes my ratio above 30% on today's income.
Test a new loan against the rule before you apply. A new EMI of ₹6,000 would make payments ₹24,500 and the ratio ₹24,500 ÷ ₹70,000 = 35%, so under this example rule you would wait or pay something down first. The 30% here is invented for the example; yours should come from your own stress test.
Which payment off does the most good?
The ratio also shows the effect of clearing a loan. If the personal loan were repaid, payments would fall to ₹11,300 and the ratio to about 16.1% (₹11,300 ÷ ₹70,000). Compare that with the effort and interest cost of clearing it; the ratio is one lens, not the whole decision.
Habit to keep
- Recalculate the ratio whenever you take on or finish a loan.
- Write down your personal stop level in the sheet next to the ratio.
- Review it with your take-home each April, when pay often changes.
A dedicated category for loan repayments in SpendixAI lets a monthly report show your EMI total, which you can divide by take-home.
Useful ideas start with a clearer picture of your own spending.
Explore your reports

