O'Reilly logo

Business Analysis with Microsoft® Excel, Second Edition by Conrad Carlberg

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required