An interactive executive dashboard from the book
Fiscal Fitness
Strengthening Hospital Financial Performance
Diagnose financial health, size every improvement lever, stress-test the plan, and build the accountability that keeps a hospital solvent and its mission funded.
- 16 connected tools
- 40+ live formulas
- Monte Carlo and SPC
- Role lens: manager to CEO
- Index A and B mapped
Fiscal Fitness · Executive dashboard
Strengthening hospital financial performance, one decision at a time
Sixteen connected tools for managers, directors, vice presidents, chief operating officers, chief financial officers and chief executives.
A working model of the book, built for the people who carry the budget
Fiscal Fitness argues that financial health is the foundation that lets a hospital pay its people, fund technology, and keep its mission intact through rate cuts, labor inflation and policy change. This dashboard turns the book’s metrics, formulas, case studies and two indexes into calculators that respond to your own figures.
Every tab opens with an illustrative 300-bed community hospital so that each tool shows a complete, worked answer. Replace the figures with your own and every tab, chart and formula output updates. Inputs carried between tabs (revenue, expenses, volume) are entered once on the tab.
How to read the labels: From the book content, formulas and case figures taken from the book; Published benchmark an external benchmark with its source; Illustrative input a starting value to replace with your own; Dashboard construct a scoring rule or composite built for this dashboard and not validated as a predictive instrument.
The premise
Just like a building needs a strong foundation, healthcare organizations need solid financial health.
Kelly Emrick, Fiscal Fitness, Introduction
Choose your seat at the table
The same numbers mean different things to a department manager and to a board chair. Pick a role to see the questions the book asks of that role, the measures to watch, and the tabs to open first. Tabs for your role are marked with a teal dot.
Chief Financial Officer
Horizon: monthly close, annual budget, five-year capital and financing plan.
The CFO translates operations into liquidity, coverage and capital capacity. Chapters 1, 2, 5, 7 and 17 frame the questions that rating agencies, lenders and the board will ask.
Questions to answer
- How many days could we operate on cash, and how does that compare with peers?
- What is the revenue cycle leaking, and how much cash is trapped in AR?
- How exposed are we to a payer shift or a rate cut?
- Which capital requests should we fund within the budget?
- How large a reserve does a bad year require?
Your starting path
Measures to watch
- Operating margin and days cash on hand
- Debt service coverage ratio
- AR days and denial rate
- Payer concentration
- Probability of an operating loss
Fiscal Fitness Index
72.0
Fit; weakest: Expense
Operating margin
1.57%
Fitch 2025 median 1.5%
Days cash on hand
201.8
Fitch 2025 median 212 days
Accounts receivable days
47.8
Target 40 days
Modeled margin opportunity
$36,716,250
Margin 1.57% to 9.47% across four tabs
Chapter map
Every chapter and both indexes are connected to the tab that puts them to work.
Chapter 1 · Understanding financial health
The Fitness Scorecard
Eighteen metrics across revenue, expense, profitability, liquidity, solvency and efficiency, calculated from your statements with every formula shown.
Illustrative input Starting values describe an illustrative 300-bed community hospital, not a real organization. Commercial payer share is set on the Payer Mix tab.
Fiscal Fitness Index
72.0 · Fit
Weakest domain: Expense (59). Start with Cost Containment, Workforce.
Dashboard construct Each metric scores 0 at its floor and 100 at its target; domains average their metrics and the index averages the six domains. Bands are equal quarters (Deconditioned, Building, Fit, Peak) for discussion, not validated cutoffs.
Six-domain fitness profile
The book’s Chapter 1 metric families, scored 0 to 100
Domain scores
Weakest domain highlighted in crimson
Chapter 1 metric scorecard
Targets and floors are editable. Where a published median exists it is shown beside your value; other targets are starting points to replace with your peer group or bond covenants.
| Domain | Metric | Formula | Your value | Reference | Target | Floor | Score | Status |
|---|---|---|---|---|---|---|---|---|
| Revenue | Revenue per adjusted discharge | NPR ÷ adjusted discharges | $17,500 | Peer target (set your own) | 71 of 100 | Watch | ||
| Revenue | Revenue per patient day | NPR ÷ patient days | $5,833 | Peer target (set your own) | 69 of 100 | Watch | ||
| Revenue | Commercial share of patient revenue | Commercial revenue ÷ NPR (Payer Mix tab) | 47.5% | Commercial 47.5% of patient revenue at current mix | 84 of 100 | Strong | ||
| Expense | Operating expense per adjusted discharge | Operating expense ÷ adjusted discharges | $18,250 | Peer target (set your own) | 70 of 100 | Watch | ||
| Expense | Labor cost as % of operating expense | Salaries, wages, benefits ÷ operating expense | 53.9% | Fitch 2025 median: personnel 52.6% of operating revenue (yours: 53.0%) | 51 of 100 | Watch | ||
| Expense | Supply cost as % of operating expense | Supplies ÷ operating expense | 17.8% | Internal trend | 55 of 100 | Watch | ||
| Profitability | Operating margin | (Operating revenue − operating expense) ÷ operating revenue | 1.57% | Fitch 2025 median 1.5% | 71 of 100 | Watch | ||
| Profitability | Net margin | Net income ÷ total revenue | 3.52% | Includes non-operating income of $9.0M | 88 of 100 | Strong | ||
| Profitability | Return on assets | Net income ÷ total assets | 2.22% | Higher indicates efficient asset use (Ch. 1) | 56 of 100 | Watch | ||
| Liquidity | Current ratio | Current assets ÷ current liabilities | 1.76x | Above 1.0 indicates sufficient liquidity (Ch. 1) | 76 of 100 | Strong | ||
| Liquidity | Days cash on hand | Unrestricted cash ÷ ((operating expense − depreciation) ÷ 365) | 201.8 days | Fitch 2025 median 212 days | 93 of 100 | Strong | ||
| Liquidity | Accounts receivable days | Net AR ÷ (NPR ÷ 365) | 47.8 days | Shorter is better (Ch. 1) | 69 of 100 | Watch | ||
| Solvency | Debt to equity | Total debt ÷ net assets | 0.42 | Fitch 2025 median debt to capitalization 28.9% (yours: 29.6%) | 96 of 100 | Strong | ||
| Solvency | Debt service coverage ratio | (Operating income + depreciation + interest) ÷ debt service | 2.50x | Above 1.0 covers debt (Ch. 1); floor set at a common 1.25x covenant | 100 of 100 | Strong | ||
| Solvency | Fixed asset turnover | Total revenue ÷ net fixed assets | 1.46x | Higher is more efficient (Ch. 1) | 46 of 100 | Watch | ||
| Efficiency | Average length of stay | Patient days ÷ discharges | 4.80 days | Internal trend and case mix | 70 of 100 | Watch | ||
| Efficiency | Bed occupancy rate | Patient days ÷ (beds × 365) | 65.8% | High occupancy indicates effective use of capacity (Ch. 1) | 54 of 100 | Watch | ||
| Efficiency | Readmission rate | Readmissions ÷ discharges | 13.0% | Lower avoids penalties (Ch. 1) | 75 of 100 | Strong |
Published benchmark Fitch Ratings 2025 not-for-profit hospital medians (222 rated organizations, audited 2025 data) as reported by HFMA: operating margin 1.5%, days cash on hand 212, personnel costs 52.6% of operating revenue, debt to capitalization 28.9%, cash to debt 188.0%.
Fitness plan: where the margin could come from
Operating income bridge
Current operating income plus the modeled opportunity from each tab, in millions of dollars
Read the bridge carefully
Each step comes from the matching tab and updates as you change it. Revenue cycle, cost, workforce and quality levers are modeled separately so the same dollar is not counted twice: denials sit only on the Revenue Cycle tab, overtime and agency only on Workforce, readmission avoidance only on Quality.
Operating margin today
1.57%
Operating income $7,000,000
Margin if every lever lands
9.47%
+$36,716,250 a year if every lever lands
Opportunity is not certainty. The Forecast Lab shows how much of it a bad year can erase.
Chapters 2 and 12 · Revenue cycle and patient billing
Revenue Cycle: stop the leak before you cut the staff
Denials, write-offs and slow collections drain margin quietly. Model what the book’s 500-bed case achieved, applied to your own claim volume.
Denied dollars per year
$63,000,000
36,000 claims denied at 15.0%; $21,000,000 at target
Permanent write-off avoided
$16,800,000
$25,200,000 lost today, $8,400,000 at target
Rework cost avoided
$2,400,000
24,000 fewer denied claims to rework
Annual margin benefit
$19,200,000
Recurring each year
One-time cash release from AR
$6,671,233
AR days 47.8 to 42.0 at $1,150,685 per day
Operating margin after
5.67%
From 1.57% today
Denied dollars
Claims × denial rate × average expected payment
Today: 240,000 × 15.0% × $1,750 = $63,000,000. At target: $21,000,000.
Revenue permanently lost
Denied dollars × (1 − share recovered)
$63,000,000 × (1 − 60%) = $25,200,000 written off today; $8,400,000 at target.
AR days and cash release
AR ÷ (NPR ÷ 365); release = (AR days − target) × NPR ÷ 365
AR days = 47.80; release = (47.80 − 42.00) × $1,150,685 = $6,671,233.
Before and after the denial program
Annual dollars, current rate against target rate
What denials really cost today
Denied dollars, less what appeals recover, plus the staff time to rework them
The seven-step revenue cycle
Follows the book’s RCM figure; the crimson marks are where the Chapter 2 case found its denials
Where denials start
| Step | Book-identified failure | Book countermeasure |
|---|---|---|
| 1. Pre-authorization | Lack of pre-authorization | Standardized workflows, real-time verification |
| 2. Eligibility and benefits | Insurance verification failures | Real-time insurance verification (Chapter 12) |
| 3. Claims submission | Coding errors, incomplete documentation | Automated coding, CDI programs, coder training |
| 4. Payment posting | Manual data entry errors | Automation and RPA |
| 5. Denial management | Repeat denials, slow appeals | Root cause analysis, denial tools (DMAIC cut denials 30%, Chapter 13) |
| 6. AR follow-up | Rising accounts receivable | Work queues, payer follow-up |
| 7. Reporting | Data silos | Integrated reporting and dashboards |
Chapters 3 and 11 · Cost containment and supply chain
Cost Containment without cutting care
Size the non-labor levers the book recommends, using its case-study percentages as starting points. Labor levers live on the Workforce tab.
Where the operating dollar goes
From the Scorecard inputs
Annual non-labor savings
$6,370,000
Recurring annual savings
Operating margin after
3.00%
From 1.57%
Expense per adjusted discharge after
$17,985
From $18,250
Savings as % of operating expense
1.45%
Savings by lever
Annual dollars
Chapter 3 guardrail
Cost containment that lowers quality is not savings; it is deferred cost.
The book pairs every cost lever with care coordination, standardized pathways and preventive care, and measures readmissions, length of stay and cost per patient together.
Chapter 4 · Investment in technology and infrastructure
Technology ROI: four tests every investment must pass
The book’s Chapter 4 formula table, run live: cost-benefit analysis, ROI ratio, NPV, IRR, payback and break-even.
Illustrative input Defaults describe a revenue cycle automation platform. Replace with your vendor quote and benefit case.
Net benefit (CBA)
$1,750,000
$5,500,000 benefits − $3,750,000 costs
ROI ratio
46.67%
Undiscounted, over 5 years
Net present value
$985,168
At 7.00% required return
Internal rate of return
20.76%
Exceeds the 7.00% hurdle
Payback period
2.94 years
Discounted payback
3.42 years
The investment passes 4 of 4 tests (positive net benefit, positive NPV, IRR above the hurdle, payback within useful life). Chapter 4 adds clinical, operational and patient-satisfaction returns that these financial tests do not capture.
Cost-benefit analysis
NB = Total benefits − Total costs
$5,500,000 − $3,750,000 = $1,750,000
ROI ratio
ROI = (Net benefit ÷ Total costs) × 100
($1,750,000 ÷ $3,750,000) × 100 = 46.67%
Net present value
NPV = Σ Rt ÷ (1 + r)t, t = 0 to n
NPV at 7.00% = $985,168
Internal rate of return
0 = Σ Rt ÷ (1 + IRR)t
IRR = 20.76% (NPV at that rate = $0)
Cumulative cash flow
Undiscounted and discounted; payback is where each line crosses zero
NPV profile
NPV across discount rates; IRR is where the curve crosses zero
| Year | Benefits | Costs | Net cash flow | Discount factor | Present value | Cumulative | Cumulative PV |
|---|---|---|---|---|---|---|---|
| 0 | $0 | $2,500,000 | −$2,500,000 | 1.0000 | −$2,500,000 | −$2,500,000 | −$2,500,000 |
| 1 | $1,100,000 | $250,000 | $850,000 | 0.9346 | $794,393 | −$1,650,000 | −$1,705,607 |
| 2 | $1,100,000 | $250,000 | $850,000 | 0.8734 | $742,423 | −$800,000 | −$963,185 |
| 3 | $1,100,000 | $250,000 | $850,000 | 0.8163 | $693,853 | $50,000 | −$269,331 |
| 4 | $1,100,000 | $250,000 | $850,000 | 0.7629 | $648,461 | $900,000 | $379,130 |
| 5 | $1,100,000 | $250,000 | $850,000 | 0.7130 | $606,038 | $1,750,000 | $985,168 |
| Total | $5,500,000 | $3,750,000 | $1,750,000 | $985,168 |
Break-even analysis
Break-even point (book formula)
BEP = Fixed costs ÷ (Price per unit − Variable cost per unit)
$900,000 ÷ ($450 − $120) = 2,727.3 units
Break-even volume
2,727.3 units
Contribution $330 per unit
Margin of safety
22.1%
Volume can fall this far before losses
Profit at expected volume
$255,000
3,500 units × $330 − $900,000
Cost-volume-profit chart
Revenue and total cost lines cross at break-even; the dot marks expected volume
View the published formula table (Chapter 4)
View the published ROI equation (Chapter 4)
Chapters 16 and 17 · Capital budgeting and funding
Capital Budgeting: rank, ration, and defend the list
The four Chapter 17 methods (NPV, IRR, profitability index and payback) applied to competing requests under a real budget ceiling.
Capital requests
| Project | Cost ($) | Annual net cash flow ($) | Life (yrs) | Strategic fit (1 to 5) |
|---|---|---|---|---|
Illustrative input Five sample requests. Cash flows are level annual amounts; salvage value is excluded.
Total requested
$14,300,000
Against a budget of $9,000,000
Requests above budget
$5,300,000
Something must wait
| Project | NPV | IRR | Profitability index | Payback | Rank by NPV | Rank by IRR | Rank by PI | Ranked by PI | Best NPV set |
|---|---|---|---|---|---|---|---|---|---|
| MRI replacement | $860,969 | 15.47% | 1.269 | 4.10 years | 3 | 3 | 4 | Funded | Deferred |
| Revenue cycle automation | $893,804 | 20.76% | 1.358 | 2.94 years | 2 | 1 | 2 | Funded | Funded |
| Ambulatory surgery suite | $1,832,626 | 15.03% | 1.282 | 4.48 years | 1 | 4 | 3 | Deferred | Funded |
| Energy retrofit (LED and HVAC) | $544,621 | 17.26% | 1.454 | 4.62 years | 4 | 2 | 1 | Funded | Deferred |
| Telehealth platform | $18,323 | 8.77% | 1.020 | 3.91 years | 5 | 5 | 5 | Funded | Deferred |
Return against efficiency
IRR on the horizontal axis, profitability index on the vertical; bubble area is cost; filled bubbles are funded in the best-NPV set
Two ways to spend the same budget
NPV funded, ranked by PI
$2,317,717
$7,800,000 of capital committed
NPV funded, best combination
$2,726,430
$9,000,000 of capital committed
Ranking by profitability index leaves $408,713 of NPV on the table because large projects do not fit neatly into the remaining budget. Under hard rationing, test combinations, not just rankings.
Profitability index
PI = PV of future cash flows ÷ Initial investment
Energy retrofit (LED and HVAC): PI = $1,744,621 ÷ $1,200,000 = 1.454
Chapters 5 and 18 · Planning, forecasting and analytics
Forecast Lab: plan for the year you get, not the year you want
Regression trend, the book’s scenario grid, a sensitivity tornado and a seeded Monte Carlo simulation that sizes the reserve a bad year requires.
1. Trend forecast with regression
Illustrative input Twelve quarters. Paste your own history (at least 4 values).
Trend per quarter
$1.116M
About 4.0% a year at the latest level
R squared
0.971
97.1% of the variation follows the trend
Standard error of estimate
$0.734M
Typical miss of the trend line, n = 12
Next four quarters, total
$454.0M
t critical 2.228 with 10 df
Linear trend with 95% prediction interval
Ordinary least squares on quarter number; the band widens as the forecast moves away from the data
| Quarter ahead | Point forecast ($M) | 95% lower | 95% upper |
|---|---|---|---|
| +1 (quarter 13) | 111.83 | 109.91 | 113.75 |
| +2 (quarter 14) | 112.94 | 110.96 | 114.93 |
| +3 (quarter 15) | 114.06 | 112.00 | 116.12 |
| +4 (quarter 16) | 115.17 | 113.03 | 117.32 |
Regression and prediction interval
ŷ = a + bt; PI = ŷ ± t0.975, n−2 · s · √(1 + 1/n + (t₀ − t̄)² / Σ(t − t̄)²)
ŷ = 97.323 + 1.116t; quarter 16: 115.17 (95% PI 113.03 to 117.32)
2. Scenario analysis: the book’s two-uncertainty grid
Next-year operating margin in each scenario
Uncertainty 1 is patient volume; uncertainty 2 is reimbursement rate. Base year is the Scorecard.
| Volume pessimistic (−3.0%) | Volume optimistic (4.0%) | |
|---|---|---|
| Rate optimistic (4.0%) | Scenario 1−0.45%Fewer patients, better rates Operating income −$2.0M | Scenario 23.63%Best case Operating income $17.4M |
| Rate pessimistic (0.0%) | Scenario 3−4.24%Worst case Operating income −$18.3M | Scenario 4−0.02%More patients, weaker rates Operating income −$0.1M |
Base year operating margin 1.57%. Every scenario carries 4.00% cost inflation; variable costs also move with volume.
View the published scenario grid (Chapter 5)
3. Monte Carlo simulation and contingency reserve
A fixed seed makes every run reproducible; change it to draw a new sample.
Probability of an operating loss
33.0%
Share of 5,000 simulated years with an operating loss
Median operating margin
1.05%
Plan at the means: 1.04%
1-in-10 bad year (P10)
−2.06%
P90 upside: 3.89%
Contingency reserve to hold
$14,056,694
About 12.3 days of cash
Distribution of next-year operating margin
Simulated outcomes; crimson bars are losses; dashed lines mark P10, P50 and P90
Sensitivity tornado
Operating margin when each driver moves one standard deviation, others held at their means
From the book to the model
Chapter 5 names three techniques: sensitivity analysis (vary one variable at a time), scenario analysis (baseline, optimistic, pessimistic and wildcard), and Monte Carlo simulation (sample from distributions and interpret the probabilities). All three run here on the same margin model, so their answers can be compared directly.
Contingency reserve (dashboard rule)
Reserve = Planned operating income − P10 operating income
$4,811,680 − −$9,245,014 = $14,056,694
Dashboard construct Holding a reserve equal to the gap between plan and a 1-in-10 year follows the management-reserve idea in the book’s contingency figure; the P10 threshold is a choice, not a rule from the book.
Chapters 5 and 13 · Variance analysis and process control
Control Room: separate the signal from the noise
Variance analysis tells you whether a miss came from volume or from spending. Statistical process control tells you whether a change is real.
1. Flexible budget variance analysis
| Expense line | Fixed ($) | Variable per unit ($) | Actual ($) |
|---|---|---|---|
| Salaries and benefits | |||
| Supplies | |||
| Purchased services | |||
| Utilities and other |
Illustrative input One month for an illustrative hospital.
| Line | Static budget | Flexible budget | Actual | Volume variance | Spending variance |
|---|---|---|---|---|---|
| Net patient revenue | $35,000,000 | $33,600,000 | $33,100,000 | −$1,400,000 U | −$500,000 U |
| Salaries and benefits | $19,600,000 | $19,296,000 | $19,950,000 | +$304,000 F | −$654,000 U |
| Supplies | $6,500,000 | $6,240,000 | $6,420,000 | +$260,000 F | −$180,000 U |
| Purchased services | $3,900,000 | $3,848,000 | $3,950,000 | +$52,000 F | −$102,000 U |
| Utilities and other | $2,500,000 | $2,476,000 | $2,560,000 | +$24,000 F | −$84,000 U |
| Operating income | $2,500,000 | $1,740,000 | $220,000 | −$760,000 U | −$1,520,000 U |
Spending variance by line
Actual against the flexible budget; teal is favorable, crimson unfavorable
Flexible budget
Flex = Fixed + Variable rate × Actual volume
Salaries and benefits: $12,000,000 + $3,800 × 1,920 = $19,296,000
Volume variance
Flexible budget − Static budget
Operating income effect of volume: −$760,000 U (1,920 actual against 2,000 budgeted units)
Spending variance
Actual − Flexible budget
Operating income effect of spending and price: −$1,520,000 U. Most of the miss is spending, not volume.
2. Statistical process control: is the denial rate really improving?
Illustrative input Eighteen months; a denial program starts in month 13.
Baseline denial rate (center line)
9.62%
From the first 12 months
Control limits at average volume
9.00% to 10.25%
Three sigma
Special-cause signals
6
Real change, not noise
Recent six-month rate
7.26%
Last 6 months pooled
p-chart of monthly denial rate
Limits vary with each month’s claim volume; crimson points are special-cause signals
Signals: Month 13 (7.40%, outside the limits); Month 14 (7.28%, outside the limits); Month 15 (7.26%, outside the limits); Month 16 (7.17%, outside the limits); Month 17 (7.23%, outside the limits); Month 18 (7.23%, outside the limits). A point beyond the limits is a special cause worth explaining; when the cause is your own intervention, reset the limits on the new baseline.
p-chart control limits (Chapter 13, statistical process control)
UCL, LCL = p̄ ± 3 √(p̄(1 − p̄) / ni); signal when a point falls outside a limit or 8 consecutive points sit on one side of p̄
p̄ = 0.09622; at the average month the limits are 0.08997 to 0.10246.
Chapters 6, 7 and 9 · Revenue diversification, payers and policy
Payer Mix: the margin is decided before the patient arrives
Model margin by payer, stress-test a shift toward Medicaid or a Medicare cut, and see what a commercial contract would have to recover.
Payer mix and payment
| Payer | Share of volume (%) | Payment per adj. discharge ($) | Margin each |
|---|---|---|---|
| Commercial | +$7,750 | ||
| Medicare | −$2,750 | ||
| Medicaid | −$6,750 | ||
| Self-pay and uninsured | −$15,750 | ||
| Other government | −$4,250 |
Cost per adjusted discharge comes from the Scorecard: $18,250. Illustrative input Payments are illustrative and reproduce the Scorecard’s net patient revenue at the default mix.
Blended net revenue per adjusted discharge
$16,997
Current mix: $17,500. Payer table implies NPR $420.0M against the Scorecard $420.0M
Patient care margin
−$30,076,800
−$1,253 per adjusted discharge before other operating revenue
Operating margin
−1.17%
Current mix: 1.57%
Commercial share of patient revenue
44.4%
Current mix: 47.5%
Payer concentration (HHI)
3,732
Equivalent to 2.68 equal-sized payers
Commercial increase needed to offset the stress
6.67%
Recovers $12,076,800 lost to the shift and public rate changes
Margin per adjusted discharge by payer
Payment minus fully loaded cost; most hospitals lose money on every public payer
How fast a payer shift erodes the margin
Operating margin as commercial volume moves to Medicaid, with current stress settings
Revenue mix, current against stressed
Share of net patient revenue by payer
Blended revenue per adjusted discharge
Σ (payer share × payer payment)
Stressed: $16,997 per adjusted discharge × 24,000 = $407,923,200
Herfindahl-Hirschman Index of revenue
HHI = Σ (revenue share × 100)²; effective payers = 10,000 ÷ HHI
HHI 3,732 (current 3,907); effective payers 2.68
Commercial rate needed to break even on the stress
Lost margin ÷ commercial revenue after the shift
$12,076,800 ÷ commercial revenue after the shift = 6.67%
Dashboard construct The HHI is the standard concentration index, applied here to the book’s Chapter 6 argument that diversified revenue reduces financial risk. Higher values mean revenue depends on fewer payers.
Chapters 13 and 19 · Case mix and patient volume
Volume & Case Mix: acuity, beds and the visits that never happen
Calculate the case mix index exactly as the book defines it, then size the capacity and no-show levers from Chapter 19.
1. Case mix index
| Service line | Cases | Average relative weight | Weighted cases |
|---|---|---|---|
| 3,885.0 | |||
| 3,280.0 | |||
| 6,510.0 | |||
| 3,230.0 | |||
| 1,170.0 | |||
| 1,330.0 |
Illustrative input Relative weights are illustrative averages by service line; use your CMS MS-DRG weights.
Case mix index
1.2937
19,405.0 weights ÷ 15,000 patients
Average DRG payment per case
$8,797
$6,800 × CMI
Revenue from the CMI change
$1,244,400
+0.020 CMI on 61% of cases
Case mix index (book figure, Chapter 13)
CMI = Total of CMS relative weights ÷ Total number of patients served
19,405.0 ÷ 15,000 = 1.2937
Relative weight by service line
The dashed line is the hospital CMI
2. Bed capacity and length of stay
Current occupancy
65.8%
72,000 patient days in 300 beds
Discharges possible at target occupancy
19,391
At 85% occupancy and 4.80-day stays; today 15,000
Bed days freed by shorter stays
4,500
15,000 discharges × 0.30 days
Added discharge capacity
1,000
At the shorter 4.50-day stay
Contribution if the beds are filled
$4,000,000
Beds are not the constraint at 66% occupancy; shorter stays mainly lower cost
3. No-shows: the volume you already scheduled
Revenue lost to no-shows
$4,536,000
21,600 missed visits
Revenue recoverable
$1,360,800
30% of the loss
Capacity and volume opportunities
Annual dollars from the three volume levers on this tab
Chapter 14 · Workforce management and financial stability
Workforce: the largest line, managed with the most care
Overtime, agency premium and turnover are where labor dollars leak without adding care. Size each one against your own spend.
Illustrative input Starting values; labor cost and adjusted discharges come from the Scorecard.
Average labor cost per FTE
$118,000
Salaries, wages and benefits ÷ 2,000 FTEs
Labor cost per adjusted discharge
$9,833
Labor as % of operating revenue
53.0%
0.4% above the Fitch median
Overtime savings
$2,360,000
Agency conversion savings
$1,200,000
Turnover savings
$2,430,000
Turnover costs $16,200,000 a year today
Total workforce opportunity
$5,990,000
2.54% of labor cost
Published benchmark Fitch 2025 median personnel costs: 52.6% of operating revenue.
Workforce savings by lever
Annual dollars
The cost of turnover
Annual replacement cost across turnover rates; the dot is your organization
Agency conversion savings
Agency spend × share converted × premium ÷ (1 + premium)
$9,000,000 × 40% × 50% ÷ (1 + 50%) = $1,200,000
Turnover cost
FTEs × turnover rate × replacement cost per departure
2,000 × 18.0% × $45,000 = $16,200,000
Labor cost per adjusted discharge
Salaries, wages and benefits ÷ Adjusted discharges
$236,000,000 ÷ 24,000 = $9,833
The book’s workforce strategies
- Data-driven staffing and scheduling with predictive analytics
- Flexible models: part-time, per diem and float pools
- Cross-training and leadership development
- Retention through work-life balance, wellness and recognition
- Workforce management software for scheduling, time and attendance, and compliance
Labor often exceeds half of total operating expense (Chapter 14), which is why the smallest percentage change here moves the margin more than any supply contract.
Chapter 15 · Financial impacts on patient outcomes
Quality = Finance: preventing harm is a margin strategy
Infections, surgical complications and readmissions carry costs that are seldom fully reimbursed. Price the dividend the book’s case studies achieved.
HAI dividend
$900,000
36.0 infections avoided
SSI dividend
$600,000
24.0 SSIs avoided
Readmission dividend
$3,656,250
487.5 readmissions avoided
Total quality dividend
$5,156,250
Readmission penalty exposure
$600,000
VBP withhold at stake
$2,400,000
Earned back only through quality scores
The quality dividend
Annual dollars kept by preventing harm, and Medicare dollars at stake
Chapter 15
Better patient outcomes can lead to better financial performance.
Fewer complications shorten stays, avoid unreimbursed costs, protect value-based payments and lower penalties. The dividend is real only when the harm is actually prevented.
Infection dividend
Infections × reduction × cost per avoided infection
120 × 30% × $25,000 = $900,000; SSIs $600,000
Readmission dividend
Readmissions × reduction × cost per readmission × share kept
1,950 × 25% × $15,000 × 50% = $3,656,250
Readmissions come from the Scorecard (1,950 a year, 13.0% of discharges). Penalty and withhold percentages are inputs; check the current CMS program year for your hospital’s actual adjustment.
Chapters 8 and 10 · Regulatory compliance and risk management
Risk & Compliance: put a price on what could go wrong
Score the book’s top 10 risk factors, convert them into expected annual loss, and size the penalty exposure that compliance programs exist to prevent.
Chapter 10: the top 10 risk factors (2024)
| Risk | Likelihood (1 to 5) | Impact (1 to 5) | Financial severity if it occurs ($) | Score | Expected annual loss |
|---|---|---|---|---|---|
| 1. Payment reductions | 20 | $4,000,000 | |||
| 2. Patient safety and medical errors | 12 | $900,000 | |||
| 3. Regulatory compliance | 12 | $750,000 | |||
| 4. Cybersecurity threats | 20 | $5,000,000 | |||
| 5. Workforce shortages and turnover | 20 | $4,500,000 | |||
| 6. Operational inefficiencies | 12 | $2,000,000 | |||
| 7. Emergency preparedness | 10 | $1,050,000 | |||
| 8. Supply chain disruptions | 9 | $600,000 | |||
| 9. Legal and malpractice risks | 12 | $1,050,000 | |||
| 10. Patient data management | 9 | $450,000 |
Illustrative input Ratings and severities are starting points for a leadership discussion. Dashboard construct Likelihood maps to annual probability: 1 = 5%, 2 = 15%, 3 = 30%, 4 = 50%, 5 = 75%.
Risk heat map
Likelihood across, impact up; numbers are the Chapter 10 risks
Total expected annual loss
$20,300,000
Sum of probability × severity
Risks in the red zone (score 15+)
3
Likelihood × impact of 15 or more
Largest expected loss
$5,000,000
Cybersecurity threats
Expected annual loss by risk
Probability from likelihood × financial severity, ranked
Compliance penalty exposure (Chapter 8)
HIPAA civil penalty
$150,000
3 × $50,000
Stark or AKS penalties
$100,000
Total exposure
$250,000
Before legal costs, repayment and exclusion risk
From the book The book cites HIPAA penalties of $100 to $50,000 per violation with a $1.5 million annual cap for violations of an identical provision, and Stark and Anti-Kickback fines up to $100,000 per violation plus possible exclusion from Medicare and Medicaid. HHS adjusts these civil penalty amounts for inflation each year; confirm the current figures with counsel.
Index A and Index B
Pressures to Levers: match the remedy to the strain
Rate the twenty current financial pressures from Index B and the dashboard ranks the twenty improvement levers from Index A that answer them.
Index B: how hard is each pressure hitting you?
Revenue challenges
Cost pressures
Operational inefficiencies
Market and economic factors
External pressures
Technology and innovation
Human resources
Your ten highest-leverage moves from Index A
Score = sum of pressure severity × link strength
Dashboard construct Links between pressures and levers (strong or supporting) are the dashboard author’s mapping of the two indexes, not a table printed in the book. Click a pressure row in the matrix to trace it.
The pressure-to-lever matrix
| Index B pressure ↓ / Index A lever → | A1 | A2 | A3 | A4 | A5 | A6 | A7 | A8 | A9 | A10 | A11 | A12 | A13 | A14 | A15 | A16 | A17 | A18 | A19 | A20 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Index A: the top 20 ways to improve financial and operational performance
Revenue enhancement
A1. Optimize revenue cycle management. Advanced RCM technology; regular coding accuracy and compliance training.
A2. Expand service lines. High-demand specialties such as telemedicine, outpatient surgery and wellness; niche community services.
A3. Enhance patient access and retention. Scheduling that reduces no-shows and cancellations; portals and apps for engagement.
A4. Negotiate better payer contracts. Use analytics to demonstrate value and outcomes; value-based contracting.
A5. Increase market share. Targeted marketing; partnerships with local employers and community organizations.
Cost reduction
A6. Implement cost containment strategies. Activity-based costing to find high-cost areas; Lean and Six Sigma to remove waste.
A7. Optimize supply chain management. Centralized purchasing; inventory systems that cut excess stock and waste.
A8. Reduce labor costs. Workforce tools to right-size staffing and cut overtime; per diem and part-time models.
A9. Leverage technology. EHR and digital tools to cut administrative cost; telehealth to reduce physical infrastructure.
A10. Energy efficiency. LED lighting, efficient HVAC, solar; regular energy audits.
Efficiency improvement
A11. Streamline clinical operations. Standardized clinical pathways and protocols; analytics to find bottlenecks.
A12. Enhance data analytics. Analytics platforms for clinical and operational insight; predictive resource allocation.
A13. Improve patient flow. Real-time location systems; discharge planning protocols that shorten stays.
A14. Telemedicine integration. Expand telemedicine; integrate telehealth with the EHR.
A15. Invest in staff training and development. Continuous education; a culture of continuous improvement.
Strategic investment
A16. Invest in advanced technologies. AI and machine learning for decision support; robotic process automation.
A17. Expand outpatient services. Outpatient clinics and ambulatory surgery centers; preventive and chronic disease programs.
A18. Enhance cybersecurity. Robust security measures; regular audits and staff training.
A19. Foster community partnerships. Work with health departments, schools and nonprofits on social determinants of health.
A20. Financial planning and forecasting. Advanced planning tools for budgets and forecasts; regular performance reviews.
Chapters 20 and 21 · Financial literacy and accountability
Accountability: the culture behind the numbers
A twenty-item self-assessment of the leadership habits the book says make financial performance durable.
Rate each statement: 1 = not at all true, 3 = partly true, 5 = fully true and evident.
Leadership commitment
Transparency and communication
Financial literacy
Measurement and accountability
Controls and integrity
Financial accountability score
Not scored
0 of 20 items answered
Domain profile
Average of answered items, 0 to 100
Answer at least one item in every domain to see the weakest domain.
Dashboard construct Items are written from Chapters 20 and 21. Score = (mean rating − 1) ÷ 4 × 100. Bands are equal quarters for discussion. Because the book treats controls and integrity as non-negotiable, a Controls and integrity score below 50 caps the overall band at Building.
Reference
Formula Library
Every formula the dashboard computes, with its chapter and a link to the calculator that runs it.
Net patient revenue
Gross charges − contractual allowances − bad debt − charity care
Income actually received from patient care.
Chapter 1 ·
Revenue per adjusted discharge
NPR ÷ Adjusted discharges
Revenue efficiency adjusted for service intensity.
Chapter 1 ·
Revenue per patient day
NPR ÷ Patient days
Average income for each day a patient spends in the facility.
Chapter 1 ·
Operating expense per adjusted discharge
Operating expense ÷ Adjusted discharges
Cost efficiency adjusted for intensity.
Chapter 1 ·
Labor cost percentage
Salaries, wages and benefits ÷ Total operating expense
Share of cost attributable to the workforce.
Chapter 1, 14 ·
Operating margin
(Operating revenue − Operating expense) ÷ Operating revenue
Efficiency of core operations.
Chapter 1 ·
Net margin
Net income ÷ Total revenue
Overall profitability including non-operating items.
Chapter 1 ·
Return on assets
Net income ÷ Total assets
How effectively assets produce returns.
Chapter 1 ·
Current ratio
Current assets ÷ Current liabilities
Ability to cover short-term debts; above 1 is sufficient.
Chapter 1 ·
Days cash on hand
Unrestricted cash ÷ Average daily operating expense
Days the organization could operate on cash. Daily expense excludes depreciation.
Chapter 1 ·
Accounts receivable days
Net AR ÷ (NPR ÷ 365)
Average days to collect after service.
Chapter 1, 2 ·
Debt to equity
Total debt ÷ Total equity (net assets)
Reliance on creditors versus owners.
Chapter 1 ·
Debt service coverage ratio
Net operating income available for debt service ÷ Total debt service
Above 1 covers debt payments. Computed as operating income plus depreciation and interest.
Chapter 1 ·
Fixed asset turnover
Total revenue ÷ Net fixed assets
Revenue generated per dollar of property, plant and equipment.
Chapter 1 ·
Average length of stay
Patient days ÷ Discharges
Average duration of a hospital stay.
Chapter 1, 19 ·
Bed occupancy rate
Patient days ÷ (Beds × Days in period)
Share of available beds occupied.
Chapter 1, 19 ·
Readmission rate
Readmissions within the period ÷ Discharges
Quality signal with penalty exposure.
Chapter 1, 15 ·
Denied dollars
Claims × Denial rate × Average payment
Revenue at risk from denials.
Chapter 2 ·
Cash released from AR
(AR days now − Target AR days) × NPR ÷ 365
One-time cash freed by faster collection.
Chapter 2 ·
Net benefit (cost-benefit analysis)
NB = Total benefits − Total costs
A positive net benefit indicates a favorable investment.
Chapter 4 ·
ROI ratio
ROI = (Net benefit ÷ Total costs) × 100
Straightforward measure of financial return.
Chapter 4 ·
Break-even point
BEP = Fixed costs ÷ (Price per unit − Variable cost per unit)
Volume at which revenue equals total cost.
Chapter 4 ·
Net present value
NPV = Σ Rₜ ÷ (1 + r)ᵗ
Present value of future cash flows less the investment.
Chapter 4, 17 ·
Internal rate of return
0 = Σ Rₜ ÷ (1 + IRR)ᵗ
Discount rate at which NPV equals zero.
Chapter 4, 17 ·
Payback period
Years until cumulative net cash flow reaches zero
Interpolated within the crossing year.
Chapter 17 ·
Profitability index
PI = PV of future cash flows ÷ Initial investment
Value created per dollar invested; used to ration capital.
Chapter 17 ·
Cash flow
Total receivables − Total payables
The book’s cash flow formula.
Chapter 5
Linear trend forecast
ŷ = a + b·t, with 95% prediction interval
Regression analysis named in Chapters 5 and 18.
Chapter 5, 18 ·
Monte Carlo reserve
Planned operating income − P10 operating income
Dashboard rule for sizing a contingency reserve.
Chapter 5 ·
Flexible budget variance
Volume variance = Flex − Static; Spending variance = Actual − Flex
Separates volume effects from spending effects.
Chapter 5 ·
p-chart limits
p̄ ± 3√(p̄(1 − p̄) ÷ nᵢ)
Statistical process control for rates such as denials.
Chapter 13 ·
Blended revenue per discharge
Σ (Payer share × Payer payment)
How payer mix sets average revenue.
Chapter 7 ·
Herfindahl-Hirschman Index
HHI = Σ (Revenue share × 100)²
Concentration of revenue across payers (diversification, Chapter 6).
Chapter 6 ·
Case mix index
CMI = Total CMS relative weights ÷ Total patients served
Average acuity of patients treated.
Chapter 13 ·
Agency conversion savings
Agency spend × Share converted × Premium ÷ (1 + Premium)
Premium avoided by employing instead of contracting.
Chapter 14 ·
Turnover cost
FTEs × Turnover rate × Replacement cost
Annual cost of replacing departing staff.
Chapter 14 ·
Quality dividend
Events × Reduction × Cost per event × Share kept
Cost avoided by preventing harm.
Chapter 15 ·
Expected annual loss
Annual probability × Financial severity
Prices a risk for comparison and reserves.
Chapter 10 ·
Sources
- Emrick, K. (2024). Fiscal Fitness: Strengthening Hospital Financial Performance. All chapter content, formulas, case figures, Index A and Index B.
- Healthcare Financial Management Association. (2026). Fitch medians: 10 things to know. Fitch Ratings 2025 not-for-profit hospital medians.
- Centers for Medicare & Medicaid Services. Hospital Readmissions Reduction Program and Hospital Value-Based Purchasing Program (penalty cap and withhold percentages used as editable inputs).
This dashboard is an educational decision-support tool. Illustrative values describe no real organization. It is not accounting, legal or investment advice.