Use CAGR for one lump sum; XIRR for dated cash flows
CAGR is best when you have one starting value, one ending value and one continuous holding period. XIRR is designed for multiple cash flows occurring on different dates, which makes it much better suited to SIPs, staggered investments and partial withdrawals. Applying CAGR to total SIP contributions can produce a misleading result because each instalment was invested for a different length of time.
The rule of thumb
- CAGR: one beginning value → one ending value over time.
- XIRR: multiple dated cash flows → one annualised rate.
- Do not calculate SIP CAGR by pretending all contributions were invested on day one.
- XIRR quality depends on correct dates and cash-flow signs.
Same money, different timing
Imagine you invest ₹1 lakh at the start of each year for three years and finish with ₹3.65 lakh at the end of year three. A naive CAGR using ₹3 lakh as if it were invested on day one ignores that the second and third ₹1 lakh had much less time to grow. XIRR instead treats each contribution on its actual date.
The formula difference is the reason the answer changes
CAGR assumes one amount is invested for the entire measurement period: CAGR = (Ending Value ÷ Beginning Value)^(1 ÷ Years) − 1. XIRR instead solves for the annual rate that makes the present value of all dated cash flows equal to zero. Each contribution therefore receives its own time weight.
Using the three-contribution example above—₹1 lakh on 1 January 2023, ₹1 lakh on 1 January 2024, ₹1 lakh on 1 January 2025 and a final value of ₹3.65 lakh on 31 December 2025—the dated-cash-flow XIRR is about 10.14% a year. Treating ₹3 lakh as though it was invested on the first date would answer a different question because two-thirds of that money arrived later.
The exact XIRR can also vary slightly with the precise transaction dates. That is not a flaw: the date sensitivity is the feature that makes XIRR appropriate for irregular cash flows.
When CAGR is the right tool
If ₹10 lakh becomes ₹15 lakh over exactly five years with no intervening cash flows, CAGR expresses the smooth annual rate that links those two values. The actual market path can be volatile; CAGR is a geometric summary, not a year-by-year return history.
When XIRR is the right tool
- Monthly SIPs.
- Irregular top-ups.
- Multiple redemptions.
- Dividend/distribution cash flows you choose to include.
- Real-estate or private-investment cash flows on different dates.
Common XIRR mistakes
Use negative signs for money invested and positive signs for money received/current value. Use real transaction dates, not month numbers. Include every cash flow that belongs in the performance measurement. Also remember that an annualised money-weighted return is not a forecast of future performance.
Use the return measure that matches the cash flow
Use CAGR when one starting value compounds to one ending value with no intervening cash flows. Use XIRR when money enters or leaves on different dates, as with SIPs, redemptions or irregular investments. The two measures can both be mathematically correct while answering different questions, so do not compare them as if they were interchangeable.
Sanity-check extreme XIRR results
Very high or very low XIRRs can arise when the holding period is short or a small cash flow occurs close to the valuation date. Inspect the underlying dates and amounts before interpreting the annualised percentage. For a portfolio, verify that every contribution and withdrawal has the correct sign and date.
Where return-measure comparisons go wrong
- Entering every SIP instalment on the same date.
- Reversing the sign convention for investments and money received.
- Forgetting the current portfolio value as the final positive cash flow when measuring an ongoing investment.
- Comparing an XIRR from one period with a CAGR from another.
- Reading an annualised return from a very short holding period without checking the underlying dates and cash flows.
Check the same cash flows both ways
Frequently asked questions
Can I use CAGR for SIP?
Not reliably if you treat all SIP contributions as one starting amount. XIRR handles dated contributions properly.
Why can XIRR be higher than CAGR?
They may be measuring different cash-flow patterns. XIRR is money-weighted and sensitive to when you invested.
Is XIRR guaranteed future return?
No. It describes historical/assumed cash flows.
What signs should I use?
Typically contributions are negative and withdrawals/current value are positive.
Can XIRR handle irregular dates?
Yes. That is one of its main advantages over simpler annual-return measures.