NeehaRams

SIP & Lumpsum Calculator

A SIP pays a fixed sum into a fund on the same date every month; a lumpsum puts the whole amount in at once. This projects either, or both together, with an optional yearly step-up — and runs the same maths backwards to size the instalment a target needs.

What a SIP actually is

A Systematic Investment Plan is a standing instruction: the same amount, into the same fund, on the same date each month. The fund allots units at that day's NAV, so a fixed rupee sum buys more units when the price is down and fewer when it is up. That is the whole mechanism. It is not a product, and it is not a fund — it is how you pay into one you have already picked.

A lumpsum is the other way of paying in: everything at once, exposed to whatever happens from that day forward. Neither is better in the abstract. A lumpsum has more time in the market; a SIP spreads entry across many prices, which cushions a bad start and dilutes a good one.

How the projection is built

Each instalment is treated as arriving at the start of its month and earning that month's return — an annuity due. The monthly rate is a twelfth of the annual rate, and the balance rolls forward one month at a time. Running it that way means a stepped SIP and a flat one are computed by the same loop, so they never disagree at the edges.

20 years at 12% a year, no step-up
Monthly SIPTotal investedValue at the end
₹5,000₹12.00L₹49.96L
₹10,000₹24.00L₹99.91L
₹25,000₹60.00L₹2.50Cr
₹50,000₹1.20Cr₹5.00Cr
₹1,00,000₹2.40Cr₹9.99Cr

The ratio between the last two columns is identical on every row, because the maturity value is directly proportional to the instalment. That proportionality is also why solving for a target is exact here rather than searched for: the required SIP is the target divided by what one rupee a month would have become.

Time does more than the rate

Two things drive the outcome, and they do not contribute equally. Extending the term adds instalments and gives every earlier one longer to compound; raising the assumed return only does the second. Across a long horizon the first effect dominates.

₹25,000 a month, at three different annual returns
DurationInvested8%10%12%
5 years₹15.00L₹18.49L₹19.52L₹20.62L
10 years₹30.00L₹46.04L₹51.64L₹58.08L
15 years₹45.00L₹87.09L₹1.04Cr₹1.26Cr
20 years₹60.00L₹1.48Cr₹1.91Cr₹2.50Cr
25 years₹75.00L₹2.39Cr₹3.34Cr₹4.74Cr
30 years₹90.00L₹3.75Cr₹5.70Cr₹8.82Cr

In the early rows the value sits close to what was paid in, because most instalments are only a year or two old. Further down, the gap between the invested column and the value columns is almost entirely growth on earlier instalments rather than new money.

What a step-up changes

A step-up raises the instalment on a fixed cycle — by a percentage of the current amount or by a flat addition. The first raise lands after one complete cycle, so with a yearly step-up, months one to twelve pay the base figure and month thirteen pays the first increase.

Starting at ₹25,000 a month for 20 years at 12%
Yearly step-upTotal investedValue at the end
None₹60.00L₹2.50Cr
5%₹99.20L₹3.43Cr
10%₹1.72Cr₹4.97Cr

Each raise compounds on the one before it, and every raised instalment then compounds for the remaining years. That is two geometric series stacked, which is why a step-up that sounds modest moves the closing figure so far.

Lumpsum, and the two together

A lumpsum projection is the simplest case on this page: one amount, compounded for the whole term. ₹10,00,000 at 12% becomes ₹96.46L over 20 years with nothing added.

Running both at once is the common real case — an existing holding plus a monthly contribution. The calculator adds the two projections, and in target mode it grows the lumpsum forward first and sizes the SIP against whatever the target still lacks.

What these figures leave out

  • Everything here is pre-tax. Equity gains are taxed on redemption, not while invested.
  • A single flat return stands in for every year. Real returns arrive in an order, and the order matters — most of all once withdrawals begin.
  • Expense ratios, exit loads and the gap between a fund and its index are not priced.
  • A real SIP buys on a specific date at that day's NAV, so actual units depend on the path the price took rather than its average.
  • The maturity figure is in future rupees unless you state the target in today's money and let it inflate forward.

Frequently asked questions

What is a SIP?

A Systematic Investment Plan is a standing instruction to put a fixed sum into a mutual fund on the same date every month. The fund allots units at that day’s NAV, so the same rupee amount buys more units when the price is low and fewer when it is high. Nothing about it is a product in its own right — it is a way of paying into a fund you have already chosen.

Is a SIP or a lumpsum better?

They answer different situations rather than competing. A lumpsum puts the whole amount to work immediately, so it is exposed to everything that happens from day one. A SIP spreads entry across many prices, which softens a bad start and dilutes a good one. The calculator runs either, or both together, and shows the totals side by side rather than picking one.

How is the SIP maturity value calculated here?

