“Nifty 50 SIP has historically returned 12-15% over 10 years.” You will see this claim in every mutual fund advertisement. It is not wrong, but it hides the most important part of the story.
That 12-15% is an average across all possible 10-year windows. The actual outcome for any real investor depended entirely on which specific decade they happened to invest in. Two investors who each put in exactly ₹10,000 per month for 10 years in a Nifty 50 index fund - starting just five years apart - could have ended up with a difference of over ₹14 lakh on identical total contributions of ₹12 lakh.
That variance is not a fluke. It is the normal lived experience of SIP investing.
What Rolling 10-Year Windows Means
Instead of asking “what did Nifty 50 return over the last 10 years?”, rolling window analysis asks: “what did a ₹10,000/month SIP return for every possible 10-year period from 2005 onward?” A new window opens every January. Each window has a different starting valuation, a different sequence of crashes and rallies, and a different ending point.
The result is not one number but a distribution - a range of outcomes any real investor might have experienced depending on nothing more than when they started.
The Setup
₹10,000 per month, Nifty 50 TRI index fund, exactly 10 years:
- Installments: 120 monthly payments
- Total invested: ₹12,00,000 (₹12 lakh)
- Metric: XIRR, which accounts for the timing of each investment
XIRR is the right number for SIPs, not CAGR. A CAGR tells you the start-to-end growth of the index as if all money was deployed at once. XIRR tells you the actual return on your money, accounting for when each ₹10,000 went in.
Returns below are based on Nifty 50 TRI (Total Return Index), which reinvests dividends. An index fund tracking Nifty 50 would approximate these returns minus TER of 0.10-0.20%.
All Eleven Windows: 2005 to 2024
| SIP Window | Nifty 50 Start | Nifty 50 End | Est. XIRR | Corpus on ₹12L |
|---|---|---|---|---|
| Jan 2005 - Dec 2014 | ~2,100 | ~8,300 | ~16% | ~₹30L |
| Jan 2006 - Dec 2015 | ~2,800 | ~7,900 | ~12% | ~₹23L |
| Jan 2007 - Dec 2016 (WORST) | ~3,950 | ~8,200 | ~9% | ~₹19.5L |
| Jan 2008 - Dec 2017 | ~6,100 | ~10,500 | ~11% | ~₹22L |
| Jan 2009 - Dec 2018 (BEST) | ~3,000 | ~10,900 | ~18% | ~₹34L |
| Jan 2010 - Dec 2019 | ~5,200 | ~12,200 | ~12% | ~₹23L |
| Jan 2011 - Dec 2020 | ~5,850 | ~13,900 | ~14% | ~₹26L |
| Jan 2012 - Dec 2021 | ~4,600 | ~17,400 | ~17% | ~₹32L |
| Jan 2013 - Dec 2022 | ~6,000 | ~18,100 | ~14% | ~₹26L |
| Jan 2014 - Dec 2023 | ~6,300 | ~21,700 | ~16% | ~₹30L |
| Jan 2015 - Dec 2024 | ~8,900 | ~23,500 | ~13% | ~₹25L |
Nifty 50 price index levels are approximate references at start of January each year. TRI adds ~1-1.5% above price returns from dividends. XIRR estimates are based on representative historical figures, not exact month-end data.
Three things stand out from this table before digging deeper:
- Nine out of eleven windows delivered 11% XIRR or better
- The worst window still returned 9%, not zero
- The gap between best (18%) and worst (9%) is 9 percentage points - which translates to ₹34L versus ₹19.5L, a difference of ₹14.5 lakh on the same ₹12L invested
The Worst Window: January 2007 to December 2016
This window combined three things in the worst possible sequence: a high entry price, the biggest crash in a generation, and a decade of muted recovery.
How it played out:
- January 2007: Nifty at ~3,950, mid-bull run
- January 2008: Nifty peaked near 6,100 (your first 12 installments bought at 4,000-6,100)
- March 2009: Nifty crashed to ~2,600 - a 57% fall from peak
- December 2016: Nifty ended at ~8,200 - about double the January 2007 starting point
That doubling over 10 years is only 7.2% price CAGR. TRI adds roughly 1.5%. For the SIP investor, the XIRR comes out to approximately 9%: early installments went in at inflated pre-crash prices, the crash happened early enough to buy some cheap units in 2009-2012, but the exit level of 8,200 still offered limited upside from the average cost of units purchased.
The Math
At 9% annual XIRR (0.75% per month):
FV = 10,000 x [(1.0075)^120 - 1] / 0.0075 x 1.0075
(1.0075)^120 = 2.45
FV = 10,000 x 193.5 x 1.0075 = Rs 19,49,000
Result: ₹12 lakh invested over 10 years grew to approximately ₹19.5 lakh - a gain of ₹7.5 lakh.
This is the historical floor for a 10-year Nifty 50 SIP. Across all windows since 2000, the lowest recorded XIRR in any 10-year SIP period has been in the 8-10% range.
The Best Windows: 2009 Starters and 2012 Starters
January 2009 to December 2018 is the best window. The Nifty was around 3,000 in January 2009 and bottomed at 2,600 in March 2009. Every installment from mid-2008 through 2012 was buying units at deeply discounted prices, then the 2013-2018 rally multiplied those cheap units.
Estimated XIRR: ~18% Corpus on ₹12 lakh: approximately ₹34 lakh
At 18% annual XIRR (1.5% per month):
FV = 10,000 x [(1.015)^120 - 1] / 0.015 x 1.015
(1.015)^120 = 5.97
FV = 10,000 x 331.3 x 1.015 = Rs 33,63,000
January 2012 to December 2021 is the second-best window. Nifty at ~4,600 in early 2012 was a flat, depressed market (post-Europe debt crisis). Then came the 2014 election rally, the 2017-2018 run, and a COVID dip in March 2020 (Nifty to 7,500) followed by one of the sharpest recoveries in history.
Estimated XIRR: ~17% Corpus: approximately ₹32 lakh
What both best windows share: they required running SIPs when market sentiment was at its worst. February 2009 was a global financial crisis. Early 2012 was inflation at 10%, policy paralysis, and rupee weakness. The investors who captured these windows were the ones who did not stop their SIPs.
The Median: What Most Investors Actually Got
Windows like Jan 2011-Dec 2020, Jan 2013-Dec 2022, and Jan 2015-Dec 2024 cluster around 13-14% XIRR. These are “nothing special at the start” windows where markets were neither particularly cheap nor at obvious peaks.
At 13% XIRR (1.0833% monthly):
(1.010833)^120 = 3.644
FV = 10,000 x 244.1 x 1.010833 = Rs 24,67,000
Median outcome: ₹12 lakh invested grows to approximately ₹24.7 lakh - about 2.1x the invested amount.
Plan for 13% when building any financial model. It is realistic without requiring the courage of starting at a crisis low or the luck of a bull market at exit.
Was Even the Worst Window Worth It?
For someone in the 30% tax bracket, a bank FD at 7.5% delivers an after-tax effective rate of about 5.25% per year (interest taxed at slab rate annually, not on withdrawal).
At 5.25% effective post-tax return on ₹10,000/month:
FV = 10,000 x [(1.004375)^120 - 1] / 0.004375 x 1.004375
(1.004375)^120 = 1.689
FV = 10,000 x 157.5 x 1.004375 = Rs 15,82,000
The comparison:
| Option | 10-year corpus on ₹10K/month | Post-tax |
|---|---|---|
| Nifty 50 SIP, worst window (~9% XIRR) | ~₹19.5L | ~₹18.7L |
| Bank FD at 7.5% (30% tax bracket) | ~₹15.8L | ₹15.8L (already post-tax) |
| Bank FD at 7.5% (10% tax bracket) | ~₹17.2L | ₹17.2L |
| Recurring Deposit at 6.5% (30% bracket) | ~₹14.6L | ₹14.6L |
Even the worst historical SIP window beat a bank FD for anyone in the 30% bracket by roughly ₹3-4 lakh over 10 years. The structural advantage is also different: FD interest is taxed at your income slab rate every year. Equity LTCG is taxed at 12.5% only on redemption.
LTCG Impact: What Your Corpus Actually Nets
From the July 2024 Union Budget, LTCG on equity mutual funds is taxed at 12.5% on gains above ₹1.25 lakh per financial year. For a simplified single-year redemption at the 10-year mark:
| Scenario | Gross Corpus | Total Gain | LTCG Tax | After-Tax Corpus |
|---|---|---|---|---|
| Worst (~9% XIRR) | ₹19.5L | ₹7.5L | ~₹78K | ~₹18.7L |
| Median (~13% XIRR) | ₹24.7L | ₹12.7L | ~₹1.43L | ~₹23.3L |
| Best (~18% XIRR) | ₹33.6L | ₹21.6L | ~₹2.54L | ~₹31.1L |
LTCG formula: (Total gain - ₹1.25L) x 12.5%. Staging redemptions across two or three financial years - using the annual ₹1.25L exemption each time - reduces the tax bill further. The table above is a conservative single-withdrawal calculation.
After-tax, even the 9% XIRR window delivers ₹18.7L against a 30%-bracket FD’s ₹15.8L.
Why the Best Windows Required Courage
The best theoretical SIP returns were not available to most investors because capturing them required one specific behavior: not stopping the SIP when everyone around you was panicking.
The 2009-2018 window’s 18% XIRR required investing through late 2008 and into 2009 - the most fearful period in Indian market history since the dotcom crash. AMFI data shows SIP discontinuation rates spiked in late 2008 and Q1 2009. The investors who captured this window were the ones still running SIPs when the Nifty was at 2,600 and market commentary was saying it would go to 1,500.
The 2012-2021 window is strong partly because of COVID in March 2020 - Nifty fell 38% in six weeks. Most retail investors reading the news in March 2020 were thinking about stopping their SIPs, not starting new ones. That six-week dip is part of what makes the 2012-2021 corpus reach ₹32L instead of ₹28L.
This is why real-world investor returns consistently lag index returns by 2-4%. The best windows theoretically exist. Most investors do not capture them fully.
Using Variance to Plan Your Target SIP
The practical implication: do not calculate your required SIP assuming the best-case XIRR. Plan for median, build in buffer for the worst case.
If your 10-year corpus goal is ₹50 lakh:
| XIRR Assumption | Required Monthly SIP |
|---|---|
| 9% (worst case) | ~₹25,650 |
| 13% (median) | ~₹20,300 |
| 18% (best case) | ~₹14,900 |
The difference between planning at 13% and 18% is ₹5,400 per month. If you commit to ₹14,900 (assuming best case) and instead get a 2007-2016 experience, you end up with about ₹29L short of your ₹50L target. If you plan for ₹20,300 and markets deliver 17-18%, you end up with a surplus - a far better problem to have.
Bottom Line
Rolling 10-year Nifty 50 SIP windows from 2005 to 2024 produced a range of roughly ₹19.5L to ₹34L on ₹12L invested - a 9-percentage-point spread in XIRR (9% to 18%). The median cluster sits at 13-14%, delivering a corpus of around ₹24-26L. Even the worst window beat a 7.5% bank FD for investors in the 30% tax bracket. The best windows required keeping SIPs running through crashes when most investors quit.
Plan for a 12-13% XIRR. If markets deliver 16-17%, treat it as a windfall. If they deliver 10%, you still beat fixed income by a meaningful margin. The SIP’s job is to keep running - the market determines the rest.
Figures in this post are illustrative, based on representative Nifty 50 historical price and TRI data, and are not investment advice. Actual fund returns will differ from index returns due to TER, tracking error, and dividend timing.
Comments