Most founders waste hours trying to build the perfect equity spreadsheet before they even have a working product. Use this basic setup to track who owns what, so you can get back to building something people actually want to buy.
A cap table template is a basic ledger showing exactly who holds equity in your startup. Keep it simple on day one.
Save this text as a .csv file and open it in your preferred spreadsheet software. Before you use this, you might also want to review my
pre-seed cap table template if you are at day zero.
- Format the file: Copy the block below and save it as a text file with a .csv extension.
- Edit placeholders: Replace the bracketed text with your actual team members and investors.
- Calculate percentages: Divide the individual shares by the total outstanding shares.
Sample math: If you have 8,000,000 to 10,000,000 total shares, and you give an advisor 100,000 shares, they own around 1.0% of the company. For standard startup structuring, review
SVB's startup equity guide.
Setting the right initial numbers gives you breathing room later. Look at
typical option pools according to Carta to benchmark your own distributions before allocating them.
- Total authorized shares: 5,000,000 to 10,000,000 units.
- Employee option pool: 15% to 20% reserved for early hires.
- Advisor shares: 0.1% to 1.0% per advisor depending on involvement.