Pro cap table training course

CAP TABLE #13: Accounting for convertible debt and warrants sheet

Tl;DR: This is the 13th part of the Pro Cap Table training course where we deal with accounting for convertible debt and warrants. In this series we go through the basics you need to know, then worksheet by sheet so you know how to make a seriously kick-ass cap table.

There are 14 parts:

  1. What is a cap table and other important questions
  2. Cap table dilution step by step example
  3. Cap table dilution math
  4. Starting the cap table (The drop down menus we need)
  5. Shareholders sheet
  6. Deal calculations
  7. The cap table sheet
  8. The assumptions sheet
  9. Individual shareholder returns sheet
  10. Returns waterfall calculation
  11. The ESOP sheet
  12. The Common sheet
  13. The convertible notes and warrants sheet
  14. The preference shares sheets (From Series A to I)

You can join the course and get these sent straight to your mail box here:


We are going to cover two sheets today (convertible debt and warrants).

Let’s go over accounting for convertible debt in the Notes sheet.

If you don’t know this well, recommend you read:

At the top of the sheet are calculations to make filling in the sheet easier. You know what the conversion price is per round. This is used to calculate the shares CNs get.

Input the names of the Angels.

Next, you want to add the class of share they will be converting into. If you do a CN seed round, then this is going to be your series-a.

Input the issue date, which is basically the seed close date. Then add the maturity date – this is typically 12 months after the issue date.

If you cancel the convertible debt for some reason, add the date of cancellation.

The date of conversion is pulled from the inputs at the top.

Note term simply is a check to tell you how many months the convertible debt can last for.

convertible debt

Here are the terms of the convertible debt.

The principal amount is how much is invested. The interest rate is whatever you agreed to pay. Interest calculated the interest portion for you.

The cap is whatever you agreed as is the discount.

The effective discount is super handy. This calculated the actual discount rate the CNs get depending if they would opt to use the cap or discount.

convertible debt

The conversion price is the effective discount on the conversion price of the actual round (eg S-A).

Next, we see how many shares investors get from principal and interest. You add the two.

  • Underlying Principal Shares 
  • Underlying Interest Shares

Comments are comments. They invested in the seed round so they should convert into S-A class of shares.

convertible debt

Now let’s do Warrants in the Warrants sheet.

Input the investor name and the warrant cert number.

Input the issue date and expiration date, similar to what you did in the CN sheet.

Input the class of stock they elect to convert into. Warrants are different to CNS in that they give a lot more flexibility to investors (typically).

  • Exercise price – if they exercise, what price? That’s at series a in this example
  • Warrant Shares Issued – how many shares did they get issued?
  • Date of Exercise – what’s that date when they choose to exercise
  • No. Exercised – They may not need to exercise all of them, so how many are exercised
  • Date of Cancellation – If you cancel them, what date?
  • No. Cancelled – how many were cancelled
  • No. Outstanding – how many are still outstanding. This is a calculation
  • Comments– add comments…

Warrants are not common which is why I am not spending a tonne of time on them.

convertible debt


Click here to continue

The preference shares sheets (From Series A to I)

Show off to your friends. Hit a social button to share the cap table love!

Get in the game

Free tools and resources like this shipped to you as they happen.

We won't send you spam. Unsubscribe at any time. Powered by ConvertKit

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.