CAGR
vs
XIRR
Which is Better?
Two numbers. Both claim to measure your returns. But they tell very different stories — and confusing them can seriously mislead your investment decisions.
"My mutual fund shows 18% CAGR but my XIRR is only 11.3%. Which one should I believe?" If you've ever asked this, you're not alone — and the answer reveals a crucial truth about how investment returns are actually measured.
CAGR and XIRR are both measures of investment return, but they are designed for completely different scenarios. Using the wrong metric — or misreading either one — can make a poor investment look spectacular and a great investment look mediocre. This guide explains both from the ground up, with real numbers, and gives you a definitive answer on when to use which.
What is CAGR?
CAGR stands for Compound Annual Growth Rate. It measures how fast a single lump-sum investment has grown from a starting value to an ending value over a specific time period, assuming steady, compounded growth every year.
CAGR gives you a single, smoothed annual growth rate that answers one question: "If my investment grew at the same rate every year, what would that rate be?"
CAGR in Action — A Simple Example
Ravi invests ₹10 lakhs as a lump sum in a mutual fund in January 2021. By January 2026 (5 years later), the investment is worth ₹17.6 lakhs.
This means Ravi's investment grew at an effective rate of 11.96% per year, compounded annually. The actual year-to-year performance may have been +22%, −8%, +15%, +6%, +14% — CAGR smooths all of that into one clean number.
CAGR is perfect for comparing how different lump-sum investments have performed over the same time period. "Fund A gave 14% CAGR, Fund B gave 11% CAGR over 5 years" — this is a fair, apples-to-apples comparison. It is the standard metric used by mutual funds, stock markets, and financial media when reporting historical performance.
The Critical Limitation of CAGR
CAGR assumes a single lump-sum investment at the start and a single redemption at the end. The moment you add multiple cash flows — monthly SIPs, partial withdrawals, additional top-ups, or irregular investments — CAGR becomes mathematically incorrect and misleads you about your real returns.
If you invested ₹10,000/month via SIP for 5 years and your fund's NAV shows "18% CAGR", that 18% applies to a lump sum invested at the fund's inception — not to your actual SIP investments which started at different points in time. Your personal return could be significantly higher or lower depending on when you started and when the market moved.
What is XIRR?
XIRR stands for Extended Internal Rate of Return. It is a financial function (available in Excel, Google Sheets, and calculators) that calculates the annualised return on an investment when there are multiple cash flows at irregular dates.
XIRR answers a different question: "Given all my actual investments and withdrawals on their actual dates, what single annual return rate explains all of it?" This makes XIRR the accurate measure of your personal investment experience, not the fund's theoretical performance.
You don't need to calculate XIRR by hand — it is iteratively solved by software. What matters is understanding what it measures: the time-weighted, date-aware rate of return on all your actual cash flows.
XIRR in Action — Priya's SIP
Priya invested ₹10,000/month via SIP in the same fund as Ravi. But unlike Ravi, she invested monthly from January 2021 to December 2025. By January 2026, her total corpus is ₹8.9 lakhs. Let's see what her XIRR looks like.
| Date | Cash Flow | Type | Cumulative Invested |
|---|---|---|---|
| 01 Jan 2021 | −₹10,000 | SIP Instalment 1 | ₹10,000 |
| 01 Feb 2021 | −₹10,000 | SIP Instalment 2 | ₹20,000 |
| 01 Mar 2021 | −₹10,000 | SIP Instalment 3 | ₹30,000 |
| … (monthly) | −₹10,000 | Continued SIP | … |
| 01 Dec 2025 | −₹10,000 | SIP Instalment 60 | ₹6,00,000 |
| 01 Jan 2026 | +₹8,90,000 | Full Redemption | — |
| Summary | Total Invested: ₹6,00,000 | Maturity: ₹8,90,000 | Gain: ₹2,90,000 | XIRR = ~12.8% | |
The fund returned 18% CAGR — but that applies to a lump sum invested on Day 1. Priya's first ₹10,000 had 5 full years to compound. Her last ₹10,000 had only 1 month. XIRR correctly weights each instalment by its actual time in the market, giving her true personal return of 12.8% — not 18%. Neither number is wrong; they measure different things.
Side-by-Side: The Core Differences
Compound Annual Growth Rate
Measures growth of a single lump-sum investment from start to end. Assumes one entry point and one exit point. Best for evaluating fund or stock performance over time.
Extended Internal Rate of Return
Measures actual return across multiple, dated cash flows. Accounts for when each investment was made. Best for evaluating your personal portfolio return on SIPs, withdrawals, and irregular investments.
| Parameter | CAGR | XIRR |
|---|---|---|
| Number of cash flows | Single (1 in, 1 out) | Multiple (any number) |
| Cash flow timing | Fixed start & end dates | Any irregular dates |
| Best used for | Fund / index performance | Personal SIP / portfolio returns |
| Handles SIPs? | ❌ Not accurately | ✓ Yes, precisely |
| Handles withdrawals? | ❌ No | ✓ Yes |
| Handles top-ups? | ❌ No | ✓ Yes |
| Calculation complexity | Simple formula | Iterative (use calculator) |
| Used in MF fact sheets? | ✓ Yes (fund performance) | ❌ Rarely shown |
| Reflects your actual return? | ❌ Only for lump sum | ✓ Always accurate |
| Affected by investment timing? | ❌ No | ✓ Yes (correctly) |
| Standard in Excel/Sheets? | ✓ (manual formula) | ✓ =XIRR() function |
Instead of wrestling with Excel's XIRR function, use Arthzo's XIRR Calculator to enter your actual SIP dates and amounts, add any withdrawals or lump sums, and instantly see your true annualised return. It handles up to 120+ cash flow entries and handles irregular dates automatically.
The ₹10 Lakh Full Comparison — Same Money, Three Outcomes
Let's use one scenario to show exactly how CAGR and XIRR diverge depending on how you invested the same ₹10 lakhs into the same fund over the same 5-year period.
| Investor | Strategy | Total Invested | Maturity (Jan 2026) | Fund's CAGR | Personal XIRR |
|---|---|---|---|---|---|
| Ravi | Lump sum ₹10L on 01 Jan 2021 | ₹10,00,000 | ₹17,60,000 | 11.96% | 11.96% (identical — lump sum) |
| Priya | SIP ₹8,334/month × 60 months | ₹5,00,040 | ₹7,41,000 | 18.0% (fund's published) | ~12.8% (her actual) |
| Anand | ₹5L lump sum + ₹4,167/mo SIP × 60 | ₹7,50,060 | ₹13,20,000 | 18.0% (fund's published) | ~14.1% (his actual) |
| Sunita | ₹10L lump sum + ₹50,000 partial withdrawal in Yr 3 | ₹9,50,000 (net) | ₹16,85,000 | N/A — cannot use CAGR | ~12.4% (XIRR is the only correct method) |
* Same fund, same 5-year period (Jan 2021–Jan 2026), same published CAGR of 18%. Different personal returns purely because of different investment patterns. XIRR captures the real difference; CAGR cannot.
Why Anand's XIRR (14.1%) is Higher than Priya's (12.8%)
Anand invested ₹5L as lump sum on Day 1, giving a large chunk of capital maximum compounding time. Priya spread everything over monthly SIPs. The lump sum component in Anand's strategy benefited from the full 5-year compounding window, pulling his weighted average return upward. XIRR captures this perfectly — CAGR would just show "18%" for both and obscure the difference entirely.
Head-to-Head Scorecard
Real-Life Profiles — When to Use Which?
Use CAGR When…
- Comparing two mutual funds on the same fact sheet
- Evaluating a single lump-sum FD or bond investment
- Benchmarking a fund vs Nifty 50 / Sensex
- Reading financial news ("Nifty gave 14% CAGR over 10 years")
- Evaluating a business's revenue growth year over year
- Calculating property value appreciation on a single asset
- Understanding how fast an index has grown historically
Use XIRR When…
- Calculating your actual SIP return from a mutual fund
- Measuring returns from a portfolio with multiple purchases
- Evaluating a SWP (systematic withdrawal plan)
- Calculating return on a real estate investment with rental income
- Reviewing your overall personal investment portfolio
- Comparing your portfolio performance to what the fund claims
- Computing returns on any investment with irregular cash flows
Profile 1 — Nisha, 32, Checking if Her SIP is "Actually" Performing
Nisha has been running a ₹15,000/month SIP for 4 years. Her fund's app shows "17.4% CAGR" on the fund page. She assumes she made 17.4% on her money. She did not. Her actual XIRR — calculated from her specific start dates and the current corpus value — is 13.6%. Still excellent, but 3.8 percentage points less than she believed. This gap affects her retirement planning. XIRR gave her the truth CAGR hid.
Use Arthzo's XIRR Calculator to enter your SIP history and find your true return. If your investment portal doesn't show XIRR, this tool does the job in under 60 seconds. Also use Arthzo's SIP Calculator to project what your future corpus will look like at various return rates.
Profile 2 — Mr. Iyer, 58, Evaluating Retirement Income from SWP
Mr. Iyer has ₹30 lakhs invested. He takes a ₹20,000/month SWP withdrawal. Over 7 years, he wants to know: "What annual return am I effectively earning on my money?" CAGR cannot answer this — it ignores his withdrawals. XIRR inputs all 84 monthly withdrawals plus the current portfolio value and gives him a precise annualised return on his entire corpus management. For retirement income planning, XIRR is the only correct metric.
Profile 3 — Kavya, 26, Comparing Two Funds
Kavya is deciding between Fund A (18% CAGR, 5 years) and Fund B (15.5% CAGR, 5 years). She wants to invest a lump sum of ₹3 lakhs. Here, CAGR is exactly the right tool. Both figures are for lump-sum, single-entry investments over the same period, making them directly comparable. Fund A's higher CAGR means it genuinely outperformed for a lump-sum investor.
Comparing a fixed deposit's effective CAGR vs an equity fund's CAGR is a legitimate use of the metric for lump-sum amounts. Use Arthzo's FD Calculator to find your effective annual return, then compare with any fund's published CAGR. Remember: FD CAGR is guaranteed; MF CAGR is historical — past performance is not guaranteed to repeat.
Common Myths — Busted
This is the most widespread and costly misconception. A fund's CAGR reflects the growth of a hypothetical lump sum invested at inception. Your SIP instalments were invested at different times — some early (with more compounding time) and some late (with barely any time in the market). Your actual personal return (XIRR) will almost always be lower than the fund's CAGR for SIP investors, especially if you started the SIP recently.
XIRR was once confined to Excel spreadsheets and required some financial literacy. Today, online calculators make it completely accessible. Any investor who does a SIP should check their XIRR at least once a year. It takes 5 minutes with a calculator and gives you the single most accurate number about your investment's performance. Ignorance of XIRR often means overestimating your returns by 3–6%.
Not always true. XIRR can actually be higher than a fund's CAGR in certain scenarios — for example, if you started your SIP just before a major market rally and invested most of your money at low NAVs. XIRR doesn't inherently deflate returns; it accurately reflects whether your timing worked in your favour or against you. It's precise, not pessimistic.
CAGR is very useful — just for the right purpose. It remains the correct tool for comparing fund performance, evaluating index returns, or calculating lump-sum investment growth. The mistake is applying it to SIPs and irregular portfolios where it structurally cannot give accurate answers. Use both metrics — just know which one fits your question.
Many apps do show XIRR, which is great. However, always double-check what dates and values they use, especially if you've made lump-sum additions, partial withdrawals, or switched between fund plans. Discrepancies in the reference date or unrealised vs realised valuations can skew the figure. An independent XIRR calculator using your actual transaction history is always more reliable than app-generated numbers.
CAGR vs XIRR — By Investment Type
| Investment Type | Correct Metric | Why |
|---|---|---|
| Lump-sum Mutual Fund | CAGR | Single entry, single exit — CAGR is exact |
| Monthly SIP in Mutual Fund | XIRR | 60+ cash flows at different dates — must use XIRR |
| Fixed Deposit (FD) | CAGR | Lump sum → maturity; CAGR = effective annual rate |
| Recurring Deposit (RD) | XIRR | Monthly deposits = multiple cash flows; XIRR is correct |
| PPF (Public Provident Fund) | XIRR | Annual deposits over 15 years at different dates → XIRR |
| SWP (Systematic Withdrawal Plan) | XIRR | Monthly withdrawals = multiple outflows; only XIRR works |
| Sukanya Samriddhi Yojana (SSY) | XIRR | Annual deposits + lump maturity = multiple cash flows |
| Direct Stocks (single buy-sell) | CAGR | One purchase, one sale — CAGR is ideal |
| Direct Stocks (multiple buys) | XIRR | Multiple purchase dates require XIRR |
| Real Estate (rent + sale) | XIRR | Rental income + eventual sale = multiple irregular flows |
| EMI Loan (effective cost check) | XIRR | Monthly outflows over tenure — XIRR gives true cost of borrowing |
| NPS / ULIP | XIRR | Periodic premiums/contributions → XIRR is the correct measure |
PPF and Sukanya Samriddhi Yojana offer tax-free returns, but since you invest annually over 15–21 years, the effective return depends on when each deposit was made. Use Arthzo's PPF Calculator to model your PPF corpus and then plug the cash flows into the XIRR Calculator to compare the true effective return vs an FD or equity SIP. Also see Sukanya Samriddhi Calculator for SSY projections.
Calculate Everything — Arthzo's Free Tools
Whether you're computing your SIP's true XIRR, comparing it to an FD's CAGR, or planning tax on your returns — these free calculators give you the numbers you need in seconds.
Arthzo Financial Calculators
All free · No login required · Instant results
Did you know XIRR can also reveal the true cost of a loan? Enter your EMI outflows as negative cash flows and your loan principal as a positive inflow — XIRR gives you the effective annual interest rate you're paying. Compare this to the bank's stated rate. Use Arthzo's EMI Calculator to break down your loan, then cross-check with the XIRR calculator to verify the bank's advertised rate matches the mathematical reality.
The Verdict — Which is "Better"?
Neither CAGR nor XIRR is universally "better." They answer different questions. CAGR is the right benchmark for evaluating how a fund or index performed for a lump-sum investor. XIRR is the right measure of your actual, personal return on any investment with multiple cash flows.
If you had to remember just one rule: Use CAGR to evaluate the fund. Use XIRR to evaluate yourself.
Know Your True Returns
Don't let fund fact sheets mislead you. Calculate your actual XIRR and compare it to every alternative — all with Arthzo's free calculators.