Each instalment is treated as going in at the start of the month and earning that month’s return — an annuity due. The monthly rate is a twelfth of the annual rate, and the balance rolls forward as balance plus instalment, grown by one month. A step-up simulation and a flat projection therefore agree with each other exactly.

What does the step-up option do?

It raises the instalment on a fixed cycle, either by a percentage of the current amount or by a flat rupee addition. The first raise lands after one full cycle, so with a yearly step-up months one to twelve pay the base amount and month thirteen pays the first increase. Raising a SIP in step with your salary is the usual reason to use it.

Why does a small step-up change the final figure so much?

Because every raise compounds on the one before it, and each raised instalment then compounds for the rest of the term. A percentage step-up applied for twenty years is a geometric series sitting on top of a geometric series. The effect is largest early, since those instalments have the longest left to grow.

What return rate should I assume?

There is no rate that is correct in advance. Indian equity indices have delivered long-run returns in the low teens over multi-decade windows, with individual five-year stretches ranging from negative to far above that. The slider matters more than the number you settle on: moving it a point or two shows how much of the projection is assumption rather than arithmetic.

Does the projection account for inflation?

The maturity figure itself is in future rupees. When you solve for a target, the target basis toggle lets you state the goal in today’s money and have it inflated forward, which is the honest way to size a goal that is years out. A figure that looks large in future rupees can be ordinary once inflation is taken out of it.

Are returns and tax the same thing here?

No — the projection is pre-tax. Equity mutual fund gains are taxed when units are redeemed, so nothing is deducted while the money is invested. The SWP calculator prices the redemption side, including FIFO lots and the yearly long-term exemption.

What does "solve for a target" do?

It runs the same maths backwards. Instead of asking what a known instalment grows into, it asks what instalment reaches a known target — or, in lumpsum mode, what single amount does. Because the maturity value is directly proportional to the instalment, the answer is exact rather than searched for.

Can I include money I have already invested?

Yes. In target mode there is a field for a lumpsum you already hold. It is grown forward at the same expected return and subtracted from the target, so the SIP only has to build whatever is still missing.

Does this match what my fund house shows?

It will be close but rarely identical. This treats instalments as landing at the start of each month at a single flat return. A real SIP buys on a specific date at that day’s NAV, so the actual units bought depend on the path the price took, not just its average. Expense ratios and exit loads are also not priced here.

What is XIRR, and is that what this shows?

XIRR is the annualised return implied by a series of cash flows on their actual dates, which is the right measure when money goes in at many different times. This calculator works the other way round — you supply a return and it projects a value. The portfolio benchmark tool is where real NAV history gets turned into an XIRR.

What happens if I stop a SIP partway?

The instalments already made stay invested and keep compounding; only the future ones stop. The calculator assumes an unbroken run, so a paused SIP will finish below the projection by roughly the value the missed instalments would have grown into.

Does the duration slider mean years of investing or years of holding?

Years of investing. Instalments continue for the whole period, and the value is read at the end of it. Holding a completed SIP for further years without adding to it is a lumpsum projection on the closing balance.

Everything else here

  • SWP & Tax Calculator — How long a corpus lasts under monthly withdrawals — with FIFO capital-gains tax, the ₹1.25 lakh exemption and a replay against real Indian index history.
  • Retirement Calculator — Find the corpus your expenses need after inflation and the monthly SIP that builds it, then stress-test that corpus against real Indian market history.
  • 3-Bucket Retirement Strategy — Split a retirement corpus into safety, stability and growth buckets, run the refills month by month, and compare it against holding one pot.
  • SIP + SWP Calculator — Run a SIP and an SWP as one plan: pay in weekly to yearly, draw out on any schedule, and see how long the corpus lasts after capital-gains tax.
  • Loan Prepayment Calculator — See what extra money put into a home loan really buys: interest saved, months cut, and whether investing it instead would leave you better off.
  • Portfolio Benchmark Comparison — Backtest multi-fund portfolios against NIFTY total-return indices: rolling returns, volatility, drawdown and SIP or lumpsum growth over real NAV history.
  • Govt. Scheme Calculators — Calculate PPF, SSY, NSC, KVP, EPF, NPS, APY, PM-SYM, PM-KMY, SCSS and Post Office savings, RD, TD and MIS outcomes with clear India-specific formulas.
  • Interest & CAGR Calculator — Compare simple against compound interest on one deposit at any compounding frequency, and find the CAGR between two amounts — by duration or by dates.
  • FIRE Calculator — When could you stop working? All five FIRE numbers — Lean, Traditional, Fat, Coast and Barista — with Indian inflation, healthcare and capital-gains tax.
  • Financial Goal Calculator — Price a home, education, car or any goal at its future cost and see the monthly SIP, lump sum or time it takes — with inflation, step-up and many goals.