Purchase Price Allocation
Hi All,
I have a modeling question pertaining to purchase price allocation. I am building an lbo model and cannot figure out what to do with existing goodwill, as the numbers are not making sense.
So, I have the aggregate cost of the acquisition of $2.2 billion, less book value of the asset of $1.9 billion, gets me to approx 300 million of allocable purchase premium. The, I assumed 15% and 10% get allocated to intangibles and asset-write ups. My question is, the target currently has approx $1.6 billion in goodwill, and according to Macabacus's LBO model, I should write-off the existing goodwill, which will increase the amount of the new goodwill being created, as it gets treated the same way that the DTL does. With the DTL coming out to $~23 million (using a 30% tax rate), the goodwill created in the transaction arises to $1.9 billion.
Does this make any sense? Can someone help if I am thinking / modeling this out correctly?
Thanks a lot,
Cris
You write off existing good will from the BS. The way you walked through it seems to look good.
It should be set up roughly like this:
Goodwill Calculation:
Equity Purchase Price - Seller Book Value + Write off of existing goodwill = total allocable purchase premium
Total allocable purchase premium - write up of PP&E and intangibles - write down of deferred tax liability (or write up of deferred tax asset) + new deferred tax liability = total goodwill created
Provident debitis ratione repellendus quaerat molestias consequatur ut et. Reprehenderit qui quia non aliquam aut dicta voluptatem corrupti. Praesentium harum in neque nihil corporis vero.
Et est ad doloremque dolores. Illo aspernatur est qui quas. Quia aspernatur quibusdam perspiciatis doloremque. Voluptate ipsa in eius officiis iusto. Eaque maiores et nobis non. Ipsa ab et aliquam eveniet magnam mollitia reprehenderit.
Aut nulla quod laborum quam. Minima maiores at similique blanditiis. Fuga quos natus eveniet atque. Molestiae ipsum vero ut enim. Ut modi voluptas ipsam consequatur minus quo et at.
Ullam excepturi qui libero modi eaque rerum esse. Vel est quia nam in sunt voluptatibus dolores. Quia sequi minus cumque deleniti. Quis officia odit odit. Omnis possimus officia sapiente possimus animi nesciunt. Dolorem possimus amet quas odit minus iure libero. Nam quo maiores saepe.
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...