Excel version

This template cap table is intended for use when considering a potential equity investment in a company (whether from existing shareholders, external investors, or both). The template works when the number of new shares to be issued is calculated:

  • based on a specific investment amount at a specific pre-money valuation of the company e.g. an aggregate investment of $500,000 at a pre-money valuation of $2m
  • on a fully diluted basis i.e. all unexercised options (if any) are treated as existing shares in the company for the purpose of calculating the number of new shares to be issued
  • no anti-dilution rights are triggered by the issue of the new shares
  • all shares issued in consideration for the conversion of debt to equity are issued at a discount to the price per share paid by the cash investors. If all of the debt is converting at the same price per share paid by the cash investors please use our template investment capitalisation table for debt converting without a discount
  • the investment is made on a fully diluted basis, i.e. if a new employee share option plan (ESOP) is established as part of the investment round, the dilutionary effect of the ESOP is borne entirely by the founders and any other existing shareholders, and not by the investors. This is the most common approach.

using our templates

Use of a template by business users is free of charge and is subject to you agreeing to our template terms of use.