Competitive Intelligence — MERCY HOSPITAL IOWA CITY
CCN 160029 | IA | 211 beds | Nat'l margin P13 | 16 gaps to P75
🛡️ Public data only — no PHI permitted on this instance.
$144.6M
Net Revenue
-28.1%
Margin (P13)
211
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=1,882) | IA Size-Matched (n=15) | Direction |
|---|---|---|---|---|---|---|
| Net Patient Revenue | $144.6M | P67 | P88 | P28 | P20 | ▲ higher |
| Operating Margin | -28.1% | P14 | P3 | P11 | P20 | ▲ higher |
| Bed Count | 211 | P81 | P95 | P58 | P80 | ▶ neutral |
| Revenue per Bed | $685K | P31 | P13 | P21 | P0 | ▲ higher |
| Occupancy Rate | 26.5% | P21 | P49 | P4 | P0 | ▲ higher |
| Net-to-Gross Ratio | 22.6% | P24 | P5 | P39 | P7 | ▲ higher |
| Expense per Bed | $878K | P36 | P18 | P28 | P7 | ▼ lower |
| Medicare Day % | 35.1% | P59 | P18 | P83 | P67 | ▶ neutral |
| Medicaid Day % | 7.4% | P63 | P75 | P60 | P67 | ▶ neutral |
| Commercial Payer % | 57.5% | P43 | P82 | P22 | P53 | ▲ higher |
| Payer Diversity Index | 0.541 | P82 | P81 | P83 | P60 | ▲ higher |
| Total Patient Days | 20,445 | P62 | P86 | P11 | P7 | ▲ 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 | $144.6M | $427.1M | +$282.5M | P28 | ~$5.96B |
| Net Patient Revenue | $144.6M | $338.4M | +$193.8M | P20 | ~$4.09B |
| Revenue per Bed | $685K | $1.8M | +$1.1M | P21 | ~$24.1M |
| Revenue per Bed | $685K | $1.6M | +$933K | P0 | ~$19.7M |
| Expense per Bed | $878K | $1.9M | -$97K | P28 | ~$2.0M |
| Total Patient Days | 20,445 | 66,024 | +45,579 | P11 | — |
| Total Patient Days | 20,445 | 42,328 | +21,883 | P7 | — |
| Occupancy Rate | 26.5% | 76.4% | +49.9% | P4 | ~$72.1M |
| Occupancy Rate | 26.5% | 62.2% | +35.6% | P0 | ~$51.5M |
| Operating Margin | -28.1% | 6.3% | +34.4% | P11 | ~$49.8M |
Top Size-Matched Peers
106–422 beds, ranked by revenue. Click any peer for full profile.
| Hospital | State | Beds | Revenue | Margin | Medicare |
|---|---|---|---|---|---|
| MERCY HOSPITAL IOWA CITY (Target) | IA | 211 | $144.6M | -28.1% | 35% |
| LUCILE PACKARD CHILDRENS HOSPI | CA | 394 | $2.39B | -0.8% | 0% |
| MAYO CLINIC HOSPITAL | AZ | 315 | $2.25B | 1.4% | 46% |
| RAINBOW BABIES & CHILDRENS HOS | OH | 231 | $2.22B | -5.0% | 0% |
| EASTERN MAINE MEDICAL CENTER | ME | 352 | $2.05B | 48.1% | 24% |
| ARTHUR G JAMES CANCER HOSPITAL | OH | 356 | $1.95B | 21.0% | 23% |
| MOFFITT CANCER CENTER | FL | 218 | $1.91B | 16.0% | 29% |
| UCI MEDICAL CENTER | CA | 397 | $1.90B | -2.5% | 19% |
| BANNER ESTRELLA MEDICAL CENTER | AZ | 317 | $1.84B | 79.2% | 13% |
| CITY OF HOPE NATIONAL MEDICAL | CA | 217 | $1.83B | -10.7% | 32% |
| RADY CHILDRENS HOSPITAL - SAN | CA | 401 | $1.82B | 14.8% | 0% |