Organize founder and investor ownership across successive funding rounds, then see how new share issuances change each holder’s percentage of the company.
This capitalization table Excel workbook is built for early-stage equity planning. Enter shareholder names, investment amounts, issue dates, round-level share costs, and shares issued. The model brings those entries into a structured ownership table showing total shares, equity raised, and percentage ownership by stakeholder and round.
Map the ownership structure
Keep founder and investor positions in one table, with individual holdings, subtotals, total shares, and ownership percentages presented together.
Review funding-round dilution
Follow how the addition of shares in later rounds changes the relative percentage held by existing founders and investors.
Connect cash raised to shares issued
Compare investment amounts, cost per share, and resulting share counts for each modeled financing round.
What does the cap table help you analyze?
The workbook turns individual equity transactions into a round-by-round view of capitalization. It is designed to answer practical questions about who owns the company, how much capital each round contributes, and how ownership shifts when additional shares are issued.
Founder and investor allocation: record up to 20 shareholder entries across founder and investor groups.
Successive financing rounds: model the founder position and up to three investor rounds shown as Series A, Series B, and Series C.
Per-round share economics: enter the date and cost per share, then organize the related investment and number of shares.
Ownership percentages: review each stakeholder’s percentage of total shares after each modeled round.
Dilution visibility: compare earlier ownership percentages with the post-financing structure as the share base expands.
Capitalization totals: see total shares issued, total equity raised, and the modeled round value in a consistent layout.
What is inside the workbook?
The spreadsheet uses a single structured cap table layout. Yellow cells identify the visible data-entry areas, while calculated fields summarize shares and ownership across the founder allocation and subsequent rounds. The layout keeps shareholder-level details and round-level totals close together so users can trace how each financing input affects the capitalization structure and verify the resulting ownership split before sharing or discussing it.
Editable transaction inputs
Enter stakeholder names, dates of issue, investment amounts, share quantities, and round-level cost per share in the designated fields.
Round-by-round ownership table
Separate columns display founder, Series A, Series B, and Series C positions, including shares and percentage of total ownership.
Calculated totals and subtotals
Review founder and investor subtotals together with total shares issued, total equity raised, and the value associated with each round.
The workbook view places shareholder inputs beside each financing round, making share counts, investments, and ownership percentages easy to follow across the capitalization table.
See the ownership effect of each round
The table starts with founder holdings and extends through three investor rounds. For each stage, the user can review the investment entered, shares issued, and percentage of total ownership. This makes it possible to discuss a proposed raise in concrete terms: how many new shares are added, what proportion moves to incoming investors, and how the founders’ percentage changes after the transaction.
How do you use the template?
Set the founder position
Enter founder names, issue dates, contributions or investment amounts, and the initial number of shares allocated.
Define each financing round
Add the round date and cost per share, then enter investor-level amounts and shares for the relevant series.
Review calculated ownership
Check shareholder percentages, founder and investor subtotals, and total shares after each round.
Compare the dilution path
Use the successive columns to assess how later issuances affect the ownership retained by existing stakeholders.
Who is this template for?
The workbook is suitable for founders preparing an early financing discussion, finance teams maintaining a clear internal ownership schedule, analysts reviewing a proposed capitalization structure, and investors evaluating how a new round fits into the existing share base. It is most useful when the required structure fits within the displayed founder allocation, up to three investor rounds, and up to 20 shareholder entries.
For a broader financing review, pair the cap table with the Investor Negotiation Calculator to examine investor terms and ownership trade-offs. When the discussion also depends on enterprise value, the DCF Calculator provides a separate framework for estimating value from projected cash flows.
Choosing a selection results in a full page refresh.
