If you invest through SIPs or add money to your portfolio at different times, a single return percentage can be misleading. The right tool to measure your true return is XIRR. This beginner guide answers what is XIRR, why it matters, and how it differs from CAGR.
What Is XIRR?
XIRR stands for Extended Internal Rate of Return. It calculates the annualised return on an investment when money flows in (and out) at multiple, irregular dates. In short, it answers: “considering every contribution I made, on every date, what is my real yearly return?”
Why XIRR Matters
Calculate While You Read
Free calculators related to this article — instant results, no signup.
When you do a SIP, you invest a fixed amount every month. Each instalment stays invested for a different length of time – the first instalment compounds far longer than the most recent one. A simple return figure cannot capture this. XIRR accounts for both the amount and the timing of every cash flow, giving an accurate picture of performance.
XIRR vs CAGR: The Key Difference
CAGR (Compound Annual Growth Rate) works perfectly for a single lump-sum investment – one amount in, one amount out, over a known period. But CAGR cannot handle multiple investments made at different times.
XIRR is built exactly for that situation. If you invested ₹5,000 every month for 3 years, CAGR has no clean way to measure it, but XIRR does. Think of XIRR as CAGR’s more flexible cousin for real-world, multi-date investing.
A Simple Way to Remember It
- CAGR – one investment, one withdrawal, fixed period.
- XIRR – many investments on different dates, like a SIP.
Where XIRR Is Used
- Measuring the actual return on your mutual fund SIPs.
- Evaluating a portfolio where you added money irregularly.
- Comparing investments that involve multiple cash flows.
- Checking returns when you also made partial withdrawals.
How XIRR Works (In Simple Terms)
To calculate XIRR you list every cash flow with its date. Each investment you make is a negative cash flow (money leaving your pocket), and the final value of your investment is a positive cash flow. XIRR then finds the single annual rate that makes all those dated cash flows balance out. The math is complex, which is why spreadsheets and online calculators do it for you.
How to Calculate XIRR Easily
Most spreadsheet software has a built-in XIRR function. You enter two columns – the dates and the corresponding cash flows – and the function returns the annualised rate. Many mutual fund platforms also display XIRR for your portfolio automatically.
Reading Your XIRR Correctly
A higher XIRR means a better annualised return. But always interpret it alongside risk and time period. A high XIRR over a short, lucky run is not the same as a steady XIRR over many years. Use it as one input, not the only one.
A Simple XIRR Example
Imagine you invested ₹10,000 on three different dates over a year, and at the end your total holding is worth ₹35,000. A simple “total gain” figure would say you gained ₹5,000 on ₹30,000 invested – but that ignores the fact that your first ₹10,000 was working for a full year while your last ₹10,000 was invested only a few months. XIRR weighs each contribution by how long it stayed invested and produces a single, fair annualised rate. That rate is what you can genuinely compare against an FD rate or another fund’s XIRR.
What Counts as a Good XIRR?
There is no universal “good” number – it depends on the asset class and the period. For a long-term equity SIP, an XIRR in the low double digits is often considered healthy, while a debt-oriented investment would reasonably show a lower figure. The mistake to avoid is comparing the XIRR of a risky equity fund against the XIRR of a safe deposit and concluding one is simply “better.” Always compare like with like, and weigh the return against the risk taken to earn it.
Limitations of XIRR
XIRR assumes that interim cash flows could be reinvested at the same rate, which may not hold in reality. It also needs accurate dates and amounts – a wrong entry skews the result. And like any return figure, it looks backward; it does not predict future performance.
For a single lump-sum investment, the simpler measure is CAGR – learn more in our guide and try the CAGR Calculator. If you are planning regular monthly investments, estimate their growth with our SIP Calculator, and compare a guaranteed option using the FD Calculator.
Frequently Asked Questions
What is the difference between XIRR and CAGR?
CAGR measures the return on a single lump-sum investment over a fixed period. XIRR measures the annualised return when money is invested at multiple, irregular dates – such as a SIP.
Why is XIRR used for SIP returns?
Because every SIP instalment is invested on a different date and stays invested for a different duration. XIRR accounts for the timing of each instalment, giving an accurate return.
Is a higher XIRR always better?
Generally yes, but consider risk and the time period too. A high XIRR over a very short period is less meaningful than a steady one over many years.
Can XIRR be negative?
Yes. If your investment’s final value is less than the total you put in, XIRR will be negative, indicating a loss.
This article is for educational purposes only and is not investment advice. Please consult a qualified financial advisor before investing.
