Univest
Univest
  • Markets

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

  • November 16, 2026
  • Posted by: Kunal Singla
  • Category: Market
No Comments
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.

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

Table of Contents

Toggle
  • What Is CAGR?
  • What Is XIRR?
  • XIRR vs CAGR: Side by Side
  • Why CAGR Misleads for a SIP
  • How to Calculate XIRR in Excel
  • Other Points to Remember
  • Conclusion
  • Frequently Asked Questions
    • What is the difference between XIRR and CAGR?
    • Which is better for SIP returns, XIRR or CAGR?
    • How do I calculate CAGR?
    • How do I calculate XIRR in Excel?
    • Can XIRR be negative?
    • Is a higher XIRR always better?
    • Why do my fund’s CAGR and XIRR differ?

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.



CAGR returns XIRR
Author: Kunal Singla
Kunal Singla is the Associate Director - Research at Univest, leading quantitative equity research, intraday trading setups, and derivatives strategy. With 4+ years of experience in Indian equity markets, he combines rigorous quantitative methods with classical technical analysis to build high-conviction research frameworks for retail and advisory clients. He holds an MSc from the Indian Institute of Technology (IIT) Delhi — one of India's most selective institutions — and has completed the Certificate in Quantitative Finance (CQF), a globally recognised programme covering derivatives pricing, risk modelling, machine learning for finance, and advanced portfolio theory. This combination places him in a small group of Indian analysts with both deep academic training in quantitative methods and SEBI-recognised research credentials. Kunal holds seven SEBI-recognised NISM certifications spanning research, derivatives, portfolio management, and securities operations: Series-XV (Research Analyst), Series-XXI-A (Portfolio Managers), Series-XVI (Commodity Derivatives), Series-VIII (Equity Derivatives), Series-VII (SORM), Series-V-A (Mutual Fund Distributors), and Series-I (Currency Derivatives). At Univest — India's SEBI-registered research and advisory platform — Kunal leads research inputs for Pro Lite, Pro Super, Pro Gold, and Pro Commodity advisory services, alongside publishing intraday stock picks on Univest Blogs.

Leave a Reply Cancel reply