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?

 
Most Helpful

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

 

Voluptas maiores laudantium ducimus quia debitis velit ipsam. Consequuntur praesentium quas perspiciatis. Totam unde quasi exercitationem omnis qui reprehenderit atque.

Nam voluptatem vero veniam nemo et provident adipisci. Quia quisquam consequatur omnis est necessitatibus. Repellat quisquam qui officiis. Consequuntur eos est iste culpa non ut omnis.

Career Advancement Opportunities

April 2024 Hedge Fund

  • Point72 98.9%
  • D.E. Shaw 97.9%
  • Citadel Investment Group 96.8%
  • Magnetar Capital 95.8%
  • AQR Capital Management 94.7%

Overall Employee Satisfaction

April 2024 Hedge Fund

  • Magnetar Capital 98.9%
  • D.E. Shaw 97.8%
  • Blackstone Group 96.8%
  • Two Sigma Investments 95.7%
  • Citadel Investment Group 94.6%

Professional Growth Opportunities

April 2024 Hedge Fund

  • AQR Capital Management 99.0%
  • Point72 97.9%
  • D.E. Shaw 96.9%
  • Magnetar Capital 95.8%
  • Citadel Investment Group 94.8%

Total Avg Compensation

April 2024 Hedge Fund

  • Portfolio Manager (9) $1,648
  • Vice President (23) $474
  • Director/MD (12) $423
  • NA (6) $322
  • 3rd+ Year Associate (24) $287
  • Manager (4) $282
  • Engineer/Quant (71) $274
  • 2nd Year Associate (30) $251
  • 1st Year Associate (73) $190
  • Analysts (225) $179
  • Intern/Summer Associate (22) $131
  • Junior Trader (5) $102
  • Intern/Summer Analyst (250) $85
notes
16 IB Interviews Notes

“... there’s no excuse to not take advantage of the resources out there available to you. Best value for your $ are the...”

Leaderboard

1
redever's picture
redever
99.2
2
Secyh62's picture
Secyh62
99.0
3
Betsy Massar's picture
Betsy Massar
99.0
4
BankonBanking's picture
BankonBanking
99.0
5
kanon's picture
kanon
98.9
6
CompBanker's picture
CompBanker
98.9
7
dosk17's picture
dosk17
98.9
8
GameTheory's picture
GameTheory
98.9
9
Jamoldo's picture
Jamoldo
98.8
10
bolo up's picture
bolo up
98.8
success
From 10 rejections to 1 dream investment banking internship

“... I believe it was the single biggest reason why I ended up with an offer...”