Resources · Template
Cap table workbook
Excel workbook modelling common, preferred, options, and SAFE conversions across four rounds
Financial
pdf · 12 pages · Victor Chikezie Email required
What's inside the document?
- Founders tab with vesting schedules and 83(b) filing dates
- SAFE ledger that converts automatically at your priced round
Read an excerpt before you download.
Excerpt
1. Tab: SAFE ledger
Each SAFE row takes an amount, a post-money cap, and a discount. Conversion price is the lower of the cap price and the discounted round price, and the resulting share count feeds the waterfall automatically.
Excerpt
2. Tab: Waterfall
Preferred is modelled as 1x non-participating with a conversion check at each exit value, so you can see the exact point where investors convert to common.
Common filing mistakes this document prevents.
- Modelling the option pool post-money when your term sheet says pre-money.
- Forgetting that unissued pool shares still count in fully-diluted ownership.
- Keeping the only copy in one founder's personal Drive
- Read end to end