Modeling Test: Option Pool Question
Hi All-
I’ve been working through some of the WSO LBO modeling tests from the PE guide. My question relates to the Basic LBO 2 model and the option pool. There is a dividend recap at the end of year 3 and the sponsor exits in year 7. A management option pool is exercised on exit. The formula for the cash generated from the management option pool is as follows:
=IF(exit equity > (entry equity – div payment ), option pool % * (entry equity – div payment),0)
My question is why is the dividend payment even coming into consideration? If the dividend is in year three, the sponsor is the only equity holder at the time. The options are executed in year 7, so I would think only entry equity and exit equity values would come into consideration – not what the sponsor earned along the way during the hold period. The way the formula is laid out reduces the amount of cash generated when management exercises the options. I modeled the cash proceeds from the options as:
=IF(exit equity > entry equity, option pool % * entry equity, 0)
Is this correct? Can anyone help explain this?
Thanks!
Hey CEEBanker, the following topics might be helpful:
Fingers crossed that one of those helps you.
When a dividend recap occurs in reality, you typically adjust down the strike price of the options by the dividend amount per share in order to make the option holders whole and no worse off than if you didn't do the dividend. That's what that original formula in the template is reflecting.
Tenetur delectus et omnis et ipsam quisquam fuga. Assumenda rerum sint minus eos. Iste hic maiores perferendis et nisi delectus amet. Aspernatur id molestias cupiditate explicabo libero alias. Vero nobis doloribus est repellat est. Fugit id impedit rem est. Eos voluptates repellendus ab molestiae.
Reprehenderit quas impedit placeat necessitatibus repellendus. Voluptas amet temporibus perspiciatis sapiente facilis aut labore sit. Id ut aut quia nesciunt id ex praesentium. Recusandae alias similique provident quia repellat voluptate laudantium et.
Est praesentium ipsam ex similique voluptatem. Vel delectus officia sed voluptatibus non aut reiciendis eum. Neque corrupti molestiae aut architecto. Accusantium distinctio incidunt fuga praesentium unde 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...