XIRR Explained: The one return metric every mutual fund investor in India must understand
Your mutual fund app shows a 42% return. You feel great. But you started three years ago with multiple SIPs at different times, some top-ups, one redemption. Is 42% what you actually earned? Almost certainly not. XIRR is the only return metric that tells you the real truth and here's why.
MUTUAL FUNDS
XIRR Explained: The one return metric every mutual fund investor in India must understand
Deepa has been investing in a mutual fund SIP for three years. Her app shows a return of 38%. She's thrilled and tells her friend that her fund has "given 38%." Her friend Vinod invested a lump sum in the same fund on the same day Deepa started her SIP. His app also shows 38%.
But here's the thing, Deepa and Vinod have not earned the same return. Not even close.
Vinod invested ₹1 lakh on Day 1 and it grew at 38% over three years. His money worked for the full 36 months.
Deepa invested ₹5,000 every month for 36 months. Her first SIP instalment worked for 36 months. Her last instalment worked for exactly one month. Every instalment in between earned returns for a different duration.
The 38% her app shows is the absolute return on the current value vs. total amount invested. It doesn't account for when each rupee was invested or for how long.
That is the critical difference. And XIRR is the metric that fixes it.
What is XIRR?
XIRR stands for Extended Internal Rate of Return. It is a financial function that calculates the annualized return on investments where cash flows, deposits and withdrawals happen at irregular intervals and on different dates.
In simple terms: XIRR is the true annual return on your investment, adjusted for the timing and amount of every single transaction you made.
It answers the question that absolute return cannot: given that I invested different amounts at different times, what is the actual annualized rate at which my money grew?
XIRR is expressed as a percentage per annum, making it directly comparable to FD rates, PPF returns, and any other investment metric quoted annually.
Why absolute return misleads SIP investors
Absolute return is calculated as: (Current Value − Amount Invested) ÷ Amount Invested × 100
This is a perfectly valid calculation for a lump sum investment held for a fixed period. If you put in ₹1 lakh and it is now ₹1.38 lakh, you made 38%. Simple and accurate.
But for a SIP, where you invest every month over years, absolute return becomes misleading. Here is why:
Your ₹5,000 invested in Month 1 has been compounding for 36 months.
Your ₹5,000 invested in Month 36 has been compounding for exactly 1 month.
Treating both as earning "38%" is mathematically incorrect. The actual annualised return, adjusted for timing, could be significantly higher or lower than what absolute return shows.
This is why AMFI mandates that mutual fund returns beyond one year be disclosed as CAGR( Compound Annual Growth Rate) for lump sum investments, and as XIRR for SIP-style irregular investments.
XIRR vs. CAGR: What's the difference?
Both CAGR and XIRR express returns as an annualized percentage. But they serve different purposes.
CAGR (Compound Annual Growth Rate) works perfectly for a single lump sum investment with one start date and one end date. It tells you the steady annual rate that would have grown your investment from start to finish.
XIRR is designed for multiple cash flows at irregular dates. It is CAGR's more sophisticated cousin, built specifically for the real-world investing behavior of most Indians who invest through SIPs, make top-ups, and do partial redemptions.
Think of it this way: CAGR is the speed of a car on a straight, empty highway. XIRR is the average speed of the same car across a journey with traffic, stops, detours, and different starting points for different passengers.
A practical example: Same fund, very different XIRR
Consider two investors in the same fund over three years:
Investor A: Lump sum of ₹1,80,000 invested on Day 1. Current value: ₹2,60,000. Absolute return: 44.4%. CAGR: approximately 13.1% per annum.
Investor B: SIP of ₹5,000 per month for 36 months. Total invested: ₹1,80,000. Current value: ₹2,60,000. Absolute return: 44.4%. XIRR: approximately 24–26% per annum.
Same fund. Same total amount invested. Same current value. Same absolute return.
But vastly different annualized returns, because Investor B's later SIP instalments had far less time to grow, meaning the effective return per year was actually higher to reach the same endpoint.
This is why XIRR for SIP investors is almost always significantly higher than CAGR for lump sum investors for the same fund over the same period.
What is a good XIRR for a SIP?
There is no universal benchmark, it depends on the fund category, market conditions, and investment period. However, as a general reference:
An XIRR of 10-12% on a large cap or index fund SIP over 5-7 years is broadly in line with long-term Nifty 50 performance.
An XIRR of 14-18% on a mid or small cap fund over the same period reflects stronger outperformance.
An XIRR below 7-8% on an equity fund SIP over 5+ years warrants a review, a comparable debt fund or even PPF may have served you better with lower risk.
The bottom line
Deepa eventually calculated her actual XIRR. It was 21.4%, not 38%. Still excellent. But the 38% figure had given her a distorted sense of performance that could have led to poor future decisions.
Understanding what you are actually earning, not what the app shows on the surface, is the foundation of every good investment decision.
XIRR is not a complex concept. It is simply the honest answer to the most important investment question: what did my money actually earn, per year, given how and when I invested it?
Check yours today. It might surprise you, in either direction.
#XIRR #MutualFundReturns #SIPReturns #MutualFundsIndia #PersonalFinanceIndia #SIPInvesting #InvestmentReturns #CAGR #AbsoluteReturn #FinancialLiteracy #TeamSanchay #Sanchay #MutualFundBasics #IndianInvestor #WealthBuilding #InvestSmart #MutualFundSahiHai #FinancialFitness #SEBIIndia #AMFIIndia #RupeeWise #FinancialPlanning #InvestingForBeginners #SmartInvesting #MoneyTipsIndia
Disclaimer: Published by TeamSanchay for educational purposes only. Not personalised financial or investment advice. Mutual fund investments are subject to market risks. XIRR figures shown are illustrative only, actual returns will vary. Consult a SEBI-registered investment adviser before making any investment decisions.
© Sanchay Mutual Fund Distributor and Insurance Advisor | AMFI-Registered Mutual Fund Distributor