HAWKINS COUNTY MEMORIAL HOSPITAL
value-creation walk.
7-lever RCM bridge from current EBITDA to pro-forma — denial / underpay / DAR / coding / contract / cost discipline / cash acceleration. Each lever shows current vs benchmark target with data provenance.
Bridge Realization Estimate
ML model predicts what fraction of the bridge is achievable (accuracy: 60%, n=5,839)
Expected realization: 69% of modeled bridge. Strengths: Bed Count, Revenue per Bed. Risks: Occupancy Rate, Commercial Payer %. Risk-adjusted uplift: $0.5M (vs $0.7M modeled).
EBITDA Bridge — 7 RCM Levers
Each bar shows the annual EBITDA impact at full run-rate. Revenue levers increase top-line; cost levers reduce operating expense; cash acceleration releases working capital. Calibrated to published research bands (Denial 12%→5% = $8-15M on $400M NPR).
Lever Detail
Each value shows its data source. SELLER = seller data room, DEFAULT = model default, BENCHMARK = P75 peer benchmark.
| Lever | Current | Target | Revenue | Cost | EBITDA | WC | Ramp |
|---|---|---|---|---|---|---|---|
| Cost to Collect | 4.5% DEFAULT | 2.5% BENCHMARK | $0 | $275K | $275K | $0 | 12mo |
| Denial Rate Reduction | 12.0% DEFAULT | 6.5% BENCHMARK | $265K | $8K | $273K | $0 | 12mo |
| A/R Days Reduction | 52.00 DEFAULT | 38.00 BENCHMARK | $42K | $125K | $167K | $527K | 9mo |
| Clean Claim Rate | 88.0% DEFAULT | 96.0% BENCHMARK | $0 | $10K | $10K | $0 | 6mo |
| Net Collection Rate | 93.5% DEFAULT | 71.5% BENCHMARK | $0 | $0 | $0 | $0 | 18mo |
| CDI / Case Mix Index | 135.0% DEFAULT | 142.0% BENCHMARK | $0 | $0 | $0 | $0 | 18mo |
Implementation Timing Curve
Linear ramp to full run-rate per lever. Month 0 = close date. Partners should expect 60-70% of total uplift realized by month 12.
| Lever | M0 | M3 | M6 | M9 | M12 | M18 | M24 | M36 |
|---|---|---|---|---|---|---|---|---|
| Cost to Collect | $0 | $69K | $137K | $206K | $275K | $275K | $275K | $275K |
| Denial Rate Reduction | $0 | $68K | $136K | $205K | $273K | $273K | $273K | $273K |
| A/R Days Reduction | $0 | $56K | $111K | $167K | $167K | $167K | $167K | $167K |
| Clean Claim Rate | $0 | $5K | $10K | $10K | $10K | $10K | $10K | $10K |
| Cumulative | $0 | $197K | $395K | $588K | $724K | $724K | $724K | $724K |
Returns Sensitivity (IRR / MOIC)
5-year hold, 5.5x leverage, 3% organic growth, 10%/yr debt paydown. Green = exceeds 20% IRR hurdle. Amber = 15-20%. Red = below hurdle or loss. RCM uplift of $724K is added at exit.
| Entry \ Exit | 9.0x | 10.0x | 11.0x | 11.5x | 12.0x |
|---|---|---|---|---|---|
| 8.0x | Loss | Loss | Loss | Loss | Loss |
| 9.0x | Loss | Loss | Loss | Loss | Loss |
| 10.0x | -100% / 0.0x | Loss | Loss | Loss | Loss |
| 11.0x | -100% / 0.0x | -100% / 0.0x | Loss | Loss | Loss |
| 12.0x | -100% / 0.0x | -100% / 0.0x | -100% / 0.0x | Loss | Loss |
Covenant Headroom (at 10x Entry, 6.5x Max Leverage)
Pro forma EBITDA can decline 0% before the 6.5x covenant trips. RCM uplift reduces leverage from 99.0x to 99.0x, adding 0.0 turns of cushion.
5-Year Value Creation Waterfall
EBITDA trajectory: 3% organic growth + RCM uplift ramp (full run-rate at month 18).
| Base EBITDA | RCM Uplift | Total | Margin | |
|---|---|---|---|---|
| Entry | $-1.1M | — | $-1.1M | -8.4% |
| Year 1 | $-1.2M | +$483K | $-700K | -5.1% |
| Year 2 | $-1.2M | +$724K | $-494K | -3.6% |
| Year 3 | $-1.3M | +$724K | $-531K | -3.9% |
| Year 4 | $-1.3M | +$724K | $-568K | -4.1% |
| Year 5 | $-1.3M | +$724K | $-607K | -4.4% |
Achievement Sensitivity
What if we only achieve a fraction of each lever? 50% = conservative, 75% = base management case, 100% = plan, 120% = stretch.
| Lever | 50% | 75% | 100% | 120% |
|---|---|---|---|---|
| Cost to Collect | $137K | $206K | $275K | $330K |
| Denial Rate Reductio | $136K | $205K | $273K | $327K |
| A/R Days Reduction | $84K | $125K | $167K | $201K |
| Clean Claim Rate | $5K | $7K | $10K | $12K |
| Total | $362K | $543K | $724K | $869K |
Peer Context — Where This Hospital Sits
Key metrics vs 114 size-matched peers. Low percentile on margin/efficiency metrics = more room for improvement = larger bridge opportunity.
| Metric | Hospital | P25 | P50 | P75 | Percentile |
|---|---|---|---|---|---|
| Op Margin | -8.4% | -22.5% | -8.7% | 2.4% | P50 |
| Net-to-Gross | 18.3% | 35.8% | 53.0% | 71.5% | P8 |
| Occupancy | 47.3% | 15.4% | 24.4% | 38.0% | P81 |
| Rev/Bed | $2.3M | $845K | $1.4M | $2.5M | P72 |
| Exp/Bed | $2.5M | $1.1M | $1.6M | $2.7M | P72 |
Bridge Methodology
Coefficients calibrated to published research bands: denial 12%→5% = $8-15M on $400M NPR. Current metrics estimated from HCRIS public data and ML predictions. Target metrics set at P75 peer benchmarks with 60% gap closure assumption. Revenue levers use NPR × delta × avoidable share. Cost levers use claims volume × cost per reworked claim. Working capital from AR reduction is one-time cash (not included in recurring EBITDA). Returns assume 5.5x leverage, 3% organic growth, 10%/yr debt paydown.