TL;DR: Choosing a mutual fund is a filtering job, not a prediction. Pick the category first, then compare each fund with the median of its own category — not with the fund your colleague holds. Keep funds whose 5-year CAGR beats that median, whose rolling 3-year returns beat it in most windows, whose worst fall you could sit through, and whose expense ratio isn't eating the difference. On live data for 45 Direct-plan flexi-cap funds, those filters leave a shortlist of two to six in a couple of minutes. This guide walks through the seven filters, a worked example, and the mistakes that make a fund look better than it is.
Last updated: 15 September 2026 · 10 min read
By Pulkit Mangal — trader since 2017 and founder of TradeDiary, which built the free mutual fund screener this guide uses. Every figure below comes from AMFI NAVs as of 14 September 2026.
Most mutual fund decisions in India start the same way: a fund tops a "best returns" list, someone forwards it, and the SIP goes in. The problem isn't that the fund is bad. It's that a single number — usually the 1-year or 3-year return — is doing all the work, and that number mixes three different things together: what the whole category did, what the fund manager added, and luck.
Separate those three and fund selection gets dull in the best way. You stop asking "which fund is best?" — a question nobody can answer — and start asking "which funds in this category have beaten their peers, consistently, at a cost and a risk level I can live with?" That question has an answer, and you can get it from public data.
💡 Short on time? The free mutual fund screener applies every filter in this guide to about 1,700 Direct-plan funds — no signup needed. Create a free account only if you want to save your screens.
What "choosing a mutual fund" should actually mean
Choosing a mutual fund means narrowing a category of similar funds down to a short list, using filters you decide in advance, and then picking from that short list. It is a comparison inside a group, not a hunt for the highest number on a page.
Three India-specific details change how you should read any fund's numbers:
- Direct vs Regular plans. Every scheme has a Direct plan and a Regular plan with the same portfolio. The Regular plan charges a higher expense ratio to pay distributor commission, so its returns trail the Direct plan by that difference every single year. Compare Direct with Direct.
- SEBI's categories. Since SEBI's October 2017 categorisation circular, a "large cap fund" or a "flexi cap fund" has a defined mandate. That's what makes a category median meaningful: the funds in it are fishing in the same pond.
- Tax and exit load. Equity-fund gains held over 12 months are taxed at 12.5% above ₹1.25 lakh a year; under 12 months at 20%. Debt-fund units bought on or after 1 April 2023 are taxed at your slab rate however long you hold them. Many equity funds also charge an exit load — often 1% — if you redeem within a year. Check the scheme information document before you buy.
Why a fund's return means nothing on its own
A 16% 5-year CAGR sounds excellent. For a large-cap fund it would be. For a small-cap fund it's roughly what the typical fund did. Here is what the middle Direct-plan fund in each category returned, from our screener's data as of 14 September 2026:
| Category | Funds | 3-yr CAGR (median) | 5-yr CAGR (median) | Expense ratio (median) | Worst fall (median) |
|---|---|---|---|---|---|
| Large Cap | 33 | 10.08% | 9.28% | 1.02% | −35.14% |
| Flexi Cap | 45 | 12.09% | 11.18% | 0.89% | −29.87% |
| Large & Mid Cap | 35 | 13.71% | 12.89% | 0.90% | −35.69% |
| Mid Cap | 32 | 17.51% | 15.91% | 0.81% | −32.76% |
| Small Cap | 35 | 16.13% | 16.50% | 0.77% | −34.64% |
| ELSS (Tax Saver) | 37 | 11.01% | 11.15% | 0.93% | −35.69% |
| Aggressive Hybrid | 31 | 11.00% | 10.11% | 0.93% | −28.65% |
| Liquid | 42 | 6.96% | 6.34% | 0.13% | −0.13% |
Two things jump out. First, the gap between categories — a mid-cap median of 15.91% against a large-cap median of 9.28% over five years — is far bigger than the gap between most funds inside a category. Picking the category is the big decision; picking the fund is the refinement. Second, a higher-returning category came with the same or deeper falls along the way. Return and risk arrive together.
So the first rule of reading a fund's return: put its category median next to it. A small-cap fund at 17% is a middling small-cap fund. A large-cap fund at 12% is a strong one.
The seven filters that matter
| Filter | Why it matters |
|---|---|
| Category | Sets the risk you're signing up for. Decide it from your goal and horizon before looking at any fund. |
| 5-yr CAGR vs category median | Shows whether the fund beat funds with the same mandate over a full market cycle, not just a good year. |
| Rolling 3-yr consistency | The share of month-end 3-year windows in which the fund beat its category median. Separates a steady fund from one lucky stretch. |
| Worst fall | The deepest peak-to-trough drop in the fund's history. The number you'll actually live through, and the one that makes people stop their SIPs. |
| Expense ratio | Comes out of your return every year, guaranteed. The only filter where lower is always better. |
| Fund age | Under five years, you can't see a full cycle, and the worst fall may never have been tested. |
| Minimum SIP and fund size | Practical fit. A ₹100 minimum SIP helps you start small; very small funds can be closed or merged. |
Optional extras worth a glance: the riskometer (SEBI's six-level label, Low to Very High), lock-in (ELSS funds lock each instalment for three years), and fund manager tenure.
Rolling consistency deserves a second look, because it catches the fund that looks great only because of when you're looking. In our data, 33 equity funds are currently above their category's 3-year median yet beat that median in fewer than 40% of rolling 3-year windows over the last five years. Their trailing return is real, but it's recent — a hot stretch, not a habit.
Worst fall needs context too. Among Direct-plan equity index funds, the median worst fall looks mild at −18.2% — but 231 of the 257 were launched after March 2020 and never lived through that crash. The 26 older index funds have a median worst fall of −37.6%. A young fund's drawdown is untested, not low.
How to screen funds, step by step
- Write down the goal and horizon. Money you need within three years doesn't belong in an equity fund; 10+ years can take equity's falls. This decides the category.
- Pick one category and look at its median figures before any single fund.
- Keep funds that beat the category's 5-year median. In the screener, tick "5-yr above its category median".
- Require consistency. Set rolling 3-year beat-the-median to 60% or higher, so a fund had to outperform in most windows, not one.
- Cap the cost. Set a maximum expense ratio at or below the category median.
- Set a minimum age of five years if you want a record through at least one bad patch.
- Look at the worst fall of what's left and be honest about whether you'd keep investing through it.
- Read the scheme documents of your final two or three for exit load, benchmark and mandate — then decide.
A worked example: one category, four filters
Ritika, 31, a product designer in Pune, wants to start a ₹15,000 monthly SIP for a goal 12 years away. She settles on a flexi-cap fund, so the manager can move between large, mid and small caps. (Ritika is a composite; the fund counts are real screener results for Direct-plan growth funds on 14 September 2026.)
| Step | Filter added | Funds left |
|---|---|---|
| 0 | Category: Flexi Cap | 45 |
| 1 | 5-yr CAGR above the category median (11.18%) | 13 |
| 2 | Expense ratio 0.80% or lower | 6 |
| 3 | Beat the median in at least 60% of rolling 3-yr windows | 4 |
| 4 | Minimum SIP ₹500 or lower | 2 |
Forty-five funds became two in four clicks. Two details in her shortlist are worth noticing. The funds that survived step 3 beat their category median in roughly 83% to 100% of rolling windows — the filter didn't just trim the list, it kept the steadiest funds. And one of the final two had a worst fall of −41.8% at some point in its history, deeper than the category's −29.9% median. That isn't disqualifying for a 12-year goal, but it's exactly the kind of fact Ritika should see before the first ₹15,000 goes in, not during the next correction.
Now the cost side. Take ₹10,000 a month for 15 years, assume the portfolio earns 12% a year before costs, and change only the expense ratio:
| Expense ratio | Value after 15 years | Cost vs 0.3% |
|---|---|---|
| 0.3% | ₹46,38,969 | — |
| 1.0% | ₹43,70,720 | ₹2,68,249 |
| 1.5% | ₹41,89,398 | ₹4,49,571 |
You'd have put in ₹18,00,000 either way. A 0.7-point difference in cost quietly takes ₹2.68 lakh. That's why cost is a filter, not a tie-breaker.
Common mistakes when choosing a mutual fund
- Ranking by 1-year return. One year mostly reflects the category's year. Compare 5-year CAGR with the category median instead.
- Comparing across categories. A mid-cap fund "beating" a large-cap fund tells you about the categories, not the funds. Compare within one.
- Buying the Regular plan by default. Same portfolio, higher cost. Check the plan name says Direct.
- Trusting a young fund's small drawdown. If the fund didn't exist in March 2020, its worst fall hasn't been tested.
- Collecting funds. Five flexi-cap funds is one flexi-cap fund with five times the paperwork. Pick one or two per category.
- Ignoring exit load and tax. Switching often can cost 1% exit load plus short-term capital gains tax. Screen properly once, then leave the SIP alone.
How TradeDiary helps
You can do all of this with AMFI's NAV files and a spreadsheet — computing CAGR, category medians and rolling windows for a thousand funds is just tedious. The free TradeDiary mutual fund screener does the arithmetic for about 1,700 Direct-plan growth funds every night: category medians beside every return, rolling 3-year consistency, worst fall, expense ratio, minimum SIP and fund size, with presets like "Low-cost index funds" and "Consistent 5-yr", compare-up-to-three and Excel export. It never ranks or recommends a fund — you set the filters.
Once you invest, TradeDiary tracks it: import your CAMS / KFintech CAS statement and every fund is valued at the latest NAV, with XIRR, realised gains and the long-/short-term split — beside your stock portfolio and trades, if you have them.
→ Open the free mutual fund screener — no signup needed.
You may also like: what maximum drawdown really costs you, how to tell a real edge from a lucky streak, filing ITR-3 as a trader, and the best trading journal apps in India.
Frequently asked questions
How do I choose a good mutual fund in India? Decide the category from your goal and time horizon first. Then, within that category, keep Direct-plan funds whose 5-year CAGR beats the category median, that beat the median in most rolling 3-year windows, whose expense ratio is at or below the category median, and whose worst fall you could sit through. Read the scheme documents of the two or three that remain before investing.
Is a high past return enough to pick a mutual fund? No. A fund's return mixes what its whole category did, what the manager added and luck. Compare it with the median of its own category, and check rolling returns to see whether the outperformance was consistent or came from one strong stretch. Past returns do not guarantee future returns.
What are rolling returns in mutual funds? Rolling returns measure a fund's return over every window of a fixed length — for example every 3-year period ending at each month-end — instead of one period ending today. Counting how often a fund beat its category median across those windows shows consistency; a trailing return shows only one window.
How much does the expense ratio really cost? More than it looks. On a ₹10,000 monthly SIP for 15 years at a 12% gross return, a 1.0% expense ratio leaves about ₹2.68 lakh less than a 0.3% expense ratio, and 1.5% leaves about ₹4.5 lakh less — on the same ₹18 lakh invested.
Should I choose Direct or Regular mutual fund plans? Direct and Regular plans of a scheme hold the same portfolio; the Regular plan's higher expense ratio pays distributor commission, so it returns less each year. If you choose and review funds yourself, Direct plans cost less. If you rely on a distributor's ongoing help, that commission is what pays for it.
Risk disclaimer
This article is for educational purposes only and does not constitute investment advice. Mutual fund investments are subject to market risks; read all scheme-related documents carefully. Past performance does not guarantee future results. Figures are computed from AMFI NAVs as of 14 September 2026 and fund fact sheets, and will change. The investor example is a composite, but the fund counts are real screener results on that date. Tax rules are summarised for general information; consult a tax professional and a SEBI-registered investment adviser before making investment decisions.
Author: Pulkit Mangal — Founder, TradeDiary. Trader since 2017; builds the tools on tradediary.app that turn public market data into numbers you can check.
Last updated: 15 September 2026.