LBO Valuation: Fundamentals and Excel Modeling

Examine the 2013 take-private of Dell by Michael Dell and Silverlake, aiming to transform Dell from hardware to IT services amid PC market decline, with insider ownership and a premium.

Dell's management buyout led a bold turnaround, expanding from a pc maker to a multi-market provider in PCs, cloud, and enterprise solutions through the EMC merger and debt-financed growth.

Analyze Dell's lbo: why it was a suitable target, and how strong operating cash flows, excess cash, and low leverage enabled financing through sources and uses.

The Dell case study demonstrates how leverage and financial engineering enabled a successful take-private, amplifying returns as Michael Dell bet his capital on an undervalued tech company.

Build a paper LBO model to assess target feasibility using a one-page vertical Excel approach, focusing on cash generation, low leverage, and taxes.

Estimate the maximum debt capacity for an lbo using cash flow forecasts or EBITDA multiples, with term a at 3x and term b at 3.5x, plus covenants against dividends.

Apply a 30% premium to the market cap to determine the acquisition price, compute the enterprise value including net debt, and determine the $3.4b equity investment for the LBO.

Forecast a five-year cash flow from 2022 to 2027, applying 7% revenue growth, COGS 30% and OpEx 21%, boosting EBITDA margin to 49% with steady 320 million capex.

Compute interest expenses for term a and term b loans at fixed rates, then calculate earnings before taxes, taxes due, and 2023 net income, ahead of cash flow modeling.

Calculate cash for debt reimbursement from net income by adding back D and A. Adjust for 1% working capital; CapEx equals depreciation for $400m term A, affecting term B.

Copy 2023 formulas to forecast 2024–2027, complete the debt schedule and interest expenses, and project cash flow, taxes, and net income in an LBO valuation model.

Estimate 2027 debt and enterprise value using an 8.5x ebitda multiple, derive equity value, and compute an irr near 50%, illustrating cash on cash and exit equity for the lbo.

Explore how the IRR of an LBO changes with exit EBITDA multiple and revenue growth using Excel data tables to test scenarios.

Build a more sophisticated LBO model with scenarios and goodwill. Include acquisition price, revolver debt, minimum cash, working capital, and fixed asset roll forward.

Develop the LBO model drivers sheet for the target, defining hard input versus formula reference styles, input ABC data (share price, shares, premium), and set three scenarios.

Construct the profit and loss header for lbo valuation, link the scenario cell, indicate currency in thousands, separate historical and forecast data, and format for forecast (f) and actuals (a).

Analyze ABC's historical P&L by filling in rows, computing year-on-year revenue growth and COGS weights to reveal growth rates and margins for forecasting.

Compute equity value at transaction by applying acquisition premium to the current share price. Add net debt to obtain enterprise value and use ebitda to determine the ev/ebitda entry multiple.

Explore estimating transaction fees in an LBO: distinguish capitalized financing costs from expensed professional fees, apply origination and legal fee percentages, and model impacts on sources and uses of funds.

Explore sources and uses of funds for an LBO, balance financing from equity sponsors and lenders, account for cash, financing fees, and plan debt and amortization schedules in Excel.

Learn to bridge the target’s balance sheet at transaction by adjusting assets to fair value, allocating to goodwill, and financing with debt and fees, producing the post-transaction balance sheet.

Compute goodwill in an M&A deal by starting with the equity purchase price, subtracting the net book value, and adjusting for fair value changes to appear on the balance sheet.

Integrate assumptions into the drivers sheet to forecast revenue, cogs, and opex, and model dso, dio, and dpo with base and worst-case scenarios and capex as a percentage of revenue.

Build a fixed asset roll forward schedule for PPE and goodwill, detailing CapEx, depreciation, and impairment, with a dedicated amortization table for financing fees in an LBO context.

Explore building a three-scenario forecast with capex at 5% of revenue, fixed asset roll forward, and revenue growth paths while keeping COGS at 50% and OpEx at 26% of revenue.

Populate the P&L sheet up to EBITDA using a three-scenario model with the choose function. Calculate revenue, COGS, OpEx for forecast years, then derive gross profit, gross margin, and EBITDA.

Model the working capital sheet to calculate net trade working capital and the net cycle using DSO, DIO, and DPO, linking historical data and forecast balances.

Complete the balance sheet at transaction, detailing cash outflows, goodwill, and financing after an LBO. Link fees, capitalization, and refinancing to post-transaction balances.

Link closing and forecast balance sheet items using a choose function tied to revenue, model other current assets, and copy formulas with adjusted row references to complete assets and liabilities.

Link the 2023 P&L and balance sheet to the transaction sheet, project capex as revenue percentage via a choose function, and compute depreciation and amortization for fixed asset roll forward.

Develop a debt schedule by calculating LIBOR-based interest for four financing types—senior note, term loans A and B, and revolver—with spreads and a repayment and bullet-year projection.

Create a fixed asset amortization schedule by calculating capitalized financing costs for three loans using a straight-line method, and link the results to the debt schedule in Excel.

Construct a cash flow statement starting with net income, adding back D and A, and adjusting working capital to derive operating cash, with investing and financing to net cash flow.

Design a three-loan financing sheet for an LBO model by linking beginning loan values, calculating annual repayments and remaining balances, and computing interest expenses using the debt schedule.

Link net income in the P&L to EBIT, adjust for working capital and balance sheet changes to derive operating cash flow, then subtract capex to show investing cash flow.

Create and link an equity schedule for ABC, modeling equity issuance, repurchases, and dividends as 0%, using driver sheet inputs to forecast ending equity from net income and starting balance.

Finalize the financing section by linking debt issuance, debt repayment, and the equity schedule to the cash flow under the no new debt assumption, keeping the revolver empty.

Learn to model the revolver facility in LBO analysis, calculate drawdown and repayments in Excel, manage minimum cash balance, and integrate with forecast cash flows.

Complete the p&l by calculating annual interest for senior note, term loans a and b, and revolver; derive net income after taxes and link figures to equity and balance sheets.

Model the revolver facility’s cash impact by recording revolver drawn and repaid each year on the financing sheet, clarifying its role in cash flow alongside P&L interest.

Balance the balance sheet by adding capitalized financing costs from the transaction fees sheet, align cash flow with the forecast, and audit historical pad depreciation and data consistency.

Analyze exit valuation and IRR in an LBO model using entry and exit EV/EBITDA multiples. Compare IRRs across equity and lenders like senior notes and term loans A and B.