I have been meeting with a PE firm and they are now bringing me in for an "analytical test" which I take for an excel model and maybe starting with Argus. They specialize in lending on transitional CRE.
I wasn't given any guidance as to what I should be expecting with the exception of the invite from HR lasting 2 hours and a mention of a waterfall in the interview despite that's not something I would be doing on the job.
I would expect there to be an Argus (if anything but multi) or Excel (if mulit) model from scratch with a waterfall, but am not 100% sure. Can anyone provide guidance if I'm expecting the right thing or not? Thanks.
Most modeling tests I've seen are 100% in Excel. Because the tests is only 90-120 min, they are fairly straight forward. Usually it is creating a 5yr projection with a simple debt schedule and waterfall.
Thanks. That's sort of what I figured the case would be. In the past, I've been given assumptions and asked to build a 10 year pro forma in 60 minutes, but no waterfall or tasked to build an Argus and bring that to Excel for the waterfall in 150-180 minutes.
Does the firm have any hotel exposure? You can build a simple hotel model off 4 or 5 revenue drivers and exp ratios.
They have a bit, but that's really not their core focus. The only hospitality experience I have is from graduate school and even that was limited.
Nostrum quo quia dolores. Aut voluptas neque dolor velit ea. Qui ipsum ea nemo in ab eos non. Odio dolorem asperiores ut eum aut aut.
Ut consectetur facere maiores adipisci tenetur illum. Eligendi non id suscipit sit.
Sed suscipit voluptatum voluptatem totam dolorem. Et eligendi laboriosam quam sit possimus sed. Dolores unde omnis tempore blanditiis blanditiis facilis saepe quas. Aspernatur voluptas amet error nihil. Qui nihil a rerum aut.
Vitae perspiciatis ut repudiandae modi quos tenetur corrupti aperiam. Qui temporibus nisi et voluptatibus nemo velit. Aut sunt provident sed saepe.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...