LBO and IFRS Leases
Hi all! I have a question on how to account for existing IFRS leases in an LBO model.
Specifically, how would you record in the 3 statements a rolling of the leases in an LBO modelling test
Lets assume that when you purchase the company, it has 500 RoU assets and 490 lease liabilities - this is all we know
I want to model the sponsor acquiring the company, and rolling the leases in a way that it is more or less realistic and simple to model in an modelling test
The approach i was thinking:
- in s&u, sources will account for the refinancing of lease liabilities
- lease liabilities will be included in net debt, affecting purchase price allocation and hence pro forma goodwill
- when i do the BS m&a adjustments, i would simply kill existing lease liabilities and existing RoU assets
- then going forward model lease liabilties as if it was debt (not sure how to show here that RoU assets and lease lisbilties amount may differ)
Any thoughts?
Ah, navigating the jungle of LBO modeling with IFRS leases, are we? Let's swing through this together, branch by branch.
First off, your approach to handling IFRS leases in an LBO model is on the right track. Given the scenario where the company has Right-of-Use (RoU) assets of 500 and lease liabilities of 490, here's how you might refine your approach based on the most helpful WSO content:
Sources & Uses (S&U) Table Adjustments:
Net Debt and Purchase Price Allocation:
Balance Sheet (BS) M&A Adjustments:
Modeling Lease Liabilities and RoU Assets Going Forward:
Interest Expense and Cash Flows:
Remember, the key to a realistic and simple model is clarity and consistency in your assumptions. Make sure to document your assumptions clearly, especially regarding the terms of the refinanced leases and the depreciation/amortization methods used.
Swinging through the financial modeling jungle can be complex, but with a clear map (or model structure) and a keen eye for detail, you'll navigate it like a pro. Keep those bananas handy for energy, and happy modeling!
Sources: Adjusting EV for Operating Lease Liabilities?, Beyond the guide: a list of real interview technical questions, LBO and leases, Creating own LBO assumptions, Paper LBO Model for SA interviews?
If you roll the leases, you wouldn’t be refinancing them. Treat the same as rolled equity and it would reduce the amount of outside capital you need to raise to fund the txn.
Yep. Dont listen to the bot’s answer on this one
Makes sense! But how would you project them forward in a simple way? Do you think keeping them flat and flagging as an assumption for simplicity would be fine in a 2h PE interview?
Just grow them with some nominal amount and keep them as a liability at the end. Don’t overthink it. These are office rents and whatnot so probably it increases a bit as the business grows but not too much. Not worth spending time on
So you would grow RoU and lease liabilities of the same amount, so effectively no impact on the BS.
Basically we dont take into account the D&A, interest expense and lease payment in the IS and CFS - not worth the time needed i guess?
No, the cashflows very much do matter. The cash cost you need to show in the cash flows and D&A (or better you put them through EBITDA).
For the b/s, you should just grow your overall net balance sheet liability with a bit (I can’t be bothered to remember the RoU vs the liability and interaction with D&A but there are some rules for this which shouldn’t be too hard.
The point is don’t overthink your b/s item and just grow the net liability with a bit. And account correctly for the cashflows. As long as you do that you’re fine
Quidem ea provident in quas ut. Nisi optio voluptatem rerum incidunt asperiores dolorem. Eligendi velit non ipsum quas explicabo consequatur. Totam blanditiis commodi voluptas. Consectetur illo accusamus suscipit iure natus tenetur eligendi.
Optio quae nulla possimus veniam omnis. Deserunt eligendi repellat animi harum exercitationem. Totam quasi et consectetur facilis qui laborum. Reprehenderit modi quo aut commodi cupiditate quia dolorem. Voluptatum enim veritatis id.
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...