CAGR and XIRR: How to Read Your Investment Returns

A mutual fund statement usually presents more than one number to describe how an investment has performed. There is the total amount invested, the current market value, and often an absolute percentage showing the simple gain. Alongside these, statements almost always display either CAGR or XIRR.

Seeing different percentage figures for the same folio can be disorienting. An investor might notice that their simple return is 15%, while the statement reports an XIRR of 11%, or vice versa. These numbers are not conflicting mistakes. They are simply different measuring tapes designed for different situations.

Understanding which metric applies depends entirely on one question: did the money enter the investment all at once, or did it move in and out over time?

What CAGR measures and when it works

CAGR stands for Compound Annual Growth Rate. It describes the constant yearly rate at which a single investment would have grown if it had compounded smoothly over a period of years.

In the real world, investments rarely grow at an even pace. An equity portfolio might drop in its second year and rise sharply in its third. CAGR ignores that volatility and calculates a single smoothed annual figure that bridges the starting value and the ending value.

Because CAGR only requires a starting value, an ending value, and a time period, it works well for a single lump-sum investment. If an investor put ₹1,00,000 into an instrument on 1 January 2021 and held it until 1 January 2024, the timeline has one clear start and one clear end. CAGR measures that three-year journey accurately.

The formula for CAGR divides the final value by the initial value, raises that ratio to the power of one divided by the number of years, and subtracts one. It is a helpful tool when comparing how different lump sums performed over identical timeframes.

CAGR fails, however, as soon as a second cash deposit or a withdrawal enters the picture.

Why multiple cash flows break CAGR

Most people do not invest once and walk away. A salaried saver might invest through a Systematic Investment Plan (SIP), adding ₹5,000 on the fifth of every month. A business owner might add money whenever surplus cash becomes available, or withdraw funds to pay advance tax.

Each of these transactions creates a new, independent timeline.

Consider an SIP running for three years. The very first monthly instalment stays invested for the full 36 months. The second instalment stays invested for 35 months. The instalment paid in the final month stays invested for only 30 days.

If an investor tries to calculate CAGR for the whole portfolio, what should the starting date be? Using the date of the first payment treats the final payment as if it had been working for three years, which understates the true performance. Using an average date distorts the compounding effect. Because CAGR cannot accommodate different sums of money working for different lengths of time, it cannot accurately reflect the return on an SIP.

This is where XIRR becomes necessary.

How XIRR handles irregular cash flows

XIRR stands for Extended Internal Rate of Return. It is an extension of the internal rate of return (IRR) calculation used in corporate finance, adjusted to handle transactions that take place on specific calendar dates.

XIRR looks at an investment as a ledger of cash flows. Every deposit is entered as cash going out of the investor's bank account on a particular date. Every withdrawal, dividend payout, and the current portfolio valuation is entered as cash coming back in on its specific date.

The calculation then solves for a single annual rate of return that makes the present value of all those separate cash flows equal to zero. In plain English, XIRR asks: what constant annual rate of growth would turn each specific rupee, invested on its exact date, into the final portfolio balance?

Because XIRR tracks the exact date of every single transaction, it handles regular monthly SIPs, skipped instalments, ad-hoc lump sums, and partial redemptions within the same calculation.

A concrete comparison between the two

To see how the timing of money changes the reported return, consider a simplified hypothetical example covering one full year.

Suppose Investor A deposits a single lump sum of ₹1,20,000 on 1 January. By 31 December of the same year, the investment is worth ₹1,30,000.

Investor B decides to invest ₹10,000 on the first day of each month, starting 1 January and ending 1 December, totalling the same ₹1,20,000 invested. By 31 December, Investor B’s portfolio is also worth ₹1,30,000.

Both investors put in ₹1,20,000 in total. Both finished the year with ₹1,30,000, representing an absolute gain of ₹10,000.

For Investor A, the CAGR calculation is straightforward:

• Initial value: ₹1,20,000
• Final value: ₹1,30,000
• Duration: 1 year
• CAGR: 8.33%

Because all ₹1,20,000 was at work for the entire 12 months, the annual pace of growth was 8.33%.

For Investor B, CAGR cannot be applied because the money entered gradually. Using XIRR to account for the exact monthly dates yields a very different result: approximately 16.1%.

This is not an error, nor did Investor B find a magical shortcut. Investor B generated the same ₹10,000 gain, but did so without committing the entire ₹1,20,000 on day one. The first ₹10,000 worked for 12 months, but the final ₹10,000 worked for only one month. On average, the capital was deployed for only about six and a half months. Earning ₹10,000 in that shorter average window requires a much higher annualized rate of growth.

Note: This arithmetic is an assumption designed solely to show how the formulas operate, not a forecast or indication of actual market performance.

What these metrics cannot tell you

While CAGR and XIRR are reliable mathematical tools, they have distinct limitations that investors should keep in mind.

First, neither metric reflects the actual path the investment took. An investment that delivered a 12% CAGR over five years could have experienced severe downward swings along the way. CAGR and XIRR show the start and the finish, but completely hide the volatility experienced during the journey.

Second, annualizing figures over very short periods creates distortion. If an investment gains 3% over a two-week period, an XIRR calculation will annualize that pace across 365 days, producing an enormous, artificial percentage that cannot realistically be sustained. For this reason, regulations set by the Securities and Exchange Board of India (SEBI) generally require performance for periods under one year to be shown as absolute returns rather than annualized rates.

Third, XIRR is sensitive to the timing of large transactions. If an investor maintains a small SIP for five years and then deposits a very large lump sum shortly before a sharp market rally, the XIRR for the entire portfolio will jump significantly. The metric accurately reflects the cash flows, but the figure is heavily influenced by the recent large deposit rather than the long-term discipline of the earlier instalments.

Finally, neither figure accounts for deductions such as exit loads, applicable taxes, or the eroding effect of inflation on purchasing power. The return shown on a statement is a nominal, pre-tax calculation.

Matching the tool to the task

Reading an investment statement becomes simpler once each metric is kept in its proper place.

CAGR is the appropriate tool for measuring a single lump sum that was invested on one date and evaluated on another. It provides a clean, standardized rate for money that stayed intact throughout.

XIRR is the standard tool for ongoing investments, including monthly SIPs and portfolios with irregular additions or withdrawals. It ensures that the return figure reflects not just how much money was invested, but how long each individual rupee was given to work.