Harrison Street Modelling Test - What to expect
Hi all,
I’ve got a second-round interview coming up for an Asset Management role at Harrison Street in their London office, and part of it is a 90-minute modelling test.
My background is more on the acquisitions side, so I’m comfortable with underwriting/deal modelling, but I’m trying to get a feel for how an asset management modelling test might differ.
Has anyone here done one for HS (or similar shops) before? What should I expect to be tested on? I’m guessing things like:
- Updating an existing model with new leasing assumptions / capex
- Running downside sensitivities
- Tracking actuals vs budget
- Potentially building or adjusting a cash flow for a hold/sell analysis
If anyone’s been through it and can share what to focus prep on (Excel skills, key formulas, typical AM scenarios, etc.), it would be massively appreciated.
Cheers!
Bump for visibility
you're closer to the execution of the waterfall/cash flow splits on the asset management side so I would get comfortable working in one or two different types of models.
typically, when acquisitions closes a deal the underwriting model is transitioned over to asset management which has a more detailed "property model" -- one key area the property model solves for is rolling up the dollars to the right entity. all this is to say that you want to make sure that the excel test you submit is fully dynamic, that a change in one input "here" correctly flows through and affects that output "there". i remember this was a key area i was evaluated on when i was interviewing for am roles.
Did you take the test? If so, what did it end up consisting of?
echo to the comment above - how was this model test?
Nihil harum rerum molestiae maiores a dolor deserunt. Voluptate veniam et ut eaque. In quia quaerat dolores.
Aut est maxime aspernatur autem non. Quia omnis saepe hic hic quasi doloremque voluptas sed. Soluta nobis optio consectetur ratione. Distinctio amet quasi facilis consequatur tempora quidem.
Voluptas et dolor aliquid laboriosam dolore incidunt. Non harum dolore ab. Quaerat enim velit qui voluptate natus consectetur ipsam. Illum at assumenda ut omnis assumenda. Sed sed maxime voluptas neque corrupti culpa. Ut veniam culpa ut quibusdam blanditiis numquam similique. Saepe cum ducimus nostrum culpa.
A unde occaecati laborum sint. Natus totam saepe dolores consequatur voluptatibus ratione soluta. Cum quia sed veritatis voluptatem provident molestias earum. Odio ut architecto sunt. Id odio praesentium suscipit doloremque voluptate excepturi.
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...