In this article:

Free Cap Table Template for Google Sheets (2024 Update)

May 8, 2024

Cap Table Template in Google Sheets

A cap table template for Google Sheets is useful for managing equity ownership, facilitating investment decisions, and supporting startup growth and valuation.

Access our free Google Sheets cap table template here.

Please do not request edit access. To make a copy, go to 'File' and select 'Make a copy’. Before you start, make sure to read the instructions below. This will help you understand which parts to fill in and which parts not to edit.

How to Use the Google Sheets Cap Table Template

Follow the steps below to use the Google Sheets cap table template. 

1. Enter Company Name and Shareholder Names

Replace the default names with your company name and the real names of your company's shareholders.

These could be founders, employees, or investors.

If your company has more people in any category, add rows where they fit. For example, if you have a third founder, click on the row under "Founder #2" and insert a new row there. 

2. Fill in Common Shares

For each shareholder, enter how many common shares they have. Only change the cells with a green background.

3. Add Options Details

If people have options, put the number in the options column. Remember, options are like promises for shares in the future.

4. Input Series A Investments

In the Series A column, write how much money each investor put in. This part is important for understanding how much of the company they own.

5. Set Price and Preferences

Confirm the price per share for Series A. Also, decide if these shares have special rights, like getting money back first in a sale.

6. Double-Check Formulas

Make sure all the formulas in the sheet are correct. They automatically calculate totals and percentages based on your inputs. Look over your cap table to make sure everything is right. 

7. Consult with Experts

If things get complicated, it might be a good idea to talk to a lawyer or accountant. They can help make sure your cap table is set up properly.

We hope that you now have a better understanding of how to use our free cap table template for Google Sheets. If you enjoyed this article, you might also like our article on our Google Sheets class schedule template or our article on our free work order template for Google Sheets.

Get Google Sheets productivity and automation tips delivered straight to your inbox
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.
We'll email you 1-3 times a week — and never share your information.
Get your copy of our free Google Sheets automation guide!
  • 27 pages of Google Sheets tips and tricks to save time
  • Covers pivot tables and other advanced topics
  • 100% free

Work less, automate more!

Use Lido to connect your spreadsheets to email, Slack, calendars, and more to automate data transfers and eliminate manual copying and pasting. View all use cases ->