Rebuild the record before forecasting
A cap table before Series A should begin with legal records, not the last spreadsheet someone emailed. Gather formation documents, stock purchase agreements, board and stockholder consents, option grants, exercise records, repurchases, transfers, SAFEs, notes, warrants, and prior financing documents. Reconcile holder names, dates, share counts, and vesting terms. Mark missing signatures or approvals for counsel. Forecasting on an inaccurate baseline produces precise-looking errors. Assign one person to own the reconciliation and one authoritative system or workbook where approved corrections are entered.
Define fully diluted ownership
State exactly what the denominator includes. A fully diluted cap table commonly reflects issued common stock, preferred stock on an as-converted basis, outstanding options, warrants, and the available option pool, with convertible securities handled according to the scenario. Use separate columns for issued, vested, exercisable, reserved, and as-converted amounts. The Cake equity dilution guide introduces the practical effect of equity dilution. Definitions can differ across documents and negotiations, so place the governing definition beside each model output. A percentage without its denominator is not a reliable ownership statement.
Create a clean pre-round tab
The baseline tab should list every security by holder and class, then summarize founders, employees, existing investors, and the available pool. Add issue dates, purchase prices, vesting start dates, and document references where useful. Tie total authorized, issued, and reserved shares back to the charter and equity plan. Keep assumptions out of this tab. It represents the company as it exists today. If a row is disputed, flag it visibly and resolve it before circulating a financing model. Hidden uncertainty becomes harder to correct after investors begin diligence.
Model each SAFE separately
Stacked SAFEs may carry different valuation caps, discounts, MFN rights, and pro rata letters. Enter every instrument on its own row with purchase amount, date, terms, and document link. Calculate the conversion method required by that agreement under the proposed Series A price. Do not average caps or group instruments simply because they share an investor. The Beancount cap table guide examines mistakes that surface around a Series A, including SAFE conversion and option pool treatment. Reconcile the total SAFE proceeds to cash records and prior board reporting before trusting the conversion.
Handle notes and accrued interest
Convertible notes require principal, accrued interest through the expected closing date, cap, discount, maturity, and any qualified-financing threshold. Confirm whether interest converts and whether the note uses the same capitalization definition as other instruments. Model the cap and discount calculations, then apply the provision that governs the actual conversion price. If maturity or amendment questions remain, surface them for counsel rather than inserting a convenient assumption. The model should expose legal questions, not quietly answer them. Keep a sensitivity cell for the closing date because accrued interest changes over time.
Build the option pool from hiring
A Series A investor may request a post-closing unallocated pool percentage. Translate that percentage into a hiring plan before accepting it as necessary. List likely roles, hiring quarter, level, and expected grant range, then subtract currently available options. Calculate the top-up required under both pre-money and post-money treatment. The option pool shuffle occurs when the pre-money holders absorb the increase before new capital enters. Show founders the ownership difference in percentage points and shares. A bottom-up plan creates a better discussion than arguing from a generic market percentage.
Solve the round as a circular model
The new share price depends on pre-money capitalization, while SAFE conversion and option pool size may also depend on that price or resulting capitalization. Build the model in a deliberate order and document each step. Some spreadsheets use iterative calculations; others solve the algebra explicitly. Either approach needs check cells that confirm proceeds, ownership totals, and the target pool. The FoundStep cap table calculator can help founders explore cap table scenarios, though the company’s signed documents control the final calculation. Have counsel and the financing lead review the same version.
Run three financing cases
Create at least a base case, a lower-valuation case, and a case with a larger pool or round. For each, show price per share, conversion shares by instrument, new investor shares, total fully diluted shares, and ownership by major group. Add a waterfall or simple exit comparison only if it helps explain preferences already in the documents. Sensitivity analysis turns dilution from a single surprising number into a range connected to decisions. Label every assumption and date each output so screenshots cannot circulate later without context.
Install integrity checks
A useful workbook tests itself. Ownership should sum to one hundred percent. Issued and reserved shares should reconcile to authorized shares. Investment divided by price should equal new shares, subject to stated rounding. SAFE and note proceeds should match the instrument schedule. The post-closing pool should equal the negotiated target. Add a change log and protect formula cells from accidental overwriting. The 1984 Ventures Series A guide places cap-table preparation within the broader Series A process. Share a read-only output with decision makers while keeping one controlled model as the source.
Use the model to make choices
The cap table is a decision tool before it becomes a closing record. Use it to compare round size, valuation, option pool timing, and pro rata participation. Explain the outputs to the board in plain language, including where legal interpretation affects the result. After terms are agreed, update the model to match definitive documents and closing dates. Then reconcile the final share issuances, file approvals, update the equity system, and preserve the signed version. A clean post-close table gives the company a stronger start for grants, reporting, and the next financing.
Maintain it as an operating record
After Series A, assign responsibility for grants, exercises, cancellations, transfers, and investor reporting. Reconcile the equity system to board approvals on a regular schedule and keep a small exception list until every discrepancy is resolved. Before issuing new offers, check available pool capacity against the hiring plan. Before the next financing, repeat the legal-record review instead of assuming the table remained correct. Cap-table quality comes from routine ownership and documented controls. The closing model provides a clean starting point, and steady maintenance preserves its value for employees, directors, investors, and future diligence.