Discussion about this post

User's avatar
ShowMeTheValue's avatar

I have been using Monte Carlo simulation in my DCF models for several years. I limit myself to lognormal, normal and uniform distributions so to avoid overcomplicating things (do I really have enough data to know whether a lognormal distribution is better or worse than a Weibull distribution? Weibull is typically just a more calibratable approximation to a lognormal or normal or exponential anyway, etc.) The more variables required to set the distribution up, the more uncertainty I will have that the distribution is a good fit. There is always a risk of "analysis paralysis" - having so many numbers you don't know how to use then, or how to ensure they are ACTUALLY making your estimation better. Are you back-testing your model to check it's predictive accuracy? If not, keep it simple and based on fundamentals.

For this reason, I also don't check correlation of revenue growth and earnings (is the correlation statistically significant?). I used to treat revenue and earnings growth independently, but now I link them via gross margin and EBIT margin, less interest and tax expenses (all of which I consider to be independent).

I also just do some relatively simple models in Excel / Google Sheets to ensure I don't need much programming capability or extra software. What do you use?

Expand full comment
Kev's avatar

Monte Carlo will always result in the mean.

Expand full comment
3 more comments...

No posts