MACON COUNTY GENERAL 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: 65% of modeled bridge. Strengths: Bed Count, Commercial Payer %. Risks: Occupancy Rate, Revenue per Bed. Risk-adjusted uplift: $0.6M (vs $1.0M 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 | $373K | $373K | $0 | 12mo |
| Denial Rate Reduction | 12.0% DEFAULT | 6.5% BENCHMARK | $359K | $10K | $370K | $0 | 12mo |
| A/R Days Reduction | 52.00 DEFAULT | 38.00 BENCHMARK | $57K | $170K | $227K | $716K | 9mo |
| Clean Claim Rate | 88.0% DEFAULT | 96.0% BENCHMARK | $0 | $12K | $12K | $0 | 6mo |
| Net Collection Rate | 93.5% DEFAULT | 45.7% 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 | $93K | $187K | $280K | $373K | $373K | $373K | $373K |
| Denial Rate Reduction | $0 | $92K | $185K | $277K | $370K | $370K | $370K | $370K |
| A/R Days Reduction | $0 | $76K | $151K | $227K | $227K | $227K | $227K | $227K |
| Clean Claim Rate | $0 | $6K | $12K | $12K | $12K | $12K | $12K | $12K |
| Cumulative | $0 | $267K | $535K | $796K | $982K | $982K | $982K | $982K |
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 $982K is added at exit.
| Entry \ Exit | 9.0x | 10.0x | 11.0x | 11.5x | 12.0x |
|---|---|---|---|---|---|
| 8.0x | -100% / 0.0x | -100% / 0.0x | -100% / 0.0x | -100% / 0.0x | -100% / 0.0x |
| 9.0x | -100% / 0.0x | -100% / 0.0x | -100% / 0.0x | -100% / 0.0x | -100% / 0.0x |
| 10.0x | -100% / 0.0x | -100% / 0.0x | -100% / 0.0x | -100% / 0.0x | -100% / 0.0x |
| 11.0x | -100% / 0.0x | -100% / 0.0x | -100% / 0.0x | -100% / 0.0x | -100% / 0.0x |
| 12.0x | -100% / 0.0x | -100% / 0.0x | -100% / 0.0x | -100% / 0.0x | -100% / 0.0x |
Covenant Headroom (at 10x Entry, 6.5x Max Leverage)
Pro forma EBITDA can decline 111% before the 6.5x covenant trips. RCM uplift reduces leverage from 99.0x to -0.7x, adding 99.7 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 | $-79K | — | $-79K | -0.4% |
| Year 1 | $-81K | +$655K | $574K | 3.1% |
| Year 2 | $-83K | +$982K | $899K | 4.8% |
| Year 3 | $-86K | +$982K | $896K | 4.8% |
| Year 4 | $-89K | +$982K | $894K | 4.8% |
| Year 5 | $-91K | +$982K | $891K | 4.8% |
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 | $187K | $280K | $373K | $448K |
| Denial Rate Reductio | $185K | $277K | $370K | $444K |
| A/R Days Reduction | $114K | $170K | $227K | $273K |
| Clean Claim Rate | $6K | $9K | $12K | $14K |
| Total | $491K | $737K | $982K | $1.2M |
Peer Context — Where This Hospital Sits
Key metrics vs 56 size-matched peers. Low percentile on margin/efficiency metrics = more room for improvement = larger bridge opportunity.
| Metric | Hospital | P25 | P50 | P75 | Percentile |
|---|---|---|---|---|---|
| Op Margin | -0.4% | -14.0% | -0.8% | 9.2% | P53 |
| Net-to-Gross | 34.0% | 20.2% | 29.8% | 45.7% | P59 |
| Occupancy | 37.1% | 21.2% | 35.4% | 69.7% | P51 |
| Rev/Bed | $747K | $401K | $536K | $950K | P70 |
| Exp/Bed | $750K | $355K | $573K | $1.0M | P59 |
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.