ad

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.


16 Nov 2026 • 10:18 am

XIRR vs CAGR: How Each Return Measure Is Calculated, Which One Suits SIPs and Lump Sums and How to Compare Fund Performance

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

  1. Enter each investment date in one column and the amount in the next, as a negative number.
  2. Add the current value on today's date as a positive number.
  3. Use the XIRR function with the cash flow range and the date range.
  4. 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

Note: This blog is for information purpose only. Investments and trading are subject to market risks, read all scheme related documents carefully.

Reviews

user-review-1
user-review-2
user-review-3
user-review-4
user-review-5

RESEARCH ANALYST

Get SEBI Registered
advice on the stocks
trending today.

Get 3 FREE Trade Ideas

+91
for Startups Accelerator 2024

for Startups Accelerator 2024

Trusted by 1Cr Indians

Trusted by 1Cr Indians

Awarded No.1 by Economic Times

Awarded No.1 by Economic Times

GET THE APP

Join 1Cr users today.

SEBI Registered Analyst-backed Picks. Free Demat. One App

  • Free Demat account in under 5 minutes
  • Live market data — Nifty, Sensex, sector insights
  • SEBI Registered analyst-backed stock picks
Get it on Google PlayDownload on the App Store
Stocks:
All|a|b|c|d|e|f|g|h|i|j|k|l|m|n|o|p|q|r|s|t|u|v|w|x|y|z

Copyright 2026 Univest. All rights reserved.
Designed with ❤️ in India

arrow down