Cap Table

A capitalization table, also known as a cap table, is a spreadsheet or table that shows the equity capitalization for a company. A capitalization table is most commonly utilized for startups and early-stage businesses but all types of companies may use it as well. In general, the capitalization table is an intricate breakdown of a company’s shareholders’ equity. Listed here are financial model templates for different business models and industries that include the cap table in the financial planning.

Optimize your Subscription-based B2C SaaS startup's financial planning with our…

Starting at: $150.00
Add to wish list
Excluding 8.1% tax

Explore the Debt Fund Excel Model, a comprehensive tool for…

Starting at: $150.00
Add to wish list
Excluding 8.1% tax

Dynamic assumptions to create pro forma financial statements for a…

Starting at: $99.00
Add to wish list
Excluding 8.1% tax

Leveraged Buyout Template for Private Equity and Investment Banking Professionals.

Starting at: $19.99
Add to wish list
Excluding 8.1% tax

A pro forma template for any home service or general…

Starting at: $75.00
Add to wish list
Excluding 8.1% tax

Discover the SaaS Company Financial Model and Valuation, an essential…

Starting at: $0.00
Add to wish list
Excluding 8.1% tax

Create financial projections for a FaaS cloud computing services business.…

Starting at: $65.00
Add to wish list
Excluding 8.1% tax

This model is built for data-as-a-service startups. If you have…

Starting at: $125.00
Add to wish list
Excluding 8.1% tax

Model up to 3 course types that have scaling logic…

Starting at: $75.00
Add to wish list
Excluding 8.1% tax

An integrated and comprehensive Blue Ammonia Production Plant Model that…

Starting at: $149.00
Add to wish list
Excluding 8.1% tax

An integrated and comprehensive Blue Hydrogen Production Plant Model which…

Starting at: $149.00
Add to wish list
Excluding 8.1% tax
Starting at: $35.00
Add to wish list
Excluding 8.1% tax

Unlocking Potential Returns: Venture Capital Return Analysis Simplified - Financial…

Starting at: $29.99
Add to wish list
Excluding 8.1% tax

Test many variables in this financial model for a subscription…

Starting at: $125.00
Add to wish list
Excluding 8.1% tax

Create a detailed financial projection for up to 10-years with…

Starting at: $45.00
Add to wish list
Excluding 8.1% tax

Configure all aspects of an acquisition that is being facilitated…

Starting at: $45.00
Add to wish list
Excluding 8.1% tax

Ultimate Real Estate Private Equity Financial Model Template: Preferred IRR…

Starting at: $55.00
Add to wish list
Excluding 8.1% tax

Unique logic to plan out the feasibility and cash requirements…

Starting at: $125.00
Add to wish list
Excluding 8.1% tax

We proudly present our cutting-edge Real Estate Waterfall Analysis Model…

Starting at: $0.00
Add to wish list
Excluding 8.1% tax

Build assumptions around scaling deliveries. Smart logic built for truck…

Starting at: $45.00
Add to wish list
Excluding 8.1% tax

The financial model is for a business that started Men’s…

Starting at: $79.00
Add to wish list
Excluding 8.1% tax

This excel financial projection model is for forecast of revenue,…

Starting at: $69.00
Add to wish list
Excluding 8.1% tax

Contains all the assumptions you need to build a financial…

Starting at: $45.00
Add to wish list
Excluding 8.1% tax

This Excel sheet is for a financial projection model of…

Starting at: $69.00
Add to wish list
Excluding 8.1% tax

This quick and coherent Valuation and Financial model (20 years)…

Starting at: $47.00
Add to wish list
Excluding 8.1% tax

This Shopping Center Valuation and Three Statement (20 years) Model…

Starting at: $47.00
Add to wish list
Excluding 8.1% tax

This template allows the user to produce financial statements based…

Starting at: $45.00
Add to wish list
Excluding 8.1% tax

