Round modelling report is an spreadsheet you can use to model a new financing round.
Round modelling is a report you can use to model a new financing by entering a pre-money valuation, adding projected investments, analyzing the effect on share price and company ownership and modeling the adjustments to the incentive pool.
Exporting Round Modelling
1. Navigate to Ownership > Cap Table page and click Reports.
2. Click Round modelling.
3. In the Customise your round modelling report page you can decide what you want to include in the report. Click Request report to download the spreadsheet.
- Currency: the report will convert values and notes to the selected currency.
- End date: the report will include transactions up to and including this date - cannot be a future date.
- Content: what, from the company's current cap table, will be included in the report.
- Round instruments: what type of equity will be modeled in the new round (shares are included as a standard).
4. The report will be generated and sent to your email address within a few minutes. You can also download the report from the widget at the bottom right of Carta.
Inputs
The report gives you a view of the fully diluted cap table pre-investment, post-investment and an investment section.
To model the new round, you can add data to the following fields:
- Pre-money valuation (cell D3): is the aggregate pre-money valuation, rather than the price paid per share.
-
Pool adjustment method (cell D4): adjust the pool size for post-investment size - this requires enabling iterative calculations to properly work. If using:
- Windows: File → Options → Formulas → Calculation options → Enable iterative calculation
- Mac: press Excel → Preferences → Calculation → Use iterative calculation.
- Adjust to (cell D5): input a percentage value.
- <<New Investor>> [C20]: Input the name of the new investor.
- Investment [P20]: Amount invested by the new investor.
Post Investment Cap Table
The Post Investment section gives you an overview of how your fully diluted cap table will behave after the new investments have taken place.
Add More Investors
- Click on one of the new stakeholders cells.
- Right-click to insert a new line
- Enter the name of the new investor and the amount they invested.