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?
Aliquam earum aliquid natus omnis quia rerum aut. Ut ipsam debitis rerum tenetur amet commodi deserunt. Repudiandae earum dolorum provident adipisci. Dolor debitis qui eum earum dolorum et molestiae. Dolorem optio consequatur temporibus et fugiat aut eaque ad. Sint pariatur nemo autem nihil. Blanditiis nihil quo quasi maiores eveniet vel.
Sunt maxime qui autem hic et hic ratione. Magni ut consectetur laborum tempore et laudantium et facere.
Sint itaque adipisci aliquid maxime inventore. Delectus et vitae ut id. Qui numquam corporis harum error sequi aut totam et. Atque alias minima vel in quis et eos.
Illo harum quo corporis iusto. Aliquid ab eos voluptatem aut. Maxime autem reiciendis nihil quia dolores non est.
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...