About this tool

Rolling Returns Calculator

Average, best and worst annualised returns across every overlapping window in a NAV or index series.

The Rolling Returns Calculator takes a NAV or index series and slides a fixed window — one year, three years, five years — across every possible start point, annualising each window with the CAGR formula. Instead of one flattering point-to-point number, you get the average, median, best and worst experience across all overlapping periods, plus how often the fund cleared your hurdle rate. It is the honest way to judge consistency rather than luck of the start date.

How to use Rolling Returns Calculator

1. 1

   Open Rolling Returns Calculator on AltFTool — it loads instantly in your browser.

2. 2

   Enter the values you already know.

3. 3

   Fine-tune the options to match your scenario.

4. 4

   Read the result and use it in your planning or reporting.

Why use Rolling Returns Calculator

• Removes start-date bias

  Every possible entry point is tested, not just the one that flatters the fund.

• Worst case in plain sight

  The minimum rolling return tells you what the unluckiest investor actually earned.

• Consistency scoring

  Distribution buckets and the hit rate above your hurdle show how reliable the returns were.

Common use cases

• Comparing two equity funds whose 5-year point-to-point returns look identical, to see which one had the worse rolling 3-year troughs.
• Checking how often a fund beat a 12% per year hurdle over rolling 3-year windows before you commit to a SIP.
• Showing a nervous investor the worst rolling 5-year outcome in a fund's history so expectations are set before markets fall.

Frequently asked questions