How to use
- By period (IRR): list the cash flows from period 0 onward, one per line. Money you put in is negative and money you get back is positive. Pick the length of one period (year, half-year, quarter, month, week) to also see the annualized return.
- By date (XIRR): enter a date and an amount on each line, like
2024-01-15 -10000. This suits deposits and withdrawals at irregular intervals. - Enter a discount rate to also see the net present value (NPV) at that rate. Leave it empty to skip.
- The table below the result shows each cash flow discounted at the IRR.
The currency starts to match the country you visit from. Pick another currency and the amounts you entered are converted at live exchange rates.
What IRR means
The internal rate of return is the discount rate that makes the net present value exactly 0. It is the rate at which the present value of what you put in equals the present value of what you get back, so it reads like the yearly return of a single investment.
0 = CF₀ + CF₁ ÷ (1 + r) + CF₂ ÷ (1 + r)² + … + CFₙ ÷ (1 + r)ⁿ
There is no closed-form solution, so it is found by iteration. This calculator scans rates from −99% upward, finds where the sign of the NPV flips, and narrows each spot by bisection so every solution is found.
| Kind | Time unit | Reference point |
|---|---|---|
| IRR (by period) | Number of periods | First cash flow is period 0, not discounted |
| XIRR (by date) | Days apart ÷ 365 | Earliest date is the start |
| Annualized | (1 + period IRR)^(periods per year) − 1 | 1% a month is 12.6825% a year |
Examples
| Cash flows | Result |
|---|---|
| −100, 110 | IRR 10% |
| −100, 0, 121 | IRR 10% (121 = 100 × 1.1²) |
| −100, 50 | IRR −50% |
| −10,000 up front, then 3,000 / 3,500 / 4,000 / 4,500 each year | about 17.0937% a year |
| NPV of the same flows at an 8% discount rate | about 2,261.43 |
| 2024-01-01 −10,000 / 2024-07-01 1,500 / 2025-01-01 2,000 / 2025-12-31 9,000 | XIRR about 14.5921% |
How it compares with a spreadsheet
- The spreadsheet IRR function treats values as evenly spaced periods with the first value at period 0, the same as the by-period mode here.
- The spreadsheet XIRR function also divides day differences by 365, so the same input gives nearly the same result.
- The spreadsheet NPV function discounts even the first value by one period. Here the first value sits at period 0, so in a spreadsheet you add that first amount outside the NPV function to match.
Things to keep in mind
- IRR only exists when there are both outflows and inflows. If everything is negative or everything is positive there is no solution.
- If the sign of the cash flow changes more than once (for example a project with a clean-up cost at the end) there can be several solutions. −100, 230, −132 has both 10% and 20%. Look at NPV as well in such cases.
- IRR assumes interim cash is reinvested at the same rate. If you can only reinvest at a lower rate, your real return is lower than the IRR.
- Size does not matter to IRR. A high IRR on a small amount can still mean a small absolute gain.
- Taxes and fees are not included. A comma is read as a thousands separator when the number looks like 1,000; if in doubt, put one amount per line.
For a simple return use the ROI calculator, for growth between two values the CAGR calculator, and for present and future values the future value calculator.
FAQ
What IRR counts as a good investment?
There is no universal number. Compare it with the risk, with the rate on savings or other alternatives, and with the minimum return you need (your cost of capital). When IRR is above the cost of capital, NPV at that rate is positive.
How is IRR different from CAGR?
CAGR uses only two points, the start and the end. IRR accounts for every deposit and withdrawal in between. With no cash flows in between, the two are equal.
Why does my result differ slightly from a spreadsheet?
Date-based results count 365 days as a year, and even the same method in a spreadsheet can differ in the later decimals. Also check that you did not skip a line in the by-period mode and that the first value is meant to be period 0.
Is my input stored anywhere?
No. Your cash flows are processed in your browser only and never sent to a server.