ER - Monte Carlo Simulation

Do you use Monte Carlo simulations in your ER work? If so, what are the applications and programming software you normally use? Looking to get a feel for how commonly this and other analytic approaches are for valuation.

WSO Elite Modeling Package

  • 6 courses to mastery: Excel, Financial Statement, LBO, M&A, Valuation and DCF
  • Elite instructors from top BB investment banks and private equity megafunds
  • Includes Company DB + Video Library Access (1 year)

Comments (8)

Oct 23, 2021 - 5:32pm

We are happy with coming up with random target price and tell investors what the implied multiple is. Why get so scientific? 

Instagram: @dickthesellsider | Substack: dicktoad.substack.com

Most Helpful
Nov 4, 2021 - 10:55am

I've seen it used in a couple of very specific situations: valuing O&G exploration companies (where you are drilling a series of prospects with a rough idea of % chance of success on each and the probabiltiy distribution, plus there is some path dependency) or early stage pharma (similar).

For most companies - what would the point be? You're trying to value a company based on fundamentals, unless you're going to start putting together probability distributions for what the revenue line looks like (which would be garbage in / garbage out) there's nothing to 'simulate'.

Nov 4, 2021 - 12:11pm

Thanks for sharing your thoughts. I was mainly thinking it might apply to the probability of success for a pharma company's trial or for a valuation of an early-stage pharma company.

Nov 4, 2021 - 12:26pm

If you have a very good idea of the % chance of success of each drug in a company's development pipeline at each stage of approval, and there are a few different drugs in the pipeline, then yeah running a Monte Carlo simulation could make some sense. 

I'm not a pharma investor but I'd be amazed if you ever have enough information on the probabilities to make Monte Carlo anything other than garbage in / garbage out.

Learn More

300+ video lessons across 6 modeling courses taught by elite practitioners at the top investment banks and private equity funds -- Excel Modeling -- Financial Statement Modeling -- M&A Modeling -- LBO Modeling -- DCF and Valuation Modeling -- ALL INCLUDED + 2 Huge Bonuses.

Learn more
Nov 4, 2021 - 10:58am

Voluptatum ullam voluptate et similique enim assumenda placeat corporis. In et et quia saepe. Odit in quis impedit et et corporis.

Numquam recusandae deserunt ea expedita. Porro rerum ad excepturi quis maxime. Voluptatem ipsa quae quisquam ut assumenda. Qui sed veniam sed enim earum occaecati nesciunt.

Adipisci aliquid omnis in beatae quae est nam. Rerum autem omnis libero minus nulla. Omnis aut soluta omnis animi non fugit quod. Optio rerum voluptas ut est consequatur consequatur. Et iste reiciendis aliquam dolorem vero perspiciatis autem occaecati.

Start Discussion

Total Avg Compensation

November 2021 Investment Banking

  • Director/MD (10) $853
  • Vice President (40) $360
  • Associates (234) $234
  • 2nd Year Analyst (144) $156
  • 3rd+ Year Analyst (34) $154
  • Intern/Summer Associate (107) $146
  • 1st Year Analyst (513) $136
  • Intern/Summer Analyst (394) $84