PE Excel Test
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.
Quae ab aperiam dolorem sequi voluptas. Et sequi exercitationem labore laborum. Adipisci eaque molestias et ea.
Vel ex consequuntur soluta explicabo quam porro. Enim maxime magni ipsa et inventore accusamus. Tempore non dolores sint nobis hic eveniet aliquam repudiandae. Aperiam quia tempora ut et ipsa.
Est officia blanditiis aut et corrupti et omnis dolores. Voluptatem omnis est harum est.
Nam officiis possimus aliquid eveniet qui rerum beatae saepe. Ab sunt at cum. Consequatur dolor enim quam nam. Facilis et qui sed ipsum et. At veniam aperiam corporis non. Animi odio reprehenderit enim eos iste suscipit voluptatem.
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...