⚖ Active vs Index: Does Your Fund's Alpha Justify Its Cost?

A Cost-Benefit Evaluation That Ends in a Direct Verdict — Choose Active or Choose Index

Following along? Install the extension first

Finmagine AI Advisor — free • no account needed • Chrome, Edge, Brave

Install Free →
Published: April 2, 2026 | 18 min read | Template Tutorial | Part 4 of the VRO MF Series

Multimedia Learning Hub

Master the Active vs Index template through interactive learning and knowledge testing

Complete Learning Path

This tutorial is a complete guide to the Active vs Index template in the Finmagine AI Advisor Chrome Extension (v2.14.0). This template goes beyond the standard benchmark comparison most investors use — it computes true net alpha after fees, checks whether the benchmark is legitimate (TRI or PRI?), identifies the best passive alternative by name, evaluates whether the alpha is consistent across periods, and delivers a direct verdict: Choose Active or Choose Index. You will learn what drives each part of the analysis and see a worked example using HDFC Mid-Cap Opportunities Fund.

What You'll Learn:

  • Why gross alpha misleads: The typical benchmark comparison ignores expense ratio drag entirely — and that gap matters more than most investors realise
  • The TRI vs PRI trap: How funds using Price Return Index benchmarks create the illusion of alpha that disappears when you use the correct Total Return Index
  • Net alpha calculation: fund return − benchmark TRI return − expense ratio drag — computed for all available periods
  • Best passive alternative: not a generic "buy an index fund" recommendation, but the specific index fund or ETF that is the fairest comparison for that category
  • Alpha sustainability check: was the net alpha consistent across 3Y, 5Y, 7Y, or was it a single-period phenomenon?
  • The two verdicts: Choose Active (with specific conditions) or Choose Index (with the named alternative to switch to)
  • Worked example: HDFC Mid-Cap Opportunities Fund — from raw returns to conditional verdict

Key Skills You'll Master:

  • Calculate true net alpha after fees for any equity mutual fund
  • Identify whether an active fund's benchmark is fair or artificially easy to beat
  • Know which Indian equity fund categories most consistently fail the net alpha test
  • Interpret conditional verdicts and set appropriate review triggers
  • Evaluate the specific passive alternative recommended, including its own ER and tracking error

Test Your Knowledge

Click any flashcard to reveal the answer. Use the search box to find specific topics.

SECTION 1

The Question This Template Answers

Most investors evaluate active funds by comparing their returns to a benchmark. The fund returned 14%, the Nifty returned 11.5% — therefore the fund generated 2.5% alpha. This calculation is the standard scorecard used by every fund fact sheet, distributor comparison tool, and financial news article. And it is fundamentally incomplete.

It leaves out the most important cost: the expense ratio. The active fund charged you 1.1% per year to generate that 2.5% gross alpha. After fees, the true benefit you captured is only 1.4%. Meanwhile, an index fund tracking the same benchmark charges 0.10% — so even an index investor is earning 0.1% below the benchmark. The correct comparison is: does the active fund's net alpha after all costs exceed zero, and does it exceed the index fund's own cost drag by enough to justify staying active?

The Net Alpha Formula: True Net Alpha = Fund Return − Benchmark TRI Return − Expense Ratio Drag

Example: Fund returns 14%, benchmark TRI returns 11.5%, fund ER is 1.1%
Gross alpha = 14% − 11.5% = 2.5%
Net alpha = 2.5% − 1.1% = 1.4%

Index fund ER = 0.10%. Your true advantage from staying active = 1.4% − 0.10% = 1.3% per year. Still positive — but much thinner than the headline 2.5%.

The Active vs Index template in the Finmagine AI Advisor panel on VRO fund pages runs this cost-benefit evaluation systematically. It reads publicly available fund data from the page — returns, expense ratio, benchmark composition, category peers — and assembles it into a structured prompt that an AI platform then analyses to deliver a direct, reasoned verdict.

The template does not hedge. It ends in one of two conclusions: Choose Active or Choose Index. If the answer is conditional, the conditions are stated explicitly. If the answer is Choose Index, the specific passive alternative is named.

