Real AMFI NAV Data · All Indian Mutual Funds

Mutual Fund SIP Backtester

What did your SIP actually return?

Stop guessing with flat 12% return calculators. Backtest any Indian mutual fund using real AMFI NAV data and see your actual XIRR through market crashes, bull runs, and everything in between.

A Mutual Fund SIP Backtester simulates what would have happened if you had invested a fixed monthly SIP in a specific Indian mutual fund. Unlike static calculators that assume a flat 12% annual return, this free tool uses actual historical NAV data sourced from AMFI to calculate your real XIRR — showing exactly how your portfolio would have grown (or shrunk) through market crashes like 2008 and 2020, bull runs, and everything in between. You can backtest any fund registered with AMFI, including Parag Parikh Flexi Cap, Quant Small Cap, SBI Bluechip, and Mirae Asset Emerging Bluechip.

MF Backtester Stock Backtester SIP Calculator Lumpsum Direct vs Regular Goal Planner Inflation Calculator All Tools
Search Mutual Fund
Popular:
Investment Settings

⚠️ Disclaimer: Educational use only. Market data from AMFI via mfapi.in. Past performance does not guarantee future results.

Ready to Time Travel?

Search for a mutual fund and hit 'Run Backtest' to see exactly what would have happened to your money in the real market.

Risk guide

Understanding the Risk Numbers

Plain-English guide to what each metric means — with real examples.

Beta Volatility vs Market

What it means: When the market falls, how much does your fund fall? Beta 1 = same as market. Beta 0.8 = falls less. Beta 1.3 = falls more.

Real feel: You invest ₹1 lakh. The market drops 10% — everyone is panicking. With Beta 0.8, your fund drops only ₹8,000. With Beta 1.3, it drops ₹13,000. Same panic, different pain.

Watch for: Above 1.2 — your portfolio will scare you more during crashes. Below 0.7 — it's likely a conservative or hybrid fund.

Alpha Extra Return p.a.

What it means: Did the fund manager actually earn their fee? Alpha is the extra return they added on top of what the market gave for free.

Real feel: If a Nifty index fund would have grown your ₹1 lakh to ₹1.12 lakh in a year, and your fund grew it to ₹1.15 lakh — that extra ₹3,000 is Alpha. Negative Alpha means the manager did worse than just buying the index.

Watch for: Consistently negative Alpha over 5+ years = the fund is destroying value. Positive Alpha = manager is earning their keep.

Market Influence

What it means: When your fund goes up or down, how much of that is just the market moving — and how much is the fund doing something unique?

Real feel: R² 95% = your fund is basically riding the market wave. You could almost replace it with a Nifty index fund. R² 50% = the fund makes very independent bets. Diversifying into it actually reduces your overall risk.

Watch for: High R² with high TER = you're paying active fund fees for index-like behaviour. Check if a cheaper index fund does the same job.

Sharpe Risk-Reward Score

What it means: Are you being paid enough for the stress you're taking? Two funds can return the same amount — but one keeps you up at night and the other doesn't. Sharpe rewards the calmer one.

Real feel: Two jobs both pay ₹1 lakh/month. Job A has random salary cuts, demands weekends, unpredictable. Job B is steady. You'd pick Job B — same pay, less stress. Sharpe helps you pick Fund B.

Watch for: Below 0.5 = you're taking equity risk for almost no extra reward over a safe FD. Above 1.0 = the stress is worth it.

Sortino Bad-Month Shield

What it means: Sharpe penalises all swings. Sortino only asks about the painful ones — the months when your portfolio actually lost money. Higher = your bad months aren't as bad as they look.

Real feel: Imagine your salary. Some months you get a bonus (good swing — no problem). Some months there's a pay cut (bad swing — this hurts). Sortino measures: when the pay cuts happen, how bad are they compared to your normal salary? Higher Sortino = the cuts are small, the bonuses are big.

Watch for: Below 0.8 = your bad months are genuinely painful. Above 1.5 = even in downturns, this fund recovers well.

Volatility Ride Smoothness

What it means: How much does your portfolio value jump around every month? Low volatility = calm, predictable. High volatility = some months you feel rich, some months you want to quit.

Real feel: You invest ₹1 lakh. With 14% volatility, your worst months might show ₹96,000 — uncomfortable but manageable. With 28% volatility, your worst months could show ₹85,000 — can you stay calm and not sell in panic? That's the real question.

Watch for: If seeing ₹85,000 on a ₹1 lakh investment makes you want to sell — choose a lower-volatility fund. High returns with high volatility only work if you hold through the scary months.

FAQ

Frequently Asked Questions

Quick answers about historical Mutual Fund SIP backtesting.

What is a Mutual Fund SIP backtester?

A Mutual Fund SIP backtester is a free tool that calculates the historical returns of a Systematic Investment Plan (SIP) in specific Indian Mutual Funds using actual past NAV data. It simulates investing a fixed amount every month to find your true XIRR and profit.

