Begin with the source document
A manager reading startup cap table should remember that the calculation answers one management question: Add new financing shares to founder, employee, and existing investor shares and calculate post-round ownership percentages. It is intentionally narrower than a forecast, valuation, or approval.
Against the defined startup cap table base, choose cash, booked, billed, or recognized figures consistently. Similar labels can conceal different timing conventions.
Questions raised by the output
The working file for startup cap table indicates that a zero value may reflect no activity, missing data, or a genuine zero. The founding team must distinguish those conditions.
If Founder shares is observed and New-round price per share is forecast, identify that difference in the heading of the saved case.
If New-round price per share is probability weighted while Founder shares is recorded, label that asymmetry beside the startup cap table output.
Discuss startup cap table materiality with the founding team, since system noise and business consequence are not the same thing.
Follow the model step by step
Within the startup cap table analysis, use the stated relationship without rearranging business definitions: Post-round capitalization adds all existing and new shares; each ownership percentage divides its shares by the total.
The working file for startup cap table indicates that the Pre Money Valuation Calculator is the appropriate follow-up for a documented pre money valuation issue.
Data required from the working system
Verify whether Founder shares is gross, net, or probability weighted. State any allocation included in founder shares. Reconcile the Founder shares cutoff before interpreting movement in Employee and option shares.
The startup cap table dataset assigns a defined role to Employee and option shares. Label reversals affecting employee and option shares. Explain why Employee and option shares and Existing investor shares belong to one population.
Check the unit attached to Existing investor shares; Retain the raw evidence for existing investor shares. Keep the treatment of Existing investor shares stable while stress-testing New investment.
If New investment is forecast, distinguish it from recorded values. Match new investment to the chosen population. Compare New investment with New-round price per share after agreeing on both definitions.
When New-round price per share changes, save a new comparison case. Exclude duplicates from new-round price per share where applicable. Independently establish New-round price per share, then compare it with Founder shares.
A worked numerical trace
For a reproducible test, enter Founder shares = 6e+06 shares; Employee and option shares = 900000 shares; Existing investor shares = 1.6e+06 shares; New investment = $3,000,000; New-round price per share = $1.50.
With the startup cap table cutoff fixed, label the run illustrative so it cannot be mistaken for an approved forecast or transaction.
Remaining commercial questions
The source trail for startup cap table supports this point: before implementation, return to the capitalization file; Securities law, tax treatment, legal rights, preferences, vesting, and negotiated financing terms are not determined.
From the startup cap table evidence, include the page version when the result supports a recurring management process.
The operating meaning of startup cap table begins here: a question about runway after funding belongs in the Runway After Funding Calculator, not in an improvised field.
Notes for the metric owner
What precision should be saved?
For this startup cap table population, retain source precision and round only the displayed or contractual output.
Why preserve intermediate rows?
A manager reading startup cap table should remember that they reveal which component moved and make reconciliation faster.