Publication number: ELQ-90311-1
View all versions & Certificate
Startup Options Valuation Excel Model by Financing Stage
A straightforward option excel valuation model illustrating the impact of each financing stage on startup options.
Hereafter, you will find a capital table startup options valuation model that was created to value options for an early-stage startup with illiquidity.
It should be extremely valuable for founders as it will allow them (as well as their employees) to analyse equity compensation, or the options paid out, to founding team members and key employees.
You will find this model especially useful in employment negotiations.
This model is particularly designed in helping all team members of a startup understand what happens to their options at each fundraising round (ie: when there is a dilution effect). It can be really helpful to have a model that you can communicate to everyone in your organisation, as it shows that you are giving the same message to everyone on-board (including external consultants or people on the advisory board). It can also be helpful for founders looking for a co-founder or looking to hire a key employee.
As to illustrate what we call the "dilution effects", we have simulated a few investment rounds (business angels and VCs) along with the incrementation of employee options at different stages.
Special thanks to Raul Trevino, who worked closely with me to develop this options valuation financial model. Raul is a star forer Citi investment banker and Columbia MBA.
- David Teten & Raul Trevino
This business tool includes
1 Excel Model
David Teten offers you this business tool for free!
download for free
Add to bookmarks
- Vladimir Baydin Ph.D. MB(last updated: 06/11/2017 20:32)
People using this tool also downloaded
Dealing with Employee OptionsLearn how to value employee options and inserting this share in the value of your equity per share.financevaluationoptionsequitystock priceemployeeshares52 remove_red_eye
ESOP Plan Excel Template and Step by Step Guide to Retain and Attract Top StaffESOP plan done in excel to help your business recruit and keep the best employees.optionsstockfundraisingdilutionemployeesesop planemployee stock options37 remove_red_eye$59.00by Alexander Jarvis
The ESOP (Employee Share Ownership Plan) dilution Excel modelHow startup dilution works for founders with ESOPs and investment.startupscap tableownershipemployeedilutionesopowners115 remove_red_eye$9.00by Alexander Jarvis
How to Calculate Burn RateExplanation on how to calculate and reduce burn rate.valuationcash flowstartupsinvestingfinancial modellingburn ratecash poolimplicationsburn rate reductionNew!
How to Raise Capital: A Guide to Seed FundraisingWhat startup founders must know about raising seed funds to get their startups off the ground.fundraisingstartupsraising capitalseed fundraising892 remove_red_eyefreeby Geoff Ralston
Startup Executive Summary TemplateExplain your firm's main features in one page, to maximise your chance of raising funds.fundraisingstartupsraising capitalexecutive summary153 remove_red_eyefreeby Pejman Makhfi
Sample Cap Table (Pro-forma)Template for entrepreneurs to make their own capitalization tables.investorfundraisingstartupscap tablecapitalizationtemplatesampleangel investor771 remove_red_eye
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,337 remove_red_eyefreeby S3 Ventures
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 capitalinvestingfundingvc2,989 remove_red_eye
FCFE (Free Cash Flow to Equity) Valuation ModelA complete FCFE valuation model that allows you to capital R&D and deal with options in the context of a valuation modelfinancevaluationfirmpresent valuer&doptionsfcfefree cash flow to equity579 remove_red_eye
Any questions on Startup Options Valuation Excel Model By Financing Stage?
The user community and author are here to help. Go ahead!