Healthcare Financial Model Checklist
Executive Summary
Key Takeaways
- ✓ Healthcare provider models combine standard financial modelling discipline with reimbursement, case mix, and revenue cycle mechanics that require their own, sector-specific checklist items.
- ✓ Revenue should be decomposed into volume, case mix, and payer mix rather than reviewed as a single blended growth assumption, since each driver carries a different risk profile and sourcing requirement.
- ✓ The gross-to-net revenue cycle waterfall, and its resulting days in accounts receivable, is one of the most consequential and most frequently under-scrutinised areas of a healthcare provider model.
- ✓ Staffing cost, given its typical dominance of the cost structure, and clinical equipment capex, given its faster and more safety-sensitive renewal cycle, both warrant dedicated review beyond a generic cost and capex checklist.
Objective¶
This checklist verifies the sector-specific mechanics of a healthcare provider financial model: revenue driver decomposition, revenue cycle gross-to-net mechanics, and healthcare-specific cost and capital structure. It exists as a distinct checklist because these mechanics do not appear in a generic corporate model and are not covered by the general Financial Model Audit Checklist, which this checklist assumes has already been applied.
Applicability¶
Applicable when a financial model is being built or reviewed for a hospital, clinic, or other healthcare provider ahead of a financing decision, investment approval, or transaction. Most directly applicable to fee-for-service and mixed-model providers; a provider operating materially under value-based or capitated arrangements should additionally apply the utilisation and cost-risk considerations described in Healthcare Business Models.
Checklist¶
| # | Check Item | Why It Matters | Evidence to Collect |
|---|---|---|---|
| 1 | Revenue is decomposed into patient volume, case mix index, and payer mix as separable, individually sourced assumptions | A blended revenue-per-patient assumption conceals which driver is responsible for a forecast change or historical variance | Revenue driver decomposition schedule |
| 2 | Case mix index assumption is documented with its source and, where practical, built at the service line level | An undocumented or hospital-wide-blended CMI assumption can mask offsetting service line shifts and overstate reimbursement | CMI sourcing documentation, service line breakdown |
| 3 | Payer mix is modelled explicitly with a category-specific reimbursement rate, and tested under a downside payer mix scenario | Payer mix shifts can reduce revenue at stable volume and case mix, and this exposure should be explicitly tested | Payer mix assumption and downside scenario output |
| 4 | The gross-to-net revenue cycle waterfall (contractual allowance, charity care, denial/write-off) is built as explicit, separate deduction lines | A single blended collection percentage against gross charges obscures which deduction category is driving revenue leakage | Gross-to-net waterfall schedule |
| 5 | Denial rate and denial recovery rate are modelled as separate assumptions | The two respond to different operational levers, and blending them conceals which one needs improvement | Denial rate and recovery rate assumption documentation |
| 6 | Days in accounts receivable is derived from the revenue cycle module's own payment timing assumptions, not forecast independently | An independently forecast Days in AR can be inconsistent with the model's own revenue cycle assumptions | Days in AR derivation trace to revenue cycle module |
| 7 | Staffing cost is driven by clinical staffing ratios tied to volume and acuity, not a flat headcount growth rate | Staffing, typically the largest cost line, should track the clinical activity that actually drives it | Staffing ratio documentation and formula trace |
| 8 | Clinical supply and pharmaceutical cost is modelled per case or per patient day, not as a flat percentage of revenue | Revenue-percentage-based supply cost incorrectly ties clinical resource consumption to payer reimbursement rate | Supply cost driver documentation |
| 9 | Clinical equipment capex is modelled as a distinct asset category from building fabric, with its own renewal cycle | Blending clinical equipment into general building capex understates its faster, technology-driven replacement need | Capex schedule by asset category |
| 10 | Fixed facility overhead is modelled separately from variable, activity-driven cost categories | Blending fixed and variable cost obscures the provider's true sensitivity to a volume change | Cost structure schedule showing fixed/variable split |
| 11 | Where a service line or contribution margin analysis is presented, the shared cost allocation basis is documented and applied consistently | An inconsistent or revenue-proportional allocation basis can distort relative service line profitability comparisons | Cost allocation methodology documentation |
| 12 | Where any portion of revenue is value-based or capitated, utilisation and cost risk under that arrangement is modelled and stress-tested separately from fee-for-service revenue | Capitation and downside-risk value-based arrangements invert the volume-to-revenue relationship, and blending them with fee-for-service revenue conceals this exposure | Value-based arrangement risk schedule |
Common Failures¶
- Revenue modelled as a single blended per-patient rate, with no visibility into whether volume, case mix, or payer mix is driving a forecast change.
- Gross charges used as a proxy for revenue without an explicit gross-to-net waterfall, overstating expected collections.
- Staffing cost grown on a flat percentage basis, disconnected from the volume and acuity forecast driving actual clinical demand.
- Clinical equipment blended into general building capex, understating the facility's near-term capital requirement.
Recommended Evidence¶
A completed healthcare model review should be accompanied by the revenue driver decomposition schedule, the gross-to-net revenue cycle waterfall, the staffing ratio and supply cost driver documentation, and, where relevant, the capex schedule broken out by asset category. The table above is structured for direct use in model governance documentation, a lender due diligence file, or an audit working-paper file.
How to Use This Checklist¶
Apply the Financial Model Audit Checklist first for general structural integrity, then work through this checklist against the model's revenue driver decomposition and revenue cycle schedules. See Financial Model Audit for Healthcare for broader industry audit context.
Continue Reading¶
Related Pillars¶
Related Technical Guides¶
Related Industries¶
Related Checklists¶
How OXXON tests thisRun a free structural check with FMAE
Frequently Asked Questions
What makes a healthcare financial model different from a standard corporate model, for review purposes?
It combines standard financial modelling discipline with reimbursement-rate, case-mix, and revenue cycle mechanics specific to the sector, none of which appear in a generic corporate model, and each of which can materially affect revenue and cash conversion independent of headline volume growth.
Why should revenue be reviewed as three separate drivers rather than one growth rate?
Because patient volume, case mix index, and payer mix can each move independently and for different reasons, and a single blended revenue growth assumption prevents a reviewer from identifying which driver is actually responsible for a forecast change or a variance against history.
Why does the revenue cycle warrant its own checklist section?
Because the gap between gross billed charges and actually collected cash, driven by contractual allowances, claims denial, and collection timing, is frequently one of the largest and least scrutinised sources of overstated revenue and understated working capital requirement in a healthcare model.
Should this checklist be used alongside the general Financial Model Audit Checklist?
Yes. This checklist adds the healthcare-sector-specific items; the general Financial Model Audit Checklist should be applied first for baseline structural integrity, formula correctness, and documentation standards.
Related Articles
What Is a Financial Model Audit?
A financial model audit is an independent, structured examination of an Excel based financial model to confirm that its mechanics, logic, and outputs are reliable enough to support a decision. It is not a check of whether the assumptions are optimistic or conservative. It is a check of whether the model actually calculates what its author believes it calculates. Every year, lenders extend debt, investment committees approve capital, and boards sign off on transactions using numbers that came out of a spreadsheet nobody outside the immediate deal team has independently verified. A financial model audit exists to close that gap before it becomes expensive.
Healthcare Financial Modelling
Healthcare financial modelling is the discipline of modelling a healthcare provider's revenue, cost, and capital structure from its clinical and operational drivers, patient volume, case mix, payer mix, and clinical staffing and equipment, rather than the generic market-price and headcount-growth drivers used in most corporate models. This page is the hub for the Knowledge Centre's healthcare and life sciences financial modelling content: how a hospital or provider operating model is structured, how the revenue cycle converts gross charges into collected cash, how service line and cost models are built, and how sector-specific business models, occupancy dynamics, and governance practice apply as this domain expands to cover the full range of healthcare and life sciences sub-sectors.
Financial Model Audit for Healthcare
Healthcare financial models, whether for a hospital operator, a healthcare real estate asset, or a PPP-structured hospital infrastructure project, are shaped by reimbursement-rate assumptions, occupancy and case-mix mechanics, and regulatory tariff exposure that a general corporate model does not test. Where hospital infrastructure is financed under an availability payment or concession structure, standard project finance mechanics apply on top of these sector-specific revenue drivers. This page sets out the modelling risks specific to healthcare, the audit findings that recur across hospital and healthcare real estate financings, and what independent audit is expected to verify.
Revenue Cycle Modelling
The revenue cycle module translates gross billed charges into net patient service revenue and, ultimately, collected cash, through contractual allowances, claims denial and resubmission, and the resulting accounts receivable balance. This guide covers how to build that module: the gross-to-net waterfall, how denial and collection assumptions should be sourced and tested, and how days in accounts receivable feeds the working capital forecast.