CAGR vs XIRR vs Absolute Returns: Which One Is Correct?

Absolute return, CAGR and XIRR answer three different questions, and the thing that decides which one is correct is cashflow timing. Absolute return measures the total change in value and ignores time entirely. CAGR converts that change into a steady yearly rate, but only works when there is a single amount invested at the start. XIRR is the version that survives contact with reality, because it handles money going in and out on irregular dates.

Getting this wrong is not a technicality. The same account can show three very different numbers depending on which measure is applied, and only one of them is describing what the investor actually earned.

What each one measures

Absolute return is the simplest. Take the ending value, subtract the starting value, and express the difference as a percentage of the starting value. That is it. There is no time in the formula at all. A gain of 60 percent is a gain of 60 percent whether it took eight months or eight years.

CAGR, the compound annual growth rate, adds time. It asks what constant annual rate, compounded once a year, would have carried the starting value to the ending value over the number of years involved. In words: divide the ending value by the starting value to get the growth multiple, then find the yearly rate that compounds to that multiple over that many years. The full treatment is in what is CAGR.

XIRR, the extended internal rate of return, adds cashflows. It asks a harder question: given every amount that went in or out, and the exact date of each, what single annual rate makes all of them consistent with the final value. Technically it is the annual discount rate at which the present value of all cashflows, treating money paid in as negative and money received or remaining as positive, comes to zero. There is no closed formula. Spreadsheet and programming tools solve it by trial and error until the equation balances.

The important intuition behind XIRR is that it weights each rupee by how long it was actually invested. Money that went in early counts for more time than money that went in last month, and XIRR accounts for that automatically.

Measure	Handles time	Handles cashflows	Natural use
Absolute return	No	No	Short periods, or comparing identical horizons
CAGR	Yes	No	A single lumpsum, start to end
XIRR	Yes	Yes	Any account with contributions and withdrawals

How to read it

Start by asking one question about the money: did anything go in or out during the period? If the answer is no, CAGR and XIRR will agree, and CAGR is the simpler thing to quote. If the answer is yes, CAGR is measuring the wrong quantity, because part of the change in value came from deposits rather than from growth, and CAGR has no way to separate the two.

A hypothetical illustration shows how large the distortion can get. Imagine an account that starts the year with 100 and ends the year with 300. Read as a lumpsum, that looks like a 200 percent gain. But suppose 180 of that was deposited in the final month. Almost all of the increase in value was new money, not return, and the actual rate earned on the capital was modest. CAGR from opening to closing balance would report something spectacular. XIRR, which knows the dates, would report something ordinary. Only the second is a description of performance.

Second, ask what the number is being compared to. A rate is only meaningful next to a reference measured the same way over the same window. Comparing a fund’s XIRR to an index’s point-to-point CAGR is not a fair comparison, because the two are not answering the same question. If you want to know whether an approach added anything, the reference has to be constructed on the same cashflow schedule, which is the discipline behind buy and hold vs strategy returns.

Third, check the period length before you accept any annualised figure. Annualising three months of performance takes whatever happened in one quarter and projects it across a year. It produces large, confident-looking numbers from very little information. For anything under about a year, absolute return is the more honest presentation, and reputable reporting conventions in India follow that practice for exactly this reason.

Fourth, look at whether the figure is gross or net. Costs, fund expenses and taxes all sit between a gross return and what an investor keeps, and over long horizons the difference compounds. A number is not comparable to another number unless both sit on the same side of costs.

The measure follows the cashflows. No cashflows, use CAGR. Cashflows on irregular dates, use XIRR. Short period, just say what the value did.

What it does not tell you

None of these three measures is a risk measure, and that is the single biggest thing to hold in mind. Each of them is a summary of the outcome, and each is silent about the experience of getting there.

They do not tell you the path. All three depend on endpoints and, for XIRR, on cashflow dates. None of them contains any information about how far the value fell along the way, how long it stayed below its previous high, or how volatile the ride was. That is the job of separate figures such as maximum drawdown and volatility.

They do not tell you about consistency. A rate computed once over one window cannot show whether the outcome came from a handful of exceptional months or from broad, repeated performance. Rolling returns exist to answer that.

They do not adjust for risk taken. Two accounts can report the same XIRR while one held a concentrated, leveraged position and the other held a diversified one. Comparing them on return alone is comparing them on half the information.

XIRR can be unstable or ambiguous in odd cases. Because it is solved numerically, a cashflow pattern that changes sign many times can in principle admit more than one mathematically valid answer, and a sequence dominated by a very late large cashflow can produce an extreme rate that is technically correct but practically meaningless. Sanity-check any XIRR that looks implausible against the plain absolute change in value.

Absolute return hides the horizon completely. A total gain quoted without a time period is not a performance figure at all, and it is the easiest of the three to present misleadingly.

None of them is a forecast. Every one of these numbers describes a window that has already closed. Nothing in the arithmetic carries forward, and treating a past rate as an expected rate is a category error rather than a small approximation.

They inherit the quality of the underlying data. If the values or prices used were later revised, or if a price series was not adjusted for corporate actions, the return being reported is a return on a history that was never actually observable at the time. That is the practical reason point-in-time data matters even for something as basic as a growth rate.

Used correctly, the choice is not difficult. Look at the cashflows, pick the measure that respects them, state the window and whether the figure is gross or net, and put a risk measure next to it.

Related reading

• Portfolio metrics explained: the hub that maps how return, risk and trade statistics fit together.
• What is CAGR: the compound annual growth rate in full, and what it smooths away.
• Rolling returns explained: removing the start-date luck that single-window rates carry.
• Buy and hold vs strategy returns: building a like-for-like baseline to compare a rate against.
• Expense ratio impact on returns: why the gap between gross and net widens with time.

This article is educational. Altys Labs is not a registered research analyst or investment adviser, and nothing here is investment advice or a recommendation to buy, sell, or hold any security.