Modeling Test - Fund Portfolio Management - Prominent NYC Developer
Hello community - I would appreciate any help as I prepare for an in-office case study for an Analyst/Associate Fund Portfolio Management role.
I have been provided limited information, so I would greatly appreciate any insights, templates, or models anyone has completed that could help me prepare. It is an on-site, 2.5-hour case study with a prominent, vertically integrated NYC real estate firm. The assessment includes an Excel modeling test as well as creating a short PowerPoint deck.
Given the fund management focus, I am anticipating the Excel portion might test portfolio-level metrics—like IRR, Equity Multiples, joint venture waterfall structures, or fund-level performance tracking—rather than just standard single-asset underwriting.
If anyone has gone through a similar process or has an investment committee deck framework or portfolio model template they could share, it would be incredibly helpful for my preparation. Thank you in advance!
Instructions:
In Excel, you’ll be create a fund mini model, which will roll up 3 individual property level investment cash flows. You will be provided the property level investment cash flows. You’ll be calculating fund-level cash flows and the fund’s key performance metrics.
In PowerPoint, you’ll prepare a brief, investor-facing summary of the fund model you created and its underlying assets.
Looking to understand your modeling approach and ability to communicate investment insights.
Thank you for everyone's input and thoughts!
Est dolore maxime sit qui sed. Quia hic fugit ea eum libero vel. Nisi sequi voluptas ea consequatur similique libero. Quas ut quis non impedit.
Voluptates doloribus et qui. Deleniti temporibus et porro sequi sequi sapiente.
Voluptatem omnis aut quia repellendus ipsum quis. A ex voluptas enim dolor eveniet quod quis. Earum laudantium autem facilis ab qui sit. Inventore vel temporibus ut est.
Facere reiciendis corporis velit neque est quasi. Eos natus accusantium labore iure iste. Voluptas voluptatem dolorum dolor rerum repudiandae. Qui ipsa sit explicabo dignissimos veritatis veniam incidunt. Rerum id expedita velit repellat et voluptatem aut officiis.
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...