The 411 On Startups ™

Follow @theStartup411

  • ANGELS 411
    • Angel Investing Statistics
    • Angel Primers
    • Common Deal Mistakes
    • Expected Returns
    • Founder Salaries
    • How Groups Work
    • Net Worth Allocation
    • Tax Incentives
  • ENTREPRENEURS 411
    • Common Mistakes
    • Dilution Through Exit
    • Employee Option Grants
    • Executive Summaries
    • Exit Strategy
    • Finding Angels
    • Founders Syndrome
    • Fundraising
    • General Primers
    • Gust / Angelsoft
    • Hiring The Team
    • Investor Presentations
    • Milestones/$$ to Raise
    • Money Finders
    • Pitching
    • Stealthy or Not
    • Technology Transfer
    • Type of Investors
    • Types of Entrepreneur
  • FUNDING SOURCES
    • Angel Groups
    • Angels
    • Bank Loans
    • Family and Friends
    • Funding Sources Overview
    • Grants
    • Revenue Based Financing
    • SBA Loans
    • Strategic Investors
    • Super Angels
    • Venture Capital
    • Venture Leasing
    • Web/Micro Loans & Crowdfunding
  • LEGAL/CORPORATE STUFF
    • Advisory Board
    • Board Of Directors
    • Founder Agreements
    • Get the Right Attorney
    • Legal Stuff Primers
    • License Agreements
    • LLC or C or S Corp?
    • Non-Disclosure Agreements
    • Patents and IP
    • Restricted Stock
    • Selling Stock — SEC Rules
    • Stock Options
    • Stock Terminology
  • NON-PROFIT CATALYSTS
    • Creating A Startup Culture
    • Economic Development
    • Incubators / Accelerators
    • Organizations
    • Venture Forums
  • OTHER
    • GOOGLE GENERIC SEARCHES
    • LIST OF LISTS
    • TOPICAL
  • PLANNING
    • Business Models
    • Business Planning Software
    • Business Plans
    • Financial Plans
    • Financing Plans
    • Marketing Plans
  • STARTUP MEDIA
    • Blogs
    • Books
    • Podcasts
    • Presentations
    • Videos
  • TAKING THE MONEY
    • Capitalization Tables
    • Convertible Notes
    • Due Diligence
    • Funding Documents
    • Preferred Stock
    • Private Placement Memorandum PPM
    • Term Sheets
    • Valuation
  • Uncategorized
  1.  
  2. TAKING THE MONEY
  3. Capitalization Tables
  4. Cap (Capitalization) Tables — Example Spreadsheet
« Seed Capital From Angel Investors: David Rose, Founder and CEO of Gust / Angelsoft
5 Lessons For Raising Money From Family And Friends »

Cap (Capitalization) Tables — Example Spreadsheet

5 Oct 2011   | Capitalization Tables

Tags: cap table · spreadsheet

LINK TO ORIGINAL ARTICLE:
  • http://www.avc.com/a_vc/2011/09/mba-mondays-cap-tables.html

Cap Tables (short for capitalization tables) are spreadsheets that show how much everyone owns of the company. You can get a stockholder ledger from your lawyer that will list all the stockholders and show how many shares or options they have, but I don’t consider that a cap table.

For the past 25 years, I’ve used a simple form, mostly given to me by the partners I worked for when I first entered the venture capital business in the mid-80s, but with a few modifications by me over the years.

Last night I put together a public read-only google spreadsheet that shows you a basic cap table in the format I like to use. (You can get the link in the original post.)

The basic outlines of this cap table are:

  • it shows all the major stockholders of the company listed down the left side. it also shows the major option holders and buckets of option holders
  • it shows all of the classes of stock and how much was paid for them across the top of the columns
  • for each investor, you show how much of each class was bought and how many shares of that class they own as a result
  • you total up the cost and shares and then calculate ownerships on a fully-diluted basis (which means you include the options, whether issued or non-issued or vested or non-vested).

I like this presentation for its simplicity and because it shows the progression of financing activity. It also has the benefit of showing how much each investor has put in on a cost basis, which many cap tables leave out.

If you want to make a cap table for your company, feel free to replicate this format. If you have angel investors, put them in the angel section. I would include the largest ones and bucket all the rest into “other angels.”

If you’ve got any questions about this cap table, or cap tables in general, feel free to ask them in the comments. I will answer them (maybe not until late today or tomorrow -I’ve got a crazy day today). And I bet the community will answer them too (probably well before me).

>>> READ MORE at:
  • http://www.avc.com/a_vc/2011/09/mba-mondays-cap-tables.html
« Seed Capital From Angel Investors: David Rose, Founder and CEO of Gust / Angelsoft
5 Lessons For Raising Money From Family And Friends »

Popular Posts

  • Milestones – Biotech Startup Milestones – Venture Capital Deliverables
  • Spreadsheet for creating a startup financial plan
  • BizPlanIt Virtual Business Plan
  • Writing an Effective Business Plan — Deloitte & Touche LLP.
  • Discount or cap? A spreadsheet that shows what happens when a note converts.

© 2023 The 411 On Startups ™ — All Rights Reserved.