Excel Cap Table Template
Having a well-structured excel cap table template free is the single most important step you can take to ensure compliance, employee onboarding, retention, and meeting labor law standards. Research consistently shows that teams and individuals who follow a documented, step-by-step process achieve 40% better outcomes compared to those who rely on memory or improvisation alone. Yet, the majority of people still operate without a clear, actionable framework. This comprehensive Excel Cap Table Template template bridges that gap — giving you a battle-tested, ready-to-use guide that covers every critical step from start to finish, so nothing falls through the cracks.
What is a Excel Cap Table Template?
A excel cap table template free is a standardized document used to streamline processes, ensure consistency, and maintain compliance within the business-hr domain. By leveraging this pre-built template, you avoid starting from scratch, thereby reducing errors and saving significant time. Our professionally designed format is easily accessible as an editable CSV spreadsheet for Microsoft Excel and Google Sheets, alongside a clean printable PDF.
Spreadsheet/Log Preview
Standard Operating Procedure
Registry ID: TR-EXCEL-CA
Excel Cap Table Template
This document serves as a foundational ledger for tracking equity distribution, share classes, and dilution across a private entity. Use this to maintain an accurate record of shareholders, issued options, and total authorized shares. This file should be updated whenever a new funding round closes, an option grant is approved, or a transfer of ownership occurs.
Current Equity Distribution
| Shareholder Name | Class | Shares Owned | % Ownership | Grant Date | Status |
|---|---|---|---|---|---|
| [Founder A] | Common | 5,000,000 | 50.00% | 2023-01-01 | Active |
| [Founder B] | Common | 4,000,000 | 40.00% | 2023-01-01 | Active |
| [Investor Group] | Preferred | 500,000 | 5.00% | 2023-06-15 | Active |
| [Option Pool] | Common | 500,000 | 5.00% | 2023-07-01 | Reserved |
Data Definitions
- Shareholder Name: [Full Legal Name of Entity or Individual] (Text)
- Class: [Common / Preferred / Restricted] (Dropdown Validation)
- Shares Owned: [Numeric value of total shares held] (Number)
- % Ownership: [Calculated field based on total authorized] (Percentage)
- Grant Date: [YYYY-MM-DD] (Date)
- Status: [Active / Vested / Reserved / Terminated] (Dropdown Validation)
Essential Formulas
Calculate Total Shares Issued:
=SUM(C2:C5)
Calculate Individual Ownership Percentage (Cell D2):
=C2 / $C$6
(Note: Ensure C6 contains the Total Authorized Shares sum)
Calculate Remaining Option Pool:
=Total_Authorized_Pool - SUM(Shares_Allocated_to_Employees)
Formatting and Validation Rules
- Conditional Formatting (Percentage Heatmap): Apply a "Color Scale" (Green to White) to the "% Ownership" column to visually identify majority stakeholders.
- Data Validation (Class Column): Select the "Class" column, go to Data > Data Validation, and select "List." Enter:
Common, Preferred, Restrictedto ensure data consistency. - Data Validation (Status Column): Select the "Status" column, go to Data > Data Validation, and select "List." Enter:
Active, Vested, Reserved, Terminated.
Cap Table: Spreadsheet Template
Copy this grid into Google Sheets or Excel and fill in the blank cells with your own figures. Subtotals, totals and calculated cells carry live spreadsheet formulas, so the sheet updates itself as you type.
| Shareholder | Share Class | Shares Issued | % Ownership | Price per Share | Total Invested |
|---|---|---|---|---|---|
| =C2/C15 | =C2*E2 | ||||
| =C3/C15 | =C3*E3 | ||||
| =C4/C15 | =C4*E4 | ||||
| =C5/C15 | =C5*E5 | ||||
| =C6/C15 | =C6*E6 | ||||
| =C7/C15 | =C7*E7 | ||||
| =C8/C15 | =C8*E8 | ||||
| =C9/C15 | =C9*E9 | ||||
| =C10/C15 | =C10*E10 | ||||
| =C11/C15 | =C11*E11 | ||||
| =C12/C15 | =C12*E12 | ||||
| =C13/C15 | =C13*E13 | ||||
| =C14/C15 | =C14*E14 | ||||
| Totals | =SUM(C2:C14) | =SUM(D2:D14) | =SUM(F2:F14) |
Frequently Asked Questions
Q: How do I ensure the ownership percentage updates automatically when I add new shareholders?
A: To keep your percentages accurate, you must update the "Total Authorized Shares" figure in your master cell (referenced as C6 in the formulas) whenever you issue new equity. Because the ownership formula uses an absolute reference ($C$6), any change to your total share count will instantly trigger a recalculation across the entire table, ensuring your dilution math remains precise without needing to manually edit individual cells.
Q: Can I customize the dropdown menus in the Class and Status columns? A: Yes. To modify these, highlight the cells in the "Class" or "Status" columns, navigate to the "Data" tab in the Excel ribbon, and click "Data Validation." In the settings menu, you can edit the comma-separated list in the "Source" box. Ensure you keep the list consistent with your internal record-keeping needs, such as adding new share classes like "Series A Preferred" or "Convertible Notes."
Q: How should I account for unallocated shares within the Option Pool? A: Treat the "Option Pool" as a distinct shareholder row. When you grant shares to an employee, decrease the "Shares Owned" value in the Option Pool row and create a new row for the individual recipient. This method allows you to track your remaining "Reserved" pool versus "Vested" grants, maintaining a clear audit trail of exactly how much of your authorized pool remains available for future hires.
Download this Template
Related Templates
View allInventory Control System Excel Template
Manage your stock efficiently with this professional inventory management template. Track incoming shipments, outgoing orders, and audits in one place.
View templateTemplateDaily Electrical Panel Inspection SOP: Essential Checklist
>-
View templateTemplateInventory Management System Download
Manage your stock efficiently with this inventory management system template. Includes tracking logs, supplier contact details, and stock adjustment forms.
View template