Summary: A cap table lists who owns what in a startup. It calculates how the option pool shuffle and seed debt lower the Series A share price. At its most basic level, a cap table is just a list of your company’s securities (i.e., stock, options, warrants, etc. For example, if you are considering a new financing, you need to be able to quickly run scenarios based on different pre-money valuations, different round sizes, different available option pool targets, etc. Where do you start when you need to put together your cap table? We’ll give you a template to use as a starting point. But we’ll also show you why a cap table spreadsheet will eventually lead to suicide, and what you can do to prevent it.
A capitalization table (or cap table) is a table providing an analysis of the founders’ and investors’ percentage of ownership, equity dilution, and value of equity in each round of investment. Download a cap table with guide how to use it. Track share ownership from founding up to Series-A. Calculate investment returns for all classes of investor. Bringing together the insights from the Cap Table University we’ve created a worked example of a Cap Table from the ground up. We will contrast the old method – using Excel, with the new method – using Reportally’s free cap table builder.
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. Also known as ‘cap table.’. A common template for capitalization tables is to list shareholders in a column on the left side of the table and describe each investment round (such as Series A, Series B etc. This post and sample cap table spreadsheet is provided as a learning tool on an as-is basis with no guaranties. We are not lawyers and this post should not be considered advice legal, tax, or otherwise.
This is a guide to how to use my template cap table and returns analysis excel spreadsheet. This will enable founders to track the ownership of their startup f. Take control of your cap table, model fundraising scenarios, manage your option pool and keep your shareholders up to date. The cap table below is a neat, relatively simple and fairly organized example, most likely due to the small size of the current company. An example cap table (in Excel format) for a relatively simple startup is available for download at the end of this post. The example company has (1) three founders and two initial employees who hold common stock (with one employee’s common stock being restricted stock); (2) three angel investors who invested in a Series A round (likely through convertible notes); (3) four new investors who invested in a Series B round (along with the angel investors); and (4) an option pool equal to 15 of the fully diluted equity of the company, which is nearly depleted due to the outstanding options listed on the cap table. But just because something like reading or building a cap table is new or unfamiliar doesn’t mean it’s inherently difficult. In this simple example, you can see all the key elements of the table: post-money valuation, price-per-share, shareholders, how much shareholders paid for shares, and what percentage of ownership it gives them pre and post-money.