DUNDY COUNTY 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: 61% of modeled bridge. Strengths: Commercial Payer %, Bed Count. Risks: Occupancy Rate, Net-to-Gross Ratio. Risk-adjusted uplift: $0.3M (vs $0.5M 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 |
|---|---|---|---|---|---|---|---|
| Denial Rate Reduction | 12.0% DEFAULT | 6.5% BENCHMARK | $188K | $8K | $196K | $0 | 12mo |
| Cost to Collect | 4.5% DEFAULT | 2.5% BENCHMARK | $0 | $195K | $195K | $0 | 12mo |
| A/R Days Reduction | 52.00 DEFAULT | 38.00 BENCHMARK | $30K | $89K | $119K | $374K | 9mo |
| Clean Claim Rate | 88.0% DEFAULT | 96.0% BENCHMARK | $0 | $10K | $10K | $0 | 6mo |
| Net Collection Rate | 93.5% DEFAULT | 80.3% 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 |
|---|---|---|---|---|---|---|---|---|
| Denial Rate Reduction | $0 | $49K | $98K | $147K | $196K | $196K | $196K | $196K |
| Cost to Collect | $0 | $49K | $97K | $146K | $195K | $195K | $195K | $195K |
| A/R Days Reduction | $0 | $40K | $79K | $119K | $119K | $119K | $119K | $119K |
| Clean Claim Rate | $0 | $5K | $10K | $10K | $10K | $10K | $10K | $10K |
| Cumulative | $0 | $142K | $284K | $421K | $519K | $519K | $519K | $519K |
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 $519K 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 | Loss | Loss | Loss | Loss | Loss |
| 11.0x | Loss | Loss | Loss | Loss | Loss |
| 12.0x | Loss | Loss | Loss | 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 | $-3.5M | — | $-3.5M | -35.7% |
| Year 1 | $-3.6M | +$346K | $-3.2M | -33.2% |
| Year 2 | $-3.7M | +$519K | $-3.2M | -32.5% |
| Year 3 | $-3.8M | +$519K | $-3.3M | -33.6% |
| Year 4 | $-3.9M | +$519K | $-3.4M | -34.8% |
| Year 5 | $-4.0M | +$519K | $-3.5M | -36.0% |
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% |
|---|---|---|---|---|
| Denial Rate Reductio | $98K | $147K | $196K | $235K |
| Cost to Collect | $97K | $146K | $195K | $234K |
| A/R Days Reduction | $59K | $89K | $119K | $142K |
| Clean Claim Rate | $5K | $7K | $10K | $12K |
| Total | $260K | $389K | $519K | $623K |
Peer Context — Where This Hospital Sits
Key metrics vs 54 size-matched peers. Low percentile on margin/efficiency metrics = more room for improvement = larger bridge opportunity.
| Metric | Hospital | P25 | P50 | P75 | Percentile |
|---|---|---|---|---|---|
| Op Margin | -35.7% | -13.4% | -7.4% | -0.3% | P6 |
| Net-to-Gross | 72.3% | 67.3% | 72.5% | 80.3% | P48 |
| Occupancy | 15.7% | 9.6% | 16.1% | 21.9% | P43 |
| Rev/Bed | $812K | $728K | $1.2M | $1.7M | P30 |
| Exp/Bed | $1.1M | $729K | $1.3M | $1.7M | P41 |
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.