
XIRR vs CAGR: How Each Return Measure Is Calculated, Which One Suits SIPs and Lump Sums and How to Compare Fund Performance
CAGR = (ending value / starting value)^(1/years) – 1, for one lump sum. XIRR gives an annualised return for several investments on different dates, such as a SIP. Use XIRR for SIPs.
Updated: 16 Nov 2026 • 10:18 am
Posted by:

Quick Answer
XIRR vs CAGR comes down to the pattern of cash flows. CAGR gives the yearly growth rate of a single investment held from start to end, so it suits a lump sum. XIRR calculates an annualised return when you invest or withdraw several times on different dates, so it is the right measure for a SIP. Using CAGR on a SIP gives a misleading number.
XIRR vs CAGR confuses many investors because both are shown as a yearly percentage. They answer slightly different questions, and picking the wrong one can make a fund's performance look better or worse than it is.
This guide explains how each is calculated, when to use it and how to compare returns fairly.
Click Here – Get Free Investment Predictions
What Is CAGR?
CAGR is the compound annual growth rate. It assumes a single investment grows at a steady rate each year between a starting value and an ending value. The formula is (ending value divided by starting value) raised to the power of one divided by the number of years, minus one.
For example, if Rs 1,00,000 grows to Rs 2,00,000 in six years, CAGR is about 12.2%. It smooths the ups and downs into one yearly figure, which makes it a good way to compare lump sum investments or the growth of a company's revenue.
What Is XIRR?
XIRR is the extended internal rate of return. It finds the annualised return that makes the value of all your cash flows, with their exact dates, equal to the final value. It is used when you add or withdraw money at different times, as in a SIP, an extra investment or a partial redemption.
The calculation is complex, so it is done with a spreadsheet or a calculator. In Excel, you list the dates and the cash flows, with investments as negative numbers and the final value as a positive number, and apply the XIRR formula.
XIRR vs CAGR: Side by Side
| Feature | CAGR | XIRR |
|---|---|---|
| Cash flows | One in, one out | Many, on any dates |
| Best for | Lump sum, company growth | SIP, irregular investments |
| Needs dates | Only start and end | Every cash flow date |
| Calculation | Simple formula | Iterative, via spreadsheet |
| Time value of money | Not adjusted for interim flows | Adjusted for each flow |
Why CAGR Misleads for a SIP
Use the Univest Screener to check live fundamentals before you act on any idea.
In a SIP, money goes in at different times, so each instalment is invested for a different length. If you take the first and last date and apply CAGR on total invested and final value, you treat all the money as if it had been invested on day one. That understates the return because later instalments had less time to grow. XIRR corrects this by weighing each instalment by its holding period.
XIRR and CAGR both give a yearly percentage, but XIRR and CAGR answer different questions. Pick CAGR and XIRR according to the pattern of investments, not according to which number looks better. The XIRR formula and the CAGR formula are both available as an Excel formula, so you can check any figure a platform shows, even over a short investment period or with SIPs and other irregular investments.
How to Calculate XIRR in Excel
- Enter each investment date in one column and the amount in the next, as a negative number.
- Add the current value on today's date as a positive number.
- Use the XIRR function with the cash flow range and the date range.
- Read the result as an annualised return, and compare it with a benchmark such as the Nifty 50 over the same dates.
Most fund platforms and the mutual fund factsheet already show XIRR for SIPs and CAGR for lump sums, so check which measure is being displayed before comparing numbers.
Other Points to Remember
- Absolute return ignores time. A 50% gain over two years is very different from a 50% gain over ten.
- Returns shown for periods under one year are usually absolute, while longer periods are annualised.
- Compare like with like: XIRR with XIRR, and CAGR with CAGR.
- Past returns do not guarantee future returns, and a high XIRR over a short period can reflect timing and luck.
Download the Univest iOS App or Univest Android App to get daily stock research and market updates.
Conclusion
Use CAGR for a single investment held for a clear period, and use XIRR when money enters or leaves at different dates, as with SIPs. Both turn performance into a yearly number so you can compare options.
Check which measure a platform shows, compare with a benchmark over the same period and avoid reading too much into short term numbers.
Disclaimer: Data and figures in this article are sourced from publicly available information. These may or may not be accurate. Please verify all data with the official NSE (nseindia.com) and BSE (bseindia.com) websites before making any investment decision. Investments in securities are subject to market risk. This content is for educational purposes only and is not investment advice by Univest (SEBI RA INH000013776).
Frequently Asked Questions
What is the difference between XIRR and CAGR?
Ans. CAGR measures the yearly growth of a single investment between two dates. XIRR calculates the annualised return for several cash flows on different dates. CAGR suits lump sums, while XIRR suits SIPs and irregular investments.
Which is better for SIP returns, XIRR or CAGR?
Ans. XIRR is the right measure for a SIP because each instalment is invested for a different period. CAGR treats all money as invested on the first date, which understates the return for a SIP.
How do I calculate CAGR?
Ans. Divide the ending value by the starting value, raise the result to the power of one divided by the number of years, and subtract one. Multiply by 100 to get a percentage. It assumes steady growth and no additional investment.
How do I calculate XIRR in Excel?
Ans. List dates and cash flows, with investments negative and the current value positive, then use the XIRR function with the values and the dates. Excel returns the annualised return. Make sure the dates are in a valid date format.
Can XIRR be negative?
Ans. Yes. If the final value is less than the money you put in, XIRR is negative. It then shows the annualised loss rate, which is useful for comparing how bad a fall was across different holding periods.
Is a higher XIRR always better?
Ans. Not always. XIRR over a short period can be inflated by timing, and it does not show risk. Compare it over similar periods, with similar funds and against a benchmark, and look at volatility as well.
Why do my fund's CAGR and XIRR differ?
Ans. They are calculated differently. CAGR assumes one investment and ignores timing of other flows, while XIRR accounts for each date. If you invested more than once, XIRR gives a truer picture of your own return.
Recent Articles

