SIP Calculator Formula Explained: The Math Behind Your Returns

If you have ever stared at a SIP calculator result wondering “where did that number come from?” — you are not alone. The ₹23 lakh corpus that pops up when you enter ₹10,000 monthly for 10 years at 12% is not a marketing guess; it is the output of a precise mathematical formula rooted in the future value of annuity theory. Once you understand the SIP calculator formula, you gain the power to verify any projection, build your own spreadsheet, and plan your mutual fund investments with full transparency.

In this article, we will break down the exact SIP calculator formula, derive it from first principles, walk through multiple worked examples, compare it with Excel’s built-in FV function, and explore how step-up SIPs modify the calculation. By the end, the math behind your returns will feel as natural as balancing your monthly budget, and you will never have to take a calculator’s output on blind faith again.

The SIP Calculator Formula: FV = P × [((1 + i)^n - 1) / i] × (1 + i)

Here is the formula every SIP calculator on the planet uses (or should use) to project your mutual fund corpus:

FV = P × [((1 + i)^n - 1) / i] × (1 + i)

Where each variable represents a specific input from your investment plan:

• FV (Future Value): The total corpus you accumulate at the end of your investment tenure. This is the headline number the calculator shows you, representing principal plus all compounded returns.
• P (Monthly Investment): The fixed amount you invest each month, in rupees. For a ₹10,000 SIP, P = 10000.
• i (Monthly Interest Rate): The expected annual return divided by 12 and by 100. If you assume 12% annual returns, i = 12 ÷ 12 ÷ 100 = 0.01 (or 1% per month).
• n (Number of Months): Total number of SIP installments. For a 10-year SIP, n = 10 × 12 = 120.

The expression ((1 + i)^n - 1) / i is called the future value of annuity factor, and the trailing (1 + i) multiplier converts it from “ordinary annuity” (end-of-period payments) to “annuity due” (beginning-of-period payments). In Indian mutual fund SIPs, money is typically auto-debited at the start of each month, so the annuity-due version is the more accurate model and the one used by quality calculators like ours.

Deriving the Formula from Compound Interest

To truly understand the SIP calculator formula, let’s derive it from the basic compound interest formula you likely learned in school: FV = PV × (1 + r)^n. This formula tells you the future value of a single lumpsum invested today, compounded at rate r for n periods.

In a SIP, you do not invest one lumpsum. You invest P rupees every month. So imagine we treat each monthly installment as a separate lumpsum investment, each compounding for a different number of months:

• First installment (month 1): compounds for n months → FV₁ = P × (1 + i)^n
• Second installment (month 2): compounds for n-1 months → FV₂ = P × (1 + i)^(n-1)
• Third installment (month 3): compounds for n-2 months → FV₃ = P × (1 + i)^(n-2)
• … and so on until
• Last installment (month n): compounds for 1 month → FVₙ = P × (1 + i)^1

Adding all these up: FV = P × [(1+i)^n + (1+i)^(n-1) + (1+i)^(n-2) + … + (1+i)^1]

This is a geometric series with first term (1+i), common ratio (1+i), and n terms. Applying the geometric series sum formula S = a × (r^n - 1) / (r - 1), we get:

FV = P × (1+i) × [((1 + i)^n - 1) / i]

And there it is — the SIP calculator formula, derived from first principles. The (1+i) out front appears because the last installment compounds for one month (not zero), making this an annuity due rather than an ordinary annuity. If your SIP was auto-debited at month-end instead of month-start, that final multiplier would disappear, and your corpus would be slightly smaller.

Worked Example 1: ₹10,000/month for 10 Years at 12%

Let’s plug in real numbers that any Indian investor might use. P = ₹10,000, annual return = 12%, tenure = 10 years.

• i = 12 ÷ 12 ÷ 100 = 0.01
• n = 10 × 12 = 120
• (1 + i)^n = (1.01)^120 = 3.3004
• ((1 + i)^n - 1) ÷ i = (3.3004 - 1) ÷ 0.01 = 230.04
• × (1 + i) = 230.04 × 1.01 = 232.34
• FV = ₹10,000 × 232.34 = ₹23,23,376

Your total invested amount = ₹10,000 × 120 = ₹12,00,000. Wealth gain = ₹11,23,376. This matches what any reliable SIP calculator (including ours) will show. Verify it on our SIP calculator to confirm the formula’s accuracy.

Worked Example 2: ₹5,000/month for 20 Years at 10%

Now a longer-horizon, more conservative example that reflects a typical middle-class Indian investor’s plan. P = ₹5,000, annual return = 10%, tenure = 20 years.

• i = 10 ÷ 12 ÷ 100 = 0.008333
• n = 20 × 12 = 240
• (1 + i)^n = (1.008333)^240 = 7.3281
• ((1 + i)^n - 1) ÷ i = (7.3281 - 1) ÷ 0.008333 = 759.37
• × (1 + i) = 759.37 × 1.008333 = 765.69
• FV = ₹5,000 × 765.69 = ₹38,28,467

You invested ₹12,00,000 total (₹5,000 × 240), and your wealth gain is ₹26,28,467. Notice that even though both Example 1 and Example 2 invested the same ₹12 lakh total, the 20-year SIP produced a corpus 65% larger than the 10-year SIP — purely because of the longer compounding horizon. This is why financial planners say “time in the market beats timing the market,” and why starting early matters far more than the absolute amount you invest.

