Cap Table&Dilution Model (Excel + Sheets) | SAFE · Option Pool Shuffle · Pre/Post-Money · Liquidation Prefs · MoIC & IRR

Description
The Cap Table & Dilution Model is a self-contained, multi-round priced-equity cap table for startup founders, operators, angels, and finance students who need to determine — and defend — exactly what each funding round does to ownership. Enter the founder shares, starting option pool, an optional post-money SAFE, and each round's pre-money, investment, and target pool %, and the full dilution waterfall (Founding → Seed → Series A → Series B → optional Series C), the price per share and post-money at each stage, two exit waterfalls, per-investor MoIC, and annualized IRR all populate automatically. The workbook ships pre-filled with a complete, tied-out worked deal.

The differentiator is correctness, not features. The hard parts of a cap table are the option-pool shuffle, the SAFE conversion, and the liquidation-preference waterfall — and most templates get them wrong, break on a circular reference, or skip them. This model solves each round in closed form (pool expanded pre-money, tops up only when needed), converts the post-money SAFE at the first priced round, and solves the non-participating liquidation waterfall exactly with a per-class participating toggle. It runs on arithmetic-only formulas, unchanged, in both Microsoft Excel and Google Sheets.

What you get
- A correct multi-round priced-equity cap table (Founding → Seed → Series A → Series B → optional Series C)
- Post-money SAFE (YC 2018) converting at the first priced round at the greater of the cap-implied count or the round's own price per share (YC safe, S.1(a))
- The option-pool shuffle done right — expanded pre-money, closed form, no circular references
- Price per share and post-money valuation at every stage
- Two exit waterfalls — as-converted pro-rata AND liquidation preferences (1×+, per-class participating toggle)
- Per-investor MoIC and annualized investor IRR (per investor + blended)
- A 12-KPI founder-dilution dashboard with built-in self-checks
- A pre-filled, tied-out worked deal to study before changing a cell

Model structure — Excel (7 tabs)
1. START HERE — what the model does, input order, method in plain English, disclaimer
2. Assumptions — founder shares (incl. optional Founder C), starting pool, SAFE, global settings
3. Funding Rounds — each round's pre-money, investment, target pool %, PPS, post-money
4. Cap Table — full multi-round dilution waterfall with ownership % at each stage (incl. SAFE)
5. Exit Waterfall — pro-rata as-converted exit proceeds, per-investor MoIC, annualized IRR
6. Liquidation Waterfall — returns with 1×+ preferences, per-class participating toggle, founder cost of prefs
7. Dashboard — 12 KPI tiles, founder dilution, built-in self-checks

See it working
Pre-loaded with "Helio Robotics" ($500k post-money SAFE on a $5M cap, $200M exit): founders diluted 84.2% → 32.7% across the SAFE and three priced rounds; SAFE converts to 1,055,556 shares (~4.3%); Seed price per share $0.5632; post-money $7.5M / $24M / $65M; $22.5M raised; blended MoIC 4.71x (Seed 14.5x → Series B 3.1x); founders $65.4M as-converted = $65.4M under 1× non-participating vs $57.9M under 1× participating (ships non-participating — founder cost of prefs reads $0 on open; set Liquidation Waterfall row 12 to 1 for this $57.9M case); ownership 100% at every stage. Replace the inputs with your own figures and every output re-prices.

Scope
Models the post-money SAFE (YC 2018, cap, no discount); each round independently participating or non-participating, pari passu. Pre-money/discount SAFEs, seniority-ranked stacks, participation caps, and anti-dilution ratchets are a deliberate future tier. IRR annualizes MoIC over a single holding period.

Technical specifications
- Format: .xlsx (Excel edition) + .xlsx (Google-Sheets-safe edition)
- Compatibility: Excel 2019, 2021, Microsoft 365 (Windows and Mac) and Google Sheets
- No macros, no VBA, no add-ins
- No circular references — closed-form round math
- Pre-filled worked deal; replace with your own
- 7 tabs · multi-round waterfall · two exit waterfalls · MoIC & IRR
- Delivery: instant digital download · single-user license

ABOUT THE AUTHOR
Built by Hoda Elmorshidy — Financial Controller & Fractional CFO, 9+ years in IFRS reporting, FP&A, commodity trading, CFO/board reporting, UAE VAT & Corporate Tax, and finance automation. Practitioner-grade tools, not generic templates.

DISCLAIMER
This template is an analytical and educational tool, not professional financial, investment, tax, accounting, or legal advice, and its use creates no professional relationship. All assumptions and figures are illustrative — outputs are only as good as your assumptions, and past or sample results are not indicative. Verify every conversion, preference and ownership figure against your own charter, safe and financing documents, with your counsel and accountant, before relying on any output. The sample company "Helio Robotics Inc." and all of its figures are fictional. Liability is limited as set out in the licence terms below.

LICENSE & LIABILITY
LICENSE GRANT: Single-user license for your own or your organization's internal use. No resale, redistribution, sublicensing, or repackaging of the file or its templates.
AS IS: Provided "as is" without warranty of any kind, express or implied, including merchantability or fitness for a particular purpose.
LIMITATION OF LIABILITY: To the maximum extent permitted by law, total liability for any claim arising from this product is limited to the amount you paid for it. Not liable for indirect, incidental, or consequential losses.
NON-WAIVABLE RIGHTS: Nothing here limits rights that cannot be excluded under the consumer-protection law of your jurisdiction.
GOVERNING LAW: This purchase is governed by the terms of the platform you bought it on (e.g. Etsy, Gumroad) and by the consumer-protection law of your own country of residence. Where those permit, the limitations above apply to the maximum extent allowed.
Past or sample results are not indicative.
REFUNDS: Digital download — refunds are handled per the refund policy of the platform you purchased on for digital/instant-download items.
TRADEMARKS & NON-AFFILIATION: "SAFE" and the post-money safe documents referenced here are published by Y Combinator. This product is an independent analytical template and is NOT affiliated with, endorsed by, or sponsored by Y Combinator. Microsoft Excel and Google Sheets are trademarks of Microsoft Corporation and Google LLC respectively; this product is not affiliated with, endorsed by, or sponsored by either. NVCA model document references are for methodological attribution only.