Competitive Intelligence — HANSEN FAMILY HOSPITAL
CCN 161380 | IA | 17 beds | Nat'l margin P54 | 18 gaps to P75
🛡️ Public data only — no PHI permitted on this instance.
$32.1M
Net Revenue
-3.2%
Margin (P54)
17
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,937) | IA Size-Matched (n=85) | Direction |
|---|---|---|---|---|---|---|
| Net Patient Revenue | $32.1M | P35 | P42 | P62 | P52 | ▲ higher |
| Operating Margin | -3.2% | P54 | P74 | P60 | P72 | ▲ higher |
| Bed Count | 17 | P8 | P8 | P20 | P12 | ▶ neutral |
| Revenue per Bed | $1.9M | P74 | P78 | P72 | P74 | ▲ higher |
| Occupancy Rate | 15.1% | P9 | P20 | P19 | P26 | ▲ higher |
| Net-to-Gross Ratio | 53.0% | P78 | P58 | P59 | P41 | ▲ higher |
| Expense per Bed | $1.9M | P74 | P70 | P71 | P68 | ▼ lower |
| Medicare Day % | 74.5% | P96 | P93 | P90 | P91 | ▶ neutral |
| Medicaid Day % | 0.1% | P2 | P1 | P2 | P2 | ▶ neutral |
| Commercial Payer % | 25.4% | P7 | P8 | P15 | P12 | ▲ higher |
| Payer Diversity Index | 0.380 | P23 | P10 | P19 | P8 | ▲ higher |
| Total Patient Days | 938 | P7 | P11 | P16 | P15 | ▲ 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 | $32.1M | $45.1M | +$13.0M | P62 | ~$22.1M |
| Net Patient Revenue | $32.1M | $44.2M | +$12.1M | P52 | ~$20.5M |
| Expense per Bed | $1.9M | $2.1M | -$1.2M | P71 | ~$2.1M |
| Expense per Bed | $1.9M | $2.1M | -$935K | P68 | ~$1.6M |
| Revenue per Bed | $1.9M | $2.0M | +$134K | P72 | ~$228K |
| Revenue per Bed | $1.9M | $1.9M | +$18K | P74 | ~$30K |
| Total Patient Days | 938 | 4,206 | +3,268 | P16 | — |
| Total Patient Days | 938 | 2,674 | +1,736 | P15 | — |
| Commercial Payer % | 25.4% | 61.3% | +36.0% | P15 | ~$11.5M |
| Occupancy Rate | 15.1% | 50.1% | +35.0% | P19 | ~$11.2M |
Top Size-Matched Peers
10–34 beds, ranked by revenue. Click any peer for full profile.
| Hospital | State | Beds | Revenue | Margin | Medicare |
|---|---|---|---|---|---|
| HANSEN FAMILY HOSPITAL (Target) | IA | 17 | $32.1M | -3.2% | 75% |
| 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% |
| CORYELL MEMORIAL HOSPITAL | TX | 25 | $305.9M | -1.5% | 28% |
| VALLEY VIEW HOSPITAL | CO | 31 | $285.3M | -3.1% | 34% |
| WENATCHEE VALLEY HOSPITAL | WA | 11 | $277.5M | -4.9% | 47% |
| TAHOE FOREST HOSPITAL | CA | 25 | $264.3M | 13.0% | 34% |
| PORTERVILLE DEVELOPMENTAL CENT | CA | 17 | $193.6M | -6.0% | 14% |
| CUYUNA REGIONAL MEDICAL CENTER | MN | 25 | $180.8M | -4.0% | 30% |
| METHODIST HOSPITAL FOR SURGERY | TX | 32 | $178.4M | 22.8% | 17% |