MF Returns Calculator: How to Compare Lumpsum and SIP Returns on the Same Fund

Two investors put ₹12,00,000 into the exact same mutual fund over the same 10-year period, one as a single lumpsum on day one, the other spread across ₹10,000 monthly SIP instalments. Assuming the fund grew at a smooth, steady rate the entire time, one of them ended up with a meaningfully larger corpus than the other, and it's worth understanding exactly why before assuming SIP always wins.

How to calculate mutual fund returns for each approach #

Lumpsum: A single amount invested once, compounding for the entire holding period.

Future value = Principal × (1 + rate)^years

SIP: A fixed amount invested every month, where each instalment compounds only for its own remaining time in the market.

Future value = Instalment × [((1+r)^n − 1)/r] × (1+r), where r is the monthly rate and n is the number of instalments.

Worked example: ₹12,00,000 total invested, 10 years, 12% annual return #

Lumpsum: ₹12,00,000 invested on day one

• Future value after 10 years at 12%: ≈ ₹37,27,018

SIP: ₹10,000 a month for 10 years (120 instalments totaling ₹12,00,000)

• Future value after 10 years at 12%: ≈ ₹23,23,391

Under this smooth, constant-return assumption, lumpsum comes out ahead by roughly ₹14,03,627. This surprises a lot of people who've heard "SIP is better" as an unqualified rule, so it's worth understanding exactly why the gap exists here.

Why lumpsum wins under a constant-growth assumption #

In this comparison, every rupee of the lumpsum starts compounding on day one and enjoys the full 10 years of growth. The SIP's later instalments, by contrast, have much less time to compound, the 120th instalment only gets 1 month of growth before the 10-year mark, while the lumpsum's entire ₹12 lakh has been growing the whole time. Under a smooth, ever-rising market, more time invested always wins, and lumpsum simply has more time invested per rupee.

Why real markets often favor SIP anyway #

The comparison above assumes a perfectly smooth 12% annual return, which real markets never actually deliver. Real markets move up and down unevenly, and a lumpsum invested right before a downturn can take years to recover, while an SIP investing through that same downturn buys more units when prices are low, a mechanism called rupee-cost averaging. This is where SIP's real-world advantage tends to show up, not in a smooth market, but specifically in a volatile one where entry timing genuinely matters.

So which should you actually choose? #

• If you have a lumpsum available and a long horizon, and you're comfortable with volatility, investing it directly (or via a short STP to spread entry risk over a few months) often captures more of the market's long-term upward trend than delaying deployment.
• If you're building wealth from regular income rather than a windfall, SIP is the natural and only realistic option, since you don't have a lumpsum to begin with.
• If you have a lumpsum but are nervous about a market top, an STP over 6 to 12 months offers a middle ground, smoothing entry risk somewhat while still getting most of the money invested relatively soon.

What a volatile market comparison actually looks like #

To see rupee-cost averaging in action, imagine the same fund instead of growing smoothly, drops 20% in year 3, then recovers and continues its long-term trend. A lumpsum invested right before that drop takes the full hit on the entire ₹12,00,000 at once, and needs the recovery to climb back to breakeven before any further gains count. An SIP investor, by contrast, is still contributing new instalments during the dip, buying units at the lower price, which then benefit disproportionately once the recovery happens. This is the scenario where SIP's averaging genuinely earns its reputation, not the smooth constant-growth case used for the simpler comparison above, but a realistically bumpy one where entry timing would otherwise have mattered a great deal.

Common mistakes when comparing SIP and lumpsum #

1. Assuming SIP always outperforms lumpsum. As this example shows, under a smooth constant return, lumpsum wins simply due to more time invested. SIP's advantage is specifically about managing volatility and entry timing, not a guaranteed higher return in all conditions.
2. Comparing SIP and lumpsum returns using absolute return instead of annualized return (XIRR). Since the two approaches invest money at different times, only an annualized, time-weighted measure like XIRR gives a fair comparison.
3. Ignoring your own cash flow reality. The "better" option is often decided by whether you actually have a lumpsum available, not by abstract return comparisons alone.
4. Not accounting for the psychological difference. A lumpsum investor watching a single large sum swing with the market can panic-sell more easily than an SIP investor who's mentally used to seeing monthly ups and downs in smaller amounts.

Tips for making the right choice for your situation #

• Use XIRR, not absolute return, to compare any scenario where money goes in at different times, since it properly accounts for the timing of each cash flow.
• Consider your own risk tolerance for market timing, not just the theoretical math, when deciding between a lumpsum, an STP, or a straightforward SIP.
• Don't let a windfall sit in a savings account indefinitely while deciding, since idle cash earns close to nothing while you deliberate, and an STP can start protecting some of that opportunity cost immediately.
• Track your actual returns periodically using the fund's real NAV history rather than assuming a constant rate, since real returns are always uneven even when the long-term average looks smooth in hindsight.

Compare your own numbers with the MF returns calculator, and check a real example like a ₹5,000 monthly SIP over 10 years or a ₹1,00,000 lumpsum over 5 years to see the numbers for your own investment horizon.

Frequently asked questions #

Does SIP always give better returns than lumpsum? #

No. Under a smooth, constantly rising market, lumpsum invested on day one generally outperforms an SIP of the same total amount, since it has more time compounding. SIP's real advantage shows up in volatile markets, where spreading entry points reduces the risk of investing everything right before a downturn.

How do I fairly compare SIP and lumpsum returns? #

Use XIRR (extended internal rate of return) rather than absolute return or simple CAGR, since XIRR properly accounts for the fact that SIP instalments and a lumpsum investment enter the market at different times.

Should I invest a bonus as a lumpsum or spread it via SIP? #

It depends on your risk tolerance and market outlook. Investing directly captures more time in the market if it continues rising, while spreading it via an STP over 6 to 12 months reduces the risk of unlucky timing, at the cost of some of that lumpsum sitting in lower-yielding debt temporarily.

Is it possible to combine both approaches? #

Yes, many investors deploy part of a lumpsum immediately and spread the remainder via STP, balancing the time-in-market advantage of lumpsum investing against the entry-risk protection of a staggered approach.

Use the MF returns calculator to run your own SIP versus lumpsum comparison, and remember that the "better" choice depends as much on your own cash flow and risk tolerance as it does on the pure math.