Variance bridges for the board pack, in Google Slides.
Draw the EBITDA bridge from a Sheets range, with its delta, and refresh it when the month closes.
Free plan. No card needed.
October board pack
EBITDA bridge
EBITDA rose EUR 4m to EUR 46m: price and volume added 15, mix and costs took back 11
Month end moves the model. The slides are retyped.
By hand
- Rebuild the EBITDA bridge from shapes after close.
- Retype EUR 46m in the slide text and miss one instance.
- Paste last month's chart over this month's.
- Hear about the stale figure from the board first.
With ChartKit
- Chart the bridge from a Sheets range, with signed steps and a delta.
- Refresh the chart when the range changes.
- Link figures in text to cells and run Refresh links. Part of Enterprise.
- Draft the commentary with your own Claude.
Change the sheet, refresh the pack.
Linked numbers is part of Enterprise. Change opex in the sheet, then run Refresh links: three figures in the text follow the cell.
Q3 data (Google Sheets)
2FY24 EBITDA
42
3Price
9
4Volume
6
5Mix
-3
6Input costs
-5
7Opex
-3
8FY25 EBITDA
46
Summary
EBITDA reached EUR 46m, up 9.5% on FY24.
Operating costs took EUR 3m of that back.
Questions about ChartKit
Close the month, then refresh the pack.
Free plan. No card needed.