Cap Table Template Excel Download
Having a well-structured cap table template excel download 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 Cap Table Template Excel Download 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 Cap Table Template Excel Download?
A cap table template excel download 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-CAP-TABL
Cap Table Template Excel Download
This system provides a structured framework for tracking equity distribution, share classes, and dilution across funding rounds. It is designed for founders and CFOs to maintain accurate records for investor reporting and legal compliance.
Update Cadence: Update immediately upon any issuance, transfer, or conversion of shares.
Current Equity Distribution
| Shareholder Name | Share Class | Shares Held | % Ownership | Grant Date | Vesting Status |
|---|---|---|---|---|---|
| [Legal Name] | Common | 500,000 | 50.00% | 2023-01-01 | Fully Vested |
| [Legal Name] | Common | 250,000 | 25.00% | 2023-01-01 | 4-Year Vest |
| [Legal Name] | Preferred | 150,000 | 15.00% | 2023-06-15 | N/A |
| [Legal Name] | Option Pool | 100,000 | 10.00% | 2023-07-01 | Unallocated |
Column Definitions
- Shareholder Name: [Text] The legal name of the individual or entity.
- Share Class: [Dropdown] Select from Common, Preferred, or Option Pool.
- Shares Held: [Number] Total quantity of shares currently owned.
- % Ownership: [Percentage] Calculated field based on total outstanding shares.
- Grant Date: [Date] The date the equity was issued or authorized.
- Vesting Status: [Text] Current status of vesting schedule (e.g., Fully Vested, 4-Year Vest, Cliff).
Essential Formulas
Calculate Total Shares Outstanding:
=SUM(C2:C5)
Calculate Individual Ownership Percentage (Place in D2):
=C2/SUM($C$2:$C$5)
Calculate Total Option Pool Remaining:
=SUMIF(B2:B5, "Option Pool", C2:C5) - [Total Granted Options]
Data Validation and Formatting
- Dropdown Menu: Select the "Share Class" column, go to Data Validation, and set criteria to "List" with the input:
Common, Preferred, Option Pool. - Ownership Alert: Apply conditional formatting to the "% Ownership" column. Set a rule: If cell value
> 0.50, highlight in light red to flag potential control issues. - Date Formatting: Ensure the "Grant Date" column is set to Date format
YYYY-MM-DDto maintain consistency across fiscal reporting periods.
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 calculate the remaining available options in my pool after issuing grants?
A: Use the provided SUMIF formula in your spreadsheet. You will need to subtract your total granted options from the total quantity listed under the "Option Pool" share class. By keeping this formula active, the template will automatically update your remaining unallocated pool balance whenever you add new rows or adjust share counts for employees or contractors.
Q: Why does the "% Ownership" column highlight in red for certain shareholders? A: This is an automated conditional formatting rule designed to flag potential control issues. If any individual shareholder exceeds 50% ownership, the cell will turn light red. This serves as a visual safeguard for founders and CFOs to quickly identify concentrated equity stakes that might require specific governance considerations or complicate future investor negotiations during funding rounds.
Q: Should I include unvested shares in the "Shares Held" column? A: Yes, you should include the total quantity of shares currently held or authorized for that shareholder, regardless of their current vesting status. Use the "Vesting Status" column to document the specific terms, such as "4-Year Vest" or "Cliff." This ensures your "Shares Held" column remains an accurate representation of your company's total issued equity while providing clear context for legal and reporting requirements.
Download this Template
Related Templates
View allBusiness Plan Template for Ontario
Use this professional business plan template to outline your strategy, market analysis, and financial projections for your Ontario-based business venture.
View templateTemplateNewborn Baby Checklist for First Time Parents
Manage daily infant care and home safety effortlessly with this newborn baby checklist for first time parents, built to ensure a smooth transition home.
View templateTemplateBusiness Plan Template Outline
Use this professional business plan template to outline your company''s mission, market analysis, operations, and financial projections for stakeholders.
View template