RebotaREBOTA/Works Search tools, standards, templates… Ctrl K Rebota →
Calculators Standards Templates Checklists Estimators Learn Community Search Rebota (business platform) →
Guide

How SIP Returns Are Calculated — The Formula Behind Every SIP Calculator

The maths of monthly investing, what compounding really does over 20 years, and the assumptions that make projections look better than reality.

₹10,000/month, 12%, 10 yrs
≈ ₹23.2 lakh
Amount invested
₹12 lakh
Formula
Future value of an annuity due

Key Takeaways

  • SIP value = P × [((1 + i)^n − 1) ÷ i] × (1 + i), with i the monthly rate.
  • Time matters more than rate: doubling the period more than triples the corpus at 12%.
  • Real returns vary year to year; projections assume a constant rate.
  • Measure actual SIP performance with XIRR, not absolute return.

The SIP formula

FV = P × [((1 + i)n − 1) ÷ i] × (1 + i)

P is the monthly instalment, i the expected annual return ÷ 12, and n the number of months. The extra (1 + i) is there because each instalment is invested at the start of the month.

Worked example

₹10,000 a month at 12% for 10 years: i = 0.01, n = 120. (1.01)120 = 3.300, so FV = 10,000 × 230.04 × 1.01 = ₹23.23 lakh on ₹12 lakh invested. Over 20 years the same SIP grows to about ₹99.9 lakh on ₹24 lakh invested.

Open the SIP Calculator →

Step-up SIPs

Raising the instalment 10% each year, in line with salary, roughly doubles the final corpus over 20 years at 12% — about ₹1.99 crore versus ₹99.9 lakh for a flat ₹10,000 SIP.

Why actual returns differ

Markets do not deliver a steady 12%. A SIP buys more units when prices fall (rupee-cost averaging), so the sequence of returns changes the outcome. Expense ratios, exit loads and capital gains tax (12.5% LTCG above ₹1.25 lakh on equity) also reduce what you keep.

SIP vs lump sum

A lump sum invested at the start compounds for longer, so it usually ends higher in a rising market. SIPs reduce timing risk and fit monthly income. Compare both with the lumpsum calculator.

Action Checklist

  • Use a conservative return (10–12% equity, 7% debt)
  • Add a yearly step-up
  • Track actual performance with XIRR
  • Plan withdrawals with the SWP calculator

Related Intelligence

Frequently Asked Questions

What will ₹5,000 SIP give in 15 years?▾
At 12% a year, about ₹25.2 lakh on ₹9 lakh invested.
Is SIP return guaranteed?▾
No. Mutual fund SIPs are market-linked; calculators show an illustration at an assumed constant rate.
How is SIP return calculated in practice?▾
With XIRR, which accounts for the date and amount of every instalment and the current value.
Is SIP better than FD?▾
Equity SIPs have historically beaten FDs over long periods but carry market risk; FDs are fixed and suit short horizons.
Save & Access Anywhere
Save your favorite tools & resources
Smart Search (Ctrl+K)
Find what you need in seconds
Community Support
Ask questions & get real answers
Regularly Updated
New tools, templates & guides added
Run a business? Keep its money this organised.Rebota puts invoices, expenses, cash flow and accounts on one ledger, so you always know what the business can set aside.
Start a free 15-day trial →