🏠 Home 🧮 Calculators ⚖️ Compare ⚡ Decision Tools 🛠️ Tools 📚 Learn 📝 File ITR ✍️ Blog
📈 SIP Calculator 🏦 EMI Calculator 🧾 Income Tax 🔥 FIRE Calculator
← All Calculators
📊
✓ Updated March 2026 · FY 2025-26

Rolling Return
Calculator

See how Nifty 50, Midcap 150, Gold and FD performed across every 1, 3, 5 and 10-year window since 2000. Understand consistency — the truth about SIP reliability that point-to-point returns hide.

Advertisement
📋 Analysis Settings
Windows Analysed
22
3-year windows since 2000

Start SIP on Groww

Zero commission · 5-min setup

Invest →
Avg Return
13.2%
p.a. CAGR
Best Period
+52%
highest
Worst Period
-12%
lowest
% Positive
84%
profitable
📊 Rolling CAGR — Every Window (Green = Profit, Red = Loss)
📋 Quick Summary Table

Why Rolling Returns Matter More Than Point-to-Point

📉
Reveals Consistency
A fund can show 20% returns over 10 years by doing 50% in year 1 and 6% thereafter. Rolling returns expose this illusion.
🎯
Better Fund Selection
Funds with high % of positive 5-year rolling windows are safer SIP choices than those with impressive but volatile point-to-point returns.
Set SIP Horizon
If 95%+ of 5-year windows are positive, Nifty 50 SIPs are reliably profitable over 5+ years. This drives the "stay invested" advice.

Rolling Return Calculator — The Truth About Consistency That Point-to-Point Hides

Rolling return measures the annualised return across every possible time window of a fixed length. Unlike point-to-point returns — which can flatter or mislead depending on start/end dates — rolling returns reveal whether a fund is consistently good or just had one good run. A Nifty 50 SIP investor who sees 87% of all 5-year windows were positive can invest with far greater confidence than one relying on a single advertised return figure.

87%
of all 5-yr Nifty 50 windows delivered positive returns (2000–2024)
13.4%
Average 5-yr rolling CAGR for Nifty 50 since 2005
99%
of all 10-yr Nifty 50 windows delivered positive returns since 2000
-22%
Worst Nifty 50 year (2008) — recovered fully in 2 years

📐 Formula

Rolling CAGR = (End NAV / Start NAV)^(1/n) − 1

For a 3-yr rolling analysis 2000–2024: Window 1 = 2000→2003, Window 2 = 2001→2004 … 22 windows total. Min, max, average and % positive windows are computed across all windows.
💡 How to Use for Fund Selection
✓ Look for 85%+ positive 3-year windows — ideal for 3-5 year SIP horizons.
✓ Avoid funds where minimum rolling return is below -30% — extreme downside risk.
✓ Gold and Nifty 50 are inversely correlated — combining them reduces portfolio volatility.
✓ Small-cap has highest average rolling returns but also most negative windows — only for 7+ yr horizons.

❓ Frequently Asked Questions

What is a rolling return? +

Rolling return measures annualised returns over every possible time window of a fixed length (e.g. every 3-year period from 2000). It reveals consistency — a fund with 90% positive 3-year windows is far more reliable than one with one great 10-year stretch.

What is Nifty 50's average 5-year rolling return? +

The Nifty 50 average 5-year rolling CAGR from 2000 to 2024 is approximately 12–14%. About 87% of all 5-year windows delivered positive returns.

How many 3-year SIP periods in Nifty 50 gave negative returns? +

About 13–16% of 3-year periods (mostly 2001–2003 and 2008–2011 windows). At 5 years, this drops below 8%, and at 10 years, virtually zero periods have shown losses.

Which asset class has the best rolling returns in India? +

Over 10-year windows since 2000: small-cap average 18–20% CAGR but with high variance. Nifty 50 averages 12–14% with better consistency. Gold averages 8–10% and acts as a portfolio hedge.

How do I pick mutual funds using rolling returns? +

Choose funds where: average 3/5-year rolling return beats benchmark, % positive periods is above 85% (3yr) and 95% (5yr), and minimum rolling return is above -25%.

📰 Related Reading
⚖️ SIP vs Lump Sum: Real Data
Historical Nifty 50 comparison

📬 Get Free FY 2025-26 Finance Updates

Tax changes, RBI rate updates, new calculators — straight to your inbox. 100% free, unsubscribe anytime.

✅ You're subscribed! Check your inbox for a confirmation.