Dataminal
CalculatorsIRR and XIRR

IRR and XIRR calculator

The internal rate of return of a series of cash flows: IRR when they are a period apart, XIRR when each has its own date.

  1. 0 (start)
  2. 1
  3. 2
  4. 3
  5. 4

Money paid out negative, money received positive: −1,000,000 then 300,000.

IRR15.3221%Per period: a year if the periods are years
Cash flows
5
Sign changesBetween outflows and inflows
1

Arithmetic on the figures entered. Not investment advice.

How it is calculated

IRR: Σ CFₜ ÷ (1 + IRR)^t = 0, t = 0, 1, 2 …XIRR: Σ CFᵢ ÷ (1 + XIRR)^((dᵢ − d₀) ÷ 365) = 0

Enter money paid out as negative and money received as positive. IRR treats the flows as evenly spaced, the first at period 0, so its rate is per period: per year when the periods are years. XIRR times each flow by its date, Actual/365 from the earliest, and gives an annual rate, as Excel's XIRR does.

Both are solved by bisection between −99.99% and 1,000%. With more than one sign change there can be more than one rate, and this is the one found in that range. Once money moves in or out along the way, a CAGR of the first and last values is not the same thing as XIRR.