Skip to content

IRR Calculator

Use this IRR calculator to find the internal rate of return of a series of cash flows. It also shows the NPV at your own discount rate and the payback period.

Cash flows

Enter the first row as the investment, usually negative. Rows are equal time steps.

Per period. Used for NPV.

Internal rate of return (per period)

19.25%

The return is above your 8% discount rate, so NPV is positive at that rate.

NPV at 8%
$2,948.72
Payback period
2.75 periods
Net total of cash flows
$6,000.00
Cash flows entered
6

Estimates only. Cash flows are forecasts, investment returns are not guaranteed, and past returns do not predict future ones. This tool is not financial advice.

Cash flows, present value and running total
PeriodCash flowPresent valueRunning total
Year 0-$10,000.00-$10,000.00-$10,000.00
Year 1$3,000.00$2,777.78-$7,000.00
Year 2$4,000.00$3,429.36-$3,000.00
Year 3$4,000.00$3,175.33$1,000.00
Year 4$3,000.00$2,205.09$4,000.00
Year 5$2,000.00$1,361.17$6,000.00

How to use this calculator

  1. 1 Enter the first row as your investment. It is usually a negative number.
  2. 2 Add one row for each later period with the cash you expect to receive. Rows must be equal time steps, such as years.
  3. 3 Enter your discount rate, which is the return you require per period.
  4. 4 Read the IRR, then check the NPV and the payback period.

What is the internal rate of return?

The internal rate of return (IRR) is the single rate of return that fits a whole series of cash flows. It is the discount rate at which the net present value (NPV) of all the flows is exactly zero.

In plain terms, it answers this: what steady yearly return would turn my money out today into the money I get back later? It works when cash comes in at different times, unlike a simple ROI.

How IRR is found

There is no direct formula for IRR when there are several flows. The calculator tries rates until the NPV reaches zero, using a repeated halving search between −99% and 1,000% per period.

The answer is a rate per period. If your rows are years, it is a yearly rate. If your rows are months, it is a monthly rate, so you may want to convert it.

How to read the result

Compare the IRR with your discount rate, the minimum return you would accept. If the IRR is higher, the NPV at your rate is positive, and the project beats your target. If it is lower, it does not.

The table below compares two projects that each cost $10,000, using an 8% discount rate.

Two projects, each costing $10,000 up front
ProjectCash backIRRNPV at 8%Payback
A$3,000, $4,000, $4,000, $3,000, $2,000 over years 1 to 519.25%$2,948.722.75 years
B$16,000 in year 59.86%$889.334.63 years

IRR and discount rate: how NPV changes

NPV falls as the discount rate rises. For project A, the NPV is $2,948.72 at 8%, $972.95 at 15% and −$1,107.84 at 25%. It crosses zero at the IRR of 19.25%.

This is why IRR is also the break-even rate. If your required return is higher than the IRR, the project loses value on those terms.

Limits to keep in mind

IRR is useful, but it has weak spots:

  • It needs a negative and a positive flow. Without both, there is no IRR.
  • Some flows have more than one IRR. This can happen when signs switch more than once, such as a late clean-up cost.
  • It assumes you can reinvest at the IRR. That can be unrealistic for a very high IRR.
  • It ignores size. A small project can have a high IRR but add little money. Check the NPV too.
  • Returns are not guaranteed. Cash flows are forecasts, and past returns do not predict future ones.

Related tools

To see how fast a project pays back, use the payback period calculator. To discount a single future amount, use the present value calculator. For a simple start-and-end growth rate, try the average return calculator.

The formula

Net present value

NPV = CF₀ + CF₁ ÷ (1 + r) + CF₂ ÷ (1 + r)² + … + CFₙ ÷ (1 + r)ⁿ

CFₜ
cash flow in period t (negative for money you pay, positive for money you receive)
r
discount rate per period as a decimal
n
last period

Internal rate of return

Find r so that NPV = 0

r
the IRR, per period

Worked example

A $10,000 investment that returns cash over five years

  1. 1.Cash flows: −$10,000, $3,000, $4,000, $4,000, $3,000, $2,000
  2. 2.Solve NPV = 0 for r: IRR ≈ 19.25% per year
  3. 3.NPV at 8%: −$10,000 + $3,000 ÷ 1.08 + $4,000 ÷ 1.08² + … ≈ $2,948.72
  4. 4.Running total turns positive in year 3: 2 + 3,000 ÷ 4,000 = 2.75 years

The IRR is 19.25% a year, the NPV at 8% is $2,948.72, and the payback period is 2.75 years.

Frequently asked questions

What is a good IRR?

It depends on your required return and the risk. A project is worth considering when its IRR is above your discount rate. A higher IRR is better only if you trust the cash flow forecasts.

What is the difference between IRR and NPV?

NPV is a money amount: the value created at your discount rate. IRR is a rate: the discount rate where NPV is zero. Use both, because IRR ignores the size of the project.

What is the difference between IRR and ROI?

ROI is the total gain divided by the cost, and ignores timing. IRR takes timing into account, so it suits cash flows spread over several periods.

Why does the calculator say there is no IRR?

IRR needs at least one negative and one positive cash flow. If every flow has the same sign, no rate can bring NPV to zero.

Is the IRR a yearly rate?

It is a rate per period. If each row is a year, it is yearly. For monthly rows, the result is monthly, so convert it before comparing with yearly rates.

Can IRR be negative?

Yes. If you get back less than you put in, the IRR is below zero. It means the money lost value over the period.

Sources

Last reviewed by the GridCalculators team.