Expert Business Case XL Simulation Screen Shots
Click to return to Expert Business Case XL page
Likely Distribution of Values
This chart shows how often various values of a specific business case metric (in this case Net Present Value or NPV) occurred. For example, in the chart below, the most likely value occurs between $1.043 and $1.291 million dollars which occurred around 15% of the time the simulation was run.
Cumulative Distribution of Values
What If Analysis
The What If analysis allows you to determine the probability/odds that the the NPV or other business case metric will fall within a certain range. It lets you answer questions like, there is a 10% chance that the NPV will be less than 0, and when that occurs the average loss will be $240,000.
Sensitivity
This chart shows which of the assumptions in the simulation had the greatest impact on the NPV (or other business case metric). In the chart below, the Product Cost of Goods had the greatest impact on the business case results, so you should focus on that assumption to ensure your assumption is accurate.
Click to return to Expert Business Case XL page
