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 business tool includes
1 Excel sheet, 1 methodology
Carlos Eduardo Espinal offers you this business tool for free!
download for free
Add to bookmarks
- No review yet!
People using this tool also downloaded
Startup Excel Cap Table Template - EsharesLearn how a Startup Cap Table works with eShares simple and direct excel template.simpleequitystartupraising capitalcap tableeasyesharesfounder159 remove_red_eyefreeby Iman Malik
Ultimate Startup Cap Table and Return Analysis Excel TemplateSample cap table excel template with exclusive waterfall return analysis.analysiswaterfallstartupcap tabletemplateexcelspreadsheetfreedownloadreturn analysis2,951 remove_red_eye$9.00by Alexander Jarvis
Equity & Investment Cap Table Model TemplateAn Excel spreadsheet to model out cap table equity and dilution through your financing roundsinvestmentequitystartupsventure capitalraising capitalcap tablerounds1,031 remove_red_eye
Cap Table Excel Template for Pre Series A CompaniesHow to Make a Cap Table for a Pre Series A Fundraising Roundtoolequityventure capitalcap tablecapitalizationexcelspreadsheetpre series adownloadable397 remove_red_eyefreeby EquityZen
Subscription E-Commerce Fundraising Financial ModelCombining an e-commerce product sales model & a subscription model to make one subscription e-commerce fundraising modelplanningfinancial modelstartupfundraisingsubscriptionecommercetemplateexcelspreadsheetgrowing302 remove_red_eye$199.00by Alexander Jarvis
Profit & Loss Statement Template in ExcelThis is a blank Profit & Loss Statement (or Income Statement) made in Excel.income statementaccountingexpensesfinancial statementtemplateexcelspreadsheetbookkeepingprofit and lossprofit and loss statement425 remove_red_eyefreeby Sarah Booysen
Personnel Forecast Excel Model TemplateHow to create detailed headcount forecasts using excelmodelexpensesforecasttemplateexceloperating expensesemployeesstaffwagespersonnel1,130 remove_red_eyefreeby Ben Murray
Generic Startup Financial Projection 3 statement Excel ModelUser-friendly model for preparing a financial projection for a startup businessfinancialincome statementprojectionmodelforecastbalance sheetstartuptemplateexcelraising fundscashflowgeneric3 statement201 remove_red_eye$50.00by Projectify
Discounted Cash Flow (DCF) Excel Model TemplateDiscounted Cash Flow Model provide an estimated investment return by discounting future cash flows to a present value.dcfdiscounted cash flowtemplateexceldiscounted cash flow analysisdcf modeldcf valuationdiscounted cash flow modelwhat is dcfdiscounted cash flow calculatordcf formuladiscounted cash flow formula31 remove_red_eyefreeby Henry Sheykin
Mobile App / Website - 5 Year Recurring Revenue Excel Model TemplateA financial forecasting excel model template for apps or websites that have recurring paid subscribers.dcfsensitivity analysissaasrecurring revenuetemplateexcelspreadsheetfinancial forecastwebsite startupstartup business modelmobile app668 remove_red_eye$95.00by Jason Varner
Any questions on Equity Calculator Model With Option Pool Expansion?
The user community and author are here to help. Go ahead!