Kalindra Advisors is choosing between two value funds that both show a 14.5% 5-year CAGR. Fund X beat its benchmark in 58% of 3-year rolling windows, by wide margins; Fund Y in 81%, by narrow margins. Which suits a first-time investor who will judge the fund after two years?

Fund Y suits this investor, because it was ahead in 81% of rolling windows against 58% for Fund X. The identical 14.5% hides very different paths: Fund X wins big and loses big, so a client who checks after two years has about a 42% chance of seeing it behind and leaving at the worst moment. Fund X may suit a patient investor; for this one, consistency matters more than the size of the wins.

Two students both average 75% over a year. One scores 74 to 76 in every test; the other swings between 55 and 95. A parent who sees only one report card in the middle of the year may meet either student at their worst. A rolling returnThe return over a fixed window, such as three years, measured again and again as the window moves forward, so you see every starting date, not just one. shows every report card, not just the annual average. Here the five-year figures are identical, and the rolling record shows how differently the two funds got there.

Because the investor will act on one window. An investor who leaves a fund after a bad stretch does not earn the fund's average; they earn its worst period and miss its recovery. Fund X's losing windows averaged -3.2 points and lasted for long runs: look at the 7 windows in a row below zero early in the chart. A client who entered at the start of that run would be behind for two years and would likely sell. Fund Y's worst window was -0.9 points, small enough that most clients would not notice.

Put a rupee figure on it. On Rs 10 lakh, being 5 points behind the benchmark for two years means the client sees about Rs 1 lakh less than an index fund would have made, which is a conversation most first-time investors end by redeeming. Being 0.8 points behind is about Rs 16,000, which rarely ends a relationship. The gap between a fund's return and the return its investors actually earn is called the behaviour gapThe difference between a fund’s reported return and the average return its investors earn, caused by buying after good periods and selling after bad ones., and volatile excess returns widen it.

No, and saying so is part of a good answer. Fund X's average excess return across all windows is about the same as Fund Y's, and its big swings may come from a genuinely contrarian value process that pays off for patient money. The right fund depends on the investor's horizon and temperament, not only on the fund's record. For a client who will hold for seven years and has sat through a bad patch before, Fund X may be the better choice. For a first-time investor who judges at two years, it is a likely source of a bad first experience.

Close with what you would still check. Is Fund X's volatility from style, which is explainable, or from a few large bets, which is concentration risk? Has the same manager run both records throughout? And are both funds' rolling records measured against the same value benchmark, so that the consistency is real and not the result of a softer comparison? The past windows are evidence of behaviour, not a forecast of returns.