Why This Matters in India Now: Index funds in India now carry expense ratios of 0.05–0.20%. Nifty 50 index funds from major AMCs are available below 0.10%. This means an active large-cap fund charging 1.0% must consistently generate at least 1.0% + 0.10% = 1.1% gross alpha just to break even with a passive alternative. At the 5-year and 10-year time horizons, more than 70% of active large-cap funds in India have failed this test. The template makes this visible for any individual fund you are evaluating.

How the Template Accesses Fund Data

When you visit a fund page on Value Research Online (VRO), the Finmagine AI Advisor extension reads publicly available fund data from the page. The panel then gives you access to three prompt templates: Deep Analysis, Active vs Index, and Portfolio Fit. The Active vs Index template uses the returns data, expense ratio, benchmark details, and category information visible on the page to assemble a focused cost-benefit evaluation prompt. You copy it to your preferred AI platform and receive the analysis.

Best with Claude (claude.ai): The Active vs Index template is optimised for Claude. Claude's precise multi-step reasoning handles the net alpha computation, benchmark legitimacy check, and conditional verdict construction more reliably than other platforms on this specific template type. ChatGPT is also effective. Gemini is acceptable but tends to be less precise on the conditional verdict language.
SECTION 2

The Four Analyses the Template Runs

The Active vs Index template is structured as four sequential analyses, each building on the previous. Together they determine whether the final verdict is Choose Active or Choose Index.

Analysis 1 — Net Alpha After Fees

The template computes true net alpha for all available return periods: 1Y, 3Y, 5Y, 7Y, and 10Y where available. For each period:

The output is a table. A fund with positive net alpha in all 5 periods is a very different case from a fund with positive net alpha only in the most recent 1Y or 3Y window. The template does not average these — it presents them period by period and looks for consistency.

Analysis 2 — Benchmark Legitimacy Check

This is the analysis most individual investors never run. Indian mutual funds are required by SEBI to benchmark against a relevant index — but the choice of specific index, and whether it is the Price Return Index (PRI) or Total Return Index (TRI), can dramatically change the apparent alpha.

Benchmark Issue What It Means Alpha Impact
PRI vs TRI PRI ignores dividend reinvestment; TRI includes it. For Nifty 50, the gap is ~1.5–2.0% per year. Using PRI inflates apparent alpha by ~1.5–2.0% per year
Wrong index composition A large-cap fund benchmarked against Nifty 50 when it holds 30% mid-caps is unfair to the benchmark Mid-cap exposure in bull phases inflates alpha vs a pure large-cap index
Narrow peer index Fund benchmarked against a sector index when it invests more broadly Sector outperformance can appear as manager skill when it is just category allocation
Fair benchmark Correct composition + TRI confirmed + consistent with actual portfolio construction Alpha computed against this benchmark is genuine
The PRI Trap: Before April 2018, most Indian mutual fund marketing material compared returns against the Price Return Index. A fund that "beat the Nifty" by 2% per year in that era may have actually lagged the Nifty TRI. The template checks which benchmark version is being used and explicitly flags when PRI-based comparisons overstate alpha. If you see a fund boasting a long track record of alpha, always verify whether that track record is measured against TRI.

Analysis 3 — Best Passive Alternative Identification

The template does not recommend a generic "buy an index fund." It identifies the specific index fund or ETF that is the fairest passive comparison for the active fund being evaluated. This matters because different passive options within the same broad category can have very different characteristics.

For a mid-cap active fund, the relevant passive alternatives are mid-cap index funds — not Nifty 50 index funds. Within mid-cap index funds, the Nifty Midcap 150 index fund has a different composition than the Nifty Midcap 100 index fund. The template names the specific option, notes its current expense ratio from available data, and uses it as the cost baseline for the net alpha calculation.

Analysis 4 — Alpha Sustainability Check

Alpha in a single period can result from market conditions that favoured the fund's portfolio style rather than from manager skill. A large-cap value fund may show strong alpha in a bear market simply because its style is defensively positioned, not because the manager is exceptional. The sustainability check asks: is the net alpha consistent across all available periods (3Y, 5Y, 7Y), or is it concentrated in one phase?

