This best practice allows you to calculate the capitalization (cap table) of your company after several successive funding rounds with the possibility to include 1) SAFE (simple agreement for future equity) and SAFE conversion, 2) Pro rata rights given to SAFE holders 3) the creation of a Management pool option.
This model will allow you to assess and understand the dilutive impact of SAFE conversion and Stock Options conversion and of multiple rounds of fundraising. This cap table model assumes that SAFE convert before Management Pool Option is created and that Seed round investors are NOT diluted by SAFE conversion and by shares issued for Management pool (ie. this is equivalent to say that new investors will invest on a fully diluted basis. This is very common market practice as you would not expect an investor to agree be diluted at time of investment.
The model also assumes that at time of exit all shares from the Management Option Pool have been allocated.
This model allows you to simulate 1 SAFE round, 1 Seed round with the creation of an option Management pool and 1 Series A round. For Seed round and Series A round, you have the possibility to model both capital raise and shares bought out / sold between existing shareholders. The model ends with a recap of cash flow by shareholders and gives return on investment metrics (IRR and Investment Multiples)
All the input of the model are colored in grey. All the other cells not colored in grey are automatically calculated. “Check” cells throughout the model should all be equal to 0.
I have also included notes throughout the whole model where I thought useful to give indication / explanation to the user of the model.
I have included 3 tabs with similar model to allow you to easily test and compare 3 different scenario.
As a bonus tab, I have included a model that demonstrate the difference in terms of value distribution between i) issuing shares to constitute a Management Option Pool and grant Management options to purchase these shares at a given strike price and ii) granting Management option to purchase shares from existing shareholders at a similar strike price.
Similar Products
Other customers were also interested in...
Due Diligence P&L – Exhaustive Revenue a...
Model for in depth understanding of high level profit and loss and revenue analysis. Big-4 like chec... Read more
Price Volume Mix Charts and Analysis – On re...
Best practice model for a complete Price Volume Mix (PVM) analysis on revenue and on gross profit by... Read more
Private Equity Fund Model (Investor Cashflows)
Private Equity Financial Model to analyze fund cashflows and returns available to Limited Partners (... Read more
All My Financial Models, Spreadsheets, Templates, ...
Lifetime access to all future templates as well! Here is a set of spreadsheets that have some of the... Read more
Cap Tables & Investor Returns Model
User-friendly Cap Table Model for a startup company or early-stage venture including multiple rounds... Read more
Advanced Financial Model with DCF & Valuation
General Overview Advanced Financial Model suitable for any type of business/industry and fully cu... Read more
Joint Venture and Fund Cash Flow Waterfall Templat...
Here are all the spreadsheets I've built that involve cash flow distributions between GP/LP. Include... Read more
Preferred Equity Cash Distribution Model – 2...
A 10-year joint venture model to plan out various scenarios for the way cash is shared between a GP ... Read more
3 Statement Financial Modeling with DCF & Rel...
Financial Modeling Tutorial guides user via step by step approach on how to build financial models w... Read more
Franchisor Licensing: Financial Model with Cap Tab...
Build up to a 10 year financial forecast with assumptions directly related to the startup and operat... Read more
You must log in to submit a review.