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

Liquidity risk, An investor, who wants to sell a bond even before it ...

An investor, who wants to sell a bond even before it reaches its maturity date, would be concerned as to whether he will receive a price that is close to the true

Capital gain on investment, a. Why do prices of low coupon bonds tend to fl...

a. Why do prices of low coupon bonds tend to fluctuate more than the prices of high coupon bonds? And why do prices of longer te$ to maturity bonds tend to fluctuate more than th

Hy would a borrower be willing to pay and a lender demand, Would there be p...

Would there be positive interest rates on bonds in a world with absolutely no risk no default risk, maturity risk, and so on? Why would a, borrower be willing to pay and a lender d

Comparative financial statement analysis, You are currently employed by DPT...

You are currently employed by DPT Holdings Ltd (DPT) one of the world's largest MNEs based in the United Kingdom. DPT is looking to enter into a new phase of global expansion activ

Operating cycle, applicability of an operating cycle in vegetable growing b...

applicability of an operating cycle in vegetable growing business

Describe the functions of controller, Q. Describe the Functions of Controll...

Q. Describe the Functions of Controller? (1) Planning and budgeting: - It comprises capital expenditure planning, profit planning, budgeting, inventory control, sales forecasti

Viability of project - syringe management, The syringe management program t...

The syringe management program tries to educate society by increasing the capacity and quantity of the syringe disposable centers , providing timely responses to all syringe compla

Current yields for treasury bond, ACT presently is all-equity financed. Thi...

ACT presently is all-equity financed. This reflects the stance of the former CEO, a dominant personality who stated repeatedly: "I don't want us to be in thrall to the demands of t

Analyze the corporate financial statements, You are currently an Analyst wo...

You are currently an Analyst working for a finance publication firm and as part of your responsibilities; you are required to provide a monthly forecast and analysis of certain com

Highest earnings-per-share, McGovern Company is comparing two disimilar cap...

McGovern Company is comparing two disimilar capital structures - an all-equity plan (Plan I) and a levered plan (Plan II).  Under Plan I, the Company would have 700,000 shares of s

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