Do Active Large-Cap Funds Beat the Nifty 100? An XIRR Win Rate Analysis
In my previous post, I introduced the XIRR win rate: a way of comparing two funds by asking how often an SIP investor would have held the larger corpus. In this article, I use it to answer a practical question: how often has an active large-cap fund beaten its benchmark, the Nifty 100, from the point of view of an SIP investor?
Fixing the start-date bias
My earlier XIRR win rate checked the SIP at the end of every month, but the SIP always began on the same date. That fixed start can flatter or penalise a fund depending on the market conditions at that point. To remove this bias, this analysis uses a separate SIP for each start date: 1 January of every year from 2014 to 2024. Every SIP is tracked up to October 2026.
I have also split the XIRR win rate into two windows:
• First 5 years: the first 60 months of the SIP. This is the experience of an investor who needs the money early. Equity is generally recommended for horizons of five years or more, so a long-term investor need not worry too much about this window.
• After 5 years: once the SIP has completed five years, how often does the fund keep a larger corpus than the index, month after month? This is the experience of the investor who stays the course.
Table 1: Percentage of time the fund beats the Nifty 100 (SIP on the 1st of every month)
Scheme | 5-Year Rolling Returns | XIRR Win Rate | |
First 5 Years | After 5 Years | ||
Bandhan | 43% | 49% | 72% |
Edelweiss | 96% | 69% | 96% |
HDFC | 59% | 57% | 80% |
Kotak | 90% | 71% | 98% |
Nippon | 69% | 74% | 88% |
SBI | 69% | 60% | 82% |
Tata | 55% | 58% | 76% |
UTI | 49% | 41% | 23% |
Axis | 62% | 49% | 25% |
Canara | 97% | 75% | 99% |
Mirae | 65% | 68% | 64% |
ABSL | 57% | 60% | 72% |
JM | 31% | 43% | 60% |
DSP | 18% | 44% | 46% |
Franklin | 23% | 44% | 26% |
ICICI | 83% | 72% | 96% |
Green cells mark a win rate of 60% or higher, the hurdle used in this article.
Sixteen large-cap schemes were analysed, all of which were in operation as of January 2013.
What the numbers show
More schemes clear the hurdle. Suppose an active fund is worth holding only if it beats the index at least 60% of the time. On 5-year rolling returns, 8 of the 16 schemes qualify. On the after-5-years XIRR win rate, 12 qualify. Five schemes join the list (Bandhan, HDFC, Tata, ABSL and JM), while Axis drops out.
Of those 12, 8 also clear 60% in the first five years: Edelweiss, Kotak, Nippon, SBI, Canara, Mirae, ABSL and ICICI. The four that do not are Bandhan, HDFC, Tata and JM.
In plain terms: for an investor who stays beyond five years, 12 schemes were ahead of the index in at least 60% of months. For an investor who might need the money within the first five years, 8 of those 12 were still ahead in at least 60% of months.
More clear winners emerge. On rolling returns, only three schemes (Edelweiss, Kotak and Canara) have a win rate of about 90% or more. On the after-5-years XIRR win rate, five do: Edelweiss, Kotak, Canara, ICICI and Nippon.
Nippon is the standout example. Its 5-year rolling win rate is a modest 69%, yet its after-5-years XIRR win rate is 88%. It was also ahead of the index in 74% of months during the first five years, the second highest among all 16 schemes.
Some funds look worse. UTI and Axis show 49% and 62% on 5-year rolling returns. Their after-5-years XIRR win rates are just 23% and 25%. Axis would have passed a rolling-returns screen but fails badly once an SIP investor's actual cash flows are considered.
So, do active large-cap funds beat the Nifty 100?
Often, yes, particularly for investors who stay beyond five years. The XIRR win rate paints a more favourable picture of active large-cap funds than 5-year rolling returns do. On rolling returns, half the schemes (8 of 16) clear the 60% hurdle. After five years of SIP investing, three-quarters (12 of 16) do, and the number of schemes ahead of the index in about 90% or more of months rises from 3 to 5. Even in the first five years, half of the schemes clear 60%.
Part of this difference comes from how the two measures work. An SIP corpus carries its history forward, so a lead (or a deficit) stays until it is reversed, and a strong spell can move a fund ahead and keep it there, whereas each rolling window starts afresh and looks at an isolated period. The two measures are not in conflict; they answer different questions. Rolling returns show how consistently a fund has performed over a fixed holding period. The XIRR win rate shows how an SIP investor would have fared at different points in the journey, such as exiting within five years or staying for eight, which a single rolling-returns figure cannot tell you.
The conclusion is not that every active fund works. UTI, Axis, Franklin and DSP were ahead of the index in fewer than half of months after five years, with win rates between 23% and 46%. Choosing the right fund still mattered a great deal: after five years, win rates ranged from 23% to 99%.
As explained in my previous post, combining the win rate with the margin by which one fund beats the other makes the analysis more complete. I have left margins out here to keep this article short.
Limitations
The 60% hurdle is my own choice; a different threshold would change the count of qualifying schemes.
Only schemes that existed in January 2013 and still exist today are included. Funds that were merged or closed are not, which can overstate how well active funds have done.
Because the corpus is cumulative, a lead (or a deficit) persists until it is reversed, so the monthly observations within an SIP are not independent of each other. The after-5-years figures also rest mainly on the earliest start dates, which have the longest history.
These are historical frequencies, not forecasts. A fund being ahead in 80% of past months does not mean an 80% chance of being ahead in future.
Past performance does not guarantee future results, and this is not a recommendation to buy or sell any scheme.
Post 5 year XIRR win rate would have limited observation points for SIPs starting in later years. For example for SIP start in 2019, the first 5 year XIRR win rate would have 60 observations and post 5 year window would have 45 observation points upto October 2026.
Disclaimer: Nothing in this article is a solicitation, recommendation, endorsement or offer. Past performance of an index, asset class or individual mutual fund scheme is no guarantee of future performance as to returns and risks. We do not take any responsibility for investment decisions based on this article. Please consult your advisor before taking any decisions on your portfolio construction. Registration granted by SEBI, BASL membership, and NISM certification do not guarantee the intermediary’s performance or provide any assurance of returns to investors. Investment in the securities market is subject to market risks. Read all the related documents carefully before investing.




Comments