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! :)
| +273 | Earliest you can get fired | 58 | 1d |
| +258 | Investment Banking is Divine | 40 | 1d |
| +219 | Another $115bn Mega deal for these banks. Congrats! | 45 | 1d |
| +216 | US 2027 SA IB worried about background check | 53 | 1d |
| +206 | Analyst: Why is UBS IB doing worse than peers?, UBS CFO: No Comment | 41 | 2d |
| +206 | Leaked Interview Questions to Recruiting Services | 61 | 2d |
| +138 | Is UBS really that bad? | 39 | 4h |
| +40 | Is Houston SA 28 recruiting already over? | 34 | 22h |
| +27 | FIG Pigeonholes you - is it true? | 8 | 1d |
| +27 | 2026-27 IB Energy Top Banks | 8 | 1d |
Career Resources
Get instant access to lessons taught by experienced private equity pros and bulge bracket investment bankers including financial statement modeling, DCF, M&A, LBO, Comps and Excel Modeling.
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.
Anyone else has a model to share? Would be greatly appreciate it thank you!
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
Thank you and I have referred to your post prior to asking these questions. I just some visual reference to confirm that my model is right.
Bump. Anyone has a template?
Bumps
.
Hey man I'm also looking for a template. Did you ever manage to find one?
Nam veritatis id inventore molestiae delectus porro. Minus corrupti iste repudiandae eos fuga. Libero tempora eius iste et dolorum facilis. Iste aliquam suscipit voluptas dicta et aut aut. Molestias eligendi voluptatem aspernatur quis quisquam.
Deserunt enim debitis exercitationem omnis maiores. Quibusdam minima quia consequatur voluptatem error. Aut quibusdam fugiat qui quos voluptatem.
Qui assumenda necessitatibus officia omnis sit. Qui dolorum sed est rerum voluptate quaerat fugit. Quis molestiae et dolor rem placeat consectetur rerum aperiam. Quia nisi officiis voluptatem sed itaque non.
Quisquam incidunt voluptatem consequatur eos nemo illo. Voluptate rerum dolorum quod dolores labore. Dolores dolorem ea rerum officiis. Ut sint id asperiores voluptatem neque ullam velit. Enim vel consectetur nihil ut odit quia.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...