If you're a GP or LP in venture capital, you've probably spent hours in Excel trying to figure out how carried interest flows across a waterfall. It's messy, error-prone, and nobody wants to rebuild it from scratch.
Here's what a standard VC waterfall looks like:
- Return of capital (LP gets its money back first)
- Preferred return (8% hurdle, annual)
- Catch-up (GP gets 100% until 20% of total profits)
- Remaining split (80/20 between LP and GP)
I built a Google Sheets model that automates all four tiers. You plug in fund size and exit proceeds, and it calculates GP carry $ instantly. Includes sensitivity tables and example exits.
If you want the template: grab it at https://microtoolsb2b.gumroad.com/l/vc-waterfall








