To estimate how long a card balance will take to clear, work it month by month: add the monthly interest to the balance, subtract your payment and repeat until the balance is zero. For a made-up ₹60,000 balance at 3% a month with a fixed ₹5,000 payment, it takes 16 months and about ₹15,498 of interest. A spreadsheet function gives you a quick check.
How do you do it month by month?
Each month has three steps. Interest is the opening balance times the monthly rate. Closing balance is the opening balance plus interest minus the payment. The closing balance becomes next month's opening balance. In this example the interest is charged on the opening balance and the payment lands at the end of the month. The 3% rate is invented; your statement shows your own, and if it is quoted yearly, dividing by 12 gives a rough monthly figure.
| Month | Opening balance | Interest (3%) | Payment | Closing balance |
|---|---|---|---|---|
| 1 | ₹60,000 | ₹1,800 | ₹5,000 | ₹56,800 |
| 2 | ₹56,800 | ₹1,704 | ₹5,000 | ₹53,504 |
| 3 | ₹53,504 | ₹1,605 | ₹5,000 | ₹50,109 |
| 6 | ₹43,011 | ₹1,290 | ₹5,000 | ₹39,301 |
| 9 | ₹31,545 | ₹946 | ₹5,000 | ₹27,491 |
| 12 | ₹19,015 | ₹570 | ₹5,000 | ₹14,586 |
| 15 | ₹5,324 | ₹160 | ₹5,000 | ₹483 |
| 16 | ₹483 | ₹15 | ₹498 | ₹0 |
The rows for months 4, 5, 7, 8, 10, 11, 13 and 14 are left out to keep the table short; the same three steps fill them in. In total you pay ₹5,000 for fifteen months plus ₹498 at the end, which is ₹75,498. That is the ₹60,000 balance plus ₹15,498 of interest.
What is the quick check formula?
In Excel or Google Sheets, the function NPER returns the number of months for a fixed payment. For this example, type =NPER(3%,-5000,60000). The payment is negative because it is money going out. The result is about 15.1, which you round up to 16 months, matching the table. The total interest is the payment times the months minus the balance, roughly ₹5,000 × 15.1 − ₹60,000 = about ₹15,500.
- Rate: the monthly rate, entered as 3% or 0.03.
- Payment: a negative number, such as -5000.
- Present value: the balance you owe, as a positive number.
- Result: months, usually with a decimal, which you round up.
Why does the payment have to beat the interest?
In month one, interest on ₹60,000 is ₹1,800. If your payment were ₹1,800, the balance would never fall; with less than that it grows. NPER shows an error in that case. A useful quick test: multiply your balance by the monthly rate and make sure your payment is clearly above that number. In this example ₹5,000 is well above ₹1,800, so ₹3,200 goes to principal in month one, and more each month after.
What if you pay more?
Try ₹6,000 in the same formula: =NPER(3%,-6000,60000). Change only the payment and watch the months fall. That returns about 12.1 months instead of 15.1, and the interest drops to roughly ₹12,400 from ₹15,500, so an extra ₹1,000 a month saves about three months and about ₹3,100. This is a way of seeing what a change in monthly budget buys, without any commitment.
Things this simple model leaves out
- New spends on the card, which push the balance back up.
- Fees, late charges and tax on them.
- A minimum due that changes with the balance.
- Interest calculated daily and not monthly.
- Changes to the rate during the repayment.
Treat the answer as an estimate. If you need an exact figure, ask your card issuer for the payoff statement. And if the number of months is longer than you can live with, rerun the check with a higher payment to see what is achievable.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


