Paying only the minimum can keep a balance alive for years. On a made-up carried balance of ₹50,000, a monthly rate of 3% and a minimum of 5% of the amount due (never less than ₹200), the sheet below takes 148 months and ₹66,375 of interest. A fixed ₹5,000 a month clears it in 13 months with ₹10,338 of interest. Every rate is an input, so replace mine with the figures on your own statement.
The input cells
- B1 Starting balance: 50000. The sheet assumes no new purchases on the card.
- B2 Monthly interest rate: type the monthly rate your card statement shows. I use 3% only to make the arithmetic visible.
- B3 Minimum due as a percentage of the amount: 5%. Banks differ and a minimum can include fees and taxes, so check how your statement defines it.
- B4 Minimum floor in rupees: 200, the lowest amount the sheet will pay.
- B5 Fixed payment you could afford: 5000.
The month-by-month formulas
Start the table in row 8 with these headings: A Month, B Opening balance, C Interest, D Payment, E Closing balance. Do the same again to the right for the fixed-payment plan, so the two sit side by side.
- A8: 1 and A9: =A8+1.
- B8: =B1 and B9: =E8.
- C8: =ROUND(B8*$B$2, 2).
- D8 (minimum plan): =MIN(B8+C8, MAX(ROUND($B$3*(B8+C8), 2), $B$4)). It never pays more than what is owed.
- D8 (fixed plan): =MIN(B8+C8, $B$5).
- E8: =B8+C8-D8.
- Copy down for about 160 rows; once the balance reaches zero, interest and payment stay at zero.
What do the first months look like?
Minimum-payment plan, first three months:
| Month | Opening | Interest | Payment | Closing |
|---|---|---|---|---|
| 1 | ₹50,000.00 | ₹1,500.00 | ₹2,575.00 | ₹48,925.00 |
| 2 | ₹48,925.00 | ₹1,467.75 | ₹2,519.64 | ₹47,873.11 |
| 3 | ₹47,873.11 | ₹1,436.19 | ₹2,465.47 | ₹46,843.83 |
In month one, interest is ₹1,500.00 and the payment is ₹2,575.00, so the balance falls by only ₹1,075.00. Now the fixed ₹5,000 plan:
| Month | Opening | Interest | Payment | Closing |
|---|---|---|---|---|
| 1 | ₹50,000.00 | ₹1,500.00 | ₹5,000.00 | ₹46,500.00 |
| 2 | ₹46,500.00 | ₹1,395.00 | ₹5,000.00 | ₹42,895.00 |
| 3 | ₹42,895.00 | ₹1,286.85 | ₹5,000.00 | ₹39,181.85 |
How do I read the totals?
| Measure | Minimum only | Fixed ₹5,000 |
|---|---|---|
| Months to clear | 148 | 13 |
| Total interest | ₹66,375 | ₹10,338 |
| Total paid | ₹1,16,375 | ₹60,338 |
For the minimum plan, 148 months is 12 years and 4 months. Count months with =COUNTIF(D8:D200, ">0"), and total interest with =SUM(C8:C200). The cost of the lower payment is the difference in interest, ₹56,038 here, which is what you pay for keeping the monthly outflow smaller.
What if I can pay more in some months?
Replace the fixed payment in a row with the amount you actually plan to pay, such as a bonus month, and watch the closing balance. You can also add a column that shows interest saved against the minimum plan at each month. That column often motivates a faster payoff more than a rate on a page does.
What should I change first when I try the sheet?
Change one input at a time. Drop the monthly rate and see how much the minimum plan shrinks. Raise the minimum percentage and see how fast the months fall. Then raise the fixed payment by a small amount, such as ₹500, and compare months and interest. The pattern to look for is that a modest increase in the payment often cuts the payoff time by a lot.
Before you decide
- Find the interest rate and minimum rule on your latest statement, not on a poster.
- Pay at least the minimum on time every month; the sheet assumes you do.
- Check whether new purchases lose any interest-free period while a balance is carried.
- If you are struggling, speak to the card issuer about options before dues pile up.
Your own balance and payments are on your statements. Importing a card statement into SpendixAI lets you check each month's payment and charge rows, and a category of your own keeps card dues in one place across months.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


