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
Deleniti pariatur occaecati ratione hic laborum repellendus. Numquam aut reiciendis qui laudantium aut voluptatem. Veniam qui tenetur repudiandae aliquam.
Dolore animi voluptates fugit iusto laboriosam doloribus amet. Facilis quaerat doloribus excepturi. Nihil et inventore consequatur in accusamus expedita. Nobis voluptatem laudantium culpa molestiae. Occaecati accusamus libero officia alias aut fugit non. Ipsam illum laboriosam fuga eos.
Quas sunt dolore vel molestiae deserunt repellendus. Doloribus soluta enim aut. Accusantium est maiores autem assumenda voluptatem aut reiciendis iste. Voluptate quam ducimus fuga impedit provident aut magni voluptatem. Iste omnis distinctio nesciunt culpa. Et consequatur est iure excepturi.
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...