Hey guys, I'm working on a Comps model and I got stuck here. I've done one Comps before but it seems to me that I've done an easier version...
Please see the attached images and files. How am I gonna find those inputs? Please, thank you sooooo much !
| Attachment | Size |
|---|---|
| capture_2.png 7.65 KB | 7.65 KB |
| capture_3.png 24.97 KB | 24.97 KB |
| capture_1.png 13.15 KB | 13.15 KB |
| +166 | Return Rates For Interns Are Falling? | 51 | 1h |
| +129 | UBS Americas IB: The Kids’ Table of Wall Street | 16 | 14h |
| +96 | I am a drunk MD AMA | 36 | 10h |
| +74 | London IB BB is a challenge | 41 | 10h |
| +62 | VP Lifestyle at Top BB Coverage Groups | 39 | 20h |
| +56 | An Outsider’s View of RX Banking Out of College | 7 | 3m |
| +48 | SharePoint makes IB hours HELL | 15 | 2d |
| +46 | KISSED MY VP… HELP!!! | 11 | 3m |
| +42 | momentum of Rx groups | 16 | 4h |
| +39 | Fired during interview | 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.
Nobody answered because there are some basic accounting questions involved. I won't do this for you but here are some ideas to get you started.
In order;
Indebtedness. (hint: look at calculating a company's net debt for an example of where to start)
Options/Warrants. You'll need to use your judgement and the timeframe of whatever the transaction you're working on to find out if/when any of the warrants or options can be exercised, (hint: when might you want to find fully diluted shares outstanding or percentage held by insiders?)
the opex adjustments can be done after the fact if you've already got a three statement model and annual reports or you can project an income statement and cash flows to build a pro forma list if you're working from a quarterly report, (hint: if this is homework you probably want to think about how you find gross margin and net income).
Hi, thank you so much for your answer ! I'm a Maths major and honestly neither opex adjustments nor Warrants/Options make sense to me... I have only done some simplified comparable analysis so far. This is another project that's for a company's final interview; they told me they will probably still give me the internship position if I can't finish this project, but still I need to submit it in 3 days. Are there any books maybe you can recommend ? Thanks again.
Ducimus voluptas vel qui distinctio blanditiis et. Est non ut est. Maxime ut excepturi nemo quia explicabo sapiente nobis. Repellendus qui labore iure nulla ea ea quod. Aut tempore aut omnis harum ex. Atque numquam sed doloremque dolorem. Impedit voluptates architecto voluptatum quibusdam at.
Qui inventore quos deserunt dolore cum occaecati magni nobis. Provident similique ipsam et qui occaecati consectetur ab. Alias est quia ut consequatur explicabo voluptas dolore autem.
Aliquid ipsa ut in nihil nihil rerum. Voluptas natus beatae officiis aut voluptatem. Sed ratione corrupti fuga rerum voluptatibus. A ducimus consequatur quis iusto.
Sit nisi occaecati eos. Cum rerum optio vitae odio. Harum consequatur amet ut praesentium ullam ut repellendus impedit.
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...