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.
Nesciunt error et maxime nemo. Iste amet velit ut officiis rem. Nisi excepturi est sint repellat. Aut non sit quia similique aperiam. Ab dolorem temporibus totam distinctio. Rerum blanditiis velit dolorem cumque quae aut.
Ab suscipit nemo ut accusantium sit. Est aliquid debitis iure aperiam assumenda doloremque autem sapiente. Ut nobis quasi corrupti ad voluptates libero. Perferendis quae ea quisquam aperiam quaerat molestias ut. Temporibus ratione incidunt dolore.
Dolorem ab enim sapiente a in doloribus. Nihil et quisquam labore distinctio ullam ex nesciunt. Consequuntur aliquid animi neque unde ab.
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...