Monte Carlo Simulation

A Powerful Statistical Method for Modeling Uncertainty

Author: Josh Pupkin
Josh Pupkin
Josh Pupkin
Private Equity | Investment Banking

Josh has extensive experience private equity, business development, and investment banking. Josh started his career working as an investment banking analyst for Barclays before transitioning to a private equity role Neuberger Berman. Currently, Josh is an Associate in the Strategic Finance Group of Accordion Partners, a management consulting firm which advises on, executes, and implements value creation initiatives and 100 day plans for Private Equity-backed companies and their financial sponsors.

Josh graduated Magna Cum Laude from the University of Maryland, College Park with a Bachelor of Science in Finance and is currently an MBA candidate at Duke University Fuqua School of Business with a concentration in Corporate Strategy.

Reviewed By: Adin Lykken
Adin Lykken
Adin Lykken
Consulting | Private Equity

Currently, Adin is an associate at Berkshire Partners, an $16B middle-market private equity fund. Prior to joining Berkshire Partners, Adin worked for just over three years at The Boston Consulting Group as an associate and consultant and previously interned for the Federal Reserve Board and the U.S. Senate.

Adin graduated from Yale University, Magna Cum Claude, with a Bachelor of Arts Degree in Economics.

Last Updated:March 18, 2024

What is Monte Carlo Simulation?

A Monte Carlo Simulation is a statistical technique used to predict different outcomes in situations where there's a degree of uncertainty.

Imagine you're dealing with a problem, and there are some factors that you can't predict with absolute certainty. Instead of giving a single fixed answer, this method provides a range of possible answers, which can be more practical and informative.

The name "Monte Carlo" comes from the city of Monaco known for its casinos and games of chance, highlighting the idea of dealing with uncertainty. This simulation technique was developed during World War II by a mathematician named Ulam Stanislaw to solve a specific problem related to the behavior of neutrons in the Manhattan Project, which led to the development of the atomic bomb.

Since then, Monte Carlo Simulation has become a valuable tool widely used in various fields like finance, engineering, mathematics, and the sciences. In finance, it has several applications. For instance, it's used to determine the prices of financial instruments like options and convertible bonds, which can be affected by unpredictable factors. It's also used in portfolio management to estimate the value of an investment portfolio and predict how it might perform in the future.

Another important use is in sensitivity analysis, which helps investors understand how changes in one variable can impact their financial models. This method essentially saves time and effort by creating models that randomly sample values from a distribution, making it particularly handy when dealing with multiple uncertain variables. So, Monte Carlo Simulation is a versatile and valuable tool for tackling problems involving uncertainty and is widely used across various fields, including finance.

Understanding the Monte Carlo Simulation

A Monte Carlo simulation is a mathematical tool that helps us understand uncertain situations. Imagine you have a bunch of variables that are kind of unpredictable. This simulation helps us make sense of them.

Today, statisticians and researchers use the Monte Carlo simulation when dealing with uncertainty. Here's how it works:

  1. You have some numbers that represent the uncertainty, like a range of possible values and an average value.
  2. The simulation then plays out the situation many times, randomly picking values within those ranges each time.
  3. After running the simulation thousands of times, it gives you a bunch of possible outcomes, like a list of different results and how likely each one is.

This is helpful when there are lots of uncertain factors involved because manually plotting all those possibilities would be very hard and time-consuming.

People use the Monte Carlo simulation in various fields like finance, marketing, software development, engineering, and physics. For instance, in finance, it's used to price options, make predictions about investment portfolios, and see how sensitive investments are to different conditions.

How Monte Carlo Simulation Method Work?

The Monte Carlo simulation produces a probability distribution of outcomes based on multiple random values of one or more inputs. This process involves the following steps:

  1. Find the uncertain variable or variables that may include a range of possible values.
  2. Determine the range of values and the probability of their occurrence.
  3. Use the MC simulation to select values from this range randomly. Then create a graph of outcomes from testing these randomly selected values for the same variable.