An integrated, dynamic and ready-to-use Real Estate Acquisition-Rent-Sell Comprehensive Analysis…

Starting at: $0.00
Add to wish list
Excluding 8.1% tax

Fully loaded financial model that can be used for up…

Starting at: $45.00
Add to wish list
Excluding 8.1% tax
Starting at: $50.00
Add to wish list
Excluding 8.1% tax

Average rating:

Pro Forma Models created this financial model to calculate and…

Starting at: $50.00
Add to wish list
Excluding 8.1% tax

A model to prepare and analyze a start-up or existing…

Starting at: $50.00
Add to wish list
Excluding 8.1% tax
Starting at: $50.00
Add to wish list
Excluding 8.1% tax

This Commercial Real Estate (Multi) Valuation Model will help your…

Starting at: $57.00
Add to wish list
Excluding 8.1% tax
Starting at: $50.00
Add to wish list
Excluding 8.1% tax

Create a wide range of scenarios for the financial forecasting…

Starting at: $75.00
Add to wish list
Excluding 8.1% tax

Pro Forma Models created this model to analyze the financial return…

Starting at: $50.00
Add to wish list
Excluding 8.1% tax

This 10-year financial forecasting template works great for any sort…

Starting at: $45.00
Add to wish list
Excluding 8.1% tax

We are glad to present our new high quality financial…

Starting at: $138.00
Add to wish list
Excluding 8.1% tax

Average rating:

This financial model lets the user plan out cash requirements…

Starting at: $75.00
Add to wish list
Excluding 8.1% tax

Create a financial forecast for a members-only golf course. There…

Starting at: $125.00
Add to wish list
Excluding 8.1% tax

This Pro Forma Model is used to analyze the financial…

Starting at: $50.00
Add to wish list
Excluding 8.1% tax

This Airbnb acquisition and financial forecasting model will provide you…

Starting at: $37.00
Add to wish list
Excluding 8.1% tax

