CCalclabhub

Finance · 111 calculators

IRR Calculator

The internal rate of return is the discount rate that makes an investment's net present value exactly zero. It is the break-even rate the project must beat, and it lets you compare projects of different sizes on a single percentage scale.

Last updated

Internal rate of return

0.00%

Annuity factor
3.3333
Total cash received
$15,000.00
Total profit
$5,000.00
NPV at required return
$1,372.36

Values update as you type. This calculator covers the single scenario its formula assumes — see Common Mistakes for what it leaves out.

The formula this calculator uses

NPV = 0 at the rate r, so r is the IRR

C0
Initial investment at time zero
CF
Cash received each year
n
Number of years
IRR
Rate that makes NPV zero

How to check the result by hand

  1. 1

    Lay out the cash flows

    List the initial cost as a negative at year zero and each year's inflow as a positive. Timing matters, so be precise about which year each flow falls in.

  2. 2

    Compute the cost-to-cash ratio

    Divide the initial cost by the annual cash flow. 10,000 divided by 3,000 gives 3.333, the annuity factor for five years.

  3. 3

    Search for the matching rate

    Find the rate whose five-year annuity factor equals 3.333. Trial rates converge quickly, or a spreadsheet's IRR function solves it directly.

  4. 4

    Compare with your hurdle rate

    If the IRR exceeds the return you require, accept the project. If it falls short, the project destroys value at your cost of capital.

  5. 5

    Check the NPV too

    Confirm the NPV at your required rate is positive for the same cash flows. When scale differs, trust the NPV, not the IRR.

Common Questions

How does the IRR Calculator work?

The IRR is the single rate that discounts every future cash flow back to exactly the upfront cost. Spend 10,000 to receive 3,000 a year for five years and the IRR is roughly 15.24%, because discounting those five payments at 15.24% yields exactly 10,000. If your required return is below that, the project adds value.

What do I need to enter in the IRR Calculator?

It takes 4 inputs: Initial investment, Annual cash flow, Years, Required return (percent). Fields that expect a unit say so next to the label.

Where does Internal rate of return come from?

It comes from 0 = -C0 + sum CF / (1 + IRR)^t — the rate that discounts every cash flow back to the initial cost.

What is the most common mistake with the IRR Calculator?

Ranking projects by IRR instead of NPV. A high percentage on a small project can add less wealth than a modest percentage on a large one. Use NPV for the accept-or-reject and ranking decision.

For worked examples, common mistakes and the limits of this formula, read the full How To Calculate IRR page.