“My CAGR Is 12%”
A friend recently messaged me after reading my article on CAGR.
“My CAGR is 12%. That’s pretty good, right? Or am I getting crushed by inflation?”
My reply (You guessed it) “IT DEPENDS”
There was a brief pause before I asked him another question.
“Did you invest all your money on day one?”
“No, I invest every month.”
Suddenly, we weren’t talking about CAGR anymore.
We were talking about XIRR.
If you’ve been investing regularly through SIPs, making additional contributions over time, or occasionally withdrawing money from your portfolio, CAGR can actually paint an incomplete picture of your investment performance.
That’s where XIRR comes in.
What Is XIRR?
XIRR stands for Extended Internal Rate of Return.
It measures the annualized return of investments that involve multiple cash flows occurring on different dates.
Annualized returns become much more meaningful when you know how quickly they can double your money. If you’re curious, my guide on the Rule of 72 explains a simple shortcut that lets you estimate doubling time in your head.
Unlike CAGR, which assumes you invested once and sold once, XIRR recognises that real life isn’t that simple.
Perhaps you:
- Invest every month.
- Add extra money when markets fall.
- Withdraw cash occasionally.
- Receive dividends and reinvest them.
Every one of those cash flows changes your actual return.
XIRR accounts for all of them.
Why CAGR Isn’t Always Enough
Let’s imagine two investors.
Investor A
Invests:
- $10,000
Leaves it untouched for ten years.
Simple.
CAGR works perfectly.
Investor B
Invests:
- $500 every month
- Adds another $5,000 during the 2022 tech sell-off
- Makes a withdrawal three years later
By the end of ten years, the portfolio reaches exactly the same value as Investor A’s.
Would both investors have earned the same return?
Not necessarily.
Investor B invested different amounts at different times.
Some money had more time to compound than others.
That’s the key idea behind investing—time matters just as much as returns. If you’d like a deeper understanding of why money grows faster the longer it’s invested, I’d recommend reading How Compounding Actually Works.
CAGR simply isn’t designed for situations like this.
XIRR is.
Think Of It Like Baking
Imagine baking two identical cakes.
Both weigh exactly one kilogram.
But one took one hour.
The other took four.
Looking only at the final weight tells you nothing about the process.
Investment returns work the same way.
The ending value matters.
But when money entered and left the investment matters just as much.
XIRR measures both.
When Should You Use XIRR?
XIRR is ideal when your investment includes multiple transactions.
Examples include:
- SIP investments
- Retirement accounts
- Mutual funds
- Real estate investments
- Private businesses
- Portfolios with additional deposits
- Portfolios with withdrawals
If money moved in or out during the investment period, XIRR is usually the better metric.
Imagine the following investment journey:
| Date | Cash Flow |
|---|---|
| January 2020 | -$10,000 |
| July 2020 | -$2,500 |
| March 2021 | -$3,000 |
| October 2022 | +$1,500 (Partial Withdrawal) |
| Today | $22,000 (Current Value) |
Calculating your return manually would be extremely difficult because every investment was made at a different point in time.
This is exactly the kind of situation where XIRR shines. It considers both the amount and the timing of every cash flow, giving you a much more accurate annualized return than CAGR (Which opens up the age-old debate of SIP vs Lump Sum Investing, but that’s a story for another day).
When Is CAGR Better?
Despite everything I’ve said…
CAGR hasn’t suddenly become useless.
In fact, it’s still the perfect choice when:
- You invest once.
- You don’t add more money.
- You don’t withdraw anything.
- You simply want to know how fast your investment grew each year.
Think of it this way.
CAGR is simpler.
XIRR is smarter.
Neither metric is “better.” They simply answer different questions. Choosing the wrong one is like using a ruler to measure temperature..it isn’t that the tool is bad, it’s just the wrong tool for the job.
If your investment involved a single lump-sum investment with no additional contributions or withdrawals, you don’t need XIRR. if your journey was that simple, you can just plug your numbers into a standard CAGR Calculator and call it a day.
XIRR vs CAGR
Here’s the simplest way to remember the difference.
| Feature | CAGR | XIRR |
|---|---|---|
| Initial investment | One | Multiple |
| Additional deposits | ❌ | ✅ |
| Withdrawals | ❌ | ✅ |
| Cash flow timing | ❌ | ✅ |
| Calculation Difficulty? | Simple Math | Complex / Requires Excel |
| Best for… | Lump-sum Investments | SIPs & Active Portfolios |
Whenever someone asks me which metric is “better”, my answer is always the same.
Neither.
Use the one that matches your investment journey.
Why Professional Investors Prefer XIRR
Many investment platforms display XIRR instead of CAGR. 📖 HSBC Asset Management
That’s because very few investors simply buy once and never invest again.
Most people:
- Invest every month.
- Increase contributions after salary raises.
- Buy more during market corrections.
- Occasionally withdraw funds.
XIRR captures all of those decisions.
That’s why it’s widely used by mutual fund companies, portfolio trackers and financial advisors.
Is XIRR Hard To Calculate?
Fortunately…
No.
The formula behind XIRR is significantly more complicated than CAGR.
It uses an iterative mathematical method to determine the annualized return that accurately reflects every cash flow.
Thankfully, you don’t need to solve it yourself.
Spreadsheet software such as Microsoft Excel and Google Sheets can calculate XIRR automatically, and many investment platforms now display it as a standard performance metric.
Limitations Of XIRR
Like every financial metric, XIRR isn’t perfect.
It relies entirely on accurate cash flow data.
If you forget to include a deposit, withdrawal or dividend payment, your result won’t reflect reality.
It also focuses solely on returns.
It doesn’t tell you:
- How much risk you took.
- How volatile the investment was.
- Whether the investment outperformed inflation.
- Whether another investment achieved similar returns with less risk.
XIRR should therefore be viewed as one important metric—not the only one.
Final Thoughts
If CAGR taught us to ask:
“How fast did my investment grow each year?”
Then XIRR teaches us another important lesson.
“When did I actually invest my money?”
Those two questions sound similar.
They’re not.
One assumes your investment journey was simple.
The other recognises how people actually invest.
If you’ve been investing regularly through SIPs, adding money over time or making withdrawals, XIRR will usually give you a much more realistic picture of your investment performance.
Once you’ve calculated your historical return using XIRR, the next logical question becomes: “What could my investments be worth in the future?” That’s exactly what my Investment Calculator helps you estimate using your expected annual return and future contributions.
And that’s exactly why serious investors understand both.
Not because one is better than the other.
But because each answers a different question.
Professional Perspective
Investment professionals don’t rely on a single performance metric. CAGR is useful for evaluating one-time investments, while XIRR is better suited to investments with multiple cash flows. Understanding when to use each metric is often more valuable than memorizing either formula. This distinction is reflected in professional investment performance guidance and industry practice.
Continue Exploring
Interested in learning more about investing?
You may also find these resources useful:
- 📈 Investment Calculator
- 📊 CAGR Calculator
- ⏳ Rule of 72 Explained
- 💰 How Compounding Actually Works
- 🧮 Explore all Finance Tools
