Cap Table Template
Professional capitalization table to track equity ownership, manage dilution, and model funding scenarios. Essential for every startup founder.
Everything You Need to Manage Equity
Ownership Tracking
Track all shareholders and their ownership percentages
- +Founders equity
- +Employee stock options
- +Investor holdings
- +Advisor shares
- +Ownership percentages
Vesting Schedules
Manage vesting for employees and founders
- +4-year vesting with cliff
- +Custom vesting schedules
- +Acceleration triggers
- +Vested vs unvested tracking
- +Termination scenarios
Funding Rounds
Model dilution through multiple rounds
- +Pre-money valuation
- +Investment amounts
- +Share price calculation
- +Dilution impact
- +Pro-forma ownership
Option Pool
Plan and manage employee equity
- +Option pool sizing
- +Grant tracking
- +Exercise price
- +Available options
- +Dilution planning
Exit Scenarios
Calculate returns at different exit values
- +Liquidation preferences
- +Participation rights
- +Distribution waterfall
- +Return multiples
- +Proceeds calculator
Legal Compliance
409A and tax considerations
- +409A valuation tracking
- +Strike price history
- +Tax implications
- +ISO vs NSO tracking
- +Fair market value
Typical Funding Scenarios
| Round | Typical Raise | Dilution | Pre-Money Val |
|---|---|---|---|
| Pre-Seed | $250K-$1M | 5-10% | $3-5M |
| Seed | $1-3M | 10-25% | $5-15M |
| Series A | $5-15M | 15-30% | $20-50M |
| Series B | $15-50M | 10-20% | $50-200M |
*Ranges vary significantly based on industry, traction, and market conditions
Common Cap Table Mistakes to Avoid
Not updating after each grant
Impact: Inaccurate ownership records
Solution: Update cap table immediately after board approval
Forgetting about dilution
Impact: Surprised founders at funding
Solution: Model scenarios before raising
Complex share structures
Impact: Investor confusion and delays
Solution: Keep it simple in early stages
No vesting for founders
Impact: Investor red flag
Solution: Implement 4-year vesting with 1-year cliff
Option pool too small
Impact: Can't hire key talent
Solution: Plan for 10-20% option pool
Not tracking 409A valuations
Impact: Tax compliance issues
Solution: Get 409A valuations annually
How to Use This Template
Initial Setup
Enter founders, initial shares, and vesting terms
Add Stakeholders
Input employees, advisors, and early investors
Model Rounds
Simulate funding rounds and see dilution impact
Track Changes
Update after each grant or investment
Best Practices
- +Keep cap table updated in real-time
- +Use standard 4-year vesting with 1-year cliff
- +Get board approval for all equity grants
- +Track 409A valuations and FMV
- +Model dilution before fundraising
- +Keep option pool at 10-20%
Pro Tips
- +Consider using cap table software after Series A
- +Include double-trigger acceleration for founders
- +Reserve equity for key hires early
- +Understand liquidation preferences
- +Plan for employee departures
- +Keep legal docs organized
Download Your Cap Table Template
Get the Excel template that thousands of startups use to manage their equity. Includes formulas, vesting schedules, and scenario modeling.
Free forever · Excel & Google Sheets compatible · Used by 5,000+ startups