Worked Example 3: ₹25,000/month for 15 Years at 14%

A more aggressive scenario for high-income professionals in metros. P = ₹25,000, annual return = 14%, tenure = 15 years.

• i = 14 ÷ 12 ÷ 100 = 0.011667
• n = 15 × 12 = 180
• (1 + i)^n = (1.011667)^180 = 8.158
• ((1 + i)^n - 1) ÷ i = (8.158 - 1) ÷ 0.011667 = 613.55
• × (1 + i) = 613.55 × 1.011667 = 620.71
• FV = ₹25,000 × 620.71 = ₹1,55,17,750

Invested = ₹45,00,000. Wealth gain = ₹1,10,17,750. Notice how a 4-point jump in return rate (from 10% to 14%) and 5 extra years turned a ₹38 lakh corpus into a ₹1.55 crore corpus — a 4× amplification. But beware: assuming 14% returns is optimistic for equity funds over 15 years, even with strong historical precedents. Use 11-12% for conservative planning to avoid under-saving for critical goals.

Comparing with Excel’s FV Function

Microsoft Excel and Google Sheets both have a built-in FV function that does exactly what a SIP calculator does. The syntax is:

=FV(rate, nper, pmt, [pv], [type])

For our Example 1 (₹10,000, 10 years, 12%), the formula is:

=FV(12%/12, 120, -10000, 0, 1)

• rate = 12%/12 = 1% per month (matches our i)
• nper = 120 months (matches our n)
• pmt = -10000 (negative because it’s a cash outflow from your pocket)
• pv = 0 (no initial lumpsum)
• type = 1 (payments at beginning of period — this triggers the annuity-due mode)

Excel returns ₹23,23,376 — identical to our manual calculation. If you set type=0 (end of period), Excel returns ₹23,00,373 — the ordinary annuity version, which is ₹23,003 less. This confirms that quality SIP calculators (and our manual formula) use the annuity-due convention to match how real SIPs work in India. For investors who prefer spreadsheets, our SIP calculator Excel tutorial walks through building a full SIP calculator from scratch in Excel.

How Step-Up SIP Changes the Calculation

A flat SIP assumes the same P every month for the entire tenure. A step-up SIP increases P annually — typically by 10% — to mirror your salary growth. The formula for step-up SIP is more complex because P changes each year, but conceptually it is the sum of multiple one-year SIP annuities, each with a different P and a different remaining compounding period.

For example, a ₹10,000 SIP with 10% annual step-up for 5 years would compute:

• Year 1: 12 monthly investments of ₹10,000 each, compounding for 60 down to 49 months
• Year 2: 12 monthly investments of ₹11,000 each, compounding for 48 down to 37 months
• Year 3: 12 monthly investments of ₹12,100 each, compounding for 36 down to 25 months
• Year 4: 12 monthly investments of ₹13,310 each, compounding for 24 down to 13 months
• Year 5: 12 monthly investments of ₹14,641 each, compounding for 12 down to 1 months

Summing all these gives the step-up corpus. The math is tedious but mechanical — exactly the kind of repetitive computation a calculator handles flawlessly. Our step-up SIP calculator performs this entire computation in milliseconds, showing you how a 10% annual top-up can boost your final corpus by 30-50% over 15-20 years. For a deeper comparison, see our step-up SIP vs regular SIP guide.

Important Caveats: Taxes, Expense Ratios, and Real Returns

The SIP calculator formula gives you the gross maturity value before taxes and fund expenses. In reality, your net wealth will be slightly lower due to three factors. First, the mutual fund’s expense ratio (typically 0.5-1.5% for equity funds) is already deducted from the NAV, so the CAGR you see on the fund fact sheet is post-expense — meaning your “12% expected return” assumption should already account for this. Second, long-term capital gains above ₹1.25 lakh per financial year on equity funds are taxed at 12.5% under current Indian tax rules (as of 2025), reducing your net corpus.

Third, inflation erodes the real purchasing power of your corpus. A ₹1 crore corpus in 20 years will only have the purchasing power of about ₹31 lakh in today’s money, assuming 6% inflation. This is why financial planners recommend pairing your SIP calculator projections with an inflation-adjusted SIP calculator to see your real wealth in today’s terms. Understanding these caveats prevents you from celebrating a ₹1 crore projection that, in real terms, may only fund a modest retirement.

Conclusion: Formula is the Foundation, Calculator is the Engine

The SIP calculator formula — FV = P × [((1 + i)^n - 1) / i] × (1 + i) — is the single most important equation in personal finance for Indian investors. It captures the precise mathematical relationship between your monthly investment, your expected return, your time horizon, and the wealth you will accumulate. Deriving it from first principles reveals why compounding is exponential, why time matters more than amount, and why beginning-of-month SIPs outperform end-of-month models.

Now that you understand the formula inside out, put it to work. Use our SIP calculator to model your investment plan, experiment with different return rates and tenures, and watch the formula in action. If you want to learn more about the broader mechanics of how these calculators work behind the scenes, read our How SIP Calculator Works guide. The math is clear — your wealth is waiting to be planned and built, one compounding month at a time.