ZFunds

XIRR vs CAGR vs Absolute Return: What NISM V-A Students Should Know

XIRR vs CAGR vs Absolute Return
Enroll for FREE to Crack NISM VA Exam in 1st Attempt

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.

Get FREE NISM VA Training to Crack NISM Exam

By clicking on button you agree with Privacy Policy and Terms of use

image

Get Updates on WhatsApp and SMS

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.

SituationUseful Return Measure
One-time investmentCAGR
SIP investmentXIRR
Simple gain/loss percentageAbsolute Return
Multiple investments and withdrawalsXIRR

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.

Related Articles :