Microsoft Office Tutorials and References
In Depth Information
Chapter 18: Using Scroll Bars for Sensitivity Analysis
Using Scroll Bars for
Data tables, as shown in the last chapter, are excellent tools for sensitivity analysis.
One problem you may encounter when using them
especially if you want to
analyze many inputs
is that you have to create a number of tables
to have an extensive analysis. As data tables are limited to a maximum of two
variables for any output, it may be difficult to view a few or all the tables simulta-
neously, and it might become a difficult undertaking.
A different solution to modify the input is to use scroll bars. Scroll bars were
created in Excel for changing values in forms. You are going to harness the power of
these scroll bars to change input values in the financial statements of decision-making
models, analyzing the impact of these changes on the output.
To illustrate this idea go back to our car loan example used in the last couple of
chapters. See Figure 18.1. This loan example has a number of inputs: price, down
FIGURE 18.1 The Car Loan Example