Using the Convertible Note Calculator
The convertible note calculator assumes that the business has already issued a convertible note and is now at the stage where it is seeking additional outside equity investment.
The calculator is available for download below and is used as follows:
-
Enter Pre-money Details
Enter the number of existing shares and pre-money valuation of the business. These shares will typically have been issued to the founders of the business.
-
Enter the Convertible Note Details
Enter the amount, discount, and cap for the convertible note. The amount of the convertible note should include any accrued interest accumulated on the loan note since it was issued.
The calculator works out the conversion values based on both the discount and on the cap, and uses the maximum of these two values for the remaining calculations. Details of these calculations can be seen in our conversion loan notes tutorial.
-
Enter Investment details
Enter the amount of the additional equity investment being sought by the business. The calculator works out the post-money valuation of the business
-
Ownership
The convertible note calculator calculates the percentage shareholding, number of shares, and value held by the investor, noteholder, and founders of the business, following the conversion of the loan note and the injection of the additional investment.
-
Share Price
For additional information, the calculator also shows the share price paid by the investor and the noteholder. Due to the effect of the convertible note discount and cap, the price paid by the noteholder will usually be less than that paid by the investor. The calculator also shows the effective discount on the share price that the noteholder receives.
Convertible Note Calculator Download
The convertible note calculator is available for download in Excel format by following the link below.