So I managed to make it past the first few rounds, and now I have a modeling test. I don't have work experience in this field, know a good amount but little modeling experience. I'm expecting it to be a 3 statement model and multiples valuation most likely. I really need resources, what are available? Do any of you have old tests I can study?
| +19 | Post HBS hedge fund opportunities | 4 | 1d |
| +17 | Best Non RX Sell Side seat for Opportunistic exits? | 6 | 11h |
| +13 | IB -> HF | 4 | 14h |
| +10 | MF to Smallish HF? | 2 | 3d |
| +10 | How would you transition a long-only book into L/S? | 1 | 1d |
| +8 | How to pivot into HF, L/S | 3 | 2d |
| +7 | Thoughts on situational awareness | 3 | 4d |
| +6 | How to Learn Programming? | 2 | 3d |
| +2 | hbs vs gsb | 3 | 1h |
| +1 | Hedge Fund from undergrad? | 3 | 4d |
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.
https://mergersandinquisitions.com/3-statement-model/
This is an "easier" test I feel like, but good to get started if you have never built a model
https://www.wallstreetmojo.com/financial-modeling-in-excel/
This is a little deeper
"Financial modeling for equity research analysts" - the book by gutenberg research is a really good resource for a deeper model (book includes excels)
Ultimately the best practice will be sitting down and building an integrated 3 statement model from scratch on a new company - just pull 4 10qs and you can model two years of historicals and then model out 2 years forward on quarterly basis.
Depending on the modeling test, it could be simpler where they just want to make sure you can fill in a few equations to tie working capital / balance sheet drivers on an existing model with some missing elements, or it could be the pod shop test where they give you the stack of reports and filings and ask for a model and view. If the latter, there are a few threads that discuss the best best strategies to succeed on those (whether its more important to just have a detailed rev and cost build to an earnings forecast, etc.)
Lastly there are the paid resources like BIWS and WSO that have modeling guides, but they are more or less similar to the above steps
Voluptatem voluptates sunt numquam. Error vitae voluptatem deserunt quaerat tempore.
Temporibus illum et necessitatibus ea perspiciatis voluptatum. Laboriosam magni dolores nulla nulla rerum.
Mollitia quam quos eligendi molestiae. Nulla earum quis unde aliquid eius. Ex tempore animi illum autem et ut.
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...