Why a SIP needs XIRR, not CAGR
This is where most SIP comparisons go wrong before they begin.
In a SIP each instalment is invested for a different length of time. Money you put in last month has been working for a month; money from five years ago has been working for five years. A CAGR computed from total invested against final value treats every rupee as though it went in at the start, which materially misstates the return.
XIRR is the internal rate of return for cashflows on irregular dates, and it is the correct measure. A lumpsum has a single cashflow, so CAGR is fine there — which is exactly why comparing a SIP's mis-computed CAGR against a lumpsum's correct CAGR produces nonsense in both directions.
What rupee-cost averaging does, and does not, do
A SIP buys more units when NAV is low and fewer when it is high, so the average cost per unit comes in below the average NAV over the period. That is real and it is arithmetic.
What it is not is a return-enhancing mechanism. In a market that rises steadily, staggering entry means most of your money is invested for less time, and lumpsum wins — not because averaging failed, but because time in the market did the work. In a market that falls and recovers, the SIP accumulates units cheaply and comes out ahead.
So the comparison is really a question about the path the market took, which nobody knows in advance. Rupee-cost averaging reduces the consequence of being unlucky with timing. It does not create return.
Why trailing returns will mislead you
A fund's 3-year or 5-year trailing return depends heavily on where the window happens to end. A fund that ran hot in the final six months can show an excellent trailing number while having been mediocre for most of the period.
Rolling returns fix this: compute the return from every possible start date across a window — all 3-year periods in the last decade, say — and read the distribution. Median, worst case, and the share of windows that were negative tell you about consistency, which is what a SIP investor is actually exposed to, since a SIP experiences many start dates rather than one.
A fund with a strong trailing number and a wide rolling distribution was well positioned at the endpoint. That is not the same as being good.
The comparison most apps will not show you
Star ratings and category ranks compare a fund with its peers. The question they do not answer is whether the fund beat the benchmark it is supposed to beat — which is the only comparison that decides whether active management earned its fee.
A four-star fund can trail its own index for years, because the rating is relative to other funds in the category rather than to the index. Checking a scheme against its actual benchmark, on the same period and the same cashflow pattern, is the single most useful thing most investors are not doing.
The practical answer
If you are investing from income as it arrives, the question is moot — a SIP is the only option, and the discipline of automatic investment is worth more than any timing edge you would have failed to capture anyway.
If you genuinely have a lumpsum, the arithmetic favours deploying it, but the arithmetic ignores that a large single-date entry followed by a sharp drawdown is the most common reason people abandon a plan entirely. Staggering over a few months is a behavioural hedge with a small expected cost, and describing it honestly as that is more useful than pretending it raises returns.
Neither of these is advice — they are the trade-offs. The decision depends on your own circumstances, and FNOTrader does not give investment advice or recommend schemes.
Testing it on your own numbers
All of the above is testable on real data rather than argued about. FNOTrader's Mutual Funds app runs on the full AMFI NAV history — around 34 million NAV rows, refreshed nightly — and simulates SIP and lumpsum on any scheme and period, reporting XIRR, invested versus value, and maximum drawdown, plus rolling-return distributions and comparison against the benchmark that matters.
It is also reachable by asking, over MCP: "backtest a ₹10,000 monthly SIP in this fund from 2019 to today — XIRR and worst drawdown" is a sentence. Mutual fund tools are free on the MCP plan and consume no credits.
Public documentation, no login: the Mutual Funds user guide — every screen, and the published formulas behind the rolling-return table, the Health Score, capture ratios and the portfolio look-through.
Common questions
Is SIP better than lumpsum?
Lumpsum usually wins on paper in a rising market because more money is invested for longer; SIP wins when the market falls and recovers, and wins in practice for most people because they invest from income as it arrives. Rupee-cost averaging reduces the consequence of unlucky timing rather than creating return.
Why is XIRR used for SIP returns instead of CAGR?
Because each SIP instalment has been invested for a different length of time. A CAGR from total invested against final value treats every rupee as though it went in on day one, which misstates the return. XIRR is the internal rate of return for cashflows on irregular dates and is the correct measure.
What does rupee-cost averaging actually do?
It buys more units when NAV is low and fewer when it is high, so average cost per unit comes in below average NAV over the period. That is arithmetic, not a return-enhancing mechanism — in a steadily rising market staggered entry means less time in the market and a lower outcome.
Why are trailing returns misleading for mutual funds?
Because they depend heavily on where the window ends. A fund that ran hot in the last six months can show an excellent 3-year trailing number while having been mediocre for most of that period. Rolling returns across every start date show consistency instead.
Does a 4-star rating mean a fund beat its index?
No. Ratings and category ranks compare a fund with its peers, not with the benchmark it is meant to beat. A highly rated fund can trail its own index for years — checking the scheme against its actual benchmark over the same period is the comparison that decides whether active management earned its fee.
How can I test SIP versus lumpsum on a specific fund?
Simulate both on the scheme's actual NAV history over the same period, reporting XIRR for the SIP and CAGR for the lumpsum, alongside maximum drawdown for each. FNOTrader's Mutual Funds app does this on the full AMFI history, and the same is available by asking an AI assistant connected over MCP.
Related
App: Mutual Funds · Strategies: Options School (free, no login) · Definitions: trading glossary · Free tools: position sizing & risk calculators · More: all articles