Boutique 2nd round interview modeling test

Hey guys. I did a search but didn't really find what I was looking for. I know there are people who are gonna bag on me for that...but...

I have the interview on monday. I was notified today that it is going to involve an excel/modeling test that is going to be about 3 hrs long. I know that they are going to give me assumptions and its going to be a three statement model.\

now i've never done a three statement model and they know that.. that being said: what can i expect? someone thats been through one before, your input would be invaluable!

where can I go for a practice or sample?

Appreciate your guys' help!!

 
WSOHelper:
is this for full time? Sort of strange they'd ask you to do modeling if you never had experience before.

With that said, I've heard good things about BIWS so you should probably take a look at their modeling guide.

If he's never done modeling I doubt 2 days of BIWS will prepare him.

That being said this is extremely unusual that they are making you work on a model as part of an interview. Not even BB's do this for their FT analyst interviews, much less any boutique...

 
Best Response

I had to do a modeling test for a boutique a little while back. Pretty much the same situation as you...the bank knew I did not have prior IB modeling experience and I did not have much time to prepare (one week in my case).

My exam consisted of three years historical financial info for the three statements along with assumptions (revenue growth rate, COGS % revenue, inventory/AP/AR days outstanding, etc). I had to project 3 years of the three financial statements, along with building a simple DCF (did not have to do a WACC calculation, just used an assumption) and the top half of a LBO (transaction assumption, debt assumptions, sources and uses.... no debt and interest schedule, IRR or rebuilding any of the statements).

I did the BIWS Fundamental and it was great. There was nothing on the modeling exam that I was not prepared to do. If all you have to do is project the 3 statements out, there is no reason you can't learn this in 2 days if that is all you do this weekend (16-18 hours a day).

EDIT: I also used this website (see link below) for some additional info and practice, although I still highly recommend BIWS.

http://www.ibinterviewprep.com/Accounting___Modeling.html

 

Est consequuntur harum ratione est qui. Velit nam incidunt quas iste et. Omnis quam ut id minima et.

Career Advancement Opportunities

March 2024 Investment Banking

  • Jefferies & Company 02 99.4%
  • Goldman Sachs 19 98.8%
  • Harris Williams & Co. (++) 98.3%
  • Lazard Freres 02 97.7%
  • JPMorgan Chase 03 97.1%

Overall Employee Satisfaction

March 2024 Investment Banking

  • Harris Williams & Co. 18 99.4%
  • JPMorgan Chase 10 98.8%
  • Lazard Freres 05 98.3%
  • Morgan Stanley 07 97.7%
  • William Blair 03 97.1%

Professional Growth Opportunities

March 2024 Investment Banking

  • Lazard Freres 01 99.4%
  • Jefferies & Company 02 98.8%
  • Goldman Sachs 17 98.3%
  • Moelis & Company 07 97.7%
  • JPMorgan Chase 05 97.1%

Total Avg Compensation

March 2024 Investment Banking

  • Director/MD (5) $648
  • Vice President (19) $385
  • Associates (86) $261
  • 3rd+ Year Analyst (13) $181
  • Intern/Summer Associate (33) $170
  • 2nd Year Analyst (66) $168
  • 1st Year Analyst (202) $159
  • Intern/Summer Analyst (144) $101
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
BankonBanking's picture
BankonBanking
99.0
4
Betsy Massar's picture
Betsy Massar
99.0
5
dosk17's picture
dosk17
98.9
6
CompBanker's picture
CompBanker
98.9
7
kanon's picture
kanon
98.9
8
GameTheory's picture
GameTheory
98.9
9
DrApeman's picture
DrApeman
98.9
10
Jamoldo's picture
Jamoldo
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...”