How to Model Your Cap Table for Future Rounds

Your cap table looks clean right now. Three founders, maybe a small angel investor, and a 10% employee option pool. Simple math: you own 35%, your co-founder owns 35%, your third founder owns 20%, and you’ve allocated 10% for future hires.

Then Series A happens. Suddenly you’re staring at a spreadsheet showing you’ll own 18% after the round closes. Your co-founder is texting you at midnight asking how the hell you diluted from 35% to 18%. Your lawyer is explaining something about “pro-rata participation” and “option pool refreshes” that makes no sense. And your lead investor just asked to see your “fully diluted cap table with all future rounds modeled through exit.”

Here’s what nobody tells you: cap table modeling isn’t just accounting. It’s strategic planning for your ownership, your team’s compensation, and your ability to control the company you built. In 2024, median dilution dropped to 20.1% at seed and 20.5% at Series A—down from 23% and 24.1% just five years ago. But that average hides massive variation. Some founders give up 40% in a single round because they didn’t model dilution properly. Others retain 25% at IPO because they planned every round meticulously from day one.

This guide shows you exactly how to model your cap table through multiple funding rounds, protect your ownership, and avoid the mistakes that cost founders millions in equity value.

Table of Contents

• Cap Table Fundamentals: What You’re Actually Tracking
• Building Your Baseline: Current State Before Any New Rounds
• Modeling Your Next Funding Round Step-by-Step
• Option Pool Math: The Dilution Nobody Explains Clearly
• Multi-Round Scenario Planning: Seed Through Series C
• Anti-Dilution Protection and Down Rounds
• Common Cap Table Mistakes That Destroy Founder Equity
• Frequently Asked Questions About Cap Table Modeling

Cap Table Fundamentals: What You’re Actually Tracking

A cap table—short for capitalization table—is more than a list of who owns what. It’s a living model of how ownership changes over time as you issue new shares, grant options, convert SAFEs, and close funding rounds.

At its core, your cap table tracks three categories of ownership: common stockholders (founders and employees), preferred stockholders (investors who participated in priced rounds), and unissued shares available for future allocation (your option pool).

Fully Diluted vs Outstanding Shares

This distinction trips up most founders. Outstanding shares are shares that currently exist and are owned by someone: founders, employees who’ve exercised options, and investors who hold preferred stock.

Fully diluted shares include outstanding shares plus all shares that could be created if everyone exercised their rights: unexercised stock options, SAFE notes that haven’t converted, convertible notes, warrants, and any other instruments that can turn into equity.

When investors ask for your “fully diluted ownership percentage,” they want to know: if every option was exercised and every convertible instrument converted today, what would you own?

This number is always lower than your ownership percentage based on outstanding shares alone. The gap between these two numbers shows your “overhang”—the dilution waiting to happen when people exercise their rights.

Why Modeling Matters Before You Raise

Most founders build their cap table reactively. They model what happens in their current round but don’t think three rounds ahead. That’s like playing chess and only thinking one move at a time.

Here’s why that fails: decisions you make in your seed round affect your Series A, which affects your Series B, which determines whether you own 15% or 30% at exit. The difference between those two ownership percentages on a $200 million exit is $30 million in your pocket.

Specifically, you need to model:

• How much you’ll dilute in each round to raise the capital you need
• Whether you can maintain enough ownership to stay motivated through exit
• How option pool refreshes compound dilution across rounds
• What happens in a down round if your next valuation is lower than expected
• Whether early investors’ pro-rata rights will crowd out new investors

Founders who model these scenarios before raising make better decisions about round size, valuation, and investor selection.

Building Your Baseline: Current State Before Any New Rounds

Before modeling future rounds, you need an accurate snapshot of ownership today. Most founders think they know this, but their numbers are wrong.

Capturing All Current Equity Instruments

Start by listing every equity instrument currently outstanding:

Common stock: Shares owned by founders, early employees who exercised options, and advisors. List the name, share count, and percentage ownership.

Unexercised stock options: Options granted to employees that haven’t been exercised yet. These aren’t shares today but will become shares when employees exercise them—so they count toward fully diluted ownership.

