Chapter 27. Performing What-If Analysis
Create Various Scenarios
Using the Scenario Manager, you can explore different possible outcomes for a given set of data. Creating different possible outcomes is often referred to as creating a what-if model. That is, by modifying certain data, you answer the question, "What would happen if I made this change?"
When you work with scenarios, you use a worksheet that contains some values that do not change and others than do change. You identify the cells that contain changing values and supply a scenario name. Then you supply variables for the changing cells.
Suppose, for example, that you want to evaluate a potential mortgage payment, given several different down payments and interest rates. You can create ...