Excel workbook previewStartup and small business finance
Cap Table Template (Excel)
3 free downloads per account. Just your email and a 6-digit code.
About this template
A cap table records who owns what in a company: founders' common stock, investors' preferred stock, employee options and RSUs, warrants and the unallocated option pool. It is needed for every financing, every option grant, the annual valuation, and any acquisition. Investors and their counsel ask for it in the first week of diligence and check it against the stock ledger, board consents and the charter, so it has to tie to the share.
The workbook keeps one ledger row per issue or grant and builds the cap table from it by formula, on an issued and a fully diluted basis, with vesting at any date. The option pool sheet tracks reserved, granted, exercised and returned shares. A next round sheet models a priced round with an option pool increase and converts SAFEs and convertible notes at the lower of the cap price and the discount price. It uses plain startup finance arithmetic; counsel's closing table governs.
Who it is for
The founder or finance lead asked by a new investor or their counsel for a clean, fully diluted cap table and a pro forma for the round.
What is inside
- Holdings ledger with 12 worked rows and 20 blank rows: holder, type, class, shares, price, vesting, cliff and status
- Vested shares by formula at an as-of date, with monthly vesting after the cliff
- Cap Table sheet for 10 worked holders plus 12 blank rows: common, preferred, options and RSUs, warrants, % issued and % fully diluted
- Option Pool sheet: shares reserved by board approval, outstanding, exercised, cancelled and available
- Check lines that turn red when the cap table does not tie to the ledger
- Rounds sheet with price per share, shares issued and post-money valuation for each priced round
- Next Round sheet: round price, pool increase, 3 SAFEs and notes converting at the lower of cap price and discount price, and pro forma ownership for 8 groups
How to use it
Enter every share issue, option grant and warrant on the Holdings sheet, then list each holder once on the Cap Table sheet.
Files
- XLSXcap-table-template.xlsx22 KB
Opens in Microsoft Word or Excel, Google Docs or Sheets, and LibreOffice. Based on general finance practice, not on one published standard. A template to adapt, not legal, tax or accounting advice.
Questions about this template
What does fully diluted mean on a cap table?
Fully diluted ownership counts every share that exists or could exist: issued common and preferred stock, outstanding options, RSUs and warrants, and the unallocated option pool. Issued ownership counts only shares in issue. Investors usually price a round on the fully diluted count, so the template shows both columns side by side.
How does a SAFE convert in a priced round?
A SAFE with a valuation cap and a discount usually converts at the lower of two prices: the cap divided by the company capitalization defined in the SAFE, and the round price reduced by the discount. The Next Round sheet works out both and uses the lower one. Exact terms differ between SAFEs, so the documents decide.
Why does the option pool increase come before the round?
New investors often ask for the option pool to be topped up before they invest, so that the increase dilutes the existing holders and not them. The template adds the pool increase to the pre-money share count, which lowers the round price, and shows the pool as a percentage of the post-money fully diluted shares.




