Spreadsheet skills competitionTry our live spreadsheet skills quiz



Scenario and sensitivity analysis is an important part of financial modelling: Although we would like to predict the future exactly - unfortunately we cannot. So it is useful to model a range of scenarios and also to look at key outcomes and measure their sensitivity to their drivers.

Available on this page are two resources on scenario analysis: 1) A PDF overview, and 2) A spreadsheet illustrating the techniques discussed in the overview.

See a guide showing how scenario and sensitivity analyses may be done in financial models. Option Analyser
Download a spreadsheet illustrating the concepts described aboveOption Analyser