A free cap table and exit waterfall template in Excel
A post-money SAFE converting at the seed, a seed and a Series A each with an option pool top-up in the pre-money, the fully diluted cap table after each round, and the liquidation waterfall at five exit values: five sheets, no macros, no circular reference.
The file follows two founders with 8.0 million shares and a 1.0 million share option pool. A 1.0 million SAFE at a 10 million post-money cap converts at the seed: 4.0 million at 16 million pre-money, with the pool topped up to 10%. The founders hold 62.0% after the seed. A 12.0 million Series A at 48 million pre-money and a pool of 12% takes them to 46.8%. At a 40 million exit the Series A keeps its 12 million preference while the SAFE and seed convert; the founders receive 16.4 million, 41% of the exit.
Get the template
One Excel file, no macros, nothing locked. Free: enter your email address and the download opens at once, along with the other 129 free models.
Cap_Table_and_Exit_Waterfall.xlsx (18 KB)
You join the reader list: one email when a new free model or a new book comes out, and a few notes on using the models. Leave in one click. Already on the list? Enter the same address. How your address is used.
The book behind this model
This model goes with Venture Capital, which explains the method behind it, chapter by chapter.
The Financial Model Library: all 130 models from this site in one download, organised by theme, plus two modelling books in DRM-free PDF (Financial Modeling from First Principles and Real Estate Financial Modeling).
This free file stays free. Secure checkout by Stripe.
Not on Amazon: 24 paperbacks by Julian R. Sterling on insurance and retirement, printed on demand and shipped worldwide. Browse the bookshop →
What is in the file
Five sheets. Inputs are blue cells on a pale blue fill on the Inputs sheet.
Read me
What the file does, its conventions, and why there is no circular reference.
Inputs
Founder shares, the pool, the SAFE amount and cap, the seed and Series A amounts, pre-money valuations and pool targets, and five exit values.
Rounds
Each round solved in closed form: pre-money shares, SAFE shares, pool increase, price per share and new shares.
Cap table
Shares and percentages before the seed, after the seed and after the Series A, with each class's preference and preference per share.
Waterfall and Checks
At each exit value, which classes convert, the preferences paid, the residual and each holder's payout; then the checks: all OK.
What the worked case returns
Measure
Value
Seed price per share
1.5500
SAFE conversion price
0.9688
Founders after the seed
62.0%
Series A price per share
3.5133
Founders after the Series A
46.8%
SAFE, seed, Series A after the A
6.0%, 15.1%, 20.0%
Founders at a 20m exit
2.39m
Founders at a 40m exit
16.40m
Founders at an 80m exit
37.48m
The pool top-up in the pre-money is paid for by the existing holders, not by the new investor. That is why a 20% Series A takes the founders from 62.0% to 46.8% rather than to 49.6%: the extra pool comes out of their share before the new money arrives.
How to use it on your own company
Enter founder shares and the existing pool on Inputs.
Enter the SAFE amount and cap, then each round's amount, pre-money and pool target.
Read the cap table after each round.
Enter the exit values you care about and read the Waterfall.
Questions people ask about it
Is this template really free?
Yes. The file costs nothing: you enter an email address, the download opens at once, and you can leave the reader list in one click.
Does it use macros or circular references?
No macros and no circular reference. The pool target and the SAFE conversion depend on the share count they create; the file solves that in closed form instead of letting Excel iterate.
How does a post-money SAFE convert?
The SAFE holder receives the SAFE amount divided by the post-money cap as a share of the company's capitalization just before the priced round, including the enlarged pool but not the new money: here 10%.
Is this legal advice?
No. Real documents vary (pro rata rights, participation, multiple preferences, conversion mechanics). The file shows the standard arithmetic on a fictional company.
Go further
For how venture investors price rounds, size reserves and read a cap table, Venture Capital and its companion workbooks go further.
LCR and NSFR calculatorLiquidity coverage and net stable funding built line by line, with encumbrance and six defensible readings.
Risk-weighted assets (RWA) calculatorStandardised against internal-model RWA, the mortgage loan split, CET1 ratios and the year the output floor binds.
Credit scorecard modelA points scorecard built from counts: bins, weight of evidence, information value and the leaking variable.
Price waterfall analysisList price to pocket price for one account and a whole company: nine leakages, ranked and added up.
If this book helped, or didn’t, a few lines on Amazon are worth more than they look: they are what the next reader goes on. Write a review. The template stays free either way.