Managing Scenarios
Chapters 11 and 12 explained how to construct a base business case. During the initial case development, the tendency is to be neither optimistic nor pessimistic about the initial inputs: these estimates are starting points, and they are usually just best guesses. After constructing the basic business case, it's useful to continue with a sensitivity analysis—an examination of each input variable, and the assignment of base case, worst case, and best case values to each.
Scenario management is the process of examining individual variables, and assigning ranges of values to them. Each combination of values results in a different view, or scenario. You can then focus on each scenario, and assess the sensitivity of the most likely ...
Get Business Analysis with Microsoft® Excel, Second Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.