CAGR vs XIRR: Which Return Metric Should You Trust?

CAGR, or Compound Annual Growth Rate, is the annualised rate at which an investment would have had to grow, steadily and without interruption, to get from its starting value to its ending value over a given period. It's a smoothing device: it doesn't describe the actual, bumpy year-to-year path an investment took, but rather the single constant growth rate that would produce the same end result. This makes CAGR the natural metric for describing a single lump-sum investment  money put in once, left untouched, and measured at two points in time  which is exactly why every index, mutual fund, and PMS strategy fact sheet leads with a CAGR figure for "3-year returns" or "5-year returns."

The concept itself is old  a basic extension of compound-interest math that has been part of standard corporate finance and accounting practice for decades, long before personal-finance apps existed. What changed is accessibility: CAGR used to require a calculator and a bit of algebra; today it's a single formula in any spreadsheet or a number auto-generated by every investment app in the country.

The formula is straightforward:

CAGR = [(Ending Value / Beginning Value) ^ (1 / Number of Years)] − 1

You take the ratio of what your investment became to what it started as, take the nth root (where n is the number of years), and subtract 1 to express it as a growth rate. Because it only uses two data points  the start value and the end value  CAGR is blind to everything that happened in between, including volatility, drawdowns, or any additional money added along the way. That's both its strength (simplicity, comparability) and its biggest limitation, discussed later in this guide.

Say you invested ₹5,00,000 as a lump sum in a PMS strategy on 1 April 2021, and by 31 March 2026 (five years later) it had grown to ₹11,25,000.

CAGR = [(11,25,000 / 5,00,000) ^ (1/5)] − 1 CAGR = [(2.25) ^ 0.2] − 1 CAGR ≈ 17.6% per annum

That single number tells you the equivalent steady annual growth rate  not the actual path, which may have included a sharp drawdown in year two and a strong recovery in year four. For a genuine one-time, buy-and-hold investment, that's a perfectly fair and useful number. The problem starts the moment more than one cash flow enters the picture.

XIRR, or Extended Internal Rate of Return, solves exactly the problem CAGR can't handle: multiple cash flows happening on different, irregular dates. It's the version of the classic Internal Rate of Return (IRR) concept generalised for real-world investing, where money rarely goes in  or comes out  in one tidy lump sum. SIP instalments, ad hoc top-ups, partial redemptions, dividend reinvestments, and PMS/AIF capital calls all happen on their own schedule, and XIRR is built to find the single annualised rate of return that makes the present value of every one of those cash flows  in and out  net out to zero.

XIRR became practically usable for ordinary investors once spreadsheet software made the underlying iterative calculation (which has no simple algebraic solution) a one-line function. Microsoft's own documentation describes exactly how the function works and what inputs it needs (see the official Microsoft Excel XIRR function documentation). As SIPs became the default way most Indians invest in mutual funds, and as PMS/AIF products scaled up with staggered funding structures, XIRR moved from a spreadsheet curiosity to the standard way individual investors  and the apps they use  report personal returns (see Forbes Advisor India's explainer on XIRR in mutual funds for a further look at how it's applied in everyday SIP tracking).

Unlike CAGR, XIRR has no neat closed-form formula you can write out and solve by hand. In Excel or Google Sheets, it's expressed as:

=XIRR(values, dates, [guess])

Where values is the list of every cash flow (negative for money going out of your pocket, positive for money coming back to you or the value of your holding today), and dates is the corresponding list of actual transaction dates. The spreadsheet then uses an iterative approximation method to find the discount rate that makes the net present value of all those cash flows equal zero  essentially testing rates until the math balances (a deeper technical explanation of this iterative process, including where it can go wrong, is covered in the Wall Street Prep guide to the XIRR function).

Consider a PMS investor who commits capital in two tranches: ₹3,00,000 on 1 January 2023 and a further ₹2,00,000 on 1 July 2024, and whose portfolio is worth ₹6,80,000 on 1 January 2026.

A CAGR calculation here would be meaningless  there's no single "beginning value," just two separate inflows at different times. XIRR handles this correctly by treating each cash flow on its actual date:

• −₹3,00,000 on 1 Jan 2023
• −₹2,00,000 on 1 Jul 2024
• +₹6,80,000 on 1 Jan 2026 (current value)

Running this through the XIRR function returns an annualised return of roughly 19–20%  a figure that correctly weights the fact that the second tranche had less time to compound than the first. This is the number that reflects what the investor actually earned, given exactly when their money went to work  something no CAGR calculation could produce from this data.

