XIRR vs CAGR vs Absolute Return: What NISM V-A Students Should Know
If you're preparing for the NISM Series V-A exam, there are a few return-related concepts that you really cannot afford to mix up.
Absolute return, CAGR, and XIRR may all look like different ways of answering the same question: "How much did my investment earn?" But they are not the same.
The confusion usually starts when someone sees a mutual fund investment that has been made through multiple SIPs. The return shown by the fund, the return calculated by the investor and the return calculated by a website may all look different.
In this article, let's understand XIRR vs CAGR vs Absolute Return concepts for NISM V-A students. Learn the formulas, key differences, SIP examples, and when to use each return measure.
The NISM Series V-A exam curriculum specifically includes measures of returns under its section on risk, return and fund performance, so understanding these concepts is important for the exam as well as for real-world investor conversations.
First, What Does "Return" Actually Mean?
Suppose you invested ₹1,00,000 and after some time your investment became ₹1,20,000. You made ₹20,000. That's your gain.
But there is one problem: we don't know how long you took to make that ₹20,000.
Did it happen in six months? Two years? Five years? The answer makes a huge difference. That's why we have different ways of measuring returns.
1. What Is Absolute Return?
Let's start with the easiest one.
Absolute return simply tells you how much your investment has gained or lost in percentage terms, without considering the time period.
The formula is: Absolute Return = (Current Value − Initial Investment) ÷ Initial Investment × 100
Example: You invest ₹1,00,000. After some time, it becomes ₹1,20,000.
Your profit is: ₹1,20,000 − ₹1,00,000 = ₹20,000
So: Absolute Return = ₹20,000 ÷ ₹1,00,000 × 100 = 20%
Your absolute return is 20%. Simple. But here's the catch.
Absolute return doesn't tell you how quickly you earned that 20%.
If you earned 20% in one year, that's very different from earning 20% over five years.
That's where CAGR comes in.
2. What Is CAGR?
CAGR stands for Compound Annual Growth Rate.
In simple terms, the CAGR tells you the annualised rate of return on an investment when you have a beginning value, an ending value, and a known investment period.
The formula is: CAGR = [(Final Value ÷ Initial Value)^(1/n) − 1] × 100
Here, n = number of years.
Let's take the same example: You invest ₹1,00,000.
After 5 years, it becomes ₹1,20,000.
Your absolute return is still 20%.
But what is your CAGR? Approximately 3.71% per year.
That's a much more useful number when you're comparing investments held for different periods.
Why?
Because CAGR converts the total growth into an annualised number.
So instead of simply saying: "I made 20%."
You can say: "My investment grew at a CAGR of around 3.71% over five years."
That's a very different story.
3. CAGR Works Best for One-Time Investments
This is something NISM V-A students should remember.
CAGR works neatly when you have: One initial investment → One final value → One investment period
For example: You invest ₹2 lakh in a mutual fund.
After 4 years, your investment becomes ₹3 lakh.
There are no additional investments or withdrawals during those four years.
In such a case, CAGR is a useful way of measuring the annualised return.
But what happens if you invest every month? That's where things get interesting.
4. What Happens With SIPs?
Suppose you start a ₹10,000 monthly SIP.
You invest:
- ₹10,000 in January
- ₹10,000 in February
- ₹10,000 in March
- And so on...
Now, is the entire ₹1.2 lakh invested for one year? No.
The January investment has been there longer than the December investment.
Each instalment has a different investment date.
So applying a simple CAGR calculation to the entire SIP investment isn't appropriate.
This is where XIRR becomes extremely useful.
5. What Is XIRR?
XIRR stands for Extended Internal Rate of Return.
It is commonly used to calculate the annualised return when there are multiple cash flows occurring on different dates.
And that's exactly what happens with SIPs.
You invest money on different dates, and eventually you have a current value or redemption amount.
XIRR takes those different dates into account.
That's the important part.
Think About It This Way
Imagine you invested:
- ₹10,000 on January 10
- ₹10,000 on February 10
- ₹10,000 on March 10
- ₹10,000 on April 10
These four investments have not been invested for the same amount of time.
XIRR considers the actual timing of each cash flow while calculating the annualised return.
That's why it is much more suitable for SIP portfolios.
XIRR vs CAGR: The Easiest Way to Remember
Here's a simple rule: One-time investment → CAGR
Multiple investments/withdrawals on different dates → XIRR
That's not the only possible use of these measures, but it's a very useful rule of thumb for NISM V-A preparation.
6. A Simple SIP Example
Let's say you invest ₹10,000 every month for one year.
Your total investment is: ₹1,20,000
At the end of the year, your portfolio is worth: ₹1,32,000
You might be tempted to calculate:
₹1,32,000 − ₹1,20,000 = ₹12,000 gain
And then: ₹12,000 ÷ ₹1,20,000 = 10%
But saying your return is simply 10% doesn't tell the complete story.
Why? Because your entire ₹1,20,000 was not invested from day one.
Your first ₹10,000 had almost a year to grow.
Your last ₹10,000 may have been invested only for a short period.
XIRR accounts for these different investment dates.
This is why the XIRR of an SIP portfolio can be very different from the simple gain divided by total investment.
7. So Which Return Should You Look At?
It depends on the situation.
| Situation | Useful Return Measure |
| One-time investment | CAGR |
| SIP investment | XIRR |
| Simple gain/loss percentage | Absolute Return |
| Multiple investments and withdrawals | XIRR |
Again, this is a simplified exam-friendly way to remember the concepts.
The important thing is to understand why the measures are different.
8. Absolute Return vs CAGR vs XIRR
Let's put everything together.
Absolute Return
Answers: "How much did my investment gain or lose in total?"
It does not annualise the return.
CAGR
Answers: "What was the annualised growth rate of my investment over this period?"
It is useful when there is a beginning value and an ending value with no intermediate cash flows.
XIRR
Answers: "What annualised return did I earn when my cash flows happened on different dates?"
It is particularly useful for SIPs and portfolios with multiple cash flows.
9. A Quick Example to Make It Stick
Suppose you invest ₹1 lakh and it becomes ₹1.5 lakh after three years.
Absolute Return
You made ₹50,000.
So: Absolute return = 50%
CAGR
The investment grew from ₹1 lakh to ₹1.5 lakh over three years.
CAGR is approximately:
14.47% per year
XIRR
Now imagine instead that you invested the ₹1.5 lakh through multiple SIP installments over those three years.
You can't simply use the same CAGR calculation.
Because each instalment was invested on a different date.
XIRR would be the more appropriate annualised measure.
That's the key difference.
10. Why Does XIRR Matter for Mutual Fund Investors?
For someone investing through SIPs, XIRR gives a more meaningful picture of the portfolio's annualised return because it considers the timing of each investment.
This is particularly useful when an investor asks: "I've invested ₹5 lakh in total. My portfolio is now worth ₹6 lakh. What return have I actually earned?"
The answer isn't necessarily just 20%.
If those ₹5 lakh were invested gradually over several years, the annualised return could be quite different.
That's why investors should understand the difference between total gain and annualised return.
11. Don't Mix Up Return With Profit
This is another common point of confusion.
Suppose your investment is worth ₹2 lakh today and you invested ₹1.5 lakh in total.
Your profit is: ₹50,000
Your absolute return is: 33.33%
But that does not mean you earned 33.33% every year.
The investment period and cash-flow pattern matter.
This is exactly why annualised measures such as CAGR and XIRR exist.
12. What Should You Remember for NISM V-A?
If you're studying for the exam, don't just memorise the formulas.
Try to understand the logic behind them.
Remember these three lines: Absolute Return → Total return over the investment period
CAGR → Annualised return for a single initial investment and final value
XIRR → Annualised return when cash flows happen on different dates
Once you understand this, many questions become much easier.
The NISM V-A syllabus includes return measurement and fund-performance concepts, so these aren't just theoretical definitions. They are part of the broader understanding expected from someone working with mutual fund investors.
Final Takeaway
The easiest way to remember the difference is to ask yourself one question:
"Did I invest all the money at one time, or did I invest it at different points in time?"
If it was a one-time investment, CAGR is usually the relevant annualised measure.
If there were multiple cash flows on different dates, XIRR is generally more appropriate.
And if you simply want to know how much your investment has gained or lost in percentage terms, look at the absolute return.
Once you understand the reason behind these three measures, they stop looking like three confusing formulas and start making sense.
And that's exactly how you should approach NISM V-A preparation—understand the concept first, then remember the formula.
