SIP Backtest
Mahanagar Gas Ltd.
A ₹10,000 monthly SIP in MGL over the last 10 years means ₹12,00,000 paid in across 120 instalments. It would be worth ₹14,93,592 today.
Change the instalment or the holding period to run the backtest against MGL'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,17,684 today, an XIRR of -4.2%.
Same money, invested once: ₹1,03,959 (-14.5% 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,22,491 today, an XIRR of -7.4%.
Same money, invested once: ₹4,08,822 (4.5% 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 ₹6,51,274 today, an XIRR of 3.3%.
Same money, invested once: ₹6,86,515 (2.8% XIRR) — the lump sum did better.
Same SIP into the Nifty 50: ₹6,98,507 (6.2% XIRR) — the index ahead.
120 instalments of ₹10,000 — ₹12,00,000 paid in — would be worth ₹14,93,592 today, an XIRR of 4.3%.
Same money, invested once: ₹25,35,289 (7.8% XIRR) — the lump sum did better.
Same SIP into the Nifty 50: ₹20,27,267 (10.3% XIRR) — the index ahead.
By Monthly Amount
Each row is a 10-year SIP in MGL, run at a different instalment.
| Every month | Total invested | Worth today | Gain |
|---|---|---|---|
| ₹1,000 | ₹1,20,000 | ₹1,49,359 | +₹29,359 |
| ₹2,000 | ₹2,40,000 | ₹2,98,718 | +₹58,718 |
| ₹5,000 | ₹6,00,000 | ₹7,46,796 | +₹1,46,796 |
| ₹10,000 | ₹12,00,000 | ₹14,93,592 | +₹2,93,592 |
| ₹25,000 | ₹30,00,000 | ₹37,33,980 | +₹7,33,980 |
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 10 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 120 instalments and today's value balance. For Mahanagar Gas Ltd. over 10 years, that rate is 4.3%.
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
₹12,00,000 put into Mahanagar Gas Ltd. as a single lump sum at the start of the period would be worth ₹25,35,289 today (7.8% XIRR). The same money paid in monthly is worth ₹14,93,592.
The lump sum came out ahead. That is the usual result over a period where the price rose, because money invested earlier had longer to compound — and it is worth stating plainly rather than only showing the SIP figure.
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 120 instalments put into the Nifty 50 on the same dates would be worth ₹20,27,267 — an XIRR of 10.3%, against ₹14,93,592 in Mahanagar Gas 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.
MGLis 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 2016-07-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 Mahanagar Gas Ltd. for the last 10 years would have meant paying in ₹12,00,000 across 120 instalments. That holding would be worth about ₹14,93,592 today — a gain of ₹2,93,592, or 1.2× the money paid in. Every instalment is priced at that month's adjusted close, so dividends and stock splits are already counted in.
A 10 years SIP in Mahanagar Gas Ltd. returned an XIRR of 4.3%. 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 10 years SIP's final instalment has been invested for one month, not 10 years.
Over the last 10 years, no. The same ₹12,00,000 invested as a single lump sum at the start would be worth ₹25,35,289 today, against ₹14,93,592 for the monthly SIP. The lump sum won because the price rose over the period, so money invested earlier had longer to compound. That is the usual outcome in a rising market, and it is the honest answer rather than the flattering one. A SIP is a way of investing what you earn each month, not a technique for beating a lump sum you already have.
Over 10 years, no. The identical monthly instalments put into the Nifty 50 instead would be worth ₹20,27,267, against ₹14,93,592 in Mahanagar Gas Ltd. — an index XIRR of 10.3%. The index leg is bought month by month on the same dates, not modelled at an assumed rate.
₹5,000 a month for 10 years adds up to ₹6,00,000 paid in, and would be worth about ₹7,46,796 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.
₹10,000 a month for 5 years means ₹6,00,000 paid in, worth about ₹6,51,274 today — +8.6% on what went in, an XIRR of 3.3%. Shorter horizons swing far more widely than long ones, which is why this page publishes every period separately rather than picking one.
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 Mahanagar Gas 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
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.