All articles
By Fundeep Team6 min read
Cap tableFundraising

If Your Cap Table Lives in Excel, Here's What It Costs You in a Funding Round

Untangle the raise
On this page

Most early-stage startups still keep their ownership structure in a single spreadsheet. At first it makes sense. The founders are known, the percentages are simple, and the whole thing fits on one screen.

The problem is that a cap table isn't a static document. You sign a SAFE. You promise options to an early hire. An angel comes in. A co-founder leaves. An option pool gets carved out. Every one of those events changes the table, and almost nobody keeps the old version. By the time you're raising, you're working from a file you hope is correct.

Here's where Excel-based cap tables usually break during a round, and what it actually costs you.

1. Getting the option pool timing wrong

This is the most expensive mistake founders make, and it shows up in nearly every round.

Say you're raising $2M at a $10M post-money valuation. The investor takes 20%. The term sheet also says a 10% option pool will be created before closing.

Most founders do the math like this: "20% goes to the investor, 10% goes to the pool, so we dilute by 30%."

That's not how it works. If the pool is created before the round, founders absorb all of that dilution alone. If it were created after the round, the investor would share it:

ScenarioFoundersInvestorOption Pool
Pool created pre-money70%20%10%
Pool created post-money72%18%10%

Two percentage points. At a $10M valuation, that's $200,000. When your next round prices the company at $40M, those same two points are worth $800,000.

A spreadsheet won't show you this, because it only displays the end state. It doesn't model when the pool was created or whose ownership paid for it.

2. Forgetting about convertibles

SAFEs and convertible notes have one thing in common: on the day you sign them, they don't appear as shares.

So founders usually leave them out of the table. "It's not equity yet, we'll deal with it later." Then a priced round arrives, two or three convertibles convert at once, and founders discover at the closing table that they're far more diluted than they expected.

Valuation caps make this sharper. If your round prices well above the cap, that early investor converts into a much larger stake than their check size suggests. That's not unfair; it's exactly what the instrument was designed to do. The problem is only that nobody modeled it in advance.

A healthy cap table shows every signed convertible alongside a scenario for what happens when it converts.

3. Vesting that nobody is actually tracking

Founder and employee vesting is standard now. But in a spreadsheet, vesting usually lives in a single cell: "4 years, 1-year cliff."

An investor won't ask you what the schedule is. They'll ask: "As of today, how many of this founder's shares are vested?"

That answer depends on today's date, and Excel doesn't calculate it for you. When a co-founder has left and nobody can say cleanly how much they vested versus how much returned to the company, diligence stops. Unresolved questions about a departed shareholder are, on their own, enough reason for an investor to walk.

4. Version chaos

cap_table_final.xlsx cap_table_final_v2.xlsx cap_table_FINAL_investor_copy.xlsx

If that looks familiar, you're in good company.

Once more than one person touches the file, nobody can say with confidence which version reflects reality. Worse: the version you sent your investor may not match the one your lawyer is working from. When that gap surfaces during diligence, it stops being a formatting issue and becomes a credibility issue.

The investor's next thought is predictable: "If they can't keep track of who owns the company, how are they tracking their financials?"

5. Broken formulas and silent errors

The dangerous thing about Excel is that it fails quietly. You add a shareholder row, the total formula doesn't extend to cover it, and the ownership column no longer sums to 100%. Nobody notices, because the gap is 0.4%.

An investor's lawyer will notice. And from that moment, they'll start questioning every other line in the table too.


What this actually costs you in a round

The damage isn't only measured in equity. In a live funding process, you lose four things:

Time. A cap table inconsistency discovered during diligence typically adds weeks to the process. For a company with limited runway, weeks are expensive.

Negotiating position. A founder who can't explain their own structure ends up defending it instead of negotiating it. If you can't argue the pre-money versus post-money pool question, you'll accept whatever the term sheet proposes.

Trust. Your cap table is the first piece of operational discipline an investor sees. A messy one sets expectations for everything that follows.

Legal cleanliness. Undocumented option promises, unconverted SAFEs, and ambiguous vesting don't disappear. They become far more expensive problems in your next round.

What a fundable cap table looks like

An investor-ready ownership record should answer all of these instantly:

  • What are the fully diluted ownership percentages today?
  • What share classes exist, and what rights attach to each?
  • Which round, at what valuation, brought in how much capital?
  • What happens to the table when outstanding convertibles convert?
  • How much of the option pool is allocated, and how much remains?
  • What is each shareholder's vested position as of today?
  • Who gets diluted, and by how much, in the round you're raising now?

All of this is possible in a spreadsheet. It just has to be maintained every month, on every change, without a single error. In practice, that rarely happens.

How Fundeep handles this

All your fundraising, in one clear view

Fundeep treats your cap table as a living record of the funding process rather than a static table.

Shareholders, share classes, funding rounds, and valuations all live in one place, with ownership percentages and dilution calculated automatically. A valuation timeline shows how your company value has moved across rounds, and a chart view makes ownership immediately readable. Option pools and vesting schedules are managed alongside it in Equity Plans.

More importantly, your cap table sits on the same platform as your financial model, your valuation report, and the data room you open to investors. When someone asks for a document, you're not stitching together versions of three different files.

If you're preparing to raise, your cap table will be one of the first three documents an investor opens.

Build your ownership structure in Fundeep, model your dilution scenarios, and walk into the room with a table you can defend.

Try Fundeep free

This article is for general information purposes only and does not constitute legal or financial advice.