“My mutual fund has given me 14% CAGR.”
Sounds good, right?
But before celebrating that number, there is one simple question I would ask:
Did you invest ₹1 lakh at one time, or have you been investing through SIPs?
Because that small detail makes a big difference.
If you invested a lump sum and left it untouched, CAGR is usually the right way to measure your return.
But if you have been investing every month through an SIP, making additional investments, or withdrawing money along the way, XIRR is generally the more meaningful number.
And this is where many mutual fund investors get confused.
Let’s make it simple.
First, what exactly is CAGR?
CAGR stands for Compound Annual Growth Rate.
In simple language, it tells you how much your investment has grown annually, on a compounded basis, assuming you invested once and stayed invested throughout the period.
For example, suppose you invest:
₹1,00,000
Five years later, it becomes:
₹1,76,000
Your CAGR would be approximately 12%.
Pretty straightforward.
You put money in once, waited five years, and checked what it became.
CAGR works well because there is only one investment date and one final value.
The basic formula is:
CAGR = (Final Value / Initial Investment)^(1 / Number of Years) − 1
So, CAGR essentially answers:
“How fast did my one-time investment grow every year?”
But what happens when you invest through SIP?
This is where things change.
Suppose you invest ₹10,000 every month for five years.
Your total investment would be:
₹6,00,000
But here’s the important part:
You didn’t invest the entire ₹6 lakh on day one.
Your first ₹10,000 has been invested for almost five years.
Your next ₹10,000 has been invested for slightly less.
And your latest ₹10,000 may have been invested for only a few weeks or months.
So every SIP instalment has had a different amount of time in the market.
That’s why simply applying CAGR to the entire ₹6 lakh doesn’t tell you the return you actually earned on your money.
This is where XIRR becomes useful.
So, what is XIRR?
XIRR stands for Extended Internal Rate of Return.
Don’t let the complicated name put you off.
The concept is actually quite simple.
XIRR calculates your annualised return while taking into account when each investment or withdrawal actually happened.
It considers things like:
- How much did you invest
- The date of each investment
- Additional investments
- Withdrawals or redemptions
- The date of each withdrawal
- The current value of your investment
In other words, XIRR looks at your actual cash flows.
And that’s exactly what you need when you have been investing through SIPs.
Here’s the easiest way to remember CAGR vs XIRR
Think about two investors.
Investor A
Invests ₹1 lakh once and doesn’t touch it for five years.
For Investor A:
👉 CAGR makes sense.
Investor B
Invests ₹10,000 every month for five years.
For Investor B:
👉 XIRR makes more sense.
Why?
Because Investor B has made 60 different investments on 60 different dates.
Each instalment has had a different journey in the market.
Why your SIP return can be different from the fund’s CAGR
This is another point that often confuses investors.
You may visit a mutual fund’s website and see something like:
5-Year Return: 14% CAGR
Then you check your own portfolio and find that your XIRR is, say, 11.8%.
You may wonder:
“Why is my return lower than the fund’s return?”
There could be several reasons.
The fund’s CAGR generally measures the performance of its NAV over a specified period.
Your XIRR measures the performance of your actual money, based on when you invested.
And those two things aren’t necessarily the same.
For example, imagine two people investing in exactly the same mutual fund.
One investor starts an SIP during a market correction.
The other starts after the market has already gone up substantially.
Same fund.
Same SIP amount.
But different investment dates.
Their actual XIRRs can therefore be different.
This is why looking only at the fund’s headline CAGR doesn’t always tell you how well your own investment has performed.
XIRR isn’t only for SIPs
This is worth remembering.
XIRR is useful whenever you have multiple cash flows at different times.
For example:
Additional investments
You start with ₹2 lakh and add another ₹1 lakh after a year.
STP
You move money from one scheme to another in multiple instalments.
SWP
You regularly withdraw money from your investment.
Partial redemptions
You invest, withdraw some money, and keep the rest invested.
In all these situations, there isn’t one simple investment date.
That’s why XIRR becomes more appropriate.
CAGR vs XIRR: A simple comparison
| Your investment situation | Better return measure |
|---|---|
| One-time lump sum | CAGR |
| SIP | XIRR |
| Multiple lump-sum investments | XIRR |
| Additional investments | XIRR |
| STP | XIRR |
| SWP | XIRR |
| Multiple withdrawals | XIRR |
| Multiple purchases and redemptions | XIRR |
The easiest rule is:
One investment → CAGR
Multiple cash flows → XIRR
Remember that, and you’ll avoid one of the most common return-calculation mistakes.
You don’t need to calculate XIRR manually
The good news is that you don’t need to sit with a calculator and do complicated mathematics.
Excel and Google Sheets both have an XIRR function.
You simply enter:
- Investment amount
- Investment date
- Withdrawal amount, if any
- Withdrawal date
- Current investment value
- Current valuation date
The formula then calculates the annualised return based on the timing of those cash flows.
Most investment platforms also provide XIRR for SIP portfolios automatically.
So which number should you actually look at?
The answer depends on what you are trying to measure.
If you’re asking:
“How has this mutual fund performed over the last five years?”
CAGR can be useful.
But if you’re asking:
“How much has my SIP investment actually earned?”
Look at your XIRR.
That’s the important distinction.
Don’t compare your SIP with a fund’s CAGR blindly
This is probably the biggest takeaway from this entire discussion.
Suppose a mutual fund shows:
3-Year CAGR: 15%
And your SIP shows:
XIRR: 12.5%
It doesn’t automatically mean something is wrong.
The two numbers are measuring different things.
The fund’s CAGR is looking at the fund’s performance over a particular period.
Your XIRR is looking at the performance of your individual cash flows.
Your investment dates matter.
Your SIP start date matters.
Your additional investments matter.
Your withdrawals matter.
Even the timing of a major market correction can affect your personal XIRR.
So don’t compare these numbers without understanding what they represent.
The simplest way to remember it
Here’s the rule I would keep in mind:
One-time investment? Think CAGR.
Regular or multiple investments? Think XIRR.
Withdrawals involved? Think XIRR.
That’s it.
You don’t need to memorise complicated formulas.
Just ask yourself:
“Did all my money go in on the same day?”
If the answer is yes, CAGR may be appropriate.
If the answer is no, because you invested or withdrew money at different times, XIRR is generally the better measure of your personal annualised return.
The real question isn’t “What return did the fund give?”
As investors, we often focus on the headline number.
“This fund gave 15%.”
“That fund gave 18%.”
But there’s a more important question:
“What return did my money actually earn?”
That depends not only on which fund you chose, but also on when and how you invested.
A good mutual fund can generate strong returns, but your personal experience can be different depending on your investment timing.
That’s why understanding CAGR and XIRR is more than just knowing two financial terms.
It helps you understand your own investment journey.
The bottom line
CAGR and XIRR aren’t competing methods.
They simply answer different questions.
CAGR is useful for measuring the compounded annual growth of a single lump-sum investment.
XIRR is generally more appropriate for measuring the annualised return of an investment with multiple cash flows — such as SIPs, additional investments, STPs, SWPs and withdrawals.
So the next time someone tells you:
“My mutual fund gave 14% CAGR.”
Don’t just ask which fund.
Ask:
“Was it a lump-sum investment or a SIP?”
Because that one answer tells you whether CAGR is even the right number to look at.
And if you’re investing regularly through SIPs, remember:
Don’t just look at the fund’s return. Look at your own XIRR.
Because ultimately, what matters isn’t only how the fund performed.
What matters is how your money performed.
One-line takeaway
Lump sum → CAGR | SIP & multiple cash flows → XIRR
Understanding this simple difference can help you evaluate your mutual fund investments more accurately and make better-informed financial decisions.
Did you know the difference between CAGR and XIRR before reading this? Share your thoughts in the comments.
If you’d like to understand how mutual funds and SIPs can fit into your long-term financial goals, feel free to connect with me.
Disclaimer: Mutual Fund Investments are subject to market risks. Read all scheme-related documents carefully before investing. This article is for educational purposes only and should not be considered investment advice.
