Independent demonstration · Fictional data · Not a client engagement

Two-period comparison / each prior value = 100

Revenue and profit are up; cash is down.

Revenue and profit are up; cash is down.Metric, Prior, Current, Current index; Revenue, 100, 128, 128.0; EBITDA, 18, 21.76, 120.9; Free cash flow, 15, 12, 80.080100120140Revenue 128.0EBITDA 120.9Free cash flow 80.0100PriorCurrent

Two periods; each metric indexed to prior period = 100. Raw values: revenue 100→128; EBITDA 18→21.76; FCF 15→12.

Fictional example · Not a client engagement
Data and definitions
MetricPriorCurrentCurrent index
Revenue100128128.0
EBITDA1821.76120.9
Free cash flow151280.0

Two periods; each metric indexed to prior period = 100. Raw values: revenue 100→128; EBITDA 18→21.76; FCF 15→12.

Question

Revenue rises from 100 to 128 and EBITDA from 18 to 21.76, but margin falls from 18% to 17% and free cash flow from 15 to 12. Growth, earnings and cash need separate examination.

Analysis

The given revenue bridge is 100 + 16 + 8 + 9 − 5 = 128. Free-cash-flow/EBITDA falls from 83.3% to 55.1%. Check working capital, capital expenditure, cash taxes and other movements rather than immediately claiming one cause.

From the conclusion to its evidence.

Analysis

Amounts: millions / independent zero baselines

More revenue. More profit. Less cash.

More revenue. More profit. Less cash.Metric, Prior, Current; Revenue, 100, 128; EBITDA, 18, 21.76; Free cash flow, 15, 12Revenue075150100Prior128CurrentEBITDA012.52518Prior21.76CurrentFree cash flow0102015Prior12Current

Each small multiple has its own scale for within-metric comparison; absolute values appear above the bars.

Fictional example · Not a client engagement
Data and definitions
MetricPriorCurrent
Revenue100128
EBITDA1821.76
Free cash flow1512

Each small multiple has its own scale for within-metric comparison; absolute values appear above the bars.

Two-period metrics / separately scaled rows

Margin and cash conversion are not the same.

Margin and cash conversion are not the same.Metric, Prior, Current, Change / pp; EBITDA margin, 18.0%, 17.0%, -1.0; FCF / EBITDA, 83.3%, 55.1%, -28.2PriorCurrentEBITDA margin0%10%20%25%18.0%17.0%FCF / EBITDA0%25%50%75%100%83.3%55.1%

Margin falls 1.0 percentage point; FCF/EBITDA falls 28.2 points. Direction and magnitude, not an attribution of cash movement.

Fictional example · Not a client engagement
Data and definitions
MetricPriorCurrentChange / pp
EBITDA margin18.0%17.0%−1.0
FCF / EBITDA83.3%55.1%−28.2

Margin falls 1.0 percentage point; FCF/EBITDA falls 28.2 points. Direction and magnitude, not an attribution of cash movement.

Current revenue fixed at 128 / estimated receivables: millions

What does thirteen extra collection days cost?

What does thirteen extra collection days cost?Assumed days, Estimated receivables; 45, 15.7808; 58, 20.33970510152045 days15.7858 days20.34Additional cash tied up +4.56

128 ÷ 365 × 13 ≈ 4.56. Based on current revenue, this isolates the change in DSO and assumes uniform annual credit sales. Receivables absorb about 4.56, more than the 3 decline in free cash flow, so other items partly offset it. A cash-flow reconciliation is needed to confirm the drivers.

Fictional example · Not a client engagement
Data and definitions
Assumed daysEstimated receivables
4515.7808
5820.3397

128 ÷ 365 × 13 ≈ 4.56. Based on current revenue, this isolates the change in DSO and assumes uniform annual credit sales. Receivables absorb about 4.56, more than the 3 decline in free cash flow, so other items partly offset it. A cash-flow reconciliation is needed to confirm the drivers.

MetricPriorCurrent
Revenue100128
EBITDA1821.76
EBITDA margin18%17%
Free cash flow1512
Days sales outstanding4558

Receivables pressure

Assuming annual revenue, uniform credit sales and no other differences, DSO rises from 45 to 58. At current revenue, additional cash tied up is 128 ÷ 365 × 13 ≈ 4.56. Receivables absorb about 4.56, more than the 3 decline in free cash flow, so other items partly offset it. A cash-flow reconciliation is needed to confirm the drivers.

Decision implication

Track collections by customer and ageing, analyse the margin decline and build a rolling cash forecast. Management should approve owners, timing and targets against the actual situation.

Amounts in millions. Receivables estimates ignore seasonality, sales taxes, cash sales and ageing differences. A real cash-flow reconciliation is required to attribute the FCF change.