Skip to content

IRR Calculator

Enter an initial investment and the cash flows that follow to find the IRR and NPV, and see how NPV changes with the discount rate.

FinancialUpdated Free · No sign-up

How to use the IRR Calculator

  1. Type or paste Cash flows, period 0 first (Enter the initial investment as a negative number, then each period’s cash flow).
  2. Enter Discount rate for NPV.
  3. Read your answer in the results panel. It updates as you type, and the breakdown, step-by-step working and any charts or tables appear below it.
  4. Use Share link to save or send the exact calculation, or Copy to paste the results elsewhere.

NPV and IRR in brief

Capital budgeting asks whether a project’s future cash flows justify what it costs today. Two linked measures answer this:

  • Net present value (NPV) discounts every cash flow back to today at your required return and adds them up. A positive NPV means the project earns more than that return.
  • Internal rate of return (IRR) is the discount rate that makes the NPV exactly zero. A project is attractive when its IRR is above your cost of capital.

Formulas

NPV = Σ CFt ÷ (1 + r)t, t = 0 … n

IRR: the r for which Σ CFt ÷ (1 + r)t = 0

The period 0 cash flow, usually the negative initial investment, is not discounted. IRR has no closed-form solution, so it is found numerically with Newton’s method, falling back to bisection when needed.

Worked examples

  • Invest $1,000 and receive $500 at the end of each of the next three years. At a 10% discount rate, NPV = −1,000 + 500/1.1 + 500/1.21 + 500/1.331 = $243.43. The IRR is 23.3752%.
  • With the default flows of −$10,000, $3,000, $4,200 and $6,800, the IRR is 16.34% and the NPV at 10% is $1,307.29.
  • Invest $1,000 and get $1,210 back after two years: IRR = 10% and NPV at 10% is zero.

Reading the NPV profile

The chart plots NPV against the discount rate. Where the line crosses zero is the IRR. A steep line means the project’s value is sensitive to the rate, typical of projects whose cash comes late.

Caveats

  • If the cash flows change sign more than once, for example a big repair cost in a later year, there can be several IRRs or none. Rely on NPV and check the profile.
  • IRR assumes cash flows are reinvested at the IRR itself, which can overstate very high IRRs. When comparing projects of different sizes, NPV is the better guide.
  • The periods must be evenly spaced. For dated cash flows, use the money-weighted tab of the average return calculator.

Results are estimates for analysis and not investment advice.

Frequently asked questions

What is a good IRR?

An IRR is good when it is above your cost of capital or the return you could earn elsewhere with similar risk. Many businesses use hurdle rates between 8% and 15%.

What is the difference between NPV and IRR?

NPV is a dollar amount of value created at a chosen discount rate. IRR is the rate at which NPV is zero. They usually agree on accept or reject decisions, but NPV is more reliable when ranking projects of different sizes.

Why can't the calculator find an IRR?

IRR needs at least one negative and one positive cash flow, and the flows must cross zero NPV at some rate. Flows that change sign several times can have no IRR or several.