1. Home
  2. Finance
  3. IRR Calculator

IRR Calculator

Internal rate of return and NPV from a list of cash flows.

Runs in your browser · No upload
Investments (outflows) are negative, returns are positive. One per line or separated by spaces. The first value is period 0 and is not discounted.
%
Annual rate. Leave empty to skip NPV.
Annualized IRR
17.0937%
Rate per period. Annualized as (1 + r)^1 − 1
Total inflows (positive sum)
$15,000.00
Total outflows (negative sum)
$10,000.00
Net gain
$5,000.00
Cash flows
PeriodAmountPresent value (at IRR)
0-$10,000.00-$10,000.00
1$3,000.00$2,562.05
2$3,500.00$2,552.71
3$4,000.00$2,491.49
4$4,500.00$2,393.75
For reference only. IRR assumes interim cash is reinvested at the same rate, and taxes and fees are not included.

How to use

  1. 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.
  2. 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.
  3. Enter a discount rate to also see the net present value (NPV) at that rate. Leave it empty to skip.
  4. 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.

Can't find the tool you need?

Tell us what you want to do. We build the most requested tools first.