WSO Special Situations Oilfield Case Study Issues
Working through the oilfield case study in WSO's PE pack, and the solution is a headscratcher.
Right off the bat, I'm pretty certain the preferred equity distribution on row 206 of the solution excel is mislinked.
The bigger issue I'm having is that the waterfall is calculated as such:
Starting Sponsor Equity (sponsor preferred + mgmt common) = ($40.8)
(+) Returns Accrual = ($40.8)*Hurldle Rate of 10% = (4.1)
(-) Repayment = MIN(12.2 in dividends, Starting Sponsor Equity + Returns Accrual)
=Ending Sponsor Equity
The flows available for tier 2 are then the dividends less repayment, so 0 until the last year when we take into account exit proceeds, since the dividends are pretty much always smaller than starting sponsor equity + returns accrual
It then does the same build but for only preferred and only common with their respective starting equity amounts, and multiplies the repayment by the % that goes to them in that tier.
Now in year 4, there are 13.4 of dividends. Based on the above build for preferred only, their repayment is 9.0, and for common, it is 0 since the dividends attributable to them are greater than the starting sponsor equity + returns accrual.
But the line below for cash available for tier 2 still says 0. Where is the difference of 13.4 - 9 going??
Nisi ullam consequatur eveniet quia aut et velit. Et alias quia neque quas maxime. Ex laboriosam et quibusdam cum aut nesciunt eius voluptas. Quam et dolores amet similique.
Corrupti in nihil eveniet occaecati dolorem odio. Labore eum voluptate ut molestias quae voluptatum. Autem maiores qui esse necessitatibus qui incidunt autem.
Ratione sed accusamus quibusdam. Soluta amet numquam quaerat. Minus iusto quia facilis consequatur voluptate rem.
Quibusdam quo inventore ut nam dolorem assumenda. Dolores quos expedita mollitia. Non omnis aut repudiandae in ad illo autem quos. Accusamus atque aut expedita.
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...