The values the Monte Carlo method randomly draws from may be an equally weighted range. In other cases, some values may be more probable than others. 

In this instance, one must supply the simulation with an equation that dictates the probability of certain values over others. Many examples include a normal distribution

This is defined by a mean (𝜇) and standard deviation (𝝈), which measures the degree of variation within a distribution.

In excel, this is graphed by the function =norm.inv(x, 𝜇, 𝝈) where

  • X = Probability
  • 𝜇 = Mean
  • 𝝈 = Standard deviation

In an MC simulation, often, the probability is defined by the rand() function in excel. This function chooses a random number at which to evaluate the probability. 

The standard deviation is the square root of the average variance of a distribution. The mean, of course, is the average of the values in the distribution. 

This equation will generate a random number selected from a normal distribution. The function can be run many times to generate various values for a single uncertain variable.

In finance, an asset's price path is often calculated using a lognormal distribution. This includes a right skew. This lognormal distribution is calculated using the probability density function. The Excel formula for this is very similar to the normal distribution. 

It looks like this: =lognorm.inv(x, 𝜇, 𝝈), where

  • X = Probability
  • 𝜇 = Mean
  • 𝝈 = Standard deviation

Again, usually, the probability is selected at random, which is generated by the rand() function. This function, once again, will generate a random number within the distribution range. This only generates a single output but can be run many times to generate multiple potential values for the uncertain variable.

Excel is not the only place one can use to create a Monte Carlo simulation. Often this simulation is created through other computer programming languages such as Python. 

These platforms may be more suited for generating models such as the MC simulation. For those without coding experience, excel functions may be easier to use.

Monte Carlo Simulation for valuing options

This simulation is a very commonly utilized tool for option pricing. 

Options are a type of derivative. When someone purchases an option, they are purchasing a contract that they can choose whether or not to execute, hence the name "option." 

This contract is a deal to buy 100 shares of a given security at a certain price and includes a small fee on each share. 

There are various ways that investors attempt to value options to make a profit, and some of these methods benefit from using the MC simulation. 

Specifically, Asian options are particularly suited for using this simulation. The price of an Asian option is based on the average price of the underlying asset over a specific period of time. 

This is unlike American and English options, which are priced based on the underlying asset at the time of execution.

Investors use the MC simulation to model multiple potential asset price paths. They can then calculate the would-be payoff from these price paths and discount them back to their present value. These values are then averaged to find an expected value of the option.

This method is most commonly applied to Asian options. There are, however, methods of using the Monte Carlo simulation that should yield a value for an English option.

This value should be the same as using the Black-Scholes model. 

Using constant drift in a geometric Brownian motion, the model follows this equation:

dAt = μAtdt + 𝝈AtdWt

Where:

  • A = Underlying asset price
  • t = time to maturity
  • μ = Constant drift
  • 𝝈 = Volatility
  • W = random variable

The W is where the Monte Carlo simulation can play a big role. It supplies the equation with various random samples. The random sampling of a normal distribution usually chooses these.

Although more difficult to price, American options have a pricing method that involves the MC simulation. 

The trouble with American options is that they allow for exercising the option before its maturity. A potential solution is the least squares method. 

This method is accomplished by generating future asset prices and performing a backward induction to find the asset price at every point along the asset's price path. 

At each price along the asset's price path, determine the value of exercising the option vs. the risk and potential payoff of exercising in the future. 

Lastly, discount the cash flows to their present value and average them across each price path.

The Monte Carlo simulation is also helpful for pricing convertible bonds

These are bonds that can be converted into equity before their maturity. This bond behavior may sound similar to how an American option can be exercised before maturity. 

They behave somewhat similarly, and investors can also apply the least squares method to pricing convertible bonds. 

The MC method can also be valuable when pricing options based on baskets of multiple securities. This is because this simulation can account for many variables and generate different values for all of them. 

Monte Carlo Simulation for Portfolio Management

This may also be used in portfolio management and applied in a few different ways.

