Publication number: ELQ-77411-1
View all versions & Certificate
How to Build a Startup Cap Table: Excel Template
I couldn’t find a good cap table template, so I built my own.
All start-ups talk equity; It doesn’t matter where – bars, cafés, or even at a lawyer’s office as he holds a brand new operating agreement. It is common for entrepreneurs to debate and obsess about equity, but ultimately it’s for a good reason.
Ownership depicts who takes decisions in an enterprise and who earns the biggest share when an acquisition occurs. A great product can eventually be worth a pretty penny, perhaps TRILLIONS of them, and in time the aim is to accumulate enough of those pennies to prove the risks we’ve taken today to bring those products to the market.
Cap tables are key, yet they are greatly misunderstood.
A small number of entrepreneurs truly comprehend the drivers and the consequences of how equity can change with time. Ownership can shift, convert, become diluted and vest in unexpected ways as startups raise the necessary capital from investors and employees become hired or even fired. These are all the events that do take place after all documents have been signed- and indeed, it can be a tricky situation to be in.
For that reason, understanding the math of venture funding can be greatly complicated for a newly founded company. But an instructive tool to use in these scenarios is a cap table. The capitalization table can help founders predict and prepare for the changes that will take place as funding happens and the ownership and control structure change.
Lately I’ve been helping companies build financial models before raising capital on their demo days at Techstarts NYC. These conversations naturally become related to equity, valuation, dilution and other fundraising strategies such as using convertible debt. As I got curious about the task at hand, I searched the interned for comprehensive cap tables and couldn’t manage to find one. So I decided to make one of my own and offer that template, without a cost, to anyone on the net who had asked themselves the same nerdy questions.
Hence, below you will find the best startup cap table on the internet – imho
This business tool includes
1 Excel file, 1step by step online methodology
Adam Carver offers you this business tool for free!
download for free
Add to bookmarks
- Joshua Jackson(last updated: 16/02/2019 02:35)
- Neusa Andrade(last updated: 03/12/2018 00:47)
- Steve Vannatta(last updated: 08/08/2018 16:59)
- Maggie Norris(last updated: 28/06/2018 04:21)
People using this tool also downloaded
Sample Cap Table (Pro-forma)Template for entrepreneurs to make their own capitalization tables.investorfundraisingstartupscap tablecapitalizationtemplatesampleangel investor1,574 remove_red_eye
A Guide to Marketplaces: Handbook and SlidesA full guide dedicated and geared at Marketplace Startupsstartupsguidevcpdffreedownloadmarketplacehandbook858 remove_red_eyefreeby Version One
VC Valuation Methods Excel Model with sensitivityAn Excel Model outlining different Startup Early Stage VC Valuation Methods (Quantitative and Qualitative).startupsfreedownloadcashing invaluation startupsvaluing startupstemplate valuationearly stage valuationtool valuation353 remove_red_eyefreeby David Stark
Cap Table and Exit Waterfall Template for Excel and Google SheetsA Cap Table and Exit Waterfall template for Entrepreneurs and Investorsvaluationstartupsventure capitalcap tablecapitalizationexit waterfallexit analysiscapitalization table6,766 remove_red_eye
S3 Cap Table TemplateA cap table file to help entrepreneurs structure and understand their financing rounds and increase their performancevaluationfinancingstartupsventure capitalraising capitalseries acap tableseries bownershipshareholders3,871 remove_red_eyefreeby S3 Ventures
Ultimate Startup Cap Table and Return Analysis Excel TemplateSample cap table excel template with exclusive waterfall return analysis.analysiswaterfallstartupcap tabletemplateexcelspreadsheetfreedownloadreturn analysis3,056 remove_red_eye$9.00by Alexander Jarvis
Startup Cap Table and Returns Model TemplateA Pro Forma Cap Table Model Template in Excel for entrepreneurs from Series A to Series Bstartupsentrepreneursventure capitalraising capitalseries acap tableseries bcapitalizationinvestor returns2,450 remove_red_eyefreeby Kelly Hwang
Equity & Investment Cap Table Model TemplateAn Excel spreadsheet to model out cap table equity and dilution through your financing roundsinvestmentequitystartupsventure capitalraising capitalcap tablerounds1,084 remove_red_eye
Pitch Deck Template for Early Stage StartupsTo raise capital, use this strong pitch deck.investorstartupspitchvcfreedownloaddeckpowerpointstep by step546 remove_red_eye
A Simple Capitalization Table TemplateA quick example to get the hang of cap tables.cap tablefreedownloadcap table templatecap table examplebasic cap table281 remove_red_eyefreeby Nick Moran
Any questions on How To Build A Startup Cap Table: Excel Template?
The user community and author are here to help. Go ahead!