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:

• Mgmt Options Pool Calculation in Basic LBO Model Example basic lbo model examples. The calculation is "new equity * [(mgmt %) / (1+mgmt%)]". Why do you ... need to divide by (1+mgmt%)? Mgmt option pool LBO ... Hello, Can someone explain the theory behind the formula for cash out from mgmt options in the ...
• LBO Model- Management Option Pool How would you model this in an lbo model test during an interview? My thoughts: Would you assume ... / 90 share The mgmt would receive 10 options with a strike price per above. Then once you exit in year ...
• "How Much Debt Can the Company Support" Question in Growth Capital Modeling Test regular one-page lbo model. The question is: "Based on your analysis of the free cash flow, how much ... Hello, I am working on a Growth Capital modeling test. After a standard 3-Statement projection in ... the next five years, there is a follow-up question about debt and I think it is quite different from ...
• PE/LBO Model request- (Upcoming interview!) **Included an example question on dividend recap that needs an answer** format- 2/3hr modeling test (maybe without presentation- this is TBD) Thanks again all! EDIT: See my post ... I've got a few models here and there to look at and practice with, but they are from BIWS ... below- I included an example case study question w/ some arbitrary numbers. PE WSOers, pls take a look to ...
• 5-Hour PE Interview LBO Modeling Test + IC Memo Hi all, May be taking a 5 hour-ish test soon wherein you have to create an LBO modeling test ... little experience with LBO models, had a couple of quick questions regarding this. Understand that ... created in the first place- understand this is needed in a merger model but why is all this adjustment ...
• LBO Modeling Help! questions has already been answered. I've recently been through several LBO modeling tests and have ... I should reflect this in the model? Thanks a ton in advance! LBO Model Question ... seen several times transaction assumptions that say something like "10% management option pool ...
• 2 hour LBO modeling test. How simplified can the model be? seek assistance with preparation. I've been told there is going to be a 2 hour modeling test ... building an LBO model and reaching conclusions. Probably have to set up a few slides presenting as well. If ... , apparently consisting of 1 hour of discussion/familiarising with the company in question and 1 hour of ...
• More suggestions...

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.