πŸ›‘οΈ Public data only β€” no PHI permitted on this instance.
SC
SeekingChartis
CCN 180066 | KY | 37 beds | Current EBITDA $36K β†’ Pro Forma $1.2M (+$1.2M)
$22.1M
Net Revenue HCRIS
$36K
Current EBITDA COMPUTED
+$1.2M
RCM EBITDA Uplift
$1.2M
Pro Forma EBITDA
+526bps
Margin Improvement
$847K
WC Released (1x)

Bridge Realization Estimate

ML model predicts what fraction of the bridge is achievable (accuracy: 60%, n=5,839)

60%
Realization (C)
$1.2M
Modeled Uplift
$693K
Risk-Adjusted
-$469K
Execution Discount
Occupancy RateLower Occupancy Rate reduces execution likelihood
Revenue per BedLower Revenue per Bed reduces execution likelihood
Bed CountHigher Bed Count increases execution likelihood
Net-to-Gross RatioHigher Net-to-Gross Ratio increases execution like
Commercial Payer %Commercial Payer % has minimal effect on execution

Expected realization: 60% of modeled bridge. Strengths: Bed Count, Net-to-Gross Ratio. Risks: Occupancy Rate, Revenue per Bed. Risk-adjusted uplift: $0.7M (vs $1.2M 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).

Cost to Collect
Cost Savings | 12mo ramp
$442K
+200bp
Denial Rate Reduction
Revenue | 12mo ramp
$437K
+198bp
A/R Days Reduction
Cash Accel | 9mo ramp
$269K
+122bp
Clean Claim Rate
Cost Savings | 6mo ramp
$14K
+6bp
Total EBITDA Impact$1.2M

Lever Detail

Each value shows its data source. SELLER = seller data room, DEFAULT = model default, BENCHMARK = P75 peer benchmark.

LeverCurrentTargetRevenueCostEBITDAWCRamp
Cost to Collect4.5% DEFAULT2.5% BENCHMARK$0$442K$442K$012mo
Denial Rate Reduction12.0% DEFAULT6.5% BENCHMARK$425K$12K$437K$012mo
A/R Days Reduction52.00 DEFAULT38.00 BENCHMARK$68K$201K$269K$847K9mo
Clean Claim Rate88.0% DEFAULT96.0% BENCHMARK$0$14K$14K$06mo
Net Collection Rate93.5% DEFAULT40.6% BENCHMARK$0$0$0$018mo
CDI / Case Mix Index135.0% DEFAULT142.0% BENCHMARK$0$0$0$018mo

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.

LeverM0M3M6M9M12M18M24M36
Cost to Collect$0$110K$221K$331K$442K$442K$442K$442K
Denial Rate Reduction$0$109K$219K$328K$437K$437K$437K$437K
A/R Days Reduction$0$90K$179K$269K$269K$269K$269K$269K
Clean Claim Rate$0$7K$14K$14K$14K$14K$14K$14K
Cumulative$0$316K$633K$942K$1.2M$1.2M$1.2M$1.2M

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 $1.2M is added at exit.

Entry \ Exit9.0x10.0x11.0x11.5x12.0x
8.0x200% / 243.8x207% / 271.2x213% / 298.6x215% / 312.4x218% / 326.1x
9.0x193% / 216.3x199% / 240.7x205% / 265.1x208% / 277.3x211% / 289.5x
10.0x187% / 194.3x193% / 216.3x199% / 238.3x202% / 249.2x204% / 260.2x
11.0x181% / 176.4x187% / 196.3x193% / 216.3x196% / 226.3x198% / 236.3x
12.0x176% / 161.4x182% / 179.7x188% / 198.0x191% / 207.2x193% / 216.3x

Covenant Headroom (at 10x Entry, 6.5x Max Leverage)

8.5x
Entry Leverage
0.3x
Pro Forma Leverage
6.2x
Headroom (turns)
96%
EBITDA Cushion

Pro forma EBITDA can decline 96% before the 6.5x covenant trips. RCM uplift reduces leverage from 8.5x to 0.3x, adding 8.2 turns of cushion.

5-Year Value Creation Waterfall

EBITDA trajectory: 3% organic growth + RCM uplift ramp (full run-rate at month 18).

Base EBITDARCM UpliftTotalMargin
Entry$36Kβ€”$36K0.2%
Year 1$37K+$775K$811K3.7%
Year 2$38K+$1.2M$1.2M5.4%
Year 3$39K+$1.2M$1.2M5.4%
Year 4$40K+$1.2M$1.2M5.4%
Year 5$41K+$1.2M$1.2M5.4%
$356K
Entry EV (10x)
$13.2M
Exit EV (11x)
$12.9M
Value Created
$1.2M
Exit EBITDA
$57K
Organic Growth
$11.6M
RCM Value Creation
$1.2M
Multiple Expansion

Achievement Sensitivity

What if we only achieve a fraction of each lever? 50% = conservative, 75% = base management case, 100% = plan, 120% = stretch.

Lever50%75%100%120%
Cost to Collect$221K$331K$442K$530K
Denial Rate Reductio$219K$328K$437K$525K
A/R Days Reduction$134K$202K$269K$323K
Clean Claim Rate$7K$11K$14K$17K
Total$581K$872K$1.2M$1.4M

Peer Context β€” Where This Hospital Sits

Key metrics vs 63 size-matched peers. Low percentile on margin/efficiency metrics = more room for improvement = larger bridge opportunity.

MetricHospitalP25P50P75Percentile
Op Margin0.2%-11.0%-1.0%8.7%
P54
Net-to-Gross15.6%26.1%30.7%40.6%
P11
Occupancy12.9%25.7%35.9%57.7%
P3
Rev/Bed$597K$581K$852K$1.4M
P25
Exp/Bed$596K$602K$969K$1.2M
P24

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.

📄 Download ExcelValue TrackerFund LearningHospital ProfileML AnalysisPE ReturnsDCFLBO ModelDeal Screener
Data: HCRIS FY2022 | 6,123 hospitalsSources: HCRISML