- Automotive Business
- Balance Sheet
- Bank Financial Models
- Black-Scholes -
- Capital Budgeting
- Cash Burn Rates
- Cash Flow
- Comparable Comps Analysis
- Corporate Finance
- Cost Analysis
- Debt Schedule
- Discounted Cash Flow (DCF)
- Economic Value Added
- Excel Add-Ins
- Excel VBA
- Financial Markets
- Financial Modeling
- Financial Projections -
- Hedge Fund
- Healthcare Financials
- Hotel Financial Models
- Income Statement
- Industry Specific Financial Models
- Investment Banking
- Inventory Management
- IPO (Initial Public Offering)
- IT (Information Technology) Business
- Leveraged Buyout (LBO)
- Loan Amortization
- Mergers & Acquisitions (M&A)
- ModelOff Samples
- Monte Carlo Simulation
- Mining Financials
- Net Present Value (NPV)
- Oil & Gas
- Options Pricing & Valuation
- Personal Finance
- Private Equity
- Real Estate Finance
- Renewable Energy Financials
- Restaurant Finance
- Return On Investment (ROI)
- Retail Finance
- Shipping Financials
- Scenario Analysis
- Sensitivity Analysis
- Stock Valuation
- Three Statement Financial Models
- Valuation Models
- Variance Analysis
- Venture Capital
- Weighted Average Cost Of Capital (WACC)
- Wealth Management
- Ansoff Matrix
- Balanced Scorecard
- BCG Growth-Share Matrix
- Business Model Canvas -
- Business Plans
- Competitor Analysis
- Consulting Proposals
- Due Diligence
- Executive Summary
- Heat Maps
- Logistics & Supply Chain Management
- Management Consulting
- Market Analysis
- Market Research
- Market Sizing
- Nine-Box Matrix
- PEST & PESTEL Analysis
- Sales -
- Strategic Planning
- SWOT Analysis
- Waterfall Charts
- Cohort Analysis
- Design Thinking Process
- E-Commerce Financial Models
- Growth Hacking
- Lean Startup
- Lifetime Value (LTV)
- Mobile App Finance
- Raising Capital
- Software-as-a-Service (SaaS)
- Startup Boards
- Startup Business Plans
- Startup Cap Tables
- Startup Financial Models
- Startup Investors
- KPI Dashboards
- Startup Lifestyle
- Startup Pitch Decks
- Startup Studios
- Startup Valuation
- Leadership & HR
Startup Cap Table templates
What is a Startup 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 startup 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 Startup 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 Startup Cap table complex?
A startup 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 startup 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 startup 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 startup 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 startup 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 startup cap table models, feel free to have a look at the links below:
- Lawyer level quality Excel Cap table template for investors or startup founders289 remove_red_eye$179.00by Alexander Jarvis
Startup Cap Table Excel Model TemplateA complete startup cap table to help you manage your fundraising with your investors.116 remove_red_eye$19.00by Mahender K. Punhani
Capitalization Table Excel TemplateThis template is a useful tool for a startup company or early-stage venture to list all the company’s securities.293 remove_red_eyefreeby CFI
Cap Table Excel ModelAn Excel Cap Table and Exit Waterfall for Entrepreneurs5,920 remove_red_eye
Ultimate Startup Cap Table and Return Analysis Excel TemplateSample cap table excel template with exclusive waterfall return analysis.2,874 remove_red_eye$9.00by Alexander Jarvis
Cap Table TemplateThis Cap Table template perfect for first-time entrepreneurs to list a company's securities.1,183 remove_red_eye
Capitalisation Templates with Waterfall AnalysisA solution, with examples, to help you manage all aspects of your company's cap table346 remove_red_eyefreeby Seraf
Cap Table Vesting Excel CalculatorUse to calculate vesting quarterly for personnel incentive ESOP plans.624 remove_red_eye
Startup Cap Table Excel TemplateA fully customizable excel cap table template for startups of all stages to use when raising capital1,267 remove_red_eye
How to Split Equity Among Co-FoundersAdvice for founders on how to divide equity between co-founders.167 remove_red_eye
Startup Excel Cap Table Template - EsharesLearn how a Startup Cap Table works with eShares simple and direct excel template.142 remove_red_eyefreeby Iman Malik
Cap Table Excel Template for Pre Series A CompaniesHow to Make a Cap Table for a Pre Series A Fundraising Round340 remove_red_eyefreeby EquityZen
Financial Model: Various Rounds of Investment Affecting Ownership, Waterfall Analysis, and IRR/Return Multiple AnalysisExcel Financial model for entrepreneurs looking to raise capital448 remove_red_eye
A Simple Capitalization Table TemplateA quick example to get the hang of cap tables.267 remove_red_eyefreeby Nick Moran
How to Build a Startup Cap Table: Excel TemplateI couldn’t find a good cap table template, so I built my own.229 remove_red_eyefreeby Adam Carver
Startup Options Valuation Excel Model by Financing StageA straightforward option excel valuation model illustrating the impact of each financing stage on startup options.787 remove_red_eyefreeby David Teten
- Have a Cap Table Template to share?
Your Startup Cap Table TemplatePublish your template
Any questions on Startup Cap Tables?
The user community is here to help. Go ahead!