Competitive Intelligence — MERCY HOSPITAL OF VALLEY CITY
CCN 351324 | ND | 25 beds | Nat'l margin P60 | 16 gaps to P75
🛡️ Public data only — no PHI permitted on this instance.
$13.2M
Net Revenue
-0.8%
Margin (P60)
25
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) | ND State (n=51) | Size-Matched (n=2,513) | ND Size-Matched (n=37) | Direction |
|---|---|---|---|---|---|---|
| Net Patient Revenue | $13.2M | P13 | P44 | P23 | P50 | ▲ higher |
| Operating Margin | -0.8% | P60 | P83 | P64 | P81 | ▲ higher |
| Bed Count | 25 | P16 | P39 | P30 | P40 | ▶ neutral |
| Revenue per Bed | $529K | P24 | P38 | P27 | P42 | ▲ higher |
| Occupancy Rate | 30.3% | P24 | P45 | P43 | P51 | ▲ higher |
| Net-to-Gross Ratio | 54.3% | P79 | P33 | P67 | P22 | ▲ higher |
| Expense per Bed | $533K | P23 | P31 | P24 | P38 | ▼ lower |
| Medicare Day % | 68.7% | P93 | P69 | P87 | P60 | ▶ neutral |
| Medicaid Day % | 18.1% | P85 | P72 | P86 | P80 | ▶ neutral |
| Commercial Payer % | 13.2% | P2 | P4 | P3 | P5 | ▲ higher |
| Payer Diversity Index | 0.477 | P52 | P53 | P44 | P62 | ▲ higher |
| Total Patient Days | 2,767 | P22 | P51 | P42 | P57 | ▲ 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 | $13.2M | $50.4M | +$37.2M | P23 | ~$93.0M |
| Net Patient Revenue | $13.2M | $24.7M | +$11.5M | P50 | ~$28.7M |
| Revenue per Bed | $529K | $1.9M | +$1.4M | P27 | ~$3.4M |
| Revenue per Bed | $529K | $987K | +$458K | P42 | ~$1.1M |
| Expense per Bed | $533K | $1.1M | -$35K | P38 | ~$88K |
| Total Patient Days | 2,767 | 5,838 | +3,072 | P42 | — |
| Total Patient Days | 2,767 | 4,846 | +2,079 | P57 | — |
| Commercial Payer % | 13.2% | 63.2% | +50.0% | P3 | ~$6.6M |
| Commercial Payer % | 13.2% | 49.0% | +35.8% | P5 | ~$4.7M |
| Net-to-Gross Ratio | 54.3% | 88.7% | +34.5% | P22 | ~$4.6M |
Top Size-Matched Peers
12–50 beds, ranked by revenue. Click any peer for full profile.
| Hospital | State | Beds | Revenue | Margin | Medicare |
|---|---|---|---|---|---|
| MERCY HOSPITAL OF VALLEY CITY (Target) | ND | 25 | $13.2M | -0.8% | 69% |
| DANA-FARBER CANCER INSTITUTE | MA | 30 | $1.88B | -35.1% | 35% |
| FRED HUTCHINSON CANCER CENTER | WA | 20 | $1.17B | -50.0% | 22% |
| MERCY WALWORTH HOSPITAL | WI | 25 | $616.4M | 4.4% | 34% |
| MOUNTAIN VIEW HOSPITAL | ID | 43 | $382.5M | 8.7% | 5% |
| WISE HEALTH SYSTEM - PARKWAY | TX | 36 | $361.0M | -15.5% | 26% |
| CORYELL MEMORIAL HOSPITAL | TX | 25 | $305.9M | -1.5% | 28% |
| VALLEY VIEW HOSPITAL | CO | 31 | $285.3M | -3.1% | 34% |
| TAHOE FOREST HOSPITAL | CA | 25 | $264.3M | 13.0% | 34% |
| MASSACHUSETTS EYE AND EAR INFI | MA | 41 | $263.9M | -36.1% | 33% |
| CENTRAL PENINSULA GENERAL HOSP | AK | 49 | $255.1M | 5.5% | 49% |