cap table example excel

Cap Table Example in Excel

By Kevin Miller
AD

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:

AD
Cap Table Startup Template
Cap Table Startup Template
Capitalization Table Template
Capitalization Table Template
Top 21 Excel Formulas
Top 21 Excel Formulas
ShareholderNumber of SharesType of Shares
Founder A1,000,000Preferred
Founder B1,000,000Preferred
Investor C500,000Series 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.

Cap Table and Equity Ownership Tracker | Startup Founder Cap Table Excel Template | Option Pool, Dilution & Round Modeler | CPA-Built
Cap Table and Equity Ownership Tracker | Startup Founder Cap Table Excel Template | Option Pool, Dilution & Round Modeler | CPA-Built
the excel formulas chart with numbers and symbols for each item in this table, you can
the excel formulas chart with numbers and symbols for each item in this table, you can
Example of Excel Data Table (6 Criteria) - ExcelDemy
Example of Excel Data Table (6 Criteria) - ExcelDemy

Excel Cap Table: Advanced

For a more complex, yet realistic, example, consider this snapshot of a vc-funded startup's cap table:

2,000,000
ShareholderPre-Funding SharesPrice per ShareFunding RoundShares IssuedPost-Funding SharesShares Outstanding% of Company
Founder A4,000,000$1.00Series A6,000,0006,000,00050.00%

With this setup, you can easily track ownership changes, calculate dilution, and project future shareholder equity with additional funding rounds.

AD

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.

How to create a compact table view in Excel!
How to create a compact table view in Excel!
COUNT vs COUNTA vs COUNTIFS in Excel Easy Guide for Beginners | Excel Functions Explained (part 17)
COUNT vs COUNTA vs COUNTIFS in Excel Easy Guide for Beginners | Excel Functions Explained (part 17)
Excel Tables Explained | Transform Raw Data into Smart, Dynamic Reports
Excel Tables Explained | Transform Raw Data into Smart, Dynamic Reports
Excel Tables Cheat Sheet
Excel Tables Cheat Sheet
How to Copy and Paste an Excel Table into Outlook Email (3 Methods) - ExcelDemy
How to Copy and Paste an Excel Table into Outlook Email (3 Methods) - ExcelDemy
the ultimate guide to create professional chart in excel with infos, graphs and diagrams
the ultimate guide to create professional chart in excel with infos, graphs and diagrams

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:

ShareholderShares% of Company
Founder A4,000,00066.67%
Founder B2,000,00033.33%

After issuing 2,000,000 shares to an investor:

AD
ShareholderShares% of Company
Founder A4,000,00040.00%
Founder B2,000,00020.00%
Investor2,000,00040.00%

As you can see, both founders experienced dilution—their ownership percentages decreased.

3.3K reactions · 645 shares | ✅ 60 MS Excel Shortcuts Keys 🤫 #shorts #ytshorts #trendingshorts #excel | Harkesh Kumar
3.3K reactions · 645 shares | ✅ 60 MS Excel Shortcuts Keys 🤫 #shorts #ytshorts #trendingshorts #excel | Harkesh Kumar

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.

AD
AD