M&A add-ons modelling
How do you model a m&a add ons case? More specifically in case of NWC / change in NWC.
If you start from the NWC you will need to have a suspicious amount in the year prior the acquisition to get a change in NWC for the year of acquisition. Then in the total NWC for organic and inorganic case you will have an issue in the total amount of NWC vs. change in NWC which do not match (since I do not include the amount of suspicion NWC in the first year).
How do you guys work around this in your model / LBO.
Can you give an example? Frankly I have no idea what you’re asking
Think I know what you're getting at but can you rephrase / provide an example on this?
Absolutely. See below a potential example with Y0 the first year after the acquisition (forecast) and Y-1 the actual data. The question is around how I should look at the NWC of the potential add-ons for the period prior the acquisition of the target given that you do not really have NWC before that but you need to calculate the change in NWC during the same year. Let me know if more clear the question
Organic
NWC (Y0): 100
NWC (Y-1 Actual, prior LBO): 50
Change in NWC: 50
+++
M&A Add ons
NWC (Y0): 20
NWC (Y-1 Actual, prior LBO): 10 >> Fictitious figure to get a change in NWC
Change in NWC: 10
+++
Total
NWC (Y0): 120
NWC (Y-1 Actual, prior LBO): 50 >> excluding the fictitious figure and because its pre potential acquisition
Change in NWC: 60 >> issue with excluding the fictitious figure is that now the change does not match
What is the question? It genuinely sounds like you're just trying to apply some formulaic logic without taking a step back and thinking about what you're actually doing...
You're are acquiring NWC of the target at a steady state. Any deviation from normal levels of NWC is covered by the purchase price. That said, for the purposes of the exercise you can ignore the target's NWC requirement for CF impact.
Est voluptatibus omnis nemo dolores. Expedita cupiditate est qui enim ea. Dolorem natus odit quia. Officia minima quam doloremque assumenda.
Deleniti quas deleniti voluptatum vero officiis maxime et. Dignissimos dolores illum dolor incidunt ut similique. Ut ut voluptatem accusantium culpa. Quia maxime voluptas nihil in corrupti natus sunt. Sint maiores totam doloremque est atque ut. Blanditiis itaque qui minus laudantium nihil. Omnis porro quia dolorem quis mollitia quibusdam.
Iste possimus consequatur doloremque consequatur non laboriosam dolorum. Fugit et sed sed vel optio. Error quo sit expedita cum. Voluptatum eveniet eos quis dolore minus at.
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...