Monte Carlo Simulation

Loading the player...

What is the 'Monte Carlo Simulation'

Monte Carlo simulations are used to model the probability of different outcomes in a process that cannot easily be predicted due to the intervention of random variables.

BREAKING DOWN 'Monte Carlo Simulation'

Since business and finance are plagued by random variables, Monte Carlo simulations have a vast array of potential applications in these fields. They 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 countless applications outside of business and finance, such as in meteorology, astronomy and particle physics.

Monte Carlo simulations are named after the gambling hot spot in Monaco, since chance and random outcomes are central to the modeling technique, much as they are to games like roulette, dice and slot machines. The technique was first developed by Stanislaw Ulam, a mathematician who worked on the Manhattan Project. After the war, while recovering from brain surgery, Ulam entertained himself by playing countless games of solitaire. He became interested in plotting the outcome of each of these games in order to observe their distribution and determine the probability of winning. He mentioned this to John Von Neumann, and the two collaborated to develop the Monte Carlo simulation.

Asset Price Modeling

One way to employ a Monte Carlo simulation is to model possible movements of asset prices using Excel or a similar program. There are two components to an asset's price movements: drift, which is a constant directional movement, and a random input, representing market volatility. By analyzing historical price data, you can determine the drift, standard deviation, variance and average price movement for a security. These are the building blocks of a Monte Carlo simulation.

To project one possible price trajectory, use the historical price data of the asset to generate a series of periodic daily returns using the natural logarithm (note that this equation differs from the usual percentage change formula):

periodic daily return = ln (day's price ÷ previous day's price)

Next use the AVERAGE, STDEV.P and VAR.P functions on the entire resulting series to obtain the average daily return, standard deviation and variance inputs, respectively. The drift is equal to:

drift = average daily return - (variance ÷ 2)

Alternatively, drift can be set to 0; this choice reflects a certain theoretical orientation, but the difference will not be huge, at least for shorter time frames.

Next obtain a random input:

random value = standard deviation * NORMSINV(RAND())

The equation for the following day's price is:

next day's price = today's price * e ^ (drift + random value)

To take e to a given power in Excel, use the EXP function: EXP(x). Repeat this calculation the desired number of times (each repetition represents one day) to obtain a simulation of future price movement. By generating an arbitrary number of simulations, you can assess the probability that a security's price will follow given trajectory. Here is an example, showing around 30 projections for the Time Warner Inc's (TWX) stock for the remainder of November 2015:

The frequencies of different outcomes generated by this simulation will form a normal distribution, that is, a bell curve. The most likely return is at the middle of the curve, meaning there is an equal chance that the actual return will be higher or lower than that value. The probability that the actual return will be within one standard deviation of the most probable ("expected") rate is 68%; that it will be within two standard deviations is 95%; and that it will be within three standard deviations is 99.7%. Still, there is no guarantee that the most expected outcome will occur, or that actual movements will not exceed the wildest projections.

Crucially, Monte Carlo simulations ignore everything that is not built into the price movement (macro trends, company leadership, hype, cyclical factors); in other words, they assume perfectly efficient markets. For example, the fact that Time Warner lowered its guidance for the year on November 4 is not reflected here, except in the price movement for that day, the last value in the data; if that fact were accounted for, the bulk of simulations would probably not predict a modest rise in price.

  1. Stochastic Modeling

    A method of financial modeling in which one or more variables ...
  2. Random Factor Analysis

    A statistical analysis performed to determine the origin of random ...
  3. Random Variable

    A variable whose value is unknown or a function that assigns ...
  4. Exponential Growth

    A pattern of increasing prices that resembles the curve of an ...
  5. Stress Testing

    A simulation technique used on asset and liability portfolios ...
  6. Standard Deviation

    1. A measure of the dispersion of a set of data from its mean. ...
Related Articles
  1. Fundamental Analysis

    Explaining the Monte Carlo Simulation

    Monte Carlo simulation is an analysis done by running a number of different variables through a model in order to determine the different outcomes.
  2. Fundamental Analysis

    What Can The Monte Carlo Simulation Do For Your Portfolio?

    A Monte Carlo simulation allows analysts and advisors to convert investment chances into choices. The advantage of Monte Carlo is its ability to factor in a range of values for various inputs.
  3. Options & Futures

    Multivariate Models: The Monte Carlo Analysis

    This decision-making tool integrates the idea that every decision has an impact on overall risk.
  4. Professionals

    Discrete and Continuous Compounding

    CFA Level 1 - Common Probability Distributions - Discrete and Continuous Compounding
  5. Fundamental Analysis

    Monte Carlo Simulation With GBM

    Learn to predict future events through a series of random trials.
  6. Fundamental Analysis

    Create a Monte Carlo Simulation Using Excel

    How to apply the Monte Carlo Simulation principles to a game of dice using Microsoft Excel.
  7. Fundamental Analysis

    Guide To Excel For Finance: Advanced Calculations

    Monte Carlo SimulationIn its most basic form, the Monte Carlo simulation seeks to simulate real-world outcomes by showing a range of outcomes for a given variable set. For example, in the casino ...
  8. Active Trading Fundamentals

    How To Convert Value At Risk To Different Time Periods

    Volatility is not the only way to measure risk. Learn about the "new science of risk management".
  9. Professionals

    Straight-Line Returns Vs. Probability Analysis

    Straight-Line Returns Vs. Probability Analysis
  10. Professionals

    Scenario / What-If Analysis

    We look at some ways that you can evaluate your project.
  1. What percentage of a diversified portfolio should be exposed to the insurance sector?

    Learn how it is critical to innovate and improve financial models and techniques used in quantitative analysis, and understand ... Read Answer >>
  2. What is the minimum number of simulations that should be run in Monte Carlo Value ...

    Find out how many simulations should be run at minimum for an accurate value at risk when using the Monte Carlo method of ... Read Answer >>
  3. How can I use systematic sampling in finance?

    Learn about systematic sampling, how it works and how it can be used in finance, including Monte Carlo simulations that model ... Read Answer >>
  4. What technical skills must one possess to trade options?

    Learn about the technical skills required to trade options and how mathematical and computer science skills give you a better ... Read Answer >>
  5. What is stress testing in Value at Risk (VaR)?

    Discover the difference between Value at Risk, or VaR, and stress testing, and learn how the two concepts might be used together ... Read Answer >>
  6. What is the difference between standard deviation and average deviation?

    Understand the basics of standard deviation and average deviation, including how each is calculated and why standard deviation ... Read Answer >>
Hot Definitions
  1. Stop-Limit Order

    An order placed with a broker that combines the features of stop order with those of a limit order. A stop-limit order will ...
  2. Keynesian Economics

    An economic theory of total spending in the economy and its effects on output and inflation. Keynesian economics was developed ...
  3. Society for Worldwide Interbank Financial Telecommunications ...

    A member-owned cooperative that provides safe and secure financial transactions for its members. Established in 1973, the ...
  4. Generally Accepted Accounting Principles - GAAP

    The common set of accounting principles, standards and procedures that companies use to compile their financial statements. ...
  5. DuPont Analysis

    A method of performance measurement that was started by the DuPont Corporation in the 1920s. With this method, assets are ...
  6. Call Option

    An agreement that gives an investor the right (but not the obligation) to buy a stock, bond, commodity, or other instrument ...
Trading Center