Competitive Intelligence — RH OF NORTHWEST INDIANA LLC
CCN 152024 | IN | 61 beds | Nat'l margin P77 | 17 gaps to P75
🛡️ Public data only — no PHI permitted on this instance.
$27.7M
Net Revenue
6.7%
Margin (P77)
61
Beds
6,123
National Universe
4
Peer Groups
Percentile Rankings — All Metrics
Percentile rank across 4 peer groups. Bar shows position: left = bottom of peers, right = top. Green = favorable direction, red = unfavorable. Direction: ▲ higher is better, ▼ lower is better, ▶ neutral.
Data: CMS HCRIS FY2022 | 6,123 hospitals with complete financials
| Metric | Value | National (n=6,122) | IN State (n=170) | Size-Matched (n=2,131) | IN Size-Matched (n=72) | Direction |
|---|---|---|---|---|---|---|
| Net Patient Revenue | $27.7M | P31 | P31 | P35 | P39 | ▲ higher |
| Operating Margin | 6.7% | P76 | P67 | P70 | P58 | ▲ higher |
| Bed Count | 61 | P49 | P60 | P50 | P62 | ▶ neutral |
| Revenue per Bed | $454K | P20 | P20 | P33 | P37 | ▲ higher |
| Occupancy Rate | 60.6% | P59 | P66 | P60 | P62 | ▲ higher |
| Net-to-Gross Ratio | 11.8% | P4 | P2 | P4 | P0 | ▲ higher |
| Expense per Bed | $424K | P17 | P18 | P29 | P35 | ▼ lower |
| Medicare Day % | 53.3% | P83 | P92 | P86 | P90 | ▶ neutral |
| Medicaid Day % | 0.0% | P0 | P0 | P0 | P0 | ▶ neutral |
| Commercial Payer % | 46.7% | P26 | P11 | P25 | P12 | ▲ higher |
| Payer Diversity Index | 0.498 | P63 | P71 | P63 | P79 | ▲ higher |
| Total Patient Days | 13,497 | P52 | P61 | P56 | P65 | ▲ higher |
Value Creation Gaps — Path to P75
Metrics where the target trails size-matched P75 peers. Each gap represents quantifiable value creation opportunity. Estimated EBITDA impact assumes linear improvement proportional to revenue.
| Metric | Current | P75 Target | Gap | Percentile | Est. Impact |
|---|---|---|---|---|---|
| Net Patient Revenue | $27.7M | $148.4M | +$120.7M | P39 | ~$736.3M |
| Net Patient Revenue | $27.7M | $108.5M | +$80.7M | P35 | ~$492.5M |
| Revenue per Bed | $454K | $2.0M | +$1.5M | P37 | ~$9.2M |
| Revenue per Bed | $454K | $1.6M | +$1.1M | P33 | ~$6.7M |
| Expense per Bed | $424K | $1.9M | -$77K | P35 | ~$473K |
| Expense per Bed | $424K | $1.6M | -$38K | P29 | ~$232K |
| Total Patient Days | 13,497 | 18,870 | +5,373 | P56 | — |
| Total Patient Days | 13,497 | 16,131 | +2,634 | P65 | — |
| Net-to-Gross Ratio | 11.8% | 44.9% | +33.2% | P4 | ~$9.2M |
| Net-to-Gross Ratio | 11.8% | 43.7% | +31.9% | P0 | ~$8.9M |
Top Size-Matched Peers
30–122 beds, ranked by revenue. Click any peer for full profile.
| Hospital | State | Beds | Revenue | Margin | Medicare |
|---|---|---|---|---|---|
| RH OF NORTHWEST INDIANA LLC (Target) | IN | 61 | $27.7M | 6.7% | 53% |
| MIDWESTERN REGIONAL MEDICAL CE | IL | 73 | $1.38B | 80.5% | 30% |
| SMDC MEDICAL CENTER | MN | 118 | $519.2M | -7.1% | 27% |
| RANCHO LOS AMIGOS NATL.REHAB.C | CA | 83 | $512.6M | 41.9% | 5% |
| WENTWORTH DOUGLASS HOSPITAL | NH | 118 | $500.9M | 10.7% | 35% |
| MCHS - SOUTHWEST MINNESOTA REG | MN | 118 | $473.6M | -9.8% | 32% |
| USC NORRIS CANCER HOSPITAL | CA | 60 | $468.7M | 19.1% | 24% |
| THE HEART HOSPITAL BAYLOR PLAN | TX | 109 | $464.6M | 25.7% | 39% |
| SARAH BUSH LINCOLN HEALTH CENT | IL | 100 | $448.6M | -18.1% | 42% |
| ST. JOSEPHS COMM. HOSPT. | WI | 70 | $436.8M | 66.1% | 32% |
| MCHS FRANCISCAN HEALTHCARE IN | WI | 103 | $413.8M | -7.2% | 39% |