LBO Modeling Question
Anyone able to help with a quick LBO modeling excercise?
Trending Content
Career Resources
WSO Free Modeling Series - Now Open Through
April 30, 2024
9 Free Financial Modeling Lessons
Get instant access to lessons taught by experienced private equity pros and bulge bracket investment bankers including financial statement modeling, DCF, M&A, LBO, Comps and Excel Modeling.
+Bonus: Get 27 financial modeling templates in swipe file
+Bonus: Get 27 financial modeling templates in swipe file
what is the question?
Can you fill in the blanks in yellow?
some of this is quite straight forward i think which u can figure out
goodwill:
purchase price of equity = purchase equity row in entry valuation
TBV of equity = link to balance sheet equity
Allocable purchase premium = purchase equity - tbv equity
write up of ppe: 15% * allocable purchase premium
write up of intangibles: 30% * allocable purchase premium
allocable purchase premium - write ups = goodwill created
DTL = write ups * tax rate
goodwill post dtl = goodwill + dtl
btw if u have existing DTL u need to substract it from "Goodwill Created" since it gets wiped out and replaced with the new one u created from the writeups
Thanks for the help, would you be able to help with the Fees and sources and uses?
and TBV u need to exclude existing goodwill since this gets replaced too
Quia placeat quam autem velit soluta quibusdam maxime. Sint voluptates nihil tenetur aut. Qui sit ut eos molestiae corporis voluptatibus quos. Unde nesciunt accusantium qui exercitationem aut eos. Quibusdam eum exercitationem voluptatem et ut sit.
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...