How to model financing round data into a new cap table version

After modelling a financing round with our tool (here), you may want to translate that data into a new cap table. This will allow you to input shares and record conversions from convertible notes to see how it would change the cap table. You can also run various scenarios, such as a Waterfall on the copy.

Here’s an example of cap table dilution prior to modelling out the data:

Below is a screenshot of our Financing Round scenario tool. As you can see, this is assuming a pre-money valuation of $3M and $1M of new money.

This results in a new round share price of $3 per share. This means that any new money being invested will be done so at $3 per share.

However, the example cap table above included convertible securities (notes). Since these can have conversion caps and discounts, the price per share they convert to is different (our article on this can be found here):

Each convertible security has a different price per share. This is due to the varying conversation caps, despite the principal note amounts being the same.

To get started you’ll want to make a copy of your cap table and open that in a new window. If you don’t know how to do this, you can go here for some help: How to Create a Version of your Cap Table

NOTE: Make sure the changes being made are to a copy, and not your primary cap table. The top search bar will indicate which version is being used.

Step 1: In the new copy you’ll first want to record the conversion to equity. Instructions on recording conversions can be found here. Be sure to record the exact amounts from the financing round tool data.

NOTE: If you don’t want to check invested capital or ownership percentage changes for note holders, you can skip the conversions and record a single preferred issuance for new shares under step 2 (in this case, 637,142.85 new shares).

Step 2: After you’ve recorded the conversions to equity, be sure to record the new preferred stock from the new money investment (if you skipped the individual conversions, be sure to add the new shares for the notes also):

That’s it! You can now do things such as run a waterfall scenario or check dilution. Here’s an example of how the dilution changed, using the above scenario:

Note: The preferred stock (“New Investment”) assumes a 1X conversion rate. The pie graph icon can be clicked on to view this data in a chart.

While this is currently a manual process, future versions of the Financing Round tool will automate this (by the end of 2017).

Was this article helpful?

Related Articles