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!

 

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

 

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?

 
Most Helpful

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.

Career Advancement Opportunities

April 2024 Investment Banking

  • Jefferies & Company 02 99.4%
  • Goldman Sachs 19 98.8%
  • Harris Williams & Co. New 98.3%
  • Lazard Freres 02 97.7%
  • JPMorgan Chase 03 97.1%

Overall Employee Satisfaction

April 2024 Investment Banking

  • Harris Williams & Co. 18 99.4%
  • JPMorgan Chase 10 98.8%
  • Lazard Freres 05 98.3%
  • Morgan Stanley 07 97.7%
  • William Blair 03 97.1%

Professional Growth Opportunities

April 2024 Investment Banking

  • Lazard Freres 01 99.4%
  • Jefferies & Company 02 98.8%
  • Goldman Sachs 17 98.3%
  • Moelis & Company 07 97.7%
  • JPMorgan Chase 05 97.1%

Total Avg Compensation

April 2024 Investment Banking

  • Director/MD (5) $648
  • Vice President (19) $385
  • Associates (87) $260
  • 3rd+ Year Analyst (14) $181
  • Intern/Summer Associate (33) $170
  • 2nd Year Analyst (66) $168
  • 1st Year Analyst (205) $159
  • Intern/Summer Analyst (146) $101
notes
16 IB Interviews Notes

“... there’s no excuse to not take advantage of the resources out there available to you. Best value for your $ are the...”

Leaderboard

1
redever's picture
redever
99.2
2
Secyh62's picture
Secyh62
99.0
3
BankonBanking's picture
BankonBanking
99.0
4
Betsy Massar's picture
Betsy Massar
99.0
5
CompBanker's picture
CompBanker
98.9
6
GameTheory's picture
GameTheory
98.9
7
kanon's picture
kanon
98.9
8
dosk17's picture
dosk17
98.9
9
Linda Abraham's picture
Linda Abraham
98.8
10
DrApeman's picture
DrApeman
98.8
success
From 10 rejections to 1 dream investment banking internship

“... I believe it was the single biggest reason why I ended up with an offer...”