Loading the player...

In capital budgeting, there are a number of different approaches that can be used to evaluate any given project, and each approach has its own distinct advantages and disadvantages.

All other things being equal, using internal rate of return (IRR) and net present value (NPV) measurements to evaluate projects often results in the same findings. However, there are a number of projects for which using IRR is not as effective as using NPV to discount cash flows. IRR's major limitation is also its greatest strength: it uses one single discount rate to evaluate every investment.

Although using one discount rate simplifies matters, there are a number of situations that cause problems for IRR. If an analyst is evaluating two projects, both of which share a common discount rate, predictable cash flows, equal risk, and a shorter time horizon, IRR will probably work. The catch is that discount rates usually change substantially over time. For example, think about using the rate of return on a T-bill in the last 20 years as a discount rate. One-year T-bills returned between 1% and 12% in the last 20 years, so clearly the discount rate is changing.

Without modification, IRR does not account for changing discount rates, so it's just not adequate for longer-term projects with discount rates that are expected to vary. (To learn more, read Taking Stock Of Discounted Cash Flow, Anything But Ordinary: Calculating The Present And Future Value Of Annuities and Investors Need A Good WACC.)

Another type of project for which a basic IRR calculation is ineffective is a project with a mixture of multiple positive and negative cash flows. For example, consider a project for which marketers must reinvent the style every couple of years to stay current in a fickle, trendy niche market. If the project has cash flows of -$50,000 in year one (initial capital outlay), returns of $115,000 in year two and costs of $66,000 in year three because the marketing department needed to revise the look of the project, a single IRR can't be used. Recall that IRR is the discount rate that makes a project break even. If market conditions change over the years, this project can have two or more IRRs, as seen below.


Thus, there are at least two solutions for IRR that make the equation equal to zero, so there are multiple rates of return for the project that produce multiple IRRs. The advantage to using the NPV method here is that NPV can handle multiple discount rates without any problems. Each cash flow can be discounted separately from the others.

Another situation that causes problems for users of the IRR method is when the discount rate of a project is not known. In order for the IRR to be considered a valid way to evaluate a project, it must be compared to a discount rate. If the IRR is above the discount rate, the project is feasible; if it is below, the project is considered infeasible. If a discount rate is not known, or cannot be applied to a specific project for whatever reason, the IRR is of limited value. In cases like this, the NPV method is superior. If a project's NPV is above zero, then it is considered to be financially worthwhile.

So, why is the IRR method still commonly used in capital budgeting? Its popularity is probably a direct result of its reporting simplicity. The NPV method is inherently complex and requires assumptions at each stage - discount rate, likelihood of receiving the cash payment, etc. The IRR method simplifies projects to a single number that management can use to determine whether or not a project is economically viable. The result is simple, but for any project that is long-term, that has multiple cash flows at different discount rates, or that has uncertain cash flows - in fact, for almost any project at all - simple IRR isn't good for much more than presentation value.

For more information on capital budgeting, see the guide on Capital Budgeting.

  1. How do you calculate IRR in Excel?

    Understand how to calculate the internal rate of return (IRR) in Excel and how it's used to determine anticipated yield per ... Read Answer >>
  2. What's the difference between weighted average cost of capital (WACC) and internal ...

    Both weighted average cost of capital (WACC) and internal rate of return (IRR) are great measures for assessing value, but ... Read Answer >>
  3. How do I use Excel to get discount rate over time?

    Learn how to calculate discount rate in Microsoft Excel and how to find the discount factor over a specified number of years. Read Answer >>
  4. What is the formula for calculating the internal rate of return (IRR)?

    Learn about the internal rate of return, an important concept in determining the relative attractiveness of different investments. Read Answer >>
  5. Why is the Modified Internal Rate Of Return (MIRR) preferable to the regular internal ...

    See why the modified internal rate of return is often a superior metric to the classic internal rate of return for assessing ... Read Answer >>
  6. How do you use discounted cash flow to calculate a capital budget?

    Learn how discounted cash flows are used in creating capital budgets as a part of the net present value and internal rate ... Read Answer >>
Related Articles
  1. Small Business

    Capital Budgeting: Which is Better, IRR or NPV?

    Using internal rate of return and net present value for capital budgeting evaluations often end in the same result. But there are times when using NPV to discount cash flows makes more sense.
  2. Investing

    Internal Rate of Return: An Inside Look

    Use this method to choose which project or investment is right for you.
  3. Investing

    Return on Investment (ROI) Vs. Internal Rate of Return (IRR)

    Read about the similarities and differences between an investment's internal rate of return (IRR) and its return on investment (ROI).
  4. Small Business

    Calculating the Internal Rate of Return Using Excel

    The internal rate of return on investments is explained and illustrated in different investment scenarios.
  5. Investing

    Internal Rate of Return Formula for Excel

    The internal rate of return, or IRR, is a popular metric businesses use to measure a project’s return on investment.
  6. Investing

    An Introduction To Capital Budgeting

    We look at three widely used valuation methods and figure out how companies justify spending.
  7. Financial Advisor

    Understanding Internal Rate Of Return

    Internal rate of return, or IRR, is one of the most popular methods of evaluating potential projects. Learn more about this important metric.
  8. Investing

    Private Equity on Steroids: How Debt Fuels Outsized Returns

    Hot Air: Many private equity firms use a legal technique that can boost returns by 25% or more, Bloomberg says
  1. Internal Rate Of Return - IRR

    A metric used in capital budgeting measuring the profitability ...
  2. IRR Rule

    A measure for evaluating whether to proceed with a project or ...
  3. The Net Internal Rate Of Return - Net IRR

    A measure of a portfolio or fund's performance that is equal ...
  4. Modified Internal Rate Of Return - MIRR

    While the internal rate of return (IRR) assumes the cash flows ...
  5. Net Present Value - NPV

    Net Present Value (NPV) is the difference between the present ...
  6. Discount Rate

    The interest rate charged to commercial banks and other depository ...
Hot Definitions
  1. SEC Form 13F

    A filing with the Securities and Exchange Commission (SEC), also known as the Information Required of Institutional Investment ...
  2. Quantitative Easing

    An unconventional monetary policy in which a central bank purchases private sector financial assets in order to lower interest ...
  3. Risk Averse

    A description of an investor who, when faced with two investments with a similar expected return (but different risks), will ...
  4. Indirect Tax

    A tax that increases the price of a good so that consumers are actually paying the tax by paying more for the products. An ...
  5. Zero-Sum Game

    A situation in which one person’s gain is equivalent to another’s loss, so that the net change in wealth or benefit is zero. ...
  6. Beta

    Beta is a measure of the volatility, or systematic risk, of a security or a portfolio in comparison to the market as a whole. ...
Trading Center