A spreadsheet listing all the ownership stakes in the company
A spreadsheet listing all the ownership stakes in the company
A cap table is a spreadsheet for a startup company or early-stage venture that lists all the company’s securities such as common shares, preferred shares, warrants, who owns them, and the prices paid by the investors for these securities. It indicates each investor’s percentage of ownership in the company, the value of their securities and dilution over time. Cap tables are created first before other company documents in the early stages of a startup or venture. After a few rounds of financing, the cap tables become complex, and it lists the potential sources of funding, initial public offerings, mergers and acquisitions and other transactions.
Apart from recording transactions, a cap table also comprises many legal documents such as stock issuances, transfers, cancellations, conversion of debt to equity and other documents. The executives must manage all these transactions and documents accurately to show the events since the company’s inception. The simplest form of cap tables lists the shareholders at the beginning and their respective share ownership. Cab tables are used by venture capitalists, entrepreneurs and investment analysts to analyze important events such as ownership dilution, employee stock options and issue of new securities.
Most companies use spreadsheets to create a cap table at the inception of the business. The cap table should be designed in a simple and organized layout that clearly shows who owns certain shares and the number of outstanding shares. The most common structure is to list the name of investors/security owners on the Y-axis, while the type of securities is listed on the X-axis.
Alternatively, a company can use a spreadsheet template that allows for the addition of information and figures related to their business. The first row should indicate the total number of shares of the company. The subsequent rows should list the following:
A separate table in the capitalization table should include the following:
The company’s founders are listed first in the table, followed by executives and other employees who own equity and then investors such as angel investors and venture capitalists.
Below is a Cap Table example from one of CFI’s many free excel templates.
The spreadsheet below contains two sections: valuation and ownership. All numbers in blue are hardcoded assumptions and all numbers in black are formulas.
In the valuation section, enter the current company value (i.e. $1 million) and the current number of shares outstanding (i.e. 200,000).
In the ownership section, enter the dollar value each investor in contributing to the funding round (i.e. $100,000 for investor 1, $250,000 for investor 2, etc.).
Enter your name and email in the form below and download the free template now!
With each additional round of funding, the cap table requires updating. For example, issuing new shares of an existing security, increasing or decreasing stock options for employees, and issuing new shares of a new security require the cap table to be updated to reflect the changes. Also, the exit of key shareholders, transfer of shares to another existing shareholder or new shareholder, and termination and retirement of employees require the company to update the cap table.
An updated cap table helps entrepreneurs and venture capitalists to make informed decisions based on the current information. Also, US companies use their cap tables as the only system of recording stock ownership. US laws allow cap tables to be used as a formal legal record of equity ownership, and must, therefore, be continually updated to reflect any changes in the stock ownership.
Waterfall analysis indicates the amount every shareholder on the cap table would receive based on the amount available to equity in a liquidity scenario. Liquidity events are usually uncertain, and the shareholders cannot foresee how and when it will occur. Waterfall analysis relies on a range of assumptions to show the actual percentage of proceeds would be distributed to shareholders if the company is liquidated.
The cap table typically indicates the accounting ownership of individual shareholders, which is the actual ownership percentage. Accounting ownership varies from economic ownership, which is the percentage of ownership available to equity.
When negotiating with investors for new funding, investors are interested in seeing how the company’s ownership is structured and the changes that have occurred in the previous financing rounds. Investors may have questions that can be answered by the cap table. For example, new investors will want to know the impact of their investments on other investors. They want to avoid any potential litigious situations that may put them at loggerheads with other investors. Investors also want to see where they sit in the liquidity rank. They want to sit at the top so that they can be paid back before other investors in case a liquidity event occurs.
Although companies mainly focus on investors and executives, most companies are becoming transparent with their employees about cap tables. This helps in retaining well-performing employees and keeping them motivated to continue serving the company. Company executives want to know the payouts they will receive from their ownership percentage if the company sells or is liquidated. Companies that are transparent and organized have higher chances of retaining their employees, even when the firm is facing financial distress.
In most countries such as the United States, cap tables are used as a formal legal record of equity ownership. The tax authorities rely on cap tables to determine if the company, employees, and investors pay the required amount of taxes. Where the cap tables are not updated continuously, the company or its employees may end up paying more taxes than they need to. If the company submitted fewer taxes than required, they may end up paying high penalties for mistakes that they could have avoided.
When the company decides to sell the business to another company, the proceeds from the sale are divided among shareholders. The cap table outlines how much each shareholder gets from the proceeds and in what order. An updated cap table helps eliminate any disagreements and lawsuits that may arise from the proceeds distribution.
CFI is a global provider of financial analyst training and the official sponsor of the Financial Modeling and Valuation Analyst designation. To continue learning and advancing your career, these additional resources will be helpful: