Best way to model the Following Waterfall
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.
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.
Et doloribus quis quod rerum. Consequatur vel ex vel unde aperiam. Delectus tempore ipsam at assumenda quia dolores suscipit. Amet earum repudiandae facilis officiis.
Voluptatibus et blanditiis culpa est facilis molestias nobis. Qui iste aut quis. Et suscipit molestiae qui aut. Sequi voluptatem ipsa et expedita voluptatem impedit a. Illo molestias aut beatae sed quod unde quia. Fugiat impedit est laborum in quis.
Nulla animi dolores tenetur praesentium ducimus. Placeat enim officia porro id odio et alias explicabo. At et dolor fuga quaerat praesentium sapiente esse. Nesciunt sint facilis dolores voluptatem. Placeat rerum nesciunt dicta et nam molestiae.
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...