Also just a heads up, when I got the email with the spredsheet google was marking it as spam because you are using a gmail account. If you use a domain email, it'd probably reduce spam
Thank you for this great video. If I may ask: I did not understand why the other investors in the Series A round got diluted when the Pro Rata kicked in but not the shares of the lead investor? Was this defined somewhere?
After working with the spreadsheet (thanks) I have an observation. With the post-money SAFE there is an option to offer a conversion discount, which basically means a 10% discount would convert for about 10% more shares when the priced round closes. But this spreadsheet has a "percent" field which I assumed was the percent of the conversion discount. It is not! When you put 10% in there the final calculation makes that SAFE investor's money worth 10% of the company. So there is no way with this spreadsheet as it is to factor in a conversion discount for a SAFE.
That is correct - the purpose of this spreadsheet to help understand how the post-money value affects the final stock price (and the dilution). As pointed out in the Video "How Discounts and Valuation Caps Work" (ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-lTV_neMV1Kw.html) to analyze a SAFE that has both a discount and a cap, you need to calculate the stock price implied by the discount and the price implied by the cap to determine which term gives the better price. Once you have the Series A price, the discount price is easy to calculate - just apply the discount to the Series A price.