Index Funds vs Active Funds: The Data-Backed Answer

Should you trust a fund manager or an algorithm?

This debate has raged for decades. Every financial advisor has an opinion. Every blog has a take. And most of them are shaped by who’s paying the writer.

Here’s what I’m going to do instead: show you the data. Not my opinion. Not theory. Just numbers from actual Indian mutual funds, compared against global evidence.

Then you decide.

What’s the Actual Difference?

Before we look at the data, let’s be clear on what we’re comparing.

Index Fund

An index fund tracks a market index. The Nifty 50 Index Fund, for example, simply buys all 50 stocks in the Nifty 50, in the same proportion as the index. The fund manager isn’t picking stocks. They’re just copying the index.

If Nifty goes up 12%, your fund goes up roughly 12% (minus small costs).

There’s no research team analyzing companies. No calls on which stock will beat the market. Just mechanical replication.

Cost: 0.1% to 0.3% expense ratio (what the fund charges you annually)

Active Fund

An active fund has a manager (and usually a team) who pick stocks they believe will beat the index. They might hold 40 stocks instead of 50. They might overweight certain sectors. They’re making judgment calls every day.

The pitch is simple: Smart people with access to research and company management can beat the market.

Cost: 1% to 2% expense ratio

The Cost Gap

Here’s the math that matters.

An index fund charging 0.2% and an active fund charging 1.5% have a 1.3% annual cost difference.

Sounds small. Let’s see what 1.3% does over time.

Investment	Monthly SIP	Period	Return at 12%	Return at 10.7% (minus 1.3% fees)	Difference
Index	Rs 10,000	20 years	Rs 99.9 lakhs	-	-
Active	Rs 10,000	20 years	-	Rs 84.2 lakhs	Rs 15.7 lakhs

Same monthly investment. Same starting point. The only difference: 1.3% annual fee drag.

Over 20 years, the higher-fee active fund needs to beat the index by 1.3% every single year just to break even. If it doesn’t, you’re paying more to get less.

This is the bar active funds need to clear. Let’s see how many actually do.

What the Global Data Shows

The longest-running study on this comes from S&P. Their SPIVA (S&P Indices Versus Active) report tracks how many active funds actually beat their benchmark index.

US Market Results (15-Year Period)

Category	% of Active Funds That Underperformed Index
Large Cap	92.2%
Mid Cap	95.4%
Small Cap	93.2%

Read that again. Over 15 years, more than 92% of actively managed large-cap funds in the US failed to beat their index.

Not 50%. Not 60%. Over 90%.

Why This Happens

The US market is “efficient.” That means stock prices already reflect most available information. Thousands of analysts cover every major company. By the time a fund manager spots an opportunity, it’s usually already priced in.

In this environment, the fund manager’s skill has to overcome:

• Research costs (staff, data, travel)
• Trading costs (buying and selling frequently)
• The expense ratio (you pay this)

Most can’t clear that bar consistently.

Warren Buffett’s Million-Dollar Bet

In 2007, Warren Buffett made a public bet. He wagered $1 million that an S&P 500 index fund would beat a portfolio of hedge funds over 10 years.

Hedge funds. The best money managers in the world, charging “2 and 20” (2% management fee plus 20% of profits).

The result after 10 years (2008-2017):

Investment	Total Return
S&P 500 Index Fund	125.8%
Hedge Fund Portfolio	36.3%

It wasn’t close. The boring index fund crushed the expensive hedge funds by 3.5x.

Buffett donated the winnings to charity. His point was made.

What the India Data Shows

Here’s where it gets interesting. India is not the US.

The Indian market is considered “less efficient.” Fewer analysts cover mid and small companies. Information doesn’t spread as fast. Company managements are less transparent. There might be more room for skilled managers to find undervalued stocks.

So does active management work better here?

SPIVA India Results (10-Year Period Ending December 2024)

Category	% of Active Funds That Underperformed Index
Large Cap	73%
Mid/Small Cap	52%
ELSS (tax saver)	64%

The results are better than the US, but still sobering.

Large Cap: 73% of active funds underperformed the index. That means if you picked an active large-cap fund randomly, you had only a 27% chance of beating the index.

Mid/Small Cap: Here’s where India differs. About 48% of active funds beat their benchmark. It’s closer to a coin flip.

What this tells us: Even in India’s “less efficient” market, most active funds don’t justify their fees in the large-cap space. The opportunity for active management is primarily in mid and small caps.

The Survivorship Problem

These numbers actually understate the problem. When a fund performs badly, it often gets merged into another fund or shut down. The terrible track record disappears.

If you could see all the funds that existed 10 years ago (including the ones that failed), the underperformance rate would be even higher.

The Consistency Problem

Let’s say you’re smart. You won’t pick a random active fund. You’ll pick a winner.

Here’s the catch: Can you identify which fund will win over the next 10 years?

Top Performers Don’t Stay on Top

Studies consistently show that past performance doesn’t predict future performance. A fund that beat the market for five years is not more likely to beat it for the next five.

In fact, there’s often regression to the mean. Funds that massively outperformed tend to underperform later, and vice versa.

Top Quartile Funds in Period 1	Remained Top Quartile in Period 2
Large Cap	~25%
Mid Cap	~22%
Small Cap	~24%

Roughly one in four. Basically random chance.

If you picked the best-performing fund from the last 5 years, you have about the same odds of it being the best next 5 years as if you picked randomly.

Why Does This Happen?

