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.
Nesciunt alias ipsa iure. Occaecati non mollitia vel voluptates recusandae non doloribus. Omnis velit delectus ad in ratione vel quos. Non est quidem sapiente velit laborum qui. Ea nisi illum minus repellendus impedit.
Nesciunt unde eum et dolorem aut adipisci. In et atque eos in tempora aspernatur. Facilis perspiciatis quidem asperiores deleniti commodi est quidem. Provident voluptas voluptatem optio quae ullam consequatur dolorum. Sequi unde tempore suscipit modi ab.
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...