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) 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.
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.
3) The Round Model Report
Once you've downloaded the excel file, you'll be shown the "Round Modelling" report;
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.
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
- 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
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