Can anyone review my modeling test answers? - Super Modelers Wanted

I am currently in a buyside sales role, wanting to break into acquisitions at REPE. Having a modeling test next week. Can somebody review my answer for this modeling test I found in the forum? (Or even better, show me your own?)

Link to file

I'm already in REPE but I'm basically a sales guy (RFP for funds) and I'm not sure if I'm in the right direction. Any pointers and suggestions would be appreciated.

I know my work is pretty amateur and there's got to be mistakes - the goal here is to finalize a mental template beforehand so my mind doesn't break down in my two-hour test. I'm also interested in what would be an "acceptable range" solution in this kind of two-hour test.

22 Comments
 

Hi all, seems like I had a modeling test after all. After the test and subsequent steps I have managed to get the offer! Thanks everyone for the tips and offers.

I’d like to give my thanks and thumbs up to EuReChimp as I tried to replicate his format during the test. This helped me a lot, and saved tons of time.

In comparison to the case study here, it was very similar except the below were some key differences. - Not development, but an existing office. - 5+ tenants with different expiration dates, must model downtime and free rent for new tenants. - New tenants will come in at market rent, where you will have to come up with the right figure based on the location and comps that were given. - 1 page IC memo/investment rationale on Word >> I bought a $200 REFM case study that had this and mimicked this - I added some sensitivities, especially as the market rent was open to different opinions. I laid out some upside and downside case and mentioned this in the IC memo, and got good feedback.

Thanks guys!

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.1%

Overall Employee Satisfaction

July 2026 Investment Banking

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

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.1%

Total Avg Compensation

July 2026 Investment Banking

  • Vice President (15) $434
  • Associates (46) $258
  • 3rd+ Year Analyst (8) $210
  • 2nd Year Analyst (22) $179
  • Intern/Summer Associate (13) $156
  • 1st Year Analyst (79) $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
kanon's picture
kanon
99.0
3
Secyh62's picture
Secyh62
99.0
4
BankonBanking's picture
BankonBanking
99.0
5
dosk17's picture
dosk17
98.9
6
Betsy Massar's picture
Betsy Massar
98.9
7
CompBanker's picture
CompBanker
98.9
8
GameTheory's picture
GameTheory
98.9
9
DrApeman's picture
DrApeman
98.9
10
bolo up's picture
bolo up
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...”