SECTION 3

The Two Verdicts

Every Active vs Index analysis ends in one of two verdicts. The template is designed to be direct. "Monitor closely" or "the picture is mixed" are not verdicts — they are deferrals. The template forces a recommendation.

CHOOSE ACTIVE

Net alpha is consistently positive after fees across multiple periods, the benchmark is confirmed as TRI with fair composition, AUM is not at a scale that would impair the fund's strategy, and alpha is not concentrated in a single period. The active fund is generating enough sustained, cost-adjusted outperformance to justify the premium over a passive alternative.

CHOOSE INDEX

Net alpha is negative or near-zero after fees, or positive only in one period, or the benchmark is a PRI (making outperformance illusory when corrected for dividend reinvestment). The passive alternative is named specifically, with its expense ratio stated. The switch from active to that specific index fund is recommended.

Conditional Choose Active Verdicts

A Choose Active verdict is sometimes delivered with explicit conditions. These conditions are the reasons why the verdict could flip to Choose Index in the future. Examples of what conditions look like in the template's output:

How to Use a Conditional Verdict: When the template delivers Choose Active with conditions, note the specific conditions and set a calendar reminder to re-run the analysis. A 12-month review is the minimum. If AUM crosses the named threshold before then, re-run immediately. The conditions are not boilerplate — they are the specific trigger points that would change the recommendation.

The Near-Zero Net Alpha Case

What if net alpha after fees is 0.3%? This is not a clear Choose Active. The template is calibrated to treat near-zero net alpha (below approximately 0.5% sustained across multiple periods) as marginal. In this zone, the Choose Active verdict is not justified on a pure cost-benefit basis — the active fund is barely covering its own cost premium. However, the template does not mechanically issue Choose Index in this range. It evaluates whether:

If all three factors are neutral, the template will typically recommend Choose Index and note that the convenience of staying invested is the only argument for Active — and that convenience is not a financial argument.

SECTION 4

Which Categories Are Most Likely to Fail This Test

Not all mutual fund categories are equal in the Active vs Index contest. SEBI's categorisation rules, the efficiency of each category's investable universe, and the availability of good passive alternatives all determine how hard it is for an active manager to generate consistent net alpha.

Category Active vs Index Verdict Tendency Reason
Large Cap Most likely to Choose Index SEBI mandates 80% in large caps; leaves very little room for differentiation. The top 100 stocks are extensively researched and efficiently priced. Nifty 50 and Nifty 100 index funds are extremely cheap (0.05–0.10%). Most active large-cap funds have failed the net alpha test over 7Y+ horizons.
Multi Cap / Flexi Cap Mixed Flexi-cap allows meaningful mid and small-cap allocation which can generate genuine alpha. But the range of skill across funds is enormous. Evaluate each fund individually — category averages are misleading here.
Mid Cap Most likely to Choose Active The Nifty Midcap 150 universe has less analyst coverage than large caps. Skilled managers can identify mispriced mid-caps before the market catches up. However, AUM matters enormously here — large AUM impairs execution in the mid-cap space.
Small Cap Most likely to Choose Active The least-researched universe. Skilled small-cap managers can generate significant net alpha. But AUM risk is severe — large small-cap funds become de facto mid-cap funds. Check AUM carefully.
Thematic / Sectoral Not well-suited for this template Direct passive comparison is often unavailable. The template flags this and focuses on expense drag vs the sector index if one exists. The primary evaluation tool for thematic funds is portfolio composition, not Active vs Index.
Debt Funds Different question Active vs passive is a different framework for debt. Active debt management is about duration positioning and credit selection — not alpha over a simple index. This template is optimised for equity funds. See note below.
Debt Fund Note: The Active vs Index template in its current form is designed for equity mutual funds. For debt funds, the relevant questions are about credit risk, duration risk, fund manager's rate call track record, and yield-to-maturity vs similar-duration options. The template will note this limitation if applied to a debt fund category and redirect you to the Deep Analysis template which handles debt fund evaluation more appropriately.

The AUM Problem in Mid and Small Cap

