NISM-Series-V-A: Mutual Fund Distributors · Risk, Return and Performance of Funds

Measuring Returns: Absolute Return, CAGR and XIRR

Updated 11 October 2026 · Fact-checked

Absolute return is the total percentage gain over the holding period, ignoring time. CAGR converts that gain into a steady yearly rate for a lump sum held more than a year. XIRR does the same for investments with several dated cash flows, such as SIPs.

Understand Measuring Returns: Absolute, CAGR and XIRR

A return tells you how much your money grew. But "₹1,00,000 became ₹1,50,000" means little until you know how long it took. Time is what separates the three measures.

Absolute return (also called point-to-point return) is the simple percentage change between the starting value and the ending value. It has no time element. A 50% absolute return over 2 years and over 10 years looks the same, though they are very different results.

Annualised return and CAGR fix this. CAGR (Compound Annual Growth Rate) is the single constant yearly rate that would grow your starting amount to the ending amount, with growth compounding each year. It smooths out ups and downs. Use it for a lump sum held for more than one year. For periods up to one year, returns are generally quoted as absolute (simple) returns, since compounding does not apply.

XIRR (Extended Internal Rate of Return) is for several investments made on different dates, as in a SIP. You cannot apply CAGR to a SIP, because each instalment stays invested for a different length of time. XIRR finds the annual rate that makes the present value of all dated cash flows equal to zero. It is solved by a spreadsheet or calculator, not by hand. In the exam you need to know when to use it and what it means.

In short: absolute return ignores time, CAGR handles one investment over time, and XIRR handles many dated investments over time.

Key formulas to remember

Absolute return: Absolute return (%) = (Ending value − Beginning value) ÷ Beginning value × 100; Ignores time. Ending value includes any income received, if the question says so.
CAGR: CAGR = (Ending value ÷ Beginning value)^(1/n) − 1; n is the number of years. Use for a single lump sum held for more than one year.
Future value from CAGR: Ending value = Beginning value × (1 + CAGR)^n; Rearranged form of the CAGR formula. Useful to check your answer.
Simple annualised return: Annualised return = Absolute return ÷ n; Simple, not compounded. Gives a different number from CAGR for periods over one year.
XIRR: Σ [Cash flow ÷ (1 + XIRR)^(days from first date ÷ 365)] = 0; Investments are negative, redemption value is positive. Solved with software, not by hand.
Rule of 72 (approximation): Years to double ≈ 72 ÷ annual return (%); A rough estimate only, not an exact result.

How to solve Measuring Returns: Absolute, CAGR and XIRR questions

Pick the right measure first. Most marks are lost by using the wrong one, not by arithmetic.

1Read the cash flows. One investment and one redemption means a lump sum. Many dated instalments means SIP or similar.
2Note the holding period and convert it into years. For example, 18 months is 1.5 years.
3For periods up to one year, returns are generally quoted as absolute (simple) returns, so use the absolute return formula. Use it also when the question says absolute or point-to-point.
4If it is a lump sum held for more than one year and the question asks for CAGR or compounded annual return, use the CAGR formula.
5If the question asks for the annualised return of a SIP or any irregular cash flows, the answer is XIRR. Do not use CAGR.
6Calculate step by step. Divide ending by beginning value first, then apply the power, then subtract 1, then convert to percentage.
7Check the answer by compounding it back: beginning value × (1 + CAGR)^n should be close to the ending value.
8Match your result to the options. If two options differ only in method, absolute versus annualised, re-read what the question asked.

Quickest way: Multiple-of-money shortcut

When to use it: Use when the options are far apart and the numbers are round, such as doubling or tripling.

Find the multiple: ending value ÷ beginning value.
If the multiple is 2 and n is 4 years, the rule of 72 gives an approximate CAGR of 72 ÷ 4 = 18%. The exact figure is 2^(1/4) − 1 ≈ 18.9%, so look for an option at about 18-19%. Treat this as an approximation only.
Test each option by compounding: for example 1.1^2 = 1.21, 1.1^3 = 1.331.
For a SIP question, eliminate any option that says CAGR or absolute return, and pick XIRR.
Never do the shortcut when options are close. Then calculate properly.

Common mistakes in Measuring Returns: Absolute, CAGR and XIRR

