Skip to content
ENExplore Calculators

Extended IRR (XIRR) Calculator

Work out extended irr (xirr) instantly with clear inputs, formula shown and shareable results.

About Extended IRR (XIRR) Calculator

XIRR is the single annual rate that discounts irregularly timed cash flows back to zero. Because money invested later has less time to work, XIRR weights each contribution by how long it was actually deployed — which a simple return cannot do.

Formula

XIRR

0 = Σ CFₜ / (1 + r)^(tₜ), with tₜ measured in years

CF
Cash flow
r
Annualised rate

Worked example

With the default values below, Extended IRR (XIRR) Calculator returns Extended IRR (XIRR) of 10.478%. Change any input above and every figure here is recalculated in your browser.

Inputs used

Initial Investmentminimum 0
100,000
Further Investment At The Midpointminimum 0
50,000
Value At The Endminimum 0
210,000
Holding Period In Yearsaccepts 0.25–50
4

Results

Extended IRR (XIRR)
10.478%
Total Invested
$150,000.00
Absolute Gain
$60,000.00
Value As A Multiple Of Cost
1.400

Step by step

  1. 1Values used
  2. 2XIRR
  3. 3Extended IRR (XIRR)= 10.478
  4. 4Total Invested= 150,000.00
  5. 5Absolute Gain= 60,000.00
  6. 6Value As A Multiple Of Cost= 1.400

Assumptions and limits

  • The result is derived only from the 4 inputs listed above. Anything not among them is not part of the calculation.
  • In particular, this calculator does not take inflation, tax or fees or charges into account.
  • Figures are rounded for display to 3 decimal places, so totals built from several rounded parts can differ slightly from the unrounded arithmetic.
  • Figures are estimates for planning only. Market returns are not guaranteed, and rates, limits and tax rules change. This is not financial or tax advice — speak to a qualified adviser before acting.
  • This is an estimate for general information and not professional financial, tax or legal advice. See the full disclaimer for the limits that apply to this kind of calculator.

How these calculators are built and tested is described on the Methodology page. If a figure looks wrong, please report it.

Figures are estimates for planning only. Market returns are not guaranteed, and rates, limits and tax rules change. This is not financial or tax advice — speak to a qualified adviser before acting.

Frequently Asked Questions

How does XIRR differ from CAGR?

CAGR assumes one investment and one exit. XIRR handles any number of contributions and withdrawals on any dates.

Why is it solved numerically?

The equation is a polynomial in the rate with no closed-form solution, so bisection or Newton's method is used.

Related Calculators

Extended IRR (XIRR) Calculator | Calcrivo