Due to the fundamental nature of the topic, and the richness (and potential complexity) of the possible variations, the subject is treated throughout the CertFM Program, with further aspects covered at almost all Levels of the program.
In this Chapter, we initially briefly cover the manual methods, before providing a detailed discussion of the use of Excel DataTables in order to “automate” sensitivity analysis, as well as discussing the GoalSeek (reverse sensitivity) tool. We also introduce scenario analysis, which is then treated more fully in Level II of the CertFM Program. At the end of the Chapter, we also mention others forms of sensitivity-related topics, such as scenarios, simulation, optimisation and sensitivities in non-dynamic models. The detailed coverage of these takes places at the appropriate place in later Levels of the CertFM Program.