Round Modeling report on Capdesk

Round modelling report is an excel sheet you can use to model new financing round.

To find this report on Capdesk please follow the below; 

1) Sourcing the report

2) Downloading the report

3) How does the report work?

4) Adding Investors to the report

5) Managing the option pool 

1) Finding the report

When on your Capdesk account click on "Cap Table" and head to the "Exports" tab to find the Round Modelling report on the dropdown. 

Round Modelling

2) Ordering the report

After this, you'll be brought to the "Order Report" page, you'll then select what data you want to be included in the report. Once you've clicked on the "Order" button, the report will be sent to you via email which you can download.

 

If you are yet to go-live on Capdesk or have unpublished data on the platform please select "Include Drafts" this will include all of your unpublished data in the report. 

Round Modelling Picture 3 

3) The Round Model Report

Once you've downloaded the excel file, you'll be shown the "Round Modelling" report;

Round Modelling picture 4

This gives you a view of the fully diluted cap table before and after the new investment. 

 

The orange cells in the "Investment" column is where you can enter the new amount invested by each potential investor. 

Round modelling screenshot 5

 

4) Adding more investors to the report

You'll have to click on one of the new stakeholders and right-click to insert a new line

Then you will be able to enter the name of the new investor and the amount they invested

5) Managing the Option Pool 

You can calculate the number of options needed to maintain the option pool as a percentage of the cap table by using the tools on the top left hand of the report, "Pool Adjustment Method" and "Adjust To".

- The "Pool Adjustment Method" selects which part of the option pool you wish to adjust 

- The "Adjust To" the proportion of shares you wish the option pool to account for

Round Modelling

- The "Pre-money Valuation" is the aggregate pre-money valuation, rather than the price paid per share

- The  "Post Investment" box gives you an overview of how your fully diluted cap table will appear after the new investments have taken place

Round modelling screenshot 6

 

For the pool adjustment function to work you may need to enable iterative calculations, to do this you'll need to complete the following tasks, File->Options->Formulas->Calculation options->Enable iterative calculation.

 

If you need further assistance, you can reach out by submitting a support ticket here.

 

Thank you for reading this support article, if you are interested to read other articles that relate to managing your account, please see this page of articles: support.capdesk.com/stakeholders