Microsoft Office Tutorials and References
In Depth Information
Click OK to open the Scenario Values dialog box. Enter the input values for the scenario. In the case of
Recession and High Inflation, the values will be R and H for cells C8 and C9, respectively (see Figure C-23).
Note that if you already have entered values in the spreadsheet, the dialog box will display the current
values. Make sure to enter the correct values.
Entering values for the input cells
Click OK to return to the Scenario Manager dialog box. Enter the other three scenarios: Recession-Low
Inflation, Boom-High Inflation, and Boom-Low Inflation, and their related input values. When you finish, you
should see the names and changing cells for the four scenarios (see Figure C-24).
Scenario Manager dialog box with all four scenarios entered
You can now create a summary sheet that displays the results of running the four scenarios. Click the
Summary button to open the Scenario Summary dialog box, as shown in Figure C-25. You must now enter
the output cell addresses in Excel
they will be the same for all four scenarios. Recall that you created a
section in your spreadsheet called Summary of Key Results. You are primarily interested in the results at the
end of 2013, so you will choose the four cells that represent the Net Income after Taxes and End-of-year
Cash on Hand, and then use them for both the expansion scenario and the non-expansion scenario. These
cells are D12 to D15 in your spreadsheet. Either type in D12:D15 or use the button next to the Changing
cells field and select those cells in the spreadsheet.