Working Capital & Liquidity Stress Dashboard

Meridian Industrial Components ยท Real-time liquidity monitoring and stress testing

Cash Conversion Cycle
38.2 days
โˆ’5.9d vs 8wk ago
Days Sales Outstanding
34.7 days
+2.7d vs target
Days Payable Outstanding
43.0 days
Optimized
Liquidity Coverage Ratio
1.67x
Base scenario
Liquidity Runway (Stress -30%)
47 days
Above 30-day minimum
Revolving Credit Utilization
28%
$14.4M avail. of $20M

13-Week Rolling Cash Flow Forecast

AR Aging Cohort Velocity

Cash Conversion Cycle by Business Unit

LCR Stress Scenario Analysis

Base Scenario
1.67x
Healthy
Revenue โˆ’20%
1.31x
Adequate
Revenue โˆ’40%
0.94x
Below Threshold

DPO Optimization vs Supplier Concentration

Inventory Days Outstanding by Category

Working Capital Detail by Business Unit

Business Unit Revenue (TTM) CCC (days) DSO DIO DPO WC / Rev % AR Balance Inventory
Manufacturing $82.4M 32.1 28.4 46.2 42.5 14.2% $6.4M $10.4M
Distribution $67.2M 48.7 42.3 51.8 45.4 19.8% $7.8M $9.5M
Services $30.4M 26.8 31.2 12.1 16.5 8.4% $2.6M $1.0M
Consolidated $180.0M 38.2 34.7 39.5 43.0 15.6% $16.8M $20.9M

Top 5 Supplier Concentration

Acme Materials 22.4%
Global Steel Ltd 18.1%
Precision Parts Co 14.7%
Industrial Supply Inc 11.2%
Metro Logistics 8.9%
Top 5 Total 75.3%

WC % Revenue (4Q Rolling)

Revolving Credit Facility

Total Facility
$20.0M
Outstanding
$5.6M
Available
$14.4M
Interest Rate
SOFR + 2.25%
Covenant: Min DSCR
1.25x (Current: 1.82x)

13-Week Cash Forecast Accuracy (MAPE by Week)