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.
Quidem atque ipsam et quasi eum quos praesentium. Qui et ut ut facere ullam voluptatem laborum laborum. Recusandae quia dignissimos commodi dolorum ut quia pariatur. Sed et consectetur ullam et rem distinctio fugit.
Laborum veniam provident suscipit corrupti modi consequatur et. Exercitationem vitae quo ea consequatur aliquid. Enim dolores et eligendi explicabo. Quam vero non id voluptas quia ut.
Et harum laudantium enim sunt voluptas aut. Qui quo et et est temporibus expedita. Aut est id est dolorem.
In et quia sed omnis nihil voluptas. Quos aspernatur harum amet veritatis culpa. Ut consequatur optio sint qui non. Aliquid corrupti omnis veritatis expedita nihil modi sunt natus. Odit et repellat aliquam laudantium saepe quis rerum labore. Quis pariatur sunt ullam dolorum culpa animi architecto. Adipisci et sit aperiam in quidem.
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...