Why XIRR?

Investing rarely happens in a single lump sum. Real portfolios see contributions and withdrawals at irregular dates: monthly SIPs, rebalancing, dividends, tax payments, or emergency redemptions. XIRR is the right tool for this reality because it accounts for both magnitude and timing of cash flows, producing a money‑weighted rate of return that solves a time‑value‑of‑money equation on actual dates.

The Core Idea

XIRR finds r such that the net present value (NPV) of all cash flows equals zero when discounted by that rate using their actual dates:

Σ CF_i / (1 + r)^(Δt_i) = 0

Here CF_i is the ith cash flow (deposits are negative from the investor’s perspective, withdrawals positive), and Δt_i is the year fraction between the cash‑flow date and a chosen reference date. Because dates are irregular, there’s no single fixed period; the exponent uses the precise fraction of a year between dates.

XIRR vs IRR vs CAGR

• CAGR: best when there are no interim cash flows; gives a clean annualized summary of start-to-end growth.
• IRR: assumes periodic cash flows at a fixed interval. Good for projects with regular cycles, but too restrictive for real portfolios.
• XIRR: handles irregular dates, making it ideal for SIPs, sporadic top‑ups, and lumpy withdrawals.

Example: SIP With a Redemption

Imagine investing $500 on the 1st of every month for 24 months, then redeeming the entire value on a later date. Each $500 outflow has a specific date, and the final redemption is an inflow on its settlement date. Plug these into an XIRR solver and you’ll get a single annualized rate that incorporates timing. Notice how investing earlier in the timeline has more time to compound—XIRR captures that.

Interpretation Tips

• Positive and negative cash flows must both be present for a meaningful solution. All outflows without a terminal inflow (or vice‑versa) cannot balance to zero.
• Multiple mathematical solutions are possible in contrived sequences of sign changes; most realistic portfolios have a unique, economically sensible root near common ranges.
• Money‑weighted returns emphasize investor experience. A portfolio can show strong time‑weighted performance while an investor’s XIRR is lower if most contributions arrived right before a drawdown.

Practical Pitfalls

• Ensure dates are correct and unique; duplicate timestamps can cause numerical instability.
• Be consistent about sign convention: contributions negative, withdrawals positive.
• Annualization uses a 365‑day basis in most implementations; match your basis across tools for comparability.

Use Cases

• Evaluating SIP strategies across different start dates
• Comparing robo‑advisor portfolios with different deposit schedules
• Measuring the true investor experience in a retirement or college savings plan

Try the Tools

• XIRR Calculator
• SIP Calculator
• Compound Interest

When cash flows are irregular—as they almost always are—XIRR is the cleanest single‑number summary of performance. Pair it with risk metrics and behavior insights to make results more actionable.