DEFINITION of '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ย xย 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.

Beta Risk
The probability that a false null hypothesis will be accepted ... 
Liability Matching
An increasingly popular investment strategy that attempts to ... 
Bell Curve
The most common type of distribution for a variable. The term ... 
Multivariate Model
A popular statistical tool that uses multiple variables to forecast ... 
Type I Error
A type of error that occurs when a null hypothesis is rejected ... 
Type II Error
A statistical term used within the context of hypothesis testing ...

Retirement
Top 5 Dreyfus Funds for Retirement Diversification in 2016 (BK)
Learn which five Dreyfus funds provide the best portfolio diversity combined with stability of investment returns for any retirement plan. 
Options & Futures
An Introduction To Value at Risk (VAR)
Volatility is not the only way to measure risk. Learn about the "new science of risk management". 
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. 
Markets
The Uses And Limits Of Volatility
Check out how the assumptions of theoretical risk models compare to actual market performance. 
Personal Finance
How To Effectively Use Financial Planning Software
The right financial planning software provides clients with reports that help them achieve their financial goals. 
Active Trading Fundamentals
Bet Smarter With The Monte Carlo Simulation
This technique can reduce uncertainty in estimating future outcomes. 
Options & Futures
Multivariate Models: The Monte Carlo Analysis
This decisionmaking tool integrates the idea that every decision has an impact on overall risk. 
Fundamental Analysis
Scenario Analysis Provides Glimpse Of Portfolio Potential
This statistical method estimates how far a stock might fall in a worstcase scenario. 
Fundamental Analysis
Monte Carlo Simulation With GBM
Learn to predict future events through a series of random trials. 
Term
How Market Segments Work
A market segment is a group of people who share similar qualities.

What is the difference between an optionadjusted spread and a Zspread in reference ...
Unlike the Zspread calculation, the optionadjusted spread takes into account how the embedded option in a bond can change ... Read Full Answer >> 
What percentage of a diversified portfolio should be exposed to the insurance sector?
It is beneficial to innovate financial models and techniques used in quantitative analysis to improve performance and adapt ... Read Full Answer >> 
What is finance?
"Finance" is a broad term that describes two related activities: the study of how money is managed and the actual process ... Read Full Answer >> 
What is the difference between positive and normative economics?
Positive economics is objective and fact based, while normative economics is subjective and value based. Positive economic ... Read Full Answer >> 
What is the utility function and how is it calculated?
In economics, utility function is an important concept that measures preferences over a set of goods and services. Utility ... Read Full Answer >> 
How can I use a regression to see the correlation between prices and interest rates?
In statistics, regression analysis is a widely used technique to uncover relationships among variables and determine whether ... Read Full Answer >>