• Style goes in and out of favor. A value-focused fund might crush growth for 5 years, then lag for the next 5 as the market rotates.
• Fund managers leave. The person who generated the returns might not be the person managing your money anymore.
• Size kills performance. A successful fund attracts more money. With more money, it becomes harder to find enough good opportunities.
• Luck. Some outperformance is simply luck that doesn’t repeat.

When Index Funds Make More Sense

Based on the data, here’s when indexing is the stronger choice.

Large Cap Exposure

In large-cap equity, the data is clear. Most active funds underperform, and you can’t reliably predict which ones won’t. A Nifty 50 or Nifty 100 index fund gives you market returns at minimal cost.

Specific options:

• UTI Nifty 50 Index Fund (expense ratio: 0.18%)
• HDFC Nifty 50 Index Fund (expense ratio: 0.20%)
• Nippon India Nifty 50 Index Fund (expense ratio: 0.20%)

You’re a “Set and Forget” Investor

If you don’t want to research funds, track performance, and switch when things change, index funds are built for you. You’re not betting on a manager. You’re betting on the Indian economy.

Buy a Nifty 50 index fund, set up an SIP, and check in once a year. That’s genuinely all you need to do.

You Want the Lowest Possible Cost

Every rupee spent on fees is a rupee not compounding for you. Over decades, this adds up to lakhs. If cost efficiency is your priority, index funds are unambiguously better.

You Don’t Want to Chase Performance

With an index fund, you’ll never have the “best performing” fund. You’ll also never have a fund that implodes because a star manager made a bad bet or left for a competitor.

You get market returns. No drama. No surprises.

When Active Funds Might Make Sense

The data isn’t entirely one-sided. Here’s where active management has a stronger case.

Mid-Cap and Small-Cap Exposure

The SPIVA India data shows active managers have a fighting chance in mid and small caps. These markets are less analyzed, more volatile, and potentially more rewarding for skilled stock pickers.

If you’re investing in this space, an actively managed fund from a proven house might be worth the higher fees.

Options that have performed well historically:

• HDFC Mid-Cap Opportunities Fund
• Kotak Emerging Equity Fund
• Axis Midcap Fund

Important caveat: Past performance doesn’t guarantee future results. These funds did well; they might not continue to.

You Can Identify Skilled Managers

Some investors spend significant time researching fund managers, understanding their investment philosophy, and tracking consistency. If this is you, and you have genuine conviction in a manager’s skill, active funds can work.

But be honest: Do you actually do this? Or do you pick funds based on last year’s returns?

You Can Stomach Tracking Error

Active funds will behave differently from the market. They might lag when the market rises and fall less when it drops (or the opposite). This “tracking error” can test your patience.

If you can genuinely hold through periods of underperformance, active funds might suit you. Most people can’t. They switch after a bad year, locking in losses.

My Recommendation (Opinion Section)

I’ve shown you the data. Here’s what I’d do with it.

Large Cap: Index Fund

For Nifty 50 exposure, I’d pick an index fund every time. The data overwhelmingly supports it. You’re not missing much by skipping active management here.

Mid Cap: Your Call

This is genuinely close. About half of active managers beat the benchmark. If you have a specific fund with a philosophy you understand and believe in, go active. If not, there’s now a Nifty Midcap 150 index fund. Either works.

Small Cap: Lean Active (With Caution)

Small-cap stocks are volatile, illiquid, and hard to index efficiently. Active managers have more edge here. But small-cap investing is inherently risky. If you’re not comfortable with 40-50% drawdowns in bad years, stay out regardless of active vs passive.

The Simplest Approach

If you want to skip the entire debate:

100% Nifty 50 Index Fund

That’s it. You’ll get market returns, pay minimal fees, and never have to think about fund selection again.

Is it optimal? Maybe not in mid and small caps. Is it good enough? Almost certainly yes. The difference between “good enough” and “optimal” is much smaller than the difference between “consistent investor” and “keeps switching funds.”

Consistency beats optimization.

Questions to Ask Yourself

Still unsure? Answer these honestly.

How much time will you spend on fund research?

• Less than 1 hour/month: Go index
• Several hours/month: Consider active

How will you react if your fund underperforms for 2-3 years?

• Switch to something else: Go index (you’ll end up switching anyway)
• Stay the course: Active might work

How important is lowest possible cost?

• Very: Go index
• I’ll pay for potential outperformance: Consider active

Do you enjoy tracking funds and markets?

• No, it’s a chore: Go index
• Yes, I find it interesting: Consider active

Are you investing in large cap, mid cap, or small cap?

• Large cap: Strong case for index
• Mid/small cap: Either can work

What to Do This Month

If you’ve read this far, here’s your action step.

Check your existing mutual funds.

Log into your AMC account or check your Consolidated Account Statement (CAS). For each equity fund you hold, answer:

1. Is it an index fund or active fund?
2. What’s the expense ratio?
3. If active: How has it performed vs its benchmark over 3 and 5 years?
4. If underperforming: Is there a reason to believe it will turn around?

If you have active large-cap funds that have consistently trailed Nifty 50 after fees, consider switching to an index fund when you can (watch for exit load and tax implications).

If you’re starting fresh, pick a Nifty 50 index fund with the lowest expense ratio and start your SIP. Not sure which fund to pick? You can always add active mid-cap exposure later if you want. But the foundation should be low-cost and simple.

---

Index or active, here’s what actually matters: your family knowing these investments exist. A perfectly optimized portfolio is worthless if your nominee doesn’t know the folio number, the AMC, or how to claim it after you’re gone.