Shopping

Laptop on a 3, 6 or 12-month EMI: comparing the total paid

Compare one laptop on 3, 6 and 12-month EMI by total paid, with a sheet that has places for interest, fees and tax lines read from the lender's schedule.

Editorial illustration for Laptop on a 3, 6 or 12-month EMI: comparing the total paid

To compare a laptop on a 3, 6 or 12-month EMI, build a three-column sheet and fill each column from the lender's own schedule. Total paid is the instalment times the number of months, plus any processing fee, plus any tax lines the schedule shows. Subtract the laptop's price, and what is left is what the plan cost you.

What should the sheet look like?

Rows are the things to read from the schedule. Columns are the three tenures. The figures below are invented for a ₹60,000 laptop and are not from any lender, so replace each with the number printed on the offer you are given.

Row3 months6 months12 months
Monthly instalment₹20,300₹10,400₹5,400
Instalments x months₹60,900₹62,400₹64,800
Processing fee₹500₹500₹500
Tax lines on interest or feeAs on scheduleAs on scheduleAs on schedule
Total paid₹61,400₹62,900₹65,300
Cost over the price of ₹60,000₹1,400₹2,900₹5,300

Working: 20,300 x 3 = 60,900, then + 500 = 61,400. 10,400 x 6 = 62,400, then + 500 = 62,900. 5,400 x 12 = 64,800, then + 500 = 65,300. A longer tenure lowers the monthly burden and raises the total, which is the trade-off the sheet is meant to show.

Which spreadsheet formulas make it work?

Put the instalment in B2, the number of months in B3, the processing fee in B4 and the tax lines total in B5. In Excel or Google Sheets, these formulas do the rest.

  • Total paid: =B2*B3+B4+B5
  • Cost over price (price in B1): =B6-B1
  • Rough yearly rate hidden in the plan: =RATE(B3,-B2,B1)*12

The third formula uses the RATE function, which returns a monthly rate for equal instalments, and the sign on the instalment must be negative. It ignores the fee and tax lines, so treat the output as a rough guide and compare it between tenures, not against any quoted rate.

What does a no-cost label mean in your column?

If an offer is described as no-cost EMI, still fill in the same rows. Ask the seller for the schedule that shows the price, any discount that is removed and the fee lines. Compare the total paid against the cash price, not against the sticker price, and the label will either hold up or not.

Also compare against saving. Putting ₹5,000 aside each month for 12 months gives ₹60,000 (5,000 x 12) with no fee, but you wait a year for the laptop. The sheet cannot say whether that wait is acceptable, since it depends on whether you need the machine for work or study now, and that is a decision only you can make.

Which tenure fits your month, not just the total?

Divide each instalment by your take-home pay. If your take-home is ₹50,000, then ₹20,300 is 41 per cent of the month (20,300 / 50,000 = 0.406), while ₹5,400 is 11 per cent. A plan with the lowest total may still crowd out your rent and bills for three months, so look at the instalment next to your fixed costs, not alone.

What should you check before you accept?

  1. The total amount payable printed on the schedule, not just the instalment.
  2. Whether there is a charge for paying off early.
  3. The due date of each instalment, and how the first one is collected.
  4. Whether the laptop's warranty and return window start from the delivery date.
  5. What happens if you miss one instalment, as stated in the terms.

Keep the signed offer and the final schedule together in one folder, with the date you accepted. Once you pay, the instalments will appear on your statement. Importing it into SpendixAI means each debit is categorised and you can check them against your sheet, month by month.

SPENDIXAI JOURNAL

Useful ideas start with a clearer picture of your own spending.

Explore your reports