How to Use the Monte Carlo Simulation

Posted by Moira McCormick on November 22, 2016
Moira McCormick
Find me on:

Monte_Carlo.jpg

Monte Carlo Simulation (also known as the Monte Carlo Method) provides a comprehensive view of what may happen in the future using computerised mathematical techniques that allow people to account for risk in quantitative analysis and decision making.  It tells you not only what could happen, but how likely it is to happen.We are constantly faced with uncertainty, ambiguity, and variability in life so risk analysis is part of every decision we make. 

However, even though we now have unprecedented access to information, we still can’t accurately predict the future. Monte Carlo simulation lets you see all the possible outcomes of your decisions and assess the impact of risk, allowing for better decision making.  It shows the extreme possibilities, i.e. the outcomes of going for broke or for the most conservative decision, as well as the consequences of making a "middle ground" decision.

It goes without saying that all of those in business and finance would like to accurately estimate the probabilities of uncertain events. For example, what is the probability that a new product’s cash flows will have a positive net present value (NPV)? 

Another example would be an investor wanting to know the risk factor of their investment portfolio? Monte Carlo simulation enables both of these exemplars to model situations that present uncertainty and then play them out on a computer thousands of times.

Monte Carlo simulations are used to estimate the probability of cost overruns in large projects and the likelihood that an asset price will move in a certain way. Telecoms use them to assess network performance in different scenarios, helping them to optimize the network.

Analysts use them to asses the risk that an entity will default and to analyze derivatives such as options. Insurers and oil well drillers also use them. Monte Carlo simulations have many applications outside business and finance, such as in meteorology, astronomy and particle physics.

 

New Call-to-action

 

Why is it called Monte Carlo simulation?

The name Monte Carlo simulation comes from the computer simulations performed during the 1930s and 1940s to estimate the probability that the chain reaction needed for an atom bomb to detonate would work successfully. The physicists involved in this work were big fans of gambling, so they gave the simulations the code name Monte Carlo.

 

How do I use it?

To use Monte Carlo simulation, you must be able to build a quantitative model of your business activity, plan or process. One of the easiest and most popular ways to do this is to create a spreadsheet model using Microsoft Excel.  Other ways include writing code in a programming language such as Visual Basic, C++, C# or Java or using a special-purpose simulation modeling language.

To deal with uncertainties in your model, you'll replace certain fixed numbers, e.g. in spreadsheet cells, with functions that draw random samples from probability distributions.  To analyze the results of a simulation run, you'll use statistics such as the mean, standard deviation, and percentiles, as well as charts and graphs. If all this sounds too complicated there are great software tools out there to assist in these tasks.

 

Who uses Monte Carlo Simulation?

Many companies (see below) use Monte Carlo simulation as an important part of their decision-making process.

  • General Motors, Proctor and Gamble, Pfizer, Bristol-Myers Squibb, and Eli Lilly use simulation to estimate both the average return and the risk factor of new products. At GM, this information is used by the CEO to determine which products come to market.
  • GM uses simulation for activities such as forecasting net income for the corporation, predicting structural and purchasing costs, and determining its susceptibility to different kinds of risk (such as interest rate changes and exchange rate fluctuations).
  • Lilly uses simulation to determine the optimal plant capacity for each drug.
  • Proctor and Gamble uses simulation to model and optimally hedge foreign exchange risk.
  • Sears uses simulation to determine how many units of each product line should be ordered from suppliers.
  • Oil and drug companies use simulation to value "real options," such as the value of an option to expand, contract, or postpone a project.
  • Financial planners use Monte Carlo simulation to determine optimal investment strategies for their clients’ retirement.

 

How Monte Carlo simulation works

Monte Carlo simulation performs risk analysis by building models of possible results by substituting a range of values - a probability distribution - for any factor that has uncertainty. It then calculates results repeatedly, each time using a different set of random values from the probability functions.