The short version: CAGR tells you how the investment itself grew; XIRR tells you how your money, specifically, grew. For a genuine lump-sum PMS mandate funded on a single date, the two will actually converge to the same number  the divergence only appears once multiple cash flows enter the picture.

There's a third metric that frequently gets tangled up in this conversation: absolute return, calculated simply as:

Absolute Return = [(Final Value − Initial Investment) / Initial Investment] × 100

Absolute return tells you your total percentage gain or loss over the entire holding period, with no adjustment for time at all. A fund that returns 50% absolute over one year and a fund that returns 50% absolute over five years look identical on this metric  even though the first is a vastly better outcome on an annualised basis. For a single lump-sum investment, absolute return and CAGR describe the same underlying growth, just expressed differently (one as a total percentage, one as an annualised rate); for a SIP or any staggered investment, absolute return and XIRR can diverge sharply, because absolute return still ignores when each rupee went in. A SIP that shows a modest-looking absolute return over 12 months might actually carry a strong XIRR, simply because most of the money was invested late and hasn't had much time to compound yet  the two numbers are answering different questions, not disagreeing about the same one.

The practical rule: use absolute return only as a rough, first-glance number for a single investment; the moment more than one cash flow or more than roughly a year is involved, lean on CAGR (for lump sums) or XIRR (for irregular cash flows) instead.

CAGR remains the right tool  not an inferior one  in several common situations:

• Comparing a fund or index's own performance across periods or against a benchmark, since both sides of the comparison are point-to-point figures with no investor cash flows involved.
• A genuine, one-time lump-sum investment  for example, a single PMS mandate funded entirely on day one and measured against its current value, with no subsequent additions or withdrawals.
• Marketing and disclosure documents that describe a strategy's own historical track record, independent of any particular investor's entry and exit timing.
• Quick, back-of-envelope comparisons between asset classes (equity vs debt vs gold, for instance) over a fixed historical window, where the goal is understanding the asset's behaviour rather than any individual's portfolio.

The moment your own money entered at more than one point in time  a SIP, a top-up, a PMS or AIF drawdown  CAGR stops being the right lens, and XIRR takes over.

This is where the stakes rise considerably. Mutual fund SIP investors have generally absorbed the "use XIRR, not CAGR, for SIPs" lesson by now  most apps calculate it automatically. PMS and AIF investors face a more layered problem, because these products introduce a third metric that mutual fund investors rarely need to think about: the Time-Weighted Rate of Return (TWRR).

Portfolio Management Services in India are required by SEBI to report performance using TWRR rather than a simple weighted-average or absolute return figure  a shift from the earlier reporting norm that was widely covered when SEBI first introduced it (see Business Standard's coverage of SEBI's performance benchmarking guidelines for the PMS industry). TWRR strips out the effect of the timing and size of investor cash flows entirely  it measures what a strategy delivered on, effectively, a single rupee invested from the start of the period, regardless of when other investors added or withdrew capital. That's precisely why regulators mandate it: TWRR is designed to isolate manager skill from investor behaviour, so that two clients in the same PMS strategy who invested on different dates and in different amounts still see the same, comparable TWRR figure for that strategy (see SEBI's official circular on performance benchmarking and reporting by portfolio managers and the consolidated SEBI Master Circular for Portfolio Managers).

Here's the layering that trips investors up: the PMS strategy's official, SEBI-mandated performance is reported in TWRR. Your own personal return, given exactly when your capital was actually deployed, is best captured by XIRR. And CAGR is what you'd see if your entire investment happened to be funded in a single tranche. All three can legitimately show different numbers for the same account, and none of them is "wrong"  they're each answering a different question.

AIFs make this even more pronounced. A Category II or III AIF typically doesn't call the investor's full committed capital upfront; it draws down capital in tranches as investment opportunities arise, sometimes over 18–24 months or longer. An investor who commits ₹1 crore might see only ₹25 lakh called in the first six months, another ₹40 lakh a year later, and the remainder drawn down over the following year. Measuring "return" on this kind of structure with a simple CAGR from commitment date to current value would badly understate the real annualised return, because it wrongly assumes the full ₹1 crore was invested  and therefore compounding  from day one. XIRR, built precisely for exactly this kind of irregular, multi-date cash flow pattern, is the only metric that gives a fair, personally accurate answer for an AIF investor's own capital account. Comparing that strategy against a benchmark like the Nifty 50 TRI, meanwhile, is properly done on a TWRR basis, exactly as SEBI requires PMS strategies to report.

