Sign in or start a free trial to avail of this feature.
13. Find the Drivers of IRR
Some of our model inputs will have a bigger impact on our IRR than others. Find out which inputs are the most important using some simple sensitivity analysis.
Finding the input drivers of IRR
- Sensitivity analyses are a great way to find the variables that most affect IRR
1 Extend the sensitivity analyses inputs between optimistic and pessimistic values
2 Identify the inputs that have the biggest impact on our baseline IRR
3 Examine what will determine the final value of these inputs
SHIFT + →: Select next cell
ALT + A , W, T: Create data table