Competitive Intelligence — COLUMBIA MEMORIAL HOSPITAL
CCN 330094 | NY | 192 beds | Nat'l margin P22 | 18 gaps to P75
🛡️ Public data only — no PHI permitted on this instance.
$143.5M
Net Revenue
-18.8%
Margin (P22)
192
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) | NY State (n=195) | Size-Matched (n=1,982) | NY Size-Matched (n=96) | Direction |
|---|---|---|---|---|---|---|
| Net Patient Revenue | $143.5M | P67 | P42 | P32 | P26 | ▲ higher |
| Operating Margin | -18.8% | P22 | P46 | P18 | P45 | ▲ higher |
| Bed Count | 192 | P78 | P54 | P57 | P48 | ▶ neutral |
| Revenue per Bed | $748K | P34 | P12 | P26 | P15 | ▲ higher |
| Occupancy Rate | 36.0% | P30 | P11 | P9 | P5 | ▲ higher |
| Net-to-Gross Ratio | 27.2% | P35 | P29 | P53 | P33 | ▲ higher |
| Expense per Bed | $888K | P36 | P20 | P31 | P27 | ▼ lower |
| Medicare Day % | 35.9% | P61 | P73 | P84 | P74 | ▶ neutral |
| Medicaid Day % | 1.4% | P19 | P11 | P13 | P7 | ▶ neutral |
| Commercial Payer % | 62.7% | P53 | P37 | P35 | P36 | ▲ higher |
| Payer Diversity Index | 0.478 | P52 | P56 | P56 | P53 | ▲ higher |
| Total Patient Days | 25,211 | P67 | P36 | P24 | P14 | ▲ 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 | $143.5M | $431.8M | +$288.3M | P26 | ~$5.54B |
| Net Patient Revenue | $143.5M | $384.1M | +$240.6M | P32 | ~$4.62B |
| Revenue per Bed | $748K | $2.1M | +$1.4M | P15 | ~$26.5M |
| Revenue per Bed | $748K | $1.8M | +$1.1M | P26 | ~$20.2M |
| Expense per Bed | $888K | $1.9M | -$175K | P31 | ~$3.4M |
| Expense per Bed | $888K | $2.3M | -$74K | P27 | ~$1.4M |
| Total Patient Days | 25,211 | 69,056 | +43,846 | P14 | — |
| Total Patient Days | 25,211 | 60,441 | +35,230 | P24 | — |
| Occupancy Rate | 36.0% | 82.9% | +47.0% | P5 | ~$67.4M |
| Occupancy Rate | 36.0% | 76.2% | +40.2% | P9 | ~$57.8M |
Top Size-Matched Peers
96–384 beds, ranked by revenue. Click any peer for full profile.
| Hospital | State | Beds | Revenue | Margin | Medicare |
|---|---|---|---|---|---|
| COLUMBIA MEMORIAL HOSPITAL (Target) | NY | 192 | $143.5M | -18.8% | 36% |
| 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% |
| BANNER ESTRELLA MEDICAL CENTER | AZ | 317 | $1.84B | 79.2% | 13% |
| CITY OF HOPE NATIONAL MEDICAL | CA | 217 | $1.83B | -10.7% | 32% |
| SEATTLE CHILDRENS HOSPITAL | WA | 350 | $1.70B | 5.7% | 1% |
| CHILDRENS MEDICAL CENTER OF DA | TX | 377 | $1.56B | 10.3% | 0% |
| HARBOR-UCLA MEDICAL CENTER | CA | 369 | $1.54B | -6.4% | 10% |