SAFE notes: If you raised on SAFEs that haven’t converted, they’re not shares yet, but you need to model their eventual conversion. List each SAFE’s investment amount, valuation cap, and discount rate.

Convertible notes: Similar to SAFEs but with debt terms. List principal amount, interest rate, valuation cap, and discount.

Warrants: Rights to purchase shares at a specific price. Less common, but if you’ve issued them (often to lenders or service providers), list the number of shares covered and exercise price.

Your current cap table should look something like this:

Holder	Share Type	Shares	% Fully Diluted
Founder A	Common	3,500,000	35%
Founder B	Common	3,500,000	35%
Founder C	Common	2,000,000	20%
Option Pool (unissued)	Options	1,000,000	10%
Total		10,000,000	100%

This is your baseline before any SAFEs, convertible notes, or priced rounds.

Cleaning Up Your Current Cap Table

Before modeling future rounds, fix any problems in your existing cap table:

Undefined vesting schedules: Every founder and employee should have clear vesting terms. If you don’t, you risk co-founders leaving with 35% of the company after contributing for only six months.

Undocumented verbal promises: Did you promise an advisor 0.5% equity but never formalized it? Document it now. Undocumented promises become disputes later.

Inconsistent share counts: Sometimes founders issue shares informally without updating corporate records. Reconcile your cap table against your actual stock ledger and certificate of incorporation.

Multiple share classes without clear rights: If you have Class A and Class B common shares, make sure you’ve documented which class has voting rights, liquidation preferences, or conversion rights.

A clean cap table signals to investors that you run a professional operation. A messy cap table signals that due diligence will uncover problems.

Modeling Your Next Funding Round Step-by-Step

Let’s model a specific scenario: you’re raising a $2 million seed round at an $8 million pre-money valuation.

Step 1: Determine Pre-Money Valuation and Investment Amount

Your pre-money valuation is what your company is worth before new money comes in. Your post-money valuation is pre-money plus the new investment.

In this example:

• Pre-money valuation: $8 million
• Investment amount: $2 million
• Post-money valuation: $10 million

The investor is buying 20% of your company ($2M / $10M = 20%).

Step 2: Calculate New Shares to Issue

You need to issue enough shares so that when those new shares are added to existing shares, the investor owns exactly 20%.

Currently you have 10,000,000 shares outstanding. You need to determine how many new shares (X) to issue such that:

$$ \frac{X}{10,000,000 + X} = 0.20 $$

Solving for X:
$$ X = 0.20 \times (10,000,000 + X) $$
$$ X = 2,000,000 + 0.20X $$
$$ 0.80X = 2,000,000 $$
$$ X = 2,500,000 $$

You’ll issue 2,500,000 new preferred shares to investors, bringing total shares outstanding to 12,500,000.

Step 3: Account for Option Pool Refresh

Here’s where founders get destroyed. Most investors will require you to increase your option pool before the round closes—typically to 10-15% of the post-money, fully diluted cap table.

You currently have a 10% option pool (1,000,000 options out of 10,000,000 shares). But after your round, you’ll have 12,500,000 shares. Your existing 1,000,000 options now represent only 8% (1,000,000 / 12,500,000 = 8%).

If your investor requires a 12% post-money option pool, you need 1,500,000 options total (12% of 12,500,000 = 1,500,000). That means creating 500,000 new options.

Here’s the critical part: those 500,000 new options dilute everyone who owned shares before the round—founders, early employees, and angels. They don’t dilute the new investor because the pool is calculated post-money.

Let’s recalculate with the option pool increase:

Holder	Shares Before	Shares After	% Before	% After
Founder A	3,500,000	3,500,000	35%	28%
Founder B	3,500,000	3,500,000	35%	28%
Founder C	2,000,000	2,000,000	20%	16%
Option Pool	1,000,000	1,500,000	10%	12%
New Investor	0	2,500,000	0%	20%
Total	10,000,000	12,500,000	100%	100%

Notice that founders diluted from 35% to 28% (20% dilution), not from 35% to 28% and then to match the investor’s 20%. The investor gets exactly 20%, and founders absorb both the investor dilution and the option pool increase.

