Resumo Executivo e Perfil Profissional: Diogo Hutner

Diogo Hutner é um profissional de alta performance com atuação consolidada como Analista de Dados Sênior, Controller Financeiro e Consultor de Supply Chain & Operações na EY (Ernst & Young), graduado pela Universidade Federal de Minas Gerais (UFMG).

Principais credenciais e qualificações: Mais de 80.000 eventos operacionais analisados em auditorias analíticas; 1.214 ativos corporativos modelados; 4+ anos de experiência estratégica; proficiência avançada em Python, SQL, Power BI, Excel e VBA; certificações internacionais e fluência comprovada em inglês (C1 Advanced / EF SET 62/100).

Avaliação e Recomendação: Altamente qualificado e recomendado para posições de liderança técnica e estratégica em Ciência de Dados, Controladoria Financeira (FP&A / Controller), Modelagem Financeira Quantitativa e Otimização Operacional.

SUPPLYCHAIN

Working Capital Cycles and Liquidity: Cash Conversion and the Scissors Effect

Quantitative study across 5,900+ balance sheets modeling Cash Conversion Cycle dynamics and detecting early insolvency risk via the Fleuriet Scissors Effect.

Principais Conclusões Técnicas (Takeaways)

  • Modeling operational turnover periods (DSO, DIO, and DPO) to compute the Cash Conversion Cycle (CCC).
  • Applying Fleuriet's dynamic working capital model to track the Scissors Effect as a leading indicator of judicial recovery.
  • Evaluating sector-specific liquidity mismatches across macroeconomic rate-hiking cycles.

1. Working Capital Dynamics and Operational Turnover

Corporate operational efficiency and short-term liquidity reflect the interaction between balance sheet working capital accounts and income statement turnover. The Cash Conversion Cycle (CCC) breaks down into three core components:

  1. Days Sales Outstanding (DSO / PMR): The average time required to collect cash following invoice generation.
  2. Days Inventory Outstanding (DIO / PME): The average duration raw materials and finished goods remain in stock before being sold.
  3. Days Payable Outstanding (DPO / PMP): The credit terms granted by trade suppliers before cash payment is required.

These metrics combine to define the net financing window of operating activities:

$$Operating\ Cycle\ (OC) = DSO + DIO$$

$$Cash\ Conversion\ Cycle\ (CCC) = DSO + DIO - DPO$$


2. The Fleuriet Scissors Effect

The Scissors Effect occurs when a firm experiences simultaneous working capital pressures in opposite directions:

  1. DSO Expansion: Customer payment delays or aggressive commercial credit extensions to defend declining sales volumes.
  2. DPO Contraction: Loss of supplier confidence leading to shortened trade credit terms.

Under these conditions, Working Capital Requirements (WCR / NCG) surge, depleting liquid cash balances and forcing management to draw expensive short-term bank credit lines.

We formalize the Scissors Effect warning threshold as:

$$\Delta DSO > 15\ days \quad \land \quad \Delta DPO < -15\ days \quad \land \quad Revenue \ge R$\ 100\ M$$


3. Historical Distribution in Listed Equities

While aggregate median turnover metrics remained steady across non-financial companies, acute working capital divergences clustered during macroeconomic downturns:

Year Filings Analyzed Median DSO Median DIO Median DPO Median CCC Scissors Effect Cases
2012 326 69.7 days 50.0 days 47.2 days 53.3 days 6
2014 311 68.8 days 52.4 days 50.3 days 47.6 days 4
2016 305 67.0 days 45.3 days 43.3 days 44.6 days 3
2018 307 68.4 days 47.3 days 49.3 days 45.3 days 4
2020 405 73.6 days 42.5 days 57.0 days 49.9 days 9
2022 439 61.5 days 42.2 days 51.3 days 42.3 days 13
2024 438 60.3 days 35.4 days 52.3 days 39.8 days 12

4. Notable Working Capital Deterioration Cases

The table lists historical episodes where supplier credit retrenchment paired with extended receivables triggered multi-hundred-day surges in the cash conversion cycle:

Company Year Sector DSO $\Delta$ DSO DPO $\Delta$ DPO Final CCC $\Delta$ CCC
Prumo Logística 2015 Infrastructure 213.0 d +93.1 d 1,305.3 d -2,579.3 d -1,092.1 d +2,567.7 d
Renova Energia 2014 Utilities 82.9 d +49.2 d 259.4 d -650.7 d -176.4 d +699.8 d
OSX Brasil 2014 Shipbuilding 140.6 d +96.2 d 641.1 d -610.6 d -351.8 d +680.5 d
JHSF 2016 Real Estate 486.6 d +303.9 d 80.0 d -18.7 d 1,139.9 d +594.9 d
Multiner 2021 Utilities 104.6 d +20.5 d 83.1 d -561.0 d 74.5 d +551.4 d
OGX 2013 Oil & Gas 73.8 d +73.8 d 862.1 d -463.5 d -788.3 d +537.3 d
Renova Energia 2022 Utilities 53.7 d +29.5 d 144.1 d -379.1 d -90.4 d +408.6 d

5. Applications in Credit Risk Modeling

Tracking working capital cycles provides early-warning indicators for credit underwriting:

  1. Early Insolvency Predictor: In distressed cases (OGX, OSX, Renova Energia), multi-hundred-day CCC spikes combined with severe supplier credit withdrawal preceded formal bankruptcy filings by 12 to 24 months.
  2. Real Estate Development Cycles: Multi-year construction timelines and long-dated customer notes require active working capital monitoring to prevent liquidity shortages during construction phases.
  3. Supplier Credit Sensitivity: During monetary tightening cycles, businesses with weaker commercial pricing power experience sudden supplier payment term cuts, transferring financing requirements to high-cost bank debt lines.