Question for you re public comps:
I am trying to obtain fully diluted shares outstanding in a straightforward manner utilizing CapIQ. Purpose: for public comps, specifcally market cap and total enterprise value (TEV).
When using the treasury stock method (TSM) for getting options in the $, is it ok to use the weighted average strike price from CIQ? Will this get me to the same result as if I were to try to obtain every options tranche?
Would really appreciate your help, all. Thanks much!
| +271 | Earliest you can get fired | 58 | 1d |
| +249 | Investment Banking is Divine | 40 | 22h |
| +224 | Career Crossroads | 31 | 1d |
| +213 | US 2027 SA IB worried about background check | 53 | 19h |
| +213 | Another $115bn Mega deal for these banks. Congrats! | 45 | 23h |
| +206 | Analyst: Why is UBS IB doing worse than peers?, UBS CFO: No Comment | 41 | 1d |
| +131 | Is UBS really that bad? | 38 | 22h |
| +40 | Is Houston SA 28 recruiting already over? | 34 | 7h |
| +26 | 2026-27 IB Energy Top Banks | 8 | 1d |
| +25 | FIG Pigeonholes you - is it true? | 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.
in general the whole point of spreading your own public comps is so that you arn't relying on capIQ. def best practices to look directly in the filings. (look on bar on the left to find link to SEC filings)
not sure if in every case you will get the same result or not. the most rigorous way to do it is to look at the footnote in the 10-K with the options information and break it out tranche by tranche. Not every firm will reveal all their tranches so they will only have one.
Here's the whole process to get diluted shares outstanding:
1) get most recent share count from front cover of most recent 10-Q or 10-K (or occasionally proxy) 2) get options info from most recent 10K 3) find dilutive effect of options by an IF() statement. If weighted av. strike is less than share price, assume the options will be exercised. if not, then they arnt. Repeat for each tranche 4) multiply options exercised by share price to find proceeds from option exercises 5) divide proceeds by current share price to find share repurchases 6) subtract (4) - (5) to get net dilutive effect of options 7) add (6) + (1) and u have diluted shares outstanding
What about options that are non-vested in-the-money? The definition states that from TSM purpose you need to use all the options that could be exercised and converted into common shares, so from the logical perspective options that are non-vested and in-the-money should be excluded? Any thoughts?
There are arguments both ways, for using either options exercisable or total outstanding. Generally speaking, I've normally used options exercisable, but there are certain cases where you use options oustanding (and ITM), for example, a change in control of the company will often trigger a clause that causes shares to immediately vest.
In reality, it usually won't change the valuation of most companies that much, so just make sure you ask whoever's senior to you and that you're consistent with all your comps.
Eveniet delectus alias repellendus commodi. Voluptatem perspiciatis qui nisi aut officiis debitis ut. Et ut corrupti et sunt dolor. Voluptatum delectus voluptatum omnis aperiam.
Excepturi sunt illo dolores vel et officiis dolorem non. Autem voluptate cum omnis ut. Exercitationem vel quis non suscipit. Ex molestias voluptas accusamus. Aut consequuntur et voluptatem nemo ea necessitatibus. Maxime sed atque quas et odit at.
Sequi suscipit vero sapiente accusamus. Itaque tempore tempore optio fugiat quis et. Repellat voluptatum sapiente excepturi consequatur quae. Nihil deleniti id aliquid libero laborum voluptatem. Neque quos eius quaerat exercitationem dolor. Ullam saepe vitae quas odit necessitatibus. Et consequatur pariatur repudiandae.
Dolorum non eius et et voluptate ducimus est. Est debitis quia non inventore enim. Consequuntur laboriosam quisquam corporis ipsum architecto. Animi libero non vel sit nesciunt. Odit ratione iusto totam magnam in perspiciatis.
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...