MF Calculator
Backtest a SIP or lumpsum against a real fund's NAV history and estimate the tax — or project future SIP value at an assumed return.
Independent · No commissions · No fund-house data — how the numbers are computed
How it works
Most mutual fund calculators project an assumed return. This one can also do the opposite: backtest a SIP or a lumpsum against a real fund's actual NAV history. Pick any fund, set a monthly amount (default ₹10,000) or a one-time investment (default ₹1 lakh) and a period, and it replays the plan — buying units at each month's real NAV, valuing them at the latest — and reports the invested amount, current value and XIRR the plan genuinely produced.
That makes it an answer to the question assumption-based calculators cannot touch: not "what would 12% produce" but "what did this fund actually deliver to someone who invested this way". Because installments buy more units when the NAV is low and fewer when it is high, a backtested SIP result differs — sometimes substantially — from the fund's headline point-to-point return over the same period.
The calculator has three tabs. Backtest replays a SIP or lumpsum against history. Projection compounds a SIP at an assumed flat rate, same as the standalone SIP Calculator. Tax estimate applies the current capital-gains rules to a redemption from a chosen fund, classifying it as equity or debt and using the holding period you enter. One caution applies to all backtests: a fund's past NAV path is a record, not a forecast.
Frequently asked questions
What does backtesting a SIP against NAV history mean?
Backtesting replays a SIP as if it had actually run: a fixed amount buys units at the fund's real published NAV on roughly the same day each month, the units accumulate, and the holding is valued at the latest NAV. The result — invested amount, current value and XIRR — is what that plan historically produced in that fund, including every rise and fall along the way, rather than a projection at an assumed rate.
Why is a backtested SIP return different from the fund's advertised return?
A fund's advertised return is point-to-point: one investment at the start, valued at the end. A SIP invests across the whole period, so most of the money is exposed for less than the full term and each installment buys at a different NAV. In a fund that rose steadily, the SIP's XIRR can trail the point-to-point CAGR; in one that dipped and recovered, the SIP can beat it, because the dip installments bought cheap units.
Is a fund's past performance a guide to its future returns?
Past NAV history is a factual record of what a fund delivered, and backtesting reports it accurately — but it is not a prediction. Fund managers change, category cycles turn, and top performers in one period routinely fall down the tables in the next. SEBI requires every fund to state this. A backtest is best used to understand a fund's behavior — how deep its falls were, how volatile the ride — rather than to extrapolate its returns forward.
How does the tax estimate in this calculator work?
It classifies the chosen fund as equity-oriented or debt from its category, then applies the current rules to the redemption you describe. Equity funds: gains on units held under 1 year are taxed at 20%, and gains on units held 1 year or more at 12.5% above the ₹1.25 lakh per-year exemption. Debt funds: since April 2023, gains are added to income and taxed at slab rate. It is an estimate — actual liability depends on your full-year gains and slab.
Which funds can I backtest here?
Any open-ended Indian mutual fund with published NAV history — the search covers the AMFI-listed universe this site tracks, and each fund's daily NAV series comes from its published record. The backtest window is limited by the fund's own history: a scheme launched three years ago cannot be backtested over five, and the calculator skips installment dates that fall before the fund's inception.
Go further
The assumption-based projection, when you just want the flat-rate math.
Shortlist funds worth backtesting by their actual 3, 5 and 10-year records.
The return measure every backtest here reports, and why SIPs need it.
The price the backtest buys and values units at.
A ready-made screen of funds with strong records across periods.