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

Explain the effect of foreigners’ portfolio investments, As the early 1980s...

As the early 1980s, foreign portfolio investors have purchased an important portion of U.S. treasury bond issues. Discuss the short-term and long-term influences of foreigners’ por

Calculate amount to fund the endowment, On Completion of her introductory f...

On Completion of her introductory finance course, Kieran was so pleased with the amount of useful and interesting knowledge she gained that she convinced her parents, who were weal

What do you mean by economic risk, Q. What do you mean by Economic risk? ...

Q. What do you mean by Economic risk? Transaction risk is appears as the short-term manifestation of economic risk which could be defined as the risk of the present value of a

What is an lbo, What is an LBO? What are the risks for the equity investor...

What is an LBO? What are the risks for the equity investors and what are the potential rewards? A leveraged buyout is a buy of a publicly owned corporation by a small group of

Total revenue change, Write an essay explaining that the quantities of good...

Write an essay explaining that the quantities of goods and services that we can produce are limited by both our available resources and by technology. Assume we want to increase

Define intermediation, Define intermediation The financial system makes...

Define intermediation The financial system makes it probable for surplus and deficit economic units to come together, exchanging funds for securities, to their mutual advantage

Parity conditions, Parity Conditions A parity condition defines the rel...

Parity Conditions A parity condition defines the relative value of one country's currency to the other country's currency. The condition states how, for the example, difference

What is the time value of money, What is the time value of money? The t...

What is the time value of money? The time value of money signifies that money you hold in your hand today is worth more than money you expect to receive in the future. Likewise

Portfolio diversification, Portfolio Diversification The objectives of ...

Portfolio Diversification The objectives of diversification are to: Reduce the variability of the fund's total return; Reduce the exposure to any single component of t

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