The Capitalization Table (Cap Table): Full Guide + Excel Examples

Capitalization Table Definition: The “cap table” for a startup or venture capital-backed business lists the shares owned by each individual or entity, their percentage ownership, the current value of this ownership, and any special terms associated with each group, such as liquidation preferences.

Here’s an example cap table taken from our Venture Capital & Growth Equity Modeling course:

This table lists the co-founders’ and executives’ shares, employees’ options, and the shares owned by the investors over 5 investment rounds (Seed through Series D).

When the startup sells, the cap table tells you how much in proceeds each group earns, factoring in their shares and special terms.

For large public companies, “cap tables” are pointless because these companies mostly have common shares with a small number of employee-owned options, restricted stock units (RSUs), and other dilutive securities.

There’s no need for a full table because if one investor owns 100 shares, they have the same ownership and economic value as 100 shares owned by any other investor.

(Some exceptions exist, such as companies with multiple share classes, separate voting/control shares, etc., but these are not common.)

However, for startups, certain investors have special terms and privileges, so 100 shares owned by one group could be quite different from 100 shares owned by someone else.

For example, venture capital (VC) firms often invest using preferred stock, which gives them more downside protection if the startup fails or sells for a low price.

Cap tables are also important because, with startups, you need to track the share counts and ownership over time.

This is a bit of an afterthought for public companies, but startups need to understand each investor group independently because they likely invested at different times and valuations.

Here’s a simple cap table Excel example and instructions for the key calculations:

Files & Resources:

Cap Table Guide – Slides (PDF)

Cap Table Example (XL)

Video Table of Contents:

• 1:07: Part 1: Cap Tables: The Short Version
• 2:30: Part 2: Ownership and Investment Sizes
• 3:47: Part 3: Options and Liquidation Preferences
• 6:09: Part 4: New Shares and Options in the Round
• 9:17: Part 5: Share Price in Each Round
• 10:27: Part 6: Exit Calculations
• 13:27: Recap and Summary

Cap Table Setup: Ownership and Investment Sizes

At the minimum, you need to know how much is invested in each funding round, the pre- and post-money valuations, and any special terms attached to the funding.

Also, if the startup’s employees receive options in the round or its co-founders/managers get “free shares” in the round, you need this information.

In this example, the three co-founders each owned 33% of the company before they raised outside capital:

Next, the company raised a $2 million Seed round at a $6 million pre-money valuation.

“Pre-money” means “The Equity Value before the additional capital came in.”

The post-money valuation equals the pre-money valuation + the investment size, so it is $8 million here.

“Post-money” means “The Equity Value after the additional capital,” so it should always be higher than the pre-money valuation.

The investors’ ownership in this round equals the Investment Size / Post-Money Valuation.

In other words, they invested $2 million into a company that is now worth $8 million, so they own $2 million / $8 million = 25%.

You can see this setup below:

Cap Table Setup: Options and Liquidation Preferences

Venture capital investors typically invest using preferred stock rather than common shares.

They may convert their preferred stock into common shares at any time, but they typically keep them until the exit because doing so gives them special rights and privileges – such as liquidation preferences.

In this $2 million Seed Round, the investors get a 1x “liquidation preference,” which equals $2 million * 1x = $2 million.

This means that if the company sells for a very low valuation that would result in the Seed investors earning less than $2 million, they get the $2 million as a minimum return.

If the available proceeds are less than $2 million, they just get the available proceeds.

The liquidation preferences are not shown directly in the cap table until the exit calculations (see below), but you should enter and track them in each round:

Another issue is that in each funding round, the startup normally grants options to employees to incentivize them to stay and work at the company.

These options become more valuable if the company performs well, and if the employees stay for several years, they can pay a small amount to “exercise” their options and get shares in the company (assuming the company’s value has increased).

If they do this, they can sell their shares for a solid profit since the share price should be much higher than the options’ original exercise price.

Options may be granted before the funding round, at the same time as the funding round, or after the round.

If we assume the options are issued before this funding round and represent 10% of the company, we can calculate the options granted to employees with:

= Shares Before Round / (1 – Ownership) * Ownership

= 1.2 million / (1 – 10%) * 10% = 133,333

We want them to own 10% afterward, so we must “gross up” the share count, as 133,333 is 10% of 1.333 million shares:

Because we calculate the employee options before the funding round, they end up owning less than 10% after the funding round, as the VCs purchase 25% of the company:

