What Is a Mutual Fund Returns Calculator?
A mutual fund returns calculator projects how a lumpsum or SIP investment grows over time at an assumed annual return rate. It runs the same compounding math that fund houses use to illustrate potential outcomes.
Choose Lumpsum or Monthly SIP, enter the amount, expected return, and duration. The calculator returns your final corpus, the amount you invested, and the estimated gains.
This is a projection tool, not a prediction. Actual returns depend on which fund you pick, how equity and debt markets perform, and fund expenses over your holding period. Every mutual fund's actual performance data is published on amfiindia.com.
Mutual Fund Return Formula: Lumpsum and SIP
Lumpsum formula
For a one-time investment, the formula is:
A = P × (1 + r)^t
A is the final value, P is the principal, r is the annual rate as a decimal, and t is years. At 12 percent over 10 years, Rs 1 lakh becomes approximately Rs 3.11 lakh.
SIP formula
For monthly investments, the formula is:
M = P × [((1 + i)^n − 1) / i] × (1 + i)
M is the maturity amount, P is the monthly instalment, n is the total number of months, and i is the monthly rate derived as (1 + annual rate)^(1/12) − 1.
This calculator uses the exact compound conversion for i, not the common approximation of dividing the annual rate by 12, which understates a SIP's true compounding.
Mutual Fund Return Formula in Excel
Excel has a built-in function for each mode. Both take the same inputs this calculator uses: rate, duration, and amount.
| Mode | Excel Formula | Example |
|---|---|---|
| Lumpsum | =FV(rate,years,0,-principal) | =FV(12%,10,0,-100000) → Rs 3,10,585 |
| Monthly SIP | =FV(rate/12,months,-monthly,0,1) | =FV(12%/12,120,-10000,0,1) → Rs 23,23,391 |
The final argument 1 in the SIP formula tells Excel each instalment is paid at the start of the period, which matches how SIP debits actually happen.
SIP vs Lumpsum: Which Should You Choose?
Neither mode is universally better. The right choice depends on whether you have a one-time amount or a recurring monthly surplus to invest.
| Lumpsum | Monthly SIP | |
|---|---|---|
| Suited for | One-time large amount | Monthly savings from salary |
| Entry price risk | Full amount exposed at one price | Averaged over many entry points |
| Best market timing | Strong returns if deployed at a market low | Removes the need to time the market |
| Compounding start | Entire principal compounds from day one | Each instalment compounds from its own date |
| Best suited for | Bonuses, inheritance, windfall amounts | Salaried professionals, regular savers |
Run the same amount through both modes on the calculator above. For a recurring monthly surplus, the SIP Calculator adds step-up and pause features built specifically for that use case.
Reverse Calculation: How Much to Invest for a Target Corpus
Instead of asking what an amount grows into, you can work backward from a goal. At your current 12% assumed rate over 10 years, reaching a Rs 1 crore target needs either a lumpsum today or a monthly SIP.
| Route | Amount Required |
|---|---|
| One-time lumpsum today | ₹32,19,732 |
| Monthly SIP | ₹44,636 / month |
The formula reverses algebraically: for lumpsum, P = Target / (1 + r)^t. For SIP, P = Target / [((1 + i)^n − 1) / i × (1 + i)]. Change the rate or duration sliders above and this table recalculates.
Expected Returns by Mutual Fund Category
The return rate you enter is your own assumption. This table gives indicative ranges from long-term historical performance across Indian mutual fund categories.
| Fund Category | Risk Level | 10-Year Return Range | Who It Suits |
|---|---|---|---|
| Large-cap equity | Moderate-High | 11% to 14% | Long-term investors, moderate risk appetite |
| Mid-cap equity | High | 14% to 18% | 7+ year horizon, higher risk tolerance |
| Small-cap equity | Very High | 15% to 22% | Investors who can hold through sharp drawdowns |
| Flexi-cap / Multi-cap | Moderate-High | 12% to 16% | Diversified exposure across market caps |
| Hybrid equity-oriented | Moderate | 9% to 13% | Equity returns with lower volatility |
| ELSS (tax-saving) | High | 12% to 16% | 80C deduction plus equity returns |
| Debt: corporate bond | Low-Moderate | 6% to 8% | Conservative investors, 3-year horizon |
| Liquid funds | Low | 6% to 7% | Parking idle cash for up to 90 days |
Source: historical NAV data from AMFI India. Past performance does not guarantee future returns.
CAGR Calculator
Already know a fund's start and end value? Find its exact annualised growth rate.
Tax on Mutual Fund Returns in India
Mutual fund gains are taxed at redemption, not during the holding period. The rate depends on fund type and how long you held the units.
| Fund Type | Holding Period | Tax Rate | Exemption |
|---|---|---|---|
| Equity (≥65% in equity) | More than 12 months | 12.5% LTCG | First Rs 1.25 lakh per year tax-free |
| Equity (≥65% in equity) | 12 months or fewer | 20% STCG | No exemption |
| Debt funds (from Apr 2023) | Any period | Slab rate | No indexation, no LTCG benefit |
| Hybrid: equity-oriented | More than 12 months | 12.5% LTCG | First Rs 1.25 lakh per year tax-free |
| Hybrid: debt-oriented | Any period | Slab rate | No LTCG benefit since Apr 2023 |
The Rs 1.25 lakh LTCG exemption applies per financial year across all your equity fund redemptions combined. Rules are set under the Income Tax Act and updated by each Union Budget.
Direct vs Regular Mutual Fund Plans
A regular plan is bought through a distributor who earns a commission, built into a slightly higher expense ratio. A direct plan is bought straight from the fund house or a SEBI-registered platform with no commission.
The gap is typically 0.5 to 1 percent a year. On a Rs 10,000 monthly SIP over 20 years at 12 percent, switching from regular to direct can add several lakh rupees to the final corpus, purely from the lower fee compounding over time.
NAV and Expense Ratio Explained
NAV, or Net Asset Value, is a fund's per-unit price, published once a day by dividing total portfolio value by outstanding units. You buy and sell units at that day's NAV, and unlike a stock price, it does not move intraday.
The expense ratio is the annual management fee, already deducted before NAV is published. Index funds typically charge 0.05 to 0.20 percent; actively managed equity funds charge up to 1.05 percent under SEBI's expense ratio caps.
Limitations of This Calculator
No calculator can predict what a mutual fund will actually return. Keep these four limitations in mind before treating any output as a plan.
It assumes a constant rate. Real markets deliver a bumpy sequence of gains and losses, not a flat annual percentage. Two funds with the same average can arrive at very different actual corpuses.
It ignores expense ratio and exit load. Enter a net-of-fee return assumption if you want the result to reflect what actually reaches your account.
It ignores tax on redemption. The total value shown is pre-tax. Use the tax table above to estimate your actual take-home amount.
Past category averages may not repeat. A fund category that returned 15% over the last decade is not guaranteed to repeat that figure over the next one.
For evaluating your actual SIP portfolio using exact transaction dates, use the XIRR Calculator.
How to Use This Calculator
- Select investment type: choose Lumpsum for a one-time amount or Monthly SIP for a fixed monthly investment.
- Enter the amount: the total for lumpsum, or the monthly instalment for SIP.
- Set the expected return rate: refer to the fund category table above for a realistic range, and use the lower end for a conservative plan.
- Set the duration: compounding accelerates meaningfully beyond 7 to 10 years.
- Read the results: expand the year-by-year table to see how the corpus builds at each annual milestone.
Are you a CA or financial advisor?
Generate branded Tax Optimization Reports for your clients.
Frequently Asked Questions
Disclaimer: All calculations on this page are indicative only and do not predict actual mutual fund performance. Past performance of any fund or category does not guarantee future results. This calculator is for educational and planning purposes only and does not constitute financial advice. Consult a SEBI-registered investment adviser before making investment decisions.