XIRR Explained: The Right Way to Calculate SIP Returns

If you've ever looked at your mutual fund SIP statement and wondered why the "returns" number doesn't seem to match what you'd expect, XIRR is probably the missing piece. It's the correct way to measure returns when your money went in over time rather than all at once.

Why simple average return doesn't work for a SIP

A simple return calculation compares your total invested amount to your current value — but it treats every rupee as if it was invested for the same length of time. In a SIP, that's never true: your first instalment has been growing for years, while last month's instalment has barely had time to earn anything. Averaging these together gives a distorted picture.

What XIRR actually does

XIRR (Extended Internal Rate of Return) calculates a single annualized return rate that accounts for the exact date and amount of every cash flow — every SIP instalment going in, and the final value coming out. It essentially answers: "What constant annual rate would explain everything that actually happened, given exactly when each rupee was invested?"

A simplified example

Say you invested ₹5,000/month for 3 years (36 instalments), and your fund is now worth ₹2,20,000 against a total investment of ₹1,80,000.

• Simple return: (2,20,000 − 1,80,000) ÷ 1,80,000 = 22.2% — but this doesn't tell you the annual rate, and it ignores that different instalments were invested for different durations
• XIRR accounts for the fact that your first instalment worked for 3 years while your last instalment worked for barely a month, and produces the correct annualized figure — typically somewhat different from what a naive calculation suggests

When XIRR matters most

• SIP investments: Since money goes in monthly rather than as a lump sum, XIRR is the standard, correct way to measure SIP performance
• Irregular investments: If you've made lump-sum top-ups at random times alongside a SIP, XIRR handles this correctly where simple CAGR cannot
• Comparing different funds: XIRR lets you compare returns across funds fairly, even if your investment pattern differed between them

XIRR vs CAGR — what's the difference?

CAGR works well for a single lump-sum investment held for a fixed period — one cash flow in, one cash flow out. XIRR is the generalized version that handles multiple cash flows at different dates, which is exactly what a SIP is. For a pure lump-sum investment, XIRR and CAGR give you the same answer.

Where to find your actual XIRR

Most mutual fund platforms and your fund's Consolidated Account Statement (CAS) display XIRR directly — you don't need to calculate it by hand. What matters is understanding what the number means: it's your true annualized return, correctly weighted for when each rupee was actually invested.

Calculate your SIP's real return

Use Finzony's XIRR Calculator to calculate your actual annualized return based on your real SIP instalment dates and amounts.

This article is for educational purposes only and does not constitute investment advice. Past performance does not guarantee future returns — consult a financial advisor before making investment decisions.