How much can ₹25,000 monthly SIP grow in 10 years in index funds vs active funds?

For a ₹25,000/month SIP over 10 years (total invested: ₹30 lakh), an index fund returning 12% CAGR builds approximately ₹58 lakh. An active fund returning 14% CAGR builds approximately ₹65.5 lakh: a difference of approximately ₹7.5 lakh. Over a longer 20-year horizon at the same return assumptions, the gap widens to nearly ₹79 lakh, illustrating how compounding amplifies even modest annual return differences over time.

📊 COMPARISON · MUTUAL FUNDS · INDEX VS ACTIVE

Index Funds vs Active Mutual Funds: Which Created More Wealth Over 10 Years?

Q: What is the expense ratio difference between index funds and active mutual funds?

Index funds typically have an expense ratio (Total Expense Ratio, or TER) of 0.1% to 0.5%, with direct plans often as low as 0.1 to 0.2%. Active mutual funds typically charge 1.5% to 2.25% for regular plans, or 0.5% to 1.5% for direct plans. This difference (often 1% to 2% annually) directly reduces an active fund's net returns relative to its gross performance, meaning an active fund manager must generate that much additional gross alpha just to match an index fund's net return.

Index Funds vs Active Mutual Funds: Which Builds More Wealth Over 10 Years?

A ₹30 Lakh SIP Comparison at 12% vs 14% CAGR

QUICK ANSWER

A ₹25,000/month SIP over 10 years (₹30 lakh invested) builds ₹58 lakh in an index fund at 12% CAGR versus ₹65.5 lakh in an active fund at 14% CAGR, if that return actually holds for a decade.

ABHYUDAYA VIKRAM SINGH

June 2026 · DhanSutra.co.in · Mutual Fund Comparison

8 MIN READ

All projections are illustrative. Mutual fund returns are not guaranteed and depend on market performance.

JUMP TO A QUESTION

Which is better, index funds or active mutual funds in India? What is the expense ratio difference between index funds and active mutual funds? How much can ₹25,000 monthly SIP grow in 10 years: index vs active funds? What is the Fund Selection Paradox? Should I invest in both index funds and active mutual funds? Do most active mutual funds beat their benchmark index in India?

THE DIRECT ANSWER

For a ₹25,000/month SIP over 10 years (total invested: ₹30 lakh): an index fund at 12% CAGR builds approximately ₹58 lakh. An active fund at 14% CAGR builds approximately ₹65.5 lakh: a difference of roughly ₹7.5 lakh in the active fund's favour. On paper, the active fund wins. But this comparison assumes the active fund sustains 14% CAGR for a full decade: and most don't. The real question isn't whether active funds can beat the index. Many do, in any given period. The question is whether you can identify, today, which fund will be among that minority over the next ten years.

THE 10-YEAR SIP COMPARISON: THE NUMBERS

MONTHLY SIP & TOTAL INVESTED

₹25,000/mo · ₹30 Lakh

Same investment amount in both scenarios · 10-year horizon

INDEX FUND CORPUS @ 12%

₹58 Lakh

Tracks Nifty 50 or Sensex · Low cost · No manager risk

ACTIVE FUND CORPUS @ 14%

₹65.5 Lakh

Assumes sustained 14% CAGR for full 10 years · Not guaranteed

DIFFERENCE OVER 10 YEARS

~₹7.5 Lakh

In favour of active fund: IF the outperformance is sustained

📋 THE CORE INSIGHT

The debate is not whether active funds can beat index funds. Many do, in any given decade. The real question is whether an investor can consistently select those winning funds before they outperform: not after.

Historical data shows most large-cap active funds in India have underperformed their benchmark over rolling 10-year periods. Mid-cap and small-cap funds have fared better.

AN ORIGINAL FRAMEWORK

🔵 THE FUND SELECTION PARADOX

Many active funds beat the index. Almost nobody can tell you which ones, in advance.

