Deal Waterfall & Equity Return Analysis Prompt
Prompt
Model equity returns and distribution waterfall. [PASTE: Investment structure, equity investors, preferred return, carry, profit split] Steps: 1) Model annual cash distributions 2) Calculate cumulative distributions to each investor 3) Model exit proceeds and waterfall 4) Calculate IRR and equity multiple by investor 5) Identify preferred return thresholds 6) Model carry/promote scenarios 7) Create distribution schedule Output: Waterfall analysis, equity return by investor, distribution schedule, IRR and multiple by investor tier.
Why it works
Waterfall modeling ensures fair allocation. Clear model prevents disputes with co-investors.
Watch out for
Complex waterfalls confuse investors. Simple, transparent models build investor confidence.
Used by
Finance TeamsData Analysts