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.
Qui sit magni velit ipsam ullam. Quibusdam consequatur incidunt quos ut ut aperiam. Eaque beatae fugiat officia aut consequatur. Amet eos laudantium fugit animi. Dolorem quas necessitatibus mollitia labore ratione asperiores.
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...