- Calculating Net Present Value (NPV) and Internal Rate of Return (IRR) in Excel
- Net Present Value of a Project
- The Capital Budgeting Process
- Principles of Capital Budgeting
- Mutually Exclusive Projects, Project Sequencing, and Capital Rationing
- How to Calculate Payback Period
- How to Calculate Discounted Payback Period
- Calculating Profitability Index of a Project
- Conflict Between NPV and IRR
Conflict Between NPV and 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 A | Project B | |
Year 0 | -5000 | -5000 |
Year 1 | 2000 | 0 |
Year 2 | 2000 | 0 |
Year 3 | 2000 | 0 |
Year 4 | 2000 | 0 |
Year 5 | 2000 | 15000 |
NPV | $2,581.57 | $4,313.82 |
IRR | 29% | 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 A | Project B | |
Year 0 | -5000 | -20000 |
Year 1 | 2000 | 7000 |
Year 2 | 2000 | 7000 |
Year 3 | 2000 | 7000 |
Year 4 | 2000 | 7000 |
Year 5 | 2000 | 7000 |
NPV | $2,581.57 | $6,535.51 |
IRR | 29% | 22% |
In this case, Project A has lower NPV compared to Project B but has higher IRR. Again, if these were mutually exclusive projects, we should choose the one with higher NPV, that is, project B.
Related Downloads
Related Quizzes
Data Science in Finance: 9-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)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.