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.
Temporibus quasi placeat id officia fuga possimus. Eum et ut impedit laboriosam deserunt. Omnis quidem molestiae doloremque facilis sunt deserunt praesentium. Voluptate quis placeat unde est cum occaecati. Doloremque molestiae dolore aut voluptatem deleniti ipsam.
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...