# Analytical report scenario

Scenario Manager creates scenarios for each set of the input values for the variables under consideration. Merging the scenarios from several different worksheets or workbooks. Monte Carlo Analysis Many analysts will create a multivariate model a model with multiple variablesplug in their best guess for the value of each variable and come up with one forecasted value. The mean of any probability distribution is the one that has the highest probability of occurrence.

By using a value for each variable that is expected to be the most probable, the analyst is in fact calculating the mean value of the potential distribution of potential values.

Although the mean has informational value, as previously stated, it does not show any potential variation in the outcomes. Risk analysis is concerned with trying to determine the probability that a future outcome will be something other than the mean value.

One way to show variation is to calculate an estimate of the extreme and the least probable outcomes on the positive and negative side of the mean. The simplest method to forecast potential outcomes of an investment or venture is to produce an upside and downside case for each outcome and then to speculate the probability that it will occur. The figure below uses a three scenario method evaluating a base case B mean valueupside case U and a downside case D.

For example a simple two factor analysis: By assigning two extreme upside and downside values for A and B, we would then get our three scenario values. By assigning the probability of occurrence, let us assume: By graphing these values and their probabilities we can infer a rather crude probability distribution - the distribution of all calculated values and the probability of those values occurring.

## Scenario Manager

By forming the upside and downside cases we begin to get an understanding of other possible return outcomes, but there are many other potential outcomes within the set bounded by the extreme upside and downside already estimated.

The figure below presents one method for determining the fixed number of outcomes between the two extremes. Assuming that each variable acts independently, that is, its value is not dependent on the value of any other variable, we can conduct an upside, base and downside case for each variable.

In the simplistic two factor model, this type of analysis would result in a total of nine outcomes. A three-factor model using three potential outcomes for each variable would end up with 27 outcomes, and so forth. In Figure 2, there are nine outcomes but not nine separate values. To finalize this study, the analyst would assign the probabilities for each outcome and then add those probabilities for any like values.

We would expect that the value corresponding to the mean, in this case being BB, would appear the most times since the mean is the value with the highest probability of occurring.

The frequency of like values increases the probability of occurrence. The more times values do not repeat, especially the mean value, the higher the probability that future returns will be something other than the mean.

The more factors one has in a model and the more factor scenarios one includes, the more potential scenario values are calculated resulting in a robust analysis and insight into the risk of a potential investment.

Drawbacks of Scenario Analysis The major drawback for these types of fixed outcome analyses are the probabilities estimated and the outcome sets bounded by the values for the extreme positive and negative events. Although they may be low probability events, most investments, or portfolios of investments, have the potential for very high positive and negative returns.

Investors must remember that although they don't happen often, these low probability events do happen and it is risk analysis that helps determine whether these potential events are within an investor's risk tolerance.

A method to circumvent the problems inherent in the previous examples is to run an extreme number of trials of a multivariate model.

Random factor analysis is completed by running thousands and even hundreds of thousands of independent trials with a computer to assign values to the factors in a random fashion.

The most common type of random factor analysis is called "Monte Carlo" analysis, where factor values are not estimated but are chosen randomly from a set bounded by the variable's own probability distribution.

Standards set for reporting investment performance ensure that investors are provided with the risk profile variability of performance for past performance of investments.

Because past performance does not have any bearing on future risk or return, it is up to the investor or business owners to determine the future risk of their investments by creating pro-forma models. The output of any forecast will only produce the expected or mean value of that initiative - the outcome that the analyst believes has the highest probability of occurrence.

By conducting scenario analysis an investor can produce a risk profile for a forecasted investment and create a basis for comparing prospective investments.Learn how to do scenario analysis in Excel and learn different scenario summary reports you can generate using the Excel Scenario Manager feature.

also learn three types of scenario analysis: worst case, best case & most likely. Learn how to do scenario analysis in Excel and learn different scenario summary reports you can generate using the.

Nov 02,  · INTRODUCTION. This article provides a walk-thru for Application Developers seeking to add an analytical report to a Dynamics application. For this scenario, we will extend the Reservation Management Workspace in the Fleet Management application to include a direct link to an analytical report authored against the Entity Store using Power BI Desktop.

Analytical Report Scenario Assignment Situation (Note – An Alternate Career and/or Education Topic is Noted Below) You work for a company (Select a real company that you will represent) that needs help.

Analytical Report Scenario Assignment Situation (Note – An Alternate Career and/or Education Topic is Noted Below) You work for a company (Select a real company that you will represent) that needs help.

In the Scenario Summary dialog box, for Report type, select Scenario PivotTable report Press the Tab key, to move to the Result cells box On the worksheet, click on cell skybox2008.com is the Profit cell, and it changes, based on the sales and expense amounts. Scenario Analysis Series are published quarterly by Dcode EFC, to assist Clients in anticipating the different paths the Egyptian economy may take as a result of foreseen shocks.

Scenario / What-If Analysis