What is XIRR? A Simple Guide for Mutual Fund Investors
XIRR, or Extended Internal Rate of Return, calculates the annualised return on investments made at different dates, like SIP instalments. It accounts for the timing and size of each cash flow. XIRR is the right way to measure returns when you invest regularly.
When you invest through a SIP, each instalment goes in on a different date. A simple return figure cannot capture this, but XIRR can.
Let us unpack it with a real example and the points that matter. You can explore mutual funds on Stockk.
Key Takeaways
- XIRR is the annualised return for varied-date investments.
- It accounts for the timing of each cash flow.
- It is the right measure for SIP returns.
- It handles both investments and withdrawals.
- Most platforms calculate it automatically.
Why do SIPs need XIRR?
In a SIP, you invest on many different dates, and each instalment stays invested for a different length of time. A simple return cannot handle this, because early instalments compound longer than recent ones. XIRR solves this by factoring in the exact date and amount of every cash flow to give one annualised rate.
Take the case where you invest ₹10,000 monthly for three years. Your first instalment grows for three years, your last for just one month. XIRR blends all these timings into a single, accurate annualised return figure.
What XIRR accounts for
- Timing: when each investment was made
- Amount: how much each cash flow was
- Withdrawals: any redemptions along the way
- Duration: how long each amount stayed invested
XIRR vs CAGR
| Measure | Best for |
|---|---|
| CAGR | A single lump-sum investment |
| XIRR | Multiple investments on different dates |
How to use XIRR
For any investment with multiple cash flows, like a SIP, XIRR is the accurate way to measure your true annualised return. Most investment platforms compute it for you, so you rarely calculate it by hand. When comparing your SIP's performance, always look at XIRR rather than a simple return.
Curious to invest? Stockk offers direct mutual funds, and a free account is quick to open. The Knowledge Center covers fund performance in more depth.
Mutual fund investments are subject to market risks. Read all scheme related documents carefully. Past performance is not a guarantee of future returns, and this article is for learning only, not investment advice.
Frequently Asked Questions
Why is XIRR used for SIPs?
Because SIP instalments are invested on different dates for different durations, and XIRR factors in the timing and amount of each to give an accurate annualised return.
How is XIRR different from CAGR?
CAGR suits a single lump-sum investment, while XIRR handles multiple cash flows on different dates. SIPs need XIRR for accuracy.
Does XIRR account for withdrawals?
Yes, XIRR factors in both investments and redemptions with their dates and amounts, giving a complete annualised return.
Do I need to calculate XIRR myself?
No, most investment platforms compute XIRR automatically, so you simply read it when reviewing your SIP returns.
What does a good XIRR look like?
It depends on the fund category and period; compare it to the benchmark and peers.
Investments in securities market are subject to market risks. This article is for educational purposes only and does not constitute investment advice.
INDIRA SECURITIES PRIVATE LIMITED : SEBI REG. NO.: INZ000188930, NSE TMID: 12866, BSE TMID: 663, CDSL DPID: 17000, MCX TM ID: 56470, NCDEX TM ID: 01277, CDSL REG.NO.: IN-DP-90-2015, CIN:U67120MP1996PTC085111, RA SEBI REG. No.: INH000023269, IA SEBI REG No.: INA000021410
