Round modelling report is an excel sheet you can use to model new financing round.
Once you have clicked on "Round modelling", you'll be brought to the "Order Report" page where you can decide what you want to include in the report.
Once requested you will see the below confirmation message:
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.
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
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 "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.