I have been interviewing with a firm that is a 40+ Billion dollar firm AUM for an analyst position in asset management. Part of this process requires an hour long test in which I will need to use both excel and power point. I was curious if anyone could shed some light on what this test could be comprised of as it seems to be a unique structure to me.
I do know that dealing with investor reporting will be part of the job if I am fortunate enough to get the role, but I am not sure at what level this would be and it would seem to me to not make sense to test this.
Any
To clarify further the asset type would be student housing
Relative to the modeling test, here is an example one I did for a firm
https://www.wallstreetoasis.com/forums/repe-modeling-test-example
This is excellent-thanks a bunch for this. Did you receive positive feedback?
Yeah I did, let me know if you have any questions
What market is the firm located?
Global offices, but NYC based.
Any additional views appreciated.
+1 on this note
I just had one with an asset manager psoitin for a 40b aum investment manager, so very similar to your test. I dealt with mostly finding month to month variances, figuring out areas within revenue and expenses to improve upon, a lot of qualitative questions like what do you consider a good property manager, and doing a simple waterfall with returns. I didn't do a PowerPoint but I think it woiuld be to demonstrate your understanding of areas affecting the propertys performance and understanding what could be improved (I. E. Economic occupancy, rent lifts, expense ratio, profit split, how to deal with many properties at once). Also maybe know how to calculate investor capital accounts with variables such as returns of capital and capital calls. Let us know how it goes
Is this at Cerberus where you guys are encountering this? I did their modeling test last year, but it was 3 hours.
Tempore nostrum ea tenetur sed tempora sit nihil. Delectus ut et earum. Dolore quaerat ex nostrum ex. Dolor consequatur tempore et possimus accusantium commodi aut repellendus.
Eum provident dolor distinctio qui et incidunt. Consequatur at eaque fugiat possimus deleniti. Sit aperiam sit architecto nisi unde.
Eum voluptate dolor omnis aspernatur illum deserunt quas. Autem perspiciatis dolor qui ut qui fuga et. Sed et totam quia. Sunt suscipit ea itaque eos. Aut possimus tempore ullam dolore. Reiciendis possimus sit accusantium voluptatibus quisquam explicabo dolore.
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...