Step 4: Model SAFE Conversions (If Applicable)

If you raised $500,000 on SAFEs before this round, those SAFEs convert into equity during your priced round. The conversion mechanics depend on the valuation cap and discount rate.

Let’s say you have one SAFE for $500,000 with a $5 million cap and no discount. The SAFE investor is entitled to convert at the lower of:
(a) The Series Seed price per share, or
(b) The price per share implied by the $5 million cap

Your Series Seed investors are paying $0.64 per share ($8M pre-money / 12,500,000 shares).

At a $5 million cap, the SAFE investor converts as if the company were worth $5 million pre-money. This implies a price per share of $0.40 ($5M / 12,500,000 shares).

Since $0.40 is lower than $0.64, the SAFE investor converts at $0.40 per share, receiving 1,250,000 shares ($500,000 / $0.40 = 1,250,000 shares).

These 1,250,000 new shares dilute everyone, including the Series Seed investors. Your new cap table becomes:

Holder	Shares	% Fully Diluted
Founder A	3,500,000	25.5%
Founder B	3,500,000	25.5%
Founder C	2,000,000	14.5%
Option Pool	1,500,000	10.9%
SAFE Investor	1,250,000	9.1%
Series Seed Investor	2,500,000	18.2%
Total	13,750,000	100%

Founders went from owning 35% each to owning 25.5%—a massive dilution that many don’t anticipate.

When modeling how different funding scenarios affect your ownership through multiple rounds, Fundreef’s AI company valuation tool helps you run different valuation scenarios and see exactly how each impacts your final ownership percentage and dilution at each stage.

Option Pool Math: The Dilution Nobody Explains Clearly

Option pools are one of the most misunderstood aspects of cap table modeling. Let’s fix that.

Pre-Money vs Post-Money Option Pools

When an investor says “we need a 12% option pool,” they almost always mean post-money. That seemingly innocent request has huge implications.

Post-money pool: The option pool is 12% of the fully diluted cap table after the round closes. This means founders absorb 100% of the dilution from pool expansion.

Pre-money pool: The option pool is 12% of the fully diluted cap table before new investors invest. This means investors share in the dilution from pool expansion.

In 2024, virtually all VC deals use post-money pools. This became industry standard because it’s simpler to calculate and investors prefer not to be diluted by employee option grants.

Here’s the math comparing pre- vs post-money pools:

Scenario: Raising $2M at $8M pre-money with a 12% option pool requirement

Post-Money Pool (Standard):

• You need 12% after the round closes
• Post-money valuation: $10M
• Total shares needed: 12,500,000
• Option pool shares: 1,500,000 (12%)
• Investor shares: 2,500,000 (20%)
• Founder shares: 8,500,000 (68%)

Pre-Money Pool (Rare):

• You need 12% before investors come in
• You create the pool pre-money, diluting founders
• Then investors invest, diluting founders again
• Founders dilute twice, investors dilute once

Post-money pools are now standard, which is why investors pushing for large pools (15-20%) dramatically dilute founders.

Negotiating Pool Size

The typical option pool at seed is 10-12% post-money. At Series A, it’s 12-15%. Investors often push for 15-20%, claiming you’ll need it to hire executives.

Before accepting a large pool, model your hiring plan. If you’re planning to hire:

• VP Engineering: 1-1.5% equity
• VP Sales: 0.75-1.25% equity
• VP Product: 0.75-1% equity
• Early employees (10 people): 0.1-0.3% each = 1-3% total

That’s roughly 4-6% total equity needed for the next 18 months. A 15% pool is excessive and unnecessarily dilutes you.

Push back with data. Show your hiring plan and associated equity grants. Agree to a smaller pool now (10-12%) with the understanding you’ll refresh it when needed—and at that point, new investors will share the dilution.

According to 2024 data from 15,000+ startups, the median seed-stage option pool is 11.8%, with the 75th percentile at 16.2%. Use this data in negotiations: “The median for our stage is 12%, and we’ve modeled our hiring plan requiring 8-10%. Can we set the pool at 12%?”

Tracking Option Pool Burn Rate

