Statistical Profile — MERCY HOSPITAL IOWA CITY
CCN 160029 | JOHNSON, IA | 0 outlier flags
🛡️ Public data only — no PHI permitted on this instance.
211
Beds
$144.6M
Net Revenue
-28.1%
Op Margin
26.5%
Occupancy
0
Outlier Flags
Statistical Profile — All Variables
Each metric compared to national (n=6,123) and IA (n=124) peers. Z-score shows standard deviations from national mean.
| Metric | Hospital | Nat'l Median | IA Median | Z-Score | Nat'l %ile | State %ile |
|---|---|---|---|---|---|---|
| Beds | 211 | 63 | 25 | +0.43σ | P81 | P94 ▲ |
| Net Patient Revenue | $144.6M | $59.7M | $36.8M | -0.16σ | P67 | P87 |
| Operating Expenses | $185.2M | $62.7M | $38.8M | -0.09σ | P72 | P88 |
| Net Income | $-40.7M | $-2.1M | $-3.0M | -0.20σ | P12 | P5 ▼ |
| Gross Patient Revenue | $641.0M | $186.6M | $73.9M | -0.13σ | P69 | P90 ▲ |
| Total Patient Days | 20,445 | 12,073 | 2,364 | -0.22σ | P61 | P85 |
| Medicare Day % | 35.1% | 30.9% | 53.5% | +0.06σ | P59 | P18 |
| Medicaid Day % | 7.4% | 5.1% | 3.2% | -0.16σ | P63 | P74 |
| Operating Margin | -28.1% | -4.8% | -8.2% | -1.08σ | P13 | P3 ▼ |
| Revenue per Bed | 685,260 | $1.2M | $1.3M | -0.41σ | P31 | P13 |
| Occupancy Rate | 26.5% | 53.7% | 26.6% | -1.00σ | P21 | P49 |
| Commercial Payer % | 57.5% | 61.2% | 41.3% | -0.08σ | P43 | P81 |
| Net-to-Gross Ratio | 22.6% | 33.3% | 50.8% | -0.76σ | P24 | P5 ▼ |
| Expense per Bed | 877,932 | $1.2M | $1.4M | -0.29σ | P36 | P18 |
| Revenue per Patient Day | 7,072 | 7,054 | 16,230 | -0.05σ | P50 | P16 |
| Payer Diversity Index | 0.541 | 0.473 | 0.488 | +0.73σ | P82 | P81 |
Multi-Variable Regression Residuals
For each key metric, the national regression model predicts a value. The residual shows how much this hospital over/under-performs after controlling for all other variables.
| Target | Model R² | Actual | Predicted | Residual |
|---|---|---|---|---|
| Net Patient Revenue | 74.0% | $144.6M | $95.5M | +0.19σ |
| Operating Margin | 2.1% | -0.2812 | -0.0696 | -1.11σ |
| Occupancy Rate | 44.3% | 0.2655 | 0.2705 | -0.03σ |
| Revenue Per Bed | 2.6% | 685,260 | 905,781 | -0.12σ |
| Net To Gross Ratio | 22.4% | 0.2256 | 0.2723 | -0.27σ |