Chapter 25. 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.
For example, suppose you want to evaluate a potential mortgage payment after being given several different down payments and interest rates. You can ...