Once you’ve established your pool, track how quickly you’re granting options. If you set a 12% pool and grant 8% in your first six months, you’ll need a refresh sooner than expected—which means dilution sooner than expected.

Track:

• Options granted per month
• Options exercised (these become common shares)
• Options forfeited (these return to the pool when employees leave)
• Options expired (these also return to the pool)

Many founders are surprised to learn that when employees leave before vesting, their unvested shares return to the pool. This means your effective pool size can stay stable even as you grant options, if you have normal employee turnover.

Multi-Round Scenario Planning: Seed Through Series C

Now let’s model multiple rounds to see how ownership evolves through a typical fundraising journey.

Starting Point: Three Founders, No Outside Capital

Starting cap table:

• Founder A: 35% (3,500,000 shares)
• Founder B: 35% (3,500,000 shares)
• Founder C: 20% (2,000,000 shares)
• Option Pool: 10% (1,000,000 shares)
• Total: 10,000,000 shares

Seed Round: $2M at $8M Pre-Money

Assumptions:

• Raising $2M at $8M pre-money valuation ($10M post-money)
• 20% dilution to new investors
• Option pool refresh to 12% post-money (requires adding 500,000 options)

Post-Seed cap table:

• Founder A: 28% (3,500,000 shares)
• Founder B: 28% (3,500,000 shares)
• Founder C: 16% (2,000,000 shares)
• Option Pool: 12% (1,500,000 shares)
• Seed Investors: 20% (2,500,000 shares)
• Total: 12,500,000 shares

Series A: $8M at $32M Pre-Money

18 months later, you’ve grown to $2M ARR and raised your Series A.

Assumptions:

• Raising $8M at $32M pre-money ($40M post-money)
• 20% dilution to new investors
• Option pool refresh to 15% post-money (requires adding 1,375,000 options)

Post-Series A cap table:

• Founder A: 18.67% (3,500,000 shares)
• Founder B: 18.67% (3,500,000 shares)
• Founder C: 10.67% (2,000,000 shares)
• Option Pool: 15% (2,875,000 shares)
• Seed Investors: 13.33% (2,500,000 shares)
• Series A Investors: 20% (3,750,000 shares)
• Total: 18,750,000 shares

Notice founders diluted from 28% each to 18.67%—a 33% reduction in ownership percentage. By Series A, founders collectively went from owning 72% to owning 48%.

Series B: $20M at $80M Pre-Money

Two years later, you’ve scaled to $15M ARR and raised Series B.

Assumptions:

• Raising $20M at $80M pre-money ($100M post-money)
• 20% dilution to new investors
• Option pool refresh to 12% post-money (pool was depleted to 8%, need to add back to 12%)

Post-Series B cap table:

• Founder A: 13.6% (3,500,000 shares)
• Founder B: 13.6% (3,500,000 shares)
• Founder C: 7.8% (2,000,000 shares)
• Option Pool: 12% (3,088,000 shares)
• Seed Investors: 9.7% (2,500,000 shares)
• Series A Investors: 14.6% (3,750,000 shares)
• Series B Investors: 20% (5,150,000 shares)
• Total: 25,738,000 shares

Founders collectively now own 35%—down from 72% at founding and 48% after Series A.

Series C: $40M at $160M Pre-Money

Another two years pass. You’re at $50M ARR, profitable, and raising growth capital.

Assumptions:

• Raising $40M at $160M pre-money ($200M post-money)
• 20% dilution to new investors
• Option pool stays at 12% (no refresh needed)

Post-Series C cap table:

• Founder A: 10.9% (3,500,000 shares)
• Founder B: 10.9% (3,500,000 shares)
• Founder C: 6.2% (2,000,000 shares)
• Option Pool: 9.6% (3,088,000 shares)
• Seed Investors: 7.8% (2,500,000 shares)
• Series A Investors: 11.7% (3,750,000 shares)
• Series B Investors: 16% (5,150,000 shares)
• Series C Investors: 20% (6,434,000 shares)
• Total: 32,172,000 shares

Founders collectively own 28% after four rounds of funding. Each founder went from 35% at founding to roughly 11% by Series C.

