You don't need expensive software on Day 1. You need a clean spreadsheet. If you are building your own tracker, ensure you have these exact columns to avoid legal headaches later. You can also use our
Cap Table Template to get started immediately.
The minimum viable cap table structure- Column A: Shareholder Name (Legal entity name, not nicknames)
- Column B: Role (Founder, Investor, Employee, Advisor)
- Column C: Stock Class (Common vs. Preferred)
- Column D: Shares Issued (The hard number)
- Column E: Options Granted (For employees/advisors)
- Column F: Fully Diluted Shares (Sum of Issued + Options)
- Column G: Ownership % (Fully Diluted Shares / Total Fully Diluted Shares)
Why this matters: Lawyers charge $400+ per hour to clean up messy Excel files. Using a standardized format prevents errors that cost thousands to fix with
Cap Table Mistakes Cleanup Scripts.
Don't guess at these numbers. Use market standards to defend your valuation.
1. The option pool standard (10 – 15%)Investors will demand you create an option pool (shares reserved for future employees). Data from
HSBC Innovation Banking suggests a 10 – 15% pool is standard for early-stage rounds.
Sample math: The pre-money shuffleInvestors usually make you create this pool before their money counts (pre-money). This means the dilution comes 100% from you.
- Scenario: Investors want a 10% post-money option pool.
- Pre-investment: You own 100%.
- The shuffle: To get that 10% pool post-money, you have to dilute your ownership before the investor buys their shares.
- Result: You drop from 100% to roughly 80–85%, the investors take 10–15%, and the pool sits at 10%. You pay for the talent, not the investor.
2. Standard vesting schedulesAccording to
Carta's equity data, the industry standard is a
4-year vesting schedule with a 1-year cliff.- The cliff: If you or an employee leave at day 364, ownership is 0%. At day 365, 25% of the shares vest immediately.
- Monthly vesting: After the cliff, shares typically vest monthly (1/48th of the total grant per month).