Earnings analysis
EBITDA Bridge
Walk from one period’s EBITDA to the next through the lines that moved it. Depreciation, interest and anything else below the line is marked, excluded, and still shown — because a pasted profit and loss arrives carrying them.
Input data
One row per profit and loss line. Fill Group to bar the chart by division or cost type.
Enter a published figure to check the lines against it. Any difference is reported and never used to adjust a driver.
| Line item | Nature | Group | Prior year | Current year | |
|---|---|---|---|---|---|
Tip: paste a rectangular range from Excel or Sheets.
EBITDA movement
+$1.800
EBITDA rose $1.800 between the two periods. Favourable movements of $9.500 were partly offset by $7.700 of adverse movements. Revenue is the largest single driver at $8.000 favourable. The EBITDA margin moved +1.1 percentage points.
- Prior year
- $8.000
- Current year
- $9.800
- Prior margin
- 8.0%
- Current margin
- 9.1%
EBITDA walk
Prior year to Current year, line by line.
Prior year
$8.000
Revenue
+$8.000
COGS
-$6.000
Payroll
-$1.500
Marketing
+$1.500
Other operating costs
-$0.200
Current year
$9.800
Drivers
Profit impact is the direction that counts as better for that nature. Raw movement is simply current less prior, and both are shown.
| Line item | Group | Raw movement | Profit impact |
|---|---|---|---|
| Revenue | — | +$8.000 | +$8.000 |
| COGS | — | +$6.000 | -$6.000 |
| Payroll | — | +$1.500 | -$1.500 |
| Marketing | — | -$1.500 | +$1.500 |
| Other operating costs | — | +$0.200 | -$0.200 |
Below EBITDA, excluded
- Depreciation: $5.000 to $5.400, a movement of +$0.400
These lines are in neither EBITDA figure, in no bar and in no margin. They are listed because a pasted profit and loss carries them and silently dropping them would be worse than showing them.
Reuse the analysis
Copy the summary, or export the lines and the chart.
Transparent by design
How this calculation works
EBITDA here is computed from the lines you entered and from nothing else. If it differs from the figure you publish, the difference is shown rather than reconciled away.
EBITDA
Income lines less expense lines, in each period. Anything marked Below EBITDA is excluded from both.
Profit impact
Current less prior for income; prior less current for expenses. Positive always means EBITDA is better off, so a cost that fell reads favourable.
Raw movement
Current less prior, for every line, never re-signed. A cost that rose shows a positive raw movement and a negative profit impact, and both are on the page.
Below EBITDA
Depreciation, amortisation, interest and tax. Listed with their movements so nothing is silently dropped, and excluded from every EBITDA figure, every bar and every margin.
Margin
EBITDA divided by income, per period. Absent where there are no income lines to divide by, because a margin against nothing is not a number.
Margin movement
The difference between the two margins, in percentage points. Never one margin divided by the other, which would be a different and misleading figure.
Grouping
Filling the Group column bars the chart by division or cost type. The group bars sum to the same movement, and the driver table still lists every line.
Tie-out
A reported EBITDA is compared against the lines. Any unexplained difference is stated, appears in no bar, and changes no driver.