A professional model for retail property acquisition (buy – hold…

Starting at: $99.00
Add to wish list
Excluding 8.1% tax

Pro Forma Models created this financial model to calculate and…

Starting at: $50.00
Add to wish list
Excluding 8.1% tax

Create up to a 10 year financial forecast for a…

Price: $75.00
Add to wish list
Excluding 8.1% tax

Build a strategy for adding recurring revenues services to your…

Price: $75.00
Add to wish list
Excluding 8.1% tax

Granular assumptions to create a financial forecast for hotel operators…

Starting at: $45.00
Add to wish list
Excluding 8.1% tax
Starting at: $48.00
Add to wish list
Excluding 8.1% tax

Bottom-up assumptions for creating up to a 10 year pro…

Price: $45.00
Add to wish list
Excluding 8.1% tax

Full stack financial model, including financial statement outputs, cap table,…

Starting at: $75.00
Add to wish list
Excluding 8.1% tax

Average rating:

Lifetime access to all future templates as well! Here is…

Starting at: $999.00
Add to wish list
Excluding 8.1% tax

This is a REIT (Real Estate Investment Trust) financial model…

Starting at: $40.00
Add to wish list
Excluding 8.1% tax

This is a set of financial models, tools, and templates…

Price: $179.00
Add to wish list
Excluding 8.1% tax

This Start-up Business Financial Model and Planning template is suitable…

Starting at: $25.00
Add to wish list
Excluding 8.1% tax

This Distillery Financial Plan template prepares a sophisticated financial plan…

Starting at: $0.00
Add to wish list
Excluding 8.1% tax

Average rating:

This Financial model template presents a business scenario of a…

Starting at: $129.00
Add to wish list
Excluding 8.1% tax

Flexible capitalisation table excel model for startup / SME business…

Starting at: $0.00
Add to wish list
Excluding 8.1% tax

A fund management tool to track many positions over time…

Starting at: $75.00
Add to wish list
Excluding 8.1% tax

Apple Farming Financial Plan Allows investors and business owners to…

Starting at: $129.00
Add to wish list
Excluding 8.1% tax
What is a Capitalization Table?

The capitalization table (or cap table) calculates the equity value of a company and the value of shareholder’s equity stakes during a series of financing rounds. It is especially important to Startup companies that require several rounds of financing.

Shareholders normally include the founders and investors but can also include employees or even holders of convertible debt. If new equity capital is injected, it will lead to the dilution of the equity stakes of existing shareholders, and their ownership stakes change, as new investors will require an equity stake as well.

Illustrative Example: Shareholder Structure before and after a financing round

  • Initial equity stakes of Founder I, Founder II, and Existing Investor.




  • Accepted two new investors, causing the equity shares of existing parties to be diluted.




A capitalization table now keeps track and calculates how the issuance of new equity stakes will affect the shareholder structure at the various financing rounds. The same is true also for stock options, once exercised, they will affect the % ownership of the company's equity capital.

A basic capitalization table for a startup usually lists down the names of stockholders, the percentage of every stockholder’s ownership, how much capital invested, warrants, options, and other investments in a startup. A much more complex cap table management will be needed later on as one updates their cap table after a couple of rounds of funding injected into the business.

All data is compiled in a neat list which is designed in an organized way that’s easy to read and understand. Basically, the cap table should be able to easily answer the questions: who owns which securities, for how much (price), and which securities are outstanding.

Capitalization Table Example


Here’s an example of how the equity stakes of the founders and investors change upon every addition or injection of new capital equity from third-parties.

Founding Stage – This is where the Founders are given their initial equity stakes in the business. There are no admitted investors in this stage yet.



Seeding Stage – In here, the business acquired two new investors with investments of P50,000 respectively. They received an equity stake of 8.33% each, while the equity stake of the existing Founders went down from 33.33% to 27.78%.



Series A – In the next stage, the business acquires 3 additional investors each with P100,000 investment bringing their equity stake to 5.26% each. This causes another dilution to the founders' equity stakes bringing them lower to 23.39% each.



This event may go on as long as your entity decides to accept new investors or partners to invest. The Capitalization Table for startup plays an important role on this since you can easily keep track and observe what is happening with your own shares, as a founder, as well as if you can still able to sell equity shares but still having the major control on the entity, preventing your shares to be totally diluted.

Top Events that affect your Capitalization Table


So how does our Capitalization Table evolve over time? The following events are important for you to know how and when are you going to use your Capitalization Table.

  • Raising new financing

  • Selling new shares of a new or existing security

  • Establishing and increasing the size of the option pool

  • Issuing a restricted share award or an option grant

  • Exercising the restricted share award or an option grant given

  • Transfer of shares between an individual and another entity

  • IPO

  • Merger


There are tons of events that you want to do or may occur that cause changes and adjustments on your capitalization table. Make sure to always list them down so you won’t lose track of events that contribute to your capitalization table and to always ensure the quality and effectiveness of your capitalization table analysis.

That is why the capitalization table for a startup is always used in making financial decisions that can impact the shareholder structure of an entity. So it is always important to maintain the capitalization table accurately based on most current information for decision making.

Why using a Capitalization Table Template


Capitalization tables can be demanded by investors as they also want to anticipate future financing rounds and have a clear view of what their equity stake will be at the time of their planned exit. Startups, therefore, should prepare a cap table to answer those questions.

  • Capitalization tables are essential for the financial decision-making of a company that affects its equity ownership structure. As these decisions require shareholder approvals, cap table management help to answer questions of investors with respect to their equity stakes pre and post financing rounds. Sometimes a cap table also helps them to understand if it is better to become diluted or if they should inject additional capital.

  • Founders who seek to keep control of a company by securing a 51% equity stake or a large minority stake with a target percentage ownership need to understand how a series of financing rounds will affect their equity stakes and under what conditions they will fall short of their target equity stake.

  • Cap tables examples are also important to estimate the exit value of an investment in venture capital where the company is subject to several more financing rounds.

  • A cap table management allows you to calculate pre-and post-money valuations for new financing rounds.

  • Potential investors can evaluate how much control and leverage could be maintained during negotiations. Also, employees with options or equity stakes can see their real-time value.

  • In the event of an audit, a well-managed cap can allow your legal team to present your company’s history and holdings with accurate and well-organized information.

  • An existing shareholder can easily determine what percentage of the company to give to the new investors in exchange for the capital contributed.


It is best for startup businesses to create a cap table at their starting period to be transparent to their shareholders’ stake in the business and also to manage the securities outstanding of the business. Proper management is needed to ensure that the founder/s stake in the business the highest and to not sell away more than the business can handle.

How to Create a Cap Table Template


As you already know, a cap table is a list of who owns what in a startup business, basically, listing the business’ shareholders and their respective shares in the business. To make your own cap table for your business, you can simply make a spreadsheet and input all the data needed to be recorded in an organized manner, or you can simply follow the basic steps on how to create a cap table template.

  1. In a spreadsheet, list down in a column the five basic categories needed to be taken note of NameSharesInvestmentOwnership, and Value.

  2. Next would be to fill out the first column by listing out all the names of the starting founders and leave a couple of empty slots for future investors. You can also group up investors if they came in waves or groups and you can name it as a “Round of Investment” where the last or most recent investor should be at the bottom of the list. If ever the same entity invested more than once, each purchase should be separated in a new row.

  3. Right next to the first column is the respective shares of each shareholder. Then record according to the total number of shares each entity bought.

  4. Then do the same for the amount of capital invested in the business, recorded under the Investment column. After that, at the bottom of the columns, total up the number of shares and dollars.

  5. Next would be the Ownership column, where you’ll calculate the percentage of each shareholder’s stake in the business. Just simply calculate it by dividing the number of shares each entity owns by the total number of shares held by everyone on the list.
    Share % = Shareholder Share / Total Shareholders’ Shares

  6. The last column is a bit trickier. Since the value changes every time someone invests, you will have to ensure that you will refer to the last or most recent investor. To calculate the value of the share that each investor owns, you will need to calculate how much an entity paid per share. This can be calculated by dividing the total dollars invested in the total shares purchased by the corresponding investor.
    Price per Share = Dollars Invested / Shares Purchased


And that’s it! With these basic steps, you’ll be able to create the most basic cap table which represents the business’ current ownership structure. Just by looking at the report, one should be able to tell who owns the business and how much is each ownership worth in the present. But of course, this is just the most basic cap table management.

Capitalization tables can get really complex as it gets bigger and especially if there are major changes in ownership and different voting rights. You would need to extend more your cap table to ensure that you will take note of every data needed to be calculated. You will also need to continuously update the cap table too since a startup company is constantly evolving as it slowly grows. This can happen when your business will decide to issue more shares, option pools, selling existing shares, granting programmers for employees to raise benefits, investors redeeming their shares, terminating and expiring options, transfers, and selling of shares, etc., which could greatly impact the capitalization table. Thus, you must always keep it up to date to help you make informed decisions for your business.

Cap Table Financial Model Templates


Creating a cap table is simple and complex at the same time. However, it is simple enough for every startup to create their very own cap table for their business. To help you create a cap table more efficiently without having to spend too much time creating from scratch, you can take advantage of and use one of our cap table financial model templates.

The cap table example financial models include the following:

  • Capital Raisings from Seed to Series A-C until Exit

  • % of share ownership and equity ownership calculation

  • Stock option pool

  • Pre-/Post money valuation

  • IRR calculation for shares of the management and the different investors




Cap table Example

The cap table can become one of the most important tools when you plan to raise financing or make changes in your shareholder structure. The cap table allows you to stay on top of the shareholder structure and plan ahead who will control the company’s equity capital.