Hi guys, got a final round in 3 days and I really need to learn everything. Don't currently work in finance so studying up on accounting, statements, formulas.
Question is how do I learn the excel and financial modelling part in just 3 days? Any courses or tips? Where do I even start?
| +13 | Is Equity Research Dying - Where Are the Future Opportunites? | 4 | 1d |
| +10 | Associates who stuck around for > 5 years working for the same analyst. Why? | 4 | 6d |
| +9 | UBS ER SA27 Superday | 7 | 3w |
| +9 | Detailed Revenue and Cost Builds | 3 | 1w |
| +7 | Analyst with no coverage or ranking | 5 | 1w |
| +7 | Uiuc or Ross or UChicago | 8 | 2w |
| +1 | IB SA -> ER FT | 4 | 2w |
| 0 | Equity Research Rankings | 1 | 1w |
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.
Hi! How was your interview? Did you managed to find a course or materials for financial modelling?
Equity Research Interview Model Help (Originally Posted: 10/30/2016)
Hi guys,
I had an interview at a boutique equity research shop. The interview went well but they gave me a week to build a model on a company along with a one page write-up.
Can anyone review my model? I'm having a hard time getting the CF to match up to the change in cash in the balance sheet in my forecast period.
Thanks!!
How are you modeling the balance sheet? Are you making all of the adjustments to the income statement necessary to get the cash flow?
Not sure what income statements adjustments I should be making. My CF is linked to all the changes in the BS YoY + capex + d&a + net income
Urgent Interview: Help needed for Tech ER Model (Originally Posted: 09/27/2013)
Have an interview with a Tech Equity Research group on tuesday that will involve a modeling test. Does any one have an ER model for a tech company (yahoo, google, facebook, Amazon, ebay, etc.) that I can practice with over the weekend?
I did search the forum for similar posts, but examples/templates were all share offline via a PM.
Would really appreciate any help that you can offer. Thanks
Similar situation. Also interested.
guys - any help much appreciated.
I do not have a model that I can share.
However, models will be structured essentially the same way the company reports their financials. Tech will have some common charges (ie stock-based compensation, amortization of intangibles, restructuring, etc). Also, goog street convention for rev is adjusted - rev plus/or minus Motorola rev (can't remember)- tac (traffic acquisition costs).
Rev will grow based on industry future, operating expenses should remain roughly the same, and bottom line will be dependent on operating leverage and maybe some unforeseeable events. Hope this helps
Tks pktkid10 - appreciate the insights.
Equity Research Interview: Oil Modeling Help (Originally Posted: 02/20/2018)
Hi guys. I'm currently interviewing for an equity research role and they sent me an excel/modeling test. They basically gave me a bunch of data on well performance and want me to create some output (yea they were kind of vague). The overarching goal is to find the best operator. Note: best operator is different from best rock. So I can't just do 3-mo cumes or some simple variant of that. Any insights or suggestions are appreciated. Thanks in advance.
Dolorem quibusdam minus dicta non facere quam at. Facilis modi qui suscipit ab. Sed consequatur eligendi odit quis minima nisi consequuntur. Est quisquam fugiat illo doloribus temporibus debitis corporis. Eligendi numquam totam facilis eveniet dolor illum ea. Eos et architecto corrupti rerum corporis aliquid optio. Nemo aut veniam est et nulla voluptas animi.
Dolor occaecati nulla neque reprehenderit laboriosam. Consectetur sed quaerat neque at velit. Asperiores dolor nam quibusdam exercitationem qui in. A nisi et numquam fugit.
Accusamus soluta repellat et nihil atque. Reiciendis qui optio molestiae. Et est nesciunt iste molestiae exercitationem reprehenderit.
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...