AP Cash Flow Forecasting & Liquidity Risk Dashboard

Crestwood Packaging Solutions LLC • Probabilistic payment schedule for treasury liquidity optimization

30-Day P50 Forecast
$18.4M
+2.1%
7-Day Forecast Variance
-4.1%
Over-forecast
DPO Trend
48.2
Target: 45-52 days
Maturity Concentration
$6.2M
Nov 14-18 (35%)
ANYP Balance
$3.1M
Avg age: 9.4 days
Credit Utilization
18%
$4.5M / $25M
Probabilistic AP Outflow Forecast (90-Day)
Invoice Aging Distribution
AP Liability Currency Exposure
Critical Suppliers
142
On-time rate:94.2%
Avg payment:$28.4K
Monthly volume:$4.0M
Strategic Partners
68
On-time rate:96.8%
Avg payment:$52.1K
Monthly volume:$3.5M
Commodity Suppliers
1,284
On-time rate:87.3%
Avg payment:$8.9K
Monthly volume:$11.4M
High-Risk Invoice Forecast (Next 30 Days)
Invoice # Supplier Amount Due Date P90 Pay Date Delay Risk Currency
INV-84721Harrington Industrial Leasing$2,140,000Nov 15Nov 16Low 8%USD
INV-84518Midwest Logistics Group$847,200Nov 08Nov 12Med 34%USD
INV-84623Europack Materials GmbH€512,000Nov 20Nov 26High 58%EUR
INV-84702Precision Components Ltd£284,500Nov 12Nov 14Low 12%GBP
INV-84589Atlas Supply Chain Services$625,000Nov 18Nov 22Med 41%USD
INV-84641Northern Manufacturing Co$398,400Nov 25Nov 28Low 15%USD
INV-84512Continental Freight Systems$452,100Nov 06Nov 10Med 37%USD
INV-84668Global Packaging Materials€318,200Nov 22Nov 29High 62%EUR
Forecast Bias Trend (13-Week)
Payment Run Execution Rate
90-Day AP Outflow Scenario Comparison
Working Capital Covenant Monitor
Current Ratio 1.68
Covenant minimum: 1.50
Days Payable Outstanding 48.2
Target range: 45-52 days
Quick Ratio 1.12
Covenant minimum: 1.00
Liquidity Risk Heat Map
Cash Buffer Adequacy
Current: $8.2M vs. 5-day requirement: $3.1M
LOW
FX Exposure Risk
Unhedged EUR/GBP liability: $2.8M (14.2%)
MED
Concentration Event Nov 14-18
$6.2M maturity (35% of month) requires staging
HIGH
Credit Line Headroom
$20.5M available of $25M facility
LOW