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
- Dan Fordyce(last updated: 12/03/2019 03:07)
- 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
VC Valuation Methods Excel Model with sensitivityAn Excel Model outlining different Startup Early Stage VC Valuation Methods (Quantitative and Qualitative).startupsfreedownloadcashing invaluation startups474free by David Stark
Sample Cap Table (Pro-forma)Template for entrepreneurs to make their own capitalization tables.investorfundraisingstartupscap tablecapitalization1,733
Cap Table and Exit Waterfall Template for Excel and Google SheetsA Cap Table and Exit Waterfall template for Entrepreneurs and Investorsvaluationstartupsventure capitalcap tablecapitalization7,849free by Taylor Davidson
S3 Cap Table TemplateA cap table file to help entrepreneurs structure and understand their financing rounds and increase their performancevaluationfinancingstartupsventure capitalraising capital5,008free by S3 Ventures
A Guide to Marketplaces: Handbook and SlidesA full guide dedicated and geared at Marketplace Startupsstartupsguidevcpdffree1,013free by Version One
Simple Startup Studio Financial Excel ModelThis is a simple startup studio financial modeling tool, to model cap table progression, cash flow, studio funnel...cash flowfinancial modelstartupentrepreneurshipstartups228free by Attila Szigeti
Equity & Investment Cap Table Model TemplateAn Excel spreadsheet to model out cap table equity and dilution through your financing roundsinvestmentequitystartupsventure capitalraising capital1,287free by Giff Constable
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 a3,300free by Kelly Hwang
Ultimate Startup Cap Table and Return Analysis Excel TemplateSample cap table excel template with exclusive waterfall return analysis.analysiswaterfallstartupcap tabletemplate3,318$9.00 by Alexander Jarvis
Pitch Deck Template for Early Stage StartupsTo raise capital, use this strong pitch deck.investorstartupspitchvcfree615free by Federico Wengi
Any questions on How To Build A Startup Cap Table: Excel Template?
The user community and author are here to help. Go ahead!