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

Determine the expected net present, Karl Robinson is about to make his firs...

Karl Robinson is about to make his first major decision as president and chief executive officer of Conway Control & Instrument Corporation, a manufacturer of electronic test instr

Define the conversion ratio and conversion value, Define the following term...

Define the following terms that relate to a convertible bond:  conversion ratio, conversion value, and straight bond value. The term conversion ratio is the number of shares of c

Compare and contrast mutual and stockholder-owned savings, Compare and cont...

Compare and contrast mutual and stockholder-owned savings and loan associations. Some loan and savings associations are owned by stockholders, just as commercial banks and oth

State the examples of tests of controls, State the Examples of tests of con...

State the Examples of tests of controls: Check bank reconciliation has been reconciled as approved by chief accountant. Observe buyer checking the goods received note a

How amount of financing affecting cost of capital, Q. How Amount of financi...

Q. How Amount of financing affecting cost of capital? Amount of financing as the financing require of the firm become larger , the weighted cost of capital increased several re

Weighted-average cost of capital, A Company has the following capital struc...

A Company has the following capital structure: Debt: $2,000,000 Preferred: $1,000,000 Common: $4,000,000 Retained Earnings: $3,000,000 The amounts shown gives book values.  The m

Depreciation expense and investment in property plant, Use the excel spread...

Use the excel spreadsheet to project the net income for Winnebago from assumptions about key revenue & expense items.   Use the following assumptions to evaluate the projected net

Business analysis, 1. Each student has been allocated one Australian compan...

1. Each student has been allocated one Australian company. This information is available in the unit website. You should check that a company is assigned to you. 2. It is your r

Annuties (ordinary vs due), The values shown in ordinary annuity tables (ei...

The values shown in ordinary annuity tables (either present value or compound value) can be adjusted to the annuity due form by ____ the ordinary annuity interest factor by ____. (

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