You check your mutual fund app and see three numbers: absolute return, CAGR and XIRR. Each one tells a different story, and picking the wrong one can make an investment look far better or worse than it really is. This guide on CAGR vs XIRR vs absolute return explains the formulas, shows worked ₹ examples, and tells you exactly when to use each.
Key takeaways
- Absolute return shows total percentage gain, without considering time.
- CAGR shows the yearly compounded growth of a single, one-time investment.
- XIRR shows the yearly return when you invest or withdraw on many dates, such as in a SIP.
- For a one-time lumpsum, CAGR and XIRR give practically the same result.
- For SIPs, top-ups and withdrawals, XIRR is the most meaningful measure.
- For periods under one year, absolute return is usually more realistic than an annualised figure.
What is absolute return?
Absolute return is the simplest measure. It tells you how much your money has grown in total, in percentage terms, from start to end.
Absolute return formula
Absolute return = (Current value − Amount invested) ÷ Amount invested × 100
Suppose you invested ₹1,00,000 and it is worth ₹1,80,000 today. Your absolute return is (1,80,000 − 1,00,000) ÷ 1,00,000 × 100 = 80%.
The problem? Absolute return ignores time. An 80% gain in 2 years is very different from an 80% gain in 10 years, but absolute return shows both as 80%.
When absolute return is useful
- For investments held for less than one year.
- For a quick “how much have I gained overall” check.
- When comparing two options over exactly the same holding period.
What is CAGR?
CAGR, or compounded annual growth rate, converts the total growth into a steady yearly rate. It answers the question: “If my money grew at the same rate every year, what would that rate be?”
CAGR formula
CAGR = (Ending value ÷ Beginning value)^(1 ÷ number of years) − 1
CAGR worked example
Take the same ₹1,00,000 that became ₹1,80,000, and assume this happened over 5 years.
- Ending value ÷ Beginning value = 1,80,000 ÷ 1,00,000 = 1.8
- 1.8^(1/5) = 1.8^0.2 ≈ 1.1247
- CAGR ≈ 1.1247 − 1 = 0.1247, or about 12.47% per year
Notice that simply dividing 80% by 5 gives 16%, which is wrong. That “simple average” ignores compounding. The correct compounded figure is about 12.47%. You can verify this in seconds with the Quantsgrow CAGR calculator.
Limitations of CAGR
CAGR assumes only two cash flows: one investment at the start and one value at the end. It does not work properly when you invest on several dates. It also hides the ups and downs in between, so a CAGR of 12% could include a year of −20% and a year of +40%.
What is XIRR?
XIRR stands for extended internal rate of return. It calculates a single yearly return rate for a series of cash flows that happen on different dates. This makes it ideal for SIPs, additional purchases, partial redemptions and systematic withdrawal plans (SWPs).
How XIRR works
XIRR finds the one annual rate at which the present value of all your investments equals the present value of what you received or still hold. In simple words, it gives each instalment credit only for the time it was actually invested.
There is no simple formula you can solve by hand for many cash flows. Spreadsheets and calculators use trial and error (iteration) to find the rate. In Excel or Google Sheets, you use =XIRR(values, dates), entering investments as negative numbers and the current value as a positive number.
Worked SIP XIRR example
Let us take a 12-month SIP. The numbers below are for illustration only and do not represent any real fund.
- SIP amount: ₹5,000 on the 5th of every month, from 5 January 2025 to 5 December 2025 (12 instalments)
- Total invested: ₹5,000 × 12 = ₹60,000
- Portfolio value on 5 January 2026: ₹64,000
Absolute return = (64,000 − 60,000) ÷ 60,000 × 100 ≈ 6.67%
That looks modest. But the first instalment was invested for 12 months, while the last one was invested for just one month. On average, your money was invested for only about six and a half months.
When you enter these 12 outflows and the final value into an XIRR function, the result is approximately 12.5% per year. So the same SIP shows about 6.67% absolute return but about 12.5% XIRR. Both numbers are correct; they answer different questions.
Try your own SIP dates in the Quantsgrow XIRR calculator.
A simpler XIRR check you can do by hand
Here is a two-instalment example you can verify on paper, again for illustration only:
- ₹50,000 invested on 1 January 2024
- ₹50,000 invested on 1 January 2025
- Value on 1 January 2026: ₹1,20,000
If the yearly rate is r, then 50,000 × (1 + r)² + 50,000 × (1 + r) = 1,20,000. Solving this quadratic gives (1 + r) ≈ 1.128, so the XIRR is roughly 12.8% per year. Absolute return here is 20%, but it took two separate instalments and up to two years to earn it.
CAGR vs XIRR vs absolute return: comparison table
| Feature | Absolute return | CAGR | XIRR |
|---|---|---|---|
| What it measures | Total % gain | Yearly compounded growth | Yearly return across many cash flows |
| Considers time? | No | Yes | Yes, for every cash flow |
| Number of cash flows | One in, one out | One in, one out | Any number, on any dates |
| Best for | Holdings under 1 year | Lumpsum, index or NAV growth | SIP, top-ups, withdrawals, SWP |
| Example result (above) | 80% or 6.67% | 12.47% | About 12.5% for the SIP |
| Tool | Simple arithmetic | CAGR calculator | XIRR calculator or spreadsheet |
When to use which return measure
Use absolute return when
- Your holding period is less than one year.
- You simply want to know your total profit or loss in percentage terms.
Use CAGR when
- You made one lumpsum investment and did not add or withdraw money.
- You want to compare the growth of an index, a stock price or a fund NAV between two dates.
- You are checking a scheme’s point-to-point returns published in its factsheet.
Use XIRR when
- You invest through a SIP or step-up SIP.
- You have made top-ups, switches or partial withdrawals.
- You want to judge your personal return, not just the fund’s return.
If you want to understand how SIP maturity values are projected, read our guide on how SIP returns are calculated. For the lumpsum side, see SIP vs lumpsum.
Fund returns vs your returns
Fund factsheets and AMFI data usually show scheme returns as point-to-point figures, annualised (CAGR) for periods above one year and absolute for shorter periods. SEBI’s rules on performance disclosure also require funds to show returns against a benchmark.
Your own return can be quite different from the fund’s published CAGR, because you entered on different dates and in different amounts. That is why your consolidated account statement or portfolio app shows XIRR. Two investors in the same fund can have very different XIRRs.
Common mistakes investors make
- Dividing absolute return by years. This ignores compounding and overstates yearly returns, as the 16% vs 12.47% example shows.
- Using CAGR for a SIP. CAGR treats all your money as if it were invested on day one, which understates SIP returns.
- Annualising very short periods. A 3% gain in two months annualises to about 19%, which is misleading.
- Comparing XIRR of one investment with CAGR of another. Compare like with like, over the same dates.
- Ignoring costs and tax. Returns shown are usually before tax. Check post-tax outcomes before drawing conclusions.
- Getting the signs wrong in Excel. Investments must be negative and current value positive, or XIRR will return an error.
A return figure is only meaningful when you know which question it answers: how much in total, how fast per year, or how fast per year across all your cash flows.
How to check your returns in practice
- Note every investment date and amount, including SIP instalments.
- Note the current value and today’s date.
- For a single lumpsum, use CAGR.
- For anything with more than one cash flow, use XIRR.
- Compare against a relevant benchmark over the same dates, for example using the mutual fund category pages.
Conclusion
Understanding CAGR vs XIRR vs absolute return helps you read your portfolio honestly. Absolute return tells you the total gain, CAGR tells you the yearly growth of a single investment, and XIRR tells you the true yearly return when money moves in and out on many dates. For most SIP investors, XIRR is the number that matters.
Want to test your own numbers? Open the free Quantsgrow app and use the XIRR calculator for SIPs or the CAGR calculator for lumpsum investments. You can also explore all our free investment calculators.
Frequently Asked Questions
What is the main difference between CAGR and XIRR?
CAGR measures the yearly growth rate of a single investment made on one date and valued on another date. XIRR measures the yearly return when money goes in or comes out on many different dates, such as SIP instalments, top-ups or withdrawals. If you invested only once, CAGR and XIRR give practically the same answer. With multiple cash flows, XIRR is the more accurate measure.
Why is my SIP absolute return lower than its XIRR?
Absolute return compares total gain with total amount invested, ignoring how long each instalment stayed invested. In a SIP, the later instalments have been invested only for a few months, so the overall percentage gain looks small. XIRR adjusts for the time each rupee was invested and converts the result into a yearly rate. Over short periods, XIRR can therefore look much higher than absolute return.
Is a good CAGR always better than a good XIRR?
They cannot be compared directly unless they describe the same type of investment. CAGR is meant for lumpsum, point-to-point growth, while XIRR is meant for investments with many cash flows. A fair comparison uses the same measure for both options over the same period. For example, compare the XIRR of two SIPs, or the CAGR of two lumpsum investments, over identical dates.
Should I use absolute return for investments held less than one year?
Yes, many investors and fund factsheets prefer absolute return for periods shorter than one year. Annualising a short-period return can exaggerate it. For instance, a 3% gain in two months would annualise to roughly 19%, which may never actually happen over a full year. For short holdings, absolute return gives a more realistic picture of what you have actually earned.
How do I calculate XIRR without Excel?
XIRR has no simple closed-form formula, so it is solved by trial and error, which spreadsheets do automatically. You can use the XIRR function in Excel or Google Sheets by listing dates and cash flows, with investments as negative numbers and the current value as a positive number. Alternatively, free online tools such as the Quantsgrow XIRR calculator do the calculation for you.
Disclaimer
This article is for educational purposes only and is not investment advice. Quantsgrow is not a SEBI-registered investment adviser, and the examples used are hypothetical and for illustration only. Please consult a SEBI-registered investment adviser before making any investment decision. Mutual fund investments are subject to market risks; read all scheme-related documents carefully.
