Home›Glossary›XIRR (Extended Internal Rate of Return)

XIRR (Extended Internal Rate of Return)

XIRR stands for Extended Internal Rate of Return. It measures the annualized return of investments that have cash flows at irregular dates, such as SIPs, SWPs, or multiple lump sum investments.

XIRR is useful when investments happen on different dates, because it accounts for the timing of each cash flow.

Why XIRR matters

  • Accurate performance: Captures return impact of irregular cash flows.
  • Better comparison: Lets you compare returns across funds or portfolios.
  • Useful for SIPs: More realistic than simple average return.
  • Portfolio review: Helps track actual outcomes against goals.

How XIRR works

  • Cash flow inputs: Each investment and redemption is a cash flow.
  • Dates matter: The time gap between cash flows affects returns.
  • Single annualized rate: XIRR outputs one annualized percentage.
  • Net value included: Current value is treated as the final inflow.

You can calculate it using the XIRR calculator.

XIRR vs CAGR

CAGR assumes a single lump sum investment, while XIRR is built for multiple cash flows. For SIPs or staggered investments, XIRR provides a more accurate return. Learn more about CAGR.

Annualized return

Shows a yearly return rate across uneven cash flows.

Timing sensitive

Accounts for when money was invested or withdrawn.

Realistic performance

Reflects the actual investor experience over time.

Where XIRR is commonly used

  • SIP returns: Multiple monthly investments in mutual funds.
  • STP and SWP: Systematic transfer or withdrawal plans.
  • Portfolio evaluation: Combined investments and redemptions.
  • Loan prepayment impact: Comparing ROI after prepaying loans.

To compare fund flows, see SIP, STP, and SWP.

Common mistakes to avoid

  • Ignoring cash flow dates: Wrong dates distort the return.
  • Missing charges: Exclude fees and taxes can overstate returns.
  • Comparing with CAGR blindly: Use CAGR only for single investments.
  • Short time frames: Very short periods can exaggerate XIRR.

For return basics, review ROI and CAGR.

Who should use XIRR

  • Investors with SIPs or multiple investment dates.
  • Anyone reviewing mutual fund or portfolio performance.
  • People comparing returns across funds with different cash flows.
  • Investors tracking long term goals and outcomes.