BHARTIARTL Rolling Returns

Over 15 years, Bharti Airtel Ltd. has been through 61 separate 15 years holding periods — one starting every month. The median returned 10.0% a year, the worst 3.9% and the best 15.9%. A rolling return measures every possible start date instead of one, which is why it answers a question a single headline CAGR cannot: how much the outcome depended on when you happened to buy.

Yes. 14.9% of the 121 10 years periods on record ended below where they started, and the worst of them lost 1.5% a year — the stretch beginning September 2007. The median period returned 8.0% a year.

-11.5% a year, for the five years beginning October 2007. For contrast the best 5 years returned 37.6% a year, starting October 2020, and the median across all 181 periods was 7.0%. The gap between those two numbers is the part of the outcome that came down to timing rather than to the company.

On this record, yes. 1 year outcomes ranged from -40.4% to 114.0% a year — a spread of 154.4%. 15 years outcomes ranged from 3.9% to 15.9%, a spread of 12.0%. Longer holding periods narrowed the range of results, which is the usual pattern and the reason this page publishes every window rather than one. Narrowing the range is not the same as removing the risk.

In 36.1% of the 61 15 years periods both series cover. Each window is compared against the index over the identical months, not against an assumed index return, so the comparison is a like-for-like record rather than a model.

Windows step forward one month at a time on month-end closing prices adjusted for dividends and stock splits, so dividends are treated as reinvested. A window length is only published once there are at least twelve complete windows behind it — fewer than that describes an anecdote, not a distribution. Overlapping windows share months by construction, which is what makes this a description of the actual history of Bharti Airtel Ltd. rather than a sample of independent trials. Companies that delisted are not on this site at all, a survivorship bias worth holding in mind.

That is not a question this page answers, and we do not make recommendations. What it can show you is the full range of what every holding period in the listed history of Bharti Airtel Ltd. actually produced — including the worst ones, which most performance figures leave out. Those are records of what happened, not forecasts. A stock that never had a losing decade may still have one, and holding a single company is a materially different risk from holding an index.