The Mathematics of Wealth: The SIP Return Formula

When you use an online SIP Calculator, you enter three numbers:

  1. Monthly Investment Amount (₹)
  2. Expected Annual Return (% p.a.)
  3. Investment Tenure (Years)

Within milliseconds, the tool calculates your total invested capital, estimated gains, and final maturity corpus. But what mathematical equation runs under the hood?

Let’s unpack the exact SIP formula, understand why standard compound interest equations don’t apply to periodic deposits, and walk through a step-by-step manual calculation.

1. The Standard Compound Interest Formula vs The SIP Formula

A common beginner mistake is using the basic compound interest formula: $$A = P \times (1 + r/n)^{nt}$$

This formula only works for one-time Lumpsum deposits where a single principal amount $P$ sits uninterrupted for $t$ years.

In an SIP, you deposit money in recurring periodic installments. The first deposit compounds for the full tenure (e.g. 120 months), the second deposit compounds for 119 months, the third for 118 months, and the final installment compounds for just 1 month.

Therefore, an SIP represents an Annuity Due (cash inflows occurring at the beginning of each payment interval).

2. The Core Mathematical SIP Formula

The standard financial formula for calculating future maturity value ($M$) of an SIP is:

$$\mathbf{M = P \times \left[ \frac{(1 + i)^n - 1}{i} \right] \times (1 + i)}$$

Where:

  • $M$ = Final Maturity Corpus (Total Accumulated Portfolio Value)
  • $P$ = Monthly SIP Installment Amount (Principal deposited periodically)
  • $i$ = Periodic Monthly Return Rate
  • $n$ = Total Number of Monthly Installments ($Tenure\ in\ Years \times 12$)

3. How to Calculate the Periodic Monthly Rate ($i$)?

The expected return rate (e.g., 12% p.a.) is annualized. To calculate compounding on monthly cycles:

$$i = \frac{r}{12 \times 100}$$

For an expected annual return of 12% p.a.: $$i = \frac{12}{1200} = 0.01\ \text{per month (1% monthly)}$$

This calculator uses the nominal monthly conversion: annual rate divided by twelve. At 12%, that is 1% monthly, or about 12.68% effective annual growth. To model exactly 12% effective annual growth, use (1.12)^(1/12) - 1, about 0.9489% monthly. Calculators can use different conversions and payment timing; compare their assumptions before comparing results. See our calculation methodology.

4. Step-by-Step Worked Example (₹10,000 / Month for 10 Years at 12%)

Let’s solve a real investment scenario manually:

  • Monthly Deposit ($P$): ₹10,000
  • Expected Return ($r$): 12% per year
  • Tenure: 10 Years
  • Total Installments ($n$): $10 \times 12 = \mathbf{120\ \text{months}}$
  • Monthly Rate ($i$): $12 / 1200 = \mathbf{0.01}$

Step 1: Calculate the Compounding Factor $(1 + i)^n$

$$(1 + 0.01)^{120} = (1.01)^{120} \approx \mathbf{3.30038689}$$

Step 2: Apply the Annuity Numerator

$$(1 + i)^n - 1 = 3.30038689 - 1 = \mathbf{2.30038689}$$

Step 3: Divide by Monthly Rate ($i$)

$$\frac{2.30038689}{0.01} = \mathbf{230.038689}$$

Step 4: Multiply by Advance Payment Factor $(1 + i)$

$$230.038689 \times (1 + 0.01) = 230.038689 \times 1.01 = \mathbf{232.339076}$$

Step 5: Multiply by Monthly Deposit ($P$)

$$M = 10,000 \times 232.339076 = \mathbf{₹23,23,391}$$

Summary of Results:

  • Total Capital Invested: ₹10,000 × 120 = ₹12,00,000 (₹12 Lakhs)
  • Estimated Net Capital Gains: ₹23,23,391 - ₹12,00,000 = ₹11,23,391
  • Final Maturity Corpus: ₹23.23 Lakhs

Test this exact calculation live on our online SIP Calculator to view the dynamic doughnut chart and year-by-year compounding schedule.

5. How to Calculate SIP in Excel or Google Sheets?

If you prefer building your own financial spreadsheet, Microsoft Excel and Google Sheets offer the built-in =FV (Future Value) formula:

=FV(rate / 12, nper * 12, -pmt, 0, 1)

Formula Parameters:

  • rate / 12: Your annual expected rate divided by 12 (e.g., 12% / 12 or 0.01)
  • nper * 12: Tenure in years multiplied by 12 (e.g., 10 * 12 or 120)
  • -pmt: Monthly SIP amount entered as a negative number to denote cash outflow (e.g., -10000)
  • 0: Present value before starting (0 if starting with zero initial balance)
  • 1: Crucial! Specifies payment made at the beginning of the period (Annuity Due)

6. What About XIRR vs CAGR in SIPs?

When reviewing mutual fund account statements after investing:

  • CAGR (Compound Annual Growth Rate): Does not account for periodic monthly installments. It only measures point-to-point performance between two dates.
  • XIRR (Extended Internal Rate of Return): The true real-world rate of return for an SIP. It assigns an individual timestamp to every monthly SIP debit and cash dividend, calculating the precise annualized yield of your portfolio.

👉 Ready to explore more calculations?