Simple Cap Table Template – Free Download

This is a simple capitalization (cap) table template which allows entrepreneurs to understand the dilution effect of capital raisings and a simple stock option plan.

Cap Table
,
, , , ,

Creating a capitalization table or also known as the cap table can be very important for startup companies mainly when planning several rounds of raising funding. This is to help anticipate the ownership stakes in a company by its shareholders when going through several rounds of raising financing which inevitably will lead to dilution of existing shareholders when issuing common equity shares, but also preferred shares, share options, employee stock options, convertible bonds etc.

A simple cap table can be helpful and beneficial for:

  • Raising Financing – By creating a cap table, you will have an overview of your business. Thus, you will have a better understanding of what equity stakes can be offered to interested partners and/or for other programs. This will also prevent you from over drafting shares that your business is capable of giving out.
  • Employee Shares or Stock Option Programs – This is included in the cap table. To compensate, retain, and attract employees, getting a better understanding of the effect of employee shares or stock options program on shareholder’s stake is beneficial for your business.
  • Financial Modeling – The cap table can help you calculate the dividends, exit proceeds, and returns (IRR) by investors.
  • Controlled shares – By using the simple cap table, it is easier to understand who controls the company (>51% stake) and at which time this might change. You’ll also be able to determine how much shares are left, given, and the total. Hence, providing you with a well-controlled and managed share capital.
  • Good Practice – By practicing to create a cap table for your business, it becomes beneficial in the future in cases where you need to explain the shareholder situations to the tax authorities and regulators.

Below we provide a simple cap table template which allows entrepreneurs to understand the dilution effect when issuing new equity when dealing with capital raisings or a simple stock option plan.

The cap table example financial model template includes the following elements:

  • Capital raising rounds from Seed to Series A – C until exit
  • % of share ownership and equity ownership calculation
  • Stock option pool
  • Total # of shares and Financing
  • Pre-/Post money valuation
  • Equity Valuation
  • Calculation of Exit Market Value
  • Calculation of investors’ Cash on Cash Multiple ratio
  • IRR calculation for shares of the management and the different investors
  • Executive Summary and Charts

This model gives you a simple cap table example you can work with and the best thing about it is, it is FREE to download. So, start creating a capitalization table to list down your company’s securities such as stocks, options, warrants, etc.

This simple cap table template is recommended and available to download for users all over the world. Especially in countries such as the US, UK, Canada, Japan, Australia, and many more. But if you’re not sure what kind of cap table you need, you should consult with an experienced startup company lawyer.

Filetype: .xlsx (Microsoft Excel 2008 for Mac)

 

CAPTAB_ES_CH CAPTAB_ES CAPTAB_1 CAPTAB_2 CAPTAB_IRR

 

 

Users who purchased Simple Cap Table Template – Free Download, also purchased:
Rolling Cash Flow Projection Excel Model
Add to wish list
Purchase Excluding 0% tax
Financial Reporting Template
Add to wish list
Purchase Excluding 0% tax
Wind Energy Financial Model
Wind Energy Financial Model
Add to wish list
Purchase Excluding 0% tax

Reviews

  • Avatar Good

    I like the simplicity of it. I was able to easily edit it to what I want

    1 of 2 people found this review helpful.

    Help other customers find the most helpful reviews

    Did you find this review helpful? Yes No

  • Write a Review

    Get these templates too for a discount!

    Price: $54.95

    This is a collection of financial model templates for businesses in the Education Industry as well as its related sectors.

    Add to wish list
    Add to cart Excluding 0% tax

    Price: $315.00

    A package of financial models for Software as a Service (SaaS) businesses and its related sectors in Excel. This bundle…

    Add to wish list
    Add to cart Excluding 0% tax

    Price: $69.90

    This bundle of financial model templates provides you a package of relevant SaaS, eCommerce and Online Marketing financial model templates

    Add to wish list
    Add to cart Excluding 0% tax