How do I backtest Parag Parikh Flexi Cap or Quant Small Cap?

Simply type the name of the mutual fund in the search box above. Select the fund from the dropdown, choose your monthly SIP amount and duration, and click Run Backtest. The tool will calculate your total invested amount, current value, and real XIRR.

What is XIRR and how is it different from absolute returns?

XIRR (Extended Internal Rate of Return) is the most accurate way to measure SIP returns because it accounts for the timing of each investment. Absolute return just shows total profit as a percentage of total invested — it ignores when you invested. CAGR assumes a single lumpsum. XIRR is the only metric that correctly handles monthly SIPs made over years, which is why this backtester uses XIRR as the primary return metric.

Which mutual fund SIP date gives the best returns?

Research and backtesting consistently shows that SIP date has minimal impact on long-term returns — the difference between investing on the 1st versus the 28th is typically less than 0.1% XIRR over a 10-year period. What matters far more is staying invested consistently. You can backtest any SIP date using this tool by selecting your preferred date before running the backtest.

How accurate is this backtester? Where does the data come from?

This backtester uses real historical NAV data fetched directly from mfapi.in, which sources its data from AMFI (Association of Mutual Funds in India) — the official regulatory body. NAV data is accurate to the actual trading day. The XIRR calculation uses each SIP installment's exact purchase date and NAV, making the results as close to real-world performance as mathematically possible.

What is a good XIRR for a mutual fund SIP in India?

For Indian equity mutual funds, a good XIRR over a 10-year SIP period is generally 12–18%. Large-cap funds have historically delivered 11–14% XIRR, flexi-cap funds 13–17%, and small-cap funds 15–20% (with higher volatility). An XIRR below 10% over 10 years would underperform a simple index fund. Use this backtester to compare actual XIRR across different fund categories.

How does SIP during a market crash (2020, 2008) affect returns?

Market crashes are actually beneficial for SIP investors due to rupee cost averaging — you buy more units when prices are low. Investors who continued SIPs through the 2020 COVID crash saw significantly higher long-term XIRR because they accumulated more units at depressed NAVs. Use the Portfolio Journey filter in this tool to isolate specific years like 2020 or 2008 and see exactly how your fund performed during those periods.

What is rupee cost averaging and does backtesting prove it works?

Rupee cost averaging means that a fixed monthly SIP automatically buys more units when NAV is low and fewer units when NAV is high. This lowers your average cost per unit over time. Backtesting proves it works — investors who ran consistent SIPs through the 2008 financial crisis, 2015 correction, and 2020 COVID crash all saw their XIRR improve over investors who paused SIPs during those periods.

Is past SIP performance a guarantee of future returns?

No. Past performance is not a guarantee of future returns — this is a regulatory requirement that all mutual fund products must disclose. Historical backtesting is valuable for understanding how a fund behaved through different market cycles, volatility, and drawdowns. It helps you make more informed decisions, but markets are unpredictable. Use this tool as an educational and analytical tool, not as a prediction of what your investment will return.

How is this backtester different from a regular SIP calculator?

A regular SIP calculator assumes a flat annual return (e.g. 12%) and applies it uniformly — it has no knowledge of actual market history. This backtester uses real historical NAV data from AMFI for the specific mutual fund you choose. It simulates actual monthly purchases at real NAV prices, calculates your true XIRR, and shows how your portfolio would have looked year by year — including during crashes and bull runs.

What is maximum drawdown and why does it matter for SIP investors?

Maximum drawdown is the largest peak-to-trough decline in portfolio value during a given period. For SIP investors, drawdown matters because it tests your ability to stay invested. A fund with a 50% maximum drawdown (like many small-cap funds in 2008) requires 100% recovery just to break even. Understanding historical drawdown helps you choose funds that match your risk tolerance and avoid panic-selling during corrections.

What is the difference between CAGR and XIRR for mutual funds?

CAGR (Compound Annual Growth Rate) measures the growth of a single lumpsum investment from start to end. It does not account for multiple investments at different times. XIRR is designed for SIPs — it calculates the internal rate of return considering each monthly installment's timing and amount. For SIP performance, XIRR is always the correct metric. CAGR is used to benchmark the fund's NAV growth independently of your investment pattern.

What is the 15×15×15 rule in SIP?

The 15×15×15 rule states that if you invest ₹15,000 per month for 15 years at an assumed 15% annual return, you accumulate approximately ₹1 crore — illustrating the power of compounding in equity mutual funds. It is a useful rule of thumb, but it assumes a flat 15% CAGR which no real fund delivers smoothly every year. Use this backtester with actual historical NAV data to see what ₹15,000/month would have genuinely produced in your chosen fund over any 15-year window.

Why backtest

Why Backtest Your Mutual Fund SIP?

Understanding what your money actually did — not what a calculator assumes it did.

The Problem with Flat 12% Return Calculators

