FP&A Dashboard — Cash Flow, Liquidity & 13-Week Forecast
Beacon Health Analytics · Q1 2025 · 13-Week Rolling Liquidity View
Covenant Headroom
19%
Near threshold
DSO Sensitivity
-$3.1M
+4 days vs plan
13-Week Cash Balance Forecast (Base Scenario)
Alert: Week 9 collections shortfall scenario breached internal minimum ($30M policy). Drew $5M from revolver to maintain buffer.
EBITDA to Free Cash Flow Bridge
Covenant Headroom Gauge
Minimum required: 12% · Current: 19% · Next test: 3 weeks
Forecast-to-Actual Cash MAPE (Rolling 12W)
Capex Cash Outflow vs. Plan
Collection Shortfall Scenarios & Impact
| Scenario |
DSO Impact |
Cash Impact |
Min Cash |
Headroom |
Action Req'd |
| Base |
52 days |
$0 |
$28.0M |
19% |
Monitor |
| DSO +7d |
59 days |
-$5.4M |
$22.6M |
9% |
Draw revolver |
| Major cust delay |
65 days |
-$10.1M |
$17.9M |
3% |
Full draw + AP stretch |
| DSO -3d |
49 days |
+$2.3M |
$30.3M |
23% |
None |
| Current (Wk 4) |
56 days |
-$3.1M |
$24.9M |
11% |
Revolver standby |
AP Payment Stretch
1.08×
vs. terms
Revolver Draw Prob.
34%
next 6 weeks
Min Cash Buffer Days
9.3
policy: 12 days
Facility Available
$20M
of $25M total
Last updated: Jan 22, 2025 · Data as of Week 4 · FP&A Team · Beacon Health Analytics