Internal Tool

Trapped Cash Assessment

Enter a stock ticker to pull the latest 10-K from SEC EDGAR and extract segment-level billing cycle analysis.

Try: SLB · HAL · BKR · CAT · EMR · NOV

Review & Edit Segment Data

Quick set all:
Segment Revenue ($M) AR ($M) DSO (days) Unbilled % WACC % Source

Total Trapped Cash
Annual Capital Drag
Weighted Avg DSO
Moderate Scenario Savings

A · Segment Comparison

DSO by Segment (days)
Trapped Cash by Segment ($M)

Segment Revenue AR DSO Trapped Cash Unbilled % Annual Cost

B · Annual Savings Scenarios

Segment Conservative (10%) Moderate (15%) Aggressive (25%) Stretch (35%)

Each cell shows: Annual savings | AR released | DSO improvement. Percentages represent unbilled AR reduction targets.

C · Quarterly Projection (8 Quarters)

D · Key Findings