Productivity
Model a cap table
Ownership before and after a round, including the dilution nobody mentions.
Fill it in
Who owns what right now.
Amount, valuation, and whether the pool comes before or after.
Show what a bigger round or a lower valuation does.
Your prompt
Model this cap table. Today: [your today] The round: [the round] Get the pool timing right, because it is where founders lose points they did not know they were spending. A pool created PRE-money dilutes only the founders; the same pool created post-money dilutes everyone. The two produce different ownership from the same headline valuation, and the term sheet rarely spells it out. Show shares, not just percentages. Percentages hide the rounding and make the next round harder to model. Add scenarios: a larger raise, a lower valuation, and a bigger pool, so the sensitivity is visible rather than argued about. Deliver an .xlsx with live formulas off an inputs block.
Use Model a cap tableOpens with everything above already filled in.
Why this works
The option pool is where founders lose points they did not know they were spending: created pre-money it dilutes only them, created post-money it dilutes everyone, and the term sheet rarely spells it out. This models the timing explicitly and shows shares rather than percentages.
Questions
- Can I try different terms?
- Yes. It builds scenarios off an inputs block, so a lower valuation or a bigger pool is one cell.