Two is better than one
The true power of Data Tables is revealed with multiple variables. In the previous exercise we saw how sensitivity analysis can be performed with just one input variable, but we may be interested in analyzing how two inputs relate to each other and the dependent variable.
Let's see how changes in our Rent Growth %
and Starting Rent
assumptions impact the net operating income.
If you have lost progress, close any open workbooks and load 2_3_data_tables.xlsx
from the Exercises folder.
This exercise is part of the course
Financial Modeling in Excel
Hands-on interactive exercise
Turn theory into action with one of our interactive exercises
