Mistakes on WSO PE Prep Pack Models?
I am working through the full-version practice lbo models on the prep pack, and there are some minor differences in the way I usually model versus what is being shown. I could be wrong, but I believe the prep pack has some mistakes and it is driving me nuts... Was wondering if you guys could help me out with the below to figure this out. For reference - I am working on the LBO Full Version #1 for those who also have the prep pack.
1) First, shouldn't OID get capitalized on the Balance Sheet and amortized over the life of the financing? The practice model shows the OID (of $6) being netted against the $600m of new Term Loan debt going to the PF opening balance sheet. So the opening balance sheet shows $594 instead of $600. I understand in reality that is how much the firm will actually receive (I know what OID is so please don't explain it), but isn't OID usually treated as a "fee" and capitalized on the BS accordingly? Usually we see this being expensed / amortized annually. Is this not correct? My entire BB does it this way.
2) On top of the above, the solution model does not have the capitalized financing fees being expensed on the income statement each year and subsequently being added back on to the CFS, despite the Balance Sheet showing a decreasing balance on the Deferred Financing Fees line. This also makes no sense to me and I am not sure how the solution model even balances with that. Obviously this is minor because the cash benefit will solely come from the tax shield on the expense, but nonetheless it does not seem dynamic / accurate to leave that out. Can someone confirm this?
2) Additionally, the solution file has the Purchase Price of Company XYZ as Purchase of Equity ($955) plus total debt ($450). However, there is cash of $100. They do not net out cash to derive an implied Purchase Price / EV, which also does not make sense. They are showing the $100 as a source of funds, but it is not being reflected in the purchase price. This ends up making my model completely different than the solution because sponsor equity is calculated as a % of that, so everything ends up being slightly off. Are they correct in showing it this way?
Thanks!
WallStreetOasis.com
Id consequuntur natus itaque eaque. Voluptates est voluptas asperiores modi ab. Asperiores ea voluptatibus sint odio quasi praesentium eaque debitis. Vel accusantium necessitatibus reiciendis. Facere consectetur cupiditate quae consequatur. Aut est incidunt repudiandae voluptatem nihil voluptatem voluptatem.
Minima sit omnis quis rerum. Aut porro hic necessitatibus et ipsa eaque facere. Earum maxime qui ullam qui ut. Et quas perferendis facere et est. Vitae laboriosam cupiditate ab sequi.
Asperiores debitis eius quae vel in. Rerum et non libero sint magnam vitae voluptas. Rerum ducimus eaque optio laudantium dignissimos dicta et. Possimus voluptas quo in qui. Et laboriosam nostrum et enim.
Amet nobis dicta nobis necessitatibus qui quibusdam et. Sed ut perspiciatis voluptate est non velit. Magnam dolorem consectetur est rem ratione est quidem.
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...