Cap Table Modeling

Definition

A capitalization table (cap table) model is a structured spreadsheet that tracks equity ownership in a company across all stakeholders — founders, employees (options/RSUs), investors (preferred shares, SAFEs, convertible notes) — and models how ownership changes through funding rounds, option grants, and exit events. The exit waterfall component calculates how proceeds from a sale or IPO are distributed based on liquidation preferences, participation rights, and conversion economics. [src1]

Key Properties

• Core components: Share ledger, conversion schedule, option pool, exit waterfall [src1]
• Fully diluted basis: Common + preferred + converted SAFEs/notes + exercised options [src2]
• SAFE conversion: Post-money SAFEs convert at lower of cap or discount, using post-money valuation as denominator [src3]
• Liquidation preference: Preferred investors receive invested amount (1x) before common; 1x non-participating is standard [src4]
• Waterfall order: Preferences satisfied in reverse chronological order (Series C before B before A) [src4]

Constraints

• Instrument-specific math: Pre-money SAFEs, post-money SAFEs, and convertible notes convert differently. [src3]
• Preference stacking: Multi-round companies can have 40-60% of exit proceeds consumed by preferences at low exits. [src4]
• Option pool shuffle: Pre-money vs. post-money pool placement significantly affects founder dilution. [src2]
• Must match legal documents: Anti-dilution, pay-to-play, participation caps all affect the waterfall. [src1]
• Rounding and fractional shares: SAFE conversions produce fractions that create small discrepancies. [src2]

Framework Selection Decision Tree

START — User needs to model startup equity
├── What specifically?
│   ├── Current ownership → Cap Table — share ledger
│   ├── New round impact → Cap Table — pro forma model
│   ├── Exit payouts → Cap Table — exit waterfall
│   ├── Company P&L, burn, runway → Startup Financial Model
│   └── Company valuation → DCF Framework
├── SAFEs or convertible notes outstanding?
│   ├── YES → Model conversion mechanics first
│   └── NO → Standard share-based cap table
└── How many funding rounds?
    ├── 1-2 rounds → Simple cap table
    ├── 3+ with different preferences → Waterfall required
    └── Pre-funding → Founders + option pool only

Application Checklist

Step 1: Build the share ledger

• Inputs needed: Articles of incorporation, investment agreements, option pool grants
• Output: Complete list of all shares, SAFEs, notes, options with terms
• Constraint: Distinguish authorized, issued, outstanding, and fully diluted shares [src1]

Step 2: Model SAFE and convertible note conversions

• Inputs needed: Valuation cap, discount rate, interest rate (notes), pre/post-money designation
• Output: Converted shares per instrument at trigger event
• Constraint: Post-money SAFEs include themselves in the denominator [src3]

Step 3: Build pro forma cap table for new round

• Inputs needed: Pre-money valuation, investment amount, option pool changes
• Output: Pro forma ownership percentages post-closing
• Constraint: Pre-money option pools reduce effective founder valuation [src2]

Step 4: Build the exit waterfall

• Inputs needed: Full cap table, liquidation preferences, participation rights, exit value range
• Output: Payout table at various exit values ($10M, $25M, $50M, $100M, $500M)
• Constraint: Model both "take preference" and "convert to common" paths — investors choose whichever is higher [src4]

Anti-Patterns

Wrong: Treating pre-money and post-money SAFEs identically

Using pre-money math for all SAFEs underestimates dilution from post-money SAFEs. [src3]

Correct: Distinguishing SAFE types with correct conversion math

Post-money SAFEs (YC standard since 2018) use post-money valuation as denominator. Pre-money SAFEs use pre-money. [src3]

Wrong: Ignoring liquidation preference stacking at low exit values

A founder expects 50/50 at $20M exit, but $15M in stacked preferences leaves only $5M for common. [src4]

Correct: Modeling the full waterfall at multiple exit values

Build at 5+ exit values from 1x to 10x+ invested capital. Identify the breakpoint where investors switch from preferences to conversion. [src4]

Wrong: Placing option pool pre-money without understanding impact

Agreeing to "10% pool" without realizing pre-money placement reduces effective founder valuation. [src2]

Correct: Negotiating option pool placement explicitly

A 10% pre-money pool at $10M pre-money reduces effective valuation to $9M. Negotiate post-money placement. [src2]

Common Misconceptions

Misconception: Ownership percentage equals payout percentage at exit.
Reality: Liquidation preferences mean preferred shareholders receive disproportionate proceeds at lower exits. A 20% common holder may receive 5% at a $20M exit. [src4]

Misconception: A higher valuation cap on a SAFE is always better for founders.
Reality: A high cap with large discount may produce more dilution than a lower cap with no discount. The interaction depends on the actual priced round valuation. [src3]

Misconception: Cap tables only matter at exit.
Reality: Cap tables affect every financing decision, employee grants, secondary sales, and governance. Accuracy is an ongoing requirement. [src1]

Comparison with Similar Concepts

When This Matters

Fetch this when a user asks about modeling a cap table, SAFE or note conversion, exit waterfalls, dilution from funding rounds, or liquidation preferences.