Chapter 9 In Class Excel Problems- Students

Chapter 9 In Class Excel Problems- Students - HOW TO USE...

Info icon This preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
HOW TO USE EXCEL'S SCENARIO TOOL 8. Leave "Prevent changes" checked, but don't click "Hide". Then click OK. 10. Now go back to the box where you can click "Add" to add another scenario. Click Add. 11. For the scenario name, enter "Ind. Avg. Data". 12. The cells that should be changed are already there, so just click OK. sure you can do it. If you have a problem, retrieve our file to see again what we did. 1. Look at the section beginning on Row 157 of the Main Model. This is where we create the scenarios. Th Column C are the inputs used in the forecasting model. These data are substituted into the appropriate ce calculations shown below, where we forecast results under each scenario. The data in Columns D, E, and F inputs under each scenario. You can let as many inputs vary as you think appropriate. 2. You can start the scenario analysis from any point on the spreadsheet. Since we want to be able to see t range A158:F161 as we create the scenarios, we begin by putting cell A158 of the Main Model worksheet in corner of the screen. 3. We began by typing in the headings in Rows 157 and 158, and in Column A, after which we inserted the wanted to use for the different scenarios. Note that you can enter data here either as formulas or as fixed n we did for the other scenarios. 4. You could put the data for any scenario into Column C at the start. Since the data amounts to a "base forecast, we used that data initially. Note that Excel's Scenario Manager will automatically change the Co as we execute different scenarios. 5. Now put the pointer on about cell G157, and then click Data>What if Analysis>Scenarios to get the Scen Manager dialog box. Note that you can drag the box around as you fill in items. 6. When we started, there were no scenarios. In your case, our scenarios exist, so you should begin by del Once they are gone, click "Add" to put in the first scenario. 7. In the "Add Scenario" box we entered the name "2015 Data" to designate the first scenario, which am base case. This is important, because it permits you to easily go back to the base case input data. 8. Then tab down to "Changing cells." Delete any cells shown in the box. Then depress the Ctrl key and the first cell that will be changed, A158. Leave the Ctrl key depressed and click on the next changing cell, highlight F161. Leave the Ctrl key depressed and click on the next changing cell, D161. Continue throug 9. Excel moves you to the "Scenario Values" menu. Assuming that you started with the original set of inp OK to set their values as the values for the Base Case scenario. If you started with different values, type in appropriate values at this point. Then click OK. Note that we use the name of the scenario as an input; th title to change and lets us know which scenario is active.
Image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern