Step Up SIP Formula with Examples: Step-by-Step Math Guide

🧮 Financial Mathematics & Formulas

While calculating a regular SIP is straightforward using basic annuity formulas, a step up SIP is mathematically more intriguing. Because your monthly contribution increases each year, a step up SIP represents a succession of nested annuities compounding simultaneously. Here is the exact mathematical formula behind step up SIP calculations, complete with step-by-step worked numerical examples and Excel formulas anyone can understand. Let’s explore step up sip formula.

Why Standard SIP Formulas Cannot Be Used

For a traditional fixed SIP, finance uses the classic Future Value of an Annuity Due formula:

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

Where P is the constant monthly deposit, i is the monthly rate of return, and n is the total number of months. This formula works because P never changes.

In a Step-Up SIP, P is not constant; it changes at the start of every 12-month cycle. Therefore, a step up SIP must be calculated either as a summation of yearly SIP vintages or via a discrete monthly compounding series.

The Comprehensive Step Up SIP Formula

The calculation operates in two mathematical stages:

Stage 1: Calculate Monthly Installment for Any Given Year

P(k) = P(1) × (1 + g)^(k − 1)
  • P(k): Monthly SIP installment in Year k
  • P(1): Starting monthly SIP installment in Year 1
  • g: Annual step-up percentage (expressed as a decimal, e.g., 0.10 for 10%)
  • k: The specific year index (1, 2, 3… up to total years Y)

Stage 2: Calculate Future Value of Year k’s Deposits at Final Maturity

Each year’s set of 12 monthly payments accumulates interest during that year, and then that year end value compounds forward for the remaining (Y − k) years until the final maturity date:

FV(k) = P(k) × [ ((1 + i)^12 − 1) / i ] × (1 + i) × (1 + r)^(Y − k)

Total Final Corpus = ∑ [ FV(k) ]  for k = 1 to Y
  • r: Annual expected rate of return (e.g. 0.12 for 12%)
  • i: Effective monthly rate of return, calculated as: (1 + r)^(1/12) − 1
  • Y: Total investment tenure in years

Official technical guidelines from the Association of Mutual Funds in India (AMFI) recommend assuming installments are invested at the beginning of each monthly payment cycle (annuity due) to accurately capture compounding periods.

Worked Numerical Example: Step-by-Step Walkthrough

Let’s run a clear, manual calculation with easy round numbers:

  • Starting SIP (P1): ₹10,000 per month
  • Annual Step-Up (g): 10% (0.10)
  • Assumed Return (r): 12% per annum (CAGR)
  • Tenure (Y): 3 Years (36 Months) for manual simplicity

Step 1: Compute Monthly Rate of Return

Using effective compounding:

i = (1 + 0.12)^(1/12) − 1 = 0.0094888 (approx 0.9489% per month)

Step 2: Calculate Installments and Future Values Year by Year

Year 1 (k = 1):

  • Monthly installment: ₹10,000 × (1 + 0.10)^0 = ₹10,000
  • Value of Year 1 deposits at the end of Year 1: ₹10,000 × 12.6825 = ₹1,26,825
  • This value then compounds forward for 2 remaining years: ₹1,26,825 × (1 + 0.12)^2 = ₹1,59,109

Year 2 (k = 2):

  • Monthly installment: ₹10,000 × (1 + 0.10)^1 = ₹11,000
  • Value of Year 2 deposits at the end of Year 2: ₹11,000 × 12.6825 = ₹1,39,508
  • Compounds forward for 1 remaining year: ₹1,39,508 × (1 + 0.12)^1 = ₹1,56,249

Year 3 (k = 3):

  • Monthly installment: ₹10,000 × (1 + 0.10)^2 = ₹12,100
  • Value of Year 3 deposits at the end of Year 3: ₹12,100 × 12.6825 = ₹1,53,458
  • Compounds for 0 remaining years: ₹1,53,458 × 1 = ₹1,53,458

Step 3: Sum All Vintages to Get Final Corpus

Final Corpus = ₹1,59,109 + ₹1,56,249 + ₹1,53,458 = ₹4,68,816

Let’s check the breakdown:

  • Total Capital Invested: (10,000 × 12) + (11,000 × 12) + (12,100 × 12) = ₹3,97,200
  • Total Wealth Generated (Returns): ₹4,68,816 − ₹3,97,200 = ₹71,616

How to Calculate Step Up SIP in Microsoft Excel or Google Sheets

You do not need to perform complex summations by hand. You can model this in a spreadsheet in 60 seconds using this structure:

Column Header Formula for Row 2 (Month 1) Formula for Row 14 (Month 13 / Year 2)
A Month Number 1 13
B Year Number =INT((A2-1)/12)+1 =INT((A14-1)/12)+1
C Monthly SIP 10000 =ROUND($2*(1+10%)^(B14-1), 0)
D Months Remaining =TotalMonths - A2 + 1 =TotalMonths - A14 + 1
E Future Value of Installment =C2 * (1 + (1+12%)^(1/12) - 1)^D2 =C14 * (1 + (1+12%)^(1/12) - 1)^D14

Finally, in any summary cell, simply write =SUM(E2:E121) for a 10-year (120-month) simulation. The sum gives you the exact projected future corpus to the very rupee!

💡

Skip the Manual Spreadsheet: If you don’t want to build an Excel model from scratch, our free online Step-Up SIP Calculator automatically computes this complete mathematical schedule and lets you download a full PDF statement in one click.

Frequently Asked Questions

What is the difference between nominal and effective monthly interest rate in SIP formulas?

A nominal monthly rate simply divides annual return by 12 (i = r / 12). An effective monthly rate uses compound roots [i = (1 + r)^(1/12) – 1]. Most professional wealth managers and institutional calculators use the effective rate because mutual fund compounding operates continuously on Net Asset Values (NAVs).

Does the step up formula assume payment at the beginning or end of the month?

Most mutual fund SIP formulas assume payment at the beginning of the month (annuity due) because fund units are purchased on your specified monthly auto-debit date and immediately begin earning NAV returns for the remainder of that calendar month.

Can the step up SIP formula handle half yearly or quarterly step ups?

Yes. In the installment formula, replace the exponent (k – 1) with the number of frequency intervals elapsed. For half-yearly increments, the installment increases every 6 months instead of every 12 months.

Does the formula account for mutual fund expense ratios?

No. The formula calculates pure mathematical growth at the assumed CAGR rate. In real-world mutual funds, the daily NAV published by AMCs is already net of the Total Expense Ratio (TER), so the CAGR you observe in your portfolio has expenses already deducted.

Why do different online step up calculators show slightly different results?

Small differences between calculators (usually under 1-2%) occur due to three factors: (1) whether they use nominal (r/12) vs effective monthly compounding, (2) whether installments are credited at the beginning vs end of the month, and (3) rounding of monthly installments to the nearest whole rupee.

Related Guides and Tools

⚠️

Disclaimer: This formula guide is provided for educational purposes. Mutual fund market returns fluctuate day to day and are never guaranteed. Consult a SEBI-registered investment advisor before committing financial capital.

Author & Financial Specialist Fact-Checked & Calculation Verified (Nov 16, 2026)
HS

Hiral Saxsena

Quantitative Financial Analyst & Mutual Funds Specialist

Hiral Saxsena is a Quantitative Financial Analyst and Mutual Funds Research Specialist with over 7 years of experience in retail equity research, wealth planning, and systematic investing. She specializes in dollar-cost / rupee-cost averaging strategies, mutual fund portfolio evaluation, and long-term compounding modeling.

About The Author

Leave a Comment

Your email address will not be published. Required fields are marked *

Scroll to Top