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.
- Free, no sign-up
- Nothing is sent to a server
- Worldwide
How to use XIRR Calculator online
- List your flows. Write the date and the amount on each line.
- Use the right signs. Put money in as a minus and money out as a plus.
- Add the current value. Close with a plus line for what the investment is worth.
- 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?
What sign do deposits have?
How is XIRR different from a simple return?
Can I use it for a monthly investment plan?
Does it match spreadsheet results?
Where do the numbers I type in the XIRR Calculator go?
How do I send my XIRR Calculator numbers to someone?
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.