Capitalization Table

What is the Role of the Cap Table for Startups?

In addition to showing current equity ownership, a capitalization table is useful for the following:

• Performing an ownership scenario analysis by existing investors of a contemplated next round of investment at various pre-money valuations
• Conducting due diligence by new investors or potential acquirers
• Building 409A valuations and identifying any unallocated options available for new employee hiring
• Performing an analysis of expected returns and proceeds to various providers of capital based on certain exit valuation assumptions
• Legal ownership and tax compliance

The VC cap table becomes obsolete after the company changes ownership, either via purchase or IPO.

Cap Table Model – Excel Template

Use the form below to download a complete capitalization table example:

Get the Excel Template!

First Name *

Email *

Submit

By submitting this form, you consent to receive email from Wall Street Prep and agree to our terms of use and privacy policy.

Email provided

Your Download is Ready

Submitting...

Startup Cap Table Calculation Example

At its simplest, the equity ownership on a VC capitalization table should add up to 100%.

As events occur, such as new investors are added or debt converts to equity, the number of shares on the cap table must be updated to reflect any changes while still totaling 100%.

Let’s look at the calculations required to update the cap table with an example:

• Assume a VC is asking for 10% of a company with an investment of $1 million (valued at $10M)
• The company already has 100,000 outstanding shares (50% held by the founder and 50% held by an angel investor)

Question: How many new shares do the new Series A investor get with the investment?

Their new ownership stake can be calculated as:

Solving for their new shares results in the following formula:

Now applying the assumptions:

• New Shares = [.10/(1-.10)] * 100,000
• New Shares = 11,111

Checking the calculation, we can see their shares represent 10% of the new company.

• 11,111 / (100,000 + 11,111) = 10%

The updated cap table is shown below:

Venture Capital Exits (VC) and Industry Trends

The law of returns of early-stage venture investments states that for every ten Series A investments, 20% (2) will pay, 40% (4) will break even & 40% (4) will fail.

This means that to meet the VC firm’s investor expectations, those who make money on the investment must make up for those that do not make money (i.e., the winners need to return a multiple of the fund).

After experiencing a COVID-19 related dip in Q2 2020 deal count, Q3 showed signs of improvement. As you can see from the figure below, the deal sizes have trended up pre-COVID despite the drop is deal count.

Q3 Deal Activity (Source: PitchBook)

Moreover, while the vast majority of VCs exit their investments through acquisitions, the dollar amounts of these exits are derived largely from IPOs, and more recently, from acquisitions.

The recent public listings of Snowflake (SNOW), Palantir (PLTR), Asana (ASAN), and Unity (U) all helped contribute towards this massive rebound in exit returns in Q3.

Q3 VC Exits (Source: PitchBook)

So while strategic M&A has historically accounted for the majority of exits and returns, these recent high-profile IPOs of venture-backed unicorns are creating all-time high returns for VCs.

Cap Table Modeling in Venture Capital Investing (VC)

The waterfall flow of funds shows how the proceeds of a liquidity event, such as an acquisition, flow to everyone on a cap table.

Using the example above (VC invests $1 million for a 10% stake in a company whose ownership was previously split 50-50 between the founder and an angel investor), let us allocate the proceeds assuming the company sells for $5M, or roughly half its initial valuation, five years later.

Some additional background information:

• The Series A Preferred shares have a 1x non-participating liquidation preference
• The conversion ratio of preferred to common is assumed to be 1:1

First, the Series A investor must decide to either take their preference (i.e., 1x their initial $1 million investment) or convert to common shares and take their pro rata share of the proceeds:

• Preference amount = $1 million
• Conversion amount = 10% of $5M or $500K

Clearly, the VC will take their preference for a 1x multiple of invested capital, which means they at least get their money back, however, this would be considered a loss on a time-valued basis. The founder and the angel investor would each get $2M.

Question: What if the company mentioned above were to sell for $100M?

In this case, the investor would convert to common shares and receive $10M, or 10% of the proceeds, while the founder and angel investor would each get $45M.

Demystifying Term Sheets and Cap Tables

The math can get increasingly complicated with more entities on the capitalization table.

For a deeper dive into cap tables, enroll in our Demystifying Term Sheets and Cap Tables Course, where we explore the respective negotiating positions of VCs and entrepreneurs, as well as dive into the more sophisticated math associated with venture-backed start-ups.

Included in our two-hour course is not only a comprehensive walk-through of the VC deal process, but several exercises to construct a capitalization table such as the one shown above.

The more advanced features, such as option pools, convertible debt, and liquidation preferences will also be introduced, which should be very applicable to anyone interested in a career in venture capital.