Note Discount Cap Worksheet

Description
"Venture math can be tough. Terms like convertible note, discount and cap can complicate a seemingly easy process. A convertible note is a debt instrument typically used when a company first begins to raise capital. The valuation of the company is determined at a later date, after a Series A investment. This is when a note converts to equity at the previously agreed upon terms. A discount and cap are typically included in those terms. A discount gives a note holder’s small investment a little bit more purchasing power. But with a discount, there is no limit to the valuation of the company. That’s where the cap comes into play. A cap limits the valuation of the company to a pre-determined price. In other words, it protects early investors (note holders) from being diluted to oblivion. Owning 0.0004% of a company sucks for someone who took most of the risk, and a cap prevents that from happening.

While often spoken in the same sentence, a cap and discount are never used at the same time. They are mutually exclusive. When a note converts, the more generous of the two options is used. That depends on what the valuation of the company is, and the amount being raised in the Series A, among other things.

The terms of a note can vary dramatically, but the most common include a $3m cap, 20% discount and 8% interest. So, how much does the team own after the Series A (when the note converts)? It’s tricky to figure that out, so I put together the attached spreadsheet to help."

Note: "The spreadsheet provides a visual for what has been explained by many others, on many different sites (I learn easier this way). It can be a good resource to send to family/friends participating in early rounds. However, there are easier ways to relay the information. For example, using back of the envelope math, you can figure the cap table out without a number of shares (see the rows labeled “equity” for the formula).

So, take the spreadsheet with a grain of salt (I’ll post updated versions here, if necessary). The spreadsheet is not a suggestion on how to do your fundraise, and it’s certainly not legal guidance. It’s just another helpful resource (hopefully), among many."

- Raji Bedi, www.rajibedi.tumblr.com, 2012