featured-image-1200x630 | eFinancialModels

This Excel model answers the two questions that decide whether a term sheet gets signed: who owns what after this round, and who gets what at exit.

Enter the cap table you have today, every SAFE and convertible note outstanding, and the terms of the priced round. The model converts each instrument at its own price, sizes the option pool, issues the new shares, and reports ownership before and after, dilution holder by holder, and the exit waterfall with liquidation preferences. Every figure is a live formula.

The problem this model exists to solve

In a priced round with converting instruments, three things depend on each other at the same moment. The price per share is the pre-money valuation divided by the fully diluted share count. The shares issued to a discounted SAFE or note depend on that price per share. The option pool top-up is sized as a percentage of the post-round total, which includes both of the above.

Written directly into a spreadsheet, that is a circular reference. Excel refuses to calculate it until you switch on iterative calculation — a setting that travels with the file on some machines and not others, that changes the answer depending on the maximum-iterations value, and that a diligence reader is entitled to distrust. Most cap table templates avoid the problem by ignoring it: they price the round off the pre-round count, which overstates the price per share and understates founder dilution.

This workbook solves the loop explicitly. The Conversion Engine tab runs twelve iterations across twelve columns. Each column takes the previous column’s fully diluted count, prices the round off it, reprices every discounted instrument, resizes the pool and produces a new count. The residual printed at the bottom shrinks to zero, and the Checks tab tests that it did.

What is inside

Twelve tabs: Read Me, Dashboard, Assumptions, Pre-Round Cap Table, SAFEs, Convertible Notes, Conversion Engine, Round Waterfall, Post-Round Cap Table, Exit Waterfall, Sensitivity and Checks. Eight SAFE rows, five convertible note rows, five pre-round holder lines and one priced round.

Post-money SAFEs convert at their cap to a fixed percentage of the company, the standard YC behaviour.
Pre-money SAFEs and notes convert at the better of cap price and discount — and the model shows which leg won.
Convertible notes accrue simple interest from issue date to the round closing date and convert with principal.
The option pool is sized to a target percentage of the post-round total, created either before the round, where founders bear it, or after, where everyone does.
Three scenarios — pre-money, new money, pool target and exit value — switch from a single cell.
The exit waterfall applies the preference to the preferred class, tests it against converting to common, and allocates proceeds, money multiples and share of exit to every holder. Non-participating, participating and participating-with-a-cap are all supported.
The Sensitivity tab reruns the whole waterfall across eight exit values, from a quarter of post-money to eight times it.

How it is built

No macros. No add-ins. No external links. No password protection, no locked cells, and no iterative calculation setting to enable. A worked example runs through the whole file: three founders, a 1,000,000-share option pool, six SAFEs, two bridge notes and a $6m round at a $20m pre-money. A five-page PDF guide documents every convention the model applies, along with its limitations, and is available here as a free download.

Twelve integrity checks sit on their own tab and must all read PASS: the cap table adds up to the solved share count, ownership sums to 100%, price per share times the pre-money count equals the pre-money valuation, the iteration converged, shares times conversion price returns the money converted for every instrument, the option pool hits its target, and the exit waterfall distributes exactly the exit value.

This workbook models the arithmetic of financing documents. It is not legal or tax advice.

You must log in to submit a review.