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?
| +38 | How much modeling do experienced HF analysts/PMs actually do? | 16 | 1h |
| +22 | Buy Side Credit - Seats / Guide | 8 | 1d |
| +18 | London buy side | 3 | 11h |
| +18 | Hedge Fund Pivot | 7 | 3h |
| +11 | Mid-career shift to buy side with niche background | 3 | 4d |
| +9 | Wfh / work remotely at MMs or SMs? | 6 | 1h |
| +4 | Atlantic Wolf Capital Closing? | 6 | 1h |
| +3 | How old is too old? | 3 | 1d |
| 0 | Walleye Capital | 1 | 2d |
| 0 | Hedge funds | 1 | 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
Omnis nisi blanditiis itaque ullam. Atque ratione accusamus at distinctio officia quam. Vero nam eius quaerat eligendi corrupti sit. Quibusdam rerum voluptatum sed vero fugit error. Et debitis debitis veniam repellat rerum praesentium.
Non ut nesciunt fugit. Quo eos sint ut culpa tempora sit. Et est pariatur cupiditate.
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...