Waterfall-Cumulative Timeline

1  Slide Type Name
Waterfall‑Cumulative Timeline

2  One‑Sentence Purpose Statement
Shows “how value (cost, benefit, or volume) adds up over time and what drives each step‑change.”

3  Visual Description (Designer Instructions)

• Use a 16 × 9 slide; allocate the lower two‑thirds to a classic waterfall chart laid out chronologically from left to right.
• X‑axis = time (months, quarters, or phases). Start with an opening cumulative value column on the far left, then draw sequential floating bars for each time bucket; each bar’s height equals the net change in that period.
• Stack the bars so their tops create a “cumulative” step‑line—visually emphasise the running total with a thin outline or a contrasting step‑line overlay.
• Above or inside each bar, place a concise label stating the driver (e.g., “Marketing Spend”, “Efficiency Gains”) and the numeric delta (+/‑).
• Colour‑code positive vs. negative bars (e.g., muted green for gains, muted red for costs); use a neutral fill for the opening and closing total columns.
• Draw a horizontal reference grid at key cumulative thresholds (25 %, 50 %, 75 %) and annotate the final total on the far right column.
• Optionally overlay milestone markers (diamonds) on the timeline axis to show decision points or approvals that precede step‑changes.
• Keep legend and explanatory notes in the top 15 % of the slide to avoid encroaching on the chart area; ensure all text stays inside the safe zone.

4  Business Questions This Slide Answers

• How do individual time‑period changes accumulate to the overall outcome?
• Which periods contribute the most (or least) to cost/benefit?
• Are we trending toward the target cumulative value?
• Where do negative swings or cost overruns occur?
• What external events or decisions coincide with major shifts?

5  When to Use (Typical Situations)

• Financial reviews showing quarter‑by‑quarter EBIT or cash movement.
• Benefit‑realisation timelines in transformation programs.
• Cumulative headcount or capacity build‑ups over implementation phases.
• Cost‑to‑complete forecasts for capital projects.
• Subscription businesses illustrating ARR build across cohorts.

6  Core Data Fields Required

• Time buckets (dates or phase labels).
• Net value change for each bucket (+/‑).
• Opening cumulative value.
• Closing cumulative value (auto‑derived).
• Optional milestone dates for overlay.

7  Optional / Advanced Data Fields

• Driver category (OpEx, CapEx, Savings) for colour grouping.
• Owner/team responsible for each period’s change.
• RAG status or confidence band around projected values.
• Target line (e.g., budget cap, benefit goal).
• Commentary call‑outs for exceptional periods (one‑off events, FX impact).