Careers
Now hiring! 👋
Leave your details and we'll send you out the free template via email. No strings attached.
Klaro Templates for Google Sheets™
Spreadsheets can be complex, confusing and time consuming. So we designed an expert Cap Table template to make your life easier. Completely free, no strings attached.
3 Steps To Complete
Simply leave your details to get access to the cap table template and copy the template over to your Google Sheets account.
Fill in the yellow cells as indicated with your own data or estimations. The cap table template comes with instructions.
Modify the capitalisation table as you need to or as your data changes. Then share with your team or external stakeholders and investors!
What People Are Saying
"As a start-up founder, I found it really hard to get a clear picture of my cap table for each round. The Klaro Cap Table template was super easy to install and gave me the results I needed in minutes. I could also easily include ESOPs and SAFE rounds. Highly recommended for any start-up founder that struggles with spreadsheets!"
"These templates have been a game changer for me. I spent hours looking through Google to find the right template for a clear and straightforward Cap Table. This one hit the mark and came with a wide variety of variations, including SAFEs and Convertible Notes. Can’t wait to use more Klaro templates."
A cap table, short for capitalization table, is an essential tool for businesses of all sizes. It provides a clear and detailed breakdown of the ownership structure of a company, including the distribution of shares among shareholders. Without a cap table, it can be challenging to keep track of ownership changes, stock dilution, and other important equity-related information.
Before we delve into the process of creating a cap table template using Google Sheets, let's first understand why it is such a crucial asset for businesses.
A cap table is not just a simple spreadsheet or document; it is a powerful tool that holds significant importance in the world of finance and business. It serves as a comprehensive record of the ownership structure within a company, providing valuable insights to stakeholders.
Now, let's take a closer look at what exactly a cap table entails and why it is considered an essential document for businesses.
Market sizing is a critical component of business strategy. It helps organizations understand the size and potential of their target market, enabling them to make informed decisions about their products or services. By quantifying the market opportunity, companies can identify the most profitable segments to target and allocate resources accordingly.
Moreover, market sizing allows organizations to assess the competitive landscape. By understanding the size of the market and the share they can capture, companies can evaluate their position in relation to competitors. This information helps in setting realistic goals and developing strategies to gain a competitive edge.
Market sizing also aids in product development. By analyzing the market size and potential, organizations can identify gaps or unmet needs in the market. This knowledge allows them to develop products or services that cater to these specific demands, increasing the chances of success.
A cap table, short for capitalization table, is a detailed document that lists all the shareholders and their respective equity stakes in a company. It goes beyond a mere list of names; it provides a comprehensive overview of the ownership structure, share classes, and the distribution of shares among the shareholders.
Typically, a cap table includes important details such as the shareholder's name, share class, number of shares owned, and the percentage of ownership. It may also include additional information like the date of acquisition, vesting schedules, and any other relevant terms or conditions associated with the shares.
Essentially, a cap table serves as a snapshot of the company's ownership at a specific point in time. It is a dynamic document that undergoes changes as new shares are issued, existing shares are transferred, or when any other events impact the ownership structure.
A cap table holds immense importance for start-ups, regardless of their size or stage of development. Let's explore some of the key reasons why a cap table is considered an essential asset:
1. Ownership Transparency: A cap table provides transparency and clarity regarding the ownership percentages within a company. It allows stakeholders, including founders, investors, and employees, to understand their ownership stakes and the potential value of their shares. This transparency fosters trust and ensures that everyone involved has a clear understanding of their ownership rights and responsibilities.
2. Decision-Making and Governance: The insights provided by a cap table play a crucial role in decision-making processes and corporate governance. With a clear understanding of the ownership structure, management can make informed decisions that align with the interests of the shareholders. It also helps in determining voting rights, dividend distribution, and other important matters that require shareholder approval.
3. Fundraising and Investor Relations: A cap table is often required by investors, potential buyers, or during fundraising rounds. It serves as a key document that showcases the ownership distribution, valuation, and potential returns for investors. Having an accurate and up-to-date cap table can significantly streamline the fundraising process and enhance investor relations.
4. Compliance and Legal Requirements: In many jurisdictions, companies are legally obligated to maintain an accurate cap table. It ensures compliance with regulations related to share ownership, reporting, and disclosure. Moreover, during mergers, acquisitions, or other corporate transactions, a detailed cap table is essential for legal due diligence and valuation purposes.
5. Scenario Planning and Financial Modeling: A cap table serves as a valuable tool for scenario planning and financial modeling. By manipulating the ownership percentages and share values, companies can assess the impact of various scenarios on the ownership structure and the potential returns for shareholders. This helps in strategic decision-making and forecasting.
Overall, a cap table is an indispensable asset for any company. It not only provides a comprehensive overview of the ownership structure but also serves as a foundation for various financial and strategic decisions. By maintaining an accurate and up-to-date cap table, businesses can navigate the complexities of ownership and ensure the fair distribution of value among shareholders.
Creating a cap table is just the beginning. To ensure its accuracy and usefulness, it's important to regularly update and review your cap table. Here are some tips for maintaining your cap table effectively.
As mentioned earlier, it's crucial to update your cap table whenever there are changes in ownership or capital structure. This includes issuing new shares, transferring shares, or any other events that impact the ownership of your company. Additionally, it's recommended to review your cap table periodically to verify its accuracy and make any necessary adjustments.
Changes in equity ownership are common in growing companies. It's essential to have a process in place to handle these changes effectively. This includes properly documenting any share issuances, transfers, or repurchases and updating your cap table accordingly. By having a clear and transparent process, you can avoid potential discrepancies and maintain the integrity of your cap table.
Even with the utmost care, errors can occur in your cap table. It's crucial to identify and rectify these errors promptly to ensure the accuracy of your cap table. Regularly cross-checking the data in your cap table with supporting documentation, such as stock purchase agreements or option grants, can help identify and resolve any discrepancies or errors.
Lorem ipsum dolor sit amet, consectetur adipiscing elit. Suspendisse varius enim in eros elementum tristique. Duis cursus, mi quis viverra ornare, eros dolor interdum nulla, ut commodo diam libero vitae erat. Aenean faucibus nibh et justo cursus id rutrum lorem imperdiet. Nunc ut sem vitae risus tristique posuere.