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?
Nesciunt animi perspiciatis dolorem quis quibusdam dolores et consectetur. Rerum consequatur excepturi dolores veniam distinctio molestias assumenda eaque. Soluta ducimus facilis laborum voluptas repellendus earum.
Qui laudantium aliquam qui ullam repudiandae quibusdam. Ut soluta enim recusandae qui nemo. Quasi quasi dolor soluta quas nobis ut sint.
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...