What is XIRR and How is it Different from CAGR?
When reviewing your investment portfolio, you will encounter various metrics to describe how your wealth has grown. The two most common performance metrics are Compound Annual Growth Rate (CAGR) and Extended Internal Rate of Return (XIRR).
At first glance, both appear to represent your annualized rate of return. However, using the wrong metric can distort your understanding of how well an investment has performed. While CAGR is excellent for one-time investments, XIRR is the gold standard for portfolios with recurring cash flows, such as monthly SIPs, lump-sum additions, or periodic withdrawals.
This guide explains the difference between CAGR and XIRR, walks through the underlying math, and helps you choose the right metric for your calculations.
1. What is CAGR? (The Single-Cash-Flow Metric)
Compound Annual Growth Rate (CAGR) is the smoothed rate of return at which an investment would have grown if it had compounded at a steady rate each year from the start date to the end date.
CAGR is a point-to-point metric. It only requires three inputs:
- The starting value of the investment
- The ending value of the investment
- The total time horizon in years
Formula:
When to Use CAGR:
CAGR is perfect for evaluating:
- A bank Fixed Deposit (FD) where you invest a lump sum on Day 1 and withdraw it on maturity.
- Gold purchased years ago and valued today.
- A single stock purchase held without adding more shares over time.
2. What is XIRR? (The Multi-Cash-Flow Metric)
In real life, portfolio management is rarely point-to-point. You might start a monthly Systematic Investment Plan (SIP). You might add a lump sum to your mutual fund during a market dip. You might receive dividends or withdraw partial sums for emergencies.
Each transaction happens on a different date, which means different portions of your capital compound for different lengths of time.
Extended Internal Rate of Return (XIRR) accounts for this. It calculates the single annualized rate of return that satisfies the Net Present Value (NPV) equation for all cash inflows and outflows, matching each transaction to its exact date.
The Equation:
To calculate XIRR, financial software runs iterative trials to find the rate r that satisfies this equation:
Where:
- Ct = The cash flow amount at time t (negative for investments/outflows, positive for withdrawals/valuation).
- dt = The transaction date.
- d0 = The start date of the first investment.
- r = The XIRR rate we are solving for.
3. CAGR vs. XIRR: A Practical Example
Let’s look at a scenario where CAGR and XIRR tell different stories.
Suppose you invest ₹12,000 in an equity mutual fund.
Scenario 1: Lump Sum (CAGR is appropriate)
You invest the entire ₹12,000 on January 1, 2025. On January 1, 2026, the investment is worth ₹13,200.
- CAGR Calculation:
(13,200 / 12,000) - 1= 10.00% - XIRR Calculation: Solving the cash flow dates yields 10.00%
In a single lump-sum scenario, CAGR and XIRR are identical.
Scenario 2: Monthly SIP (XIRR is mandatory)
Instead of investing all at once, you invest ₹1,000 on the first day of every month from January 1, 2025, to December 1, 2025 (total ₹12,000 invested). On January 1, 2026, the portfolio is worth ₹13,200.
If you mistakenly run the point-to-point CAGR formula (treating it as starting with ₹12,000 and ending with ₹13,200 after 1 year), you get 10.00%.
But this is incorrect! You did not have ₹12,000 working for you the whole year. Your first ₹1,000 was invested for 12 months, but your last ₹1,000 was invested for only 1 month. The average holding period of your money was only 6 months.
Solving this monthly schedule with XIRR:
- XIRR Result: ~18.9%
The actual annualized performance of your cash was 18.9%, because the fund had to compound your money much faster to reach ₹13,200 since most of it was invested for less than a year. The CAGR calculation severely understated your fund’s performance.
To see these two methods compared in action, run simulations using our SIP vs. Lump Sum Calculator or contrast multi-asset growth paths with the SIP vs. PPF vs. FD Calculator.
4. Key Differences Summary
| Feature | CAGR | XIRR |
|---|---|---|
| Number of Transactions | Exactly 2 (Start & End) | Multiple (Unlimited cash flows) |
| Transaction Dates | Only requires total years | Requires exact dates for each cash flow |
| Calculation Complexity | Simple algebraic formula | Solved numerically via trial-and-error |
| Handling of Withdrawals | Cannot handle | Handles partial redemptions easily |
| Best Used For | FDs, Gold, single stock holdings | Mutual fund portfolios, SIPs, stock trading |
5. How to Choose
- Choose CAGR when you want to compare the overall performance of one-time deposits or assets over long horizons.
- Choose XIRR when you are calculating your actual personal investment return, taking into account the dates you added money to your mutual funds, paid taxes, or withdrew capital. Most investment platforms display your personal portfolio returns as XIRR for this exact reason.