Cap Table Manager

---

name: cap-table-manager version: 1.0.0 description: > Equity cap table management for startups and growth-stage companies. Models SAFEs, convertible notes, priced equity rounds, token allocations, dilution scenarios, and 409A valuation prep. Outputs investor-ready cap tables, waterfall analyses, and scenario models. tags: - finance - equity - startup - cap-table - saas - legal author: PrecisionLedger / Sam Ledger

---

Cap Table Manager

Manage equity ownership from Day 1 through exit. Model rounds, dilution, SAFEs, options pools, and token side-tables. Output investor-ready cap tables and scenario analyses.

When to Use

Modeling pre-seed / seed / Series A+ rounds and dilution impact

Tracking SAFE conversions (MFN, pro-rata, discount, valuation cap)

Building a convertible note conversion schedule

Calculating fully diluted share counts and ownership percentages

Scenario planning: best / base / bear case valuations and payout waterfalls

Preparing 409A valuation support materials

Modeling option pool expansion (pre-money vs post-money shuffle)

Token allocation tables alongside equity (hybrid company structures)

Generating investor-ready cap table exports (CSV, Google Sheets, Excel)

When NOT to Use

Public company equity management (use Carta, Shareworks, or a transfer agent)

Complex secondary transactions requiring legal execution (refer to securities counsel)

Tax advice on stock option grants, ISOs vs NSOs (refer to CPA with PTIN)

Cap table maintenance in a state with specific securities filing requirements — flag for attorney review

Replacing a cap table tool of record (Carta, Pulley, LTSE) for an active company with >25 stakeholders

Anything requiring custodianship, ledger finality, or board-authorized record keeping

---

Core Concepts

Share Classes

Common Stock — founders and employees; lowest liquidation preference

Preferred Stock — investors; liquidation preference + conversion rights

Options/Warrants — unissued; part of fully diluted but not issued shares

SAFEs — Simple Agreement for Future Equity; convert at next priced round

Convertible Notes — debt converting to equity at a discount or cap

Key Metrics

| Metric | Formula | |--------|---------| | Ownership % | Shares Held / Total Fully Diluted Shares | | Pre-Money Valuation | Post-Money − New Investment | | Price Per Share | Pre-Money Valuation / Pre-Money Fully Diluted Shares | | Dilution % | 1 − (Old Shares / New Fully Diluted Shares) | | Liquidation Preference | Investment Amount × Preference Multiple |

---

Workflows

1. Build a Baseline Cap Table

Collect and structure current ownership:

Stakeholder | Class | Shares | % Ownership | Notes
------------|-------|--------|-------------|------
Founder A   | Common | 4,000,000 | 40% | Vesting 4yr/1yr cliff
Founder B   | Common | 3,000,000 | 30% | Vesting 4yr/1yr cliff
Option Pool | Options | 1,000,000 | 10% | 2024 Plan, unissued
Angel 1     | SAFE   | —      | —   | $250K @ $5M cap, 20% discount
Angel 2     | SAFE   | —      | —   | $100K MFN SAFE
TOTAL (pre-conversion) | | 8,000,000 | 80% issued |

Calculation prompt: > "Build me a cap table. Founders: Alice 4M shares, Bob 3M shares. Option pool: 1M shares. Pre-money fully diluted: 8M shares. We have a $250K SAFE at $5M cap and 20% discount, and a $100K MFN SAFE. We're raising a $2M seed at $8M pre-money. Show post-close ownership for all parties."

---

2. Model a Priced Round

Inputs needed:

Pre-money valuation

Investment amount

New option pool size (if expanding pre-money)

Existing cap table (issued + options + SAFEs outstanding)

Step-by-step:

1. Calculate post-money option pool (if pre-money shuffle): - New option pool shares = Target % × Post-Money Fully Diluted - Example: 15% post-close pool on 12M post-money FD shares = 1.8M options reserved

2. Calculate price per share: - Pre-Money FD shares (including new pool) = existing shares + new pool shares - PPS = Pre-Money Valuation / Pre-Money FD shares

3. Convert SAFEs: - Conversion price = lower of: (PPS × (1 − discount)) OR (Cap / Pre-SAFE FD shares) - SAFE shares = Investment / Conversion Price

