Underridge Start free

Valuation

How an LBO Model Works: Structure, Returns and Risks

A leveraged buyout model projects the returns to a financial sponsor that acquires a company using a large share of borrowed money. It links sources and uses, an operating forecast, a debt schedule and an exit assumption to calculate equity IRR and multiple of invested capital. Returns come from EBITDA growth, debt paydown and multiple change.

What is a leveraged buyout model?

A leveraged buyout (LBO) model answers a narrow question: given a purchase price and a financing structure, what return will the equity investor earn over a holding period? Unlike a DCF, which estimates intrinsic value, an LBO model starts from a price and solves for return, or works backward from a target return to the maximum price a sponsor can pay. That makes it both a valuation tool and a test of debt capacity. For a lender, the same model is equally useful in reverse: it shows how much debt the cash flows can carry and how quickly that debt can be reduced under the sponsor's plan and under more conservative assumptions.

The model has five linked components: a sources and uses table that shows how the purchase is funded, an operating forecast, a debt schedule that tracks each tranche, a cash flow waterfall that determines how much debt is repaid each year, and an exit calculation. Because the components feed one another through interest expense and cash sweeps, LBO models often contain circular references that must be handled deliberately with average balances or iterative calculation. Good models separate inputs, calculations and outputs on distinct sheets, label every assumption with its source, and include a switch that toggles between management, sponsor and lender cases so that reviewers can compare scenarios without rebuilding the logic.

How do sources and uses work?

Uses list everything the transaction must pay for: the purchase of equity, refinancing of the target's existing debt, transaction fees, financing fees and any cash left on the balance sheet for operations. Sources list how that total is funded: senior term loans, revolver draws, subordinated or mezzanine debt, seller financing, rollover equity from management and new sponsor equity. The two sides must balance exactly, and the sponsor equity is usually the plug. Fees deserve attention because they are paid on day one and must be recovered from future value creation before equity earns a return. Financing fees are often amortized for accounting purposes but are a cash outflow at closing, so the sources and uses table should reflect the cash amount.

The mix of sources determines both risk and return. More debt reduces the equity check and magnifies returns if the business performs, but it raises fixed charges and narrows the margin for error. Lenders will size debt by leverage multiples, fixed charge coverage and free cash flow paydown capacity, so the sources table should be tested against the lender's constraints rather than chosen to maximize the modeled return. Rollover equity from management is also worth examining. It aligns incentives, but it reduces the cash proceeds sellers receive and may come with governance rights or preferred terms that affect how value is shared at exit. Seller notes can bridge valuation gaps but are usually subordinated and may carry their own covenant implications.

Sponsor equity = total uses - (senior debt + subordinated debt + seller note + rollover equity)

How is the debt schedule built?

Each tranche carries its own interest rate, amortization schedule, maturity and prepayment terms. Floating-rate loans require an assumed base rate path, and the model should show the effect of higher rates rather than assume the current curve holds. Mandatory amortization is paid first; excess cash flow is then applied according to the credit agreement, often a percentage sweep to the senior lender, before any optional prepayment of other tranches. The schedule should also respect the legal terms of each instrument, including prepayment premiums, call protection on subordinated notes, and any restrictions on paying junior debt while senior debt is outstanding.

The cash available for debt service equals EBITDA less cash taxes, capital expenditures, changes in working capital and cash interest. Many models overstate paydown by forgetting minimum cash balances, payment-in-kind interest on subordinated tranches, or the tax shield that disappears as interest falls. A careful schedule also tracks covenant metrics each period, because a structure that repays debt on paper may still breach a leverage or coverage covenant in a soft year. Lenders often build their own version of the schedule rather than relying on the sponsor's, precisely because small mechanical choices can produce large differences in projected repayment over a five-year horizon.

How are IRR and MOIC calculated?

At exit the model assumes the business is sold, usually at a multiple of the final year's EBITDA. Subtracting the remaining net debt from exit enterprise value gives exit equity value. The multiple of invested capital (MOIC) divides that equity value plus any interim distributions by the equity invested. The internal rate of return (IRR) is the discount rate that sets the net present value of all equity cash flows to zero. When there are multiple cash flows, such as an initial investment, a follow-on equity injection and a partial dividend, IRR must be calculated with the dated cash flows rather than the simple shortcut, and the timing of each flow should match the transaction calendar.

MOIC and IRR answer different questions. MOIC shows how much money is made; IRR shows how fast. A dividend recapitalization in year two can raise IRR significantly while barely changing MOIC. Committees typically look at both, along with downside cases. Base case exit multiples are conventionally set at or below the entry multiple so that returns do not depend on the market paying more for the same business later. A useful additional output is the return in a downside scenario and the exit multiple at which the equity is fully lost. Those figures show the committee how much room there is for error in the assumptions that drive the base case.

MOIC = (exit equity value + interim distributions) / equity invested; for a single entry and exit, IRR = MOIC^(1 / years) - 1

