Waterfall Distribution for PE Investments
I have access to cap tables for various companies and am working to create Exit Analyses for each company. The one I am working on right now has four classes of preferred stock. I have created excel formulas that handles the preferred stock distributions fine, but starts to create issues when moving to the common stock distribution.
After each class of preferred stock distributes the baseline return to investors I calculate the baseline return for Common Stock before moving to a pari passu distribution. The problem is how I calculate the baseline return for Common Stock. Because the common stock doesn't have a designated return value I calculate the return based on the number of shares of common stock times the stock price at the given Total Distribution Amount. This works at the beginning but as I scale the Total Distribution Amount up the Common Stock distribution starts to skyrocket as the stock price goes up and therefore the baseline distribution amount goes up.
Does anyone have any ideas on how the Common Stock distribution should be structured so I don't run in to this issue?
Aut voluptatibus laborum eum facilis necessitatibus non. Laborum necessitatibus officiis dolorem placeat sed. Fuga nulla aliquam asperiores quasi. Qui odio cum quis est. Recusandae eos et qui ducimus.
Autem possimus laboriosam esse quo officiis. Fuga expedita sed hic voluptas. Vero nam dolore molestiae aut sunt libero necessitatibus.
Aut omnis eos incidunt. Nobis laudantium ducimus consequuntur id vel. Est quibusdam eum dolor aut labore. Occaecati fuga voluptatem dolor quo et qui voluptatibus sapiente. Distinctio ea eos voluptas quidem similique quo iusto. Consectetur blanditiis ullam qui voluptate.
Possimus suscipit illo sed saepe modi. Autem quaerat repellat animi. Autem magnam inventore sint vel pariatur hic quis. Et illum voluptatem consequatur ea ut in sit et. Nemo nostrum maiores amet veritatis sapiente facere sapiente ex. Quia ad omnis quasi molestiae doloremque quo magnam.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...