So I did a Facebook DCF, and getting a very high stock price of $174.52. Can someone maybe comment if this is correct? Seems a little high for me, so I am not sure what I am supposed to fix to make it lower and more reasonable.
Edit (1): I fixed it again, and it is at 168 now. Not sure if this is still a little high.
Edit (2): fixed the "terrible" formatting.
Any suggestions would help!
| Attachment | Size |
|---|---|
| FB Snapshot DCF v8 298.78 KB | 298.78 KB |
| Excel File 42 KB | 42 KB |
| +96 | Bathroom War Crimes | 22 | 14h |
| +57 | for you youngins (under 40, ideally under 30), what do you want out of life? | 34 | 5h |
| +51 | We all should've gotten in tech | 28 | 4h |
| +30 | Stealth-Listening Devices | 8 | 17h |
| +13 | Totally random question | 6 | 1d |
| +12 | Companies with products that track terminal/analytics desktop usage | 1 | 4d |
| +12 | Pickleball Manhattan | 4 | 20h |
| +9 | Ordering Valium Online: Key Considerations | 0 | 3d |
| +8 | LinkedIn Shitposts | 3 | 2d |
| +7 | my advisor looks a little too good | 7 | 2d |
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.
Not to be rude, but your formatting is terrible. Some numbers have decimals, some have no decimals, some show two decimal points, some show one, some negative numbers are in parenthesis, some show negatives signs...
One thing that seems really high is your terminal multiple. I don't work in a tech group, but 19.3X EBITDA is very high. Where is 19.3X coming from? Again, I don't work with tech companies, so I could be mistaken.
Fixed the formatting. Thanks for pointing it out. I was focusing too much on the numbers.
As for EBITDA multiple, I actually used the assumptions I read from an equity research report. Was it ok to do that?
Was the EBITDA multiple in the research report an LTM or NTM number? Or was it the exit multiple they assumed in a 5yr DCF?
Big difference for a growth company.
I would recommend that you post the excel version because that .pdf version doesn't help us help you lol. If you post the excel we might be able to track calculation errors, or aggressive assumptions that is most undoubtedly the case.
Thanks! Posted the Excel file.
19.3 EV/EBITDA is an incredibly high multiple for any company. Apple's is less than 10 currently, for example.
Equity research reports can be overly optimistic. You should look at a bunch of equity research reports and create a range of multiples from which you should pick the mean/median to stay conservative.
Thanks!
A few things: 1. All your projections are based on estimates, which inflate the value of your assumptions by a lot. I would start by putting down a couple years of actual figures so that the assumptions are a little more concrete. Your growth figures seem a little aggressive as well (i.e. You project growth at pretty high rates, if you look at historical data the numbers are much less.) Same thing pertains to your depreciation numbers, so I would go back and revise the entire model and the growth rates you use. 2. Your tax rate also seems pretty high, I did a quick tax calculation for the past couple years and your tax rate of 32% is not reflective of the actual tax rate.
To be very honest, I just looked at those few things and found inconsistencies/issues. I would go back and edit the model and be more in-depth. Also, not sure where you picked up your beta from but I would actually go back and add a couple more sheets (One with hard-coded previous years' data --> 5 years should be good). You can make assumptions about growth rates from here based on historical numbers.
Would also add a Comps sheet, so that you can do things like un-lever and re-lever beta to have a more accurate number for beta. Also would recommend cleaning up the model a little more, the numbers are everywhere and don't have a consistent flow.
I will say this, if you're making this for practice good on you - keep grinding a couple more of these (also would recommend creating full operating models). These will go a long way in improving your understanding/modelling skills.
Good luck.
Thank you for this! Awesome advice!!
Your projected growth rate is very high (~20% CAGR in explicit forecast period); your discount rate is very low (the discount rate you would expect from stable cash flow generating, mature business) and your exit multiple is through the roof. Who would pay 19.3x EBITDA for facebook? Better yet, who could pay that much for it?
Beta needs to be higher; consider company specific risk premium; consider size premium; consider revised growth estimate; consider replacing exit multiple with gordon growth capitalization rate based on a reasonable long-term growth rate.
hey I'm trying to see where you pulled out all this information? I'm currently using the sec filings
Blanditiis qui magnam hic molestiae. Dignissimos nihil unde aspernatur velit quo officia. Et repellendus cumque aspernatur cumque debitis.
Corporis temporibus repellat atque molestias enim sequi. Veritatis et ab officia soluta autem aliquid eaque. Architecto aut reiciendis eum laborum minus temporibus minima. Facere fugiat nulla aut porro voluptatum temporibus dolores ratione. Aperiam atque veniam in nemo. Non veniam officiis nemo est labore eveniet.
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...