Skip to main content

> tpl_stv_008

Cap Table and Dilution Scenario Model

Venture capitalization table and dynamic dilution modeling framework tracking founder common shares, post-money SAFEs / convertible notes, employee stock option pools (ESOP unallocated vs issued), priced preferred rounds (Series Seed/A/B), and exit liquidation preference waterfalls.

TEMPLATE // INSPECT: TPL-STV-008MODIFIED: 2026-09-19
CATEGORYStartup, Founder & VC
VERSIONv1.0.0
RISK LEVELMEDIUM
ARTIFACT CLASSXLS
FORMATSPDF, MD, MERMAID, SVG, XLSX
AI & EXECUTIVE SUMMARY

Capitalization table and dilution simulator modeling SAFE conversions, option pool expansions, and exit waterfalls.

Important Tech Document Template & Operational Notice

TinyCTO.tv Tech Document Template Notice: This template is a general educational and operational starting point. It is not legal, tax, accounting, investment, procurement, regulatory, security or certification advice. Requirements vary by jurisdiction, organization, contract and risk. Review and adapt it with qualified professionals before relying on it.

Problem Solved

Founders sign uncoordinated SAFEs with varying valuation caps, agree to investor option-pool "shuffle" demands, and fail to calculate conversion dilution, waking up after Series A with their ownership slashed below 25%.

When to Use

  • Modeling equity dilution across multi-tranche convertible SAFEs, note conversions, and priced preferred equity rounds
  • Calculating the impact of pre-money vs post-money option pool expansion requirements from lead VC investors
  • Simulating exit payouts and net proceeds across common and preferred share classes using liquidation preference waterfalls

When NOT to Use

  • For overarching operating budgets, P&L forecasts, and monthly cash burn rate calculations (use TPL-STV-005)
  • For corporate statutory share certificates, minutes of board meetings, and register maintenance (use TPL-GOV-018)

5 Template Sections & Structural Outline

1. 1. Foundation Cap Table Architecture and Share Classesstandard, enterprise

Structuring initial capitalization: Founder Common Stock, 4-year vesting with 1-year cliff, 83(b) election records, and authorized vs issued share counts (typically 10M shares at inception).

Guidance:Every founder must execute an 83(b) tax election within 30 days of stock issuance; failing this creates disastrous tax liabilities.
2. 2. Convertible Instrument Mechanics (Post-Money SAFEs and Notes)standard, enterprise

Modeling conversion dynamics: Valuation Caps, Discount Rates (typically 20%), Most Favored Nation (MFN) clauses, and interest accrual on convertible debt.

Guidance:Use standardized YC Post-Money SAFEs to make dilution deterministic before entering a priced preferred round.
3. 3. Priced Round Mechanics and Share Price Calculationstandard, enterprise

Calculating Series A mechanics: Pre-Money Valuation / Pre-Round Fully Diluted Shares = Original Issue Price (OIP). Tracking shares issued to incoming investors and new ownership splits.

Guidance:Verify whether the option pool is calculated pre-money (founder absorbs 100% of dilution) or post-money (shared dilution).
4. 4. The Option Pool Shuffle and Equity Governancestandard, enterprise

Modeling the Employee Stock Option Pool (ESOP): sizing the unallocated pool (typically 10-15% post-Series A) to fund critical executive hires over the next 18-24 months.

Guidance:Negotiate the option pool size based on a detailed hiring plan rather than accepting a generic 15% investor boilerplate demand.
5. 5. Exit Liquidation Preference Waterfall Modelingstandard, enterprise

Simulating exit scenarios ($10M to $500M): evaluating 1x Non-Participating vs Participating Preferred, liquidation seniorities (pari passu vs tiered), and calculating net dollar payouts to founders.

Guidance:Model your exit waterfall across multiple enterprise valuation scenarios before signing any term sheet.

Completion Instructions