The Fund Selection Paradox describes the central difficulty of active fund investing: the debate is not whether active funds can outperform index funds: many individual funds do, in any given period. The real question is whether an investor can reliably identify, today, which specific fund will be among the outperformers over the next decade.

Past outperformance does not reliably predict future outperformance. Fund managers change roles, market conditions shift between cycles, and a strategy that worked brilliantly in one decade can underperform badly in the next.

This paradox is why selecting active funds is fundamentally harder than the simple historical-return comparison suggests. The 14% return used in any active fund comparison is a backward-looking number: it tells you what happened, not what will happen.

Term coined by Abhyudaya Vikram Singh · DhanSutra.co.in

Same SIP, Same Decade, Two Different Philosophies

Index funds simply track a market index (Nifty 50, Sensex, or a sector-specific index) buying the same stocks in the same proportion as the index itself. There is no fund manager trying to pick winners. The fund's job is to mirror the market, not beat it.

Active mutual funds are managed by a fund manager who selects specific stocks, adjusts sector weightings, and tries to generate returns higher than the benchmark index: what the industry calls "alpha."

📘 INDEX FUND

ASSUMED ANNUAL RETURN12%

10-YEAR CORPUS₹58 Lakh

EXPENSE RATIO (TER)0.1% to 0.5%

MANAGER RISKNone

MONITORING NEEDEDMinimal

📙 ACTIVE MUTUAL FUND

ASSUMED ANNUAL RETURN14%

10-YEAR CORPUS₹65.5 Lakh

EXPENSE RATIO (TER)0.5% to 2.25%

MANAGER RISKPresent

MONITORING NEEDEDPeriodic review

At first glance, the active fund wins by roughly ₹7.5 lakh. But this comparison rests on one large assumption: that the active fund sustains a 14% CAGR (consistently beating the index by 2 percentage points every year) for the entire decade. That is the part the simple comparison leaves out.

Where Each Approach Actually Shines

Returns are only one part of the comparison

📘 Where Index Funds Shine

Lower expense ratios: more of your return stays invested
No fund manager risk: performance can't be hurt by a manager change
Complete transparency: you always know exactly what you own
Consistent market-matching returns: no surprises, good or bad
Minimal monitoring required: set it and let it run

📙 Where Active Funds Shine

Potential to outperform the market in skilled hands
Flexibility to adjust allocation as market conditions change
Opportunity to generate genuine alpha over long periods
Stronger historical track record in less-covered segments (mid/small-cap)
Active risk management during sharp downturns, in some cases

Not every active fund beats its benchmark consistently: and this is where the comparison gets harder than the simple ₹58 lakh versus ₹65.5 lakh math suggests.

The Gap Widens Over Longer Horizons

Why the same 2% return difference matters more over 20 years than 10

Time Horizon	Total Invested	Index Fund @ 12%	Active Fund @ 14%
10 years	₹30 Lakh	₹58 Lakh	₹65.5 Lakh
15 years	₹45 Lakh	₹1.26 Crore	₹1.51 Crore
20 years	₹60 Lakh	₹2.50 Crore	₹3.29 Crore
A consistent 2% annual return difference compounds significantly over longer horizons. But this also means the cost of choosing an underperforming active fund compounds just as severely in the opposite direction.

The Real Question Behind the Debate

The debate is not whether active funds can beat index funds. Many active funds do: in any given 5-year or 10-year window, you can point to specific funds that comfortably outperformed their benchmark.

The real question is whether an investor (sitting today, without the benefit of hindsight) can consistently select those winning funds before they outperform, not after their outperformance is already visible in the track record.

By the time a fund's 10-year outperformance is visible in the data, you've already missed the 10 years that created it. The decision has to be made looking forward, with no guarantee the next decade resembles the last one.

This is the central challenge that index fund advocates point to, and it is supported by data: across multiple SPIVA India studies, a majority of actively managed large-cap funds have underperformed their benchmark over rolling 10-year periods. The picture is meaningfully different in mid-cap and small-cap categories, where active managers have shown more consistent outperformance: likely because these segments have less analyst coverage and more pricing inefficiency for a skilled manager to exploit.

