Modeling at work vs modeling tests

Hey all, I work at a large multinational real estate investment firm and we have very well built out templates for the investments we focus on. The template model is fairly large and complex but I've come to understand it quite well over the past few months that I've been in the role. When modeling, I am usually not modeling from scratch. Rather, we are using the template and making adjustments / adding in functionality where needed. However, for modeling tests, I've noticed your expected to be able to complete a model from a blank excel file with no guidance or resources to glance at. For those who are analysts and have 1-2 YOE and are looking to make the transition, how did you prep for the tests? I don't feel as if my day job has prepared me well to absolutely murder these tests. Instead, I've come to understand our model very well, can work it in very easily, and have learned a lot about other key areas (JV's, loan docs, mitigating risk, etc). Modeling on the job is fairly different than opening up a blank excel sheet and putting something together in a few hours. If I had a modeling test that I was to complete over 2-3 days, I would easily pass. If I had to complete something in 2-4 hours, I am not as confident in my ability to knock it all out without any references, etc. I’m very familiar with excel and all of the main functions needed to complete a model.

14 Comments

Career Advancement Opportunities

July 2026 Investment Banking

  • Evercore 01 99.4%
  • Moelis & Company 01 98.9%
  • JPMorgan 01 98.3%
  • Guggenheim Partners 01 97.7%
  • Morgan Stanley 07 97.2%

Overall Employee Satisfaction

July 2026 Investment Banking

  • Moelis & Company No 99.4%
  • Evercore No 98.9%
  • Morgan Stanley 01 98.3%
  • Banco Santander 02 97.7%
  • BMO Capital Markets 12 97.2%

Professional Growth Opportunities

July 2026 Investment Banking

  • Evercore 01 99.4%
  • Moelis & Company 01 98.9%
  • Morgan Stanley 06 98.3%
  • Goldman Sachs 01 97.7%
  • JPMorgan 01 97.2%

Total Avg Compensation

July 2026 Investment Banking

  • Vice President (16) $429
  • Associates (46) $258
  • 3rd+ Year Analyst (8) $210
  • 2nd Year Analyst (22) $179
  • Intern/Summer Associate (14) $159
  • 1st Year Analyst (80) $150
  • Intern/Summer Analyst (73) $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
kanon's picture
kanon
99.0
4
BankonBanking's picture
BankonBanking
99.0
5
GameTheory's picture
GameTheory
98.9
6
dosk17's picture
dosk17
98.9
7
CompBanker's picture
CompBanker
98.9
8
DrApeman's picture
DrApeman
98.9
9
Betsy Massar's picture
Betsy Massar
98.9
10
Mimbs's picture
Mimbs
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...”