Angelcalc
Load Model:
Model Save Model converts only ?
Common Stock Add Common Holder



Convertibles Add Convert


Equity Add Round


Model Save
Precision for calculations:

Instructions (hide)

Angelcalc models the conversion of safes and/or convertible notes during an equity financing. It uses techniques similar to those used by Microsoft Excel to make its calculations. The instructions below outline the steps necessary to create and save a model of a particular financing. A sample model with two safes and a $2,000,000 financing with a $8,000,000 pre-money valuation is automatically included to help demonstrate what a conversion looks like. Detailed instructions for how to create your own model follow below.

STEP 1: For each convertible in the deal, click the Add New link to add that convertible to the model. You will need the total investment in that convertible, including any interest, and the discount (if any) and cap (if any). You may also include any investment you made using this convertible.

STEP 2: Fill in the following fields for the financing:
Your InvestmentIf you are an angel and invested in the round itself, enter the amount here.

Total InvestmentThis is the total amount invested directly in the equity round (including yours, of course).

Options / PostThis is the post-money unallocated pool of options as a percent of the total fully diluted post-money shares. This percentage is usually negotiated.

ValuationThis is the company’s negotiated value, either pre or post money.

Fully diluted pre-money sharesThis is the company’s total fully diluted shares outstanding prior to this deal, including all allocated and unallocated options.

Unallocated pre-money optionsThis is the count of options from any pre-money pool which remain to be allocated.
STEP 3: Click the "Model" button to create your model. You may specify the number of decimal places of precision that the model uses as well. This is helpful to match Excel models where the modeler chooses to round their calculations. The model may also be named and saved (by clicking the "Save" button), but this does require a (simple) registration.

You may compare two different models or variations on the same model by clicking Compare (also in the nav bar).


Note: Convertibles.
The following convertibles are supported:

  1. Standard Y Combinator (YC) safe (simple agreement for future equity) with a pre-money cap and / or discount.
  2. Standard YC convertible note. This is a debt instrument and will usually include an interest rate and a maturity date - neither of which are modeled by Angelcalc.
  3. YCVC safe: specialized vehicle for YC companies.
  4. Post money safe: This is a safe with a post-money (this means post all other seed money) cap
  5. Custom Convert: This convertible is customizable in terms of when the cap or discount is used as well as the key components of the denominator used to divide the cap / valuation.
  6. Manual Convert: This convertible can be used in the event a convertible type is not known or supported. In that case you may simply enter the investment amount and the number of shares into which that investment converted. These will then be incorporated into the model.
Please note that interest is not calculated by the model. Rather, it is assumed that these amounts (your interest and total interest for all investors) will be provided by the company and entered as part of your investment and the total investment for any convertible which includes an interest rate (e.g. a convertible note).


Note: Calculations
If there is any doubt as to the calculation used to determine the price at which a convertible converts and therefore the number of shares into which it converts, the "Show Calc" link next to each entry in the cap table gives the details of each calculation.


Note: Accuracy
It is highly unlikely that this model will give precisely the same values as an Excel model due to rounding differences even if the precision chosen is the same as used in Excel.


Disclaimer
The values calculated by this model are for comparison purposes only. Their accuracy is not guaranteed by the author. It is likely that this model will differ from Excel models of the same capitalization table, even when the inputs are identical due to rounding errors. No representation is made in any way as to which is the "correct" model in this case.

© Copyright 2016/2017 Geoff Ralston -- Privacy -- Terms