SIP Calculator for Mutual Fund Monthly Investments
A SIP calculator projects what a fixed monthly investment in a mutual fund could grow to, by treating each instalment as a separate deposit that compounds for the months remaining until you redeem. It is an annuity calculation, not a forecast: the return you type in is an assumption, and equity returns are neither fixed nor guaranteed.
SIPs suit Indian retail investors because the instalment can start at ₹500 a month and because investing on a fixed date removes the need to judge market levels. AMFI data shows monthly SIP collections in the mutual fund industry running in the tens of thousands of crores, which is why almost every fund house now offers the facility.
Use the output as a planning range rather than a promise. Run the same instalment at a conservative rate and an optimistic one, and plan around the lower figure.
SIP Calculator
Projected corpus
₹50,45,760
15 years at 12% a year
- Total invested180 instalments over 15 years
- ₹18,00,000
- Wealth gained₹50.46 lakh in all
- ₹32,45,760
- Gain as a share of what you put in
- 180.32%
- Monthly instalmentunchanged for the whole term
- ₹10,000
- Corpus if the return is only 10%₹8,66,517 less
- ₹41,79,243
- The same total as a lump sum today₹18,00,000 compounded annually at 12%
- ₹98,52,418
- Corpus in lakh and croreafter 15 years
- ₹50.46 lakh
- Equity returns are neither fixed nor guaranteed; treat the figure as a planning range, not a forecast.
- Shown before exit load and capital gains tax. Equity gains above ₹1,25,000 a year are taxed at 12.5% once held beyond 12 months.
- Uses the start-of-month convention, so every instalment compounds for the full month. The end-of-month convention gives a slightly lower figure.
The formula
FV = P × ((1 + i)^n − 1) ÷ i × (1 + i)
- P
- The monthly SIP instalment
- i
- Expected monthly return, that is the annual return divided by 12 and by 100
- n
- Number of instalments, that is years multiplied by 12
- FV
- Future value, the projected corpus at the end
The trailing (1 + i) treats each instalment as invested at the start of the month; drop it if you want the end-of-month convention, which gives a slightly lower figure.
How to calculate it
- 1
Fix the instalment and the horizon
Decide the amount you can debit every month without interruption and the number of years you will hold. Stopping a SIP in a fall is the single largest cause of the projected figure not being reached.
- 2
Choose a return assumption you can defend
Use a long-run figure for the asset class rather than the fund's recent chart. Running the projection at two rates, one cautious and one optimistic, is more useful than arguing over a single number.
- 3
Convert to a monthly rate and an instalment count
A 12% annual assumption gives i = 12 ÷ 12 ÷ 100 = 0.01. Fifteen years of monthly instalments gives n = 180. The formula compounds monthly, which is the standard simplification for a monthly SIP.
- 4
Apply the annuity formula
Compute (1 + i)^n, subtract 1, divide by i, multiply by P and then by (1 + i). The result is the corpus before exit load and tax.
- 5
Separate the corpus into contribution and gain
Total invested is simply P multiplied by n. The corpus minus that figure is the gain, and only the gain is taxed. This split is what you need for the capital gains calculation on redemption.
- 6
Check the realised return with XIRR, not CAGR
Because the money went in on many dates, CAGR on the total invested is meaningless. XIRR weights each instalment by how long it stayed invested and is the correct measure of a SIP's actual return.
Value of a ₹10,000 monthly SIP, investment at the start of each month
| Tenure | Total invested | At 10% a year | At 12% a year |
|---|---|---|---|
| 5 years | ₹6,00,000 | ₹7,80,824 | ₹8,24,864 |
| 10 years | ₹12,00,000 | ₹20,65,520 | ₹23,23,391 |
| 15 years | ₹18,00,000 | ₹41,79,243 | ₹50,45,760 |
| 20 years | ₹24,00,000 | ₹76,56,969 | ₹99,91,479 |
| 25 years | ₹30,00,000 | ₹1,33,78,903 | ₹1,89,76,351 |
Worked example
- Monthly SIP
- ₹10,000
- Assumed return
- 12% a year
- Tenure
- 15 years, so 180 instalments
- Monthly return i = 12 ÷ 12 ÷ 100 = 0.01
- (1 + i)^180 = 5.9958020
- FV = 10,000 × (5.9958020 − 1) ÷ 0.01 × 1.01
- Total invested = 10,000 × 180 = ₹18,00,000
- Gain = ₹50,45,760 − ₹18,00,000 = ₹32,45,760
Projected corpus = ₹50,45,760, of which ₹18,00,000 is your own money and ₹32,45,760 is the assumed gain
Frequently asked questions
Sources
Rates and rules on this page come from the following. This is a working aid, not professional advice: confirm anything material with your Chartered Accountant before you act on it.
Stop re-keying these figures
Aalekh runs this calculation on your actual client data, pulls the underlying ledgers straight from Tally, and carries the result through to the financial statements and the return.
Related calculators
Capital Gains Calculator
Holding periods, STCG and LTCG rates by asset class, and the indexation choice for older property.
OpenFD Calculator
Find the maturity value and effective yield of a fixed deposit, and the tax due on the interest.
OpenEMI Calculator
Work out the monthly instalment, total interest and prepayment savings on any loan.
Open
