SIP rolling returns can reveal far more about a mutual fund than the single return displayed in an investment app. A normal SIP XIRR tells you what happened between one specific start date and one specific end date. Rolling analysis repeats that calculation across many different periods, showing whether the result was consistent or largely dependent on favourable timing.
This matters because SIP investing has become deeply embedded in Indian household finance. AMFI reported monthly SIP contributions of ₹31,781 crore in June 2026. Yet many investors still evaluate funds using only one-year, three-year or five-year trailing returns. This Gyan Mela guide explains a more useful approach.
Key Takeaways
- A SIP is an investment method, not a separate mutual-fund product.
- A single XIRR depends heavily on the exact starting and ending dates.
- Rolling SIP analysis calculates returns across many overlapping investment periods.
- The analysis can reveal minimum, maximum and middle-range outcomes.
- A fund should be compared with an appropriate total-return benchmark using identical cash-flow dates.
- Rolling outperformance should not be interpreted as a guarantee or probability of future success.
- Returns alone are insufficient; investors must also assess risk, costs, portfolio quality and goal suitability.
What Is a Mutual Fund SIP?
A Systematic Investment Plan is a facility through which an investor contributes a fixed amount to a mutual-fund scheme at regular intervals. The interval may be monthly, weekly, quarterly or another frequency offered by the scheme.
AMFI describes a SIP as an investment methodology that supports disciplined investing and rupee-cost averaging. It does not transform an equity mutual fund into a guaranteed or low-risk product.
Each instalment buys units at the applicable Net Asset Value. When the NAV is lower, the same investment amount purchases more units. When the NAV is higher, it purchases fewer units.
Here’s the catch: averaging the purchase price does not protect the accumulated portfolio from a market fall. Once the corpus becomes much larger than the latest monthly contribution, the existing corpus remains exposed to normal market volatility.
What Are SIP Rolling Returns?
SIP rolling returns measure the annualised return earned by a series of SIP investments over multiple overlapping periods of equal length.
Suppose you want to analyse five-year SIP performance. Instead of calculating only one five-year period, you calculate several:
- January 2015 to December 2019
- February 2015 to January 2020
- March 2015 to February 2020
- April 2015 to March 2020
- Continue the process until the available NAV history ends
Every window contains the same investment duration, but the market conditions are different. One period may begin before a rally, another before a crash and another during a flat market.
Freefincal’s rolling-return methodology similarly calculates XIRR for one SIP window, moves the starting point forward and repeats the calculation. The fund and benchmark can then be compared across the same periods.
Why One SIP XIRR Can Be Misleading
A trailing SIP return is not necessarily false. It is simply incomplete.
Assume an investor checks a five-year SIP return on 31 December. That number reflects investments made during one particular five-year sequence. Moving the ending date by a few months can produce a different XIRR because the final market value affects every instalment in the calculation.
Two funds may therefore exchange positions depending on the date selected:
- Fund A may have the higher five-year XIRR today.
- Fund B may have performed better over most previous five-year windows.
- Fund A’s current advantage may come from one recent sector rally.
- Fund B may have delivered a narrower and more stable range of outcomes.
Point-to-point returns answer one question: What happened during this exact period?
Rolling returns answer a broader question: What happened across many comparable periods?
What Is XIRR?
XIRR is the annualised return for investments and withdrawals occurring on different dates.
CAGR is suitable when one lump sum is invested and later redeemed. A SIP creates several cash flows. Every instalment enters the investment at a different date, so each amount remains invested for a different duration.
XIRR finds one annualised rate that connects all dated investments with the final portfolio value.
When entering the data in a spreadsheet:
- SIP instalments are normally entered as negative cash flows.
- The final portfolio value is entered as a positive cash flow.
- Every cash flow must have its actual transaction date.
- The XIRR function calculates the annualised rate.
XIRR should not be confused with absolute return. If ₹1,20,000 of total instalments becomes ₹1,35,000, the absolute gain is ₹15,000. That alone does not show the annualised return because the entire ₹1,20,000 was not invested from the first day.
How SIP Rolling Returns Are Calculated
A proper rolling SIP analysis requires consistent assumptions.
- Select the scheme and plan. Specify direct or regular, growth or IDCW.
- Choose an investment frequency. Monthly SIPs are commonly used for analysis.
- Select an SIP amount. The amount does not materially affect the percentage XIRR when the same amount is used consistently.
- Choose the investment horizon. For example, three, five, seven or ten years.
- Select each instalment date. Use the same rule in every rolling window.
- Calculate units purchased. Divide each contribution by the applicable NAV.
- Find the final portfolio value. Multiply the accumulated units by the NAV on the ending date.
- Calculate XIRR. Use the dated contributions and final value.
- Move the window forward. Shift the start date by one month and repeat.
- Run the identical calculation for the benchmark.
Historical scheme NAVs can be obtained through AMFI’s official NAV-download facility. AMFI also provides historical NAV search options, although downloads may be divided into limited date ranges.
Use the Correct Benchmark
A mutual fund should be compared with a benchmark that represents its actual investment universe.
| Fund category | Possible benchmark type |
|---|---|
| Large-cap equity fund | Relevant large-cap Total Return Index |
| Mid-cap equity fund | Relevant mid-cap Total Return Index |
| Small-cap equity fund | Relevant small-cap Total Return Index |
| Flexi-cap fund | Broad-market Total Return Index |
| Hybrid fund | Comparable blended equity-debt index |
| Index fund | The specific index the scheme tracks |
A Total Return Index includes the effect of dividends generated by its constituents. Comparing an equity fund with a price-only index can make the fund appear stronger because the price index excludes dividends.
The benchmark SIP should also use the same instalment dates, amount, horizon and final valuation date as the fund SIP. Otherwise, the comparison is not like-for-like.
What Metrics Should Investors Examine?
Minimum rolling XIRR
The minimum shows the weakest historical outcome across the tested windows. It helps investors understand how disappointing the result could have been during an unfavourable period.
Maximum rolling XIRR
The maximum represents the strongest historical window. It is useful for understanding the range, but it should not be treated as a realistic expectation.
Median rolling XIRR
The median is the middle observation when all outcomes are arranged from lowest to highest. It can be more informative than a simple average when extreme returns distort the distribution.
Return range
A wide gap between the weakest and strongest outcomes indicates that investor experience depended heavily on timing. A narrow range may indicate greater historical consistency, though not necessarily low risk.
Benchmark outperformance frequency
This measures how many rolling periods the fund beat its benchmark.
For example, assume there were 120 five-year rolling windows and the fund outperformed in 78:
Outperformance consistency = 78 ÷ 120 × 100 = 65%
This is an illustrative example, not data for any specific fund.
A 65% score means the fund beat the benchmark in 65% of the historical windows tested. It does not mean that the fund has a 65% chance of beating the benchmark in the future. Freefincal explicitly cautions against treating rolling consistency as a future probability.
Negative or low-return periods
Investors should check how frequently the rolling XIRR was negative or below the return required for their financial goal.
A fund may beat its benchmark frequently and still fail to generate an adequate result. Outperformance is useful, but goal achievement matters more.
How to Interpret a Rolling-Return Table
Consider this fictional example:
| Five-year rolling metric | Fund | Benchmark |
|---|---|---|
| Median XIRR | 12.4% | 11.8% |
| Minimum XIRR | 1.9% | 3.1% |
| Maximum XIRR | 23.8% | 21.6% |
| Windows outperformed | 78 of 120 | Not applicable |
The fund has a higher median return and beat the benchmark in 65% of the periods. That initially appears attractive.
However, its weakest outcome was worse than the benchmark’s weakest outcome. The fund may therefore have generated additional return at the cost of greater downside risk.
The correct conclusion is not simply “the fund is better.” The investor must determine whether the additional risk, costs and inconsistency are justified.
Do Not Average Rolling Returns Blindly
Rolling windows overlap. A five-year period beginning in January and another beginning in February share 59 months of observations. They are not fully independent outcomes.
Data from the middle of the total analysis period also appears in more rolling windows than data near the beginning and end. This can distort a simple arithmetic average.
For this reason, investors should focus on:
- The complete range of outcomes
- The median and percentile distribution
- The weakest periods
- Benchmark outperformance consistency
- The market conditions behind extreme results
Freefincal similarly argues that the primary value of a rolling-return chart is understanding the spread in returns and the consistency of outperformance—not producing one supposedly definitive average.
Does a SIP Reduce Investment Risk?
A SIP can reduce the behavioural risk of waiting endlessly for the “perfect” market entry. It can automate investing and spread purchases over different NAV levels.
But a SIP does not eliminate market risk.
Suppose an investor has accumulated ₹20 lakh and contributes another ₹20,000 each month. A 20% decline in the portfolio can reduce the existing corpus by roughly ₹4 lakh before considering new contributions. Buying extra units during the fall does not instantly offset that decline.
SEBI requires mutual-fund schemes to display a Riskometer ranging from low to very high so that investors can assess whether the underlying scheme matches their tolerance. The risk comes from the assets held by the scheme, not from whether contributions are made through SIP or lump sum.
Rolling SIP Returns Versus Rolling Lump-Sum Returns
| Feature | Rolling SIP returns | Rolling lump-sum returns |
|---|---|---|
| Cash flows | Multiple investments on different dates | One initial investment |
| Return measure | XIRR | CAGR |
| Investor behaviour represented | Regular investing from income | One-time deployment of capital |
| Main use | Analyse recurring-investment experience | Analyse scheme or asset performance |
| Sensitivity | Influenced by each contribution and final NAV | Influenced by start and end NAV |
Rolling lump-sum returns are often simpler for evaluating the investment strategy itself. Rolling SIP returns are useful when the question concerns the experience of a recurring investor.
Neither analysis proves that SIP or lump sum will be superior in the future. They represent different cash-flow patterns.
Other Factors to Check Before Choosing a Fund
Rolling returns should be one part of the review, not the entire review.
Riskometer
Confirm whether the scheme’s official risk level matches your capacity to tolerate losses. SEBI makes Riskometer disclosure mandatory for mutual-fund schemes.
Direct versus regular plan
Direct and regular plans invest in the same underlying portfolio but have different expense structures. Regular plans include distributor-related costs, while direct plans generally have lower expense ratios. Over long periods, this cost gap can affect the final corpus.
Expense ratio
The scheme’s published NAV already reflects recurring fund expenses. A consistently expensive active fund should deliver sufficient value over a comparable lower-cost alternative.
Fund-manager and strategy changes
A 15-year track record may include several managers and investment styles. Historical rolling performance may not represent the team currently managing the scheme.
Portfolio concentration
Review exposure to major stocks, sectors, market-cap segments and credit instruments. Strong historical returns generated by concentrated bets may not be repeatable.
Downside behaviour
Check drawdowns and performance during difficult markets. A fund that loses less during major declines may be easier for investors to hold consistently.
Goal suitability
SEBI explains that mutual-fund schemes have stated objectives, and investors should select schemes whose objectives align with their own needs.
Common SIP Performance Analysis Mistakes
- Choosing a fund based only on the latest five-year return
- Comparing a mid-cap fund with a large-cap benchmark
- Using a price index instead of a Total Return Index
- Comparing direct-plan returns with regular-plan returns
- Ignoring expense ratios and exit loads
- Treating historical outperformance frequency as a future probability
- Looking only at the maximum return
- Ignoring the worst rolling period
- Assuming an SIP guarantees positive returns
- Reviewing funds every few weeks and switching repeatedly
- Ignoring changes in fund mandate or manager
- Selecting funds without connecting them to a financial goal
How Often Should You Review an SIP Fund?
A fund does not need to be replaced whenever it underperforms for a few months.
For a long-term equity goal, an annual structured review is generally more useful than daily or monthly monitoring. During the review, check:
- Whether the financial goal and time horizon have changed
- Whether the scheme still follows its stated mandate
- Whether its Riskometer remains suitable
- Whether rolling performance has weakened across several periods
- Whether benchmark underperformance is persistent
- Whether the manager or strategy has materially changed
- Whether the portfolio contains unnecessary fund overlap
One bad year is not automatically a reason to exit. Persistent weakness across complete market cycles deserves more attention than temporary underperformance during one market phase.
A Practical SIP Fund Evaluation Checklist
- Define the financial goal and required investment horizon.
- Select the correct mutual-fund category for that goal.
- Check the official Riskometer.
- Compare the fund with an appropriate TRI benchmark.
- Calculate three-year, five-year or longer rolling returns where appropriate.
- Review minimum, median and maximum rolling XIRR.
- Calculate benchmark outperformance consistency.
- Study weak-market performance and drawdowns.
- Check the expense ratio and plan type.
- Review the current fund manager, mandate and portfolio.
- Avoid selecting a fund solely because it tops one return table.
- Continue monitoring progress towards the target corpus.
Frequently Asked Questions
What are SIP rolling returns?
SIP rolling returns are annualised XIRR calculations for multiple SIP periods of equal duration but different starting dates. They show how investor outcomes changed across market conditions and provide a broader view than one trailing return.
Are rolling returns better than normal SIP returns?
They are more informative for analysing consistency because they examine many periods. However, they are not automatically predictive. A normal SIP XIRR remains accurate for the investor’s actual cash flows, while rolling returns are mainly an analytical tool.
What is a good SIP XIRR?
There is no universal good XIRR. The result should be judged against the fund category, benchmark, risk, investment horizon, inflation and return needed for the financial goal. A high return earned through excessive risk may not be suitable.
Can SIP rolling returns be negative?
Yes. Equity, hybrid and debt-fund SIPs can produce negative returns over unfavourable periods. Regular investing does not guarantee that the final value will always remain above the amount invested.
Should SIP returns be compared with CAGR?
XIRR is appropriate for an SIP because investments occur on multiple dates. CAGR is appropriate for one lump-sum investment. The two measures can be discussed together, but they do not represent identical cash-flow patterns.
Which benchmark should be used for SIP analysis?
Use the benchmark stated for the scheme or another index that accurately represents its category. The preferred comparison is generally a Total Return Index because it includes dividends.
Does a higher rolling outperformance score guarantee a better fund?
No. It only describes historical consistency during the period studied. Investors must also examine downside risk, expenses, portfolio concentration, manager changes and whether the scheme suits their goal.
Conclusion
SIP rolling returns offer a more complete way to evaluate mutual-fund performance because they reveal how results changed across different starting dates and market conditions.
The most useful analysis does not search for the highest return. It studies the full range of outcomes, compares the fund with an appropriate TRI benchmark and examines how often the fund delivered acceptable results without taking unreasonable risk.
Gyan Mela readers should use rolling returns as a diagnostic tool—not a prediction machine. Combine them with the Riskometer, expenses, portfolio quality, fund-manager stability and progress towards the actual financial goal.
Disclaimer: This article is intended for general informational and educational purposes only. It should not be treated as personalised financial or investment advice. Mutual-fund investments are subject to market risks, and past or rolling returns do not guarantee future performance. Investors should read official scheme documents and consult a SEBI-registered investment adviser where necessary.
Author: Gyan Mela Editorial Team
