24h+24h Case study
Hi everyone,
Will face a case study next week for an experienced analyst role in London. Lost my job as an Investment associate (tiny firm doing dev/senior/affordable but received great training there) a couple of months ago so would be more than happy to take that gig in this interesting firm.
HR said I will have to return the excel model after 24 hours and then return a word doc + ppt after another 24h tranche.
They cover offices, resi, affordable housing, hotels... Pan-European scale. I'm obviously trained as an Investment associate but i've never faced such a thing.
I'm expecting (as it's not a 3-hour one):
Waterfall
Multiple leases
Potential refurb?
Sensitivities
Senior loan + refi
Basically a tough 3-hour with higher expectations... I've seen one from Clarion (Indus/Log), allowing a week and it was definitely a 3-hour type + presentation...
Question is, based on your experience what should I expect?
Any chance I could face multi Eq and/or multi Debt tranches?
Don't want to sound cocky but can't imagine being stuck on something when you have 24 hours...
Any tips on what I can do to really smash it? I'll keep it extremely flexible as they will want some changes during a live interview following the case study if it goes well... (Debt sizing options, expense recovery on/off button for each row, different growth index, stress-test, error-check tab...)
Thanks in advance for your return
ALSO HAPPY TO TRADE CASE STUDY - GOT SEVERAL ASSET-CLASSES AND DURATION, LOOKING FOR TOUGHEST ONES!
Henderson Park?
No but would love it too ahah!
1 thing driving me mad in case studies:
"Operating Partner Receives an asset management fee of 1.5% per annum of the initial equity invested"
Basically the GP getting a yearly AM fee.
Questions:
Where do you put this fee? Expense? Section on its own? Should it impact anything before FCF? LP Contrib? GP Distrib?
Would you model the fee to hit each 1st month of the year or each month/12?
Thanks
How much structuring have you done in your current role? Have you only been modelling hypothetical scenarios?
Assuming you were the Associate 3 who could
"built the whole new fund model from scratch, can model any type of asset-classes Acq or Debt, complex Eq&Debt structures"
If yes, given your experience on building a fund model and being involved with complex equity structures, the question you need to ask is where the AMA sits in the structure. That will answer how you treat it.
I was thinking:
AM fee (month) = 1.5%*Total Eq/12 (Can make it flexible: Eq% or Revenue%, accruing or not...)
I would imagine GP+LP are paying for this AM fee.
After my last row of property level CF I would have the beginning of my waterfall and would do:
CF Available for distribution
- GP Fees
= Net CF for distrib
Then "normal" waterfall I think...
Any advice?
When it comes to final count of Total Distrib I would do:
All waterfall tiers distrib for LP = X
All waterfall tiers distrib for GP = Y
GP Fees = Z
Total distrib = X+Y+Z
I don't think I'm double counting as I've assumed these fees as a contribution from GP+LP but adding these fees as a distrib only for GP!
Check:
The higher the fee the more my LP IRR is diluted
Sounds ok?
My group does a week long case study for our investments team.
The general gist is that you should model the deal/think through risks and mitigants and then make a recommendation whether to pursue or not. Essentially be less of an excel monkey and more of an investor.
My biggest piece of advice is to really think through/have backup for your assumptions (outside of the OM if possible) and be able to explain your model. I see kids get killed all the time because they underwrote using the Sponsor projections and they said "yes do the deal." Of course Sponsor numbers work, that isn't what we are asking. We are asking if we should invest in the deal and at what basis.
Ill be honest, we are less concerned if you picked a 6 cap or a 6.5 cap, and more concerned with the why and how you were thinking about it.
Omnis amet voluptatem placeat iusto quos corporis praesentium. Saepe ad maxime officiis quibusdam.
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...