If you bought a television, washing machine or air conditioner on instalments, the way to see how many EMIs are left across all of them is an EMI ladder: one row per loan with the amount, the last instalment month and the months remaining. The ladder also shows the month each EMI ends, which tells you when your monthly cash frees up.
Why a ladder rather than a single count?
Festival season is when most of these loans start, and people often end up with two or three small ones from different lenders. Each is small enough to ignore, yet together they can take a meaningful bite out of a salary. A ladder keeps them in one view.
What does the ladder look like?
Say it is November 2026 and this month's instalments have been paid. These are made-up loans.
| Item | EMI | Last instalment | Months left | EMIs still to come |
|---|---|---|---|---|
| Television | ₹3,500 | March 2027 | 4 | ₹14,000 |
| Washing machine | ₹2,200 | June 2027 | 7 | ₹15,400 |
| Air conditioner | ₹4,800 | September 2027 | 10 | ₹48,000 |
The monthly outgo today is 3,500 + 2,200 + 4,800 = ₹10,500. Remaining instalments add up to 14,000 + 15,400 + 48,000 = ₹77,400. After March 2027 the television drops off, so the monthly figure becomes 2,200 + 4,800 = ₹7,000. After June it is ₹4,800, and after September it is nil.
How do you compute months left in a sheet?
- Put the last instalment date in column D, such as 01/03/2027.
- Months left, if this month is already paid: =(YEAR(D2) - YEAR(TODAY())) * 12 + MONTH(D2) - MONTH(TODAY())
- Amount still to come: =B2 * E2, where B holds the EMI and E holds months left.
- Total outgo per month: =SUM(B2:B10), after removing finished loans.
- Total still to come: =SUM(F2:F10).
DATEDIF also works, but this formula is easier to audit. If this month's debit is still ahead, add one to the result.
What should the ladder decide?
- Which instalment ends first, and what will you do with that money? Decide before it ends; otherwise it dissolves into spending.
- Whether a new purchase fits. Add its EMI to the ladder and read the new monthly total before agreeing to anything.
- Whether a particular loan is worth closing early. Ask the lender for the closure figure and any fee in writing; the answer varies by loan.
What proof should you keep?
Save the invoice, the loan or plan confirmation and, at the end, a closure message for each loan. Keep them in one folder named by the item and the year, so that a warranty claim or a lender query is a two-minute search.
How can a tracker help?
Import each paying account's statement into SpendixAI, and the instalments appear as rows you can filter by lender. Pro adds bills, which suit a fixed monthly payment, and budgets, which let you set a ceiling for all EMIs together. Set the account before importing so each instalment keeps the right account. The ladder itself still lives in your sheet.
What if two loans end in the same month?
Put both on the ladder and treat the month they end as one event: the monthly total drops by both EMIs together. It is tempting to relax when the number falls, so decide in advance where that freed amount goes, whether to a savings goal, an emergency fund or a larger prepayment elsewhere. A line in the ladder titled Freed from, with the month, makes the plan visible.
Before the next festival sale
- Update the ladder with every live loan.
- Read the monthly total before you sign for another one.
- Note the month each loan ends.
- Decide in advance what freed-up cash will do.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