Depending upon the number of uncertainties and the ranges specified for them, a Monte Carlo simulation could involve thousands or tens of thousands of recalculations before it is complete. Monte Carlo simulation produces distributions of possible outcome values.

By using probability distributions, variables can have different probabilities of different outcomes occurring.  Probability distributions are a much more realistic way of describing uncertainty in variables of a risk analysis.  Common probability distributions include:

 

Normal  or “bell curve: The user simply defines the mean or expected value and a standard deviation to describe the variation about the mean.  Values in the middle near the mean are most likely to occur.  It is symmetric and describes many natural phenomena such as people’s heights.  Examples of variables described by normal distributions include inflation rates and energy prices.

 

Lognormal: Values are positively skewed, not symmetric like a normal distribution.  It is used to represent values that don’t go below zero but have unlimited positive potential.  Examples of variables described by lognormal distributions include property prices, stock prices, and oil reserves.

 

Uniform: All values have an equal chance of occurring, and the user simply defines the minimum and maximum.  Examples of variables that could be uniformly distributed include manufacturing costs or future sales revenues for a new product.

 

Triangular: The user defines the minimum, most likely, and maximum values.  Values around the "most likely" are more likely to occur.  Variables that could be described by a triangular distribution include past sales history per unit of time and inventory levels.

 

PERT: The user defines the minimum, most likely, and maximum values, just like the triangular distribution.  Values around the most likely are more likely to occur.  However values between the most likely and extremes are more likely to occur than the triangular; that is, the extremes are not as emphasized.  An example of the use of a PERT distribution is to describe the duration of a task in a project management model.

 

Discrete: The user defines specific values that may occur and the likelihood of each.  An example might be the results of a lawsuit – it could have a 20% chance of a positive verdict, 30% chance of negative verdict, 40% chance of settlement, and 10% chance of a mistrial.

 

During a Monte Carlo simulation, values are sampled at random from the input probability distributions.  Each set of samples is called an iteration, and the resulting outcome from that sample is recorded.  Monte Carlo simulation does this hundreds or thousands of times, and the result is a probability distribution of possible outcomes. 

 

Advantages of using Monte Carlo simulation over “single-point estimate” analysis:

  • Probabilistic Results - Results show not only what could happen, but how likely each outcome is.
  • Graphical Results - Because of all the generated data it’s easy to create graphs of different outcomes and their chances of occurrence.  This is important for communicating findings to other stakeholders.
  • Sensitivity Analysis - In Monte Carlo simulation, it’s easy to see which inputs had the biggest effect on bottom-line results.
  • Scenario Analysis - Using Monte Carlo simulation, analysts can see exactly which inputs had which values together when certain outcomes occurred.  This is invaluable for pursuing further analysis.
  • Correlation of Inputs - In Monte Carlo simulation, it’s possible to model interdependent relationships between input variables. This is important for accuracy and to represent how, in reality, when some factors goes up, others go up or down accordingly.


Conclusion

Whenever you need to make an estimate, forecast or decision where there is significant uncertainty, you'd be well advised to consider Monte Carlo simulation - if you don't, your forecasts could be way off the mark, with adverse consequences for your decisions.

Many business situations involve uncertainty, e.g. variable market demand, unknown plans of competitors, uncertainty in costs, and many others.  If your situation sounds like this, you may find that the Monte Carlo method is surprisingly effective for you.

 

SOURCES

http://www.palisade.com/risk/monte_carlo_simulation.asp

https://en.wikipedia.org/wiki/Monte_Carlo_method

http://www.investopedia.com/terms/m/montecarlosimulation.asp

https://support.office.com/en-us/article/Introduction-to-Monte-Carlo-simulation-64C0BA99-752A-4FA8-BBD3-4450D8DB16F1

http://www.solver.com/monte-carlo-simulation-overview

Topics: Monte Carlo Simulation

Recent posts

Posts by tag

See all