O'Reilly logo

Hands-On Financial Modeling with Microsoft Excel 2019 by Shmuel Oluwa

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required