Category: Stock Plan

  • 01 Pre-funding cap tables and equity grants

    TL;DR: If you’re the a founder of a new startup, it’s simple to use Excel to create your first capitalization table, calculate outstanding and fully diluted ownership, and create an option pool (stock plan) based on a target percentage using Tables, circular calculations and Goal Seek. Download the open-source cap table and the example spreadsheet.…

  • 03 First preferred equity financing and pool expansion

    TL;DR: Once you’re ready to raise a “real” equity round, such as Series Seed or Series A, use Excel to consider the effects of an option pool increase and the conversion of your SAFEs and convertible notes. Download the open-source cap table and the example spreadsheet. * * * As I discussed in the previous…