All Industries, Financial Model, General Excel Financial Models

Cap Table, Excel, Financial Model, Startup Financial Models, Venture Capital

Complete cap-table modeler — founding equity split, ESOP pool, five priced rounds (Seed through Series D) with pre/post-money math and option-pool refresh, pro forma ownership through every round, exit waterfall under standard liquidation preferences with per-holder proceeds.

What is inside — 7 tabs, 211 formulas: Cover, Founding, Round Modeler, Pro Forma, Exit Waterfall, Sensitivities, Checks.

Founding split with ESOP allocation
5 priced rounds: Seed / A / B / C / D
Pre/post-money math with pool refresh dynamics
Pro forma ownership table (each round)
Exit waterfall: prefs + common residual
Founder proceeds by exit value × round size

Transparency. Every formula is visible and every cell is unlocked. There are no macros, no hidden sheets and no password protection, so you can trace any number back to the input that drives it. Inputs are colour coded blue, calculations black, same-tab links purple and cross-tab links green, following standard financial modelling convention.

Verified before publication. The workbook is recalculated from scratch under LibreOffice and then audited on the recalculated values, because cached values can hide formula errors that only surface when a model is reopened. Result: 0 formula errors, and every integrity check on the Checks tab returning TRUE. The figures quoted above are measured from the file, not estimated.

Format: a single .xlsx workbook. Works in Excel and Google Sheets. No add-ins required.

You must log in to submit a review.