Skip to content

NISM-Series-V-A: Mutual Fund Distributors · Mutual Fund Scheme Performance

Absolute Return, CAGR and XIRR for Mutual Funds

Updated 11 October 2026 · Fact-checked

Absolute return is the total percentage gain over the whole period, ignoring time. CAGR converts that gain into a smooth yearly compounded rate for a single investment. XIRR gives an annualised rate when cash flows happen on different dates, as in a SIP. Use the one that matches the cash flows.

Understand Measures of Return: Absolute, CAGR and XIRR

Return tells you how much an investment has grown. The three measures differ in how they treat time and cash flows.

Absolute return is the simple percentage change from start to end. It says nothing about how long the money was invested. A 50% gain in 2 years and a 50% gain in 10 years look identical, but they are very different results.

CAGR (Compound Annual Growth Rate) fixes this. It gives the constant yearly rate at which the money would have grown, with compounding, to reach the final value. Use it for a single lump sum with one investment and one end value. Returns held for less than a year are usually shown as absolute return; longer periods are annualised.

XIRR (Extended Internal Rate of Return) handles several investments on different dates, such as a monthly SIP, plus withdrawals. It finds the single annual rate that makes the present value of all outflows and inflows equal to zero. It cannot be solved by a simple formula, so in practice you use a spreadsheet or calculator. In the exam you must know when to use it and what it means.

The key point: CAGR of a SIP is misleading, because each instalment is invested for a different length of time. XIRR is the right measure for a SIP.

Key formulas to remember

Absolute return
Absolute return (%) = (Final value − Initial value) ÷ Initial value × 100
Ignores time. Suitable for periods up to one year.
CAGR
CAGR = (Final value ÷ Initial value)^(1/n) − 1
n is the number of years. Only for a single investment with no interim cash flows.
Future value check
Final value = Initial value × (1 + CAGR)^n
Use it to test which option is correct by working forward.
Annualising a short-period return (simple)
Annualised return = Return for the period × (365 ÷ number of days)
Simple annualisation, no compounding. Use only if the question says so.
XIRR condition
Σ [Cash flow ÷ (1 + XIRR)^(days from first date ÷ 365)] = 0
Investments are negative, redemption or current value is positive. Solved by trial or software.
Rule of 72 (approximation)
Years to double ≈ 72 ÷ annual rate (%)
A rough guide only, not exact.

How to solve Measures of Return: Absolute, CAGR and XIRR questions

Pick the measure first, then compute. Most errors come from choosing the wrong measure or the wrong n.

  1. 1Read the cash flows. One investment and one end value means absolute return or CAGR. Many instalments on different dates means XIRR.
  2. 2Check the period. If it is one year or less, absolute return is normally what is asked. Above one year, annualise with CAGR.
  3. 3Write down initial value, final value and n in years. Convert months to years (18 months = 1.5 years).
  4. 4For absolute return, compute (final − initial) ÷ initial × 100.
  5. 5For CAGR, compute final ÷ initial, raise it to 1/n, subtract 1, then convert to a percentage.
  6. 6If the question gives options, test them with Initial × (1 + r)^n instead of solving the root.
  7. 7For a SIP, do not compute CAGR on total invested. State that XIRR is appropriate, or compare given XIRR values.
  8. 8Check that the answer is sensible: CAGR must be lower than absolute return when n is more than 1 and the gain is positive.

Quickest way: Test the options by compounding

When to use it: When a CAGR question gives four rates and n is a small whole number such as 2 or 3.

  1. Compute the ratio final ÷ initial.
  2. Take each option rate and compound it for n years, using (1 + r)^n.
  3. Pick the option whose result matches the ratio.
  4. For doubling-type questions, use 72 ÷ rate to eliminate options quickly.
  5. If the question mentions SIP with dates, skip the arithmetic and choose XIRR.

Common mistakes in Measures of Return: Absolute, CAGR and XIRR

  • Using CAGR for a SIP

    Students see an initial amount and a final value and apply the formula directly.

    Fix: Instalments are invested for different durations. Use XIRR for any series of dated cash flows.

  • Treating absolute return as an annual rate

    The percentage looks like a yearly figure.

    Fix: Absolute return covers the whole period. Annualise it with CAGR if the period is more than a year.

  • Dividing absolute return by n to get CAGR

    It feels like an average per year.

    Fix: CAGR uses compounding. Take the n-th root of final ÷ initial, then subtract 1.

  • Forgetting to subtract 1 at the end

    Students stop after computing the root, for example 1.21^(1/2) = 1.10.

    Fix: The root gives the growth factor. Subtract 1 to get the rate, so 1.10 means 10%.

  • Wrong n for months

    Students plug 18 or 30 straight in as n.

    Fix: Convert to years first: 18 months is 1.5 years, 30 months is 2.5 years.

  • Dividing the gain by final value

    Confusion over the base of the percentage.

    Fix: The base is always the initial value (the amount invested).

Worked examples

Example 1

An investor puts ₹1,00,000 in a scheme. After 3 years the value is ₹1,33,100. What are the absolute return and the CAGR?

Show the solution
  1. Gain = 1,33,100 − 1,00,000 = ₹33,100.
  2. Absolute return = 33,100 ÷ 1,00,000 × 100 = 33.1%.
  3. Ratio = 1,33,100 ÷ 1,00,000 = 1.331.
  4. 1.331 = 1.1 × 1.1 × 1.1, so the cube root is 1.1.
  5. CAGR = 1.1 − 1 = 0.10 = 10% a year.

Answer: Absolute return is 33.1% and CAGR is 10% per year.

Example 2

A lump sum of ₹50,000 grows to ₹72,000 in 2 years. Which is closest to the CAGR? (a) 12% (b) 20% (c) 22% (d) 44%

Show the solution
  1. Ratio = 72,000 ÷ 50,000 = 1.44.
  2. Absolute return = 44%, so (d) is the absolute return, a trap.
  3. Test 20%: 1.2 × 1.2 = 1.44, which matches.
  4. Check 12%: 1.12 × 1.12 = 1.2544, too low. 22%: 1.22 × 1.22 = 1.4884, too high.
  5. So CAGR = 20%.

Answer: (b) 20%

Exam tips

  • Look for the trap option equal to the absolute return when a CAGR question is asked.
  • If the question mentions monthly instalments or several dates, the intended answer is XIRR, not CAGR.
  • Convert months to years before using n.
  • V-A has no negative marking, so always attempt every question, but still eliminate options by compounding.
  • Remember the definitions: CAGR for one investment, XIRR for irregular or periodic cash flows.

Practice questions from Mutual Fund Scheme Performance

Measures of Return: Absolute, CAGR and XIRR: frequently asked questions

What is the difference between CAGR and absolute return?

Absolute return is the total percentage gain over the whole period and ignores time. CAGR converts that gain into a compounded yearly rate. Use CAGR to compare investments held for different periods.

Why is XIRR used for SIP returns?

A SIP has many instalments on different dates, so each is invested for a different time. XIRR weighs every cash flow by its date and gives one annualised rate. CAGR cannot do this.

What is the difference between CAGR and XIRR?

CAGR works for a single investment with one start value and one end value. XIRR works for multiple dated cash flows, including SIPs and part withdrawals. If there is only one investment and one redemption, both give the same answer.

Do I need to calculate XIRR by hand in the exam?

Not usually. Expect questions on when to use XIRR and what it means, and simple CAGR or absolute return calculations. Practise testing options by compounding.