How to Calculate Mutual Fund Returns — NAV, CAGR, XIRR
Learn how to calculate mutual fund returns using NAV, CAGR, and XIRR methods — with formulas, worked examples, and when each method is appropriate.
Your mutual fund app shows a return percentage, but do you know what it actually means? There are several ways to measure mutual fund returns — absolute, annualized (CAGR), and XIRR — and each tells a different story. Using the wrong method can make your returns look much better or worse than reality.
Here's how to calculate mutual fund returns correctly. Verify your numbers with the CalcHub mutual fund calculator.
Understanding NAV (Net Asset Value)
NAV is the per-unit price of a mutual fund. Your returns are based on the change in NAV between purchase and redemption.
Units purchased = Investment Amount / NAV at purchase
Current Value = Units × Current NAV
Example:
- Invested: Rs 1,00,000
- NAV at purchase: Rs 50
- Units: 1,00,000 / 50 = 2,000 units
- Current NAV: Rs 72
- Current value: 2,000 × 72 = Rs 1,44,000
Method 1: Absolute Return
Absolute Return = ((Current Value - Investment) / Investment) × 100
= ((1,44,000 - 1,00,000) / 1,00,000) × 100
= 44%
Use for: Quick assessment. But 44% over 2 years is very different from 44% over 5 years, so absolute return alone is insufficient for comparison.
Method 2: CAGR (Compound Annual Growth Rate)
CAGR annualizes the return, making comparison across different time periods possible.
CAGR = ((Final Value / Initial Value)^(1/years)) - 1
Example (investment held for 3 years):
CAGR = ((1,44,000 / 1,00,000)^(1/3)) - 1
= (1.44)^(0.333) - 1
= 1.1292 - 1
= 12.92%
Use for: Lumpsum investments. CAGR is the correct method for a single one-time investment over a known period.
Method 3: XIRR (for SIP and Multiple Investments)
If you've invested through SIP or made multiple lumpsum investments, CAGR doesn't work because each investment has a different holding period. XIRR accounts for this.
Example: SIP of Rs 10,000/month for 24 months
Total invested: Rs 2,40,000
Current value: Rs 2,88,000
Using CAGR naively: ((2,88,000/2,40,000)^(1/2)) - 1 = 9.5%
Using XIRR (accounting for each monthly cash flow): approximately 17.8%
The CAGR method drastically underestimates because it assumes the full Rs 2,40,000 was invested from day one. In reality, later SIPs had less time to grow, meaning the earlier SIPs earned higher returns.
Comparing Return Methods
| Method | Best For | Considers Time? | Considers Cash Flows? |
|---|---|---|---|
| Absolute Return | Quick check | No | No |
| CAGR | Lumpsum investment | Yes | No |
| XIRR | SIP / multiple investments | Yes | Yes |
| Trailing Return | Fund performance comparison | Yes | No |
Understanding Trailing Returns
Mutual fund fact sheets show trailing returns — the CAGR over the last 1, 3, 5, and 10 years ending today. These are useful for comparing fund performance but don't reflect your personal returns unless you invested exactly at the start of that period.
| Period | Trailing Return |
|---|---|
| 1 year | 18.5% |
| 3 years | 14.2% |
| 5 years | 12.8% |
| 10 years | 13.5% |
Point-to-Point vs Rolling Returns
Point-to-point: CAGR from a specific start date to end date. Highly dependent on entry and exit timing — can be misleading. Rolling returns: Average of all possible 3-year (or 5-year) CAGR values across the fund's history. Much more reliable indicator of consistent performance. If a fund's 5-year rolling return has never been negative, it indicates good consistency.Practical Tips
1. Always use XIRR for SIP returns. Any other method underestimates your actual performance. Your fund app should show XIRR — if it shows "returns" without specifying the method, ask which calculation they use. 2. Compare funds using the same method and time period. Don't compare Fund A's 3-year CAGR with Fund B's absolute return. Use the same metric and same time period. 3. Account for exit load and taxes. A fund showing 15% CAGR before taxes might deliver 12-13% after LTCG tax (12.5% on gains above Rs 1.25 lakhs for equity funds). Exit loads (typically 1% if redeemed within 1 year) also reduce returns. 4. Direct plans always outperform regular plans. The expense ratio difference (0.5-1%) compounds significantly. Over 20 years, a 1% expense ratio difference on a Rs 10,000/month SIP can mean Rs 10-15 lakhs less in your corpus.What's a good mutual fund return?
For equity funds, 12-15% CAGR over 5+ years is considered good. For debt funds, 7-8%. For hybrid funds, 10-12%. These are pre-tax figures. Compare with benchmarks (Nifty 50, Nifty Next 50) rather than absolute numbers.
Why does my fund show negative returns even though the market is up?
Your fund may hold different stocks than the index, or your entry timing might be poor. SIP returns can also look negative in the first year during a downturn because all your recent investments are at loss. Give equity SIPs at least 3-5 years before evaluating performance.
Should I look at fund returns or benchmark comparison?
Benchmark comparison. A fund returning 10% when its benchmark returned 15% is underperforming. A fund returning 10% when the benchmark returned 7% is doing well. Alpha (fund return minus benchmark return) is more meaningful than absolute return.
Related Calculators
- Mutual Fund Calculator — calculate lumpsum and SIP returns
- CAGR Calculator — annualized growth rate
- SIP Calculator — project future SIP corpus
- Compound Interest Calculator — understand compounding mechanics