XIRR vs CAGR: Which Mutual Fund Return Actually Matters

Open two mutual fund apps and you might see two different "return" numbers for the same fund, on the same day. One shows 14% CAGR, the other shows 11% XIRR. Neither number is wrong, they're just answering different questions. The XIRR vs CAGR distinction decides which one tells you the truth about your investment.

Use CAGR for a single lump-sum investment held between two fixed dates. Use XIRR for SIPs, partial withdrawals, or anything with money moving in or out on multiple dates.

What is CAGR and when does it actually work?

CAGR (Compound Annual Growth Rate) measures the annualized growth rate of a single investment between a start date and an end date, assuming the money went in once and stayed untouched. The formula is (Ending Value ÷ Starting Value)^(1/n) − 1, where n is the number of years.

Say you invested ₹1,00,000 as a lump sum and it grew to ₹1,80,000 in 5 years. CAGR works out to roughly 12.47% per year. That number is accurate because there's only one cash flow at the start and one value at the end. CAGR also works for comparing a fund's historical performance over a fixed period, even if you personally invested differently.

What is XIRR and how is it different from CAGR?

XIRR (Extended Internal Rate of Return) calculates an annualized return for a series of cash flows that happen on different dates and in different amounts, like monthly SIP instalments, lump-sum top-ups, or partial redemptions. It accounts for the exact date and size of every transaction, not just a single start and end value.

CAGR can't do this. It has no way to factor in that your March instalment had 9 fewer months to grow than your January one. XIRR solves for the single annualized rate that makes the present value of all your inflows and outflows equal zero, which is why it needs specialized software or a spreadsheet function rather than a simple formula you can do by hand.

XIRR vs CAGR: what's the real difference?

The core difference is cash flow structure: CAGR assumes one investment date and one valuation date, while XIRR handles multiple investment dates with varying amounts.

Why does CAGR give a misleading number for SIP returns?

CAGR misleads on SIP returns because it can only compare a single starting value to a single ending value, while a SIP involves dozens of separate instalments each compounding for a different length of time. Applying CAGR to a SIP usually means dividing total invested amount by total current value as if it were one lump sum, which distorts the real annualized rate.

If you've been investing ₹10,000 a month for 3 years, your first instalment has had 36 months to grow, but your most recent one has had barely a month. A CAGR calculation that treats this as one block of money invested on day one will understate or overstate your actual return depending on how the fund moved during that period. XIRR weighs each instalment by its own holding period, which is the only way to get an honest number for a SIP.

How do you calculate XIRR in Excel or Google Sheets?

You calculate XIRR by listing every cash flow with its date in two adjacent columns and applying the built-in XIRR function. The syntax is =XIRR(values, dates), where values are negative for money you put in and positive for the current value or any withdrawal.

1. In column A, enter each amount invested as a negative number (for example, -10000 for each SIP instalment). 2. In the last row of column A, enter the current value of your investment as a positive number. 3. In column B, enter the exact date for each of those cash flows. 4. In an empty cell, type =XIRR(A1:A37, B1:B37) and press enter. 5. Format the result as a percentage. That's your annualized XIRR.

The formula needs at least one negative and one positive value to solve correctly, and dates should be in actual date format, not text.

Is a higher XIRR always better?

A higher XIRR doesn't automatically mean a better fund or a better decision, because XIRR is sensitive to when your specific cash flows happened, not just how the fund performed overall. Two investors in the identical fund can see noticeably different XIRR figures depending on their instalment dates.

A SIP that happens to catch a sharp market dip in its final few months can show an inflated short-term XIRR, even if the fund's longer-term CAGR is unremarkable. Before reading too much into a high XIRR, check it against the fund's category average CAGR over the same period, and look at whether the figure is being measured over a long enough window to mean anything. A 6-month XIRR tells you almost nothing about a fund's long-term reliability.

Frequently asked questions

What is the difference between XIRR and CAGR? CAGR measures the annualized growth between two points for a single, untouched investment, while XIRR calculates the annualized return for a series of cash flows happening on different dates, like a SIP. Both express return as a yearly percentage, but they're built for different investment patterns.

Can I use CAGR to calculate SIP returns? No, CAGR cannot accurately measure SIP returns because it assumes a single investment date and a single withdrawal date, while a SIP involves multiple investments spread across many dates. Use XIRR instead for any investment with more than one cash flow.

How do I calculate XIRR in Excel? List every cash flow as a negative number for money invested and a positive number for the current value, list the matching dates next to them, then use the formula =XIRR(values range, dates range) in an empty cell. Format the result as a percentage to read your annualized return.

Is XIRR the same as annualized return? Yes, XIRR is a type of annualized return, specifically one designed for investments with multiple cash flows on different dates, unlike a simple annualized return formula that assumes one lump sum. It's the standard way to measure SIP and STP performance.

Can XIRR be negative? Yes, XIRR can be negative if the current value of your investment is lower than the total amount you put in, after accounting for the timing of each instalment. A negative XIRR signals an actual loss on an annualized basis, not just a temporary dip.

Where can I check my mutual fund's XIRR? Most mutual fund apps, registrar platforms like CAMS and KFintech, and portfolio trackers display XIRR automatically for SIP and STP investments under the returns or performance section. You don't need to calculate it manually unless you're cross-checking the figure shown.

Does a higher XIRR always mean a better fund? Not necessarily, because XIRR is sensitive to the timing of your specific cash flows, so two investors in the same fund can see different XIRR figures depending on when they invested. Compare your XIRR against the fund's category average CAGR over the same period before drawing conclusions.

Picking the right metric is step one. Knowing what to do with the answer, whether that means staying invested, rebalancing, or rethinking your asset allocation, is a separate conversation. If you'd like a second pair of eyes on your portfolio's actual numbers, you can reach Pi Delta at https://pidelta.in/contact/.

At Pi Delta, every engagement begins with understanding your situation — goals, constraints, and existing investments — before any recommendation is made. We are a SEBI-registered Investment Adviser (INA000020721) and AMFI-registered Mutual Fund Distributor (ARN 346875).

Schedule a 20-minute clarity call — no obligation.

Prakhar Soni, CFA | CIPM | FRM | Founder, Pi Delta