There are two methods in sensitivity analysis: the direct and indirect methods. Both methods make use of data tables that can be found under What If in the Forecast group on the Data ribbon in Excel. The following is a screenshot of the location of the Data Table... option:
In order to make use of the data table, you must structure your data in a particular way. The following screenshot shows the layout for a data table:
The cell in the top-left corner of the table layout must be related to the target value share price, whose behavior we wish to observe. That specific position is essential for the data table function to work. However, since it will not be used for anything else, it is shown here in a white font color, making it invisible to the naked eye, so as not to cause any distraction.
The row input values are entered across the top row...