Cap Table Example in Excel
A cap table, short for capitalization table, is an essential financial document used to track ownership and equity value in a company. It's particularly crucial for startups to understand who owns what, and, more importantly, how diluting shares could impact their ownership of the company. If you're managing or even just involved in a startup, knowing how to create and interpret a cap table is vital. Let's explore an example of a cap table using Excel, a widely-used tool for such tasks.
Before we delve into the Excel cap table example, let's understand the key components of a cap table:
Cap Table Basics
At its core, a cap table lists each shareholder, the number of shares they own, and the type of shares they hold. It also tracks outstanding shares, series information, and conversion preferences. Here's a simple example:
| Shareholder | Number of Shares | Type of Shares |
|---|---|---|
| Founder A | 1,000,000 | Preferred |
| Founder B | 1,000,000 | Preferred |
| Investor C | 500,000 | Series A Preferred |
However, this is a static view of a cap table. An Excel cap table can dynamically track changes in equity as a company grows, raises funds, and issues more shares.
Excel Cap Table: Basics
To create a cap table in Excel, start by setting up headers: Shareholder, Number of Shares, Type of Shares, and then add columns to track each round of funding. Use formulas to calculate total shares outstanding, individual shareholder stakes, and equity dilution.
Excel Cap Table: Advanced
For a more complex, yet realistic, example, consider this snapshot of a vc-funded startup's cap table:
| Shareholder | Pre-Funding Shares | Price per Share | Funding Round | Shares Issued | Post-Funding Shares | Shares Outstanding | % of Company |
|---|---|---|---|---|---|---|---|
| Founder A | 4,000,000 | $1.00 | Series A | 6,000,000 | 6,000,000 | 50.00% |
With this setup, you can easily track ownership changes, calculate dilution, and project future shareholder equity with additional funding rounds.
Interpreting and Using a Cap Table
A cap table is a critical tool for understanding a company's equity distribution. It's essential for tracking dilution, setting employee compensation, and planning future funding rounds. For example, if an investor proposes a new funding round, use your cap table to calculate how many shares to issue and which shareholders might see dilution.
Cap Table and Dilution
Dilution occurs when new shares are issued, existing shareholders' percentage of ownership decreases. Here's an example in a cap table:
| Shareholder | Shares | % of Company |
|---|---|---|
| Founder A | 4,000,000 | 66.67% |
| Founder B | 2,000,000 | 33.33% |
After issuing 2,000,000 shares to an investor:
| Shareholder | Shares | % of Company |
|---|---|---|
| Founder A | 4,000,000 | 40.00% |
| Founder B | 2,000,000 | 20.00% |
| Investor | 2,000,000 | 40.00% |
As you can see, both founders experienced dilution—their ownership percentages decreased.
Cap Table and Employee Compensation
Cap tables help calculate the fair market value of shares, crucial for employee compensation. For instance, if a company has 10,000,000 shares outstanding and a value of $10,000,000, each share has a fair market value of $1.00. This can help set a target for employee stock compensation.
Understanding your cap table is essential for making informed decisions about growth, funding, and compensation. By keeping your cap table updated in Excel, you can sleep easy, knowing you're always a couple of clicks away from insightful equity data.