← Back to Projects Fund Screening · Indian Mutual Funds · SEBI / AMFI Data · v4.0 · Full SEBI Universe

Screening Framework

A 4-phase systematic framework covering the full active SEBI mutual fund universe. Phases 1 & 2: 3-layer scoring model (pass/fail gates, quantitative scoring, analyst overlay) applied to 273 funds across 15 equity and hybrid categories. Phase 3: structured comparison tool across 20 sector and thematic themes (169 funds, not scored). Phase 4: solution-oriented and FoF categories (64 funds) with lock-in, fee-layering, and structural heterogeneity analysis. Built from ACE MF data (sourced from AMFI and AMC disclosures). Data: March 2026.

Funds Scored 273 177 equity + 96 hybrid
Total Coverage 462 across all 4 phases
SEBI Categories 40 15 scored + 25 comparison-only
Scoring Factors 5 Equity; adapted per hybrid category

Why Build a Screening Model

India's mutual fund industry has ~₹67 lakh crore in equity AUM across hundreds of schemes. Most retail investors pick funds based on trailing 1-year returns or star ratings from aggregators. The problem: trailing returns are backward-looking, and star ratings collapse multi-dimensional fund quality into a single number with opaque methodology.

This model was built during my time at Omega Portfolio Advisors / MoneyWorks4Me to power fund recommendations for Third Rock Wealth's (TRW) client-facing dossiers. The goal was a repeatable, auditable framework that separates genuine alpha generators from funds riding beta in a rising market.

The core design choice: score funds within their own SEBI category using percentile ranks, not absolute values. A large-cap fund generating 1.5% alpha is doing something meaningfully different from a small-cap fund generating 1.5% alpha. The benchmark difficulty, volatility profile, and capacity constraints are entirely different. Category-relative scoring is the only honest comparison.

Three Layers of Filtration

Every fund in the starting universe passes through three sequential layers. Each layer eliminates or scores, so that the final output is a ranked shortlist with both quantitative rigour and qualitative context.

Layer 1

Pass / Fail Gates

Binary filters that eliminate funds with structural disqualifiers. Funds must pass all gates to enter the scoring engine. The gates remove funds that are too small, too young, or too expensive to be taken seriously for long-term allocation.

AUM Floor ≥ ₹500 Cr  (₹300 Cr ELSS)
Track Record ≥ 3 Years
Alpha Floor 3Y Alpha > −5%
Result Equity: 260 → 177  ·  Hybrid: 166 → 96
Layer 2

5-Factor Quantitative Scoring

Each surviving fund is scored on 5 weighted factors, producing a composite score from 0 to 100. All sub-metrics are converted to within-category percentile ranks before weighting, so the scoring is relative to peers in the same SEBI category.

Factor Weight Key Metrics
Alpha Generation 25% 3Y excess return vs. primary stated benchmark
Risk-Adjusted Returns 25% 3-year Sharpe ratio
Return Consistency 25% Avg percentile rank across 1Y, 3Y, and 5Y alpha
Downside Protection 20% 3-year Sortino ratio
Cost Efficiency 5% Regular plan expense ratio (inverted percentile)

Hybrid categories use adapted factor sets. Benchmark-distorted metrics (capture ratios, alpha, info ratio) are excluded where stated benchmarks are structurally invalid, e.g. arbitrage funds scored on cost and yield consistency only.

Output Composite score 0–100 + rating band
Layer 3

Qualitative Analyst Overlay

Numbers catch pattern, but they miss context. The qualitative layer adds a /10 analyst score based on dimensions that purely quantitative screens cannot capture. This overlay can upgrade or downgrade a fund's final rating.

FM Pedigree Manager tenure, track record, team depth
Key-Person Risk H / M / L classification
AUM Capacity Size vs. strategy fit
Style Drift Mandate adherence over time
ER Spread Regular - Direct (distributor fee proxy)
Client Suitability Risk profile match

What the Data Shows

After running 273 funds through the full scoring engine across 15 SEBI categories, several patterns emerged that challenge conventional fund selection logic, in both equity and hybrid universes.

01

Alpha Exists — But Quality Is What Matters

81% of the 177 scored equity funds generated positive 3-year alpha. But positive alpha alone is not the bar — only 37% (66 equity funds) earned Strong Buy or Buy. Generating modest alpha in a rising market is not difficult. Doing it consistently, with strong downside protection and low volatility, is rare.

