How to build an EBITDA bridge in Excel for a QoE analysis: step-by-step methodology, common pitfalls and how to present it in an FDD report.
The EBITDA bridge is the central analytical output of any Quality of Earnings analysis. Knowing how to build one — quickly, accurately and in a format that communicates clearly to a client — is a foundational skill for any Transaction Services analyst.
An EBITDA bridge is a schedule that reconciles reported EBITDA to adjusted (normalised) EBITDA, listing every adjustment with its description and financial impact. It is the backbone of the QoE section in an FDD report.
Start by constructing a clean historical P&L in Excel, covering at least the last two full financial years plus the last twelve months (LTM):
Ensure your P&L reconciles to the audited statutory accounts. Any difference must be explained.
Review the data room systematically for adjustment candidates:
Build a preliminary list of potential adjustments, each with a description and a reference to the supporting document.
For each adjustment item:
Categorise each item as:
In Excel, build a vertical bridge from reported EBITDA to adjusted EBITDA:
Reported EBITDA €Xm
+ Item A (one-off legal) +€0.2m
+ Item B (restructuring) +€0.5m
- Item C (grant income) -€0.3m
+ Item D (run-rate hire) +€0.1m
= Adjusted EBITDA €(X+0.5)m
Include a column for each year and an LTM column. Colour-code additions and deductions for readability.
Before presenting:
Building a rigorous, well-evidenced EBITDA bridge is the core analytical task of the FDD analyst. It is tested in TS interviews — candidates who can narrate the bridge construction process confidently demonstrate genuine readiness for the role.
The Transaction Services Interview Programme (€119.99, one-time) walks you through building a complete EBITDA bridge from a real FDD dataset, with an Excel template included. Start today.
Hundreds of candidates prepared their interviews with this programme. Those who landed the role have one thing in common: they worked the cases before walking into the room.