Skip to content
Lunera Pitch Lunera

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.

Share X in f
Lunera · 4 min read

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.