02

The Top Is Genuinely Thin

Of 273 scored funds, only 63 earned Strong Buy (23%) and 37 earned Buy (14%). The remaining 173 funds — 63% of the universe — scored Hold or below. The model is deliberately demanding: it separates genuine quality from noise, and most funds are noise.

03

Sortino Ratio Separates the Top Quartile

Across all 8 equity categories, Sortino ratio, return per unit of downside deviation, is one of the clearest separators between top and bottom-quartile funds. Unlike Sharpe, Sortino only penalises downside volatility, not upside. Funds that protect capital during drawdowns compound more powerfully over time than those generating equivalent returns with higher drawdown depth.

04

Small Cap Has the Widest Score Spread

Small Cap funds show the widest dispersion (11.3 to 97.1), while Mid Cap and Flexi Cap fund scores cluster more tightly. Small-cap alpha is highly manager-dependent: stock selection matters far more in illiquid segments where passive replication is expensive. The gap between the best and worst small-cap manager is the largest in the equity universe.

05

ELSS: Lock-In Amplifies Consistency Importance

ELSS funds carry a mandatory 3-year lock-in, which means investors cannot exit during a drawdown. The model raises the Consistency weight from 25% to 30% (and reduces Alpha to 20%) for ELSS. A fund that is highly volatile but occasionally generates strong alpha scores lower here than a fund that beats its benchmark steadily — because the investor has no exit if volatility turns negative.

06

ER Spread Reveals Distribution Economics

The gap between Regular and Direct plan expense ratios (ER Spread) is a direct proxy for distributor commissions. Funds with unusually high ER Spreads are spending heavily on distribution. This raises a question that quantitative models can flag but not answer: is AUM growth organic or fee-driven?

07

Hybrid Benchmarks Are Structurally Broken

Across the 7 hybrid categories, benchmark-relative metrics (alpha, capture ratios, information ratio) are unusable for cross-fund comparison in 4 of 7 categories. Equity Savings, Multi Asset, and Conservative Hybrid funds are commonly benchmarked against pure bond indices (CRISIL 10Y Gilt), making their "alpha" arithmetically meaningless. Multi Asset funds use 9 different benchmarks including Gold, Silver, and MSCI World. The model detects and excludes distorted metrics per category, using absolute risk metrics (Sharpe, Sortino, Std Dev) as the scoring backbone for hybrid funds.

08

In Arbitrage, Cost Is Almost the Entire Outcome

The 16 scored arbitrage funds returned between 5.82% and 6.23% over the trailing year, a spread of just 41 basis points. The ER spread across the same funds is 33 basis points. In a product where the strategy itself is commoditised, up to 80% of observable performance difference is attributable to cost alone. The model scores arbitrage funds primarily on ER% (50% weight) and yield consistency (40%), omitting Sharpe and Sortino entirely, both are artifactually elevated by near-zero volatility and provide no useful ranking signal.

Rating Band Distribution

Composite scores are mapped to 5 rating bands. The thresholds are calibrated to produce a demanding distribution where most funds fall below "Buy." Distribution shown across all 273 scored funds (equity + hybrid).

63
37
65
52
56
Strong Buy Buy Hold Underweight Avoid
Strong Buy ≥ 75
Buy 60 – 74.9
Hold 45 – 59.9
Underweight 30 – 44.9
Avoid < 30

Coverage by SEBI Category