Even once you know which metric to use, both CAGR and XIRR have real limitations investors should know about before treating either as gospel.

• Using CAGR on a SIP or staggered investment. This is the single most common mistake, and it can materially distort the perceived return  usually by ignoring the fact that later instalments haven't had as long to compound as earlier ones.
• Treating a headline CAGR as "guaranteed" or "smooth." CAGR is a mathematical smoothing of an often volatile path; an investment with a strong 5-year CAGR could easily have had a brutal drawdown in year three that a lump-sum investor would have had to sit through.
• Comparing your personal XIRR to a fund's published CAGR as if they're the same thing. They answer different questions and will rarely match exactly, even for the same underlying investment, once your entry and exit timing differs from a simple point-to-point measurement.
• Assuming a fund house always reports the metric that's most favourable to you, rather than most accurate. A distributor or fund factsheet has every incentive to lead with whichever number  absolute return, CAGR, or XIRR  happens to look strongest for a given period.

This is a genuinely under-discussed limitation. Because XIRR (like IRR) is found through iterative approximation rather than a direct algebraic formula, certain cash-flow patterns  particularly those involving significant losses or cash flows that alternate between positive and negative in unusual ways  can mathematically produce more than one valid rate that satisfies the equation, or in some cases, no solution the spreadsheet can converge on at all. In practice, Excel or Google Sheets will typically return just one of the possible answers without flagging that alternatives exist, which can give a false sense of precision. A detailed technical breakdown of exactly when and why this happens is available in freefincal's walkthrough of IRR/XIRR calculation limitations. The practical takeaway for most investors: XIRR is highly reliable for typical profitable investment patterns, but treat it with extra caution  and ideally cross-check with a portfolio's actual transaction history  when a portfolio has gone through a severe drawdown.

None of this is academic if you're actually trying to choose between 900-plus PMS, AIF, and GIFT City strategies. The whole point of understanding CAGR vs XIRR is to be able to look past a headline number and ask the right follow-up question: what, exactly, is this return measuring, and does it match how I would actually be investing? That's the "inner clause" most return figures don't spell out  the fine print about cash-flow assumptions hiding behind a single percentage.

This is precisely the problem PMS Sahi Hai was built to solve. On the Compare page, every PMS, AIF, and GIFT City strategy on the platform is shown on a consistent, annualised basis for periods of a year or more  so you're not stuck reconciling one fund house's CAGR against another's absolute return just to shortlist four strategies side by side. And because self-reported performance can be shaped by exactly the kind of metric-shopping this guide has described, PMS Sahi Hai built Nyra, its AI research engine, to score every strategy on a standardised, published basis rather than taking a single self-reported return figure at face value. Nyra reads factsheets, cites regulatory sources (SEBI, AMC, and IFSCA filings), and applies the same five-pillar framework to every fund  so a strategy can't simply win by quoting its best-looking metric for the period that flatters it most.

Where this matters most in practice is the moment an investor moves from browsing to actually committing capital  because that's exactly when CAGR, XIRR, and TWRR stop being abstract definitions and start describing three different numbers on the same statement. PMS Sahi Hai operates on a commission-free, upfront-fee model specifically so that the platform's incentive is to help you understand which strategies genuinely fit your goals  not to steer you toward whichever fund happens to pay the highest trail commission. Understanding CAGR vs XIRR is the first step; having a platform built to show you standardised, comparable numbers in the first place is what makes that understanding actually usable.

CAGR and XIRR aren't competing metrics where one is simply "better"  they're two different tools built for two different cash-flow situations, and the real skill is knowing which one applies to what you actually did. CAGR is the right lens for a fund's own point-to-point track record or a genuine lump-sum investment. XIRR is the right lens the moment your money went in  or came out  on more than one date, which describes most SIPs, top-ups, and PMS/AIF drawdowns. And for PMS investors specifically, a third figure, TWRR, sits alongside both as the SEBI-mandated way to judge a manager's skill independent of anyone's personal investment timing.

The investors who get burned aren't the ones who pick the "wrong" formula  they're the ones who never ask which formula they're looking at in the first place. Before you compare two PMS strategies, two AIFs, or a fund against your own portfolio, take ten seconds to check: is this a CAGR, an XIRR, a TWRR, or an absolute return? That one question does more to protect you from a misleading return figure than almost anything else in this guide.

Ready to compare PMS, AIF, and GIFT City strategies on numbers that actually mean the same thing? Explore the full, standardised comparison on the PMS Sahi Hai Compare page, or see how Nyra scores every strategy on a consistent, published basis before you commit a single rupee.