excel cap table template free

Equity Ownership and Capitalization Schedule

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

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, Restricted to ensure data consistency.
• Data Validation (Status Column): Select the "Status" column, go to Data > Data Validation, and select "List." Enter: Active, Vested, Reserved, Terminated.