Excel template is a simple, easy-to-use capitalization table that can be altered and modified to suit your organization's needs. Apart from recording transactions, a cap table also comprises many legal documents such as stock issuance, 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. Screenshot of the template.This
How to Edit the Cap Table TemplateAfter you download the Excel file you can get started editing the template for your own company or client. You'll need to input things such as the pre-money valuation, size of an offering, share price, number of shares, shareholder names, and percentage ownership. The key, when updating or building a cap table template, is to keep organized and have a very clear layout. The math is not complicated, it's staying organized it keeping it easy to follow that's the biggest challenge. If your cap table template gets super complicated, you may wish to consider a software solution such as https://captable.io/.