LBO Modeling Question

Anyone able to help with a quick LBO modeling excercise?
Keywords

Anyone able to help with a quick LBO modeling excercise?
| +40 | Take the Layoff or Quit? | 14 | 13h |
| +36 | Fund going shit but happy with life what to do? | 8 | 1d |
| +34 | PE PortCo Work | 18 | 2d |
| +24 | Rugpulled on Sr. ASO promote - how to fill a year (or two) before B school? | 7 | 2d |
| +16 | Those who exited PE, When did you know it was time? | 6 | 2d |
| +15 | Practical uses of of AI in PE | 1 | 5d |
| +14 | Case Study - HELP! | 4 | 2d |
| +14 | Paper LBO | 4 | 4h |
| +14 | PE on cycle guide | 2 | 8h |
| +9 | PE -> Sales/Entrepreneurship? | 3 | 3d |
Career Resources
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
Et ut quia debitis nobis est. Ut molestiae voluptate molestiae aliquid nihil eum corrupti. Quia ut ea exercitationem voluptas dolores sed fugiat. Consequatur veniam inventore aut et pariatur aut occaecati. Et aspernatur officia mollitia odit accusamus et.
Ut earum aut recusandae impedit consequatur voluptatibus ea. Temporibus adipisci voluptates facilis pariatur velit ab et. Velit in a nisi aut. Maxime et assumenda ut quia ut voluptas suscipit.
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...