Every generic SIP calculator on the internet asks for one number: expected annual return. You type 12%, it multiplies, and shows you a future corpus. The problem is that no mutual fund has ever delivered a smooth, consistent 12% every single year. Real historical NAV data is volatile — funds go up 40% in one year and down 25% the next.

A flat-rate calculator cannot show you what happens to your SIP when the market crashes in year 3. It cannot tell you whether your XIRR was 11% or 17%. It cannot reveal how rupee cost averaging helped you during the 2020 COVID crash or the 2008 financial crisis. For that, you need a dedicated historical SIP returns calculator for India — one that uses real AMFI NAV data, not assumptions.

How This Tool Works: Real AMFI Data, Not Assumptions

This AMFI NAV data SIP calculator fetches actual historical NAV records from mfapi.in, which aggregates daily data from AMFI (Association of Mutual Funds in India) — the official regulatory body. When you run a backtest, the tool simulates buying units of your chosen fund on the SIP date every month at the exact NAV that existed on that day.

The result is a true XIRR — Extended Internal Rate of Return — calculated across every individual SIP installment. Unlike CAGR, which only works for lumpsum investments, XIRR accounts for the timing of each monthly contribution. It is the same calculation methodology used by chartered accountants and fund analysts when evaluating SIP performance.

Rupee Cost Averaging: What the Data Actually Shows

Rupee cost averaging is one of the most cited advantages of SIPs — and backtesting reveals exactly how powerful it is. When NAV falls during a market crash, your fixed monthly SIP amount buys proportionally more units. When NAV recovers, the extra units accumulated at the bottom amplify your gains significantly.

Investors who continued SIPs through the 2008 global financial crisis (Nifty fell ~60%), the 2020 COVID crash (Nifty fell ~38% in 6 weeks), and the 2015–2016 mid-cap correction all ended up with higher XIRR than those who paused. This tool functions as a rupee cost averaging calculator — use the Portfolio Journey date filter to zoom into any crash period and see exactly how averaging lowered your cost per unit over time.

Understanding Maximum Drawdown and Lumpsum vs SIP

Maximum drawdown — the largest peak-to-trough decline in your portfolio's value — is a critical risk metric that most SIP calculators completely ignore. A fund with a 20-year XIRR of 18% sounds spectacular, but if it had a maximum drawdown of 65% during 2008, many investors would have panic-sold at the bottom and never captured those returns.

Lumpsum vs SIP comparison is built into the Market Reality Check section of this tool. You can see whether a lumpsum investment at the start date would have outperformed or underperformed consistent monthly SIPs — a result that varies significantly by fund category and market cycle. Small-cap and mid-cap funds typically favor SIP entry during volatile markets, while large-cap index funds are more stable for lumpsum entry.

SIP Date Comparison: Does It Actually Matter?

A common question is whether the SIP date matters — 1st of the month versus 5th, 10th, or 28th. Extensive backtesting shows that the SIP date has minimal impact on long-term returns, typically less than 0.2% XIRR difference over 10 years across any date in the month. Market timing within a single month is noise compared to the impact of tenure, consistency, and fund selection. What matters overwhelmingly more is staying invested without pausing during market falls, and choosing a fund category whose historical drawdown profile matches your actual risk tolerance.

Real results

Real Backtest Insights

What the data actually shows — not what the theory promises.

Parag Parikh Flexi Cap · 10 Years

A ₹5,000/month SIP in PPFAS Flexi Cap run from 2014 to 2024 delivered an XIRR of approximately 16–18% — despite the fund showing negative calendar-year returns in 2022 due to its ~30% US equity allocation when global tech stocks crashed. Investors who stayed invested captured the full recovery and beyond.

Backtest it yourself → type "Parag Parikh" above

COVID Crash · March 2020

During the March 2020 COVID crash, most equity fund SIP portfolios showed a drawdown of 25–40% in a single month. Investors who continued their SIPs through this period accumulated significantly more units at depressed NAVs. The majority of equity funds fully recovered within 6–12 months, turning the crash into the best SIP entry point of the decade.

Filter to Mar–Dec 2020 in Portfolio Journey to see this

SIP Date Myth · Any Fund · 10 Years

Backtesting any large-cap or flexi-cap fund across all 28 SIP dates over a 10-year period consistently shows an XIRR variance of less than 0.2% between the best and worst dates. The 1st vs the 15th vs the 28th effectively makes no material difference over a long investment horizon. Consistency of investment matters far more than timing within the month.

Run your own SIP date comparison above

Explore more

Explore More Financial Tools

SIP Calculator Lumpsum Calculator Age Calculator Stock Backtester Beta MF Comparer New
Kuldeep Singh — creator of Deep Money Minds

Built by

Kuldeep Singh

Finance content creator focused on radical transparency in Indian personal finance. I build tools that use real data — not flat assumptions — so Indian investors can make genuinely informed decisions. This backtester uses actual AMFI NAV records because that is the only honest way to measure SIP performance.

More about me