Competitive Intelligence — MERCY IOWA CITY REHABILITATION HOSPI
CCN 163026 | IA | 40 beds | Nat'l margin P15 | 15 gaps to P75
🛡️ Public data only — no PHI permitted on this instance.
$8.3M
Net Revenue
-26.2%
Margin (P15)
40
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) | IA State (n=123) | Size-Matched (n=2,737) | IA Size-Matched (n=81) | Direction |
|---|---|---|---|---|---|---|
| Net Patient Revenue | $8.3M | P6 | P2 | P8 | P1 | ▲ higher |
| Operating Margin | -26.2% | P15 | P5 | P15 | P1 | ▲ higher |
| Bed Count | 40 | P36 | P71 | P58 | P84 | ▶ neutral |
| Revenue per Bed | $208K | P5 | P2 | P6 | P2 | ▲ higher |
| Occupancy Rate | 29.7% | P24 | P56 | P34 | P64 | ▲ higher |
| Net-to-Gross Ratio | 48.0% | P72 | P44 | P64 | P34 | ▲ higher |
| Expense per Bed | $263K | P7 | P2 | P8 | P1 | ▼ lower |
| Medicare Day % | 61.6% | P89 | P71 | P84 | P69 | ▶ neutral |
| Medicaid Day % | 0.0% | P0 | P0 | P0 | P0 | ▶ neutral |
| Commercial Payer % | 38.4% | P16 | P35 | P24 | P38 | ▲ higher |
| Payer Diversity Index | 0.473 | P50 | P37 | P42 | P36 | ▲ higher |
| Total Patient Days | 4,342 | P30 | P71 | P45 | P84 | ▲ 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 | $8.3M | $61.5M | +$53.2M | P8 | ~$212.7M |
| Net Patient Revenue | $8.3M | $47.9M | +$39.6M | P1 | ~$158.4M |
| Revenue per Bed | $208K | $1.8M | +$1.6M | P2 | ~$6.5M |
| Revenue per Bed | $208K | $1.8M | +$1.6M | P6 | ~$6.5M |
| Total Patient Days | 4,342 | 9,519 | +5,177 | P45 | — |
| Occupancy Rate | 29.7% | 63.9% | +34.1% | P34 | ~$2.8M |
| Operating Margin | -26.2% | 6.2% | +32.4% | P15 | ~$2.7M |
| Commercial Payer % | 38.4% | 66.3% | +27.9% | P24 | ~$2.3M |
| Operating Margin | -26.2% | -3.4% | +22.8% | P1 | ~$1.9M |
| Net-to-Gross Ratio | 48.0% | 59.0% | +11.0% | P34 | ~$916K |
Top Size-Matched Peers
20–80 beds, ranked by revenue. Click any peer for full profile.
| Hospital | State | Beds | Revenue | Margin | Medicare |
|---|---|---|---|---|---|
| MERCY IOWA CITY REHABILITATION (Target) | IA | 40 | $8.3M | -26.2% | 62% |
| DANA-FARBER CANCER INSTITUTE | MA | 30 | $1.88B | -35.1% | 35% |
| MIDWESTERN REGIONAL MEDICAL CE | IL | 73 | $1.38B | 80.5% | 30% |
| FRED HUTCHINSON CANCER CENTER | WA | 20 | $1.17B | -50.0% | 22% |
| MERCY WALWORTH HOSPITAL | WI | 25 | $616.4M | 4.4% | 34% |
| USC NORRIS CANCER HOSPITAL | CA | 60 | $468.7M | 19.1% | 24% |
| ST. JOSEPHS COMM. HOSPT. | WI | 70 | $436.8M | 66.1% | 32% |
| LAKEVIEW MEMORIAL | MN | 68 | $411.9M | 60.9% | 30% |
| MOUNTAIN VIEW HOSPITAL | ID | 43 | $382.5M | 8.7% | 5% |
| WISE HEALTH SYSTEM - PARKWAY | TX | 36 | $361.0M | -15.5% | 26% |
| THE GETTYSBURG HOSPITAL | PA | 76 | $341.8M | 18.4% | 38% |