When a card purchase is converted to EMI, the monthly instalment comes from PMT, and the real cost comes from RATE once you count the one-time processing fee. A sheet that shows the month-by-month interest, the fee and the effective rate lets you compare the quoted rate with what you are actually paying. All figures here are samples, so use your own card's terms.
What inputs do you need from your card?
Take them from the offer screen or the confirmation message. Look for the converted amount, the number of months, the quoted annual interest rate, and any one-time processing fee. Also check whether tax is added on the interest or fee, and whether a pre-closure charge exists. Put them in cells:
- B1: Amount converted (sample ₹60,000)
- B2: Months (sample 12)
- B3: Quoted annual rate (sample 15%)
- B4: One-time processing fee (sample ₹1,000)
- B5: Monthly rate, =B3/12
How do you calculate the monthly instalment?
In B6 put =PMT(B5, B2, -B1). The minus sign on B1 makes the answer positive. With the sample inputs this gives about ₹5,415.50. Most issuers round the instalment, so yours may differ by a few rupees.
What does the month-by-month schedule look like?
Set up columns for month number, opening balance, interest, principal and closing balance. For month 1, interest is =B1*$B$5, principal is =$B$6 - interest, and closing balance is =opening - principal. Month 2 opens at month 1's closing balance.
| Month | Opening | Interest | Principal | Closing |
|---|---|---|---|---|
| 1 | ₹60,000.00 | ₹750.00 | ₹4,665.50 | ₹55,334.50 |
| 2 | ₹55,334.50 | ₹691.68 | ₹4,723.82 | ₹50,610.68 |
| 3 | ₹50,610.68 | ₹632.63 | ₹4,782.87 | ₹45,827.81 |
Over 12 months you pay 12 x 5,415.50 = ₹64,986, so the interest part is about ₹4,986. The fee of ₹1,000 comes on top, billed once.
How do you find the effective rate with the fee?
The fee means you received only ₹59,000 of value for those instalments. Use RATE to find the monthly rate that fits that cash flow:
=RATE(B2, -B6, B1-B4)*12
The arguments are the number of periods, the payment (negative because it goes out) and the present value (positive, what you effectively got). With the samples the answer is about 18.2% a year, against the quoted 15%. That gap of roughly three percentage points is the cost of the fee spread over a one-year loan.
This is a nominal annual figure (monthly rate times 12), which is how EMI rates are usually quoted. For the compounded figure, use =(1+RATE(B2,-B6,B1-B4))^12-1.
Is converting to EMI worth it?
That depends on what else you would do with the money. Paying the bill in full avoids interest altogether. Converting can make sense when the alternative is worse, such as carrying the balance at the card's regular finance charge. Do the sums with your own card's numbers. This sheet explains the cost; it does not tell you what to do.
What should you track after converting?
- Note the first instalment date and put each month's due date in a calendar.
- Record the instalment under its own category so it does not get lost in your card spend.
- Check each statement against the schedule: the instalment, the fee and any tax should all match.
How do you compare two tenures?
Copy the sheet to a second tab and change B2 from 12 to 6, keeping the same fee. The instalment rises, total interest falls, and the fee is spread over fewer months, so the effective rate usually rises even though the loan ends sooner. Put the two answers side by side: instalment, total interest, fee and effective rate. Pick the tenure whose monthly instalment fits your budget without leaving the next month's bills short.
When you import your card statements into SpendixAI, an EMI line shows up as a transaction you can categorise and compare month by month against this schedule.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


