Useful Hacks

XIRR Calculator

Calculate annualized returns for irregular cash flows.

Calculated locally in your browser. Nothing you enter is uploaded or stored.

Overview

XIRR calculates the annualized return of a series of cash flows that occur on irregular dates — such as multiple SIP top-ups, redemptions and a final withdrawal.

How to use it

  1. 1Add each cash flow with its date and amount (negative for money invested, positive for money received).
  2. 2Add the final value as a positive cash flow on today's date.
  3. 3The XIRR is solved numerically and shown as an annualized percentage.

How it works

XIRR is solved by finding the discount rate that makes the net present value of all dated cash flows equal to zero, using an iterative Newton-Raphson search.

Tips

  • This calculator provides an estimate for planning purposes only and is not financial advice.

Frequently asked questions

Related tools

All finance tools

Search tools

Search for any tool by name, category or keyword