Skip to main content

Investment · FINANCIAL TOOLS

XIRR Calculator

Work out the annualised return on money paid in and taken out on irregular dates.

Understand the calculation

Calculation logic, formula, example and guardrails behind the estimate.

How it works

Every flow is placed on its actual date and the calculator solves for the single annual rate at which their present values sum to zero. Money leaving your pocket is negative; money coming back, including the current value of what you still hold, is positive.

The day count is Actual/365 measured from the earliest flow, so leap years need no special handling — a span containing 29 February is simply one day longer. There is no closed form for this, so the rate is found numerically: Newton-Raphson from a sensible starting guess, falling back to bisection on a bracketed sign change when Newton wanders outside the bounds.

More detail

The series is sorted before solving and shown in that order, because the schedule you read should be the schedule the arithmetic walked.

Where no rate exists, the calculator says so rather than returning zero. A series in which every flow points the same way has no rate of return — there is nothing for it to balance — and reporting 0% would be a wrong answer rather than an absent one.

For a single investment held over one period, use the CAGR calculator.

To project a regular monthly investment forward instead, see the SIP calculator.

For a property held over years, try the property return calculator.

Formula

Σ Aᵗ ÷ (1 + r)^(dᵗ ÷ 365) = 0, solved for r

The exponent is a fraction of a year in real days, which is what separates XIRR from IRR. IRR assumes evenly spaced periods; XIRR makes no such assumption, which is why it is the right tool for anything with irregular dates.

Aᵗ
The amount of flow t, signed.
dᵗ
Days from the earliest flow to flow t.
r
The annualised rate being solved for.
Worked example

₹1,00,000 invested in April 2023, ₹50,000 more in January 2024, ₹75,000 more in November 2024, ₹40,000 withdrawn in June 2025, and ₹2,60,000 still held as at August 2026.

  1. 01Total paid in₹2,25,000
  2. 02Total received, including current value₹3,00,000
  3. 03Net profit₹75,000
  4. 04Simple return on money paid in33.3%
  5. 05Days from first flow to last1,209
  6. 06Annualised return (XIRR)solved from the series

The simple return of 33.3% is not an annual figure and cannot be compared with anything. Two thirds of the money went in during the first eighteen months and the rest later, so the average rupee was invested for well under the full 1,209 days — which is precisely the adjustment XIRR makes and a straight percentage cannot.

Frequently asked questions

Common questions about the xirr calculator and the assumptions behind it.

Disclaimer

This calculator is provided for general information and planning only. It is not investment, tax or legal advice, and it does not take your personal circumstances into account. Outputs are estimates based on the assumptions stated on this page, exclude taxes and charges unless said otherwise, and market-linked returns are not guaranteed — the value of investments can fall as well as rise. Lending terms, rates and eligibility are decided by the lender. For advice on your own situation, speak to a qualified professional, several of whom you can consult on Finvestalk.