Biotech investing basics part 4: DCF analysis

  Рет қаралды 13,088

Bay Bridge Bio

Bay Bridge Bio

2 жыл бұрын

GOOGLE SHEET HERE: docs.google.com/spreadsheets/...
The google sheet includes a sample DCF with comments explaining each line item and how to forecast them.
If you have questions let me know in the comments.

Пікірлер: 37
@foldsandcurves4496
@foldsandcurves4496 2 жыл бұрын
Awesome, lots of "how-to-DCF" content online but few specific to biotech - thanks!
@1000imps
@1000imps 2 жыл бұрын
Great video! Thanks!
@Zhugongde
@Zhugongde 10 ай бұрын
Hey, awesome video! I was trying out a valuation for a small biotech and realized that I was having some trouble finding the list price for drugs and information on drug penetration for benchmarking. Is there a database where we can find these values or are they provided in one of the financial statement documents? I apologize if this is a really basic question - my background is in science so I am a bit unfamiliar with the more financial/ cost projection side of things. Thanks in advance!
@hkgfhg
@hkgfhg Жыл бұрын
Great video! Do you have any recommendations on how to find interesting/relevant biotech companies to analyze?
@jaydee18828
@jaydee18828 7 ай бұрын
Very helpful video, thank you! Do you know of any good resources to help develop assumptions to project any post-approval R&D costs?
@mattn5355
@mattn5355 2 жыл бұрын
Thanks for all the resources and explanations. How could I use this DCF for a drug that is already approved but in early stages of commercialization?
@baybridgebio2576
@baybridgebio2576 2 жыл бұрын
For an already approved drug, you would use mostly the same model, but you would not need to probability-adjust the cash flows. You would also start modeling revenue in year 1, rather than modeling $0 revenue per year until the year the drug is approved (which is what you'd do for a pre-launch drug). If you look at the google sheet in the video description, basically you'd change the "Clinical phase" in row 39 to "Approved" for every year. Then in row 63 (Probability of clinical success given stage), you'd have each cell be 100%. Then you'd change row 20 (Penetration) so that the sales ramp starts in year 1 (instead of having 0% market penetration for the first few years until approved). You'd also have to change R&D expense in row 38 to only include post-approval R&D costs.
@miteshpatel2190
@miteshpatel2190 Жыл бұрын
Amazing video; the entire series is incredible. Quick question; how do you account for multiple drugs/products in the portfolio?
@baybridgebio2576
@baybridgebio2576 Жыл бұрын
You can model the risk-adjusted cash flows for each program separately. Then you add up the risk-adjusted cash flows from the products. Then you have to account for any general corporate spend that isn't attributable to specific programs, and probability adjust that (I adjust gen corp expenses by the prob that there is at least one program active at the given time, though there are other approaches). You calculate taxes and working capital based on risk adjusted general corp cash flows, and calculate capex and D&A based on either general corporate or program specific risk-adj cash flows.
@bardacha100
@bardacha100 9 ай бұрын
Question : is there a general rule on whether to start with incidence or with prevalence?
@stanhan2006
@stanhan2006 2 жыл бұрын
Absolutely the best video, thank you! I am a amateur bio investor and have to estimate Market cap. I use future revenue x5 to estimate market cap for simplicity. Is it less accurate?
@baybridgebio2576
@baybridgebio2576 2 жыл бұрын
Using peak sales multiples is a very common and valid valuation method, whether it's the best metric for a given company and whether 5x is the right number depends on the company.
@sebastiansejr2655
@sebastiansejr2655 2 жыл бұрын
Thanks for this - This really was the meat of this series! Where do you have your experience from? Will this be similar to models in in life science VCs?
@baybridgebio2576
@baybridgebio2576 2 жыл бұрын
The earlier stage the investor, the less they use DCFs. Most VCs value companies based on comps rather than DCFs. Re where I got my experience: I've worked in biotech finance my whole career, including venture / public equity funds, investment banking, in the biotech groups at big tech companies, and independent consulting.
@sebastiansejr2655
@sebastiansejr2655 2 жыл бұрын
@@baybridgebio2576 Thanks for the reply! That's an awesome list of proffesional experience. Do you have any advice for breaking into biotech finance and specifically VC? I'm just out of business school with a MSc in healthcare innovation and have started in pharma consulting (mostly on the clin ops and IT side).
@lilgiant93
@lilgiant93 2 жыл бұрын
Great vid, two questions - 1. Is it necessary to build in a balance sheet? and why / why not? 2. What is the rational for probability adjusting the FCF as opposed to EBIT or net income?
@baybridgebio2576
@baybridgebio2576 2 жыл бұрын
Whether you include a balance sheet depends on the use case, but if you are just doing a quick DCF to value a stock for your personal investment you don't need a balance sheet. The only items from the balance sheet that flow directly to the DCF are changes in net working capital. DCFs also require D&A and capex (which occur on the CF statement but flow to the balance sheet). So if you build an income statement and then forecast capex, D&A and change in working capital, you can do a DCF even without a full balance sheet. The rationale for probability adjusting FCF rather than EBIT or net income is that for DCF analysis, we value the business based on unlevered free cash flows. If you use EBIT, you don't capture cash flows from taxes, D&A, capex and changes in working capital. If you use net income, you don't capture cash flows from D&A, capex and changes in working capital.
@nicholaskoiava391
@nicholaskoiava391 2 жыл бұрын
Hey Richard, really insightful video. I just had a question about the probability of cash flows, as I do understand that the probability of cash flows in phase 3 is equivalent to the probability of success in phase 2, what is the rationale for calculating the probability of cash flows for the Approval stage? In other words, why are you multiplying the probability of success of phase 3 by the probability of cash flows in phase 3?
@baybridgebio2576
@baybridgebio2576 2 жыл бұрын
If I understand the question correctly : you need to multiply cash flows if approved by probability of approval because not all drugs that are submitted for approval are ultimately approved. Even if the Phase 3 studies succeed, and the company submits for approval based on those studies, the drug can still be rejected. So we have to adjust for that.
@snowxu9214
@snowxu9214 2 жыл бұрын
Amazing video! Just one question, where could I have access to this Google sheet?
@baybridgebio2576
@baybridgebio2576 2 жыл бұрын
Link is in the description, let me know if you have trouble accessing it.
@caseyfuller1543
@caseyfuller1543 2 жыл бұрын
Please correct me if I am wrong but this is a DCF for a singular drug. Thus all inputs must be relative to a singular potential drug not the company as a whole. What is the best way to find these inputs for a singular drug since company financials are a combination of all their products?
@baybridgebio2576
@baybridgebio2576 2 жыл бұрын
You are correct that this is for a single drug. To model a company with multiple drugs, just build a revenue build (like the one in the model) for each major indication of each major drug. You can also model a separate income statement for each drug, and then sum the probability-adjusted cash flows of all drugs, then discount those to get your DCF value. The inputs for each drug come from a variety of sources. You will have to do research outside of the financial statements for most of these inputs. The google sheet example DCF linked in the description has some guidance on where to find these inputs. Most line items have a comment explaining more about the item and where to find the input.
@georgiosaxarlis1396
@georgiosaxarlis1396 2 жыл бұрын
Richard, another queestion about when you want to model a company with a few drugs on its pipeline. How do you do the Prob-adjusted FCF? Do you do the cash flows probability for every drug and then just multiply to end up with the combined one?
@baybridgebio2576
@baybridgebio2576 2 жыл бұрын
You can just model out the cash flows for each drug, probability adjust them, then add the cash flows together. Then you discount the combined cash flows. Sometimes you can just forecast revenue individually for each drug, then add revenue together, then model the expenses for the combined company. Then discount those cash flows. Depends on the company and purpose of the model
@georgiosaxarlis1396
@georgiosaxarlis1396 2 жыл бұрын
@@baybridgebio2576 got it thank you!
@georgiosaxarlis1396
@georgiosaxarlis1396 2 жыл бұрын
Great video, Richard, thank you. One quick favor/question: You said at 44:51 that "If you are modeling a company that has a platform that's going to have value indefinitely into the future, then you may want to include a terminal value." Can you do a video where you go through a DCF for the platform of a clinical-stage company, which, thus, will include calculations for the terminal value? (and just on the top of your head, if we were to use the Gordon Growth Method how would you go about choosing the number for the long-term growth rate for a clinical-stage biotech?)
@baybridgebio2576
@baybridgebio2576 2 жыл бұрын
For a clinical stage company, I'd model the value of the clinical-stage assets separately from the platform, and model the assets until patent expiry with no terminal value. Platforms are quite difficult to value, and how you model platform value depends on the specific platform. I generally don't like to value therapeutic platforms with a DCF as a DCF for a platform would rely on so many uncertain assumptions that you can't have much confidence in the DCF output. You can model products using a DCF, but the residual "platform" value is harder to value with a DCF. Most people value platforms using comps but these valuations are still very uncertain and messy. You can check out this 14D9 filing from Synthorx to see how Centerview valued their platform (page 25 on): www.sec.gov/Archives/edgar/data/0001609727/000119312519322708/d855631dsc14d9.htm In reality investors have a hard time valuing platforms and there isn't a ton of science to it. If a platform plays a big part of your thesis just do a lot of technical diligence, understand what products can come from the platform, what differentiates it from competing platforms, how acquirors might value the platform, when the market will start appreciating the platform value, etc. And run sensitivity analyses on the impact of the change in platform value impacts share price.
@georgiosaxarlis1396
@georgiosaxarlis1396 2 жыл бұрын
@@baybridgebio2576 Got it thanks. Do you have any resources that discuss techniques for valuing a platform?
@baybridgebio2576
@baybridgebio2576 2 жыл бұрын
Platforms are generally valued using comps. You can check out that 14D9 filing for Synthorx that I linked in the above comment for an example. The art is picking the right comp set. Mgmt will always try to create a story that makes the platform seem more valuable than other platforms, investors have to do their diligence to determine whether that story is true.
@georgiosaxarlis1396
@georgiosaxarlis1396 2 жыл бұрын
@@baybridgebio2576 Makes sense! Thank you very much, Richard.
@wallstreetmonky6797
@wallstreetmonky6797 2 жыл бұрын
What university degrees would you suggest pursuing to get the strong foundation of scientific knowledge required to fully understand these companies and the drugs they are producing?
@baybridgebio2576
@baybridgebio2576 2 жыл бұрын
I think any relevant technical degree - biology, chemistry, bioinformatics- is a good foundation. Most funds also want to hire people with relevant advanced degrees - PhD or MD. But IMO the most important thing is to be able to talk to experts in different fields, then synthesize and critically analyze what they say. Biotech requires so many diverse and advanced technical skills that no one person can understand everything.
@wallstreetmonky6797
@wallstreetmonky6797 2 жыл бұрын
@@baybridgebio2576 Okay, thank you!
@xixtinthegreat
@xixtinthegreat 2 жыл бұрын
Great Presentation. Cant see the comments on the DCF excel sheet.
@baybridgebio2576
@baybridgebio2576 2 жыл бұрын
Should be fixed now. Thanks for the heads up!
@xixtinthegreat
@xixtinthegreat 2 жыл бұрын
@@baybridgebio2576 Thanks for sharing and quick reply. Really appreciate
Biotech investing basics part 1: value in biotech
21:39
Bay Bridge Bio
Рет қаралды 24 М.
The DCF Model: The Complete Guide… to a Historical Relic?
43:24
Mergers & Inquisitions / Breaking Into Wall Street
Рет қаралды 70 М.
Nastya and SeanDoesMagic
00:16
Nastya
Рет қаралды 17 МЛН
THEY made a RAINBOW M&M 🤩😳 LeoNata family #shorts
00:49
LeoNata Family
Рет қаралды 43 МЛН
Jared Friedman - Advice for Hard-tech and Biotech Founders
24:33
Y Combinator
Рет қаралды 70 М.
Intro to clinical data: biotech investing basics
25:25
Bay Bridge Bio
Рет қаралды 4,1 М.
Biotech investing basics part 3: intro to valuation
23:50
Bay Bridge Bio
Рет қаралды 7 М.
80 Year Olds Share Advice for Younger Self
12:22
Sprouht
Рет қаралды 1,4 МЛН
Biotech investing basics part 2: measuring value in biotech
35:48
Bay Bridge Bio
Рет қаралды 11 М.
How to Become a Good Biotech Entrepreneur
25:02
Labiotech.eu
Рет қаралды 15 М.
How to Analyze a Cash Flow Statement Like a Hedge Fund Analyst
16:12
Investor Center
Рет қаралды 656 М.
How to Invest in Biotech Stocks -- Everything You Need to Know
28:13
The Motley Fool
Рет қаралды 36 М.
A Guide To Emerge As A STAR Equity Research Analyst
31:20
Larry Cheung, CFA
Рет қаралды 35 М.
Biotech Forecasting and Valuation with Frank David, MD, PhD
1:01:29
FirstThought
Рет қаралды 1,5 М.
Cheapest gaming phone? 🤭 #miniphone #smartphone #iphone #fy
0:19
Pockify™
Рет қаралды 4,3 МЛН
Копия iPhone с WildBerries
1:00
Wylsacom
Рет қаралды 4,9 МЛН
EXEED VX 2024: Не өзгерді?
9:06
Oljas Oqas
Рет қаралды 49 М.