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.
| +62 | Talking about deal experience in an interview | 10 | 1d |
| +52 | What's an Undergrad to Do? | 16 | 1h |
| +33 | Development Fees > Sponsor Equity Contribution | 6 | 7m |
| +30 | Advice to Job Seekers: Don't Sleep on Asset Management | 6 | 1h |
| +25 | Underwriting Predevelopment Costs | 5 | 4d |
| +17 | Job after RE Masters Degree \ Seeking advice | 8 | 2d |
| +12 | Automated Real Estate Modelling | 2 | 5d |
| +10 | Full-Time RE Acquisitions Analyst Recruiting - Class of 2028 | 3 | 2d |
| +8 | IB to Development | 3 | 5d |
| +7 | London REPE Comp | 6 | 1d |
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.
Enim rerum deleniti delectus at unde. Sunt repellat sed molestiae. Id accusamus ipsam rerum iusto cupiditate sit dolores. Reprehenderit molestiae et ipsum dolore rem. Mollitia sit accusantium facilis voluptatem.
Quis quas mollitia asperiores quibusdam omnis blanditiis. Aspernatur aspernatur vel dolore nobis atque dolor molestiae. Est odio quisquam voluptatem et beatae debitis ducimus.
Facere minima ut aut voluptas inventore. Dolor minima fugiat enim debitis. In beatae voluptatem est deserunt distinctio est. Enim ea distinctio delectus maiores qui 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...