Transform Your Future: Go From Cap Table Confusion to VC-Ready
Master VC-grade Excel cap tables step-by-step. Ace interviews, fundraise confidently, and walk into any VC interview prepared.
Your Bridge to VC Job Offers & Confident Fundraising
Master VC-Grade Financial Modeling: -> Build the complex, accurate models VCs expect, proving your skills to potential employers or investors.
Decode SAFEs, Notes & Conversions: -> Gain the ability to confidently analyze and negotiate any early-stage term sheet, armed with precise ownership calculations vital for VCs and founders.
Conquer Anti-Dilution & Waterfalls: -> Develop the skill to precisely model and explain complex anti-dilution and waterfall scenarios, essential for acing interviews and analyzing returns.
Model Proforma Scenarios Flawlessly: -> Clearly visualize and model the impact of future funding rounds or exits, empowering strategic decision-making when investing or fundraising.
Fundraising Fluent: Speak the language of VCs and negotiate effectively.
Scenario Strategist: Confidently analyze future financial outcomes.
Welcome & Mastering the VC Math Mindset (Why precision matters)
Before we begin...
Course Structure, Excel Resources, and How to Succeed
Lesson 1.1: What is a Capitalization Table? Core Purpose & Key Stakeholders (Founders, Investors, Employees)
Lesson 1.2: Why Cap Tables Are Non-Negotiable
Lesson 1.3: Essential Terminology Part 1: Common Stock, Preferred Stock, Authorized vs. Issued vs. Outstanding Shares
Lesson 1.4: Essential Terminology Part 2: Options, Warrants, Fully Diluted Shares, Price Per Share
Lesson 2.0: Designing Your VC-Quality Excel Template: Best Practices for Structure & Clarity
Lesson 2.1: Step-by-Step: Modeling Initial Founder Shares & Common Stock Issuances
Lesson 2.3: Incorporating the Employee Stock Option Pool (ESOP): Creation & Initial Allocation
Lesson 2.4: Modeling Stock Option Grants: Vesting Schedules & Tracking (Granted, Vested, Exercised, Forfeited)
Lesson 2.5: Calculating Ownership on a Fully Diluted Basis (Pre-Investment)
Lesson 3.0: Introduction to Proforma Cap Tables: Modeling the Future
Lesson 3.1: Pre-Money vs. Post-Money Valuation: The Core Concepts & Calculation
Lesson 3.2: Anatomy of a Priced Round: Calculating New Shares Issued (The Formula Explained)
Lesson 3.3: Step-by-Step Excel Model: Incorporating a Seed/Series A Round
Lesson 3.4: Calculating Post-Financing Ownership & Understanding Dilution Impact on All Stakeholders
Lesson 3.5: The Option Pool Shuffle: Modeling Pre-Money vs. Post-Money ESOP Increases (Crucial Detail!)
Lesson 3.6: Modeling Multiple Priced Rounds Sequentially
Lesson 4.0: Introduction to SAFEs: Key Features & Common Variations (Pre-Money vs. Post-Money SAFEs)
Lesson 4.1: Decoding SAFE Terms: Valuation Cap, Discount Rate, MFN Clauses
Lesson 4.2: Step-by-Step Excel Model: SAFE Conversion Triggered by Valuation Cap
Lesson 4.3: Step-by-Step Excel Model: SAFE Conversion Triggered by Discount Rate
Lesson 4.4: Step-by-Step Excel Model: Handling SAFEs with Both Cap & Discount (Investor Choice)
Lesson 4.5: Calculating Shares Issued from SAFE Conversions & Proforma Impact
Lesson 4.6: Modeling Multiple SAFEs Converting Simultaneously (Stacking Rank & Complexity)
Lesson 5.0: Introduction to Convertible Notes: How They Differ from SAFEs
Lesson 5.1: Key Terms: Interest Rate, Maturity Date, Valuation Cap, Discount Rate
Lesson 5.2: Step-by-Step Excel Model: Calculating Accrued Interest & Principal at Conversion
Lesson 5.3: Step-by-Step Excel Model: Note Conversion with Cap, Discount & Accrued Interest
Lesson 5.4: Calculating Shares Issued from Note Conversions & Proforma Impact
Lesson 5.5: Handling Note Conversion at Maturity vs. Qualified Financing Round
Lesson 5.6: Comparing SAFE vs. Note Impact Side-by-Side on the Proforma Cap Table