Competitive Intelligence — IU HEALTH FRANKFORT HOSPITAL
CCN 151316 | IN | 12 beds | Nat'l margin P70 | 13 gaps to P75
🛡️ Public data only — no PHI permitted on this instance.
$29.3M
Net Revenue
3.0%
Margin (P70)
12
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) | IN State (n=170) | Size-Matched (n=866) | IN Size-Matched (n=25) | Direction |
|---|---|---|---|---|---|---|
| Net Patient Revenue | $29.3M | P33 | P34 | P69 | P54 | ▲ higher |
| Operating Margin | 3.0% | P70 | P59 | P76 | P79 | ▲ higher |
| Bed Count | 12 | P3 | P2 | P8 | P8 | ▶ neutral |
| Revenue per Bed | $2.4M | P85 | P84 | P82 | P79 | ▲ higher |
| Occupancy Rate | 35.1% | P29 | P32 | P63 | P60 | ▲ higher |
| Net-to-Gross Ratio | 39.8% | P62 | P75 | P27 | P46 | ▲ higher |
| Expense per Bed | $2.4M | P83 | P81 | P79 | P64 | ▼ lower |
| Medicare Day % | 42.7% | P71 | P77 | P41 | P76 | ▶ neutral |
| Medicaid Day % | 1.2% | P18 | P22 | P30 | P26 | ▶ neutral |
| Commercial Payer % | 56.0% | P41 | P26 | P68 | P28 | ▲ higher |
| Payer Diversity Index | 0.503 | P68 | P78 | P72 | P76 | ▲ higher |
| Total Patient Days | 1,538 | P12 | P8 | P47 | P16 | ▲ 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 | $29.3M | $40.1M | +$10.8M | P54 | ~$13.0M |
| Net Patient Revenue | $29.3M | $34.2M | +$4.9M | P69 | ~$5.9M |
| Expense per Bed | $2.4M | $2.1M | -$1.6M | P79 | ~$2.0M |
| Expense per Bed | $2.4M | $3.1M | -$1.0M | P64 | ~$1.2M |
| Total Patient Days | 1,538 | 3,066 | +1,528 | P16 | — |
| Total Patient Days | 1,538 | 2,906 | +1,368 | P47 | — |
| Net-to-Gross Ratio | 39.8% | 68.2% | +28.4% | P27 | ~$8.3M |
| Commercial Payer % | 56.0% | 80.6% | +24.6% | P28 | ~$7.2M |
| Net-to-Gross Ratio | 39.8% | 59.9% | +20.1% | P46 | ~$5.9M |
| Occupancy Rate | 35.1% | 49.0% | +13.9% | P60 | ~$4.1M |
Top Size-Matched Peers
10–24 beds, ranked by revenue. Click any peer for full profile.
| Hospital | State | Beds | Revenue | Margin | Medicare |
|---|---|---|---|---|---|
| IU HEALTH FRANKFORT HOSPITAL (Target) | IN | 12 | $29.3M | 3.0% | 43% |
| 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% |
| THE SURGICAL HOSPITAL AT SOUTH | OH | 24 | $166.6M | -3.1% | 25% |
| 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% |
| NORTH CENTRAL SURGICAL HOSPITA | TX | 24 | $143.6M | 32.0% | 47% |
| BAYLOR ORTHOPEDIC AND SPINE HO | TX | 24 | $133.8M | 39.8% | 46% |
| GREAT FALLS CLINIC MEDICAL CEN | MT | 20 | $132.1M | 21.0% | 44% |