Which One Should You Choose?

Choose Index Funds if you prefer simplicity and lower costs. If you want a "set it and forget it" approach with minimal ongoing decisions, index funds remove the fund-selection problem entirely: you simply own the market. Best suited for large-cap exposure, where active outperformance has historically been hardest to sustain.

Choose Active Funds if you're willing to review periodically and accept underperformance phases. Active management requires monitoring fund performance, understanding why a fund underperforms in a given period, and resisting the urge to switch funds reactively after short-term underperformance. Most suited for mid-cap and small-cap allocation, and for investors comfortable with periodic portfolio review.

Consider a blended approach if you want both certainty and upside potential. Many experienced investors split allocation: for example, 50% in index funds for core market exposure, 50% in carefully selected active funds for additional alpha potential. This structure provides guaranteed market participation through the index portion while keeping some upside potential through the active portion.

Whichever you choose, prioritise staying invested over switching funds. The data consistently shows that investor behaviour (staying invested through volatility) has a larger impact on long-term outcomes than the index-versus-active choice itself. Investors who frequently switch funds chasing recent performance typically underperform both a disciplined index fund investor and a disciplined active fund investor.

The Final Verdict

Over long periods, investor discipline matters more than the index-versus-active choice itself. The best fund (index or active) is the one you continue investing in through bull markets, bear markets, and every uneventful month in between.

Wealth creation over a decade is driven primarily by consistency, patience, and time in the market: not by correctly predicting which specific fund will outperform by 2 percentage points a year for ten straight years.

Frequently Asked Questions

Neither is universally better: it depends on the specific fund, category, and time period. Over a 10-year ₹25,000/month SIP, an index fund at 12% CAGR builds approximately ₹58 lakh, while an active fund at 14% CAGR builds approximately ₹65.5 lakh, assuming it sustains that outperformance. However, historical SPIVA India data shows a majority of actively managed large-cap funds have underperformed their benchmark over rolling 10-year periods. Mid-cap and small-cap active funds have shown more consistent outperformance. The real challenge is identifying in advance which active fund will be among the minority that outperforms.

Index funds typically charge 0.1% to 0.5%, with direct plans as low as 0.1 to 0.2%. Active mutual funds typically charge 1.5% to 2.25% for regular plans, or 0.5% to 1.5% for direct plans. This difference directly reduces an active fund's net returns relative to its gross performance: meaning an active fund manager must generate that much additional gross alpha just to match an index fund's net return.

For a ₹25,000/month SIP over 10 years (total invested: ₹30 lakh), an index fund at 12% CAGR builds approximately ₹58 lakh. An active fund at 14% CAGR builds approximately ₹65.5 lakh: a difference of roughly ₹7.5 lakh. Over 20 years at the same assumptions, the gap widens to nearly ₹79 lakh, showing how compounding amplifies even a modest 2% annual return difference over longer horizons.

The Fund Selection Paradox describes the core difficulty of active fund investing: the debate is not whether active funds can beat index funds: many individual funds do, in any given period. The real question is whether an investor can reliably identify, in advance, which specific fund will be among the outperformers over the next decade. Past outperformance does not reliably predict future outperformance, since fund managers change and market conditions shift. (Term coined by Abhyudaya Vikram Singh, DhanSutra.co.in)

Yes, a blended approach is common among experienced investors. A typical structure allocates a portion (for example, 50%) to index funds for low-cost, predictable market participation, and the remaining portion to carefully selected active funds for potential outperformance. This balances the certainty of matching market returns at low cost with upside potential, while reducing the risk of relying entirely on either approach.

Historically, no: a majority of actively managed large-cap mutual funds in India have underperformed their benchmark index over rolling 10-year periods, according to SPIVA India persistence studies. However, this varies by category: mid-cap and small-cap active funds have shown comparatively better and more consistent outperformance, attributed to lower analyst coverage and greater pricing inefficiency in those segments. The answer depends heavily on the specific market segment, not a blanket index-versus-active rule.