4. Issue new investor shares: - New shares = Investment / PPS

5. Rebuild fully diluted table post-close

Example — Seed Round:

Pre-money valuation:     $8,000,000
New investment:          $2,000,000
Post-money valuation:    $10,000,000
Pre-money FD shares (incl. pool shuffle): 9,500,000
Price per share: $8M / 9.5M = $0.8421
SAFE #1 conversion ($250K @ $5M cap, 20% disc):
  Cap price:      $5M / 8M pre-SAFE shares = $0.625
  Discount price: $0.8421 × 0.80 = $0.6737
  Conversion at:  $0.625 (lower)
  SAFE shares:    $250K / $0.625 = 400,000 shares
SAFE #2 conversion (MFN → matches best terms = $0.625):
  SAFE shares:    $100K / $0.625 = 160,000 shares
New investor shares: $2M / $0.8421 = 2,375,012 shares
Post-close fully diluted: 9,500,000 + 400,000 + 160,000 + 2,375,012 = 12,435,012

---

3. Option Pool Modeling

Pre-money pool shuffle (standard VC ask): > New pool is carved out pre-close, diluting founders not investors.

Target post-close option pool: 15%
Post-money FD shares (target): X
New pool = 0.15 × X
Solve: X = existing_shares + new_pool + investor_shares
       X = existing_shares + 0.15X + (investment / PPS)
       PPS = pre_money / (existing_shares + 0.15X)

Use iteration or algebra to solve. Common shortcut: model in a spreadsheet with goal-seek on ownership %.

Prompt template: > "I have 8M fully diluted shares pre-round. VC wants 20% post-money ownership for $3M. They also want a 15% option pool post-close, pre-money shuffle. What's the pre-money valuation implied, PPS, and final ownership table?"

---

4. Waterfall Analysis (Exit Scenarios)

Model liquidation preference payout order at various exit values.

Standard waterfall order: 1. Debt repayment (if any) 2. Preferred liquidation preferences (1x non-participating is most common) 3. Common stock (pro-rata with preferred if participating, or preferred converts) 4. Option/warrant holders (exercise if in-the-money)

Example — 1x non-participating preferred:

Exit value: $15,000,000
Preferred investment: $2,000,000 (Series Seed, 1x non-participating)
Common shares: 10M | Preferred shares: 2.4M | FD: 12.4M
Option A (preferred takes preference):
  Preferred gets: $2,000,000 (1x)
  Remaining for common: $13,000,000
  Common per share: $13M / 10M = $1.30
Option B (preferred converts to common):
  All shares pro-rata: $15M / 12.4M = $1.21/share
  Preferred gets: 2.4M × $1.21 = $2,903,226
Preferred chooses: Option A ($2M) vs Option B ($2.9M) → converts to common

Build exit scenarios at: $5M, $10M, $20M, $50M, $100M — show each stakeholder's payout.

---

5. 409A Valuation Prep

Gather inputs for a 409A (required before each option grant):

Required inputs:

Current cap table (fully diluted, all classes)

Most recent priced round (date, PPS, investors)

Any SAFEs or convertible notes outstanding

Company financials: revenue, ARR, burn rate, cash runway

Comparable company multiples (revenue multiple, EBITDA multiple)

Any material events since last 409A (new contracts, pivots, key hires)

Common 409A methods: | Method | Best For | Common Weight | |--------|----------|---------------| | Market Approach (OPM) | VC-backed, priced rounds | 60–80% | | Income Approach (DCF) | Revenue-generating | 10–30% | | Asset Approach | Pre-revenue / distress | 0–20% |

Output to provide to 409A firm:

Fully diluted cap table (CSV)

Most recent investor presentation / pitch deck

3 years of financials (actuals + projections)

List of comparable public companies or recent M&A transactions

---

6. Token Allocation Table (Hybrid Structures)

For companies with both equity and token components:

