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 Best Practice includes
1 Excel file, 1step by step online methodology
Adam Carver offers you this Best Practice for free!
download for free
Add to bookmarks
- Rate this Downloadable Tool
Write a review
- Tibor Rusiňák(last updated: 29/09/2019 19:20)
- Alexandr Marchenko(last updated: 25/07/2019 12:04)
- Budi Santoso(last updated: 04/07/2019 12:15)
- TownshendCatherine(last updated: 03/06/2019 20:58)
- 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 Best Practice also downloaded
Cap Table and Exit Waterfall Template for Excel and Google SheetsA Cap Table and Exit Waterfall template for Entrepreneurs and Investorsvaluationstartupsventure capitalcap tablecapitalization10,105add_shopping_cartfreeby Taylor Davidson
A Guide to Marketplaces: Handbook and SlidesA full guide dedicated and geared at Marketplace Startupsstartupsguidevcpdffree1,355add_shopping_cartfreeby Version One
A Simple Capitalization Table TemplateA quick example to get the hang of cap tables.cap tablefreedownloadcap table templatecap table example855add_shopping_cartfreeby Nick Moran
S3 Cap Table TemplateA cap table file to help entrepreneurs structure and understand their financing rounds and increase their performancevaluationfinancingstartupsventure capitalraising capital7,371add_shopping_cartfreeby S3 Ventures
Equity & Investment Cap Table Model TemplateAn Excel spreadsheet to model out cap table equity and dilution through your financing roundsinvestmentequitystartupsventure capitalraising capital1,818add_shopping_cartfreeby Giff Constable
VC Valuation Methods Excel Model with sensitivityAn Excel Model outlining different Startup Early Stage VC Valuation Methods (Quantitative and Qualitative).startupsfreedownloadcashing invaluation startups787add_shopping_cartfreeby David Stark
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 a4,859add_shopping_cartfreeby Kelly Hwang
Sample Cap Table (Pro-forma)Template for entrepreneurs to make their own capitalization tables.investorfundraisingstartupscap tablecapitalization2,119add_shopping_cart
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 modelstartupentrepreneurshipstartups877add_shopping_cartfreeby Attila Szigeti
Pitch Deck Template for Early Stage StartupsTo raise capital, use this strong pitch deck.investorstartupspitchvcfree765add_shopping_cartfreeby 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!