Publication number: ELQ-25978-1
View all versions & Certificate
Equity & Investment Cap Table Model Template
An Excel spreadsheet to model out cap table equity and dilution through your financing rounds
As a startup founder, it is often difficult to understand how your equity ownership stake evolves as you raise capital across multiple financing rounds - with progressive dilution from the arrival of new investors and the emission of employee options.
As when thinking about a startup, I try to see how I can share my modeling tools, you will find here an excel spreadsheet which enables you to model out cap table equity and dilution according to your different capital raising rounds.
To do this you can also use this cool tool available online ownyourventure.com, but personally I prefer to user Excel as it allows me to integrate and model the particularities of a given situation.
Like in all my models, the inputs are in blue and can be customized according to your situation.
While, the equity model has as outputs at the bottom of the table several exit multiples, it does not integrate any special treatment for investor shares such as participating preferred, etc. However, I did include an extra tool in the second tab in the spreadsheet. It is an exercise for a training session I did on VC structures quite some time ago. If you (unfortunately) have to consider liquidation and participation preferences it shows their results and effect on investor returns.
I hope this equity & investment cap table template in Excel will be useful for you. If you spot a bug (I hope not - as I have tried to make it error-free), feel free to let me know in the discussion feed below. Also, happy to have your feedback!
- Giff Constable
This business tool includes
1 Excel Cap Table Model Template
Giff Constable offers you this business tool for free!
download for free
Add to bookmarks
- No review yet!
People using this tool also downloaded
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 returns945 remove_red_eyefreeby Kelly Hwang
S3 Cap Table TemplateA cap table file to help entrepreneurs structure and understand their financing rounds and increase their performancevaluationfinancingstartupsventure capitalraising capitalseries acap tableseries bownershipshareholders1,609 remove_red_eyefreeby S3 Ventures
Startup Cap Table Excel TemplateA fully customizable excel cap table template for startups of all stages to use when raising capitalinvestorsfundraisingventure capitalraising capitalseedseries acap tableseries bseries c725 remove_red_eye
Cap Table TemplateThis Cap Table template perfect for first-time entrepreneurs to list a company's securities.financestartupinvestorsventure capitalraising capitalcap tableshareholdersfounderscontrol302 remove_red_eye
Cap Table Excel ModelAn Excel Cap Table and Exit Waterfall for Entrepreneursstartupsventure capitalcap tablecapitalizationexit waterfallexit analysiscapitalization table3,276 remove_red_eye
Startup Financial Model TemplateA simple financial model for an early-stage startup/anyone building a model for a companyfinancefinancial modelentrepreneurshipstartupsearly-stageend-to-endstandard financial statementsventure capitalkey operating metricsraising capital3,314 remove_red_eyefreeby David Teten
Liquidation Model - Waterfall AnalysisEducate employees, founders, and others in how liquidation preferences affect financial distribution in exit scenariosfinancestartupsventure capitalraising capitalliquidation preferencesfinancial distributionventuresexitsliquidation modelwaterfall analysis1,741 remove_red_eye
Freemium Business ModelCustomize a ready-made financial model for your Freemium Web Services Businessfinancemodelingfinancial modelstartupsventure capitalraising capitalfreemiumuser acquisitionuser activationentrepreneur2,145 remove_red_eye
Startup Valuation VC Method + excel SpreadsheetExcel template made to understand how VCs value the money that will be used to invest in a startupvaluationentrepreneurshipstartupsventure capitalraising capitalinvestingfundingvc3,626 remove_red_eye
Startup Excel Cap Table Template - EsharesLearn how a Startup Cap Table works with eShares simple and direct excel template.simpleequitystartupraising capitalcap tableeasyesharesfounder97 remove_red_eyefreeby Iman Malik
Any questions on Equity & Investment Cap Table Model Template?
The user community and author are here to help. Go ahead!