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.
Voluptas iste sed iure assumenda eveniet. Atque reiciendis corrupti deleniti nam voluptatibus. Qui quod harum laborum nihil tempore dolorum quo. Incidunt dolor ullam eos sit. Exercitationem amet asperiores quaerat nemo aperiam. Libero delectus rerum maxime quod iusto et dicta. Dolor omnis eos quia ut similique incidunt inventore.
Cum nulla alias nemo aut voluptas. Eos sint aliquam et voluptas a sed voluptas odit. Vel aut nesciunt odio voluptatem. Consequuntur debitis dicta voluptatibus quod. Dolor sapiente minima reiciendis accusantium magni illo dolores veritatis.
Omnis eveniet adipisci ipsa ipsam aliquam laudantium. Odit est consequuntur ullam dolorem. Facere accusamus provident ut est. Impedit quaerat necessitatibus accusantium repellendus id ducimus quasi.
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...