Topic 1 of 8~5 min read

Measuring Returns — CAGR, Absolute, XIRR, Rolling Returns

Definition

Return measurement is the process of quantifying the gain or loss generated by an investment over a specified period, expressed as a percentage of the original investment. Different methods — absolute return, CAGR (Compound Annual Growth Rate), XIRR (Extended Internal Rate of Return), and rolling returns — serve different purposes depending on the investment tenure, cash flow pattern, and the analytical objective. Absolute return measures the simple total percentage gain. CAGR smooths out volatility to show an annualized compounded growth rate. XIRR handles irregular cash flows typical of SIP investments. Rolling returns evaluate performance consistency across every possible holding period of a given length.

In Simple Words

Understanding return metrics is non-negotiable for any investor or distributor. With India's mutual fund AUM crossing ₹82 lakh crore as of early 2026 and the Nifty 50 having crossed 26,000+ levels, more capital than ever flows into mutual funds — and more investors than ever are misled by return numbers. Consider the case of an investor who says "the fund doubled in 5 years." The absolute return is 100%, but annualized (CAGR), that is only about 14.87% per year. Compare that with a fund that grew 80% in 3 years — the absolute return is lower, but the CAGR is roughly 21.6%, making it a significantly better performer on an annualized basis. Returns must always be compared on a like-for-like basis. For SIP investors, CAGR is misleading because money is invested at different times. Each SIP installment has a different holding period, so XIRR — which accounts for the timing of every cash flow — is the appropriate measure. When an investor asks "what is the SIP return?", the only accurate answer is the XIRR, not a simple CAGR. XIRR is especially important for SIP investors because it reflects the true annualized return considering all cash flow dates. Then there is the question of consistency. A fund may show a great 5-year point-to-point return, but what if it only performed well in the last year? Rolling returns solve this — they calculate the return for every possible 3-year or 5-year window and reveal how consistently the fund has performed across market cycles. Rolling returns remain the most reliable way to evaluate fund performance. A fund with a high average rolling return and low standard deviation of rolling returns is a truly consistent performer.

Real-Life Scenario

Consider the case of Ramesh, who invested a lump sum of ₹5,00,000 in a flexi-cap fund on 1st January 2019. By 1st January 2024, the value grew to ₹9,50,000. His absolute return is (9,50,000 - 5,00,000) / 5,00,000 = 90%. His CAGR is (9,50,000 / 5,00,000)^(1/5) - 1 = 13.7% per annum. His wife Priya invested ₹10,000/month via SIP over the same 5 years — a total of ₹6,00,000. Her portfolio value is ₹8,75,000. Her absolute return is 45.8%, but her XIRR (calculated using the Excel XIRR function with all 60 monthly cash flows and the final value) comes to 16.2% per annum. Why is Priya's XIRR higher than Ramesh's CAGR despite a lower absolute return? Because her later SIP installments had less time to compound, and many of her purchases happened at lower NAVs during the 2020 crash — rupee cost averaging at work. A rolling 3-year return analysis of this fund between 2016-2024 would show returns ranging from 8% to 22%, with a median around 14%. That gives far more insight than a single point-to-point number.

Key Points to Remember

Absolute return is the simple total percentage gain — suitable only for holding periods under 1 year

CAGR (Compound Annual Growth Rate) annualizes returns to enable fair comparison across different time periods

XIRR (Extended Internal Rate of Return) is the only correct method to measure SIP returns since each installment has a different holding period

Rolling returns calculate returns for every possible n-year period, revealing performance consistency across market cycles

Point-to-point returns are sensitive to the start and end date chosen — they can be cherry-picked to show misleading results

SEBI mandates that returns for periods exceeding 1 year must be shown as CAGR, not absolute returns

A fund with a high average rolling return and low standard deviation of rolling returns is considered a consistent performer

Always compare fund returns against the appropriate benchmark using the same return methodology

Formula

Absolute Return = ((Current Value - Initial Value) / Initial Value) x 100

CAGR = ((Ending Value / Beginning Value)^(1/n)) - 1
where n = number of years

XIRR: Solves for r in the equation: Sum of [Cash Flow_i / (1+r)^((Date_i - Date_0)/365)] = 0
where Cash Flow_i = each SIP installment (negative) and redemption value (positive)

Numerical Example

Absolute Return Example:
Invested: ₹1,00,000 | Current Value: ₹1,45,000
Absolute Return = (1,45,000 - 1,00,000) / 1,00,000 x 100 = 45%

CAGR Example:
Invested: ₹2,00,000 on 1 Jan 2020 | Value on 1 Jan 2024: ₹3,50,000 | Period: 4 years
CAGR = (3,50,000 / 2,00,000)^(1/4) - 1 = (1.75)^(0.25) - 1 = 1.1502 - 1 = 0.1502 = 15.02% per annum

XIRR Example:
₹10,000 SIP monthly for 12 months (total invested: ₹1,20,000)
Redemption value after 12 months: ₹1,32,500
Using XIRR function with 12 outflows of -₹10,000 on each month-start and +₹1,32,500 at end:
XIRR = approximately 19.8% per annum
(Note: Simple absolute return would show only 10.4%, significantly understating the actual annualized return)

Frequently Asked Questions

Test Your Knowledge

4 questions to check your understanding

Question 1 of 4Score: 0/0

An investor purchased mutual fund units worth ₹2,00,000. After 3 years, the value is ₹3,20,000. What is the CAGR?

Summary Notes

Absolute return = simple percentage gain, used for periods under 1 year; CAGR = annualized compounded return, used for periods over 1 year

XIRR is the only correct method for SIP return measurement — it accounts for different investment dates and amounts of each installment

Rolling returns show performance consistency by calculating returns for every possible n-year period; prefer funds with high average and low standard deviation of rolling returns

SEBI mandates CAGR for periods above 1 year and prohibits annualizing returns for periods below 1 year

Never rely on a single point-to-point return — always cross-check with rolling returns and compare against the benchmark using TRI