This example is included in the attached Excel fileEssentially, the assumptions used in the model are linked from cells L17L24 (mainly in cyan) These values are drawn from the scenario table to the right of the highlighted yellow range (eg cells N17N24 constitute Scenario 1The "Base" case, cells O17O24 constitute Scenario 2) The Scenario Selector is located in cell H12 Excel Tools to Assist in Performing Sensitivity and Scenario Analysis Choose Function The CHOOSE function is very useful when creating scenarios in financial models By using the CHOOSE formula, an analyst is able to select between 5 different scenarios that can flow through the entire model Goal Seek Function The following Excel template is a model used for sensitivity and scenario analysis (or WhatIf analysis) The Excel template provides 2 types of data tables;
3
