Blog / Cap Tables

Cap Table Scenario Modeling for Fundraising and Exits

Oct 17, 2022 · Using the Cap Table and Exit Waterfall and an import of a share register to create scenarios for fundraising rounds and proceeds from exits.

Taylor Davidson

Managing Director / Founder

First, a disclaimer: I am not a lawyer or a financial advisor and am not offering financial or legal advice.

Scenario modeling is a common usecase for the Cap Table and Exit Waterfall Tool, as it is easy to enter in details on rounds and evaluate the impact of future fundraising rounds on ownership and exit outcomes. It's also easy to use an export of a share register from an equity management tool, import it into the tool, and model fundraising scenarios and proceeds to shareholders at a variety of exit valuations.

Cap Table and Exit Waterfall Tool
4.9
Download the tool used for the scenario analysis in this post.
Download for Free >

In the video above, I detail how to:

  1. Import an existing cap table
  2. Model out a new fundraising round to see dilution and impact on ownership
  3. Model out an exit and distribution of proceeds to shareholders at multiple exit valuations, using just the existing cap table as well as adding in a new fundraising round
  4. Calculate gross exit multiples and returns to shareholder classes and individual investors

The first through third points took about 10 minutes to do, then I spent the rest of the time showing how to do the fourth point; I do not prebuild the returns (multiple, ROI, IRR) analysis into the model at the moment given a wide variety of edge cases that complicate it, but I'm always happy to answer questions and to help.

Sign up for new posts and products

You'll be redirected to my email provider to confirm. Unsubscribe anytime. Here's how I use your data.