Mutual fund SIP returns on real NAV data

How this is calculated

On the SIP start date and on the same calendar day each following month, we look up the scheme’s NAV (or the next trading day if that date was a holiday). Each instalment buys amount ÷ NAV units. We sum those units and multiply by the NAV on your end date (or the latest published NAV) to get today’s value. The annualised figure is XIRR across the full cash-flow schedule, not a simple CAGR, which would misstate returns when money is added monthly.

each month:  units_i = SIP amount ÷ NAV on instalment date
total units  = sum of units_i
current value = total units × NAV on as-of date
invested     = SIP amount × number of instalments
XIRR         = annualised rate solving NPV(cash flows) = 0
               (outflows = each SIP; inflow = current value)

Worked idea. ₹10,000 every month for five years is ₹6,00,000 invested. If those purchases accumulated enough units to be worth ₹8,40,000 at the end date, the absolute gain is ₹2,40,000. The XIRR will be lower than a same-period lump-sum CAGR, because most of the money was not invested for the full five years.

Results reflect what already happened to this scheme. They are not a promise about what it, or any fund, will return in future. Figures exclude exit load and tax on capital gains.

Frequently asked questions

How is this different from the regular SIP Calculator?

The SIP Calculator on our /tools page projects forward using a return rate you assume. This one looks backward: it uses a real scheme’s actual published NAV history, so the return shown is what genuinely happened for that monthly SIP, not an estimate.

How is XIRR calculated for a SIP?

Each monthly instalment is treated as a cash outflow on its NAV date, and today’s portfolio value is treated as a single cash inflow on the as-of date. XIRR is the annualised rate that makes the net present value of that schedule zero. That is the standard way to annualise uneven SIP cash flows.

What if my SIP date was not a trading day?

Mutual funds only strike a NAV on business days. If an instalment falls on a weekend or holiday, we use the next available NAV date for that purchase. Same convention as our lump-sum calculator.

Where does the NAV data come from?

From AMFI (the Association of Mutual Funds in India), the official body every AMC reports NAVs to. We do not use any distributor’s own figures.

Does this include exit load or capital gains tax?

No. The current value shown is before any exit load and before tax on the gains. Both would reduce the amount you actually receive on redemption.

More fund return calculators

• Lump Sum Returns (real scheme)
• Rolling Returns (real scheme)
• SWP Performance (real scheme)
• SIP NAV Movement (real scheme)