Why Trailing Returns Depend Completely on Two Dates

Two friends can invest in the exact same equity mutual fund scheme and walk away with entirely different impressions of how it performed.

The first opens an investment app on a Tuesday morning. The app shows that the fund delivered a 19% annualised return over the past three years. The second friend checked the same fund six months earlier and saw an 8% return for the preceding three-year block. Neither app was malfunctioning. Both numbers were legally accurate, calculated down to the second decimal place using official Net Asset Value (NAV) data.

The difference comes down to a quiet quirk of how investment returns are published across India. Most performance numbers printed on fund fact sheets, websites, and portal rankings are trailing returns. Understanding what a trailing return actually measures—and what it ignores—changes how you read every performance table you see.

What a trailing return actually measures

A trailing return is a point-to-point measurement. It takes the value of an investment on a chosen end date, looks back across a fixed window of time (such as one year, three years, or five years), and calculates the annual compound rate of growth between that start point and that end point.

In India, regulations set by the Securities and Exchange Board of India (SEBI) require mutual funds to publish returns over standard periods like one year, three years, and five years using Compound Annual Growth Rate (CAGR). CAGR is the constant annual rate at which an investment would have grown if it had grown at a perfectly steady pace every year.

The formula requires only three numbers: the starting NAV, the ending NAV, and the number of years between them. Everything that happened between those two dates is invisible to the formula. Whether the fund climbed in a neat straight line, fell by 40% in the middle, or sat completely flat until the final two months, the trailing return will produce the exact same final percentage if the starting and ending NAVs match.

This makes a trailing return clean, simple, and strictly historical. It tells you what happened to a single lump sum deployed on one specific calendar day and checked on another specific calendar day.

A tale of two start dates

To see how much the calendar controls the answer, consider a hypothetical mutual fund scheme over a turbulent period. Suppose an investor is looking at three-year trailing returns calculated on 31 March 2023.

The three-year trailing return measured on 31 March 2023 looks back to 31 March 2020. In late March 2020, Indian equity markets experienced a sharp, sudden fall following the onset of nationwide pandemic restrictions. NAVs across the entire mutual fund industry were depressed.

Let us trace the arithmetic using hypothetical numbers. Assume a fund scheme had an NAV of ₹100 on 1 January 2020. By 31 March 2020, after the market fall, its NAV had dropped to ₹70. Three years later, on 31 March 2023, the NAV stood at ₹140.

When the fund house calculates the three-year trailing return on 31 March 2023, the start point is ₹70 and the end point is ₹140. Over three years, doubling from ₹70 to ₹140 works out to an annualised return (CAGR) of approximately 26% per year. That 26% figure looks exceptional on a marketing document.

Now shift the measurement window back by just three months. Calculate the three-year trailing return on 31 December 2022, looking back to 31 December 2019.

Assume the NAV on 31 December 2019 was ₹98, and on 31 December 2022 it had reached ₹135. Growing from ₹98 to ₹135 over three years equals an annualised return of roughly 11.2% per year.

The underlying portfolio did not suddenly transform from an ordinary performer into a world-beater. The only thing that changed was the anchor date. In the first calculation, the start date happened to sit at the bottom of a steep market drop. Because the starting denominator was artificially low, the resulting trailing return looked artificially high.

This phenomenon works in reverse, too. If a measurement period starts at the peak of a raging bull market and ends after a normal correction, the three-year trailing return can look dismal, even if the fund performed sensibly across most of that window.

The problem of endpoint sensitivity

Financial analysts call this distortion endpoint sensitivity. When a calculation relies entirely on two specific dates, changing either the starting pin or the ending pin changes the whole story.

This creates three common traps for ordinary savers:

• Recency bias: When a market rally has run for twelve months, one-year trailing returns across almost all equity schemes look attractive. Savers who review funds during these windows often assume the category has become permanently more profitable, when they are simply measuring from a low starting point.
• The illusion of manager skill: A fund scheme may appear at the very top of a three-year ranking table not because the investment team made brilliant stock choices, but because that specific scheme held more cash or took an unusual sector bet precisely on the date the measurement window opened.
• Mismatched real-world experience: Very few savers invest their entire wealth on a single day and leave it untouched for exactly three or five years. Most people invest monthly through Systematic Investment Plans (SIPs) or add money when they have surplus cash. An investor who put money into a scheme every month for three years will almost never experience the three-year trailing return published on the scheme's fact sheet.

Trailing returns also hide the journey. A fund that gained 20% in year one, lost 15% in year two, and gained 25% in year three might show an attractive three-year trailing return. Another fund might have delivered a calm 8% each year. The trailing numbers might look comparable, but the anxiety experienced by someone holding the volatile fund was substantially higher. A point-to-point return cannot tell you how bumpy the road was.

How rolling returns offer a wider view

Because trailing returns are hostage to the calendar, analysts often look at rolling returns to see a broader pattern.

A rolling return does not look at just one three-year block. It takes every possible three-year block across a long stretch of time.

For example, instead of measuring only from 1 January 2021 to 1 January 2024, a rolling return calculation measures from 1 January to 1 January, then shifts forward by one day to measure 2 January 2021 to 2 January 2024, then 3 January, and so on for hundreds or thousands of overlapping blocks.

This rolls the window forward day by day. By looking at the average, minimum, and maximum returns across all those separate three-year periods, the effect of a single lucky or unlucky start date begins to wash out. A scheme that only looked good because of a one-time market crash at its starting gate will look far more ordinary when evaluated across fifty different starting gates.

Rolling returns take more effort to compute, but they prevent the date on the calendar from dictating the entire conclusion.

Reading the number for what it is

None of this means trailing returns are dishonest or useless. They are a standardised, mathematically rigorous way to record what an investment did between two moments in time. Regulators mandate them precisely because they prevent fund managers from picking arbitrary, non-standard dates to make their funds look better.

However, a trailing return is a historical snapshot, not a forecast. It reflects the environment on the day the money was notionally deployed just as much as it reflects the skill of the portfolio manager.

When you see a single return percentage on a screen, the question is not just how large the number is. The question is which two dates produced it, what market conditions existed on those dates, and whether that specific sliver of calendar time represents normal conditions or an unusual peak or trough.