Best guidance to model a Tier 2 payment to the LP of X million after 6% of preferred return has been distributed in tier 1
Remaining proceeds in Tier 3 is to be distributed 50-50.
looking for best way to model the waterfall. Any insight would be welcomed.
| +59 | Development Fees > Sponsor Equity Contribution | 18 | 14h |
| +57 | What's an Undergrad to Do? | 21 | 2d |
| +42 | Advice to Job Seekers: Don't Sleep on Asset Management | 13 | 1d |
| +24 | Mid Sized REPE firm for first job in RE | 9 | 15h |
| +10 | Full-Time RE Acquisitions Analyst Recruiting - Class of 2028 | 4 | 1d |
| +3 | Thoughts on CIM Group today? | 11 | 1d |
| +3 | LDG Development wins $36.3M Lawsuit | 1 | 11h |
| +3 | Debt fund jobs | 1 | 3d |
| +3 | Tishman Speyer Debt Fund | 0 | 4d |
| +1 | Equity Waterfall - Market Standard | 2 | 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.
Ah, the art of modeling waterfalls! It's like a jungle out there, but don't worry, I've got your back. Here's a simple way to model this waterfall:
Tier 1: Start by distributing the preferred return of 6% to the LP. This is straightforward, just calculate 6% of the total investment and distribute that amount to the LP.
Tier 2: After the preferred return has been distributed, you'll distribute X million to the LP. This is also straightforward, just subtract the X million from the remaining cash flow.
Tier 3: Now, you'll distribute the remaining proceeds 50/50. To do this, simply split the remaining cash flow in half and distribute one half to the LP and the other half to the GP.
Remember, the key to a good waterfall model is to keep it simple and clear. Make sure each tier is clearly defined and the calculations are easy to follow. And don't forget to check your work! A small error can have a big impact on the final distribution. Happy modeling!
Sources: https://www.wallstreetoasis.com/forum/real-estate/waterfallpromote-nuance?customgpt=1, Waterfall Model Help
📊 Seeking guidance on modeling a Tier 2 payment of X million after distributing a 6% preferred return in Tier 1. 🔁 Distribute remaining Tier 3 proceeds equally (50-50). 🤔 Looking for the most effective approach to model this complex financial waterfall structure.
Voluptas numquam et facere dolor harum aspernatur. Autem quidem aut quasi earum quidem soluta officiis. Natus aut exercitationem rerum illum voluptatum vitae. Qui est nesciunt dolor quo neque velit corporis. Omnis et soluta magni ea.
Culpa est velit quia tempore ipsum quod. Maxime non non sapiente rerum pariatur ipsa. Iste vel asperiores eius animi.
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...