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

Techniques of inventory control, Examine the reasons for holding inventorie...

Examine the reasons for holding inventories by a firm & also discuss the techniques of inventory control

Hedge against this foreign currency exposure, Question: Part A: Just...

Question: Part A: Justify and criticize the usual assumption made in Financial Management literature that the objective of a firm is to maximize the wealth of its sharehol

Importance of mutual funds in the investment intermediaries, Define the imp...

Define the importance of mutual funds in the investment intermediaries. Mutual funds: Mutual funds pool resources by several companies and individuals and invest these re

Meaning of capital budgeting, Meaning of Capital Budgeting Decisions r...

Meaning of Capital Budgeting Decisions relating to irreversible commitment of funds to projects whose profits are to be reaped over a time span longer than the current account

Representation of generator winding, Q. Representation of generator winding...

Q. Representation of generator winding? The notation using subscripts is such that VAB is the potential at point A with respect to point B, IAB is a current with positive flow

Advanced financial management, QUESTION 1 [25 marks] Xelo Ltd, whose curren...

QUESTION 1 [25 marks] Xelo Ltd, whose current sales consist of fixed operating costs of R140 000 and variable operating costs equal to 22% of sales, has made the following two sale

Determine the advantages of explicit cost, Determine the advantages of expl...

Determine the advantages of explicit cost Explicit cost of an interest bearing debt will be the discount rate which equates present value of the contractual future payments of

Statement used in working capital requirement, • Debtors :- Working Capi...

• Debtors :- Working Capital tied up in debtors must be estimated on the basis of cost of sales (excluding depreciation): [Cost of goods produces (that is raw materials + wages

Capital budgeting case study, RWE Enterprises is a small manufacturer in Ad...

RWE Enterprises is a small manufacturer in Adelaide South Australia, feed suppliments for cattle. New production line NPV, Payback period and discounted payback period

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