Why should financial professionals use the “Monte Carlo simulation” function of #Excel?
The results of the evaluation are subjective in any case. We perform experiments that create probabilities. Therefore, it is necessary to represent the model using Monte Carlo simulation technique. Excel has the rand() function, which generates multiple random simulations (Uniform Distribution), and this simulation can be performed 1000 times or even 10,000 times.
The function allows us to take the entire range instead of a single scenario, direct multiple different basic inputs, and see what results we get…
For example, the diagram below shows the internal range of one investment’s value, which includes aggregating the initial ranges of ROIC, EGR, WACC, and other fundamental investment parameters… The wide purple range shows that 50% of the results obtained by “randomization” of this data, 1000 times, median and average…
P.S.
Here I discuss the nuances that serve organizations during evaluations:
- A visual diagram of revenue should definitely be created to the end of the horizon, i.e., where business enters full competition and the capital’s valuation is determined. The diagram shows how harmoniously the pace decreases from growth to stability… The main thing is not to have a sudden transition, from growth to stability;
- When discussing the valuation of an organization, we assume the entire value of activities minus the value of reduced operational liabilities, i.e., those liabilities that the company does not incur interest on…. We do this because such liabilities are reflected in operational funds, otherwise, the percentage liabilities would not be included in the correct account… Therefore, during evaluation, special attention should be paid to these two types of liabilities, sometimes it is not so simple…
- In case of unstable inflation, it is best to conduct real forecasts (real ≈ nominal – inflation). At this time, the discounting evaluation should also be real, and not reflect the long-term growth as a result of inflation…
- Discount evaluation is very important, so here we must be as objective as possible. We should consider both average industry and specific company bets and evaluations. The best source of this data I see here: Cost of Capital (nyu.edu)
In the case of Georgia, it is also necessary to take into account the risk of the country, according to the countries’ perspective, ERP- you can see here: [link]
- When considering WACC, it is necessary to use fundamental rather than arbitrary data…