SIP Backtest
Avenue Supermarts Ltd.
A ₹10,000 monthly SIP in DMART over the last 5 years means ₹6,00,000 paid in across 60 instalments. It would be worth ₹5,68,635 today.
Change the instalment or the holding period to run the backtest against DMART's own price history. Nothing here is projected from an assumed rate — every figure comes from what the share price and dividends actually did.
Every Period
Each period is a separate backtest: ₹10,000invested at the end of every month, priced at that month's adjusted close. The last instalment falls on the valuation month, so it has had no time to grow — which is exactly true of a real SIP.
12 instalments of ₹10,000 — ₹1,20,000 paid in — would be worth ₹1,13,828 today, an XIRR of -11.0%.
Same money, invested once: ₹1,02,711 (-15.6% XIRR) — the SIP did better.
Same SIP into the Nifty 50: ₹1,18,061 (-3.5% XIRR) — the index ahead.
36 instalments of ₹10,000 — ₹3,60,000 paid in — would be worth ₹3,37,008 today, an XIRR of -4.5%.
Same money, invested once: ₹3,75,181 (1.4% XIRR) — the lump sum did better.
Same SIP into the Nifty 50: ₹3,69,813 (1.9% XIRR) — the index ahead.
60 instalments of ₹10,000 — ₹6,00,000 paid in — would be worth ₹5,68,635 today, an XIRR of -2.2%.
Same money, invested once: ₹5,40,765 (-2.1% XIRR) — the SIP did better.
Same SIP into the Nifty 50: ₹6,98,507 (6.2% XIRR) — the index ahead.
By Monthly Amount
Each row is a 5-year SIP in DMART, run at a different instalment.
| Every month | Total invested | Worth today | Gain |
|---|---|---|---|
| ₹1,000 | ₹60,000 | ₹56,863 | −₹3,137 |
| ₹2,000 | ₹1,20,000 | ₹1,13,727 | −₹6,273 |
| ₹5,000 | ₹3,00,000 | ₹2,84,317 | −₹15,683 |
| ₹10,000 | ₹6,00,000 | ₹5,68,635 | −₹31,365 |
| ₹25,000 | ₹15,00,000 | ₹14,21,587 | −₹78,413 |
SIP outcomes are exactly proportional to the instalment, so these rows scale from one backtest rather than five. The annualised return (XIRR) is identical for every row — only the rupee figures change.
The Metric
A SIP's return cannot honestly be quoted as a CAGR. CAGR describes one sum invested once and left alone; a SIP adds money every month, so the first instalment has been invested for 5 years and the last for a single month. Averaging those as though they were one investment overstates the result.
The correct measure is XIRR — the single annual rate that makes all 60 instalments and today's value balance. For Avenue Supermarts Ltd. over 5 years, that rate is -2.2%.
Most Indian SIP calculators ask you to assume a rate of return — commonly 12% — and then compute forward from it. Nothing on this page is assumed: every figure comes from what the share price and dividends actually did.
SIP vs Lump Sum
₹6,00,000 put into Avenue Supermarts Ltd. as a single lump sum at the start of the period would be worth ₹5,40,765 today (-2.1% XIRR). The same money paid in monthly is worth ₹5,68,635.
The SIP came out ahead. That happens when the price falls during the period: later instalments buy more units for the same money, so spreading the entry out worked in the investor's favour.
The comparison is not really a choice for most people. A SIP invests what you earn each month; a lump sum requires having the whole amount up front. This tells you what each would have produced, not which you should have done.
SIP vs The Index
The identical 60 instalments put into the Nifty 50 on the same dates would be worth ₹6,98,507 — an XIRR of 6.2%, against ₹5,68,635 in Avenue Supermarts Ltd.. The index is ahead over this period.
The index leg is bought month by month on exactly the same dates, not modelled at an assumed annual rate. That matters: a smooth compounded curve has no entry timing, and entry timing across many instalments is the entire subject of this page.
How This Is Calculated
Each instalment buys at that month's closing price. A real SIP buys on a fixed date that may be any trading day, so an actual outcome would differ a little in either direction.
Prices are adjusted for dividends and stock splits, so dividends are treated as reinvested. Demergers are not credited, and brokerage and taxes are not modelled.
DMARTis in today's Nifty 500 universe. Companies that delisted or collapsed are not on this site at all — a bias worth holding in mind when reading any historical backtest.
Measured on data to 2026-08-31, from 2017-03-01. Full definitions are on our methodology page.
HELP CENTER
Everything you need to know about this page and the data presented.
Investing ₹10,000 a month in Avenue Supermarts Ltd. for the last 5 years would have meant paying in ₹6,00,000 across 60 instalments. That holding would be worth about ₹5,68,635 today — a loss of ₹31,365, or 0.9× the money paid in. Every instalment is priced at that month's adjusted close, so dividends and stock splits are already counted in.
A 5 years SIP in Avenue Supermarts Ltd. returned an XIRR of -2.2%. XIRR is the right measure for a SIP and CAGR is not: CAGR assumes one sum invested once, while a SIP puts money in every month, so each instalment is exposed for a different length of time. A 5 years SIP's final instalment has been invested for one month, not 5 years.
Over the last 5 years, yes. The same ₹6,00,000 invested as a single lump sum at the start would be worth ₹5,40,765 today, against ₹5,68,635 for the monthly SIP. Spreading the entry out won here because the price fell during the period, so later instalments bought more units for the same money. A SIP is a way of investing what you earn each month, not a technique for beating a lump sum you already have.
Over 5 years, no. The identical monthly instalments put into the Nifty 50 instead would be worth ₹6,98,507, against ₹5,68,635 in Avenue Supermarts Ltd. — an index XIRR of 6.2%. The index leg is bought month by month on the same dates, not modelled at an assumed rate.
₹5,000 a month for 5 years adds up to ₹3,00,000 paid in, and would be worth about ₹2,84,317 today. SIP outcomes scale exactly with the instalment, so halving or doubling the monthly amount halves or doubles every rupee figure and leaves the XIRR unchanged.
That is not a question this page answers, and we do not make recommendations. What it can tell you is exactly what a monthly SIP in Avenue Supermarts Ltd. would have produced over every period the data covers, how that compares with the same money invested at once, and how it compares with the Nifty 50. Those are records of what happened, not forecasts — a stock that compounded well for twenty years carries no promise about the next one.
Explore Further
DMART overview
Price history, wealth journey and how it compares with the index.
DMART 5-year returns
The same period as a one-time investment, year by year.
SIP backtests for every stock
Run the same question against any company we track.
Browse every stock
1-year and 5-year returns on every row, sortable.
ReturnScreener is an educational research platform and is not a SEBI-registered investment adviser. Everything on this page is a record of what historical prices did, not a projection and not a recommendation. Past performance does not guarantee future returns. See our methodology and disclaimer.