XIRR Calculator

Extended Internal Rate of Return for irregular cash flows. Used by investors and analysts to measure annualized return on investments with non-periodic contributions.

? Investment ( -10000, +2000...) ? Real Estate Project ? Bond Ladder ? Clear all
Calculating XIRR...

What is XIRR?

The Extended Internal Rate of Return (XIRR) is a financial metric used to calculate the annualized return of an investment where cash flows occur at irregular intervals. Unlike regular IRR, XIRR accounts for exact dates, making it more accurate for real-world scenarios (investments, private equity, project finance).

Mathematical definition: Find the rate r such that:

∑ [CFᵢ / (1+r)^(dᵢ/365)] = 0

where dᵢ = days from the first cash flow date, and CFᵢ are cash flows (negative = outbound, positive = inbound).

Key Features of this Calculator

  • Flexible dates: Use any date range (YYYY-MM-DD). The first date sets the reference.
  • Real-time NPV curve: Visualize how NPV changes with discount rate, locate the XIRR crossing.
  • Robust algorithm: Hybrid Newton/bisection solver handles most cash flow patterns.
  • Common examples: One-click presets for investment analysis.

XIRR vs IRR

IRR Assumes periodic (e.g., annual) cash flows; dates ignored.
XIRR Exact dates → accurate for irregular contributions/withdrawals.

Frequently Asked Questions

XIRR requires at least one negative and one positive cash flow. If all flows are same sign, no real rate exists. Also try different initial guess or check if cash flows are too extreme.

We use actual day count (365 days/year). The first cash flow date is used as the reference (day 0).

Absolutely. XIRR is ideal for SIPs or irregular savings. Just input each contribution date.