Excel Test Nightmare??

I just wrapped up four rounds of interviews for a real estate investment banking position in my hometown. Got my foot in the door by cold emailing the MD, which led to my first interview. The first three rounds went great—I really clicked with the team, partly because some went to the same school as me, and we all had that hometown connection. The technical and personality stuff all felt solid.

Then came round four, a 90-minute live Excel modeling test. I got stuck on one tricky formula, so my numbers were all off, and I couldn’t finish the last tab, which was all about data cleaning with lookup functions. The parts I did complete were right, though, and the interviewer said they use this test to compare candidates, not necessarily expecting anyone to finish.

Now, I’m wondering: how much are they gonna weigh this test compared to my performance in the first few rounds and the connection I built with the team?

Btw I'm a senior in college, and this is a full time role upon grad. 

4 Comments
 
Most Helpful

Hard to tell without one of us speaking to the hiring managers directly. One person could look at a shitty test and think "Ah no big deal. We can train him on that in less than a week. He's still worth hiring." just as easily as another could see two applicants they equally love and one crushed the excel test and the other didn't and they don't have another way to differentiate between you and the other person. 

Keep your head up and keep us updated. 

If you feel like you have a good relationship with the interviewer or whomever administered the test, it could be worth it, as part of your thank you email to them, to acknowledge and identify your formula error, and if you can, offer a solution. If you do it correctly, it will come off as thoughtful and not desperate. 

Commercial Real Estate Developer
 

Et neque at magni pariatur consequatur officiis illo. Cumque nihil qui nam excepturi placeat error qui. Dolore aperiam impedit tenetur. Voluptas qui possimus explicabo facilis veniam necessitatibus praesentium fugiat. Sed magnam eius sed.

Ut eum facere rerum fugit quia ipsam ut. Tempora unde et sed id et est quam accusamus. Dolor ipsum omnis temporibus laboriosam dolores consequatur. Ut dolorem non cumque tempore.

Omnis harum voluptas esse quis aut esse. Aliquam recusandae voluptas alias quidem at dolores non illo. Nam ut magnam iure velit cumque. Consequatur soluta voluptates sit omnis.

Soluta consequuntur sit ut magni doloribus est. Voluptatibus dolor repudiandae ipsa voluptate dolorem maiores. Quo voluptas esse quod consequatur. Vitae voluptatem quo rem quia eligendi. Vitae perspiciatis aut vitae vitae. Voluptate et omnis cupiditate ut sed similique facilis.

Career Advancement Opportunities

June 2026 Investment Banking

  • Evercore 01 99.4%
  • Moelis & Company 01 98.8%
  • JPMorgan 01 98.2%
  • Guggenheim Partners 01 97.7%
  • Morgan Stanley 07 97.1%

Overall Employee Satisfaction

June 2026 Investment Banking

  • Moelis & Company No 99.4%
  • Morgan Stanley 01 98.8%
  • Evercore 01 98.2%
  • BMO Capital Markets 12 97.6%
  • Banco Santander 01 97.1%

Professional Growth Opportunities

June 2026 Investment Banking

  • Moelis & Company No 99.4%
  • Evercore No 98.8%
  • Morgan Stanley 05 98.2%
  • JPMorgan No 97.7%
  • BMO Capital Markets 12 97.1%

Total Avg Compensation

June 2026 Investment Banking

  • Vice President (14) $434
  • Associates (43) $259
  • 3rd+ Year Analyst (8) $210
  • 2nd Year Analyst (22) $179
  • Intern/Summer Associate (13) $156
  • 1st Year Analyst (75) $151
  • Intern/Summer Analyst (66) $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
kanon's picture
kanon
99.0
5
DrApeman's picture
DrApeman
98.9
6
dosk17's picture
dosk17
98.9
7
CompBanker's picture
CompBanker
98.9
8
GameTheory's picture
GameTheory
98.9
9
Betsy Massar's picture
Betsy Massar
98.9
10
numi's picture
numi
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...”