The indirect method

This method links the table to formulas that include the variables or drivers we have selected. To do this, we first set up data tables, as shown in the following screenshot:

All three inputs have a change base value of 0.0%, which will be added to formulas that include the inputs we have selected. Then, we also add two additional values of -2.5% and 2.5% for turnover growth and cost of sales, and -1.0% and 1.0 for terminal growth rate. The change values signify the range over which we will be testing the sensitivity of our model with data tables using the indirect method.

You then edit the relevant formulas to link the ...

Get Hands-On Financial Modeling with Microsoft Excel 2019 now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.