Investment Configuration
How the Mutual Fund Returns Calculator Works
This calculator projects your mutual fund corpus using two investment modes — SIP (Systematic Investment Plan) and Lumpsum — both based on the power of compounding at an expected annual return rate. It plots your wealth growth year-by-year so you can visualize exactly how your money multiplies over time.
📈 SIP Formula — How Your Monthly Investment Grows
SIP uses the future value of annuity formula:
M = P × [(1 + r)ⁿ − 1] / r × (1 + r)
Where: P = monthly installment, r = monthly rate (annual%÷12÷100), n = total months.
Example: ₹5,000/month SIP at 12% for 10 years:
• Monthly rate r = 12%÷12 = 1% = 0.01
• n = 120 months
• Maturity = ₹5,000 × [(1.01¹²⁰ − 1) / 0.01] × 1.01 = ₹11.61L
• Total invested = ₹6L | Gain = ₹5.61L (93.6%)
💰 Lumpsum Formula — One-Time Investment Power
Lumpsum uses standard compound interest:
M = P × (1 + r)ⁿ
Where: P = principal, r = annual return rate ÷ 100, n = years.
Example: ₹5L lumpsum at 12% for 10 years:
• M = ₹5,00,000 × (1.12)¹⁰ = ₹15.53L
• Total invested = ₹5L | Gain = ₹10.53L (210.6%)
The same ₹5L invested as SIP (₹5,000/mo × 100mo) would yield ₹11.61L — lumpsum wins if
invested early, SIP wins for rupee-cost averaging in volatile markets.
Variable Reference — SIP & Lumpsum Formulas
SIP (Systematic Investment Plan)
M = P × [(1 + i)ⁿ − 1] / i × (1 + i)
Lumpsum (One-Time Investment)
M = P × (1 + r/100)ⁿ
| Variable | Meaning | SIP (₹5,000/mo · 12% · 10yr) | Lumpsum (₹5L · 12% · 10yr) |
|---|---|---|---|
| P | Investment Amount | ₹5,000 per month | ₹5,00,000 (one-time) |
| r | Annual Return Rate | 12% p.a. | 12% p.a. |
| i | Periodic Rate (r ÷ 100 ÷ 12) | 0.01 per month | — |
| n | Total Periods | 120 months (10 yrs × 12) | 10 years |
| Invested (I) | Total Capital Deployed | ₹6,00,000 (₹5,000 × 120) | ₹5,00,000 |
| M | Maturity Value | ₹11,61,695 | ₹15,52,924 |
| Gain | Return on Capital | ₹5,61,695 (93.62%) | ₹10,52,924 (210.58%) |
Mutual Fund Categories — Which Is Right for You?
SEBI classifies mutual funds into distinct categories. Choosing the right category is the most important investment decision — more than fund selection itself:
📊 Large Cap Funds
Invest in the top 100 companies by market capitalisation (Nifty 100 universe). Historical 10-year returns: 12–14% CAGR. Lower volatility than mid/small cap. Benchmark: Nifty 100 TRI. Recommended for: first-time equity investors, anyone with a 5–10 year horizon wanting equity exposure without extreme volatility. Expense ratio: 0.5–1.5% (Direct plans: 0.3–0.8%).
🚀 Mid Cap & Small Cap Funds
Mid cap: companies ranked 101–250 by market cap. Small cap: ranked 251+. Historical 10-year returns: 15–20% CAGR for the best performers, but with significant interim drawdowns (−40% to −60% during bear markets). Only suitable for investors with a 10+ year horizon, high risk tolerance, and the discipline to not exit during crashes. Enter 15–18% as the expected rate to model optimistic mid/small cap scenarios.
⚖️ Flexi Cap & Multi Cap
Flexi cap funds have no market-cap allocation constraint — fund managers allocate freely across large/mid/small cap based on market conditions. Multi cap funds must maintain a minimum 25% in each of large, mid, and small cap as per SEBI mandate. Historical returns: 13–16% CAGR for consistent performers. Ideal for 7–15 year investors who want a single diversified equity fund without active rebalancing.
🏦 Debt Funds
Invest in government bonds, corporate bonds, treasury bills, and money market instruments. Expected returns: 6–8% CAGR depending on duration. Lower risk but not zero risk — interest rate changes affect bond prices (duration risk). Post-April 2023 tax change, debt fund gains taxed at income slab rate (no more 20% with indexation for new investments). Best for parking surplus funds 3–36 months. Use 6–7.5% as expected return in this calculator.
🔄 Hybrid & Balanced Advantage Funds
Balanced Advantage Funds (BAFs) dynamically rebalance between equity and debt based on market valuations — increasing debt allocation when markets are expensive and equity when markets are cheap. Historical returns: 10–12% CAGR with significantly lower drawdowns than pure equity. Ideal for conservative investors aged 45+, retirees, or those who cannot emotionally sustain equity volatility. Model at 10–11% in this calculator.
📦 Index Funds & ETFs
Passively replicate indices like Nifty 50, Sensex, or Nifty Next 50. Returns = index returns minus a minimal tracking error. Expense ratios: 0.05–0.20% — dramatically lower than active funds. Nifty 50 TRI 20-year rolling return: ~13% CAGR. Growing evidence (SPIVA reports) shows 80–90% of active large cap funds underperform their benchmarks over 10 years. For most retail investors, a simple Nifty 50 index fund SIP is the statistically optimal strategy. Use 11.5–13% as the expected return.
Direct vs Regular Plans — The Hidden Cost of Advice
📉 The 1% Expense Ratio Difference Is Enormous
Regular plans pay ~0.8–1% higher expense ratio
than Direct plans annually — this commission goes to the distributor/advisor, not
you.
Model it in this calculator: ₹10,000/month SIP for 20 years:
• At
12% (Direct plan): Corpus = ₹99.9L
• At
11% (Regular plan): Corpus = ₹86.4L
The 1% expense
ratio difference costs you ₹13.5L over 20 years — more than the total
investment of ₹24L in the first 10 years. Always invest via Direct plans through platforms
like MFCentral, Zerodha Coin, or Groww (Direct mode).
⏱️ The Power of Starting Early — 5 Years Changes Everything
SIP of ₹5,000/month at 12% CAGR:
•
Start at age 25, invest till 60 (35 years): Corpus =
₹3.24Cr
• Start at age 30, invest till 60 (30 years):
Corpus = ₹1.76Cr
• Start at age 35, invest till 60 (25
years): Corpus = ₹94.9L
Starting 5 years earlier (age 25 vs 30)
delivers ₹1.48Cr more with the same monthly investment. Starting 10 years
earlier (age 25 vs 35) delivers ₹2.29Cr more. The best mutual fund
investment decision is starting immediately, even with a small amount.
For a detailed SIP projection with frequency options and a wealth chart, use our SIP & Lumpsum Calculator. To measure the actual annualized return of an existing investment using CAGR or IRR, our CAGR Calculator handles multi-phase cash flows.
Reading Your Calculator Results
Estimated Maturity Value — The projected corpus at the end of your investment tenure. This is based on a constant annual return assumption — actual returns will vary year-to-year. Use a conservative rate (10–11% for equity) for planning, not optimistic projections (18% is unrealistic for sustained long-term returns in any category).
Total Investment — For SIP: Monthly amount × number of months. For Lumpsum: the one-time principal. This is your cost of investment — the denominator for calculating your personal return on investment.
Total Gain — Maturity Value minus Total Investment. The percentage shown is your absolute return — total gain divided by total invested. Note: absolute return on SIP investments is misleading because early installments compound longer. XIRR (Extended Internal Rate of Return) is the correct return metric for SIP investments — use a financial calculator or Excel =XIRR() function to compute this accurately.
Growth Chart — The gap between the solid line (Total Value) and dashed line (Invested Amount) is your wealth created by compounding. Notice how this gap widens dramatically in the later years — this is the "compounding hockey stick" effect, explaining why the last 5 years of a 20-year SIP often generate more wealth than the first 15 years combined.
Frequently Asked Questions
What is the difference between SIP and Lumpsum investment?
Lumpsum invests the entire amount at once. Ideal when you receive a windfall (salary bonus, maturity proceeds, inheritance) and markets are at reasonable valuations. Lumpsum delivers higher returns if invested at market lows but performs worse if invested at market peaks.
For most retail investors: SIP is behaviorally superior because it eliminates the need to time the market. For those with a lumpsum, consider a Systematic Transfer Plan (STP) — park in a liquid fund and transfer monthly to equity, gaining the benefits of both.
What expected return rate should I enter for accurate projections?
• Large Cap / Index Funds: 11–13% — use 11% for conservative planning
• Flexi Cap / Multi Cap: 12–14% — use 12% for planning
• Mid Cap: 13–16% — use 13% for conservative planning
• Small Cap: 14–18% — highly variable; use 13% for planning
• Balanced Advantage / Hybrid: 10–12% — use 10% for planning
• Debt Funds (Short Duration): 6.5–7.5%
• Liquid Funds: 6–6.5%
Never plan at a rate higher than the fund's 10-year rolling average. The future is not guaranteed to repeat the past. Always stress-test with 2–3% lower than your expected rate.
What is Expense Ratio and how does it impact my returns?
Typical expense ratios:
• Active Equity Funds — Regular: 1.5–2.5% | Direct: 0.5–1.2%
• Index Funds: 0.05–0.25% (Direct and Regular similar)
• Debt Funds — Regular: 0.5–1.5% | Direct: 0.2–0.8%
To factor expense ratio into this calculator: if a fund's gross return is 14% and expense ratio is 1.5%, enter 12.5% as the expected return. For Direct plans with 0.6% expense ratio, enter 13.4%. Every 0.5% saved in expense ratio adds significantly to 20+ year wealth creation.
Is it possible to lose money in mutual funds?
• 1-year horizon: ~30–40% probability of negative returns in any given year
• 5-year horizon: ~10–15% probability of negative returns across rolling periods
• 10-year horizon: Historical probability of negative returns on Nifty 50 SIP ≈ 0% (no 10-year rolling SIP period has given negative returns on Nifty 50 since 1990)
Time is the most powerful risk-reducer in equity investing. Debt funds are significantly less volatile but carry credit risk (issuer default) and interest rate risk (NAV falls when rates rise). Liquid and overnight funds have near-zero risk of capital loss.
What is XIRR and why is it different from the calculator's return percentage?
XIRR (Extended Internal Rate of Return) is the correct annualized return metric for SIP investments. It accounts for the timing of each cash flow (each monthly installment) and produces an annualized return comparable to FD rates.
Example: ₹5,000/month SIP for 10 years at 12% per annum in this calculator shows 93.6% absolute return. The XIRR is actually 12% per annum — because that's the annualized compounding rate used in the formula. Always use XIRR (available in Excel, Google Sheets, and most portfolio tracking apps) when evaluating your actual mutual fund portfolio performance.
Should I invest in mutual funds or PPF / FD for long-term goals?
• PPF (7.1% p.a.): Corpus ~₹16.3L | Tax-free
• FD (7% p.a.): Corpus ~₹16L | Interest taxed at slab rate
• Large Cap MF (12% p.a.): Corpus ~₹25.2L | LTCG taxed at 12.5% above ₹1.25L/year
• Flexi Cap MF (13% p.a.): Corpus ~₹27.9L
After LTCG tax on MF gains, equity still outperforms PPF by ₹6–9L over 15 years. The optimal strategy for most Indians: 80% equity MF + 20% PPF for the first 20 years of working life, with a gradual shift toward debt as retirement approaches. PPF provides excellent guaranteed debt allocation within the tax-free 80C benefit.
Financial Disclaimer
Mutual fund investments are subject to market risks. Please read all scheme related documents carefully before investing. Past performance of the schemes is neither an indicator nor a guarantee of future performance.
The purpose of this calculator is to inform the user and provide estimates. Do not plan your finances based solely on the calculator results.