Convertible vs. Participating Preferred Stock
Convertible Preferred Stock will either convert into common or stay as preferred (and take out its liquidation preference and dividend) in a exit event. For Participating Preferred Stock, the liquidation preference and dividends are taken out, and then converts into common. In common, the Participating Preferred Stock takes their ownership amount along with the other common shareholders. Sometimes this is referred to as “double dipping”.
The example to the right illustrates how each type of preferred stock behaves given the same exit event. Participating will always give a higher return to the investor than convertible. Try some different exit values to see how each type of stock behaves.

this tool is great. I can't intuit the formula being used. Is there a way to reduce this to excel formulas?