Menu
PDF Tools
Image Tools
Converters & Utilities
Seller & Print Tools
Accounting & Business
Calculators
Text & Writing Tools
Developer & Web Tools
Creator & Social Tools
Browser Utilities & Games
Document & Design Makers
Text & Developer Tools
Exam & Form Tools

XIRR Calculator

This calculator finds the yearly return of an investment with deposits and withdrawals on different dates. You list the dated cash flows and it gives the XIRR, the total money in and out and the net gain.

How to use XIRR Calculator online

  1. List your flows. Write the date and the amount on each line.
  2. Use the right signs. Put money in as a minus and money out as a plus.
  3. Add the current value. Close with a plus line for what the investment is worth.
  4. Read the rate. See the XIRR and the totals.

Why use this free XIRR Calculator

  • XIRR in percent
  • Any number of flows
  • Totals and net gain
  • Flows listed in a table
  • Date checks
  • Share by link

Why XIRR

A simple return ignores when money moved. If you invest at several dates, a plain percentage hides the timing. XIRR, the extended internal rate of return, finds the single yearly rate that makes all your dated cash flows add up to zero in today's terms.

How to enter flows

Type one flow per line: the date as year-month-day, then the amount. Money you put in is a minus number and money you get back is a plus number. A final line with the current value of the investment as a plus number closes the list.

A worked example

Investing 1000 on 2023-01-10 and again on 2024-01-10, then getting back 2400 on 2025-01-10, has total money in of 2000, money out of 2400 and a net gain of 400. The XIRR is 12.76 percent per year, over 731 days.

How it is solved

The page tries yearly rates until the sum of each flow divided by (1 + rate) to the power of the years since the first date is zero. A year is 365 days. This is the same definition spreadsheets use for the XIRR function, so you can check a result against one.

When no answer exists

You need at least one minus flow and one plus flow. If all flows have the same sign, no rate can balance them and the page says so. Dates must be real calendar dates, and the flows can be in any order.

Using the calculator

There is no button to wait for: the XIRR Calculator results follow every keystroke. Your numbers are remembered on this device if you leave that switch on.

XIRR Calculator: frequently asked questions

What does XIRR mean?
Extended internal rate of return: the yearly rate that balances dated cash flows.
What sign do deposits have?
Minus. Money you receive has a plus sign.
How is XIRR different from a simple return?
It takes the dates of every flow into account, so earlier money counts for more time.
Can I use it for a monthly investment plan?
Yes. Add one minus line for each monthly investment and a final plus line for the current value.
Does it match spreadsheet results?
It uses the same 365-day year, so the results should agree closely.
Where do the numbers I type in the XIRR Calculator go?
No. The XIRR Calculator does its sum in your browser, and nothing is uploaded.
How do I send my XIRR Calculator numbers to someone?
Download a CSV for a spreadsheet or a PDF to print; both carry the XIRR Calculator inputs and results.

Related searches for XIRR Calculator

  • XIRR Calculator online
  • free XIRR Calculator
  • XIRR Calculator online free
  • XIRR Calculator for mobile
  • XIRR Calculator without sign up
  • xirr formula
  • xirr calculator with table
  • XIRR Calculator – Loans & Investing

XIRR Calculator is a free online tool on MAITBOX, in the Loans & Investing group. It runs in your browser, so what you type is not sent to a server. It works on Android and iPhone, and on Windows, Mac and Linux, with no download and no account.

More tools in Loans & Investing →

Search tools