SIP Maturity Formula Explained: Annuity Math, Step-Up SIPs, XIRR, and Taxation

What a SIP Actually Is

A Systematic Investment Plan is not a product. It is a schedule: a fixed amount debited at a fixed interval and used to buy units of a mutual fund at that day’s net asset value. The fund is the product; the SIP is the discipline wrapped around it.

Two mechanical effects come out of that schedule:

1. Rupee cost averaging. A fixed rupee amount buys more units when the NAV is low and fewer when it is high, so the average cost per unit ends up below the average NAV over the period. This reduces the penalty for poor entry timing; it does not eliminate market risk.
2. Compounding over unequal holding periods. Your first instalment compounds for the full tenure. Your last instalment compounds for one month. The maturity value is the sum of many differently aged growth curves — which is exactly what the annuity formula computes in closed form.

What you get from this guide: the formula and its derivation, the step-up variant, an honest account of why projections and reality diverge, and the tax treatment that determines what you actually keep.

Deriving the Formula

Each instalment P invested at the start of a month grows for the remaining months at the periodic rate i. With n instalments:

M = P(1+i)^n + P(1+i)^(n-1) + … + P(1+i)^1

That is a geometric series with first term P(1+i) and ratio (1+i). Summing it gives the future value of an annuity due:

M = P × [ ((1 + i)^n − 1) / i ] × (1 + i)

Worked example

₹10,000 per month for 15 years at an expected 12% annual return:

i = 0.12 / 12 = 0.01
n = 15 × 12   = 180

(1.01)^180        ≈ 5.995802
((1.01)^180 − 1)/0.01 ≈ 499.5802
× (1.01)              ≈ 504.5760

M ≈ 10,000 × 504.5760 ≈ ₹50,45,760
Invested             = 10,000 × 180 = ₹18,00,000
Gain                 ≈ ₹32,45,760

Roughly 64% of the terminal value is growth rather than contribution — and that share rises steeply with tenure, which is the entire argument for starting early.

// Annuity-due future value. Handles i = 0 without dividing by zero.
function sipMaturity(monthly, annualRatePct, years) {
  const i = annualRatePct / 12 / 100;
  const n = Math.round(years * 12);
  if (i === 0) return monthly * n;
  return monthly * ((Math.pow(1 + i, n) - 1) / i) * (1 + i);
}

Tenure dominates everything

₹10,000 per month at 12%:

Values rounded to the nearest thousand. Doubling the tenure from 10 to 20 years does not double the outcome — it roughly quadruples it.

Step-Up SIP: Matching Contributions to Income

A flat instalment held for 20 years ignores salary growth. A step-up (or top-up) SIP raises the instalment by a fixed percentage each year. The closed form is a sum over annual blocks:

M = Σ (k = 0 … Y−1)  P × (1+g)^k × [ ((1+i)^12 − 1)/i ] × (1+i) × (1+i)^(12 × (Y−1−k))

where g is the annual step-up rate and Y the number of years. In code it is clearer as a loop:

function stepUpSipMaturity(monthly, annualRatePct, years, stepUpPct) {
  const i = annualRatePct / 12 / 100;
  const g = stepUpPct / 100;
  let value = 0;
  let instalment = monthly;

  for (let year = 0; year < years; year++) {
    for (let month = 0; month < 12; month++) {
      value = (value + instalment) * (1 + i);   // invest at start, then grow
    }
    instalment *= 1 + g;
  }
  return value;
}

The effect of a 10% annual step-up, starting at ₹10,000 per month, 12% expected return:

Values rounded to the nearest thousand and dependent on the assumed rate. The direction is the point: a step-up that tracks ordinary income growth changes the outcome more than most attempts to pick a better fund.

Why Reality Diverges from the Projection

The formula assumes one constant rate compounding smoothly. A market-linked fund does nothing of the sort. Four specific gaps:

1. Sequence of returns matters. Two funds with identical 12% averages produce different SIP outcomes depending on when the good and bad months fell, because each instalment bought a different number of units. A flat formula cannot capture this.
2. The expense ratio is a permanent drag. A 1.5% ratio versus 0.5% on the same underlying portfolio compounds into a large terminal difference over 20 years. Compare returns net of expenses.
3. Exit loads and redemption timing reduce the amount you actually receive; many equity funds levy a load on units redeemed within a year.
4. Inflation reduces purchasing power. ₹50 lakh in 15 years is not ₹50 lakh today. At 6% inflation, its real value is roughly ₹50,45,760 / 1.06^15 ≈ ₹21 lakh in today’s terms. Plan goals in real terms, not nominal.

Measure realised returns with XIRR, not CAGR

CAGR describes a single lump sum over one period. A SIP is many investments at many dates, so CAGR is not defined for it. XIRR solves for the rate r satisfying:

Σ  CF_k / (1 + r)^(d_k / 365)  =  0

over every dated cash flow CF_k — negative for instalments, positive for redemptions. Build a two-column table of dates and amounts in any spreadsheet and call XIRR(values, dates). That number, not the calculator’s assumed rate, is what your SIP actually earned.

Taxation of SIP Gains in India

Every instalment is a separate acquisition, and redemptions follow FIFO — the oldest units go first. One redemption can therefore contain both short-term and long-term units, taxed differently.

For equity-oriented funds (at least 65% in domestic equity), under the Finance (No. 2) Act, 2024 effective 23 July 2024:

The ₹1.25 lakh annual exemption applies to equity-oriented schemes including ELSS, and not to debt, gold, or international fund categories, which follow their own rules. Surcharge and cess apply on top as per your total income.

Planning consequence: redeeming a 20-year SIP in one transaction can push a large long-term gain into a single financial year, using the ₹1.25 lakh exemption only once. Staging redemptions across financial years, where the goal permits, uses the exemption more than once.

Tax rules change and depend on your circumstances. Confirm current provisions with a qualified tax adviser before acting.

Step-by-Step: Projecting a SIP with Toolbox

1. Open the tool: visit the Toolbox SIP Calculator.
2. Enter the monthly instalment and tenure in years — the two inputs you actually control.
3. Set a defensible expected return. Use a conservative figure and run a range (for example 10%, 12%, 14%) rather than a single optimistic number; the spread is the honest output.
4. Read invested capital against gains in the breakdown to see when compounding starts to dominate contributions, typically somewhere past year eight to ten at equity-like rates.
5. Deflate the result for inflation to state the goal in today’s purchasing power: divide the maturity value by (1 + inflation)^years.
6. Track the real outcome with XIRR once the SIP is running, using your actual dated cash flows — that is the only number that reflects what happened.

Outcome: a maturity projection you can defend as a scenario, an explicit inflation-adjusted target, and the correct measure to check performance against later.

Related guides: Loan EMI and amortization · GST calculation in India · Work hours and overtime