Monte carlo simulation model, Financial Management

Monte Carlo Simulation Model

Monte Carlo simulation is used to analyse to what extent the valuation of the chosen company is dependent on the assumptions. Monte Carlo simulation is based on artificially creating a chance process, running it many times and observing the result (Barreto & Howland, 2005). A deterministic model is created on the excel sheet for the calculation of valuation of the share of the company. A set of inputs are identified that are assumed to arrive at the valuation of the company. These inputs are varied and result of the model is evaluated. This way the model is run many times. Results are analysed using statistical methods like histograms, probability distribution, and summary statistics. Monte Carlo simulation takes into account already defined variables with their all possible values and iterate these values thousands of time to analyse all the possible results expected with the change in inputs.

359_Monte Carlo Simulation.png

Figure: Monte Carlo Simulation model

So in Monte Carlo simulation instead of fixed inputs a probability distribution is applied to some or all of the inputs which generates a probability distribution of the Output.

Analysis of the result of the Monte Carlo simulation is done to analyse how the valuation of the companies changes with the change in inputs. But this simulation requires that inputs like beta, growth rates are defined by a distribution. Distribution could be normal, triangular, binomial, lognormal, studentt, exponential etc. Triangular distribution is typically used where data is predicted subjectively and it is not possible to collect sufficient data for the population sample. This is based on a minimum, maximum and a subjective guess what is the most likely value the data can take.

Posted Date: 2/21/2013 2:45:30 AM | Location : United States







Related Discussions:- Monte carlo simulation model, Assignment Help, Ask Question on Monte carlo simulation model, Get Answer, Expert's Help, Monte carlo simulation model Discussions

Write discussion on Monte carlo simulation model
Your posts are moderated
Related Questions
The Relationship between Futures Price and Cash Price Any commodity that can be bought in the market has a price, which is referred to as cash or spot price for immediate deliv

What happens when a bank charges discount interest on a loan? When a bank charges reduction in interest on a loan the required interest payment is subtracted from the loan proc

Types of Financial Assets Majority of financial assets used worldwide are in the form of deposits, stocks and debt. Deposits Deposits can be made either with banking or

Can you describe what the payoffs from lookback options depend on? Can you write in a concise notation the payoff of a floating lookback call? a. What is the payoff of a portfol

Describe in brief about  finance Managing this flow of funds resourcefully is the purview of finance. So we can describe finance as the study of the methods that help us plan,

Dividends are expected to grow at a constant rate of 5 percent per year in the future. Firms last dividend was $1 and stock price 10 dollars the firms beta 1,2 the rate of return o

what role do core deposits play in predicting the probability distribution of net deposit drains

The dividend is the part of the net income that the company distributes to shareholders. As the dividend represents real money, the net income is also real money. Is that true?

The modified duration is a measure of the sensitivity of a bond's price to interest rate changes; the assumption made here is that the expected cash flow does not

What is Cost of Capital Cost of Capital is the rate which should be earned in order to satisfy required rate of return of the firm's investors. It may also be defined as the ra