Capitalization (Cap) Tables & VC Returns

1 minutes read
Last updated: November 14, 2023

The Macabacus capitalization (“cap”) table and venture capital return analysis template identifies how much venture capital a start-up requires and when based on free cash flow, computes pre-money and post-money valuation for each round of financing, calculates percentages ownership at each round, and computes the internal rate of return (IRR) and cash-on-cash (CoC) at exit for each investor. Venture capitalists are assumed to invest in preferred stock of the start-up, with cumulative/non-cumulative and participation features set with toggles.

 

Download Template

Cap Tables & VC Returns

Try Macabacus for free to accelerate financial modeling in Excel.

Discover more topics

Build an operating model
In this tutorial, we will walk through how to build a general industry business operating model.
Read more
Build an M&A model
In this section, we demonstrate how to model a merger of two public companies in Excel.
Read more
Build an LBO model
In this tutorial, we will walk you through building an LBO model in Excel.
Read more
Asset and Stock Deals
The first step in purchase price allocation, or PPA, is to determine the purchase price.
Read more