Publication number: ELQ-70909-1
View all versions & Certificate
Equity Calculator model with Option Pool Expansion
Model cap table designed for founders to find company value and equity impact.
During the SeedCamp’s hackathon, Ali, Will and myself decided to bring sources together to help entrepreneurs understand how it is that equity is raised and the consequences it may have on the founders.
This means that we aim at making founders aware and understanding of the figures as well as the negative effects of raising capital and giving away equity.
When it comes to finding the value of your company and getting to those last definitive calculations depicting the effects on your equity, you may find yourself in a very tedious and confusing process, which is why we are here to help!
The downloadable tool includes the sample excel model as well as the online methodology.
For you to further understand the terminology in this cap table, you may find exact terms in the online methodology of this model. It explains pre-post money valuation, option pools and round size.
Do keep In mind that the model is for illustration purposes, so do consult with an advisor if you are to use the model as your own. Also, the model does not include convertible note conversions and it is currency agnostic.
In case you want to use convertible notes and include them in your round, you can use this variant of the model attached with notes on how to do the conversion: http://bit.ly/17kHlSA
For the model to work, run it on Excel and with the circular calculations switched on. You may do this by going to Preferences (Macbook Excel) then, calculation, followed by iteration and lastly, click on limit iteration.
This Best Practice includes
1 Excel sheet, 1 methodology
Carlos Eduardo Espinal offers you this Best Practice for free!
download for free
Add to bookmarks
- Rate this Downloadable Best Practice
Write a review
- Tibor Rusiňák(last updated: 19/07/2021 08:41)
- Mohamed Africa(last updated: 04/05/2021 23:43)
- Isaac Tony Havilah(last updated: 23/04/2021 10:47)
- Peter A. Lukas(last updated: 26/11/2019 18:50)
- Charles.HA. Chen(last updated: 01/08/2019 02:05)
- Alex Walker(last updated: 21/07/2019 05:21)
- Nelson Pigossi Jr.(last updated: 03/04/2019 15:19)
People using this Best Practice also downloaded
Startup Excel Cap Table Template - EsharesLearn how a Startup Cap Table works with eShares simple and direct excel template.simpleequitystartupraising capitalcap table1,050add_shopping_cartfreeby Iman Malik
Equity & Investment Cap Table Model TemplateAn Excel spreadsheet to model out cap table equity and dilution through your financing roundsinvestmentequitystartupsventure capitalraising capital2,670add_shopping_cartfreeby Giff Constable
Cap Table Excel Template for Pre Series A CompaniesHow to Make a Cap Table for a Pre Series A Fundraising Roundtoolequityventure capitalcap tablecapitalization733add_shopping_cartfreeby EquityZen
Ultimate Startup Cap Table and Return Analysis Excel TemplateSample cap table excel template with exclusive waterfall return analysis.analysiswaterfallstartupcap tabletemplate3,951add_shopping_cart$9.00by Alexander Jarvis
Pharma Healthcare Stock Pitch - Excel Model TemplateThis is a ready-to-use stock pitch template for those wanting to summarise an investment idea.investmentequitypitchtemplateexcel380add_shopping_cartfreeby Wall Street Oasis
Mobile App (Social & Games) Financial Model (Premium Version)Financial model template for any Mobile App business (Premium version). Including 1 hour walkthrough video.business planfinancial modelfinancial projectionsfinancial plantemplate475add_shopping_cart$99.00by Remi Goncalves
Startup Pitch Deck Template & GuideDeck Template and Guide for how to attract investors (focused on Seed and Series A)investmentpresentationstartupfundraisingguide904add_shopping_cart$50.00by Evan Diaz de Arce
Random Number GeneratorGenerate, randomize and sort numbers in Excel thanks to this Random Number Generator!templateexcelnumber generator151add_shopping_cartfreeby Someka
Hemp Business - Financial Excel TemplateThis is a simple template model to create financial projections for hemp business for cultivating activity in the US.investmentfinancialmodelirrtemplate840add_shopping_cart$25.00by Fin team consult
Enterprise SaaS and SME/Consumer Fundraising Excel ModelFor large, complex SaaS companies with enterprise, consumer and SME customers looking to fundraise.modelinvestorsstartupsventure capitalsaas4,621add_shopping_cart$1,454.00by Alexander Jarvis
Any questions on Equity Calculator Model With Option Pool Expansion?
The user community and author are here to help. Go ahead!