How to Calculate Mutual Fund Returns
Calculating mutual fund returns correctly requires choosing the right method based on how you invested: lump sum (single investment) or SIP (regular multiple investments). Using the wrong method gives misleading figures. Here are the three most important return calculation methods for Indian mutual fund investors.
Method 1: Absolute Return (Simple Return)
Used for lump sum investments; shows total gain as a percentage of invested amount, regardless of time period.
Formula: Absolute Return = ((Current Value - Invested Amount) / Invested Amount) x 100
Example: Invested Rs 1,00,000; current value Rs 1,35,000. Absolute Return = ((1,35,000 - 1,00,000) / 1,00,000) x 100 = 35%
Limitation: Does not account for time; 35% over 1 year is very different from 35% over 5 years.
Method 2: CAGR (Compound Annual Growth Rate)
Used for lump sum investments to compare returns on an annualised basis.
Formula: CAGR = ((Current Value / Invested Amount) ^ (1/Number of Years)) - 1
Example: Rs 1,00,000 grew to Rs 1,35,000 over 3 years. CAGR = ((1,35,000 / 1,00,000) ^ (1/3)) - 1 = 10.6% per year.
Method 3: XIRR (for SIP Investments)
XIRR is the most accurate return metric for SIP investments with multiple cash flows at different dates.
Steps to calculate XIRR using MS Excel or Google Sheets:
- List all SIP payments in Column A (as negative values, e.g., -5000).
- Add the current portfolio value as the last positive entry in Column A.
- List corresponding dates in Column B.
- In an empty cell, enter: =XIRR(A1:A25, B1:B25)
- Result is the annualised return as a decimal (e.g., 0.12 = 12%).
Quick Summary of Return Calculation Methods
| Method | When to Use | Accounts for Time? |
|---|---|---|
| Absolute return | Quick comparison; lump sum | No |
| CAGR | Lump sum investment over multiple years | Yes |
| XIRR | SIP or any investment with multiple cash flows | Yes (best method for SIPs) |
Return on Investment (ROI) vs. XIRR
When platforms display "returns" on your SIP portfolio, they may show absolute ROI (simply comparing total invested vs. current value). Always look for XIRR to understand the true annualised return, especially for long-running SIPs where total invested amount is large. A 100% ROI over 10 years is actually approximately 7.2% XIRR, very different from what the absolute number might suggest.
Key Takeaway
Use CAGR for lump sum investments and XIRR for SIPs to get the most accurate measure of your mutual fund returns. Absolute returns are useful only for quick snapshots, not for meaningful comparison. Use the Lemonn app to automatically calculate XIRR and CAGR for your portfolio and make informed decisions about fund performance in India.
