Blog/Financial Modelling
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.
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:
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.
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.
When an interviewer says “walk me through how returns change with the exit multiple”, structure the answer in four parts:
The figures below are an illustrative example. Fees and interim dividends are ignored to keep the arithmetic clean.
Purchase price = 10.0x x $100m = $1,000m.
Debt = 5.0x x $100m = $500m.
Equity = $1,000m – $500m = $500m.
Exit EBITDA = $100m x 1.05^5 = $127.6m.
Debt repaid = $40m x 5 = $200m.
Net debt at exit = $500m – $200m = $300m.
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.
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.
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.
Avoid these mistakes:
Our guide to MOIC vs IRR covers why the two metrics can rank deals differently.
Most models use Excel’s two-variable data table (Data, What-If Analysis, Data Table). Set it up as follows:
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.
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.
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.
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.
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.
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.
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.
Join 80,000+ readers
One email a week: markets and finance news, the latest M&A deals and reports, investor biographies and deep dives.
Free forever. Unsubscribe anytime.