PE Secondaries- Excel Case Study
Hi I have a case study soon for a graduate role in Secondaries, The firm mainly does GP-Led transactions and a few LP-led transactions, I was curious how can I prep for such a case study is it primarily DCF to asses the LPs stake or would you use an LBO any advise would be helpful thanks.
edit: I believe I only have 1 hour 30 to complete it.
Comps are the main form of valuation for each company. If the Fund owns 10% of a company then take 10% of the equity value at exit. Say for example $10M EBITDA today grows to $20M EBITDA by exit, apply a TEV/EBITDA multiple based on the comp set you built, remove the net debt (which will have been paid down with your EBITDA to FCF calculation), then take 10% of the remaining equity. This is the distribution that gets paid to the fund. You do this for each company. DCF is almost never used. 2) The management fees and carry are removed on a fund level for modeling purposes, so all company cash flows get aggregated first. Take out 1.5% per year for management fees, then 20% of any profit. If $100 was paid-in, and the return from all companies is $150 over the next 2 years, then after fees you have $147. Remove 20% of the $47, and you're left with $137.6 to the fund. 3) It depends really. Use a floor of 15% and 1.5x. Your investor will not want lower on either. So if you have a fund that returns everything next year, generating a ridiculously high IRR but a 1.2x, its not a good deal. Or a longer duration deal generates a 1.7x over 10 years, but only a 10%; would be a tough deal. Secondaries are unique in that you're buying pretty mature assets, so the IRRs tend to be pretty high; but without a solid multiple to go with it, its a tough investment. IRR almost always clears the hurdle, so focus tends to be on the multiple. If the fund generates $150 to me, then I pay $100 for it, getting me the 1.5x. Keep in mind that there is an extra layer of fees in the Secondary as well, usually 1% and 10%. The 1.5x and 15% floor is after those fees, so returns coming into the Secondary are usually 1.6x and ~18%.
Wow this is incredibly comprehensive I will definitely use this to prep thank you
If these are mature assets then wouldn't the multiples be high but IRR low?
Research how secondaries cut the J curve. Early realisations of upside = higher IRR , but can result in lower MOICs since the asset is already mature.
Hey bud - would be really grateful if you could DM me what the case study entailed - prepping for a case study myself and have no clue what to expect. Thanks champ
Could I PM you? I’m in an identical boat
OP how did it go? I'm in the same boat.
Could I PM you? Just received a 3-hour modeling test invitation for a Secondaries fund and looking for any previous example on how this looks like. Thank you!!!
Same boat, would love the help too.
OP how did it go? I’m in the same boat.
Unde assumenda reiciendis et id omnis incidunt explicabo. Labore alias iste ut. Et vitae libero sit sit odio at non. Quis quidem est deserunt ullam atque illum aut. Commodi neque quia eius quis aut quos sint.
Est natus voluptatibus alias. Repellat dignissimos illum enim perspiciatis incidunt deleniti ea. Officia architecto occaecati natus hic voluptatem esse quis. Dolores commodi veritatis voluptates odio qui eos iusto.
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...