Statistical Profile — EXCELSIOR SPRINGS HOSPITAL
CCN 261322 | CLAY, MO | 0 outlier flags
🛡️ Public data only — no PHI permitted on this instance.
25
Beds
$44.0M
Net Revenue
-5.8%
Op Margin
19.3%
Occupancy
0
Outlier Flags
Statistical Profile — All Variables
Each metric compared to national (n=6,123) and MO (n=138) peers. Z-score shows standard deviations from national mean.
| Metric | Hospital | Nat'l Median | MO Median | Z-Score | Nat'l %ile | State %ile |
|---|---|---|---|---|---|---|
| Beds | 25 | 63 | 60 | -0.59σ | P16 | P10 |
| Net Patient Revenue | $44.0M | $59.7M | $64.4M | -0.38σ | P43 | P40 |
| Operating Expenses | $46.6M | $62.7M | $68.5M | -0.37σ | P43 | P42 |
| Net Income | $-2.6M | $-2.1M | $-1.9M | +0.07σ | P47 | P46 |
| Gross Patient Revenue | $93.9M | $186.6M | $182.7M | -0.42σ | P38 | P37 |
| Total Patient Days | 1,759 | 12,073 | 12,943 | -0.58σ | P14 | P11 |
| Medicare Day % | 36.3% | 30.9% | 30.6% | +0.12σ | P61 | P64 |
| Medicaid Day % | 3.1% | 5.1% | 7.7% | -0.50σ | P36 | P14 |
| Operating Margin | -5.8% | -4.8% | -6.2% | +0.03σ | P47 | P51 |
| Revenue per Bed | $1.8M | $1.2M | $1.2M | +0.14σ | P71 | P75 |
| Occupancy Rate | 19.3% | 53.7% | 50.1% | -1.28σ | P13 | P10 ▼ |
| Commercial Payer % | 60.7% | 61.2% | 59.9% | +0.07σ | P49 | P51 |
| Net-to-Gross Ratio | 46.9% | 33.3% | 33.2% | +0.40σ | P71 | P75 |
| Expense per Bed | $1.9M | $1.2M | $1.2M | +0.12σ | P72 | P77 |
| Revenue per Patient Day | 25,020 | 7,054 | 7,649 | +0.02σ | P92 ▲ | P97 ▲ |
| Payer Diversity Index | 0.500 | 0.473 | 0.518 | +0.44σ | P65 | P43 |
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% | $44.0M | $-8.7M | +0.21σ |
| Operating Margin | 2.1% | -0.0580 | -0.0555 | -0.01σ |
| Occupancy Rate | 44.3% | 0.1928 | 0.4662 | -1.50σ |
| Revenue Per Bed | 2.6% | $1.8M | $1.6M | +0.11σ |
| Net To Gross Ratio | 22.4% | 0.4685 | 0.3844 | +0.49σ |