1. Review blank document. 2. Adapt worked scenario to company scale. 3. Validate against review checklist.

Independent Review Checklist

  • All mandatory sections completed
  • No secrets or passwords included
  • Executive sponsor sign-off obtained
WORKED SCENARIO SHOWCASE

Cap Table and Dilution Scenario Model - Worked Case Study

Fictional Entity: Generative Enterprise Knowledge Graph Platform

Real-world production case study demonstrating complete operational adoption for Generative Enterprise Knowledge Graph Platform.

Key Highlights & Outputs:
  • Engineered multi-SAFE conversion and Series A cap table model preventing 8% excess founder dilution
  • Negotiated option pool expansion from 15% down to 10.5% based on bottom-up executive hiring roadmap
  • Simulated exit liquidation waterfall across 5 acquisition price scenarios, protecting common equity value

Frequently Asked Questions

What is the "Option Pool Shuffle" and how does it affect founders?

The Option Pool Shuffle occurs when an incoming VC insists that a new employee stock option pool (e.g. 10-15%) be created *pre-money* (out of the existing cap table). This forces existing common shareholders (founders) to absorb 100% of the dilution, effectively lowering the true valuation the investor is paying.

Why did Y Combinator switch from Pre-Money SAFEs to Post-Money SAFEs?

With Pre-Money SAFEs, multiple SAFE holders diluted each other and founders in complex, circular mathematical ways that made it impossible to know exact ownership until the priced round. Post-Money SAFEs fix the ownership percentage at the time of signing (e.g. $1M on a $10M cap = exactly 10%), providing complete clarity.

What is a liquidation preference waterfall?

A liquidation preference waterfall models how cash proceeds from an acquisition or IPO are distributed among share classes. Preferred investors with a 1x preference get their original investment back first before common shareholders receive a single dollar, unless preferred shares convert to common.

Download Tech Document Pack

Auth Required
Free instant downloads require a quick sign in or registration.
Complete Tech Document Pack (.zip)
12 Files

Download all blank templates, worked scenarios, and verification manifests in a single verified archive.

Individual Artifacts (.zip)
TPL-STV-008-Cap-Table-and-Dilution-Scenario-Model-Blank-EN.xlsxXLSX
all9.9 KB
TPL-STV-008-Cap-Table-and-Dilution-Scenario-Model-Example-EN.xlsxXLSX
all9.9 KB
TPL-STV-008-Cap-Table-ve-Sulandirma-Senaryo-Modeli-Bos-TR.xlsxXLSX
all9.9 KB
TPL-STV-008-Cap-Table-ve-Sulandirma-Senaryo-Modeli-Ornek-TR.xlsxXLSX
all10.0 KB
TPL-STV-008-Cap-Table-and-Dilution-Scenario-Model-Blank-EN.pdfPDF
all100.4 KB
TPL-STV-008-Cap-Table-and-Dilution-Scenario-Model-Example-EN.pdfPDF
all100.0 KB
TPL-STV-008-Cap-Table-ve-Sulandirma-Senaryo-Modeli-Bos-TR.pdfPDF
all235.1 KB
TPL-STV-008-Cap-Table-ve-Sulandirma-Senaryo-Modeli-Ornek-TR.pdfPDF
all241.1 KB
TPL-STV-008-Cap-Table-and-Dilution-Scenario-Model-Blank-EN.mdMD
all2.5 KB
TPL-STV-008-Cap-Table-and-Dilution-Scenario-Model-Example-EN.mdMD
all2.6 KB
TPL-STV-008-Ortaklik-Yapisi-ve-Seyrelme-Senaryo-Modeli-Bos-TR.mdMD
all2.7 KB
TPL-STV-008-Ortaklik-Yapisi-ve-Seyrelme-Senaryo-Modeli-Ornek-TR.mdMD
all2.8 KB
Verified SHA-256 · Zero Macros Verified Archive
Every download includes an authoritative MANIFEST.json