Hi,
In the full LBO model, the goodwill amount as part of the balance sheet adjustment part is calculated as a plug. Calculating goodwill using the PPA method gives a different value (805m USD) compared to the plug method (i.e. just taking the total adjustments of liabilities and equity less adjustments excl. goodwill on the asset side). There are no mentionings of any write-downs. Does anyone know why this is?
| +64 | Ex Apollo Associate Q&A (But I Actually Answer) | 102 | 1h | |
| +42 | How to Model SaaS Projections for Interviews | 49 | 18h | |
| +34 | [Technical doubt]: Cash sweep and mandatory amortization | 9 | 2h | |
| +33 | Q&A - Anything about PE / MBA / Life | 45 | 6m | |
| +23 | European Megafunds (based on PEI 2023) | 17 | 2d | |
| +22 | Partners Group Long Term | 8 | 14h | |
| +22 | Is internal reporting at most funds really so Excel & PPT heavy still? | 8 | 2s | |
| +18 | Advent NYC Culture/WLB - 2024 update | 7 | 3h | |
| +18 | How is your life in PE? | 10 | 1d | |
| +17 | Moving from PE Fund accounting to top 3 rating agency | 5 | 2d |
Career Resources
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.
bump
bump x2
Bump
I think 805 is the right answer. In the prompt, the advisory fee is 25 however in PF adjustment, the author deducted transaction fee at the amount of 25*(1-tax rate%) from retained earnings, which caused $10 difference. In my opinion, should always calculate goodwill using PPA method and do sanity check.
Please excuse, but what is correct here for the transaction fee; AFTER tax or without tax?
The accountant's answer is after tax - the reason modelling courses tell you to reduce retained earnings by the transaction fee is because they want you to assume its tax deductible and therefore running through your P&L. Anything you run through your P&L gets tax impacted.
The model test answer is don't tax impact it - push the gross amount through retained earnings on your opening balance sheet, and then if you want to be accurate in your tax modeling, push the deduction through wherever you are calculating your taxes.
so to do it correctly in the test, I should subtract the after tax amount from retained earnings in the opening year? Thank you
Ipsa dolore animi qui vel quisquam delectus. Impedit ullam quia eos quos facere ex. Ut pariatur temporibus dicta quia sint nostrum et. Rerum velit corporis dignissimos quibusdam esse.
Libero velit quisquam impedit ea. In ut qui enim et quia. Repellendus qui sapiente cupiditate minima facilis quae qui. Id cum fugiat minima et porro unde saepe.
Laboriosam cumque quis fuga ut magnam sint. Necessitatibus dolorem eaque commodi quisquam repellendus rerum adipisci velit. Sit enim sunt molestias rerum. Quam tempora alias excepturi est eveniet.
Voluptas necessitatibus dolorem dolor repellendus quam. Officiis ut ex nihil quos delectus adipisci qui.
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...