Tutorial:
M O N T E   C A R L O   S I M U L A T I O N


   
Every financial analysis requiring to project future outcomes contains some level of uncertainty. Unless you have a good crystal ball, these projections will seldom turn out to be exactly as forecasted. Monte Carlo simulation is a technique that helps you to model uncertainties behind these projections. The simulation is a sophisticated scenario analysis that can model thousands of scenarios in seconds. Instead of relying on one set of projections, you can simulate a range of possible outcomes to gain better understanding about the likelihood of success.

In the case of the ROI analysis with Monte Carlo simulation, for example, rather than providing a single return on investment figure, like the standard net present value (NPV) analysis shown on the left below, the Monte Carlo simulation returns a range of possible outcomes (shown on the right), together with the probability of their occurrences.

In this example, Monte Carlo simulation allows you to determine not just whether an investment will be profitable, but how likely it is to be profitable and how profitable it is likely to be. The chart below reveals that there is a 70% chance that this particular investment will make money. But there is also a 30% chance that it will be a loss.

 


What standard NPV doesn't tell you


Unlike typical scenario or what-if analyses that allow you to analyze the impact of changing one input variable at a time, Monte Carlo simulation analyzes all possible combinations at once. In a typical scenario analysis, you manually calculate as many scenarios as you deem necessary. Monte Carlo simulation, on the other hand, calculates these scenarios automatically, based on your definition of simulation parameters. It allows you to run thousands of scenarios instead of the few in a typical what-if analysis.

Monte Carlo simulation was popularized by physicists in the 1950s at the dawn of the computer age and it got its name from the Monte Carlo Casino in Monaco. Games of chance played at a casino exhibit random behavior that is bound by the characteristics of the game. When rolling a die for example, you know that a number between 1 and 6 will come up, but you don't know which one.

Similarly, in a capital investment project you may know the range of possible financial outcomes, but you don't know exactly which one will materialize. Monte Carlo simulation allows you to model all potential scenarios driven by the uncertain variables. These scenarios are defined by the probability distributions and their simulation parameters.

Probability distributions

There are few probability distributions that are used frequently in the business world. Many times a normal distribution (also known as the bell curve) is a good representation of the business situation. The normal distribution is symmetrical around the mean with open tails on both ends (see left chart below). Each distribution is described through its distribution parameters and in the case of normal distribution these parameters are the mean and the standard deviation. The mean represents the center of distribution and the standard deviation is a measure of spread or variability. The smaller the standard deviation, the less variable the underlying metric is expected to be. In other words, the smaller the standard deviation, the higher the chance that the actual metric will be close to its mean.

Although normal distribution is very common in a business setting, there may be cases where other distributions may be more appropriate. For example, when modeling days payable outstanding (DPO) in a cash flow analysis, it may be more appropriate to set a fixed range of possible values of DPO and model same likelihood of occurrence across that range. In this case the uniform distribution should be used (see middle chart below). Its parameters are the minimum and the maximum, and the most likely value is usually between these two parameters. With a uniform distribution, all values of a metric have the same chance to be between the minimum and maximum values.

A distribution that is skewed to one side may be appropriate in other cases. Unit sales of new products in a ROI analysis, for example, most likely won't be negative. On the other hand, they may be much higher than the most likely estimates if the product is a hit. Hence, instead of a symmetrical distribution a skewed distribution could be used. The triangular distribution could be used and defined as skewed distribution. In this example, its minimum could be set at zero to avoid negative unit sales in the simulation. The parameters of a triangular distribution are minimum, mode, and maximum. The mode is the most common value. The triangular distribution can be symmetrical around the mode or can be skewed to the right or left of the mode. The chart below on the right shows a triangular distribution skewed to the right. The triangular distribution is closed on both ends with definitive minimum and maximum values.


Normal distribution    Uniform distribution    Triangular distribution



Simulation and results visualization

Monte Carlo simulation uses the selected distributions and their simulation parameters to automatically generate thousands of scenarios (or iterations), usually in just few seconds. At each iteration, the simulation selects a random value for each identified variable based on the defined parameters and calculates the corresponding outcome.

After all iterations, the results can be visualized, but the visualization will depend on the type of analysis. In the ROI analysis for example, the range (or probability distribution) of NPV is depicted. On the cash flow forecast, on the other hand, the simulation outcomes are translated into a range of possible cash flows over time.

If the simulation results are visualized through a probability distribution, the resulting probability distribution may resemble a normal distribution even if other distribution types were selected to model the input variables. This is due to the fact that many real life situations can be described with a normal distribution if the sample size is large enough. Since the Monte Carlo simulation analyzes thousands of scenarios, i.e., thousands of samples, the resulting probability distribution may resemble a normal distribution. This fact is described through a mathematical theorem, known as the central limit theorem.

Although Monte Carlo simulation can be run for all input variables, it is recommended to focus the simulation on the key drivers of the analyzed metric. This can simplify the analysis and helps to better understand the results. To identify the key drivers, a sensitivity chart can be used. This chart identifies the most relevant drivers that have the highest impact on the results. The sensitivity chart is also referred to as Tornado chart due to its shape used in some applications.

The Monte Carlo simulation used in FinanceIsland's tools assumes that the input variables are relatively independent of each other. If this is not the case or if some inputs are mutually exclusive, a Monte Carlo simulation customized for the specific analysis may be more appropriate to use.

Beware of Black Swans

One aspect to keep in mind when running any scenario analysis, including Monte Carlo simulation, is that the analysis is only accurate for scenarios not wildly different than the most likely estimates. There may be, however, extraordinary, though not absolutely unlikely events, where one or more variables are significantly different from the one modeled, which would dramatically impact the results.

In the case of the ROI analysis, for example, the number of units sold could be hundred times higher than forecasted if the new product exceeds any possible expectations. Or the product may not sell at all if the economy crashes and customers stop buying these types of products.

Events like these, referred to also as Black Swans, have a low likelihood of occurrence, but big impact. Since Black Swans are unexpected by definition, they are not modeled in financial analyses. These events would also not fit the cost structures and interdependencies defined in financial models.

Bottom line

Although Monte Carlo simulation will not eliminate uncertainties in business decisions, it can help you to understand them in normal business circumstances. It can be especially helpful in financial projections for projects that are not based on repeated past experiences. These projections are most often badly flawed.

If there is a chance of negative financial outcome in your business, Monte Carlo simulation will allow you to identify its main drivers. Similarly, if you're allocating resources among several projects, Monte Carlo simulation will help you to determine which ones have the greatest chance of success. With the modeling capabilities of Monte Carlo simulation you can make better financial decisions.



You can see Monte Carlo simulation in action when using FinanceIsland's financial analysis tools. You can try them out by subscribing for a free trial.

Sensitivity chart from the ROI analysis tool

Sensitivity chart on ROI analysis
  Net revenues from the cash flow forecast tool

Cash flow forecast results
  Contribution margin from the optimal supply estimator

Contribution margin from the optimal supply estimator