Where do LBO returns come from?

Value creation can be attributed to three sources. EBITDA growth, from revenue gains or margin improvement, increases enterprise value at the exit multiple. Debt paydown transfers value from lenders to equity as free cash flow retires borrowings. Multiple expansion, selling at a higher multiple than the entry price, adds value but depends on market conditions the sponsor does not control. Fees and expenses at entry are a drag that must be overcome. The attribution should reconcile exactly to the change in equity value, so that no value creation is left unexplained. A residual or cross term often appears when both EBITDA and the multiple change, and it should be shown separately rather than buried in one bucket.

Underwriters should be skeptical of returns that rely mainly on multiple expansion or on aggressive margin improvement in the early years. A structure whose base case returns come predominantly from cash flow generation and debt reduction is more robust. Attribution analysis makes this visible and is a standard element of an investment committee memo. Attribution also helps compare deals across a portfolio. Two investments with the same projected IRR can carry very different risk if one depends on cash generation and the other on a higher exit multiple. The first is largely within management's control; the second depends heavily on market conditions at an unknown future date. Committees tend to reward the former.

What does a lender look for in an LBO model?

A lender's question is different from the sponsor's: will the borrower service and repay the debt under realistic and stressed conditions? Lenders focus on opening leverage relative to normalized EBITDA, fixed charge coverage, the percentage of debt repaid over the loan's life, and the equity cushion beneath the loan. They also test a downside case in which revenue declines, margins compress and rates rise together. They will also look at liquidity: revolver availability, minimum cash requirements, and how many months of fixed charges the business can absorb if EBITDA falls sharply. A structure with thin liquidity can fail even when long-run value supports the debt.

The equity contribution matters as a signal and as protection. A large sponsor check means the sponsor loses first and has an incentive to support the business. Lenders compare the loan amount with the enterprise value implied by conservative multiples to estimate loan to value, and they examine whether add-backs used to size the debt are supported by quality of earnings work. Lenders will also examine the sponsor's track record with similar businesses, its ability to inject further equity, and the structure of management incentives, since all three influence how the borrower behaves if performance falls short of plan. A model cannot capture these qualitative factors directly, but they inform how much weight to give the downside case.

Five-year LBO with returns attribution

  1. Entry: EBITDA = $20.0 million, purchase multiple 8.0x, enterprise value = $160.0 million. Transaction fees = $4.0 million, so total uses = $164.0 million.
  2. Sources: senior debt at 5.0x EBITDA = $100.0 million; sponsor equity = 164.0 - 100.0 = $64.0 million.
  3. Over five years, EBITDA grows to $26.0 million and cumulative free cash flow repays $40.0 million of debt, leaving $60.0 million outstanding.
  4. Exit at 8.0x: enterprise value = 8.0 x 26.0 = $208.0 million. Exit equity = 208.0 - 60.0 = $148.0 million.
  5. MOIC = 148.0 / 64.0 = 2.31x. IRR = 2.3125^(1/5) - 1 = 18.3%.
  6. Attribution of the $84.0 million equity gain: EBITDA growth 6.0 x 8.0 = $48.0 million, debt paydown $40.0 million, multiple change $0, less entry fees $4.0 million. Check: 48.0 + 40.0 - 4.0 = 84.0.

How underwriters apply this

Frequently asked questions

What IRR do private equity sponsors target?

Targets vary by strategy, fund and market environment, and there is no single standard. Sponsors generally set a required return that exceeds their cost of capital with a margin for risk, and they test whether a deal clears that hurdle in base and downside cases. Lenders should focus less on the target and more on whether the plan supporting it is realistic.

Why do LBO models have circular references?

Interest expense depends on the debt balance, the debt balance depends on how much cash is available for repayment, and available cash depends on interest expense. That loop creates a circularity. Modelers handle it with iterative calculation, by computing interest on the opening balance, or by using an average balance with a circuit breaker switch to prevent errors from propagating.

How is an LBO different from a DCF?

A DCF estimates intrinsic value by discounting cash flows at a cost of capital. An LBO model takes a price and financing structure as given and solves for the equity return, or solves for the price that achieves a target return. The LBO explicitly models the debt and its repayment, which makes it the natural tool for testing leverage and debt capacity.

Keep reading

Sizing Debt by DSCR, Debt Yield, LTV and LeverageThe Capital Stack: From Senior Debt to Common EquityFCFF vs FCFE: Unlevered and Levered Free Cash FlowDesigning Financial Covenants: Maintenance vs IncurrenceInternal Rate of Return (IRR)Multiple on Invested Capital (MOIC)Senior DebtLoan Covenants

Underwrite your next deal in minutes

Drop a deck or data room. Underridge returns a verdict, investment memo, term sheet and a live model, with every headline figure traced to a page, a formula or a labeled assumption. Ten underwrites free.

Try Underridge free

Educational content written by practitioners. Not investment, accounting, legal or tax advice.