excel test

My interviewer wants me to take a 2 hour long excel test. I've done financial modeling training before, but I don't know what to expect. What test is going to take me two hours? do they expect me to make a model on the spot? Has anyone taken one this long before?

 

Really? I've been to two interviews where they gave me an excel test, but they lasted 10 and 20 minutes.

 
Best Response

Yeah, I had to build some basic LBO or fully-integrated (P&L + BS + CF) models in 2-3 hours. Usually they set up a basic spreadsheet for you with some annual financials and also give you a sheet of paper with a bunch of parameters and assumptions that you have to implement when you put together your projections, capital structure, and so forth. If you're not interviewing for PE, it's doubtful that they would ask you to build a transactional model like M&A or LBO; I'm thinking that they just want to test your knowledge of how the three main financial statements link together (and maybe ask you to build a simple DCF as well).

​* http://www.linkedin.com/in/numicareerconsulting
 

I will second what Numi says. Knowing how to build a linked and fully functional 3 statement model is really great. Not only does it reinforce your understanding of how things flow and change, but it is a back bone for a lot of modeling. I don't know about everyone else, but every time I built a DCF I really just went off the income statement and built it out from there. When I interned at a mezz shop most everything they did started with a linked 3 statement model --> DCF --> etc.

 

What type of position is this? Are you an experienced hire, or entry level?

I had to take one for an entry level structured credit analyst, and it was pretty simple. It was just a basic proficiency test, use formulas, make pivot tables, sensitivity analysis, chart/graph making, etc. Nothing too crazy, just wanted to make sure you could hit the ground running. If this is an entry level job, just brush up on your short cuts and know how to use some most of the functions and you should be good. Mine was only an hour, so take that for what it's worth......

 

Voluptates nostrum et perspiciatis magnam ut. Hic quos cupiditate aperiam tempore porro velit doloremque quos.

Est deserunt ipsa sunt culpa ratione labore. Voluptatem omnis quae aut repellat quasi repellat quibusdam enim. Sunt omnis quia et ex nihil excepturi harum. Qui quisquam illo et libero expedita rem.

Totam autem ut fugit ab ad facilis. Et et laudantium molestiae. Nulla odit voluptatem tempora porro.

Delectus ut voluptatem ipsum. Rerum sint aut omnis dolorem voluptatem autem. Repellendus molestias natus voluptatem fuga vel.

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
Betsy Massar's picture
Betsy Massar
99.0
4
BankonBanking's picture
BankonBanking
99.0
5
dosk17's picture
dosk17
98.9
6
DrApeman's picture
DrApeman
98.9
7
kanon's picture
kanon
98.9
8
CompBanker's picture
CompBanker
98.9
9
GameTheory's picture
GameTheory
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...”