🧮 Financial Mathematics & Formulas
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!
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
Step Up SIP Calculator
What Is a Step Up SIP?
Step Up SIP vs Regular SIP
Step Up SIP vs Top-Up SIP
How Much SIP for ₹1 Crore?
SIP Mutual Fund Calculator