Capitalization Table (Cap Table) Modelling
Training Introduction:
Capitalization table (Cap Table) modelling is a critical financial tool used to track the equity ownership, dilution, and value of securities in a company. Whether you’re a startup founder, investor, venture capitalist, or finance professional, understanding and building accurate Cap Tables is essential for investment decision-making, fundraising, exits, and employee compensation planning.
This 16-module course offers a practical, hands-on approach to Cap Table modelling — from basic structure to advanced waterfall and exit modelling. It will guide participants through various funding rounds, equity instruments (like SAFEs, convertible notes, preferred stock), dilution analysis, option pools, and how these influence ownership and returns for all stakeholders.
Participants will build Cap Table models in Excel, simulate real-world financing events, and apply best practices to manage complex ownership structures.
Course Objectives:
By the end of the training, participants will be able to:
- Understand the structure and purpose of a Cap Table
- Build and update Cap Tables through multiple funding rounds
- Model common equity instruments (preferred shares, options, SAFEs, convertibles)
- Analyze dilution and ownership impact
- Create waterfall models to calculate payouts at exit or liquidation
- Evaluate investor returns (IRR, MOIC)
- Manage option pools, vesting schedules, and founder dilution
- Prepare Cap Tables for fundraising, due diligence, and exit scenarios
Target Audience:
- Startup Founders and CFOs
- Financial Analysts and Associates
- Venture Capital and Private Equity Professionals
- Corporate Development Teams
- Legal and Compliance Advisors
- Business Students specializing in Entrepreneurship or Finance
Course Duration:
4 Weeks (Typically delivered over 10 days or as an intensive bootcamp)
Course Content
Module 1: Introduction to Capitalization Tables
- What is a Cap Table and why it matters
- Key stakeholders and use cases
- Overview of equity instruments: common vs. preferred stock
- Cap Table components and layout
Module 2: Structuring the Initial Cap Table
- Founders’ shares and initial ownership
- Setting up equity classes in Excel
- Modelling authorized vs. issued shares
- Understanding pre-money and post-money concepts
Module 3: Modelling Seed and Angel Rounds
- Adding first external investors
- Calculating pre- and post-money ownership
- Impact of new equity on founder dilution
- Round-based Cap Table layering
Module 4: Option Pool Modelling
- Creating and resizing option pools
- Pre-money vs. post-money option pools
- Impact of option pool on investor dilution
- Modelling unallocated vs. allocated options
Module 5: Series A and Beyond – Modelling Preferred Equity
- Preferred shares vs. common equity
- Participating vs. non-participating preferred stock
- Liquidation preference structures
- Pro rata and anti-dilution rights
Module 6: Convertible Notes and SAFEs
- What are SAFEs and convertible notes?
- Modelling conversion at qualifying rounds
- Discounts and valuation caps
- Impact on ownership and dilution
Module 7: Dilution Analysis and Ownership Tracking
- Tracking changes across rounds
- Fully diluted ownership vs. issued shares
- Percentage ownership, voting rights, and economic rights
- Visualizing dilution over time
Module 8: Modelling Vesting Schedules and Employee Equity
- Time-based and milestone-based vesting
- Cliff periods and acceleration clauses
- Modelling equity grants over time
- Cap Table adjustments for vested vs. unvested equity
Module 9: Pro Forma Cap Table and Round Planning
- Building a pro forma Cap Table for future rounds
- Preparing Cap Tables for fundraising
- Scenario modelling: "what-if" equity events
- Investor pitch readiness and documentation
Module 10: Exit Waterfall Modelling – Introduction
- What is a liquidation waterfall?
- Calculating proceeds at different exit valuations
- Liquidation preferences and multiple scenarios
- Priority stack: seniority, participating, common conversion
Module 11: Exit Waterfall – Advanced Modelling
- Multiple preference classes and layered stack
- Participating preferred with caps
- Catch-up provisions and clawbacks
- Case-based exit modelling
Module 12: Modelling IRR and MOIC for Investors
- Modelling investor returns at exit
- IRR vs. MOIC (multiple on invested capital)
- Calculating break-even and cap table thresholds
- Return sensitivity analysis
Module 13: Advanced Excel Cap Table Techniques
- Dynamic formulas for share tracking
- Data validation and dropdowns for round assumptions
- Sensitivity tables and graphs
- Error-proofing complex models
Module 14: Cap Table Compliance and Legal Considerations
- Common legal terms and structures in Cap Tables
- Legal documents: stock purchase agreements, term sheets, equity plans
- Regulatory compliance and cap table hygiene
- Preparing for due diligence and audits
Module 15: Cap Table Software vs. Spreadsheet Models
- Overview of leading Cap Table software (e.g., Carta, Pulley, Eqvista)
- When to use software vs. Excel
- Integration with legal and HR platforms
- Transitioning from spreadsheet to cloud platforms
Module 16: Cap Table Case Study and Final Project
- Real-world case: multi-round startup Cap Table
- Model SAFEs, notes, options, preferred equity, and exit
- Create summary dashboards for founders and investors
- Present Cap Table and exit scenario to panel or instructor
Assessment and Certification:
- Hands-on modelling exercises after each module
- Final Cap Table build-out and scenario analysis project
- Certificate of Completion for successful participants
Delivery Methods:
- Live instructor-led (virtual or in-person)
- Excel-based templates for all models
- Real-world scenarios and investor simulations
- Optional graded project for certification
- Downloadable resources and Cap Table calculators
Pre-Requisites:
- Basic knowledge of Excel and financial concepts
- Familiarity with startup finance or equity structures is helpful
- No advanced modelling experience required for beginners
