XIRR Calculator: Your Real Money-Weighted Return
Quick answer: this XIRR calculator takes the dates and amounts of the money you paid in and took out, plus the value you hold today, and shows one yearly rate of return that fits all of them. XIRR is the money-weighted return of your own cash flows: it counts when each amount moved, not only how much. Enter your dated amounts below and the rate appears as you type.
Your cash flows
Money paid in is negative (a deposit or purchase). Money taken out is positive. Put the value you hold today in the last row, dated today.
Money-weighted return (XIRR)
—
Add at least one amount paid in (negative) and one taken out or held today (positive), on different dates.
- Total paid in
- —
- Taken out + value today
- —
- Net gain
- —
- Period covered
- —
Runs in your browser. Nothing you type is uploaded or stored.
What XIRR means
XIRR meaning, in one line: the single yearly rate that connects every dated deposit and withdrawal to the value you hold today. It is the same idea as an interest rate on a savings account, found backwards. A bank tells you the rate and you work out the balance; XIRR starts from the balance and the dated amounts, and solves for the rate that would have produced them.
Because the dates matter, two investors holding the same funds can have different XIRR figures. If one paid most of their money in before a strong year and the other paid in after it, the holdings match but the cash flows do not, and the yearly rate on each person’s own money differs.
Money-weighted return: why the timing of your money matters
A money weighted return gives more weight to the periods when more of your money was invested. Picture an illustrative example with invented numbers: a large deposit made just before a market fall, against the same deposit made just before a rise. The holdings are identical, the fund’s own performance is identical, but the first investor had more money exposed to the fall and the second had more exposed to the rise. Their money-weighted returns differ, because their money was in the market at different moments.
A time-weighted return removes the effect of deposits and withdrawals altogether and is the figure funds and factsheets report. The two answer different questions: one describes how the investments did, the other describes how your money did. The full comparison, and the question of which return to track, has its own article.
What to enter: dates and amounts
The calculator works from a list of dated amounts. Three things go on it:
- Each deposit and each withdrawal, with its date. Money paid in is entered as a negative amount; money taken out as a positive one. Dividends you withdrew count as money out; dividends reinvested stay inside and need no row.
- The value of the holdings today, dated today. This closes the list. Enter it as a positive amount, as if you had sold everything at today’s value.
- The result is a yearly rate whatever the length of the period. Three months or ten years, the figure is expressed per year so periods can be compared.
The XIRR formula in Excel and Google Sheets
The XIRR formula in a spreadsheet takes the same list the calculator does. In Excel and Google Sheets it is written as:
Spreadsheet formula=XIRR(values, dates, [guess])
values is the range of amounts, with money paid in as negative numbers and money received, including today’s value, as positive numbers; the range must contain at least one of each. dates is the range of matching dates, one per amount, and the first date in the list is the start of the period. The dates must be real spreadsheet dates, not text. guess is optional: a starting estimate for the rate, which the spreadsheet uses to begin its search and which rarely needs changing. The spreadsheet and this calculator use the same idea and the same inputs, so the figures agree.
Why your broker’s number can differ
Broker apps often show a simple percentage change, or a time-weighted figure, on the performance screen. Neither counts the timing of your own deposits, so neither matches a money-weighted rate, and a portfolio you paid into every month can show a very different figure in the app from the one here. Neither number is wrong. They measure different things, and the label on the screen tells you which. The guides to tracking a Fidelity account and tracking a Robinhood account show what two US brokerage apps report and how to read it.
When CAGR is enough
CAGR assumes a single amount that grows from a start date to an end date with nothing added or taken out. If that describes your holding, the calculator for growth when nothing is added gives the same answer with two values and a number of years. XIRR is for when money moves. A short article explains how CAGR works in more detail.
What the calculator leaves out
This money weighted return calculator does arithmetic on the dated amounts entered, and the result is only as complete as the list. Fees and tax are not included unless you enter them as amounts; the rate describes the past and does not forecast; and nothing here is advice. For other questions, the other Avex calculators each cover one.
Frequently asked questions
One yearly rate that fits every dated amount you entered: the deposits, the withdrawals and the value held today. It is the money-weighted return of your own cash flows, so it reflects when each amount went in or came out, not only how much.
Mathematical context only — not investment advice or a prediction. Capital at risk.
