What is an LBO model?
An LBO model is built in excel to evaluate a leveraged buyout (LBO) transaction, which is the acquisition of a company that is funded using a significant amount of debt. The assets of the company being acquired, and those of the acquiring company, are used as collateral for the loans. The buyer typically wishes to invest the smallest possible amount of equity and fund the remainder of the purchase price with debt or other non-equity sources. The aim of the LBO model is to enable investors to properly assess the transaction and earn the highest possible risk-adjusted internal rate of return (IRR). Learn more in CFI’s LBO Modeling Course!
In an LBO model, the purpose of the investing company or buyer is to make high returns on their equity investments and using debt to increase the potential returns. The acquiring firm determines if an investment is worth pursuing by calculating the expected internal rate of return (IRR), where the minimum is 30% and above. The IRR rate may sometimes be as low as 20% for larger deals or when the economy is unfavorable. After the acquisition, the debt/equity ratio is usually greater than 1-2x since the debt constitutes 50-90% of the purchase price. The company’s cash flow is used to pay the outstanding debt
Structure of an LBO Model
In a leveraged buyout, the new investors (private equity or LBO Firm) form a new entity that they use to acquire the target company. After a buyout, the target becomes a subsidiary of the new company, or they merge to form one company.
Capital Structure in an LBO Model
Capital structure in a Leveraged Buyout (LBO) refers to the components of financing that are used in purchasing a target company. Although each LBO is structured differently, the capital structure is almost similar in most newly-purchased companies, with the largest percentage of LBO financing being debt. The typical capital structure is financing with the cheapest and less risky first, followed by other available options.
An LBO capital structure may include the following:
Bank debt is also referred to as senior debt, and it is the cheapest form of financing instrument used to acquire a target company in a leveraged buyout, accounting for 50-80% of LBO capital structure. It has a lower interest rate than other financing instruments, making it the most preferred by investors. However, bank debts come with covenants and limitations that restrict a company from paying dividends to shareholders, raising additional bank debts and acquiring other companies while the debt is active. Bank debts have a payback time of 5 to 10 years. If the company liquidates before the debt is fully paid, bank debts get paid off first.
High Yield Debt/Subordinated Debt
High yield debt is typically an unsecured debt and carries a high-interest rate that compensates the investors for risking their money. They have less restrictive limitations or covenants than there are in bank debts. In the event of a liquidation, high yield debt is paid before equity holders but after the bank debt. The debt can be raised in the public debt market or private institutional market. Its payback period is 8 to 10 years with a bullet repayment and early repayment options.
Mezzanine debt comprises small components of LBO capital structure and is junior to other financing options. It is often financed by hedge funds and private equity investors and has a higher interest rate than bank debt and high yield debt. Mezzanine debt takes the form of a high yield debt with an option to purchase a stock at a specific price in the future as a way of boosting investor returns commensurate with the risk involved. They allow early repayment options and bullet payments just like high yield debt. During a liquidation, mezzanine debt is paid after other debts have been settled but before equity shareholders are paid.
Equity comprises 20-30% of the LBO financing depending on the deal. It represents the private equity fund’s capital and attracts a high-interest rate due to the risk involved. In the case of a liquidation, the equity shareholders are paid last, after the other debts have been settled. If the company defaults payments, the equity shareholders may not receive any returns on their investments.
One of the keys to building an LBO model is making sure the credit metrics and debt covenants work for the deal. In the screenshot below you will see how an Analyst would model the credit metrics for this leveraged buyout.
Key credit metrics in an LBO model include:
- Interest Coverage Ratio (EBIT/Interest)
- Debt Service Coverage Ratio (EBITDA – Capex) / (Interest + Principle)
- Fixed Charge Coverage Ratio (EBITDA – Capex – Taxes) / (Interest + Principle)
Image Source: CFI’s LBO Model Course.
The private equity firm (aka the financial sponsor) in the transaction will build the LBO model to determine how much debt they can strap on the business without blowing through the debt covenants and credit metrics they know the lenders will impose.
The ultimate goal of the model is to determine what the internal rate of return is for the Sponsor (the private equity firm buying the business). Due to the high degree of leverage used in the transaction, the IRR to equity investors will be much higher than the return to debt investors.
The model will calculate both the levered and unlevered rates of return to assess how big the advantage of leverage is to the private equity firm.
The Sponsor IRR will usually be tested for a range of values in a process called sensitivity analysis, which calculates different outcomes as assumptions and inputs change. The most common assumptions to change are the EV/EBITDA acquisition multiple, the EV/EBITDA exit multiple, and the amount of debt used.
Below is an example of sensitivity analysis demonstrating the various IRRs and cash-on-cash returns based on changes in assumptions.
The above screenshot is from CFI’s LBO Model Training Course!
Learn more about financial modeling
Thank you for reading this guide to building LBO models. CFI is a global provider of the Financial Modeling & Valuation Analyst (FMVA)™ certification program and several other courses for finance professionals. To help you advance your career, check out the additional resources below: