XIRR calculator
XIRR is the annual rate that sets the present value of dated cash flows to zero. Deposits are money you put in; withdrawals and the ending value are money back. It is not CAGR.
XIRR is the annual rate r that sets the NPV of dated cash flows to zero, using Excel’s actual/365 year fraction.
XIRR
Enter at least one deposit and one inflow (a withdrawal or ending value), each with a date. Empty rows are ignored.
How to calculate XIRR
- Enter each cash flow. Pick deposit (money you put in), withdrawal, or ending value, then the amount and the date.
- Include an ending value. The last positive flow is usually what the portfolio is worth on that date. Empty rows are ignored.
- Read the annual rate. XIRR is a yearly rate. If no rate sets NPV to zero, or more than one rate could, the result stays blank.
Frequently asked questions
- How do you calculate XIRR?
- Find the annual rate that makes the present value of every dated cash flow sum to zero. A $10,000 deposit on 1 Jan 2019 and $11,000 back on 1 Jan 2020 is a 10% XIRR. Deposits are money out; withdrawals and the ending value are money in.
- Why isn't XIRR the same as CAGR?
- CAGR assumes one lump sum and no cash in or out. XIRR dates each deposit and withdrawal, so extra contributions are not treated as if they had been there from day one.
- Is this investment advice?
- No. The calculator is for general informational and educational purposes only. It is not a recommendation to buy, sell, or hold any security.