This is quite unusual and not the intended result of a standard options pool, so we’ll look at a more traditional method in the next section.

Cap Table Calculations: New Shares and Options in the Round

While it’s critical to calculate the ownership and pre- and post-money valuation in each round, that’s not enough because you also want to track the number of shares or options owned by each group and the effective share price.

In other words, if the Series A investors invest $5 million, how many shares do they get, and what price do they pay for each share?

This sounds simple, but it can get complicated because in addition to the VC investors that pay for shares, some groups may get shares or options for free.

For example, let’s say the Series A round VCs invest $5 million at a $15 million pre-money valuation, and the employee options pool is also upsized to 20% total ownership.

To calculate the new shares for each group in this round, we start by adding up the groups whose ownership does NOT change.

We have new Series A investors, and the employees get more options, but the Co-Founders and Seed investors do not get any new shares.

The employees will own 20% afterward, and the VCs are investing $5 million at a $15 million pre-money valuation, so they’ll own $5 / ($15 + $5) = 25%.

Therefore, these “new/changed investors” will own 20% + 25% = 45%, and the investors that stay the same will own 100% – 45% = 55%.

We then “gross up” the share count by taking the 1.778 million shares from before the round and dividing by this 55% ownership:

So, there will be approximately ~3.0 million total shares after the round, which means ~1.2 million new shares will be created.

We know the employees should own 20% * 3.0 million of these, or ~598K. They already own 133K, so they’ll get 598K – 133K = 465K in the round:

Therefore, the remaining 1.2 million – 465K = 747K goes to the Series A investors, and they end up owning the 25% they initially targeted:

The Cap Table: The Share Price in Each Round

Calculating the share price in each round is also useful because you may need this information when dealing with employee options and their exercise prices (or to assess the startup’s per-share value in an IPO or M&A exit).

You can use one of two methods to calculate it:

1. Investment Size / Shares Purchased – For example, in this Series A round, it’s $5 million / 747K shares = $6.69
2. Pre-Money Valuation / (Pre-Money Shares + “Free” Shares and Options Granted in Round) – For example, here it’s $15 million / (1.8 million + 465K) =$6.69.

More advanced features, such as anti-dilution provisions, SAFE notes, convertible notes, venture debt, warrants, or follow-on investments can complicate these calculations, but the basic idea is simple:

Cap Table Use in Real Life: Exit Calculations with a Liquidation Preference

One of the main points of a cap table is to determine the exit proceeds to each group if the startup sells or goes public.

We’ll focus on the “startup sells” case here and assume a $100 million exit (i.e., the Exit Equity Value is $100 million, so these are the total proceeds available to the shareholders).

To determine the exit proceeds, we multiply each group’s ownership percentage by the $100 million:

However, this assumes that none of these investors take their liquidation preferences and instead convert to common shares, which offer ownership in an exit.

By contrast, if the investors stay in preferred, they would simply earn their liquidation preferences in an exit.

In this case, all the investors would convert to common shares because it’s better to earn $25 million rather than $5 million or $15 million rather than $2 million.

However, if the company sells for a much lower price, such as an $18 million Exit Equity Value, things change dramatically:

In this case, the Series A investors’ stake is worth only $18 million * 25% = $4.5 million, so they’ll take their $5 million liquidation preference instead.

Since they’ve taken their liquidation preference, the Seed investors now own more of the company.

Instead of just 14.9%, they own 14.9% / (14.9% + 60.1%) = 19.8%.

The remaining proceeds are only $13 million now, since $18 million – $5 million = $13 million, so the Seed investors earn 19.8% * $13 million = $2.6 million.

This amount exceeds their liquidation preference of $2 million, so they choose to convert into common shares and get the $2.6 million.

This is why it’s so important to use a real cap table for startup modeling: These details would be lost if you only tracked the shares owned by each group, and you’d get incorrect results in “low exit value” cases.

More Advanced Cap Table Topics

This tutorial scratches the surface of capitalization tables.

Other, more advanced topics include:

• SAFE Notes, Convertible Notes, and other forms of investing in “unpriced” rounds without a defined pre- or post-money valuation.
• Venture debt, venture loans, and warrants associated with these.
• “Down rounds” and terms such as anti-dilution provisions that protect earlier investors.
• Participating preferred stock with participation caps.
• Flow of Funds analysis that presents multiple exit scenarios and includes circular calculations for employees’ exercise of options.

We cover all these (and more) in our full VC & Growth Equity course, and we may publish a few additional tutorials on them.