Competitive Intelligence — MERCY MEDICAL CENTER - NEW HAMPTON
CCN 161331 | IA | 11 beds | Nat'l margin P60 | 16 gaps to P75
🛡️ Public data only — no PHI permitted on this instance.
$19.7M
Net Revenue
-1.0%
Margin (P60)
11
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=715) | IA Size-Matched (n=24) | Direction |
|---|---|---|---|---|---|---|
| Net Patient Revenue | $19.7M | P22 | P19 | P51 | P38 | ▲ higher |
| Operating Margin | -1.0% | P60 | P79 | P70 | P79 | ▲ higher |
| Bed Count | 11 | P2 | P1 | P7 | P4 | ▶ neutral |
| Revenue per Bed | $1.8M | P72 | P73 | P70 | P58 | ▲ higher |
| Occupancy Rate | 31.1% | P25 | P57 | P60 | P79 | ▲ higher |
| Net-to-Gross Ratio | 51.2% | P76 | P51 | P41 | P38 | ▲ higher |
| Expense per Bed | $1.8M | P70 | P67 | P66 | P58 | ▼ lower |
| Medicare Day % | 63.3% | P90 | P75 | P69 | P62 | ▶ neutral |
| Medicaid Day % | 0.0% | P0 | P0 | P0 | P0 | ▶ neutral |
| Commercial Payer % | 36.7% | P15 | P32 | P40 | P46 | ▲ higher |
| Payer Diversity Index | 0.465 | P46 | P35 | P48 | P38 | ▲ higher |
| Total Patient Days | 1,247 | P10 | P25 | P41 | P54 | ▲ 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 | $19.7M | $41.1M | +$21.5M | P38 | ~$23.6M |
| Net Patient Revenue | $19.7M | $33.0M | +$13.3M | P51 | ~$14.7M |
| Expense per Bed | $1.8M | $2.2M | -$1.0M | P66 | ~$1.1M |
| Expense per Bed | $1.8M | $2.3M | -$800K | P58 | ~$880K |
| Revenue per Bed | $1.8M | $2.0M | +$239K | P58 | ~$263K |
| Revenue per Bed | $1.8M | $2.0M | +$219K | P70 | ~$241K |
| Total Patient Days | 1,247 | 2,568 | +1,321 | P41 | — |
| Total Patient Days | 1,247 | 1,606 | +358 | P54 | — |
| Commercial Payer % | 36.7% | 60.2% | +23.5% | P40 | ~$4.6M |
| Net-to-Gross Ratio | 51.2% | 69.9% | +18.7% | P41 | ~$3.7M |
Top Size-Matched Peers
10–22 beds, ranked by revenue. Click any peer for full profile.
| Hospital | State | Beds | Revenue | Margin | Medicare |
|---|---|---|---|---|---|
| MERCY MEDICAL CENTER - NEW HAM (Target) | IA | 11 | $19.7M | -1.0% | 63% |
| FRED HUTCHINSON CANCER CENTER | WA | 20 | $1.17B | -50.0% | 22% |
| WENATCHEE VALLEY HOSPITAL | WA | 11 | $277.5M | -4.9% | 47% |
| PORTERVILLE DEVELOPMENTAL CENT | CA | 17 | $193.6M | -6.0% | 14% |
| NATIONAL JEWISH HEALTH | CO | 13 | $150.4M | -50.0% | 42% |
| NORTON SOUND REGIONAL HOSPITAL | AK | 18 | $148.7M | -28.6% | 34% |
| TEXAS SPINE AND JOINT HOSPITAL | TX | 20 | $147.3M | 30.3% | 52% |
| GREAT FALLS CLINIC MEDICAL CEN | MT | 20 | $132.1M | 21.0% | 44% |
| MARSHFIELD MEDICAL CENTER-MINO | WI | 19 | $129.6M | -12.4% | 32% |
| FRANCISCAN HEALTH HAMMOND | IN | 10 | $117.7M | -4.3% | 39% |
| NEW YORK EYE AND EAR INFIRMARY | NY | 15 | $112.8M | -28.0% | 1% |