Free Cap table Template

The workbook has two sheets:

• Intro – A quick walkthrough: fill the orange cells, everything else calculates on its own.
• Cap Table Template – The core sheet, split into two linked sections: a Company Valuation block and a Company Ownership Cap Table.

1. Company Valuation (Series A example) Enter your pre-money valuation and founder share count, plus the new equity being raised. The sheet automatically calculates:

• Price per share
• Post-money valuation
• Each party's % of the total round

2. Company Ownership Cap Table This is where the template earns its keep. Enter capital contributed and shares issued for each stakeholder, and it automatically tracks:

• Founders — starting share count and resulting ownership %
• Investors (up to 4 slots) — capital in, shares received, running total of shares outstanding
• Employees & Advisors (CMO, up to 2 advisors, a project manager, and 2 more roles) — equity grants tracked separately as a Class "B" share pool
• A running cumulative share count and ownership percentage that recalculates instantly as new rows are filled in

Because the valuation table and the ownership table are formula-linked, changing your raise amount or share price flows straight through to every stakeholder's ownership percentage — no manual recalculating.

• Two share classes modeled separately: Class "A" (founders/investors) and Class "B" (employee/advisor option pool)
• Automatic per-share price and post-money valuation calculations
• Running total of shares outstanding and % ownership for every stakeholder, updated live
• Slots for up to 4 investors and 6 employee/advisor equity holders — expandable if you need more
• Simple orange-cell input system — no formulas to touch, no finance background required
• Works for any industry or company type

A cap table isn't just record-keeping — it's the document investors, lawyers, and future acquirers will scrutinize most closely. A few benchmarks worth knowing as you plan your round:

• Employee option pools at the seed stage typically land in the 10 to 15 percent range of fully diluted shares, so it's worth modeling that pool size before you negotiate a term sheet.
• Founders typically hold around 56 percent of their company after a seed round, dropping to roughly 36 percent after a Series A — numbers worth checking your own cap table against.
• Seed-stage founders commonly give up 18 to 25 percent equity in a priced round, so a small modeling error at this stage compounds through every future round.

Modeling these numbers on paper before a term sheet lands means you walk into negotiations knowing exactly what a proposed valuation and option pool will do to your ownership — not finding out after signing.

• Founders preparing for a seed or Series A raise
• Early-stage teams that need to track investor and employee equity in one place
• Startup advisors and consultants who need a quick, reusable cap table tool for clients
• Anyone drafting a term sheet or pitch deck who needs a credible ownership breakdown