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.
| +34 | Where are free agents signing? | 14 | 9h |
| +31 | Uncertain of what To Do Next | 5 | 5d |
| +29 | Capital Restricted Developer | 4 | 13h |
| +28 | Laughable Job Posting | 7 | 16h |
| +14 | AvalonBay Equity Residential Merger discussion | 7 | 1h |
| +12 | Extremely Slow Ramp Up | 1 | 1h |
| +11 | In RE, what is the ONE software tool you couldn’t survive without? | 5 | 51m |
| +9 | Development Budget: use RENTABLE or GROSS BUILDABLE sf? | 3 | 1d |
| +6 | First-year REPE analyst comp check (London) | 1 | 6d |
| +6 | Dynex | 3 | 1h |
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.
Et assumenda aut voluptas iusto qui officiis ipsam. Est voluptatem nihil et et voluptatem. Consectetur quasi et asperiores dolorem quo culpa consequatur. Autem provident cum ea quibusdam rerum ratione reprehenderit.
Excepturi et excepturi dicta aliquam pariatur qui. Inventore earum aliquid eaque earum molestiae molestias eveniet. Occaecati et aut deserunt voluptatem eligendi. Porro assumenda perspiciatis tempore quia exercitationem itaque. Nostrum numquam voluptatem vero qui.
Maiores neque quam incidunt a beatae perspiciatis. Ad omnis nemo ipsam debitis perspiciatis. Ex et rem veniam libero laborum.
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...