Request for a preclinical biotech pharma model

Hello, I know this is going to be akeen to a pull-out-of-the-hat situation but I've recently been tasked to run a pre-clinical biotech deal. I've read through lots of tips on WSO for valuing a biotech company and it's been really helpful!

However, I was wondering if anyone has a template that I could refer to. It would mean a lot!

Meanwhile, thank you in advance and stay healthy! :)

10 Comments
 
Most Helpful

To be a honest, a template isn't really going to help you. You need to build a sophisticated assumption tab looking at things like prevalence rate, probability of success for the therapeutic area, addressable market, peak penetration, drug price, cost per patient per trial, sales force reps to market the drug, etc. Once you can complete this your model builds itself. Use SOTP for each asset. For your comps, they should be same therapeutic area, same indication if possible and in the same phase.

 

Hi I am currently beginning to try to build a model with an assumptions dashboard that covers peak penetration, patent expiry, probability of NDA approval, probaility of success to approval, cost of trial, cost per patient, etc. But have encountered a few obstacles along the way...

First, I guess what I'm struggling with is NOLs (from the new CARES act) and biobucks due to partnerships (Upfront fee, Milestone payments, Regulatory milestones, Profit sharing etc). Furthermore, since this is a M&A deal, valuation of NOL may be a tall order.

Second would be the comps table. Since I can't use EV/EBITDA or P/E ratios, I'd figured to build a EV/R&D, EV/sales and NPV comparable given the same phase, same method and same illness that it is trying to cure. But I'm not sure if it's the right approach.

Thus, I thought it could help if there was a biotech model to refer to.

 

https://www.wallstreetoasis.com/forums/healthcare-ibd-summary-resources

A summary of WSO threads and other resources related to healthcare.

You may want to 1) model the potential market for each drug in the pipeline, taking into account what share of that market your firm may capture. Don't forget patent expiration risks. 2) Use probabilities (something like first quartile estimate=0.25, median estimate=0.5, third quartile estimate=0.25) to create 3 scenarios from which you deduce 3 potential levels of revenue, then gross profit/ebit/ebitda/net income. 4) Calculate FCF from these estimates and build a probability-weighted DCF model. 5) Sensitize.

This article is good too: https://www.investopedia.com/articles/stocks/06/biotechvaluation.asp

 

Hello, I know this is going to be akeen to a pull-out-of-the-hat situation but I've recently been tasked to run a pre-clinical biotech deal. I've read through lots of tips on WSO for valuing a biotech company and it's been really helpful!

However, I was wondering if anyone has a template that I could refer to. It would mean a lot!

Meanwhile, thank you in advance and stay healthy! :)

Hey man I'm also looking for a template. Did you ever manage to find one? 

 

Illum nihil placeat ad culpa quae non rerum. Officia quos est repellendus magnam cupiditate repellendus consectetur. Repudiandae voluptatem accusamus sit asperiores et. Ut dolore incidunt at ut assumenda ipsa omnis.

Vero veniam veniam debitis nisi accusamus ea tempore in. Quaerat est ea animi illum beatae praesentium exercitationem. Optio est necessitatibus itaque magni ea voluptatem. Pariatur autem repellat quasi eos sunt qui. Nam soluta soluta et saepe quo facere quo.

Et beatae provident nemo architecto ea harum. Molestias enim eligendi omnis dolores quia id. Beatae expedita assumenda dignissimos nihil. Nam cum beatae pariatur eos quos. Explicabo culpa harum dolores saepe non facere vero.

Career Advancement Opportunities

November 2026 Investment Banking

  • Evercore 01 99.5%
  • Moelis & Company 01 99.0%
  • JPMorgan 01 98.4%
  • Guggenheim Partners 02 97.9%
  • Morgan Stanley 06 97.4%

Overall Employee Satisfaction

November 2026 Investment Banking

  • Moelis & Company No 99.5%
  • Morgan Stanley 02 99.0%
  • Evercore 01 98.4%
  • Banco Santander 04 97.9%
  • BMO Capital Markets 13 97.4%

Professional Growth Opportunities

November 2026 Investment Banking

  • Evercore 01 99.5%
  • Moelis & Company 01 99.0%
  • Morgan Stanley 05 98.4%
  • Goldman Sachs 01 97.9%
  • JPMorgan No 97.4%

Total Avg Compensation

November 2026 Investment Banking

  • Vice President (17) $409
  • Associates (58) $261
  • 3rd+ Year Analyst (8) $210
  • 2nd Year Analyst (29) $183
  • Intern/Summer Associate (16) $161
  • 1st Year Analyst (84) $151
  • Intern/Summer Analyst (77) $101
notes
16 IB Interviews Notes

“... there’s no excuse to not take advantage of the resources out there available to you. Best value for your $ are the...”

Leaderboard

1
redever's picture
redever
99.2
2
Secyh62's picture
Secyh62
99.0
3
BankonBanking's picture
BankonBanking
99.0
4
kanon's picture
kanon
99.0
5
GameTheory's picture
GameTheory
98.9
6
DrApeman's picture
DrApeman
98.9
7
dosk17's picture
dosk17
98.9
8
CompBanker's picture
CompBanker
98.9
9
Betsy Massar's picture
Betsy Massar
98.9
10
Linda Abraham's picture
Linda Abraham
98.8
success
From 10 rejections to 1 dream investment banking internship

“... I believe it was the single biggest reason why I ended up with an offer...”