A no-cost EMI is not free if you give up a cash discount to take it. Use =RATE(tenure, -EMI, cash price) to find the monthly rate hidden in the offer. If the list price is ₹60,000, the cash price is ₹57,000 after a ₹3,000 discount, and the EMI is ₹10,000 for 6 months, RATE gives about 1.49% a month, or roughly 17.8% a year.
What exactly are you comparing?
Two ways to buy the same thing. Pay cash today at the discounted ₹57,000. Or pay ₹10,000 a month for 6 months, a total of ₹60,000, which equals the list price. The ₹3,000 you do not save by choosing the EMI is the price of borrowing, and RATE turns it into a percentage you can compare with other rates.
The cells and formulas
- B1 Cash price after discount: 57000.
- B2 EMI amount: 10000.
- B3 Number of EMIs: 6.
- B4 One-time fee on the EMI offer: 199, or 0 if none. This is an invented figure; use what the offer states.
- B5 Monthly rate: =RATE(B3, -B2, B1-B4). Money you pay out is negative, the amount you effectively borrow is positive.
- B6 Yearly equivalent, simple: =B5*12.
- B7 Yearly equivalent, compounded: =(1+B5)^12-1.
What does the sheet say?
| Case | Monthly rate | Simple yearly | Compounded yearly |
|---|---|---|---|
| No fee | 1.49% | 17.8% | 19.4% |
| With a ₹199 fee | 1.59% | 19.1% | 20.8% |
The fee is paid up front, so it reduces the amount you are effectively borrowing from ₹57,000 to ₹56,801 while the instalments stay the same. That is why the rate rises. If the offer has no fee, leave B4 at zero.
Why is the yearly rate so much higher than 3,000 divided by 57,000?
That division gives about 5.3%, which sounds small. But the ₹3,000 is the cost of a loan that shrinks every month: after the first instalment you owe less, after the second still less, and by the end almost nothing. The average amount you are borrowing is far lower than ₹57,000, and the same ₹3,000 is charged on that smaller, shorter loan. That is why the RATE function, which accounts for each instalment's timing, gives a much higher annual figure.
How do I turn this into a decision?
Add an input for the return you would otherwise get on the money, or the rate you would pay if you borrowed elsewhere. Say it is in B8. Then:
- B9: =IF(B7>B8, "Pay cash", "Take the EMI").
- If the hidden rate is higher than what your spare money would earn, paying cash is the cheaper option.
- If it is lower, spreading the payment costs less than the opportunity you give up.
The rate in B8 is yours to supply and to justify. Use a figure from a deposit or loan you actually have, not an optimistic guess.
Does an EMI on a card affect anything else?
An EMI uses part of your card limit until it is repaid, so large purchases can leave less room for other spending. It is not part of the maths above, but it belongs in the decision if your limit is tight.
What if the first EMI is due on day one?
RATE assumes the first instalment comes a month after purchase. If the first EMI is deducted at once, add the type argument: =RATE(B3, -B2, B1-B4, 0, 1). Because you start repaying sooner, the hidden rate comes out higher. Check from the offer terms when the first instalment is taken.
A last look
- Do the instalments add up to the list price, or more?
- Is the cash discount available only for one payment mode or one card?
- What is the return period, and does it change if you pay by EMI?
- Would you buy this item at the cash price?
Once you decide, record it. Importing the card statement into SpendixAI and reviewing the instalment rows each month helps you see whether the EMIs are posting as agreed.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


