Free Cash Flow & Cash Conversion

A year-end free-cash-flow bridge from NPAT through working capital and capex.

Illustrative SMB sample (NPAT 560k · FCF 380k · CC 67.9%). Currency-agnostic. Not financial advice.

Cash bridge inputs

ΔNWC ↑ = cash use; Capex as positive spend. Memo interest/tax are not re-subtracted · Jump to results

Net profit after tax

Add-back depreciation & amortisation

For secondary conversion %

Increase in net working capital

Capital expenditure as positive spend

Memo only — not subtracted again

Memo only — not subtracted again

Cash conversion policy bands

Default 80 — FCF / NPAT

Default 50

FCF bridge & conversion

Approx CFO → FCF → cash conversion vs policy lights.

Equations (locked)

  • ApproxCFO = NPAT + DA − ΔNWC
  • FCF = ApproxCFO − Capex = NPAT + DA − ΔNWC − Capex
  • Cash conversion = FCF ÷ NPAT (primary) · FCF ÷ EBITDA (secondary)
Bridge step$

How this is calculated
  • FCF = NPAT + DA − ΔNWC − Capex (SMB ApproxCFO path — not published CFO − Capex unless you substitute)
  • ΔNWC > 0 and Capex > 0 reduce FCF
  • Cash interest / tax are memo only — NPAT is already after interest & tax
  • CC light Green ≥ 80% / Amber ≥ 50% of NPAT (editable)

Illustrative — not financial advice. Not a full IAS 7 / AASB 107 statement.

Take it with you

Download a prompt or export the Excel workbook from your current inputs.

Takes your current inputs — stays on your device.