Тёмный

Using Monte Carlo simulations for valuation 

Financial Analysis with Dr Jeff
Подписаться 733
Просмотров 13 тыс.
50% 1

How to quickly set up Monte Carlo analysis in a valuation spreadsheet to allow for variation in key inputs
Here is a link to the relevant sheets of the spreadsheet I am using in this video: tinyurl.com/bdh7pfr9
You can download this file and see how the Monte Carlo analysis works
#financialanalysis
#valuation
#accounting
#excel

Опубликовано:

 

29 мар 2023

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 16   
@mohammadjonaid8232
@mohammadjonaid8232 5 месяцев назад
You’re a life saver!
@richardgordon
@richardgordon 7 месяцев назад
This is genius!
@greensal86
@greensal86 6 месяцев назад
Thank you Dr. Jeff! This is a great video. What goes in my mind is how do you pick which distribution the assumptions should follow, for example revenue.
@financialanalysiswithdrjef931
@financialanalysiswithdrjef931 6 месяцев назад
That's the tricky bit! The 'big picture' idea of monte carlo sims is to get a general sense of how sensitive your baseline forecasts are to changes in inputs. You'd think about revenue distributions by looking at the business model and industry conditions, and for longer-term forecasts, macro conditions. Some industries might have a 'winner takes all' dynamic, which would look different to a highly competitive industry. Or sometimes a business might be about to release a product that if successful makes the company, and if not, puts it in trouble. So you need to pick a distribution that most closely matches your view on potential outcomes!
@greensal86
@greensal86 6 месяцев назад
@@financialanalysiswithdrjef931Thank you for the added clarification. So let's say we are following a public company. The company provides guidance for the next two years. I would then possibly set a triangular distribution for these two years. Assuming that I am running monte carlo simulation for the next 10 years, and assuming that the company is in a mature cycle, I would then want to consider for example a lognormal distribution. Is that a reasonable thought process?
@financialanalysiswithdrjef931
@financialanalysiswithdrjef931 6 месяцев назад
@@greensal86 that sounds reasonable. One thing you'd consider in setting the simulation parameters is whether the company's guidance is likely to be optimistic or pessimistic. We know that management forecasts are on average optimistic.
@greensal86
@greensal86 6 месяцев назад
Thank you again!@@financialanalysiswithdrjef931 How do you deal with correlation between the simulated accounts (for example, COGS, CapEx, R&D, etc.) and revenue?
@sumanthasaha61
@sumanthasaha61 8 месяцев назад
Hi Dr. Jeff, really awesome explanation. Can you make a video on Monte Carlo Sim. using different distribution assumptions like Triangular distribution, log-normal distribution, and norm dist. for valuation.
@financialanalysiswithdrjef931
@financialanalysiswithdrjef931 7 месяцев назад
Great suggestion. Yes, I'll be able to do that.
@sethlemoal7415
@sethlemoal7415 7 месяцев назад
Great video Dr. Jeff! My only question would be : How do we decide what StDev to use for the inputs we vary. That decision may have substantial impact on our output. Is there a way we can choose this with some accuracy?
@financialanalysiswithdrjef931
@financialanalysiswithdrjef931 6 месяцев назад
@sethlemoal - that's a great question, and it's the hardest part of this. You need to select a mean and standard deviation that make sense (ie that are plausible). This will come from an understanding of the business that you're looking at, the industry condition it faces (which influence likely growth and profitability). We know that things like sales growth and profitability tend to 'revert to the mean' over time, so an understanding of what is typical for an industry tends to help here. The benefit of doing the Monte Carlo analysis is to get a sense of how much your end result varies as you change these assumptions.
@fameboyish3312
@fameboyish3312 2 месяца назад
When i do this i always get two values for the stock price that are way to high. How can i stop this form happening? Is there something wrong with my settings.
@salardelavarqashqai6361
@salardelavarqashqai6361 8 месяцев назад
Please attach your excel files for better understanding
@financialanalysiswithdrjef931
@financialanalysiswithdrjef931 8 месяцев назад
I have put a link to the file in the video description. Here it is: tinyurl.com/bdh7pfr9
@salardelavarqashqai6361
@salardelavarqashqai6361 7 месяцев назад
thanks
@vf84tcat1
@vf84tcat1 6 месяцев назад
extremely confusing
Далее
Monte Carlo Simulation - NPV example
7:01
Просмотров 207 тыс.
Session 2: Intrinsic Value - Foundation
11:32
Просмотров 732 тыс.
Monte Carlo Simulation Explained
10:27
Просмотров 21 тыс.
What is Monte Carlo Simulation?
4:35
Просмотров 227 тыс.
Monte Carlo Method: Value at Risk (VaR) In Excel
10:13
Monte Carlo Simulation in Excel - Retirement Savings
16:39