£0.00 0

Basket

No products in the basket.

Blog/Financial Modelling

LBO Exit Multiple Sensitivity: Interview Walkthrough

LBO exit multiple sensitivity measures how equity value, MOIC (multiple on invested capital) and IRR change as the assumed exit EV/EBITDA multiple moves. The rule to remember: each 1.0x turn of exit multiple changes exit equity value by one times exit-year EBITDA.

In an interview, that rule lets you answer the question in four sentences and then prove it with numbers. In a model, it tells you how much of the return depends on an exit price you do not control.

This guide covers the interview answer, a full worked example in US dollars, the returns attribution, the common mistakes and how to build the Excel data table.

What you need to know first

An LBO return has three engines: EBITDA growth, debt paydown and the change between entry and exit multiple. The exit multiple sensitivity isolates the third engine while holding the other two fixed.

You should be comfortable with these terms before you start:

  • Entry multiple: purchase enterprise value divided by EBITDA at closing.
  • Exit multiple: sale enterprise value divided by EBITDA in the exit year.
  • Net debt at exit: remaining debt minus cash on the exit date. It is deducted from exit enterprise value to get equity.
  • MOIC: exit equity divided by the sponsor’s initial equity cheque.
  • IRR: the annualised return. With no interim cash flows, IRR = MOIC^(1/years) – 1.

If the mechanics of a quick buyout are rusty, work through our paper LBO guide first. The sensitivity is a small extension of the same arithmetic.

Current market context for exit assumptions

Entry multiples are high, so the exit assumption carries more weight than it did a decade ago. McKinsey’s Global Private Markets Report 2026 puts the median buyout EBITDA multiple at 11.8x in 2025, up from 11.3x in 2024 and well above the 9.1x average for 2010 to 2022.

PitchBook’s 2025 Annual US PE Breakdown puts the median North American and European buyout at 12.3x EV/EBITDA in 2025, just off the 12.9x peak in 2024. Average leverage on US LBOs funded with broadly syndicated loans (loans sold to a wide group of institutional lenders) was 5.0x debt/EBITDA in 2025, down from a 5.9x peak in 2022.

Bain’s Global Private Equity Report 2026 says steadily rising multiples powered over 50% of buyout returns in the low-rate decade. Its illustrative deal needed about 5% annual EBITDA growth in 2015 to reach a 2.5x MOIC over five years, against 10% to 12% today. Sponsors buying near peak multiples cannot count on another turn of expansion, so you should expect to defend your exit assumption.

How do you answer the LBO exit multiple sensitivity question?

When an interviewer says “walk me through how returns change with the exit multiple”, structure the answer in four parts:

  1. State the mechanic: holding EBITDA and net debt constant, each 1.0x turn changes exit enterprise value and exit equity value by one times exit EBITDA.
  2. Translate to MOIC: MOIC moves by exit EBITDA divided by the initial equity cheque for each turn.
  3. Translate to IRR: give the IRR change and name the hold period, because the same MOIC gives a lower IRR over a longer hold.
  4. Add the leverage point: more debt means a smaller equity cheque, so each turn moves MOIC and IRR further in both directions.

Step 1: Set the entry assumptions

The figures below are an illustrative example. Fees and interim dividends are ignored to keep the arithmetic clean.

  • Entry EBITDA (example): $100m
  • Entry multiple: 10.0x
  • Debt: 5.0x EBITDA
  • EBITDA growth: 5% a year
  • Debt paydown: $40m a year from free cash flow
  • Hold period: five years

Purchase price = 10.0x x $100m = $1,000m.

Debt = 5.0x x $100m = $500m.

Equity = $1,000m – $500m = $500m.

Step 2: Project exit EBITDA and net debt

Exit EBITDA = $100m x 1.05^5 = $127.6m.

Debt repaid = $40m x 5 = $200m.

Net debt at exit = $500m – $200m = $300m.

Step 3: Calculate equity value, MOIC and IRR at each exit multiple

Take the 10.0x case first, one line at a time:

Exit enterprise value = 10.0x x $127.6m = $1,276.3m.

Exit equity = $1,276.3m – $300m = $976.3m.

MOIC = $976.3m / $500m = 1.95x.

IRR = 1.95^(1/5) – 1 = 14.3%.

The table repeats this for each exit multiple.

Exit multiple Exit EV ($m) Exit equity ($m) MOIC IRR
8.0x 1,021.0 721.0 1.44x 7.6%
9.0x 1,148.7 848.7 1.70x 11.2%
10.0x 1,276.3 976.3 1.95x 14.3%
11.0x 1,403.9 1,103.9 2.21x 17.2%
12.0x 1,531.5 1,231.5 2.46x 19.8%

Each turn adds or removes $127.6m of equity, exactly one times exit EBITDA. That is 0.26x of MOIC per turn ($127.6m / $500m). IRR moves by roughly 2.6 to 3.6 percentage points per turn over a five-year hold, with bigger moves at lower multiples.

Step 4: Show why leverage amplifies the effect

Run the same deal with 3.0x debt. Debt is $300m, equity is $700m and net debt at exit falls to $100m after the same $200m paydown.

MOIC at 8.0x = ($1,021.0m – $100m) / $700m = 1.32x.

MOIC at 10.0x = ($1,276.3m – $100m) / $700m = 1.68x.