Phases 1 & 2 cover 15 SEBI fund categories across equity and hybrid segments, each fund scored against category peers using percentile ranks. Hybrid categories use adapted factor sets where benchmark-relative metrics are structurally unreliable. Phase 3 adds sector & thematic coverage as a comparison tool across 20 additional themes. Phase 4 covers solution-oriented funds (retirement, children's) and fund-of-funds (domestic + overseas), presented as structured reference tables given the structural differences that prevent standard scoring.

Equity Categories — 8 categories, 177 scored funds

Large Cap 17 funds
Benchmark: Nifty 100 TRI
Score Range 11.5 – 94.2
Avg Score 52.9

The Nifty 100 is highly efficient. Genuine outperformers stand out starkly against significant underperformers in this category.

Flexi Cap 27 funds
Benchmark: Nifty 500 TRI
Score Range 14.4 – 92.9
Avg Score 51.9

Largest category by fund count. No market-cap mandate means manager flexibility is high — and style drift risk is highest here.

Mid Cap 26 funds
Benchmark: Nifty Midcap 150 TRI
Score Range 11.8 – 93.5
Avg Score 51.9

AUM capacity constraints become material in mid cap. Large funds face liquidity drag that compresses returns.

Small Cap 23 funds
Benchmark: Nifty Smallcap 250 TRI
Score Range 11.3 – 97.1
Avg Score 52.2

Widest composite score spread of any category. Highest beta. Downside protection and capture asymmetry are the critical differentiators.

ELSS 24 funds
Benchmark: Nifty 500 TRI
Score Range 11.8 – 92.9
Avg Score 52.1

Tax-saving funds with mandatory 3-year lock-in. Consistency weighted at 30% (vs 25% default) to reflect locked-in investor exposure. AUM gate lowered to ₹300 Cr.

Multi Cap 19 funds
Benchmark: Nifty 500 Multicap 50:25:25 TRI
Score Range 16.7 – 92.4
Avg Score 52.6

SEBI mandates minimum 25% each in large, mid, and small cap. The mandatory small-cap exposure introduces higher volatility than flexi cap funds with similar names.

Large & Mid Cap 22 funds
Benchmark: Nifty LargeMidcap 250 TRI
Score Range 12.6 – 93.4
Avg Score 52.3

Mandated 35% minimum in both large and mid cap. Less flexible than flexi cap but broader than pure large cap. Good risk/return profile for moderate risk tolerance.

Focused Fund 19 funds
Benchmark: S&P BSE 500 TRI
Score Range 10.2 – 92.1
Avg Score 52.6

Pure equity funds with a maximum 30-stock mandate. High-conviction portfolios. Idiosyncratic risk is structurally higher — a wrong sector call is amplified by concentration.

Hybrid Categories — 7 categories scored, 96 funds  ·  1 display-only

Aggressive Hybrid 22 scored
Weights: Info Ratio 25% · Sharpe 25% · Consistency 25% · Sortino 20% · Cost 5%
Score Range 15.0 – 97.0
Avg Score 52.3

65–80% equity. Information Ratio leads (25%) to reward genuine benchmark outperformance. Raw alpha replaced by IR to correct for benchmark-selection distortion common in this category.

Balanced Advantage & DAA 25 scored
Weights: Sharpe 30% · Sortino 30% · Capture Asymmetry 25% · Consistency 10% · Cost 5%
Score Range 4.2 – 95.2
Avg Score 52.0

BAF and DAA treated as a single 36-fund peer group. Alpha gate removed, negative alpha is structurally expected. Capture Asymmetry (Up Cap % − Down Cap %) directly tests whether the dynamic allocation model is adding or destroying value.

Equity Savings 13 scored
Weights: Sharpe 30% · Sortino 30% · Consistency 20% · Std Dev 15% · Cost 5%
Score Range 25.7 – 86.0
Avg Score 53.8

11/13 post-gate funds use CRISIL 10Y Gilt as stated benchmark. All benchmark-relative metrics excluded from scoring. Std Dev (3x spread: 0.71–2.26) is the strongest differentiator, funds that cannot control volatility fail their own mandate.

Multi Asset Allocation 10 scored
Weights: Sharpe 30% · Sortino 30% · Consistency 20% · Std Dev 15% · Cost 5%
Score Range 21.5 – 85.0
Avg Score 55.0

Extreme benchmark fragmentation: Gold, Silver, Nifty 50, BSE 500, MSCI World, bond indices, 9 different benchmarks across 30 funds. Down Capture range of −237% to +7,675% confirms that capture ratios are noise. Age gate (≥3Y) leaves only 10 funds, a new category with limited track records.

Conservative Hybrid 10 scored
Weights: Sharpe 30% · Sortino 30% · Consistency 20% · Std Dev 15% · Cost 5%
Score Range 16.1 – 93.0
Avg Score 55.3

75–90% debt. Two funds with NaN alpha (Nifty 50 Hybrid Composite Debt 15:85 benchmark has no data in ACE MF export) are treated as gate-pass, data gap, not underperformance. On a ~8–9% gross-return product, cost efficiency has outsized impact on net investor returns.

Arbitrage 16 scored
Weights: ER% 50% · Consistency (CAGR) 40% · 1Y CAGR 10%
Score Range 7.7 – 93.5
Avg Score 53.1

Entirely different framework. Delta-neutral product: no directional equity risk. Sharpe, Sortino, and Std Dev excluded, all are artifactually elevated by near-zero volatility. Return spread of 32–41 bps across all horizons. ER range of 33 bps explains most of observable performance difference.

Balanced Hybrid 2 funds — display only
40–60% equity mandate · No scoring
Track Record < 3 years
Min Peer Group Needs ≥ 5 funds

Only 2 AMCs run this category. Both funds are under 3 years old with no 3Y CAGR data. Percentile ranking requires a meaningful peer group, not yet available. Revisit when category reaches ≥5 funds with ≥3Y history.

Phase 3, Sector & Thematic Comparison Tool

Not a scoring model. Sector and thematic funds cannot be ranked with a single composite, a Pharma score and an Infrastructure score are not comparable. Phase 3 is a comparison reference: 20 themes across 169 funds in universe, 134 AUM-gated (≥₹500 Cr), sorted by Sharpe within each theme. Benchmark-relative metrics are shown for reference only, benchmarks are inconsistent within most categories (e.g. many funds use Nifty 50 regardless of actual sector focus).

Sector Funds — 7 themes · 52 gated funds

Banking & Financial Services 11 funds
Universe: 16 · AUM gate removes 5 small funds
Top Sharpe 0.354
Leader SBI Banking & Fin Svcs

Mixed benchmarks (Nifty Fin Svcs / Nifty 50 / BSE BANKEX). Sharpe comparison valid within theme, risk-adjusted returns vary significantly despite similar mandates.

Pharma & Healthcare 7 funds
Universe: 12 · Several new funds <₹500 Cr
Top Sharpe 0.443
Leader HDFC Pharma & Healthcare

Strongest Sharpe ratio of all sector themes. BSE Health Care is the appropriate benchmark, avoid comparing alpha across funds using Nifty 50 as stated benchmark.

Technology & Digital 5 funds
Universe: 8 · Several launched post-2022
Top Sharpe 0.103
Leader Tata Digital India

Low Sharpe across the theme reflects IT sector underperformance in the 2022–2024 period. Tata Digital India is the oldest fund with the longest track record (10Y).

Infrastructure 9 funds
Universe: 11 · Includes DSP T.I.G.E.R & BoI Mfg+Infra
Top Sharpe 0.366
Leader Bank of India Mfg & Infra

Heterogeneous benchmarks (BSE Infra / Nifty Infra / Nifty 50). Several older funds (18–22Y) with full track records. High dispersion in risk-adjusted returns.

Consumption & Consumer 13 funds
Universe: 16 · Includes thematic consumption funds
Top Sharpe 0.243
Leader Tata India Consumer

Largest sector theme by fund count. Mixed SEBI classification (some as Sector Funds, some as Thematic). Nifty India Consumption is the most appropriate benchmark, ~40% of funds use Nifty 50 instead.

Energy & Resources 5 funds
Universe: 6 · Most launched post-2022
Top Sharpe 0.395
Leader DSP Natural Res & New Energy

Benchmark diversity extreme: Nifty Energy / MSCI World Energy / Nifty Commodities / Nifty 50. Alpha comparisons across funds are meaningless. Use Sharpe only.

Services & Automotive 2 funds
Universe: 3 · SBI Automotive <3Y track record
Top Sharpe 0.269
Leader Sundaram Services

Small peer group. Sundaram Services (7.5Y) vs SBI Automotive (1.8Y). Peer comparison limited, use as directional reference only.

Thematic Funds — 12 themes · 82 gated funds

Manufacturing 11 funds
Universe: 11 · All pass AUM gate
Top Sharpe 0.351
Leader Kotak Manufacture in India

New SEBI category (post-2022 launch for most funds). Majority benchmark vs Nifty India Manufacturing TRI, more consistent than most thematic themes. Sharpe data based on <3Y history for 9 of 11 funds.

Business Cycle 16 funds
Universe: 17 · Largest thematic theme
Top Sharpe 0.274
Leader Kotak Business Cycle

All funds benchmarked to Nifty 500 or Nifty 50, broader index, not sector-specific. Effectively a flexible equity strategy with a business cycle narrative. Most launched 2021–2022.

PSU / Govt Enterprise 4 funds
Universe: 5 · Benchmarks: BSE PSU / Nifty PSE / Nifty 50
Top Sharpe 0.387
Leader SBI PSU Fund

Strong Sharpe driven by PSU sector re-rating (2021–2024). SBI PSU is the oldest (15.7Y) and largest. ABSL PSU has grown rapidly (₹6,086 Cr). Returns highly correlated with government capex cycle.

Innovation & Special Situations 15 funds
Universe: 17 · Includes Defence, Pioneer, IPO funds
Top Sharpe 0.382
Leader ICICI Pru Innovation

Heterogeneous group, mandates range from structured innovation plays (ICICI Pru Innovation, ₹7,487 Cr) to defence (HDFC Defence, ₹8,097 Cr) to recently-listed IPOs. Not a comparable peer group.

ESG & Ethical 4 funds
Universe: 9 · AUM gate removes 5 small funds
Top Sharpe 0.234
Leader ABSL ESG Integration Strategy

Mixed ESG approaches: integration strategy, exclusionary, Shariah-compliant, ethical screens. Benchmarks range from Nifty 100 ESG to Nifty 50. Low AUM concentration, weak investor adoption.

Transportation & Logistics 5 funds
Universe: 5 · All pass AUM gate
Top Sharpe 0.386
Leader ICICI Pru T&L Fund

Most consistent benchmark (Nifty Transportation & Logistics TRI) of any thematic theme, meaningful alpha comparisons possible within this group. Category launched 2022–2024.

Housing 3 funds
Universe: 3 · All pass AUM gate
Top Sharpe 0.259
Leader ICICI Pru Housing Opp

Small peer group. ICICI Pru (₹2,437 Cr) vs HDFC (₹1,272 Cr) vs Tata (₹502 Cr). Housing theme has benefited from real estate cycle. Benchmarks inconsistent (Nifty Housing vs Nifty 50).

Momentum 5 funds
Universe: 7 · Most launched 2023–2024
Top Sharpe 0.157
Leader Quant Momentum

Young theme, all 5 post-gate funds have <3Y history. Sharpe is based on <3Y data. Low Sharpe reflects the 2024 momentum reversal that hurt this strategy. Do not compare to older category funds.

Quant & Factor 11 funds
Universe: 14 · Includes minimum variance & quality
Top Sharpe 0.353
Leader 360 ONE Quant Fund

Diverse strategies, quantitative screening, multi-factor, minimum variance, quality. Cannot meaningfully compare a quant fund vs a minimum variance product. Use within sub-strategy only.

MNC 3 funds
Universe: 3 · All pass AUM gate
Top Sharpe 0.185
Leader ABSL MNC Fund

ABSL MNC is the oldest fund (26Y) with the longest track record. HDFC MNC and Kotak MNC are relatively new (<3Y). Nifty MNC is the appropriate benchmark for this theme.

Commodities 2 funds
Universe: 2 · Both pass AUM gate
Top Sharpe 0.325
Leader SBI Comma Fund

Minimal peer group. SBI Comma (20.7Y, ₹999 Cr) vs ICICI Pru Commodities (6.5Y, ₹3,677 Cr). Very limited comparison value. ICICI has 3x the AUM but lower Sharpe.

Other Thematic 3 funds
Universe: 4 · International, rural, conglomerates
Top Sharpe 0.404
Leader Nippon India Taiwan Equity

Miscellaneous group, Nippon India Taiwan Equity (overseas), HDFC Defence, ICICI Pru Rural Opportunities. No meaningful within-group comparison. Displayed for completeness.

Phase 4, Misc & Special Categories

Solution-oriented and FoF categories with structural differences that prevent standard scoring. No composite scores, peer groups are too small and mandates too heterogeneous for percentile ranking. Funds presented as comparison references within logical sub-groups.

Solution Oriented, Retirement 18 funds · 3 sub-groups
Lock-in until age 60 · AUM gate ₹200 Cr · 9 displayed
Sub-groups Equity / Balanced / Conservative
ER Impact (30Y) 0.5% ER diff = ₹1.2 Cr

Benchmarks are structurally heterogeneous across plan types (equity plan vs debt plan). Sub-grouped by equity allocation: Equity-Oriented (65%+), Balanced (30–65%), Conservative/Debt (<30%). Sorted by Sharpe within each sub-group. Lock-in amplifies ER impact dramatically over a 20–30Y horizon.

Solution Oriented, Children's Fund 8 funds · display only
Lock-in until child turns 18 · Mixed mandates
AUM Range ₹15 Cr – ₹5,354 Cr
Top Sharpe 0.511 (SBI Children's Savings)

Small N, mixed equity/hybrid/debt mandates, no composite scoring. AUM is highly concentrated: SBI Children's Investment Plan (₹5,354 Cr) holds ~74% of category AUM. Tata and SBI Children's Savings Plan have 24–30Y track records. Displayed for completeness.

FoFs Domestic 25 funds · 5 sub-strategies
Fee layering: ER shown = wrapper cost only · Underlying costs embedded in NAV
ER Range 0.08% (BHARAT Bond) to 1.51%
Largest Sub-group Income Plus Arbitrage (7 funds)

5 sub-strategies, each structurally distinct. BHARAT Bond: passive ETF wrapper (ER 0.08% = wrapper only; underlying ETF ~0.0005%); government bonds, target-maturity structure, largest domestic FoF category by AUM. Income Plus Arbitrage: dynamic 60% debt + 40% equity/arbitrage allocation; classified as debt for tax. Silver ETF FoF: SIP-accessible silver exposure, no demat required. Passive FoF: multi-index or index-of-index wrappers. Active Multi-Asset: underlying active funds, highest fee drag. ER shown is wrapper cost only, underlying fund TER is deducted from NAV, not displayed separately. Compare ER within sub-strategy only; BHARAT Bond 0.08% vs Active Multi-Asset 1.51% are not comparable products.

FoFs Overseas 13 funds · 2 sub-types
⚠ CLOSED TO NEW INVESTMENTS since February 2022
AUM Leader Kotak US Equity (₹3,707 Cr)
Total ER (Active) ~2.0–2.5% (FoF + underlying)

No new investments permitted. RBI's USD 7 billion industry-wide overseas mutual fund investment cap was breached in February 2022. All 13 overseas FoFs have been closed to new lump sums and new SIP registrations since then. Existing investors can continue existing SIPs and can redeem freely, but cannot add fresh capital. RBI has not raised the cap. Displayed here for completeness and for existing investors monitoring performance. Two sub-types: Equity/Specialty (US equity, REIT, clean energy, Asia Pacific) and Overseas Debt (US Treasury ETF wrappers). Active overseas FoFs carry double fee drag: FoF ER (1.4–2.4%) plus underlying overseas fund ER, compounding to 2.0–2.5% total annually.

Technical Appendix

The full methodology is now consolidated in a single combined document (v4.0) covering all four phases. It includes the complete Phase 1 & 2 scoring engine (equity + hybrid, 273 funds), the Phase 3 sector & thematic comparison framework, and the Phase 4 solution-oriented and FoF reference tables, with all corrections applied. The original phase-specific PDFs are retained below as archived references.

Archived, Phase-Specific Documents

The underlying Excel model is not published. It contains proprietary scoring logic built during my work at Omega Portfolio Advisors and is used internally for TRW client recommendations. This page and the PDF appendix document the methodology and findings for portfolio demonstration purposes.

Sources & Limitations

All fund data is sourced from ACE Mutual Fund, which aggregates data from AMC filings with SEBI and AMFI. The dataset contains 47 variables per fund across returns, risk ratios, portfolio composition, rolling returns, and benchmark data. Data is as of the most recent available filing period.

Key limitations: The model uses point-in-time snapshots, not time-series panels. Rolling return data is pre-computed by ACE MF at the 1-month frequency (1Y, 3Y, 5Y, 10Y windows). Alpha is calculated as fund CAGR minus benchmark CAGR, which is an arithmetic approximation, not a regression-based Jensen's alpha. Survivorship bias is partially present since the ACE MF universe only includes currently active schemes.

The model is designed for relative ranking within categories, not absolute return prediction. A "Strong Buy" rating means a fund scores well relative to peers on the chosen factors. It is not investment advice.