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

Credit card receivable-backed securities, For holders of CARDS,...

For holders of CARDS, the interest is paid monthly and the principal is not amortized. The principal payments made by credit card borrowers are

Analysis of operations, You must analyze the operating performance of your ...

You must analyze the operating performance of your company. You will use ratio analysis and primarily using Liquidity, Profitability and Working Capital ratios. You will use a g

Increase total revenue, The Australian skiing industry operates out of a ve...

The Australian skiing industry operates out of a very narrow seasonal base-approximately three months in a good season. In a good year, providers of accommodation, ski hire and tow

Accrued dividend, It is an accounting term which refers to the balance shee...

It is an accounting term which refers to the balance sheet item that accounts for dividends that have been confirmed but not yet given to shareholders. Accrued dividends are taken

Financial reports, Financial Reports: Each person has their own percept...

Financial Reports: Each person has their own perception on what a particular financial report should contain, and invariably in what they consider to be the important factors w

Final stage of career, Q. Final stage of career? The final stage in one...

Q. Final stage of career? The final stage in one's career is difficult for everyone but is it hardest for those who have had continued successes in the earlier stages. After se

Benefit and drawback of maintaining many manufacturing sites, Discuss the b...

Discuss the benefits and drawbacks of maintaining multiple manufacturing sites like a hedge against exchange rate exposure. Answer:  To set up multiple manufacturing sites can

Describes net income approach to capital structure, Q. Describes Net Income...

Q. Describes Net Income Approach to Capital Structure? Net Income Approach: - As-per to the Net Income Approach as suggested by Durand the capital structure decision is applica

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