Independent demonstration · Fictional data · Not a client engagement
Two-period comparison / each prior value = 100
Revenue and profit are up; cash is down.
Two periods; each metric indexed to prior period = 100. Raw values: revenue 100→128; EBITDA 18→21.76; FCF 15→12.
Data and definitions
| Metric | Prior | Current | Current index |
|---|---|---|---|
| Revenue | 100 | 128 | 128.0 |
| EBITDA | 18 | 21.76 | 120.9 |
| Free cash flow | 15 | 12 | 80.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.
AnalysisAmounts: millions / independent zero baselines
More revenue. More profit. Less cash.
Each small multiple has its own scale for within-metric comparison; absolute values appear above the bars.
Data and definitions
| Metric | Prior | Current |
|---|---|---|
| Revenue | 100 | 128 |
| EBITDA | 18 | 21.76 |
| Free cash flow | 15 | 12 |
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 falls 1.0 percentage point; FCF/EBITDA falls 28.2 points. Direction and magnitude, not an attribution of cash movement.
Data and definitions
| Metric | Prior | Current | Change / pp |
|---|---|---|---|
| EBITDA margin | 18.0% | 17.0% | −1.0 |
| FCF / EBITDA | 83.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?
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.
Data and definitions
| Assumed days | Estimated receivables |
|---|---|
| 45 | 15.7808 |
| 58 | 20.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.
| Metric | Prior | Current |
|---|---|---|
| Revenue | 100 | 128 |
| EBITDA | 18 | 21.76 |
| EBITDA margin | 18% | 17% |
| Free cash flow | 15 | 12 |
| Days sales outstanding | 45 | 58 |
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.