Measuring Returns — CAGR, Absolute, XIRR, Rolling Returns
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 ...
Measuring Returns — CAGR, Absolute, XIRR, Rolling Returns
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.
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.
A Practical Example
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.
What Makes This Important
Mathematical 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)
Step-by-Step Calculation
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
Absolute return does not account for the time period. A 50% return in 2 years is very different from 50% in 10 years. CAGR annualizes the return so investments with different holding periods can be compared on a level playing field. For example, 50% in 2 years is a CAGR of 22.5%, while 50% in 10 years is only 4.1% CAGR — clearly the first investment performed far better.
🧠 Quick Quiz
4 questions to check your understanding