--- # === IDENTITY === id: finance/modeling/cap-table-modeling/2026 canonical_question: "How do I model a startup cap table — SAFE/note conversion waterfalls and liquidation stacks?" aliases: - "cap table model" - "capitalization table" - "equity waterfall analysis" - "SAFE conversion modeling" entity_type: concept domain: finance > modeling > Cap Table Modeling region: global jurisdiction: global temporal_scope: 2000-2026 # === VERIFICATION === last_verified: 2026-02-28 confidence: 0.91 version: 1.0 first_published: 2026-02-28 # === TEMPORAL VALIDITY === temporal_validity: status: stable last_breaking_change: null next_review: 2026-08-27 change_sensitivity: low # === CONSTRAINTS === constraints: - "SAFE and convertible note conversion math is instrument-specific — pre-money SAFEs, post-money SAFEs, and convertible notes convert differently and produce different dilution outcomes" - "Liquidation preferences cascade in reverse chronological order (last-in-first-out) — modeling order matters for multi-round waterfalls" - "Option pool placement (pre-money vs. post-money) significantly affects founder dilution — a 10% pre-money pool dilutes founders more than post-money" - "Requires legal document review — model must match actual term sheets, not generic assumptions" - "Prerequisite: must understand equity basics (common vs. preferred, authorized vs. issued vs. outstanding, fully diluted shares) before modeling" skip_this_unit_if: - condition: "User needs company P&L and cash flow projections, not equity ownership" use_instead: "finance/modeling/startup-financial-model/2026" - condition: "User needs to value the company, not model ownership" use_instead: "finance/modeling/dcf-framework/2026" - condition: "User needs per-customer profitability analysis" use_instead: "finance/modeling/unit-economics-framework/2026" inputs_needed: - key: "cap_table_need" question: "What does the user need to model?" type: choice options: - "Current cap table with existing SAFE/note conversions" - "Pro forma cap table for a new funding round" - "Exit waterfall showing payout distribution at various exit values" - "Dilution analysis across multiple future rounds" # === DISTRIBUTION === canonical_source: "https://knowledgelib.io/finance/modeling/cap-table-modeling/2026" suggested_citation: "Source: knowledgelib.io — AI Knowledge Library (verified 2026-02-28)" # === RELATED UNITS === related_kos: related_to: - id: "finance/modeling/startup-financial-model/2026" label: "Startup Financial Model" - id: "finance/modeling/scenario-analysis-framework/2026" label: "Scenario Analysis Framework" often_confused_with: [] depends_on: [] solves: [] alternative_to: [] # === SOURCES === sources: - id: src1 title: "Capitalization Table: Full Tutorial + Excel Example" author: Breaking Into Wall Street url: https://breakingintowallstreet.com/kb/venture-capital/capitalization-table/ type: technical_blog published: 2025-01-01 reliability: authoritative - id: src2 title: "Cap Table | Startup Template + Calculation Example" author: Wall Street Prep url: https://www.wallstreetprep.com/knowledge/the-ultimate-guide-to-capitalization-tables/ type: technical_blog published: 2025-01-01 reliability: high - id: src3 title: "SAFE Notes Explained: Video, Guide, and Excel File" author: Breaking Into Wall Street url: https://breakingintowallstreet.com/kb/venture-capital/safe-notes/ type: technical_blog published: 2025-01-01 reliability: high - id: src4 title: "Liquidation Preference: Full Tutorial + Excel Example" author: Breaking Into Wall Street url: https://breakingintowallstreet.com/kb/venture-capital/liquidation-preference/ type: technical_blog published: 2025-01-01 reliability: high --- # 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 (who owns what), conversion schedule (SAFE/note terms), option pool (granted, vested, available), and exit waterfall (payout distribution) [src1] - **Fully diluted basis**: Total shares = common + preferred + all converted SAFEs/notes + all exercised options — the denominator for ownership percentages [src2] - **SAFE conversion**: Post-money SAFEs convert at the lower of the valuation cap or discount rate, using the post-money valuation as the denominator for share price [src3] - **Liquidation preference**: Preferred investors receive their invested amount (1x or higher multiple) before common shareholders receive anything — 1x non-participating is the standard [src4] - **Waterfall order**: Liquidation preferences are satisfied in reverse chronological order (Series C before B before A before seed) [src4] ## Constraints - **Instrument-specific math**: Pre-money SAFEs, post-money SAFEs (Y Combinator standard since 2018), and convertible notes each have different conversion mechanics. Using the wrong formula produces incorrect dilution calculations. [src3] - **Liquidation preference stacking**: Multi-round companies with participating preferred can have 40-60% of exit proceeds consumed by liquidation preferences at lower exit values, leaving little for common shareholders. [src4] - **Option pool shuffle**: Whether the option pool is created pre-money or post-money significantly affects founder dilution. A 10% pre-money pool at a $10M pre-money valuation effectively reduces the founder's pre-money valuation by $1M. [src2] - **Must match legal documents**: The model must reflect actual term sheet provisions — anti-dilution protections, pay-to-play clauses, and participation caps all affect the waterfall. Generic templates miss these terms. [src1] - **Rounding and fractional shares**: Real cap tables must handle fractional shares from SAFE conversions and option exercises, which can create small discrepancies between the model and legal records. [src2] ## Framework Selection Decision Tree ``` START — User needs to model startup equity ├── What specifically? │ ├── Who owns how much equity today │ │ └── ✅ Cap Table Modeling — share ledger │ ├── How does a new round change ownership │ │ └── ✅ Cap Table Modeling — pro forma round model │ ├── What do investors get at exit │ │ └── ✅ Cap Table Modeling — exit waterfall │ ├── Company P&L, burn rate, runway │ │ └── → Startup Financial Model │ └── Company valuation │ └── → DCF Framework ├── Does the company have SAFEs or convertible notes? │ ├── YES → Model conversion mechanics before cap table │ └── NO → Standard share-based cap table └── How many funding rounds? ├── 1-2 rounds → Simple cap table ├── 3+ rounds with different preferences → Waterfall required └── Pre-funding → Cap table is just founders + option pool ``` ## Application Checklist ### Step 1: Build the share ledger - **Inputs needed**: Articles of incorporation, founder equity splits, all prior investment agreements, option pool size and grants - **Output**: Complete list of all shares (common, preferred by series), SAFEs, notes, and options with key terms - **Constraint**: Must distinguish between authorized, issued, outstanding, and fully diluted shares — using the wrong count produces incorrect ownership percentages [src1] ### Step 2: Model SAFE and convertible note conversions - **Inputs needed**: Each instrument's valuation cap, discount rate, interest rate (notes only), maturity date (notes only), pre-money vs. post-money designation - **Output**: Converted shares per instrument at the trigger event (typically a priced round) - **Constraint**: Post-money SAFEs include themselves in the denominator for conversion price — this is the critical difference from pre-money SAFEs and produces more dilution to founders [src3] ### Step 3: Build the pro forma cap table for the new round - **Inputs needed**: New round valuation (pre-money), investment amount, option pool increase (if any, and whether pre or post-money) - **Output**: Pro forma cap table showing ownership percentages for all stakeholders post-closing - **Constraint**: Option pool increases should be negotiated as post-money to minimize founder dilution — pre-money option pools effectively reduce the founder's valuation [src2] ### Step 4: Build the exit waterfall - **Inputs needed**: Complete cap table, liquidation preferences (1x, 2x, participating vs. non-participating, participation caps), exit value range - **Output**: Payout table showing each stakeholder's proceeds at various exit values (e.g., $10M, $25M, $50M, $100M, $500M) - **Constraint**: Model both "take the preference" and "convert to common" paths for each investor class — non-participating preferred investors will choose whichever is higher, creating a breakpoint [src4] ## Anti-Patterns ### Wrong: Treating pre-money and post-money SAFEs identically Founders model all SAFEs using pre-money math, underestimating dilution from post-money SAFEs (which include the SAFE itself in the post-money valuation denominator). This produces a cap table that shows more founder ownership than reality. [src3] ### Correct: Distinguishing SAFE types and applying correct conversion math Post-money SAFEs (Y Combinator standard since 2018) use post-money valuation as the denominator: conversion shares = investment / (post-money cap / total post-money shares). Pre-money SAFEs use the pre-money valuation. [src3] ### Wrong: Ignoring liquidation preference stacking at low exit values A founder expects a 50/50 split at a $20M exit, not realizing that $15M in stacked liquidation preferences leaves only $5M for common shareholders (25%, not 50%). [src4] ### Correct: Modeling the full waterfall at multiple exit values Build a waterfall table at 5+ exit values from low (1x invested capital) to high (10x+). Identify the breakpoint where investors switch from taking preferences to converting to common. [src4] ### Wrong: Placing the option pool pre-money without understanding the impact Founders agree to a "10% option pool" without realizing it is being created pre-money, effectively reducing their pre-money valuation by the pool size. [src2] ### Correct: Negotiating option pool placement explicitly Understand that a 10% pre-money pool at a $10M pre-money valuation reduces effective founder valuation to $9M. Negotiate for post-money pool placement or a smaller pre-money pool based on actual hiring needs. [src2] ## Common Misconceptions - **Misconception**: Ownership percentage equals payout percentage at exit. **Reality**: Liquidation preferences mean that preferred shareholders may receive a disproportionate share of proceeds at lower exit values. A 20% common shareholder may receive 5% of proceeds at a $20M exit if $15M goes to liquidation preferences first. [src4] - **Misconception**: A higher valuation cap on a SAFE is always better for founders. **Reality**: The valuation cap sets the maximum price at which the SAFE converts, but a very high cap with a large discount may produce more dilution than a lower cap with no discount. The interaction between cap and discount depends on the actual priced round valuation. [src3] - **Misconception**: Cap tables only matter at exit. **Reality**: Cap tables affect every financing decision — new rounds, employee grants, secondary sales, and even day-to-day governance (board seats, voting rights, protective provisions). Keeping the cap table accurate and current is an ongoing operational requirement. [src1] ## Comparison with Similar Concepts | Concept | Key Difference | When to Use | |---|---|---| | Cap Table Modeling | Tracks equity ownership and exit proceeds distribution | Fundraising, option grants, exit planning | | Startup Financial Model | Projects company P&L, cash flow, and runway | Revenue/expense forecasting and burn management | | DCF Framework | Estimates intrinsic company value from cash flows | Valuing the company (separate from who owns what share) | | Scenario Analysis | Tests model under different assumption sets | Modeling exit waterfall at various exit valuations | ## When This Matters Fetch this when a user asks about modeling a cap table, understanding SAFE or convertible note conversion, building an exit waterfall, calculating dilution from a funding round, or understanding liquidation preferences. Also relevant when founders need to negotiate round terms (valuation cap, option pool placement) or when investors need to model payout scenarios. ## Related Units - [Startup Financial Model](/finance/modeling/startup-financial-model/2026) - [Scenario Analysis Framework](/finance/modeling/scenario-analysis-framework/2026) - [Unit Economics Framework](/finance/modeling/unit-economics-framework/2026)