Business Analysis with Microsoft® Excel, Second Edition

Summary

When sensitivity scenarios are included in a business case package, management obtains a better overall feel for the project under review. The analyst who constructs the business case also has the opportunity to answer pertinent “what if” questions proactively. It provides multiple points of view on a project, and enables the review team to focus on the business drivers that have the most significant impact on potential outcomes.

In this chapter, you have learned how to use Excel's Scenario Manager to establish and examine the effect of variances in the input assumptions of a business case, as well as how to establish upper and lower limits on the sensitivity of the business case's outputs. You have extended your understanding of profitability ...