Skip to contents

FY23 to FY24 EBITDA bridge

Source: R/data.R
ebitda_bridge.Rd

Eight-row ordered breakdown decomposing the year-over-year EBITDA change for the fictional conglomerate behind bu_quarterly into volume, price, cost, mix, FX, and one-off effects. The first and last rows are absolute levels; the six intermediate rows are signed deltas that reconcile the endpoints. Designed for waterfall charts.

Usage

ebitda_bridge

Format

A data frame with 8 rows and 3 columns:

component

Ordered factor naming the bridge step.

value_brl

R$ MM (numeric). Absolute level for endpoint rows; signed delta for intermediate rows.

type

Factor with 3 levels: "total" for endpoint rows, "increase" or "decrease" for deltas.

Source

Synthetic data generated by the ggconsulting authors. It does not describe a real company or financial result. See data-raw/ebitda_bridge.R.

Examples

ebitda_bridge
#> # A tibble: 8 × 3
#>   component      value_brl type    
#>   <ord>              <dbl> <fct>   
#> 1 FY23 EBITDA          540 total   
#> 2 Volume                85 increase
#> 3 Price                120 increase
#> 4 Cost inflation       -95 decrease
#> 5 Mix                   25 increase
#> 6 FX                   -30 decrease
#> 7 One-offs             -45 decrease
#> 8 FY24 EBITDA          600 total