Mid and small cap funds are the categories where active management is most likely to justify its cost — but they are also the categories most vulnerable to AUM-induced impairment. When a mid-cap fund reaches ₹30,000–50,000 Cr in AUM, the manager faces a structural problem: taking a meaningful position in a mid-cap stock (market cap ₹3,000–15,000 Cr) while deploying large capital requires either accepting thin liquidity or concentrating in fewer, larger mid-caps — which pushes the fund toward large-cap territory.

The template accounts for this. If AUM has grown significantly since the period of strongest net alpha, the sustainability of that alpha is explicitly questioned. A mid-cap fund that generated 4% net alpha when AUM was ₹8,000 Cr may struggle to replicate that with ₹60,000 Cr.

SECTION 5

How to Use the Output

The template generates a structured analysis with the net alpha table, benchmark legitimacy finding, passive alternative identification, sustainability assessment, and the final verdict. Here is how to act on each outcome.

If the Verdict Is Choose Active

Note the specific conditions stated in the verdict. Set a calendar reminder for 12 months to re-run the analysis. If any conditions reference AUM thresholds, monitor the fund's AUM quarterly — most AMC websites and VRO update AUM monthly. The Choose Active verdict is not a permanent endorsement — it is valid as of the analysis date, subject to the stated conditions.

Choose Active Action Checklist:
  • Record the conditions that make the verdict conditional
  • Set a 12-month review reminder
  • Note the AUM at the time of analysis as a baseline
  • Note the fund manager's name — track any personnel changes
  • Track net alpha at the next review using the same methodology

If the Verdict Is Choose Index

Use the AI-named passive alternative as your starting point. Before switching, verify two things: the passive alternative's current expense ratio (confirm it is still in the 0.05–0.20% range) and its tracking error over 3 years. Tracking error measures how closely the index fund replicates its benchmark — a high tracking error (above 1.5% for a major index fund) reduces the effective advantage of switching. Most Nifty 50 and Nifty Midcap 150 index funds from major AMCs have tracking errors well below 0.5%.

Choose Index Action Checklist:
  • Verify the named passive alternative's current ER on its AMC or VRO page
  • Check tracking error over 3Y (should be below 0.5% for major index funds)
  • Calculate switching cost: exit load (if any) + capital gains tax on current gains
  • Compute break-even period: switching cost ÷ annual net alpha advantage
  • If break-even is under 2 years, switch. If over 5 years, evaluate the ongoing cost of staying.

The Intermediate Case: Near-Zero Net Alpha

When net alpha after fees is in the 0.1–0.5% range, you face a marginal case. This is not a clear Choose Active, but the switching cost analysis matters. If you have held the active fund for several years with significant gains, the capital gains tax on switching could consume 3–5 years of the marginal alpha advantage. In this case, staying active is a rational decision — not because the active fund is justified on its merits, but because the switching cost destroys the benefit of switching at this moment.

The template will typically flag this as: "Marginal case — net alpha of 0.3% does not justify a new purchase but switching cost analysis may justify holding for existing investors." This is a nuanced output that the standard benchmark comparison would never surface.

SECTION 6

Worked Example: HDFC Mid-Cap Opportunities Fund

HDFC Mid-Cap Opportunities Fund is one of the largest and most widely held mid-cap funds in India. It is a useful worked example because it presents a genuinely interesting case — strong gross alpha, high AUM, a legitimate TRI benchmark, and a clear best passive alternative to compare against.

Fund Profile

Parameter Value
Category Mid Cap
Expense Ratio (Direct) ~0.79%
Benchmark Nifty Midcap 100 TRI
Benchmark Type TRI — confirmed valid
AUM (approximate) ₹~70,000 Cr
Best Passive Alternative Nifty Midcap 150 Index Fund (Direct), ER ~0.20%

Analysis 1: Net Alpha After Fees

Period Fund Return Nifty Midcap 100 TRI Gross Alpha Net Alpha (after 0.79% ER)
3Y ~22% ~20% +2.0% +1.2%
5Y ~25% ~21% +4.0% +3.2%
7Y ~18% ~15% +3.0% +2.2%

