Conflict Between NPV and IRR (And Problem with IRR)

When you are analyzing a single conventional project, both NPV and IRR will provide you the same indicator about whether to accept the project or not. However, when comparing two projects, the NPV and IRR may provide conflicting results. It may be so that one project has higher NPV while the other has a higher IRR. This difference could occur because of the different cash flow patterns in the two projects.

The following example illustrates this point.

Project AProject B
Year 0-5000-5000
Year 120000
Year 220000
Year 320000
Year 420000
Year 5200015000
NPV$2,581.57$4,313.82
IRR29%25%

The above example assumes a discount rate of 10%. As you can see, Project A has higher IRR, while Project B has higher NPV.

If these two projects were independent, it wouldn’t matter much because the firm can accept both the projects. However, in case of mutually exclusive projects, the firm needs to decide one of the two projects to invest in.

When facing such a situation, the project with a higher NPV should be chosen because there is an inherent reinvestment assumption. In our calculation, there is an assumption that the cash flows will be reinvested at the same discount rate at which they are discounted. In the NPV calculation, the implicit assumption for reinvestment rate is 10%. In IRR, the implicit reinvestment rate assumption is of 29% or 25%. The reinvestment rate of 29% or 25% in IRR is quite unrealistic compared to NPV. This makes the NPV results superior to the IRR results. In this example, project B should be chosen.

The above example illustrated the conflicting results of NPV and IRR due to differing cash flow patterns. The conflicting results can also occur because of the size and investment of the projects. A small project may have low NPV but higher IRR.

Project AProject B
Year 0-5000-20000
Year 120007000
Year 220007000
Year 320007000
Year 420007000
Year 520007000
NPV$2,581.57$6,535.51
IRR29%22%

In this case, Project A has lower NPV compared to Project B but a higher IRR. Again, if these were mutually exclusive projects, we should choose the one with higher NPV, that is, project B.

Data Science in Finance: 9-Book Bundle

Data Science in Finance Book Bundle

Master R and Python for financial data science with our comprehensive bundle of 9 ebooks.

What's Included:

  • Getting Started with R
  • R Programming for Data Science
  • Data Visualization with R
  • Financial Time Series Analysis with R
  • Quantitative Trading Strategies with R
  • Derivatives with R
  • Credit Risk Modelling With R
  • Python for Data Science
  • Machine Learning in Finance using Python

Each book includes PDFs, explanations, instructions, data files, and R code for all examples.

Get the Bundle for $39 (Regular $57)
JOIN 30,000 DATA PROFESSIONALS

Free Guides - Getting Started with R and Python

Enter your name and email address below and we will email you the guides for R programming and Python.

Data Science in Finance: 9-Book Bundle

Data Science in Finance Book Bundle

Master R and Python for financial data science with our comprehensive bundle of 9 ebooks.

What's Included:

  • Getting Started with R
  • R Programming for Data Science
  • Data Visualization with R
  • Financial Time Series Analysis with R
  • Quantitative Trading Strategies with R
  • Derivatives with R
  • Credit Risk Modelling With R
  • Python for Data Science
  • Machine Learning in Finance using Python

Each book comes with PDFs, detailed explanations, step-by-step instructions, data files, and complete downloadable R code for all examples.