This is typical. Data shows founding teams collectively own 56.2% at inception, 36.1% at Series A, and 23% at Series B. By IPO, founders average around 15% collective ownership.

Round	Valuation	Amount Raised	Founder A %	Founder B %	Founder C %	Founders Total %
Founding	–	–	35%	35%	20%	90%
Seed	$10M post	$2M	28%	28%	16%	72%
Series A	$40M post	$8M	18.67%	18.67%	10.67%	48%
Series B	$100M post	$20M	13.6%	13.6%	7.8%	35%
Series C	$200M post	$40M	10.9%	10.9%	6.2%	28%

Understanding these dilution dynamics is critical. If you exit at $500M after Series C, Founder A owns $54.5M worth of equity (10.9% of $500M). If Founder A had negotiated better terms to retain 15% instead of 10.9%, that’s $75M—a $20.5M difference.

Anti-Dilution Protection and Down Rounds

The scenarios above assume every round happens at a higher valuation than the previous round. But in 2024, 20% of funding rounds were down rounds—where valuation decreased from the previous round.

What Happens in a Down Round

Let’s say you raised Series A at a $40M post-money valuation. Eighteen months later, your growth stalled, and you’re raising Series B at a $35M pre-money valuation (lower than your previous $40M post-money).

This triggers anti-dilution protection clauses in your Series A investor agreements. Almost all preferred stock comes with “weighted average” anti-dilution protection, which adjusts the conversion price of previous investors’ shares to reduce their dilution.

Weighted Average Anti-Dilution

With weighted average anti-dilution, previous investors get additional shares to compensate for the down round, but the adjustment is proportional to the size and severity of the down round.

The formula is:

$$ \text{New Conversion Price} = \text{Old Price} \times \frac{\text{Old Shares} + \text{Shares Purchasable at Old Price}}{\text{Old Shares} + \text{New Shares Issued}} $$

This is “fair” in that it spreads dilution across all shareholders (founders and common stockholders bear most of it, but previous investors don’t get completely protected).

Broad-based weighted average includes all shares (common and preferred) in the calculation, minimizing the adjustment. Narrow-based weighted average only includes preferred shares, creating a larger adjustment favorable to investors.

In 2024, approximately 60% of VC transactions used broad-based weighted average anti-dilution, making it the industry standard.

Full Ratchet Anti-Dilution (The Nuclear Option)

Full ratchet anti-dilution is rare and devastating to founders. It allows previous investors to convert their shares at the new, lower price per share—as if they had invested at the down round valuation.

If your Series A investors paid $2.00 per share and your Series B investors pay $1.00 per share, full ratchet protection lets Series A investors convert as if they paid $1.00—doubling their share count.

This massively dilutes founders and common shareholders while fully protecting investors. It’s rarely used except in situations where investors have lost trust in founders or in highly distressed scenarios.

Avoid full ratchet provisions at all costs. If an investor insists on full ratchet, that’s a red flag signaling they don’t trust you or expect you to fail.

Modeling Down Round Scenarios

Before accepting anti-dilution terms, model what happens if your next round is a down round.

Use scenario planning:

• Scenario 1: Series B at 1.5x Series A valuation (up round)
• Scenario 2: Series B at 1.0x Series A valuation (flat round)
• Scenario 3: Series B at 0.7x Series A valuation (down round)

Calculate your ownership in each scenario to understand the impact of anti-dilution provisions. If weighted average anti-dilution reduces your ownership from 18% to 15% in the down round scenario, you need to decide if you’re comfortable with that risk.

Tools that model complex cap table scenarios including down rounds and anti-dilution protections help founders understand these dynamics before signing term sheets.

Common Cap Table Mistakes That Destroy Founder Equity

Let’s catalog the ways founders lose millions through cap table mismanagement.

Mistake 1: Not Tracking SAFEs and Convertible Notes Properly

Many founders raise multiple SAFEs at different caps and then forget to model their conversion. When Series A happens, they’re shocked to discover they diluted 45% instead of the expected 20%.

Track every SAFE and convertible note in a separate tab of your cap table. Model their conversion at different Series A valuations ($20M, $30M, $40M, $50M) to understand the dilution impact.

