Blog
>
Cap Table Template and Example

Cap Table Template and Example

Download a free cap table template and find additional resources to effectively manage your cap table. Learn whether a spreadsheet or specialized software is best for your cap table management needs.

Farheen Shaikh

26 July 2024

Table of Contents

Request a Demo

A capitalization table (cap table) is a fundamental tool used by startups and early-stage ventures to track ownership, investment details, and dilution. It essentially serves as a blueprint for a company's ownership structure.

Cap table example

Imagine a startup with two founders, Alex and Maria, each initially owning 45% equity (10,000 shares each) in the company, with an ESOP pool accounting for the remaining 10% (2,200 shares).

During their seed round, they raised $25,000 from angel investor David at a pre-money valuation of $700,000. 

Example cap table by EquityLIst
Example cap table by EquityList

To determine how many shares David will receive, we first need to establish the price per share at which he is buying into the company. The price per share is calculated by dividing the pre-money valuation ($700,000) by the total number of shares issued (22,200), which in this case is $31.5

Next, we use David's investment amount ($25,000) and the price per share ($31.5) to find out how many shares are to be issued to him. This calculation gives us approximately 793 shares.

Post-investment, Alex and Maria's ownership decreased to 43.5% each, and the ESOP pool also decreased to 9.6%, reflecting the issuance of new shares to David, which increased the total number of outstanding shares.

This reduction in ownership illustrates the dilution effect that occurs with the addition of new shareholders to the cap table. Existing shareholders experience dilution every time a new shareholder is added to the cap table.

Though the share of existing investors diluted with David coming onboard the cap table, the value of their equity went up because he priced it higher than what it was worth before. Price per share earlier was $10 but since David valued the company at a pre-money valuation of $700,000 the price per share went up to $31.5.

Now that you know the basic functioning of a cap table, here’s a  Cap Table Template for you to make a copy of and use. You can customize it based on your needs.

Formulas used for calculations

Post-money valuation = Pre-money valuation + Investment amount

Price per share = Pre-money Valuation/Total number of shares issued

Dilution percentage = (Number of new shares issued/ Total number of shares outstanding before new issuance)*100

Discounted conversion price = pre-money/ (1+discount)

Why is a cap table management software important?

When discussing setting up a cap table, people often face the dilemma of whether they should use the good-old spreadsheet or turn to a software. Well, spreadsheet is great if you are looking for a free and instant way to list your shareholders and their ownership percentages.

But they don’t give you a holistic experience when it comes to the ‘management’ of your equity.

Spreadsheets don’t allow you to:

- Automate tasks like real-time updates, precise calculation of complex financial instruments (Convertible notes, SAFEs), and scenario modeling for investment impacts. 

- Streamline shareholder consents with templates and digital signatures.

- Simplify ESOP management by automating grant issuance, tracking vesting schedules, and facilitating tax calculations for employees.

- Centralize communication with investors, enhancing transparency and organization. 

- Share customizable views to cater to different stakeholders

- Remain compliant by offering detailed audit trails and reports adhering to applicable accounting standards.

- Ensure efficient document management and secure information sharing during due diligence.

Spreadsheet vs Cap table software
Spreadsheet vs Cap table software

While you may get started with the spreadsheet template we shared with you above, in case you want to explore a more scalable approach for managing your cap table, book a demo with us now.

Moreover, to help you manage your cap table better, here are some additional learning resources:

- Cap Table Management Guide

- Understanding Key Components 

- Best Practices for Maintenance

- Mistakes to Avoid