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

Economic order quantity, annual uasage of stock 100,000units carrying ...

annual uasage of stock 100,000units carrying cost per unit of stock RM2 order cost RM250 question there is a constraint arising from the floor space of the

What are the material items are carried out, What are the Material items ar...

What are the Material items are carried out Material items would have an impact on: Audit tests carried out. For illustration compliance based testing (relying on contro

What circumstances would market to book value ratios, Under what circumstan...

Under what circumstances would market to book value ratios be misleading?  Explain. The Market to Book ratio is helpful, however it is only a irregular approximation of how li

Theoretical spot rates, The theoretical spot rates for treasury secur...

The theoretical spot rates for treasury securities represent the appropriate set of interest rates that should be used to value the risk from default-free cash fl

Briefly explain non financial objectives, Briefly Explain Non Financial Obj...

Briefly Explain Non Financial Objectives Monetary statements of any sort are only an expression of organisational activities that can be measured. Lots of the activities of an

Non-interest rate indexes, Generally, an interest rate or an interest...

Generally, an interest rate or an interest rate index is used as a reference rate for However, through financial engineering, issuers have been able to construct

Preemptive right protect the interests of existing stockhold, How does a pr...

How does a preemptive right protect the interests of existing stockholders? A preventive right protects the interests of existing stockholders by giving them the opportunity to

Swiss variable rate mortgage, A Swiss Variable Rate Mortgage (S...

A Swiss Variable Rate Mortgage (SVRM) is a version of ARM which carries a coupon rate that a bank can change any time giving a notice of three m

What are the major sections of the statement of cash flows, What are the ma...

What are the major sections of the statement of cash flows? a.Cash flows from Operations b.Cash flows from investing activities c.Cash flows from financing activities

How financial system works, Question: Part A  The financial syste...

Question: Part A  The financial system is complex in structure and function throughout the world. There are many different types of institutions: banks, insurance compani

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