Measuring Returns in Financial Markets
Investment Returns
Concepts, Calculations & Interpretation
CAGR, XIRR, Average Returns, and Rolling Returns each reveal a different aspect of investment performance, and together they provide a far more complete picture than any single number could offer. PESAWALA helps demystify this complexity.
Why Measuring Returns Look
More Complex Than It Appears
Every investor eventually asks a simple question: How well has my investment performed? The answer, however, is rarely as simple as quoting a single percentage. Different investments generate returns under different conditions. Some involve a one-time investment, while others receive regular contributions. Some perform consistently over time, while others alternate between periods of exceptional growth and disappointing decline.
As a result, economists and financial analysts use several different measures to evaluate investment performance. Among the most important are Average Returns, Compound Annual Growth Rate (CAGR), Extended Internal Rate of Return (XIRR), and Rolling Returns.
Different Measures
Answer Different Questions
Each of these measures answers a different question. Understanding when and how to use them is essential for interpreting investment results correctly. Using the wrong measure can create misleading impressions, while selecting the appropriate one allows investors to compare alternatives more accurately and make better financial decisions.
(A) Average Returns:
Simplest Measure of Performance
Average Return is the simplest measure of investment performance. It is the arithmetic mean of returns earned over several periods. Suppose an investment earns 10% in the first year, 20% in the second year, and -5% in the third year. The average return is simply the sum of these annual returns divided by three.
A Simple Example of Average Return
In this example,
Average Return = (10 + 20 - 5) ÷ 3 = 8.33%.
The calculation is straightforward and easy to understand. It provides a quick summary of historical performance over multiple periods.
The Major Limitation of
Average Returns
However, Average Return has an important limitation. It ignores the effects of compounding. Investments do not usually grow by repeatedly applying the average annual percentage to the original investment. Instead, each year's return builds upon the previous year's ending value. Positive and negative returns therefore interact with one another. A gain of 50% followed by a loss of 50% does not leave the investor where they started. An investment of ₹100 grows to ₹150 after a 50% gain, but falls to only ₹75 after a subsequent 50% loss. Although the average return is zero, the investor has actually lost 25% of their original capital.
Why Compounding Changes Everything
This example illustrates why Average Return can sometimes overstate long-term investment performance. It is useful for describing historical observations but should not be used as the primary measure of long-term wealth creation.
(B) Compounded Annual Growth Rate:
Measuring the True Rate of Growth
To overcome this limitation, economists often use the Compound Annual Growth Rate, commonly known as CAGR. CAGR measures the constant annual rate at which an investment would have grown if it had increased at the same rate every year.
How CAGR Incorporates Compounding
Unlike Average Return, CAGR fully accounts for compounding. It converts a series of uneven annual returns into one equivalent steady annual growth rate.
An Example of CAGR in Practice
Suppose ₹100 grows to ₹200 over five years. The investment has doubled, but it probably did not earn exactly 20% every year. CAGR answers the following question: What constant annual return would transform ₹100 into ₹200 in five years?
The answer is approximately 14.87% per year.
Notice that this number is much smaller than simply dividing the total 100% gain by five years. Compounding explains the difference. Each year's growth occurs on an increasingly larger base.
Why Investors Prefer CAGR
CAGR is particularly valuable when comparing investments held over several years. If one mutual fund reports a CAGR of 15% over ten years while another reports 12%, the comparison is meaningful because both figures incorporate the effects of compounding.
The Limitations of CAGR
Nevertheless, CAGR also has limitations. It assumes a smooth growth path even when the actual investment experienced considerable volatility. An investment may have risen sharply one year, fallen significantly the next, and recovered afterward. CAGR ignores this journey and focuses only on the starting value, ending value, and investment duration. It therefore measures overall growth but not investment risk or consistency.
(C) Extended Internal Rate of Return:
Designed for Real-World Investing
Many real-world investments involve multiple cash flows rather than a single initial investment. Investors regularly contribute money to mutual funds through Systematic Investment Plans (SIPs), add savings at irregular intervals, or withdraw funds before the investment ends. Under such circumstances, CAGR is no longer appropriate because not all money remains invested for the same length of time.
What XIRR Stands For
This is where Extended Internal Rate of Return (XIRR) becomes indispensable.
XIRR measures the annualized return of investments involving cash flows occurring on different dates. Unlike CAGR, which assumes a single investment at the beginning and a single redemption at the end, XIRR considers the exact timing and size of every contribution and withdrawal.
A Practical Example of XIRR
Consider an investor who contributes ₹5,000 every month into an equity mutual fund through a SIP. The first contribution remains invested for several years, while the last contribution may remain invested for only a few weeks before the portfolio is evaluated. Treating all investments as though they had been invested for the same duration would produce misleading results.
How XIRR Solves the Problem
XIRR solves this problem mathematically. It identifies the annual rate of return that equates the present value of all cash outflows with the present value of all cash inflows while accounting for their actual dates.
Although the underlying calculation requires numerical methods and is too complex for manual computation, spreadsheet software such as Microsoft Excel and Google Sheets computes XIRR automatically once investors enter the dates and cash flows.
When XIRR Is the Best Choice
For anyone investing through SIPs, making additional purchases during market declines, or withdrawing money periodically, XIRR is the most appropriate measure of investment performance. It reflects the investor's actual experience rather than an oversimplified estimate.
(D) Rolling Returns:
Look Beyond
a Single Time Period
While Average Return, CAGR, and XIRR summarize past performance over a fixed period, they do not reveal how stable that performance has been across different starting dates. This brings us to Rolling Returns, one of the most informative yet often overlooked measures in investment analysis.
Understanding the
Concept of Rolling Returns
Rolling Returns calculate returns over a fixed investment horizon repeatedly by shifting the starting date forward one period at a time.
For example, suppose we wish to evaluate five-year performance for a mutual fund with fifteen years of historical data. Instead of calculating only one five-year return, we calculate every possible five-year return. The first observation might cover January 2010 to January 2015. The second covers February 2010 to February 2015. The third covers March 2010 to March 2015, and so on.
This process produces hundreds of overlapping five-year returns.
Why Rolling Returns
Are So Valuable
The resulting distribution provides much richer information than a single point estimate. Investors can observe the best five-year outcome, the worst five-year outcome, the median return, and the consistency of performance across different market environments.
Eliminating
the Bias of Timing
Rolling Returns are especially valuable because investment outcomes often depend heavily on the chosen starting date. Imagine evaluating an equity fund immediately after a major stock market crash. Its subsequent returns may appear extraordinarily strong because markets recovered from unusually depressed levels. Conversely, evaluating the same fund just before a financial crisis may produce disappointing results. A single CAGR may therefore reflect unusually favorable or unfavorable timing.
Rolling Returns reduce this timing bias by examining many different investment periods rather than only one.
Why Professionals
Rely on Rolling Returns
Professional fund managers, institutional investors, and financial researchers frequently rely on Rolling Returns because they provide a more comprehensive assessment of consistency. An investment delivering strong Rolling Returns across multiple periods is generally considered more reliable than one achieving a high CAGR through only a few exceptional years.
Choosing the Right Measure
for the Right Situation
These four measures should therefore be viewed as complementary rather than competing statistics.
Average Return provides a simple summary but ignores compounding. CAGR measures long-term compound growth for a single investment held continuously. XIRR extends the concept to investments involving multiple cash flows occurring at different times. Rolling Returns evaluate consistency by examining performance across numerous overlapping investment periods.
Selecting the correct measure depends entirely on the investment situation. A lump-sum investment held from beginning to end is best evaluated using CAGR. A SIP or irregular investment schedule should be evaluated using XIRR. A researcher studying consistency should examine Rolling Returns. Average Return remains useful for descriptive statistics but should rarely be interpreted as the actual rate of wealth creation.
My Inference:
Understanding What
the Numbers Really Mean
In economics and finance, measurement is as important as observation. Two investors may own identical portfolios yet report different returns simply because they use different performance measures. Understanding the assumptions behind each metric allows investors to interpret results correctly, compare investment opportunities fairly, and avoid common analytical errors.
Financial literacy is not merely about knowing percentages; it is about knowing what those percentages actually represent. CAGR, XIRR, Average Returns, and Rolling Returns each reveal a different aspect of investment performance, and together they provide a far more complete picture than any single number could offer.
