In this video, learn how to use percentages of a base value to define your scenarios.
- [Instructor] In the previous movie,…I showed you how to create and display scenarios…that included specific values for each scenario.…In this movie, I'll show you how to use percentages…of a base value to define your scenarios.…The formulas are a little more complicated…but some audiences prefer percentages…over specific values so it's useful to know how to do it.…My sample file is Scenarios 0202,…and you can find it in the chapter two folder…of the exercise files collection.…
This workbook displays a profit or operating income analysis…for a series of four products,…Basic, Advanced, Professional, and Enterprise.…The idea is that I calculate operating income…by subtracting cost of goods sold…or COGS from revenue.…I have my revenue scenarios in the range from B10 to F16.…You'll see that I have a base of $275,000…for the basic product and the others are as shown.…
The scenarios are based on calculating…the percent difference from that base value.…So 80%, 90% of that value, 100,…which is scenario three or the average.…
LinkedIn Learning (Lynda.com) is a PMI Registered Education Provider. This course qualifies for professional development units (PDUs). To view the activity and PDU details for this course, click here.
The PMI Registered Education Provider logo is a registered mark of the Project Management Institute, Inc.
- Designing a scenario-planning exercise
- Estimating scenario plausibility and outcomes
- Establishing parameter value ranges
- Calculating the standard deviation of a dataset
- Indicating the probability of a scenario value occurring
- Walking through a scenario presentation
- Performing retrospective analysis using a PivotTable
- Changing PivotTable summary operations