Incremental IRR is a way to analyze the financial return when there are two competing investment opportunities involving different amounts of the initial investment.
In this post, we will explore how to calculate incremental IRR and how it helps in deciding between two projects with different investments.
Let's consider a project with the following cash flow stream:
Assume a 10% discount rate.
The IRR/NPV can be calculated by using Excel IRR/NPV functions.
The project IRR is 13.27% and the NPV is 128.5.
Now let's consider another project with the following cash flow stream:
The IRR for this project is 12.78% and the NPV is 220.1.
So which project should we take? If you notice, the initial investment for the second project is twice the investment required for the first project.
In such situations, we should calculate incremental IRR. It is defined as the internal rate of return of incremental cash flows.
The incremental cash flow is the difference between the cash flows of the two projects.
The IRR for the incremental cash flow is 12.29% and the NPV is 91.7.
So what should we do? Should we take Project 1 or Project 2?
Key points about incremental IRR
If it is higher than the minimum return you consider acceptable, you should take project 2 i.e. project with higher investment.
However, qualitative issues must be considered before making any investment decision. There may be an incremental risk associated with the more expensive investment option.
Hope you enjoyed this post on incremental IRR. If you have any questions, let me know in the comment section below.
You can also download the Incremental IRR Workbook for FREE!
Check out more useful articles on Our Blog Page
Are you someone involved with real estate feasibility?
We are excited to launch the next generation of real estate feasibility software by April 2023.
claim your 15% early-bird discount
Know more about the product features