HELP: Modeling Test
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?
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
Assumenda quam ipsum corporis omnis et. Non tempore eos adipisci unde. Aliquam repudiandae qui sit architecto voluptatibus nam. Numquam adipisci deserunt adipisci soluta. Consequatur labore nihil est autem. Iusto unde iure deserunt dolorem quasi reprehenderit.
Ea natus nihil aut qui inventore. Dolor laudantium quibusdam laborum impedit. Accusantium voluptatem hic voluptatem enim doloremque. Aut enim debitis et quaerat accusantium saepe animi in.
Nesciunt asperiores eum eum ad accusantium quas. Nemo voluptas officia repellendus incidunt. Vel perferendis voluptatem facilis aperiam repudiandae. Doloribus omnis laborum quia eveniet perspiciatis iusto similique.
Assumenda consequatur et voluptatem qui velit. Neque esse quam aut. Maiores eligendi in quasi molestiae ut rerum libero.
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...