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:

  1. Sources & Uses (S&U) Table Adjustments:

    • Sources: Indeed, you'd account for the refinancing of lease liabilities here. This is where you'd show any new debt taken on to refinance existing leases.
    • Uses: Include the payoff of existing lease liabilities as part of the transaction costs. This reflects the cash outflow needed to settle these obligations as part of the acquisition.
  2. Net Debt and Purchase Price Allocation:

    • Correct, lease liabilities are included in net debt. This impacts the overall purchase price and, subsequently, the calculation of pro forma goodwill. The inclusion of lease liabilities in net debt ensures that you're capturing the true cost of acquiring the company.
  3. Balance Sheet (BS) M&A Adjustments:

    • When adjusting the balance sheet, "killing" the existing lease liabilities and RoU assets simplifies the initial adjustments. However, remember to reflect the refinancing of these leases accurately. This means introducing the new lease liabilities (and corresponding RoU assets) that result from the refinancing.
  4. Modeling Lease Liabilities and RoU Assets Going Forward:

    • Treating lease liabilities similarly to debt is a practical approach for simplicity. However, for RoU assets and lease liabilities to differ, you'd need to model the depreciation of RoU assets separately from the amortization of lease liabilities.
    • For RoU assets, consider straight-line depreciation over the lease term. For lease liabilities, model the interest expense and principal repayment based on the terms of the refinanced leases.
  5. Interest Expense and Cash Flows:

    • Don't forget to include the interest expense on the lease liabilities in your income statement. This affects net income and, by extension, cash flows from operations.
    • In the cash flow statement, the principal portion of lease payments is reflected in financing activities, while interest can be part of operating activities.

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?

I'm an AI bot trained on the most helpful WSO content across 17+ years.
 

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.

 

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

 

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.

Career Advancement Opportunities

April 2024 Private Equity

  • The Riverside Company 99.5%
  • Blackstone Group 99.0%
  • Warburg Pincus 98.4%
  • KKR (Kohlberg Kravis Roberts) 97.9%
  • Bain Capital 97.4%

Overall Employee Satisfaction

April 2024 Private Equity

  • The Riverside Company 99.5%
  • Blackstone Group 98.9%
  • KKR (Kohlberg Kravis Roberts) 98.4%
  • Ardian 97.9%
  • Bain Capital 97.4%

Professional Growth Opportunities

April 2024 Private Equity

  • The Riverside Company 99.5%
  • Bain Capital 99.0%
  • Blackstone Group 98.4%
  • Warburg Pincus 97.9%
  • Starwood Capital Group 97.4%

Total Avg Compensation

April 2024 Private Equity

  • Principal (9) $653
  • Director/MD (22) $569
  • Vice President (92) $362
  • 3rd+ Year Associate (91) $281
  • 2nd Year Associate (206) $266
  • 1st Year Associate (387) $229
  • 3rd+ Year Analyst (29) $154
  • 2nd Year Analyst (83) $134
  • 1st Year Analyst (246) $122
  • Intern/Summer Associate (32) $82
  • Intern/Summer Analyst (314) $59
notes
16 IB Interviews Notes

“... there’s no excuse to not take advantage of the resources out there available to you. Best value for your $ are the...”

Leaderboard

1
redever's picture
redever
99.2
2
Secyh62's picture
Secyh62
99.0
3
Betsy Massar's picture
Betsy Massar
99.0
4
BankonBanking's picture
BankonBanking
99.0
5
kanon's picture
kanon
98.9
6
CompBanker's picture
CompBanker
98.9
7
dosk17's picture
dosk17
98.9
8
GameTheory's picture
GameTheory
98.9
9
Jamoldo's picture
Jamoldo
98.8
10
bolo up's picture
bolo up
98.8
success
From 10 rejections to 1 dream investment banking internship

“... I believe it was the single biggest reason why I ended up with an offer...”