Token Allocation (Total Supply: 1,000,000,000)
-----------------------------------------------
Team & Founders:   20% = 200M tokens | 4yr vest, 1yr cliff
Investors:         15% = 150M tokens | 2yr vest, 6mo cliff
Ecosystem/DAO:     30% = 300M tokens | 5yr linear release
Public Sale:       10% = 100M tokens | Unlocked at TGE
Treasury:          15% = 150M tokens | DAO governed
Advisors:           5% =  50M tokens | 2yr vest, 6mo cliff
Liquidity/Market:   5% =  50M tokens | Unlocked at TGE
Equity ↔ Token relationship:
Token grants to equity holders: [document separately]
Anti-dilution protection: [specify if tokens trigger]
Side letter required for investor token rights

---

7. CSV/Sheets Export Format

Standard investor-ready cap table columns:

Stakeholder,Type,Share Class,Shares Issued,Options,Warrants,SAFE (Unconverted),Fully Diluted Shares,Ownership %,Investment,Note
Alice Chen,Founder,Common,4000000,,,,,32.2%,,4yr vest 1yr cliff
Bob Smith,Founder,Common,3000000,,,,,24.2%,,4yr vest 1yr cliff
Option Pool,Employees,Options,,1500000,,,1500000,12.1%,,2024 Equity Plan
Sequoia Capital,Investor,Series Seed Pref,2375012,,,,,19.1%,"$2,000,000",1x non-part
SAFE Holder 1,Investor,Common (converted),400000,,,,,3.2%,"$250,000",Converted @ $0.625
SAFE Holder 2,Investor,Common (converted),160000,,,,,1.3%,"$100,000",MFN converted
TOTALS,,,9935012,1500000,,,12435012,100%,"$2,350,000",

---

Common Errors & Watch-Outs

| Issue | Symptom | Fix | |-------|---------|-----| | Double-counting SAFEs | FD shares too high | Only count SAFEs post-conversion | | Pre/post money confusion | Wrong PPS | Confirm: pre-money = before investment, post-money = after | | Option pool shuffle missed | Founders less diluted than expected | Confirm pool created pre-close | | Participating preferred math | Payout too high | Check if preferred also gets pro-rata after preference | | Wrong discount application | SAFE converts at wrong price | Discount on PPS, cap on pre-SAFE FD shares |

---

Quick Reference — Useful Formulas

Post-money valuation     = Pre-money + New Investment
Price Per Share (PPS)    = Pre-money / Pre-money FD Shares
SAFE conversion shares   = SAFE Amount / min(Cap PPS, Discount PPS)
Discount PPS             = PPS × (1 - Discount Rate)
Cap PPS                  = Valuation Cap / Pre-SAFE FD Shares
Option pool shares       = Target % × Post-money FD Shares  [if post-money basis]
Dilution %               = New Shares / (Old FD + New Shares)
Ownership %              = Stakeholder Shares / Total FD Shares

---

Escalation Triggers

Flag to attorney or CPA when:

Preferred stock has complex liquidation preferences (2x, participating, caps)

Anti-dilution provisions (broad-based vs narrow-based weighted average, full ratchet)

Drag-along, tag-along, or ROFR rights affect modeling assumptions

83(b) election windows, ISO limits ($100K/yr rule), or QSBS eligibility

Token rights embedded in equity instruments (side letters, token warrants)

Company has international founders or investors (foreign private issuer rules)

---

Example Prompts

Round modeling: > "We're raising a $5M Series A at a $20M pre-money. Current cap: 8M founder shares, 1.5M option pool, $500K SAFE at $8M cap 20% discount. VC wants 15% post-money option pool, pre-money shuffle. Show me the full post-close cap table."

Dilution check: > "How much will founders dilute if we raise $3M at $12M pre-money with a 20% post-close option pool?"

Exit waterfall: > "Model our exit waterfall at $10M, $25M, $50M. We have: 2x participating preferred ($2M invested), then common. Show who gets what at each exit."

SAFE conversion: > "We have three SAFEs: $200K at $4M cap, $100K at $6M cap 15% discount, $150K MFN. We're pricing a round at $10M pre-money with 9M pre-money FD shares. Calculate conversion prices and resulting shares for each SAFE."

409A prep: > "Prepare the inputs list for our 409A valuation. Last priced round: $2M seed at $8M pre-money, closed January 2025. Current ARR: $180K. Cash: 18 months runway. Provide the document checklist and financial data template."