Finance & Investment

How does XIRR work?

How does XIRR work: calculation method, required inputs, worked check, limitations and a link to XIRR Calculator. Reviewed 25 September 2026.

By Uddhav Gopani, FounderPublished 25 September 2026Reviewed 25 September 2026

For “How does XIRR work”, the linked XIRR Calculator is relevant because Free, browser-based XIRR Calculator.

What this specific question is asking

Treat the output as a consequence of the setup. For this query the setup is dated cashflows (one per line: yyyy-mm-dd, amount) — verify each for unit, period and meaning, then let XIRR Calculator do the arithmetic.

Validate by perturbation: nudge dated cashflows (one per line: yyyy-mm-dd, amount) by ten percent and watch the output. A result that barely moves — or jumps wildly — usually means a wrong unit or period, not a broken formula.

Inputs to verify

Verify dated cashflows (one per line: yyyy-mm-dd, amount) before calculation; if this value uses a different unit, period or definition, convert or restate it first.

Step-by-step check

List each cashflow on its own line as a date and an amount.
Use negative amounts for money invested and positive amounts for money received.
Make sure there is at least one negative and one positive flow.
Tap Calculate to see the annualised XIRR for those dated cashflows.

Worked example and sanity check

As a worked reference for “How does XIRR work”, Worked example XIRR finds the annualised return when cash flows land on irregular dates — e.g. investing 100,000 and withdrawing 130,000 exactly 18 months later gives roughly 19.1% XIRR.

Interpreting the result

Interpretation starts with magnitude. The worked example landed at ed return when cash flows land on irregular dates — e; compare yours before trusting the decimals. If the two disagree wildly, the setup — usually dated cashflows (one per line: yyyy-mm-dd, amount)'s unit or period — is the suspect. Treat the figure as an estimate under stated assumptions, not a promise of returns or a lending decision; fees, taxes and rate resets will move the real outcome.

Reviewed 25 September 2026

Verify any current tax threshold, lender rate, provider rule or health guidance with the authoritative source before acting.

Use the XIRR Calculator

Open XIRR Calculator

Common questions

Which inputs matter most for how does xirr work?

The key inputs are Dated cashflows (one per line: YYYY-MM-DD, amount). Match their units and periods before using XIRR Calculator.

How can I check an answer for how does xirr work?

Reproduce the worked example with its stated inputs first, then change dated cashflows (one per line: yyyy-mm-dd, amount) by a known amount and confirm the output moves the way the relationship predicts. Only then substitute your own values.

When should I recalculate how does xirr work?

Recalculate whenever any input's basis changes: a new measurement, a revised rate or threshold, a different period convention, or an updated policy figure.