Net alpha is positive across all three available periods. The 5Y net alpha of 3.2% is the strongest signal. The 3Y net alpha of 1.2% is lower, which may reflect the impact of the large AUM base on mid-cap execution as the fund has grown. Both figures remain clearly positive.

Analysis 2: Benchmark Legitimacy Check

The benchmark is Nifty Midcap 100 TRI. TRI is confirmed — no PRI inflation issue. The benchmark composition is appropriate: the fund is required by SEBI to hold at least 65% in mid-cap stocks (ranks 101–250 by market cap), and the Nifty Midcap 100 is a broadly representative mid-cap index. The benchmark is fair.

Note: the passive alternative used in Analysis 3 is the Nifty Midcap 150 index (not Nifty Midcap 100), because the Midcap 150 better represents the investable mid-cap universe and has more liquid index funds tracking it. The template makes this explicit when there is a slight mismatch between the fund's stated benchmark and the fairest passive comparison.

Analysis 3: Best Passive Alternative

The named passive alternative is a Nifty Midcap 150 Index Fund (Direct plan) from a major AMC, with an expense ratio of approximately 0.20%. This is not a hypothetical — multiple fund houses now offer Midcap 150 index funds in the Direct plan at this cost level. The advantage of choosing the Midcap 150 over a Midcap 100 index fund is broader diversification (150 stocks vs 100) and typically lower tracking error due to higher liquidity across the expanded universe.

Alpha advantage of staying active over this specific passive alternative:

The 5Y advantage of 2.6% per year is substantial — comfortably justifying the active fund premium on a pure numbers basis. A ₹10 lakh investment earning 2.6% extra per year compounded over 10 years is approximately ₹2.9 lakh in additional wealth. This is not a marginal case.

Analysis 4: Alpha Sustainability Check

Net alpha is positive across 3Y, 5Y, and 7Y periods. However, there is a notable pattern: the 3Y net alpha (1.2%) is lower than the 5Y net alpha (3.2%) and 7Y net alpha (2.2%). This suggests that the most recent 3-year period has seen some compression in outperformance relative to the fund's longer history. The template identifies this as consistent with the AUM growth concern — as the fund has grown to ₹70,000 Cr, deploying capital effectively in the mid-cap space has become more challenging.

The Verdict and Its Conditions

VERDICT: CHOOSE ACTIVE — Conditionally

Net alpha of 3.2% over 5Y and 2.2% over 7Y consistently exceeds the cost of staying active (0.59% ER differential over the passive alternative). Benchmark is TRI with fair composition. Alpha is multi-period, not a single-window phenomenon.

Conditions on this verdict:

  • Monitor the 3Y net alpha trend. If it declines below 1% in the next annual review, re-evaluate.
  • The AUM at ₹~70,000 Cr warrants close attention. If it crosses ₹80,000 Cr without a corresponding improvement in the 3Y net alpha trend, the AUM impairment risk becomes material.
  • Verify that no fund manager change has occurred since this analysis date.
  • Re-run this analysis in 12 months using updated return data.
What the Conditional Verdict Tells You: This is not a weak or hedged answer. HDFC Mid-Cap Opportunities has a strong case for active. But the conditions are not boilerplate warnings — they are the specific pressure points that are already showing early signals (declining 3Y net alpha, large AUM). Monitoring these is part of what owning an active fund requires. If you are not willing to re-evaluate annually, the passive alternative is a cleaner choice.

VRO MF Analysis Series

This article is Part 4 of 6 in the VRO MF Analysis tutorial series for the Finmagine AI Advisor extension.

Get the Finmagine AI Advisor Extension

Access the Active vs Index template and two other MF analysis templates — Deep Analysis and Portfolio Fit — directly on Value Research Online fund pages. Available now in the Chrome Web Store.

Get Finmagine AI Advisor →

Free Chrome Extension

Ready to try this yourself?

Install the Finmagine AI Advisor and generate institutional-grade research prompts from any Screener.in or stockanalysis.com company page in seconds.

Install from Chrome Web Store →

No account required • Works on Chrome, Edge, Brave, Opera

Join Finmagine WhatsApp Community
← Back to Blog Hub