Cap Table templates
What is a Cap Table?
A capitalization table is a spreadsheet, typically used by start-ups or early stage ventures, that identifies the overall ownership structure of the company. The cap table depicts who owns what, how much each person/entity owns and what value is assigned to the stock they own – this can be in the form of equity shares, preferred shares, options and the many prices paid by stakeholders for such securities.
Who is included in the Cap Table and how are they ordered in the Cap Table?
There are several actors on the cap table, though this depends on the enterprise and who takes part in the business plan. There can be founders, executives, key employees as well as investors.
In terms of order, founders are usually listed on top. This is then followed by executives and key employees with equity stakes, investors (i.e angel investors and VC firms) and lastly, other parties that may be involved in the business plan.
Is a Cap table complex?
A cap table can vary in its complexity. For example, some may include new funding sources, mergers and acquisitions, public offerings or other potential transactions that do increase its complexity. In this scenario, it is included to increase the value of the enterprise, making it more attractive for prospective employees, investors and partners. Hence, it is ultimately dependent on the firm itself.
However, the complexity of a cap table changes over time. With more capital raised and potentially more actors being involved in your business plan, the cap table may become messy and hard to comprehend. This can occur when new agreements come into play with investors. They can bring along changes in liquidation preferences as well as different values for your equity, what you own and how much you have power over.
What makes up a cap table template?
There are some key aspects to a cap table. They are the following: post-money valuation, price-per-share, shareholders, how much shareholders paid for shares, and how percentage of ownership changes after pre and post-money.
These key elements making up the cap table build along the way by interconnecting with one another as well as being driven from the term sheet discussions.
How are the key elements derived in a cap table template?
They can be derived using specific formulas. They are the following:
- Post-Money Valuation = Pre-Money Valuation + Total Investment Amount
- Price-Per-Share = Pre-Money Valuation / Pre-Money Shares
- Post-Money Shares = Post Money Valuation/ Price-Per-Share
- Investor Percent Ownership = Investor Shares / Post-Money Shares
Can I make my own excel from a cap table template?
Building a cap table Is key to getting the hang of the technicalities that go into the investment for your start-up. For that reason, it is key to have one of your own. Nevertheless, constructing a cap table can seem daunting, but there are resources designed to simplify this. Cap Table templates can be found online additionally to step-by-step guides dedicated to facilitating the task for entrepreneurs.
For that reason, the Eloquens team has put all those cap table templates in one single platform. Below you will find excel files that only require you to enter inputs of your own and customize the cap table template to your enterprise, as well as guides on how to make a cap table model from scratch.
Feel free to have a look on your own, below!
To understand even more about cap table models, feel free to have a look at the links below:
- Sample cap table excel template with exclusive waterfall return analysis.283 remove_red_eyefreeby Alexander Jarvis
S3 Cap Table TemplateA cap table file to help entrepreneurs structure and understand their financing rounds and increase their performance148 remove_red_eyefreeby S3 Ventures
Dummy Cap Table & Returns Analysis - Round BExample Pro Forma Cap Table for a Series B company (three tranches of A, plus warrants)84 remove_red_eyefreeby Lindsay Meyer
Excel Cap Table with Waterfall for Start-UpsModel for pre-funded start-ups showing pre-money and post-money financing.120 remove_red_eyefreeby Prof. Zach Shulman
Equity Calculator model with Option Pool ExpansionModel cap table designed for founders to find company value and equity impact.91 remove_red_eyefreeby Carlos Eduardo Espinal
Sample Cap Table (Pro-forma)Template for entrepreneurs to make their own capitalization tables.66 remove_red_eyefreeby WUTIF Capital (VCC) Inc.
movieCap Table Excel ModelAn Excel Cap Table and Exit Waterfall for Entrepreneurs151 remove_red_eyefreeby Taylor Davidson
movieStarter Financial ModelBuild an initial forecast, cost budget, simple revenue forecast, cash flow analysis, funding needs, and cap table.146 remove_red_eye$75.00by Taylor Davidson
Equity & Investment Cap Table Model TemplateAn Excel spreadsheet to model out cap table equity and dilution through your financing rounds70 remove_red_eyefreeby Giff Constable
Startup Cap Table and Returns Model TemplateA Pro Forma Cap Table Model Template in Excel for entrepreneurs from Series A to Series B57 remove_red_eyefreeby Kelly Hwang
Startup Options Valuation Excel Model by Financing StageA straightforward option excel valuation model illustrating the impact of each financing stage on startup options.22 remove_red_eyefreeby David Teten
How to Build a Startup Cap Table: Excel TemplateI couldn’t find a good cap table template, so I built my own.23 remove_red_eyefreeby Adam Carver
A Simple Capitalization Table TemplateA quick example to get the hang of cap tables.27 remove_red_eyefreeby Nick Moran
Startup Cap Table Excel TemplateA fully customizable excel cap table template for startups of all stages to use when raising capital51 remove_red_eye$50.00by Timothée Demoures
- Your Cap Table Template
Have a Cap Table Template to share?Publish your template
Any questions on Cap Tables?
The user community is here to help. Go ahead!