10h case study/modeling test?

All,

I have a 10h test coming up at a large real estate PE group. Has anyone seen a test in the 10-15 hour range? Group does direct equity acquisitions.

I expect it to be a single asset acquisition (multifamily I guess most likely?) with a high level of granularity in the model, and a deck with market info, comps, etc.

Still, 10h feels like too much time to get all of that done - I think that is doable in 5h with a few years of transactional experience under your belt. Not sure what else could be involved. Any experience/ideas welcome!

 

When you say direct equity acquisitions, are you meaning that they take down the whole equity portion of the deal? Therefore, there is no waterfall structure?

I have seen this type of format, model and then a deck 5 to 10 slides long...

Executive Summary, IC Request, Market Research, Property Details Financials (Capitalization & Returns).

Would pay attention to formatting and ease auditing in the model (less tabs = better). Simple flexibility over complex formulas. Articulate concisely on the memo and show basic/above average formatting skills. 

Feel free to DM me the firm and I can tell you whether i've heard anything / have done it myself

 
Most Helpful

While I have no clue who the company is, I’ll add one thought. Unless you can do it on a weekend, you have to take a day off for this. It’s extremely rude (in my opinion) of the company to even request this. It actually says a lot more about the company than you may realize - if they are asking you to take a ten hour test just to get the job - how bad are the hours going to be, and more importantly, will they have any respect for your time (and life)? Having you take a ten hour test-the answer is no. 
 

I’ll add, if they give this to you and give you 3-5 days to do this, I might feel otherwise. 

 

Point taken, but I'll add that they let me choose whatever 10h window I wanted in the upcoming week. Could have picked a weekend day presumably.

One way to spin this is that it could be more like a 6h assignment (not unusual) and they're giving extra time to accommodate for current-job responsibilities. Maybe thats me being an optimist.

 

An institutional shop I once interviewed for, called me at 5pm on a Friday that I moved to the final round and needed to complete a case study and come in to present the following Monday morning at 10am. This was during quarter end and we had our presentation to RE head that morning and told them it was too short notice for me. They basically told me to F off.

 

Dude..WHAT? 10 hours is egregious. 

Based on your title, it sounds like you've probably got a few years of work under your belt, so you're most likely a good modeler. The company knows this, and they're just trying to confirm. A model test shouldn't take more than like 3-4 hours, if you do it in one sitting. I wonder if you could push back and just say (in a professional way), "Look at my past experience and companies -- do you really think I got this far without knowing how to model?"

EDIT: Clarity

 

We make it known to our candidates how thankful we are they spend 2 hours to do a test for us. This is ridiculous and from a 3rd party POV, is borderline disrespectful for the candidates time.

With all my years in this industry, I cannot think of any test subject that'd take you 10 hours to do - the point here is show your understanding of the key terms/subject matters of RE. Even if you go full blown development model with interest reserve and complicated JV structure, that should take 2-3, top. You're not editing anything to make it look pretty. It's a chance to show case your technical ability, not a pitch to investors.

I'd beware with whatever company this is to be honest.

 

Maybe the ten hours is just to give you time or something, like a buffer in case something comes up during your window. I can’t imagine they are asking you to answer and model like three different cases at three hours each.

 

Do they actually time you for the 10 hour window? You say 10-15 hour range so wasn't certain.

I was given a case study where I was sent an OM, ARGUS file and asked to come up with a valuation and an IC deck, but I was given 3-5 days to do it as they knew I had a relatively demanding full-time gig. 

Agreed with other posters that a timed 10-hour test seems quite disrespectful. 

 

Enim quis occaecati repudiandae sit voluptatibus et sed. Eaque et dolorem minima autem voluptatem. Culpa iure voluptatum ab id iusto.

Fugit adipisci nam eaque aut explicabo. Iure qui et deserunt nobis consectetur aut quo. Veritatis placeat dolorem quis beatae porro fugiat. Accusantium eius repellat unde reprehenderit nam consequuntur. Id id atque dolor qui impedit qui molestias. Error cum eos vel accusamus eveniet ut.

At repellendus est officiis odio quod consequatur ab neque. Libero sit nesciunt vitae rerum. Quia qui necessitatibus eos reprehenderit. Sed fuga consequuntur dolor.

Unde illo dolore quibusdam et et consectetur. Delectus ut eveniet error placeat est dolores qui. Optio repudiandae commodi impedit qui minus repudiandae mollitia ut. Et quo ratione suscipit dignissimos ea cum.

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...”