This simulation can help plot risk and reward. This method can create a graph of many portfolios based on various risk allocations. These portfolios show the potential earnings of various portfolios of different models. 

High-risk portfolios have a higher standard deviation than low-risk portfolios. This means they may earn higher profits but less consistent earnings than a low-risk portfolio. 

Plotting the various values of the risk and reward and their probability can help craft a portfolio and measure expected returns.

One may also use the MC simulation to create a probability distribution of returns on a specific portfolio. 

There are many ways an investor can generate price paths for portfolios. Some equations, for example, may be the capital asset pricing model (CAPM), the Sharpe ratio, the Treynor ratio, or the Information ratio.

These can graph a series of price paths for any given portfolio. These equations are all meant to find the expected return of a portfolio, and the MC simulation can give uncertain variables multiple values.

In portfolio valuation, Monte Carlo methods are applied to scenarios with more than two possible values for each variable. For example, in 2022, the Federal Reserve will likely raise interest rates. 

This would affect portfolios heavily, although people are still determining how much interest rates will rise. The previous year, inflation had been very high, and investors are still determining what to expect in 2022. 

These are both variables that the MC simulation could be useful for because of their uncertainty. It can calculate various expected values that may be useful to look at. 

MC methods are usually computationally intensive. Using them for all combinations may be too expensive to calculate the whole probability distribution. 

For cases like this, one could generate many random samples with replacements from all possible combinations and then estimate the return or variance as an average over these samples.

Monte Carlo Simulation for financial modeling

The Monte Carlo simulation can be especially useful for sensitivity analysis.

Sensitivity analysis tests certain variables within a model to see how they affect the overall outcome. 

This is common practice in financial modeling. It helps investors get a better feel for their model and the likelihood of profitability, even if certain assumptions are slightly incorrect.

The MC simulation is well suited for this practice, as it can create a probability distribution of outcomes for uncertain variables. 

Investors supply a range of relevant values, and the simulation will take care of the rest. 

This method can also work with multiple uncertainties, making it a great asset. Modeling outcomes from multiple values for the same variable can be a tedious process, even for a single uncertain variable; when working with many, this method is a useful tool that can save time and energy. 

Check out this video from our Financial Statement Modeling Course for more information about sensitivity analysis!

Pros and Cons of Monte Carlo Simulation

Monte Carlo simulation is a complex statistical method. It helps in modeling the probability of different outcomes in a problem. 

MC simulations have been applied to a wide variety of areas. This includes financial modeling and forecasting to software development and engineering. There are many advantages to using this technique in various applications. 

Some of them are:

  • A computer can perform a large number of trials to find out the probabilities for all possible outcomes
  • Simulation models can be created with simple formulas that require little computer programming skills
  • The technique is easy to understand and learn
  • It provides good estimates when dealing with high dimension
  • Computer models allow for easy experimentation and time savings
  • Results obtained using MC simulation may be more accurate when compared with traditional methods

The Monte Carlo simulation is a very useful tool for many subjects and is often used within finance. Despite this, there are also many disadvantages to using this method.

One of the biggest is that it is computationally intensive, which makes it time-consuming to complete, especially when a situation with many variables is considered. 

But this disadvantage can be solved by parallel computing, which can also speed up calculations.  

Financial planners find the MC simulation particularly frustrating. They claim it could be better at measuring patterns. 

Estimating portfolio returns over many years often need help, even if the portfolio can include the average returns on a portfolio every year—the order of those returns matters for compounding returns. 

The randomness of the simulation is of little use in a market full of patterns that humans can more easily discern.

Lastly, the MC simulation is wrought with human error. This method saves time and removes the tedious process of creating the same model repeatedly for slightly different variables. 

Even so, the value of those variables still depends on the range estimated by the one running the simulation. The statistician must provide the distribution of values the simulation draws from, which can sometimes lead to erroneous results.

Researched and authored by Shaun Desai

Free Resources

To continue learning and advancing your career, check out these additional helpful WSO resources: