XIRR vs CAGR: Understanding the Key Investment Metrics

The conversation around XIRR vs CAGR shows up every time an investor tries to decode a portfolio statement, a mutual fund fact sheet, or a back-tested model. Both are annualised return measures, but they answer slightly different questions. XIRR and CAGR sit next to each other in many dashboards, and yet a reader often wonders which one truly reflects performance. This piece clarifies the Difference between XIRR and CAGR, explains when each shines, and shows how numbers move in real, date-stamped cash flows that most investors actually experience.

At the heart of it, XIRR and CAGR measure growth with compounding. CAGR focuses on growth between one starting value and one ending value over a period. XIRR solves for the annualised rate that links many cash flows that arrive or leave the investment at irregular dates. The XIRR vs CAGR choice is therefore not about which one is “better.” It is about which one is faithful to the story that the money tells. Understanding the XIRR and CAGR Difference helps an investor pick the right lens for the right job.

What is XIRR?

XIRR stands for Extended Internal Rate of Return. It is an annualised return that accounts for actual dates of each cash flow. XIRR treats the investment journey as a timeline of debits and credits: instalments going in, dividends or interest coming out, partial redemptions, and the final exit value. It then solves for a single annual rate rrr that makes the present value of all dated cash flows equal to zero.

In practice, XIRR mirrors how money behaves in the real world. Salaried investors do SIPs on different days, founders top up capital when liquidity allows, and many investors book partial profits mid-way. Because timing matters, ₹1,00,000 invested in April is not the same as ₹1,00,000 invested in December. XIRR gives each cash flow a weight based on its time in the market.

Excel and Google Sheets both provide a built-in XIRR() function. Inputs are two arrays—cash flows (negative for investments, positive for receipts) and corresponding dates. The output is a single annualised number, easy to read and easy to compare across alternatives. When the objective is to capture reality with irregular contributions, XIRR is the metric that respects the calendar.

What is CAGR?

CAGR expands to Compound Annual Growth Rate. It compresses a multi-year journey into a smooth annual rate assuming all money was invested at the start and compounded without any intermediate inflows or outflows. If an investment moves from a beginning value BV\text{BV}BV to an ending value EV\text{EV}EV in nnn years, the formula is:

CAGR=(EVBV)1/n−1\text{CAGR} = \left(\frac{\text{EV}}{\text{BV}}\right)^{1/n} – 1CAGR=(BVEV​)1/n−1

CAGR is simple and elegant. It tells the average yearly pace at which wealth would have grown if the path were a straight compounding line. It is perfect for reporting how a single lump-sum behaved—say a ₹5,00,000 investment in a government security held for five years—or for comparing long windows of index performance. Because it suppresses short-term noise, many institutions use CAGR in marketing materials, factsheets, or goal-planning presentations.

However, CAGR does not see the bumps and turns. It cannot account for monthly SIPs, ad-hoc top-ups, step-up SIPs, SWPs, or mid-course partial exits. In other words, CAGR assumes a clean start and a clean finish. XIRR does not.

Difference between CAGR and XIRR

The Difference between XIRR and CAGR sits in their treatment of cash flows. CAGR handles a single outlay at time zero and a single value at the end. XIRR handles many inflows and outflows on specific dates. CAGR assumes a smooth ride; XIRR allows for messy reality. When an investor wants to evaluate a SIP in an equity fund or a series of bond purchases spread across quarters, XIRR becomes the right tool. When the investor wants to show how a lump-sum investment grew, CAGR does the job.

Because of this design, the XIRR and CAGR Difference is not merely academic. It influences how returns are read, how strategies are compared, and how decisions are justified. The Difference between XIRR and CAGR therefore should be understood before drawing conclusions from a statement or a chart.

XIRR vs CAGR: Key differences in a comparison table

XIRR vs CAGR distinctions come alive when put side by side.

A short paragraph helps: when instalments or redemptions are involved, the XIRR vs CAGR decision should lean to XIRR. If a single, one-time purchase was held to a single exit, CAGR tells the same story more simply.

Formula and numeric example for CAGR

Consider a lump-sum of ₹1,00,000 invested in a bond fund that becomes ₹1,46,410 after three years. The CAGR is:

CAGR=(1,46,4101,00,000)1/3−1=(1.4641)1/3−1≈0.13 or 13%\text{CAGR} = \left(\frac{1,46,410}{1,00,000}\right)^{1/3} – 1 = (1.4641)^{1/3} – 1 \approx 0.13 \text{ or } 13\%CAGR=(1,00,0001,46,410​)1/3−1=(1.4641)1/3−1≈0.13 or 13%

This 13 percent does not claim that each year individually earned 13 percent. Rather, it says the overall three-year journey is equivalent to compounding at 13 percent per annum. One year might have been flat, another might have jumped, and the third might have recovered from a dip. CAGR smooths those edges. It is an excellent headline number when one wishes to show the long-term pace of wealth creation from a single starting cheque to a single ending value.