Dow Theory Explained: Primary, Secondary and Minor Trends, Index Confirmation and How to Draw Trendlines on a Stock Chart
16 November 2026

Supertrend Indicator Explained: How ATR and Multiplier Settings Work, How to Read Buy and Sell Signals and Where It Fails
16 November 2026

Pivot Points in Stock Market: How to Calculate Support and Resistance Levels and Use Them for Intraday Trades
16 November 2026

Gap Up and Gap Down in Stocks: Types of Gaps, Why They Happen and How Traders Handle Gap Fills and Breakouts
16 November 2026
Note: This blog is for information purpose only. Investments and trading are subject to market risks, read all scheme related documents carefully.
Reviews
Recent Posts
Dow Theory Explained: Primary, Secondary and Minor Trends, Index Confirmation and How to Draw Trendlines on a Stock Chart
Supertrend Indicator Explained: How ATR and Multiplier Settings Work, How to Read Buy and Sell Signals and Where It Fails
Pivot Points in Stock Market: How to Calculate Support and Resistance Levels and Use Them for Intraday Trades
Gap Up and Gap Down in Stocks: Types of Gaps, Why They Happen and How Traders Handle Gap Fills and Breakouts
Head and Shoulders and Double Top Patterns: How to Spot Reversals, Confirm the Neckline, Set Targets and Read the Double Bottom
Popular this week
VWAP Indicator Explained: How Volume Weighted Average Price Is Calculated and How Intraday Traders Use It for Entries and Exits

Uniresearch Global Pvt Ltd
Research Analyst
SEBI Registration Number — INH000013776
Uniresearch is a subsidiary of Univest Communication Technologies Private Limited
Company Address: Registered Address: Ground Floor, Unitech Commercial Tower 2, Block B, Greenwood City, Unit 1-3, Sector 45, Gurugram, Haryana 122003
Write to us : support@univest.in, compliance@univest.in
Verify on SEBI registry →RESEARCH ANALYST
Get SEBI Registered
advice on the stocks
trending today.
Get 3 FREE Trade Ideas
for Startups Accelerator 2024
Trusted by 1Cr Indians
Awarded No.1 by Economic Times





