How to Calculate Mutual Fund Returns — Complete Guide
Calculating mutual fund returns sounds straightforward but has several layers that most investors miss: the impact of expense ratio, taxation differences between equity and debt funds, and the critical difference between absolute return, CAGR, and XIRR for SIPs. This guide covers everything you need to evaluate mutual fund performance accurately in 2026.
Types of Mutual Fund Returns
| Return Type | Best Used For | Formula |
|---|---|---|
| Absolute Return | Less than 1 year | (Current NAV − Purchase NAV) / Purchase NAV × 100 |
| CAGR | Lumpsum, 1+ years | (Final/Initial)^(1/years) − 1 |
| XIRR | SIP, irregular investments | Discounted cashflow; use spreadsheet or app |
| Trailing Returns | Comparing funds | CAGR from specific past date (1Y, 3Y, 5Y) |
| Rolling Returns | Consistency check | CAGR calculated every day over multiple periods |
Historical CAGR by Mutual Fund Category (India, 10-Year)
| Category | 10-Year CAGR (approx) | Risk Level | Ideal Horizon |
|---|---|---|---|
| Large Cap Funds | 11–13% | Moderate | 5+ years |
| Flexi Cap Funds | 12–15% | Moderate | 5+ years |
| Mid Cap Funds | 14–18% | High | 7+ years |
| Small Cap Funds | 16–22% | Very High | 10+ years |
| ELSS / Tax Saving | 11–14% | Moderate-High | 3+ years (lock-in) |
| Balanced Advantage | 9–12% | Low-Moderate | 3+ years |
| Debt Funds (short) | 6–7.5% | Low | 1–3 years |
| Liquid Funds | 5–6.5% | Very Low | <1 year |
The Hidden Cost: Expense Ratio Impact on Long-Term Returns
The expense ratio is the annual fee mutual funds charge for managing your money. It seems small — 0.5% to 2.5% per year — but over long periods, its compounding effect is massive.
| Gross CAGR | Expense Ratio | Net CAGR | ₹1 Lakh Lumpsum — 20 Year Corpus |
|---|---|---|---|
| 12% | 0.5% (Direct Plan) | 11.5% | ₹84.9 lakh |
| 12% | 1.0% | 11.0% | ₹80.6 lakh |
| 12% | 1.5% | 10.5% | ₹72.2 lakh |
| 12% | 2.5% (Regular Plan) | 9.5% | ₹61.4 lakh |
The difference between a Direct Plan (0.5%) and a Regular Plan (2.5%) on the same ₹1 lakh investment over 20 years is ₹23.5 lakh. This is why financial advisors increasingly recommend Direct Plans for cost-conscious investors who can research funds independently.
Mutual Fund Taxation in 2026 (Post-Budget 2024 Rates)
| Fund Type | Holding Period | Gain Type | Tax Rate |
|---|---|---|---|
| Equity Funds (65%+ equity) | <1 year | STCG | 20% |
| Equity Funds | ≥1 year | LTCG above ₹1.25L | 12.5% |
| Debt Funds | Any period | Added to income | As per slab |
| Hybrid (equity <65%) | Any period | Added to income | As per slab |
| ELSS | 3-year lock-in | LTCG above ₹1.25L | 12.5% |
The Budget 2024 change raised LTCG exemption from ₹1 lakh to ₹1.25 lakh per year and STCG tax from 15% to 20%. For long-term equity fund investors, the effective LTCG tax burden is still relatively low — especially with annual harvesting of gains under ₹1.25 lakh.