Last updated: 18 October 2026. Corrected the CAGR and XIRR examples and added a comparison table and a “when to use each” guide.
Open a mutual fund app or factsheet and you may see three different return numbers for the same investment: absolute return, CAGR and XIRR. They are not competing answers; each one answers a different question. This guide compares the three side by side, shows when to use each, and explains why abs return vs XIRR can look so different on a SIP.
Absolute Return: Total Gain, No Time Adjustment
Absolute return is the total percentage increase or decrease in the value of an investment, regardless of how long it took. If you invest Rs. 10,000 and it grows to Rs. 12,000, your absolute return is 20%, whether that took six months or three years. It is best for short periods (under a year) and quick lump-sum snapshots. For the formula, worked examples and how to read it on a SIP, see our complete guide to absolute return in mutual funds.
CAGR: The Annual Rate for a Single Lump Sum
CAGR (compound annual growth rate) is the steady yearly rate at which a single lump sum would have grown to its ending value, with compounding. It is the fairest way to compare lump-sum performance over periods longer than a year.
CAGR = (Ending Value / Beginning Value)^(1 / Number of Years) − 1
Example: Rs. 10,000 invested grows to Rs. 14,000 after two years. Absolute return = 40%. CAGR = (14,000 / 10,000)^(1/2) − 1 = 0.183, or about 18.3% a year.
CAGR assumes one investment on day one, so it should not be applied to SIPs or to portfolios with additions and withdrawals.
XIRR: The Annual Rate When Money Goes In and Out on Different Dates
XIRR (extended internal rate of return) finds the single annual rate that, applied to every cash flow on its actual date, explains the final value. That makes it the right measure for SIPs, top-ups, SWPs and partial redemptions. There is no simple one-line formula; it is solved numerically. In Excel or Google Sheets, list each investment as a negative amount with its date, the current value as a positive amount with today’s date, and use =XIRR(values, dates). Most investment apps show your personal XIRR for each folio.
For a single lump sum with no other cash flows, XIRR and CAGR give practically the same answer.
Abs Return vs XIRR: Why Your SIP Shows Two Different Numbers
Illustrative example (hypothetical figures): you invest ₹10,000 on the 1st of every month from January to December (₹1,20,000 in total), and on 1 January of the following year the holding is worth ₹1,32,000.
- Abs return = (1,32,000 − 1,20,000) / 1,20,000 × 100 = 10%. This is your total profit on the cash you put in.
- XIRR ≈ 18.9% a year. Each instalment was invested for a different length of time (the first for twelve months, the last for one), and XIRR accounts for that.
Neither number is wrong. Abs return tells you how much you made in total; XIRR tells you the annualised rate your staggered investments earned. Compare SIPs with XIRR, and don’t compare one investor’s absolute return with another’s XIRR.
CAGR vs XIRR vs Absolute Return: Comparison Table
| Absolute return | CAGR | XIRR | |
| Question it answers | How much did I gain or lose in total? | What steady yearly rate did my lump sum grow at? | What yearly rate did all my dated cash flows earn? |
| Adjusts for time? | No | Yes | Yes |
| Handles multiple investments or withdrawals? | No | No | Yes |
| How to calculate | (Current − Invested) / Invested × 100 | (End / Start)^(1/years) − 1 | Excel/Sheets =XIRR(values, dates), or your app |
| Best for | Periods under 1 year; quick snapshots | Lump sums held over 1 year; comparing funds | SIPs, top-ups, SWPs, partial redemptions |
| Watch out for | Looks large over long periods; misleading for SIPs | Wrong for SIPs; assumes smooth growth | Needs accurate dates; can swing over short periods |
| Example in this article | Lump sum: 40% over 2 years. SIP: 10% | Lump sum: about 18.3% a year | SIP: about 18.9% a year |
When to Use Each Measure
- Checking a holding of less than a year: absolute return.
- Comparing two funds’ lump-sum performance over 3, 5 or 10 years: CAGR over the same period.
- Judging how your SIP is doing: XIRR. Treat the absolute figure as “total profit so far”.
- Portfolio with top-ups, switches or withdrawals: XIRR.
- Reading a factsheet: short periods are usually shown as absolute returns, longer ones as CAGR, and SIP illustrations as XIRR-style returns. Check the label before comparing.
Frequently Asked Questions
Abs return vs XIRR: which is better?
Neither is “better”; they answer different questions. Abs return shows total gain on money invested. XIRR shows the annualised rate, accounting for when each rupee went in. For SIPs, use XIRR to judge performance.
Is CAGR the same as XIRR?
For a single lump sum with no other cash flows, they give practically the same result. Once there are multiple investments or withdrawals, only XIRR is correct.
Why is my SIP’s XIRR higher than its absolute return?
Because later instalments have been invested for only a short time. XIRR annualises each cash flow over its own holding period, so in a rising market it is often higher than the absolute figure in the early years. In a falling market both can be negative.
Conclusion
Absolute return, CAGR and XIRR each have a job: total gain, lump-sum annual rate, and annual rate across staggered cash flows. Using the right one stops you from overrating a big multi-year number or underrating a young SIP. Wealth Munshi is an AMFI-registered mutual fund distributor (ARN 141775) based in Hyderabad. Through our mutual fund investment service, we can help you read your returns with the right measure and review your SIPs against your goals.
Mutual fund investments are subject to market risks; read all scheme-related documents carefully. Past performance does not indicate future returns. Examples are illustrative.





