Bridgesheet

Financial modelling7 min read

Value creation bridge in an LBO: splitting the return

A value creation bridge splits the gain on an LBO between growth, margin, multiple and deleveraging. Here is the calculation line by line on a buyout that turns €36.0m into €112.0m, with the cross term, fees, dividends and the Excel chart.

Two-arch stone bridge reflected in a river, between bare trees
Photo: Antoine Lamielle · CC BY-SA · Wikimedia

What is a value creation bridge?

A value creation bridge, also called a value bridge, explains where an investor's gain comes from between entry and exit. It starts from the equity invested, adds the contribution of each source of value and ends at the equity recovered. On an LBO (leveraged buy-out, an acquisition financed largely with debt), four sources come up every time: revenue growth, margin, the valuation multiple and deleveraging.

A 25% IRR says nothing about its quality. If the return comes from better-held margins, the investment team can repeat it. If it comes from a buyer who paid a higher multiple, the team simply rode the market. An investment committee therefore reads the bridge before the IRR.

Do not confuse this bridge with the equity bridge, which moves at a single date from enterprise value to equity value. The value creation bridge compares two dates. The paper LBO gives a short three-line version; this article sets out the full version that a committee expects.

The example: an LBO that returns 3.1 times the stake

A fund buys Manufacture Aubert, a fictional company, and sells it five years later. Fees and dividends are ignored at first.

Item Entry Exit (5 years later)
Revenue €80.0m €110.0m
EBITDA margin 15.0% 16.0%
EBITDA €12.0m €17.6m
EBITDA multiple 7.0x 7.5x
Enterprise value €84.0m €132.0m
Net debt €48.0m €20.0m
Equity €36.0m €112.0m

The gain is €76.0m. The MOIC (multiple on invested capital, what the fund gets back divided by what it put in) comes to 3.11x and the IRR to 25.5%. The method for both is set out in the article on IRR and MOIC.

Calculating the value creation bridge line by line

Each line changes one assumption and holds the others at their entry level.

Source Calculation Gain
Revenue growth (110.0 − 80.0) × 15.0% × 7.0 €31.5m
Margin increase (16.0% − 15.0%) × 110.0 × 7.0 €7.7m
Multiple increase (7.5 − 7.0) × 12.0 €6.0m
EBITDA × multiple cross term (17.6 − 12.0) × (7.5 − 7.0) €2.8m
Deleveraging 48.0 − 20.0 €28.0m
Total €76.0m

The first two lines make up the rise in EBITDA: 5.6 × 7.0 = €39.2m. Here the margin is calculated on exit revenue, which attaches to it the small cross effect between revenue and margin (€2.1m). You can isolate that effect or leave it in growth, as long as you state the choice in the table note.

Deleveraging measures the fall in net debt, which is the cash the company generated during the holding period. That cash belongs to the shareholders at exit: every euro of debt repaid adds a euro to equity.

The cross term: the convention to state upfront

The €2.8m cross term exists because the fund sells at 7.5x an EBITDA that has grown. It comes neither from growth alone nor from the multiple alone. Three conventions are in use:

Convention EBITDA Multiple Cross term
Separate line €39.2m €6.0m €2.8m
Attached to the multiple €39.2m €8.8m 0
Shared equally €40.6m €7.4m 0

The total does not change, but the multiple's share of the gain moves from 7.9% to 11.6%. Pick one convention and apply it to every holding in the same fund, otherwise comparisons between deals are worthless. The separate line remains the most honest option, because it puts the number in front of the reader.

Expressing the bridge in MOIC and IRR points

A committee often wants the bridge in the unit of return. For MOIC, divide each line by the €36.0m stake. For IRR, spread the 25.5% in proportion to the gain.

Source Share of gain MOIC IRR points
Revenue growth 41.4% 0.88x 10.6
Margin increase 10.1% 0.21x 2.6
Multiple increase 7.9% 0.17x 2.0
Cross term 3.7% 0.08x 0.9
Deleveraging 36.8% 0.78x 9.4
Total 100% 2.11x 25.5

The MOIC total equals the gain (3.11x − 1.00x). Figures are rounded.

Pro-rata allocation is a convenient convention: IRR does not truly add up, because it depends on the timing of cash flows. To measure one source, rerun the calculation without it. At an exit multiple of 7.0x, equity is worth €103.2m, the MOIC is 2.87x and the IRR 23.4%: the higher multiple accounts for 2.1 points, cross term included.

Fees, dividends and add-on acquisitions

Three common events add a line to the bridge.

  • Transaction fees. With €3.0m of fees at entry, the fund invests €39.0m. The gain falls to €73.0m, the MOIC to 2.87x and the IRR to 23.5%. Add a negative line of €3.0m.
  • An interim dividend. If the company borrows €10.0m in year 3 to pay a dividend, exit debt rises to €30.0m. Ignoring the extra interest, the deleveraging line falls to €18.0m and a "distributions" line of €10.0m appears. The gain and the MOIC do not move, but the IRR rises to 26.8% because the fund is paid earlier.
  • An acquisition. Suppose €2.0m of the extra €5.6m of EBITDA comes from a company bought for €10.0m, or 5.0x. Organic growth is worth 3.6 × 7.0 = €25.2m. The target contributes €14.0m at 7.0x, of which €10.0m comes back in debt: the multiple arbitrage nets €4.0m. A dedicated line stops a purchase from being presented as growth.

Deleveraging and leverage

The deleveraging line does not measure leverage. It counts cash that the company would also produce without debt, and more of it, since it would pay no interest.

To isolate leverage, compare with the same buyout financed without debt. The fund invests €84.0m. It gets back €132.0m at exit, plus €28.0m of cash flow and roughly €8.9m of interest saved after tax (7% on average debt of €34.0m over five years, with tax at 25%). The total reaches about €168.9m, which is 2.01x and a 15.0% IRR if cash builds up until exit. Debt therefore adds about 10.5 points to the return without appearing on a line of the bridge.

This reading completes the bridge on one point: a return driven by leverage disappears if the company cannot keep to its repayment schedule.

Building the value creation bridge in Excel

Group the entry and exit data in an assumptions block, then point each line at that block.

Line Formula
Growth (exit revenue − entry revenue) × entry margin × entry multiple
Margin (exit margin − entry margin) × exit revenue × entry multiple
Multiple (exit multiple − entry multiple) × entry EBITDA
Cross term (exit EBITDA − entry EBITDA) × (exit multiple − entry multiple)
Debt entry net debt − exit net debt
Check exit equity − entry equity − sum of lines = 0

Keep the check cell visible: a gap almost always points to a missing line, such as fees or a dividend. Link the exit assumptions to the model so that the bridge follows your sensitivity tables.

For the chart, select entry equity, the bridge lines and exit equity, then choose Insert > Waterfall chart (Excel 2016 or later). Right-click the last bar and tick "Set as total", otherwise Excel stacks it on top of the previous ones.

Reading a value creation bridge

Three questions are enough when facing a bridge.

  1. How much depends on the market? Here the multiple and the cross term account for €8.8m of the €76.0m. The deal stands without them, as the 23.4% IRR shows. The larger this share, the more the return depends on the next buyer.
  2. Is the growth organic? Separate price, volume and acquisitions whenever the information exists.
  3. Is the margin credible? One point of margin is worth €7.7m here. Check which concrete actions fund it and whether the exit EBITDA will go through the same adjustments as the entry figure.

Test your entry and exit assumptions. Bridgesheet's LBO model calculates the IRR and MOIC from your debt structure and gives you the entry and exit figures for the bridge. It is an estimate, not a certified valuation or investment advice.