Can someone please refer me to an example file, or explain how I can create a waterfall with two separate promote structures in the same deal? E.g. raising $10M in equity, $5M is a 10% pref with 60/40 after; the other $5M is 8% pref with 70/30 after.
| +52 | Leave brokerage to be GP | 12 | 2d | |
| +49 | New Comp Database - Google Form (Now with Data Validation) | 24 | 23m | |
| +24 | Spreads over SOFR/UST | 10 | 15m | |
| +24 | Seeking Career Guidance in Real Estate Development Post-Graduation | 3 | 4d | |
| +23 | Going out on your own | 4 | 2d | |
| +22 | Real Estate = complicated + underpaid | 15 | 2d | |
| +22 | REPE/Development GPA | 15 | 5d | |
| +20 | High achiever that doesn’t want to work weekends | 12 | 19h | |
| +18 | Stocks - What are People Buying? | 8 | 19m | |
| +17 | Fisher Brothers | 6 | 2d |
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.
Use your brain. This is not hard…
Just... build two waterfalls with $5M of the equity flowing to each and the pro rata share (5/10 = 50%) of cash flow running into each?
It sounds like a simple solution, but does that really work? Even if they've only put in 50% of the equity they are still entitled to 100% of the cashflow until the pref rate is met (I would think!). Without knowing terms of the JVA it’s hard to say what happens between the 8%-10% return rates.
They are entitled to 100% of their PRO RATA cash flow. If they have 50% ownership, that is 50% of total cash flow.
Once you've divvied up that top line item between the two, you can run 8% and 10% prefs using those 50% shares on their respective equity commitments.
This is what I ended up doing. Works
How do you not end up double counting promote? Make sure that total waterfall cash flows )both), equal the deal level cash flow.
They do when you allocate pro-ratably. Sum total distributions and contributions from both waterfalls and it will equal total deal-level.
are cashflows from the deal split pro rata pari passu? Meaning every $1 gets split 50/50 equally at the same time? This is a "deal term" not a modeling convention or rule, so you need to be 100% for sure on that. There can be situations where there is an internal preference and ordered systems for each (would need to be detailed in the deal docs).. where like first group gets return of cap with pref, then other group gets return of cap with pref, then move into each hurdle.
If its the simple pro rata pari passu method, then just splitting the cash flows 50/50 and doing two sep waterfall calcs will work fine.
Voluptas quam molestias laudantium non explicabo laudantium distinctio inventore. Qui est quo eos id quam. Et voluptatum voluptatibus magni perspiciatis similique rerum vero.
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...