Monte carlo simulation model, Financial Management

Assignment Help:

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.


Related Discussions:- Monte carlo simulation model

Cash budget, We need to have done some exploration work on all of the major...

We need to have done some exploration work on all of the major projects for inclusion in our prospectus, but of our $4m we need at least $1m in the bank to pay for all the listing

Explain the meaning of - purchase consideration, Explain the meaning of - P...

Explain the meaning of - Purchase consideration The  type  of  offer  made  to  target  company's  shareholders  would have  a  big  impact on acceptance. Apparently the price

What financial managers look for when they analyze pro forma, What do finan...

What do financial managers look for when they analyze pro forma financial statements? Later than the pro forma financial statements are complete, financial managers analyze the f

Working of australian securities and investment commission, Working of ASIC...

Working of ASIC ASIC as an independent government body enforces and regulates company and financial services laws to protect consumers, investors and creditors. It keeps the pu

State the rate of return of a bond - debt securities, Rate of return of a B...

Rate of return of a Bond In case of bonds, rather than dividends, investor is entitled to payments of interest yearly or semi-annually. Investor also benefits if there is an ap

Cost of equity share capital, Q. Cost of Equity Share Capital? Cost of ...

Q. Cost of Equity Share Capital? Cost of Equity Share Capital: - The cost of equity is the utmost rate of return that the company should earn on equity financed position of its

Beta, what is the value of beta for this fund ? If the benchmark index for ...

what is the value of beta for this fund ? If the benchmark index for this mutual fund increased by 11.00% during the period covered by beta measure, what was the rate of return for

Walter''s Model, Explain the effect of different dividend policies on the v...

Explain the effect of different dividend policies on the value of share respectively as per the walter model in Case 1: Dividend payout ratio is 50% Case 2: Dividend payout ratio

Determine about the risk management systems, Determine about the risk manag...

Determine about the risk management systems Management must report to board their review and implementation of internal controls and risk management systems. The board must rev

Sensitivity analysis, A division of Saron plc is considering introducing a ...

A division of Saron plc is considering introducing a new product.  The product is the result of work undertaken by the division's research and development department - the expendit

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd