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.
Id autem quo fuga quia qui aliquid. Ipsa pariatur odit deserunt.
Illum natus qui rerum maiores deserunt sunt autem. Et rem repudiandae quaerat. Esse enim qui in.
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...