Formula and numeric example for XIRR

Now consider a more realistic pattern. An investor deploys money in steps and exits later:

• 01-Apr-2021: invests ₹50,000
  
• 01-Sep-2021: invests ₹25,000
  
• 10-Jan-2022: invests ₹25,000
  
• 31-Mar-2023: receives ₹1,18,000 on redemption

Treating investments as negative cash flows and redemption as positive cash flow, and applying the XIRR() function, the annualised return works out to ~10.2%. This means that given the dates, the sequence, and the size of each instalment, a single annual rate of roughly 10.2 percent ties the timeline together.

Why can this differ from the CAGR of the final value versus the total money invested? Because the amounts went in at different times and therefore spent different lengths of time compounding. Money added early gets more market exposure than money added later. XIRR captures this exposure precisely; CAGR does not. When someone asks for the Difference between XIRR and CAGR, this dated cash-flow example answers it cleanly.

XIRR vs CAGR: Pros and Cons

A balanced view of XIRR vs CAGR helps an investor know which to rely on in which context.

A practical rule of thumb emerges: use CAGR for what grew, and XIRR for how the investor actually put money to work. In other words, CAGR tells a product’s story; XIRR tells the investor’s story.

Limitations or Assumptions associated with XIRR And CAGR

Even the right tool has edges. A clear list of assumptions keeps interpretation honest.

CAGR — limitations and assumptions

• Assumes a single investment at the start and a single value at the end.
  
• Hides the journey: the path could have been very volatile or very smooth; CAGR remains the same.
  
• Can flatter or understate outcomes when intermittent cash flows actually occurred but were ignored.
  
• Implicitly assumes reinvestment at the same rate, which may not hold for coupons, dividends, or cash drag.
  
• Unsuitable for strategies with frequent contributions, withdrawals, or rebalancing.

XIRR — limitations and assumptions

• Requires precise dates and amounts. Missing dividends, fees, or taxes will distort the number.
  
• Money-weighted by design; results can be heavily influenced by when large inflows or outflows occurred.
  
• Assumes interim cash flows, if reinvested, earn the same implicit rate—a simplification in many real portfolios.
  
• Sensitive to extreme early or late cash flows; a large last-minute addition or withdrawal can swing the rate.
  
• Needs spreadsheet functions; manual calculation is impractical without software.

A reminder is useful here: the XIRR vs CAGR discussion is not about proving one “wins.” It is about matching the measure to the question. When the question is, “How did a SIP actually perform given the dates and amounts?” XIRR is correct. When the question is, “How fast did this one cheque grow over the period?” CAGR is the cleaner answer.

Conclusion

Both metrics belong in the toolkit. XIRR and CAGR do not compete; they complement. CAGR summarises the average pace of a lump-sum. XIRR respects the calendar of contributions and withdrawals. The XIRR vs CAGR choice therefore depends on context. For a real portfolio with instalments and redemptions, use XIRR to evaluate the experience. For a product or a one-time investment, use CAGR to compare long-term pace. Keeping this Difference between XIRR and CAGR straight leads to sharper conversations and better decisions.

FAQs

Can I convert XIRR to CAGR?

A direct conversion does not exist because the two measures answer different questions. To move from XIRR to a CAGR-like figure, one would have to re-express all cash flows as though the entire amount were invested on day one. That changes the underlying data. The safer approach is to use XIRR for irregular cash flows and CAGR for a clean lump-sum. This preserves the XIRR and CAGR Difference rather than forcing equivalence.

Which is better, XIRR or CAGR?

Neither is universally better. For SIPs, step-up investments, or portfolios with dividends and partial exits, XIRR is more faithful because it is money-weighted and date-aware. For a lump-sum investment measured from one start value to one end value, CAGR is simpler and sufficient. In short, XIRR vs CAGR is a context choice, not a superiority contest.

Is XIRR of 12% good?

“Good” depends on risk, product type, and the time period. A 12 percent XIRR in a high-quality bond ladder might be unusual, while a 12 percent XIRR in equities over a volatile phase may be reasonable. Compare the figure with appropriate benchmarks, credit risk, interest-rate exposure, and the horizon. Return without context can mislead.

What does 20% XIRR mean?

It means the sequence of dated cash flows earned the equivalent of 20 percent per annum when solved as a single annualised rate. It does not mean every year delivered 20 percent. Large early inflows during a rally, or late withdrawals during a drawdown, can produce a high number. Always pair the number with the cash-flow timeline and risk.

Disclaimer : Investments in debt securities/ municipal debt securities/ securitised debt instruments are subject to risks including delay and/ or default in payment. Read all the offer related documents carefully.