Back to glossary
I

Internal Rate of Return (IRR)

A clear, practical guide to Internal Rate of Return. Learn what IRR means, how to calculate it, how to use it in investment decisions, common pitfalls, and Excel tips.

What IRR means

Internal Rate of Return, or IRR, is the interest rate that makes the net present value of a set of cash flows equal to zero. In plain terms, it is the break even rate an investment earns. If the IRR is higher than your required return or cost of capital, the project looks attractive. If it is lower, you would likely reject it.

IRR is expressed as a percentage. It helps compare projects that last different lengths of time or have different cash patterns.

The basic formula

IRR is the r that solves this equation:

0 = NPV = sum of (Ct / (1 + r)^t)

where Ct are cash flows at time t. One cash flow is usually negative at t = 0 for the initial cost, and future Ct are positive or negative returns.

You rarely solve this formula by hand. It is nonlinear. People use a calculator, Excel, or iterative methods.

Simple examples

One year example:

  • Pay 100 today, get 120 in one year.
  • IRR = (120 / 100) - 1 = 20%.

Two year example:

  • Pay 100 today, get 60 at year 1 and 60 at year 2.
  • Solve 0 = -100 + 60/(1 + r) + 60/(1 + r)^2.
  • This leads to a quadratic with r about 13.07%.

These examples show IRR as the implied annual return of the cash flows.

How to compute IRR

  • Spreadsheet: use =IRR(range) for equally spaced periods. Use =XIRR(values, dates) for uneven dates.
  • Calculator: most financial calculators have an IRR function.
  • By hand: use trial and error or Newton's method. Start with a guess and iterate until NPV is close to zero.
  • For non-standard cash flows use MIRR to avoid some problems. See below.

Decision rule

  • If IRR > required rate of return, accept the project.
  • If IRR < required rate, reject it.

This works when you evaluate one project on its own and cash flows are conventional: one initial outflow followed by inflows.

Why IRR is popular

  • It is intuitive. People like percent rates more than NPV dollar numbers.
  • It is unit free. You can compare projects of different sizes at a glance.
  • Many managers prefer a single rate to describe a project.

Important limits and pitfalls

  1. Multiple IRRs
  • If cash flows change sign more than once, the IRR equation can have multiple solutions. That gives you more than one IRR. That is confusing and unreliable.
  1. No IRR
  • Some cash flows never give a real IRR. The equation may not cross zero.
  1. Reinvestment assumption
  • IRR assumes interim cash flows are reinvested at the IRR itself. This can be unrealistic if IRR is very high. MIRR fixes this by assuming reinvestment at a chosen rate, usually the cost of capital.
  1. Ranking conflicts with NPV
  • IRR can favor a small project with a high percentage return over a larger project that adds more total value. NPV measures value added in dollars. For mutually exclusive projects, prefer NPV to pick the one that increases firm value most.
  1. Timing and scale
  • A higher IRR does not always mean a better investment in terms of absolute dollars. Pay attention to project size and timing of cash flows.

Use cases where IRR is helpful

  • Quick screening of investments.
  • Comparing many projects when you want a simple metric.
  • Explaining project returns to non-technical stakeholders.
  • Private equity and venture investments where percentage returns matter.

When to use MIRR and XIRR

  • Use MIRR when cash flows are non-conventional or you want a realistic reinvestment rate. Excel has =MIRR(range, finance_rate, reinvest_rate).
  • Use XIRR when cash flows occur on irregular dates. Excel =XIRR(values, dates) gives a more precise annual rate.

Practical tips

  • Always calculate NPV as well. NPV tells you the value created in dollars.
  • Use IRR to rank projects, but use NPV to choose among mutually exclusive options.
  • Report both IRR and NPV together in decision documents.
  • For long projects, check sensitivity of IRR to changes in cash flow timing and size.
  • If you see strange results, check cash flow signs. A sequence like -100, +230, -132 can create multiple IRRs.

Short summary

IRR is the discount rate that makes NPV zero. It gives a single percentage return for a project. It is easy to use and intuitive. But it has limits. It can give multiple answers, assume unrealistic reinvestment, and mislead on project rankings. Always pair IRR with NPV, and use MIRR or XIRR when cash flows are irregular or non-standard.

If you want, I can show step by step how to calculate IRR in Excel or a financial calculator using a specific cash flow example.

Related Terms

Insider Trading
Insider trading explained in simple terms. Learn the difference between legal and illegal insider trading, who counts as an insider, common examples, penalties, and how to avoid trouble.
Interest Rate
Clear, simple explanation of interest rate. Learn types, how to calculate simple and compound interest, why rates change, and how they affect loans, savings, and the economy.
Internal Revenue Service (IRS)
Learn what the Internal Revenue Service (IRS) is, what it does, how it affects individuals and businesses, and how to handle taxes, audits, notices, and payments. Clear, simple, and practical.
International Monetary Fund (IMF)
The International Monetary Fund (IMF) is a global financial institution that helps countries stabilize their economies, manage balance of payments, and promote growth. This article explains what the IMF does, how it works, common programs, criticisms, and why it matters to ordinary people.