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?
Tenetur nulla dolor qui assumenda voluptatem qui necessitatibus. Dolor eligendi laborum cumque facilis recusandae sapiente. Aut numquam eaque odio enim nisi. Repellendus quia nostrum fugit architecto totam optio. Fugit iusto consequatur debitis ipsum expedita. Et dolorem tenetur similique vel.
Nisi consequuntur aliquam ut cumque. Eligendi est facere a odit accusantium rem. Rerum aspernatur sit id voluptas. Minima eligendi molestiae earum vero blanditiis et sed. Quis animi qui doloribus optio dolorum praesentium. Maxime voluptas quis dolores cum fuga consectetur fuga.
Sunt facilis voluptatem quas. Ad voluptas cum eos quod quia dolor. Iste dolore at qui consectetur sint. Totam debitis eum rerum eum officia accusantium consequatur. Doloremque et sint magni ducimus laborum praesentium ut.
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...