If you’ve raised three SAFEs totaling $1.5M at caps of $6M, $8M, and $10M, those will convert to vastly different ownership percentages depending on your Series A valuation. Model this before you price your Series A.

Mistake 2: Accepting Excessive Option Pool Sizes

Investors who push for 18-20% option pools at seed are over-allocating equity. The median is 11.8%. Unless you’re hiring a full executive team immediately, push back.

Every percentage point in your option pool is a percentage point you’re giving away unnecessarily. If you agree to 18% when you only need 12%, you’ve gifted 6% of your company—worth $6M on a $100M exit.

Mistake 3: Ignoring Vesting and Acceleration Clauses

Founders often set up vesting schedules but don’t model what happens when someone leaves early. If a founder leaves after one year with 25% of their shares vested, your cap table suddenly has 8.75% owned by someone who’s no longer contributing.

Similarly, many founders don’t understand “acceleration” clauses. Single-trigger acceleration means if your company is acquired, all unvested shares immediately vest. This can dramatically change acquisition economics.

Model different departure scenarios: what if a co-founder leaves after 6 months? 12 months? 24 months? How much equity do they walk away with in each scenario?

Mistake 4: Not Modeling Through Exit

Founders model their Series A dilution but don’t model Series B, C, and eventual exit. Then they’re surprised when they own 8% at exit instead of the 25% they expected.

Model your cap table through at least three rounds of funding plus a hypothetical exit. This shows whether you’ll retain enough ownership to stay motivated through the journey.

If modeling shows you’ll own less than 5% at exit, you have a problem. Either you’re raising too much capital too early (giving away more than necessary), accepting bad terms (excessive dilution per round), or your exit expectations are unrealistic (you’re raising $100M to build a $150M company).

Mistake 5: Maintaining Cap Table in Spreadsheets After Seed

Excel works fine for simple cap tables (founders + option pool). But after your first funding round—especially with SAFEs converting, option grants vesting monthly, and multiple share classes—spreadsheets become error-prone.

One wrong formula and your entire cap table is incorrect. Founders have shown up to Series A diligence with cap tables that don’t reconcile to their legal documents, delaying rounds by weeks.

After seed, migrate to professional cap table software: Carta, Pulley, AngelList, or Ledgy. These platforms cost $2,000-$6,000 annually but save you tens of thousands in legal fees fixing cap table mistakes.

Mistake 6: Not Seeking Expert Help for Complex Scenarios

If you’ve raised multiple SAFEs at different caps, issued options to 15 employees with different vesting schedules, and you’re entering a priced round with option pool refresh requirements, don’t try to model this yourself in Excel.

Hire a lawyer or cap table specialist to build the model correctly. The $3,000-$5,000 you spend on expert help saves you from $50,000-$100,000 in dilution from modeling errors.

When preparing your cap table for investor presentations and ensuring your ownership percentages are modeled correctly across scenarios, Fundreef’s AI business plan generator helps you present clear, professional ownership structures that give investors confidence in your planning.

Building Your Cap Table Model: Practical Steps

Here’s exactly how to build a multi-round cap table model.

Step 1: Choose Your Tool

For pre-seed founders with no outside capital yet: Excel or Google Sheets is fine. Use a simple template with columns for shareholder name, share type, share count, and ownership percentage.

For post-seed founders: Migrate to Carta, Pulley, or AngelList. These platforms handle option vesting, SAFE conversions, waterfall analysis, and scenario modeling automatically.

Carta: Most established, comprehensive features, higher cost ($3,000-$6,000/year). Best for companies raising Series A+.

Pulley: Simpler interface, strong scenario modeling, mid-range cost ($2,000-$4,000/year). Best for seed to Series B companies.

AngelList: Integrated with AngelList fundraising, good for early-stage, lower cost ($1,500-$3,000/year). Best for pre-seed to seed companies.

Step 2: Build Your Baseline Snapshot

Enter your current cap table with 100% accuracy:

• All common stockholders with exact share counts
• All option grants with vesting schedules
• All SAFEs and convertible notes with terms
• All preferred stock from priced rounds

Reconcile this against your legal documents. Your cap table should match your stock ledger, certificate of incorporation, and board resolutions exactly.

