In finance, there is a fair amount of uncertainty and risk involved with estimating the future value of figures or amounts due to the wide variety of potential outcomes. Monte Carlo simulation (MCS) is one technique that helps to reduce the uncertainty involved in estimating future outcomes. MCS can be applied to complex, non-linear models or used to evaluate the accuracy and performance of other models. It can also be implemented in risk management, portfolio management, pricing derivatives, strategic planning, project planning, cost modeling and other fields. (To learn more, read Monte Carlo Simulation With GBM.)
MCS is a technique that converts uncertainties in input variables of a model into probability distributions. By combining the distributions and randomly selecting values from them, it recalculates the simulated model many times and brings out the probability of the output.
- MCS allows several inputs to be used at the same time to create the probability distribution of one or more outputs.
- Different types of probability distributions can be assigned to the inputs of the model. When the distribution is unknown, the one that represents the best fit could be chosen.
- The use of random numbers characterizes MCS as a stochastic method. The random numbers have to be independent; no correlation should exist between them.
- MCS generates the output as a range instead of a fixed value and shows how likely the output value is to occur in the range.
Some Frequently Used Probability Distributions in MCS
Normal/Gaussian Distribution - Continuous distribution applied in situations where the mean and the standard deviation are given and the mean represents the most probable value of the variable. It is symmetrical around the mean and is not bounded. (For related reading, see The Uses And Limits Of Volatility.)
Lognormal Distribution - Continuous distribution specified by mean and standard deviation. This is appropriate for a variable ranging from zero to infinity, with positive skewness and with normally distributed natural logarithm.
Triangular Distribution - Continuous distribution with fixed minimum and maximum values. It is bounded by the minimum and maximum values and can be either symmetrical (the most probable value = mean = median) or asymmetrical.
Uniform Distribution - Continuous distribution bounded by known minimum and maximum values. In contrast to the triangular distribution, the likelihood of occurrence of the values between the minimum and maximum is the same.
Exponential Distribution - Continuous distribution used to illustrate the time between independent occurrences, provided the rate of occurrences is known. (For more insight, see Find The Right Fit With Probability Distributions.)
The Math Behind MCS
Consider that we have a real-valued function g(X) with probability frequency function P(x) (if X is discrete), or probability density function f(x) (if X is continuous). Then we can define the expected value of g(X) in discrete and continuous terms respectively:
Next, make n random drawings of X (x1, …..,xn) , called trial runs or simulation runs, calculate g(x1),….g(xn) and find the mean of g(x) of the sample:
How will the uncertainty in unit price, unit sales and variable costs affect the EBITD?
|Copyright Unit Sales)-(Variable Costs + Fixed Costs)
Let us explain the uncertainty in the inputs - unit price, unit sales and variable costs - using triangular distribution, specified by the respective minimum and maximum values of the inputs from the table.
A sensitivity chart can be very useful when it comes to analyzing the effect of the inputs on the output. What it says is that unit sales account for 62% of the variance in the simulated EBITD, variable costs for 28.6% and unit price for 9.4%. The correlation between unit sales and EBITD and between unit price and EBITD is positive or an increase in unit sales or unit price will lead to an increase in EBITD. Variable costs and EBITD, on the other hand, are negatively correlated and by decreasing variable costs we will increase EBITD.
Beware that defining the uncertainty of an input value by a probability distribution that does not correspond to the real one and sampling from it will give incorrect results.
In addition, the assumption that the input variables are independent might not be valid. Misleading results might come from inputs that are mutually exclusive or if significant correlation is found between two or more input distributions.
Also note that the number of trials should not be too small, as it might not be sufficient to simulate the model, causing clustering of values to occur.
The Bottom Line
Fundamental AnalysisExamining the gross domestic product growth and composition of Mexico, the second largest economy in Latin America
Mutual Funds & ETFsExplore detailed analysis and information of the iShares Floating Rate Bond ETF, and learn how to use this ETF as a defense against rising interest rates.
Mutual Funds & ETFsDiscover five of the most popular and best-performing mutual funds offering investors direct exposure to equities of Japanese companies.
Fundamental AnalysisInflation is the main catalyst behind U.S monetary policy. But what causes this phenomenon of sustained rising prices? Read on to find out.
Mutual Funds & ETFsFind out about the PowerShares DB Commodity Tracking ETF, and explore a detailed analysis of the fund that tracks 14 distinct commodities using futures contracts.
Mutual Funds & ETFsFind out about the PowerShares FTSE RAFI U.S. 1000 ETF, and explore detailed analysis of the fund that invests in undervalued stocks.
Mutual Funds & ETFsDiscover the top five mutual funds most heavily weighted with Berkshire Hathaway stock, and the percentage of their assets dedicated to BRK.
Mutual Funds & ETFsDiscover the top three mutual funds that dedicate the largest percentage of their total assets to Google, Inc. stock.
Options & FuturesUsing iron ore options is a way to take advantage of a current downslide in iron ore prices, whether for producers or traders.
Mutual Funds & ETFsExplore a comparison of mutual funds and exchange-traded funds, or ETFs, and learn what makes ETFs a significantly more tax-efficient investment.
A type of accounting process that aims to capture a company's ...
A situation in which one person’s gain is equivalent to another’s ...
A fundamental economic concept that describes the total amount ...
The principal-agent problem develops when a principal creates ...
A security that tracks an index, a commodity or a basket of assets ...
A bond that is issued for less than its par (or face) value, ...
Systematic sampling is useful in finance for situations where it is impractical to review the entire population for certain ... Read Full Answer >>
The Federal Deposit Insurance Corporation, or FDIC, is a government-run agency that provides protection against losses if ... Read Full Answer >>
If an investment fund has a high turnover ratio, it indicates it replaces most or all of its holdings over a one-year period. ... Read Full Answer >>
In economics, utility function is an important concept that measures preferences over a set of goods and services. Utility ... Read Full Answer >>
The rise of index trading may increase the overall vulnerability of the stock market due to increased correlations between ... Read Full Answer >>
Asset management utilizes two main investment strategies that can be used to generate returns: active asset management and ... Read Full Answer >>