Does anyone have a template for a waterfall in a deal where there are multiple LP’s in the same deal, each of whom have their own distribution schedule?
The part I’m hung up on is how to bifurcate between the deal-level distributions at the top.
Any insight is appreciated.
| +48 | Being asked to stay behind and train my replacement | 14 | 3d | |
| +45 | New Comp Database - Google Form (Now with Data Validation) | 24 | 8h | |
| +30 | What does REPE actually do? | 12 | 1d | |
| +28 | Leave brokerage to be GP | 3 | 5s | |
| +24 | Seeking Career Guidance in Real Estate Development Post-Graduation | 3 | 11h | |
| +24 | Public Homebuilders | 9 | 1d | |
| +22 | REPE/Development GPA | 15 | 1d | |
| +17 | MSRE/MSRED with no RE experience; Naive to think I’ll land a job afterwards? | 4 | 3d | |
| +16 | UC Berkeley MRED vs Columbia MSRED? | 2 | 5d | |
| +15 | Hospitality Finance - Perks? | 3 | 6d |
Career Resources
Get instant access to lessons taught by experienced private equity pros and bulge bracket investment bankers including financial statement modeling, DCF, M&A, LBO, Comps and Excel Modeling.
You would need to build out separate waterfalls (or at least sub-sections in each tier) for each LP, and separate inputs for each of their respective distribution structures.
The property level distributions would just be allocated pro rata to each LP, any LP expenses would be deducted from there, and the remaining distributable cash flow would be run through the waterfall.
EDIT: If there is also a deal-level promote above all the individual LP waterfall structures, any LP with promotes further down the waterfall would need to be credited for their pro rata share paid at the deal-level.
Meant to reply to your response directly. See my comment below.
Right, I built out the subsections in each tier. But the question is, how do you pro-ratably allocate the property level distributions to each LP? If the Sponsor also puts up, say, 10% of the equity.
For example:
property level distributions: 50m
LP 1: 60%
LP 2: 30%
GP: 10%
You’re suggesting LP1’s waterfall starts with 30m (60% x 50m) to flow through? That’s undercounting though, because we have to allocate some of the GP 10% contribution somewhere.
It wouldn't be undercounting, the GP would just receive a direct 10% pro rata share at the property level if they put up 10% of the equity.
$50M distributions:
LP1 - 50*0.6 = $30M
LP2 - 50*0.3 = $15M
GP - 50*0.1 = $5M
$50M total distributions. From there, the GP's $5M doesn't need to flow through anything, and the LP shares flow through their respective waterfalls, net of LP expenses.
If the GP has contributed an equity stake, they get their pro rata share of property level distributions.
Assuming both JVs are 90-10, then you allocate a certain % of the GP to each. Gross up the 60% and 30% by .9 and allocate the deal level cash flow 66.66% and 33.33% respectively then feed them into your two different waterfalls. GP has 10% of each deal and 10% of the overall deal.
Dicta perspiciatis nihil delectus commodi dignissimos sint numquam. Sint labore et sed earum quidem. Iure quo ipsum eos nesciunt quia.
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...