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

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 (67) $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
dosk17's picture
dosk17
98.9
6
CompBanker's picture
CompBanker
98.9
7
DrApeman's picture
DrApeman
98.9
8
GameTheory's picture
GameTheory
98.9
9
Betsy Massar's picture
Betsy Massar
98.9
10
Linda Abraham's picture
Linda Abraham
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...”