Using absolute return as if it were a yearly return
The percentage looks like a rate, so students forget the time period.
Fix: Always ask: over how long? Absolute return is for the whole period. Convert to CAGR for a multi-year comparison.
Dividing absolute return by years and calling it CAGR
It feels like the natural way to annualise.
Fix: That gives simple annualised return. CAGR needs the power of 1/n. For periods over a year, simple annualisation overstates the compounded rate.
Applying CAGR to a SIP
Students take total invested and final value and treat it as one lump sum.
Fix: Each SIP instalment is invested for a different time. Use XIRR, which accounts for the date of each cash flow.
Forgetting to subtract 1 after taking the root
The (ending ÷ beginning)^(1/n) result looks like a final answer, e.g. 1.12.
Fix: Subtract 1 to get 0.12, then multiply by 100 for 12%.
Using months as years
The holding period is given as 30 or 36 months.
Fix: Divide months by 12 before using it as n.
Computing the gain on the wrong base
Students divide by the ending value instead of the beginning value.
Fix: The denominator is always the starting value, i.e. the amount you invested.

Worked examples

Example 1

An investor invested ₹2,00,000 in a mutual fund scheme. After 3 years the value was ₹2,50,000 with no other cash flows. What is the CAGR? Options: 7.7%, 8.3%, 12.5%, 25%.

Show the solution

Gain = ₹2,50,000 − ₹2,00,000 = ₹50,000.
Absolute return = 50,000 ÷ 2,00,000 × 100 = 25%. This is the total over 3 years, not a yearly rate.
CAGR: ending ÷ beginning = 2,50,000 ÷ 2,00,000 = 1.25.
Take the cube root of 1.25. Since 1.077^3 ≈ 1.249, the root is about 1.077.
CAGR ≈ 1.077 − 1 = 0.077, which is about 7.7%.
Check the traps: 8.3% is the simple annualised figure (25 ÷ 3), and 1.125^3 ≈ 1.42, so 12.5% is too high.

Answer: CAGR is about 7.7% a year (absolute return is 25% over 3 years).

Example 2

A fund's NAV rose from ₹20 to ₹32.04 over 4 years, with no income distributed. Calculate the CAGR, given that 1.12^4 = 1.5735.

Show the solution

Ending ÷ beginning = 32.04 ÷ 20 = 1.602.
Absolute return = (1.602 − 1) × 100 = 60.2%.
CAGR = 1.602^(1/4) − 1.
Given 1.12^4 = 1.5735, 1.12 gives a slightly lower multiple, so CAGR is a little above 12%.
Try 1.125: 1.125^2 = 1.2656; 1.2656^2 = 1.6018, which matches 1.602.
So the fourth root is 1.125, and CAGR = 12.5%.

Answer: CAGR is 12.5% a year, against an absolute return of 60.2% over 4 years.

Exam tips

Read the keyword in the question: absolute, point-to-point, annualised, CAGR or XIRR. It decides the formula.
Be ready for questions on which measure suits a SIP. The answer is XIRR.
Watch for distractor options that equal absolute return divided by years. They are traps for CAGR questions.
Check the units of time. Months must become years before you use the formula.
With 100 questions and no negative marking in this paper, never leave a numerical blank. Eliminate options and guess if you must.

Practice questions from Risk, Return and Performance of Funds

Measuring Returns: Absolute, CAGR and XIRR: frequently asked questions

What is the difference between absolute return and CAGR?

Absolute return is the total percentage gain over the whole holding period and ignores time. CAGR is the constant yearly compounded rate that gives the same final value. Use CAGR to compare investments held for different periods.

How do I calculate CAGR for a mutual fund?

Divide the ending value by the beginning value, raise it to the power of 1/n where n is years, then subtract 1. Multiply by 100 for a percentage. This works for a single lump sum without other cash flows.

Why is XIRR used for SIP returns?

A SIP has many instalments on different dates, so each amount stays invested for a different time. XIRR takes the exact date of every cash flow and finds the annual rate that fits them all. CAGR cannot do this.

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

XIRR is normally solved with a spreadsheet, since it needs an iterative method. So know its concept and use: when it is appropriate and what it represents. CAGR and absolute return can be worked out by hand, so practise them.