MOIC at 12.0x = ($1,531.5m – $100m) / $700m = 2.05x.

Each turn still moves equity by $127.6m, but that is now 0.18x of MOIC per turn against 0.26x at 5.0x leverage. The dollar effect is identical. The percentage effect grows as the equity cheque shrinks.

Step 5: Split the return into its drivers

A returns attribution shows how much of the gain comes from each engine. Using the 12.0x exit, total equity gain is $1,231.5m – $500m = $731.5m.

EBITDA growth = ($127.63m – $100m) x 10.0x = $276.28m.

Debt paydown = $500m – $300m = $200.00m.

Multiple expansion = (12.0x – 10.0x) x $127.63m = $255.26m.

Total = $276.28m + $200.00m + $255.26m = $731.54m, which rounds to the $731.5m gain.

At a 10.0x exit, the multiple expansion line is zero and the deal returns 1.95x from growth and paydown alone. At an 8.0x exit, multiple compression wipes out $255.3m, more than the whole debt paydown. McKinsey’s 2026 report says leverage and multiple expansion drove 59% of buyout returns on 2010 to 2022 deals. Your attribution should show how much of the return depends on multiple expansion.

Common interview mistakes

Avoid these mistakes:

  • Assuming exit equals entry without saying so: a flat multiple is a sensible base case, but state it as an assumption and justify it against sector comparables.
  • Ignoring net debt at exit: exit equity is exit enterprise value minus net debt. Multiplying EBITDA by the multiple and calling it equity overstates MOIC.
  • Quoting IRR without the hold period: 2.0x is roughly 26% over three years and roughly 15% over five. Always say which.
  • Forgetting the dollar rule: candidates who know that one turn equals one times exit EBITDA can answer without a calculator.

Our guide to MOIC vs IRR covers why the two metrics can rank deals differently.

How do you build the sensitivity table in Excel?

Most models use Excel’s two-variable data table (Data, What-If Analysis, Data Table). Set it up as follows:

  1. Anchor cell: put a link to the output (IRR or MOIC) in the top-left corner of the grid.
  2. Row values: enter one variable across the top row, for example exit multiples of 8.0x to 12.0x.
  3. Column values: enter the second variable down the left column, for example entry multiples, exit years or EBITDA growth rates.
  4. Input cells: select the grid, open Data Table and point the row and column input cells at the hard-coded assumption cells the model uses. Keep those input cells on the same sheet as the table.

The three most common pairings are exit multiple against entry multiple, against exit year and against EBITDA growth. Exit year is the most revealing for IRR. In the example, a 10.0x exit gives 15.9% IRR in year three, 15.0% in year four and 14.3% in year five, even though MOIC rises from 1.56x to 1.95x.

Harder variations and the calculation trap

Data tables recalculate every time the worksheet recalculates, so large models slow down. Many analysts switch to calculation that skips data tables and then forget to press F9, which leaves a stale grid. Check the calculation setting before you send anything.

Interest calculated on average debt creates a circular reference. Running data tables on top of iterative calculation can produce unstable or frozen results. Build a circularity switch that sets interest to opening balances while you run the tables, or use a short macro that loops through the inputs.

In a timed case, link every sensitivity input to a single assumptions block. This is a standard check in a private equity model test, and it fits the structure in our LBO modelling framework for interviews. If you want structured practice, Wall Street Oasis courses cover LBO modelling and sensitivity tables step by step.

FAQ

What exit multiple should you assume by default?

Use the entry multiple as the base case unless you have a specific reason to change it, and say so out loud. With entry multiples near record levels, underwrite a flat or slightly lower exit unless you can justify expansion. Show the downside in the sensitivity table so the committee can see returns without expansion.

Why does more leverage make returns more sensitive to the exit multiple?

Each turn changes equity by the same dollar amount, one times exit EBITDA, whatever the capital structure. A smaller equity cheque turns that dollar change into a bigger MOIC change. In the example, one turn moves MOIC by 0.26x at 5.0x debt and 0.18x at 3.0x debt.

Why does my data table show the same number in every cell?

Calculation is probably set to skip data tables, or the input cells point at formulas instead of hard-coded assumptions. Press F9, check the calculation setting under Formulas and confirm the row and column input cells are the cells the model actually reads.

Is multiple expansion a genuine source of value?

It is real cash at exit, but it is the least controllable driver. It depends on market conditions, the buyer universe and how the business has changed. Investment committees put more weight on EBITDA growth and debt paydown, which the sponsor can influence directly.

Conclusion

LBO exit multiple sensitivity comes down to one rule: each 1.0x turn moves exit equity by one times exit EBITDA. Convert that into MOIC by dividing by the equity cheque, quote IRR with the hold period and flag the leverage effect. Then build the table so the committee can see what the deal returns with no expansion at all.

P.S. To run these sensitivities on a full buyout case, try the LBO Financial Model, and our Premium Resources include additional tools you might be interested in. For weekly finance updates and the latest financial reports, join the Private Equity Bros newsletter.

Sources

Join 80,000+ readers

Get smarter in the next 5 minutes.

One email a week: markets and finance news, the latest M&A deals and reports, investor biographies and deep dives.

Free forever. Unsubscribe anytime.

Keep reading

Related articles

Private Equity BroFINANCE CAREERS
© 2026 Private Equity Bro. All rights reserved.