Portfolio XIRR Calculator

Why XIRR Matters for SIP Investors

XIRR — Extended Internal Rate of Return — is the only meaningful way to evaluate a portfolio with irregular cash flows. SIP investors make investments at different times: ₹5,000 in January, another ₹5,000 in February, more later. Absolute returns (total invested vs current value) ignore the time value of these different investments completely.

Consider a SIP of ₹10,000/month for 3 years into a mutual fund. Total invested: ₹3.6 lakh. Current value: ₹4.5 lakh. Absolute return looks like 25%. But the first installment has been invested for 36 months, the last installment for only 1 month. XIRR accounts for this — and might show a 12% annualized return, or 18%, depending on when returns actually came in.

Every mutual fund investor should know their XIRR. It's the single number that tells you whether your portfolio is beating its benchmark on a like-for-like basis. Most AMC portals show this, but calculating it yourself with actual cash flow dates is more accurate.

XIRR vs Absolute Returns vs CAGR

For a lump sum investment, CAGR and XIRR are equivalent. Both measure annualized growth from one investment date to one redemption date. The difference appears with multiple cash flows.

Benchmarking XIRR Against Nifty 50 TRI

Total Return Index (TRI) versions of indices include dividend reinvestment. The Nifty 50 TRI is the correct benchmark for equity funds, not the price index. Nifty 50 TRI has historically delivered 12–13% XIRR over long SIP periods (10–15 years), slightly higher than the price index which gets quoted more often.

Your fund's XIRR should be compared to a hypothetical SIP of the same amount on the same dates into the benchmark. If your active large-cap fund delivers 11% XIRR and Nifty 50 TRI would have delivered 12.5% XIRR on the same schedule, you'd have done better in an index fund. This comparison is the entire value proposition of passive investing.

For mid and small cap funds, benchmark against Nifty Midcap 150 TRI or Nifty Smallcap 250 TRI. For flexi-cap or multi-cap funds, use the Nifty 500 TRI. Using the wrong benchmark makes most actively managed funds look better than they are.

When XIRR Can Mislead

XIRR has a few edge cases where it gives counterintuitive results. If you've made very recent large investments, XIRR will be heavily influenced by short-term performance. A large lump sum 2 months ago that has dropped 10% will drag the XIRR significantly even if older SIP investments have compounded beautifully for 7 years.

XIRR also doesn't distinguish between luck and skill. A portfolio concentrated in a few multibagger stocks may show 35% XIRR, but that's not replicable skill — it's concentration risk that happened to pay off. Diversified portfolios with consistent 15–18% XIRR over 10+ years are a stronger signal of good process.

Finally, XIRR on small portfolios (under ₹5 lakh) with short histories (under 3 years) is noisy. Market timing swamps process. Wait for at least one full market cycle — ideally including both a significant drawdown and a recovery — before drawing conclusions from your XIRR.

Practical XIRR Calculation

XIRR requires two inputs: a series of cash flows with dates, and a current portfolio value (treated as a positive inflow on today's date). Outflows (investments) are negative, inflows (dividends, withdrawals, current value) are positive.

In Excel or Google Sheets, the XIRR function handles this automatically. Enter all investment dates and negative amounts in one column, add today's date with the current portfolio value as positive, and apply =XIRR(values, dates). The function iterates to find the rate that sets net present value of all flows to zero.

For most investors, their AMC's consolidated account statement or platforms like Kuvera, Groww, or Coin show portfolio XIRR automatically. But knowing how it's calculated helps you understand why the number moves and what it actually means.