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 ...
