To rank your debts by what they cost, multiply each balance by its yearly rate and divide by twelve. That gives the interest in rupees for one month. The loan with the biggest rupee figure is not always the one to attack first, so also compute interest per ₹1,000 owed.
The calculation in one line
Monthly interest = balance times yearly rate divided by twelve. In a sheet, with the balance in B2 and the rate in C2 typed as a percentage, the formula is =B2*C2/12. If you type the rate as a plain number like 36, use =B2*C2/1200. For the per-₹1,000 figure, use =D2/B2*1000, where D2 holds the monthly interest.
Three invented debts
Say you owe ₹30,000 on a credit card at an assumed 36 percent, ₹2,00,000 on a personal loan at an assumed 14 percent, and ₹18,00,000 on a home loan at an assumed 8.5 percent. These rates are examples; take yours from your own statements.
| Debt | Balance | Rate | Interest a month | Share of total | Per ₹1,000 owed |
|---|---|---|---|---|---|
| Credit card | ₹30,000 | 36% | ₹900 | 5.6% | ₹30.00 |
| Personal loan | ₹2,00,000 | 14% | ₹2,333 | 14.6% | ₹11.67 |
| Home loan | ₹18,00,000 | 8.5% | ₹12,750 | 79.8% | ₹7.08 |
Together the three cost ₹15,983 a month in interest. The home loan, with the smallest percentage, accounts for about four-fifths of it, simply because the balance is large. The card, with the highest percentage, accounts for the smallest rupee amount.
Which debt actually bleeds most?
It depends on the question. In total rupees, the home loan costs most. Per rupee owed, the card does. If you are asking where your monthly outgo goes, the first column answers. If you are asking where an extra ₹10,000 will save the most, the last column does: about ₹300 a month on the card, about ₹117 on the personal loan and about ₹71 on the home loan.
Should I always attack the highest per-₹1,000 debt?
It is a good default, but check three things first.
- Does the loan allow extra payments, and are there charges for paying early?
- Is the rate fixed or does it change? A floating rate can move the ranking.
- Do you still have a cash buffer after the extra payment?
What if my loan quotes a flat rate?
The monthly figure above assumes interest is charged on the balance that is still outstanding. Some lenders quote a rate on the original amount instead, which makes the loan costlier than the number suggests. Ask which method your agreement uses, and check the repayment schedule against your own calculation before you trust the ranking.
How often should I recompute?
Each time a balance changes noticeably, a rate is revised or a debt closes. Late in a loan, the same percentage costs less in rupees because the balance is smaller. That is why your ranking can change over a year even if no rate moves.
Totalling what borrowing costs you
- List each debt with balance, rate and the monthly interest from the formula.
- Add the interest column to get your total monthly cost of borrowing.
- Compare that total with your monthly income, so you know what share of pay goes only to interest.
- Update the sheet after every statement.
To see this from your own records, create a custom category for loan interest and card interest in SpendixAI and review how the entries from your imported statements are categorised. The monthly total of that category is a figure you can compare with the sheet.
Useful ideas start with a clearer picture of your own spending.
Explore your reports

