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 September 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
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
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
Ready to Apply What You Learned?
Now that you understand Risk, Return & Performance, put it into practice with our free tools.
What you’ll learn in Risk, Return & Performance
Learn to measure returns (CAGR, XIRR, rolling), understand risk metrics (Sharpe ratio, beta, standard deviation), and read mutual fund factsheets like a pro. Essential for comparing funds.
Frequently asked questions
Why is CAGR better than absolute return for comparison?
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.
Can CAGR be used to measure SIP returns?
No, CAGR is not suitable for SIP returns. CAGR assumes a single lump-sum investment at the beginning, but in a SIP, money is invested periodically at different NAVs. Each installment has a different holding period. XIRR is the correct measure for SIP returns because it accounts for the timing and size of every cash flow. Most fund house websites and apps now show SIP XIRR.
What are rolling returns and why are they important?
Rolling returns calculate the return for every possible period of a given length within a dataset. For example, a 3-year rolling return analysis of a fund from 2010-2025 would calculate the 3-year return starting from every single day — 1 Jan 2010 to 1 Jan 2013, 2 Jan 2010 to 2 Jan 2013, and so on. This gives hundreds of data points instead of just one, showing how consistently a fund performs regardless of when the investment was made. It eliminates the bias of point-to-point returns.
How is XIRR calculated for mutual fund SIP investments?
XIRR can be calculated using Excel or Google Sheets. All SIP investment dates and amounts are listed as negative values (outflows), and the current portfolio value is added as a positive value on today's date. Then the =XIRR(values, dates) function is applied. Most mutual fund platforms like MF Central, Kuvera, and Groww also calculate and display portfolio XIRR automatically.
A fund shows 25% one-year return. Is that a reason to invest?
A single one-year return figure can be misleading because it depends entirely on which one-year period is being considered. Instead, the 3-year and 5-year rolling returns should be checked to assess consistency. It is also important to verify whether the fund outperformed its benchmark across different market cycles. A fund that consistently delivers 14-16% across rolling periods is generally more reliable than one that swings between -5% and 40%.
What is the difference between a price index and a Total Return Index (TRI)?
A price index (like Nifty 50) only tracks the price movement of its constituent stocks. A Total Return Index (TRI) additionally assumes that all dividends paid by constituent stocks are reinvested back into the index. The TRI always shows a higher return than the price index. SEBI mandated TRI comparison from February 2018 because it provides a fairer benchmark — the fund manager has the benefit of dividends, so the benchmark should reflect that too.
Can a fund have high returns but negative alpha?
Absolutely. If a fund takes significantly more risk (higher beta) than the benchmark, it may deliver high absolute returns but still have negative Jensen's Alpha. For example, a fund with beta of 1.5 is expected to deliver 1.5x the market return. If the market returns 12% and the fund returns 16%, the CAPM expected return would be 7% + 1.5 x (12% - 7%) = 14.5%. The fund returned 16%, so Jensen's Alpha is 1.5%. But if the fund only returned 14%, the alpha would be -0.5% despite a seemingly good 14% return.
What are tier-1 and tier-2 benchmarks?
Tier-1 benchmark is the primary benchmark most closely aligned with the fund's investment universe. For a large-cap fund, it would be Nifty 50 TRI or BSE 100 TRI. Tier-2 benchmark is an additional benchmark for broader comparison, often a wider market index. SEBI requires both to be declared so investors have multiple reference points for evaluating performance.
Free course · 8 topics · 55 min