✏️Prompts

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