The XIRR Trap: Why Your Mutual Fund App’s “Returns” Number Is Misleading You
Open your favorite investment app—whether it is Zerodha Coin, Groww, Kuvera, or INDmoney—and you will see a prominent green or red percentage labeled “XIRR” (Extended Internal Rate of Return) or “Total Returns”.
Many investors assume this number represents their annual profit rate, or worse, compare it directly to a bank FD rate. One week your app shows 22.4% XIRR, and two weeks later after a minor market dip, it drops to 11.2% XIRR. Did your portfolio really lose half its wealth?
To evaluate your investments accurately, you must understand the mathematical difference between Absolute Return, CAGR, and XIRR, and why cash flow timing can create severe visual distortions.
The Three Metrics Decoded
1. Absolute Return: Simple, But Ignores Time
Absolute return simply measures point-to-point capital gain:Absolute Return = [(Current Value − Total Invested) ÷ Total Invested] × 100
If you invested ₹1,00,000 and it is now worth ₹1,50,000, your absolute return is 50%. But absolute return has a fatal flaw: it completely ignores time. A 50% gain earned in 1 year is extraordinary; a 50% gain earned over 10 years translates to less than 4.2% annualized—well below a bank savings account!
2. CAGR (Compound Annual Growth Rate): Ideal for One-Time Lumpsums
CAGR answers: “What constant annual rate did my money grow at each year?”CAGR = (Current Value ÷ Initial Investment)^(1 ÷ Years) − 1
CAGR is the gold standard for comparing one-time lumpsum investments, gold, real estate, or fund benchmark indices. However, CAGR assumes a single entry point and a single exit point. It completely breaks down when you invest through a monthly SIP or make irregular deposits and withdrawals.
3. XIRR (Extended Internal Rate of Return): The Multiple Cashflow Solver
XIRR solves this problem by calculating the internal rate of return for multiple, irregular cash inflows and outflows occurring on specific calendar dates. It solves for the discount rate r that sets the Net Present Value (NPV) of all past installments equal to the current portfolio value.
Try calculating custom cash flows on our XIRR Calculator.
The Trap: Why Cash Flow Timing Distorts Your App’s XIRR
Because XIRR weights each cash flow by how long it has been invested, recent deposits have a disproportionate effect on the headline percentage. This creates three common traps:
Suppose you have been running a ₹10,000 monthly SIP for 4 years with great success. In Month 49, you receive an annual bonus of ₹2,00,000 and deposit it into the fund. If the market dips just 3% over the next week, your app’s XIRR will plummet from 16% down to 7%! Why? Because the massive ₹2 lakh cashflow has a tenure of only 7 days, heavily skewing the mathematical equation.
If you started a SIP only 3 or 6 months ago, any 2% market jump can produce an annualized XIRR of 45% or 60%! Beginners get overly excited, believe they are investment geniuses, and double their allocations right at market tops. Within your first year, XIRR is mathematically unstable and should be largely ignored.
If you withdraw partial amounts from your mutual fund, your app registers that as a positive cash flow. Depending on whether the redemption took place during a market high or low, your remaining portfolio’s reported XIRR can look artificially inflated or depressed.
How to Accurately Benchmark Your Portfolio
- Look at Total Profit in Rupees: Percentage returns can be deceptive. A 25% XIRR on a ₹20,000 portfolio is only ₹5,000. An 11% XIRR on a ₹50,00,000 portfolio is ₹5.5 lakh per year. Wealth is measured in absolute rupees that fund real life goals.
- Compare Against the Benchmark Index (Nifty 50 TRI): If your active Flexi Cap fund shows a 14% XIRR, compare it to what a passive Nifty 50 Total Return Index (TRI) SIP would have delivered over the identical dates. If the index delivered 14.5%, your active fund underperformed.
- Evaluate Only Over 3+ Year Horizons: Give your SIP at least 36 monthly installments before drawing conclusions about fund manager quality.