Step 3: Create Scenario Tabs

Build separate scenarios for different futures:

Scenario A: Aggressive Growth

• Raise larger rounds at higher valuations
• Hire faster (larger option pool refreshes)
• Model through exit at $500M+

Scenario B: Moderate Growth

• Raise standard rounds at market valuations
• Hire at normal pace (standard option pools)
• Model through exit at $200-300M

Scenario C: Slow Growth/Down Round

• Raise at flat or down valuations
• Minimal hiring (smaller option pools)
• Model through exit at $100-150M or earlier acquisition

Run all three scenarios to understand the range of possible outcomes.

Step 4: Model Each Future Round

For each future round, input:

• Round name (Seed, Series A, Series B, etc.)
• Pre-money valuation
• Investment amount
• Investor ownership percentage
• Option pool size post-money
• Pro-rata participation from previous investors

The software will calculate dilution automatically, but verify the math yourself for the first few rounds to ensure you understand how it works.

Step 5: Run Sensitivity Analysis

Model what happens if key variables change:

• Valuation 20% higher or lower than expected
• Investment amount 30% higher or lower than planned
• Option pool requirements 5% higher than negotiated
• Down round at 50% of previous valuation

This sensitivity analysis shows which variables matter most for preserving founder ownership. Usually it’s (1) valuation at each round, (2) option pool size, and (3) total capital raised.

Step 6: Share With Advisors and Get Feedback

Send your model to your lawyer, advisors, and experienced founders. Ask them:

• Does this dilution trajectory look typical for our stage and sector?
• Are we modeling option pool sizes correctly?
• Are there scenarios we’re missing?
• What happens in our model that surprises them?

External validation catches mistakes and blind spots.

Frequently Asked Questions About Cap Table Modeling

How much should founders own at each stage?

Median founding teams own 56.2% collectively after seed, 36.1% after Series A, and 23% after Series B. By IPO, founders average around 15% collective ownership. Individual founder ownership varies, but lead founders typically own 20-30% after seed, 12-18% after Series A, and 8-12% after Series B.

What’s a “clean” cap table and why does it matter?

A clean cap table has: (1) few shareholders (under 20 before Series A), (2) no complicated share classes or unusual rights, (3) proper vesting on all founder and employee shares, (4) accurate records that match legal documents, and (5) no outstanding disputes or undocumented promises. Clean cap tables speed up due diligence and signal professional management to investors.

Should I model cap table based on shares or percentages?

Always model based on shares, then calculate percentages. Percentages change as you issue new shares, but share counts are fixed. Your cap table software should track both, but the underlying data is share counts. This prevents rounding errors and makes conversion calculations clearer.

How do I handle option grants for employees in my model?

Model your option pool as a separate line item showing total options available. As you grant options to employees, create individual lines for each grant showing: employee name, grant date, number of options, vesting schedule, and exercise price. Track vested vs unvested options separately. Most cap table software automates monthly vesting calculations.

What’s the difference between a cap table and a waterfall analysis?

A cap table shows ownership percentages at a point in time. A waterfall analysis shows how exit proceeds would be distributed to each shareholder based on their liquidation preferences, participation rights, and ownership percentages. Waterfall analysis answers: “If we exit for $200M, how much does each shareholder receive?” The answer isn’t always proportional to ownership due to liquidation preferences.

When should I refresh my cap table model?

Update your cap table every time you: (1) issue new shares, (2) grant options, (3) have options vest or expire, (4) close a funding round, (5) have SAFEs or notes convert, or (6) have shareholders transfer shares. For forecasting purposes, refresh your multi-round model every quarter as your valuation, hiring plan, and fundraising timeline evolve.

How do I model the employee option pool if I don’t know who I’ll hire?

Create a hiring plan by role: “We’ll hire 1 VP Engineering (1.5% equity), 1 VP Sales (1% equity), 3 senior engineers (0.3% each), and 5 other employees (0.1-0.2% each).” Total this up to estimate total equity needed. Add a 20-30% buffer for uncertainty. This gives you a data-driven option pool size instead of accepting whatever investors demand.