4 min read ·
A Capitalization Table Example You Can Rebuild in a Spreadsheet
A worked capitalization table example with founder shares, an option pool, a priced round and spreadsheet formulas to check dilution.

A capitalization table, or cap table, records a company’s equity ownership. This worked example shows two founders, an employee option reserve and a new investor—and explains why the ownership denominator matters as much as the share count.
All figures below are hypothetical. They are not Lunera investment terms or recommended ownership targets.
1. Start with shares, not percentages
Assume a software startup has issued 9 million common shares to its founders and reserved another 1 million shares for future employee options. No options have been granted. There are no SAFEs, convertible notes, warrants or previous investors.
For this example, fully diluted capitalization includes issued shares plus the entire unallocated option reserve. This is a financing-model convention, not a universal definition: the applicable documents determine what belongs in the denominator. TKN Tyson’s explanation distinguishes outstanding shares from fully diluted capitalization and explains that the latter can include reserved option-pool shares.
| Holder or reserve | Security or status | Shares / reserved shares | Ownership of outstanding shares | Fully diluted ownership |
|---|---|---|---|---|
| Founder A | Common stock | 6,000,000 | 66.67% | 60.00% |
| Founder B | Common stock | 3,000,000 | 33.33% | 30.00% |
| Unallocated employee pool | Reserved, not issued | 1,000,000 | — | 10.00% |
| Total | 9,000,000 issued + 1,000,000 reserved | 100.00% | 100.00% |
The founders own all outstanding stock, but only 90% on this fully diluted basis. The reserve is not a shareholder. Including it models the potential dilution from future grants and exercises.
2. Model a $2 million priced round
Now assume an investor puts in $2 million at an $8 million pre-money valuation. The existing reserve stays unchanged and is included in the pre-money share denominator. Preferred shares convert one-for-one into common for this ownership calculation.
The arithmetic is:
- Post-money valuation: $8 million + $2 million = $10 million.
- Price per share: $8 million ÷ 10 million pre-money fully diluted shares = $0.80.
- New investor shares: $2 million ÷ $0.80 = 2.5 million.
- Post-round fully diluted shares: 10 million + 2.5 million = 12.5 million.
For this simple priced round, investor ownership also equals investment divided by post-money valuation: $2 million ÷ $10 million = 20%. The American Bar Association’s cap-table math walkthrough explains this calculation and how issuing new shares dilutes existing ownership.
| Holder or reserve | Pre-round shares / reserve | Post-round shares / reserve | Pre-round fully diluted ownership | Post-round fully diluted ownership |
|---|---|---|---|---|
| Founder A | 6,000,000 | 6,000,000 | 60.00% | 48.00% |
| Founder B | 3,000,000 | 3,000,000 | 30.00% | 24.00% |
| Unallocated employee pool | 1,000,000 | 1,000,000 | 10.00% | 8.00% |
| New investor | 0 | 2,500,000 | 0.00% | 20.00% |
| Total | 10,000,000 | 12,500,000 | 100.00% | 100.00% |
Neither founder sold shares. Their percentages fell because the company issued new shares. Combined founder ownership moved from 90% to 72%: an 18-percentage-point decline, or a 20% relative reduction.
3. Change one assumption: replenish the pool
The existing pool falls from 10% to 8% after the round. What if the investor instead requires an unallocated pool equal to 10% of post-round fully diluted capitalization, with the increase included in the pre-money capitalization?
Keeping the same $8 million pre-money valuation and $2 million investment, the revised ownership would be:
| Category | No pool increase | Pre-money increase to a 10% post-round pool |
|---|---|---|
| Founders combined | 72.00% | 70.00% |
| Unallocated pool | 8.00% | 10.00% |
| New investor | 20.00% | 20.00% |
To reproduce the pool increase, work backward from the founders’ unchanged 9 million shares:
Post-round FD total = 9,000,000 / (1 - 20% - 10%)
Target pool shares = Post-round FD total × 10%
Additional reserve = Target pool shares - 1,000,000
That requires approximately 285,714 additional reserved shares, before whole-share rounding. Use the enlarged pre-money total to recalculate the share price and investor shares.
The extra reserve increases the pre-money share denominator, lowers the investor’s price per share and increases the shares issued for the same investment. The founders bear the additional dilution in this scenario. Pool timing changes who bears dilution; the ABA walkthrough compares pre- and post-investment treatment.
Rebuild and check the spreadsheet
Keep valuation and investment in separate input cells. For the unchanged-pool example, use these formulas:
Pre-round FD total = SUM(pre-round shares and reserve)
Share price = Pre-money valuation / Pre-round FD total
Investor shares = Investment / Share price
Post-round FD total = Pre-round FD total + Investor shares
Each row's ownership = Row's shares or reserve / Post-round FD total
Before sharing the model:
- Label it current or pro forma, with an as-of date and financing assumptions.
- Reconcile issued shares and approved grants to their underlying records.
- Separate granted options from the unallocated reserve; do not count grants twice.
- Check that each ownership column totals 100% before display rounding.
- List outstanding SAFEs and notes separately, then model their actual conversion terms rather than inserting them into this example unchanged.
This table answers ownership arithmetic, not voting control or exit proceeds. For a broader treatment of securities, records and financing scenarios, use the cap table guide.