Revenue Cycle Modelling
Executive Summary
Key Takeaways
- ✓ The revenue cycle module should build an explicit gross-to-net waterfall, gross charges less contractual allowances, less denial and write-off, to arrive at net patient service revenue, rather than assuming a single collection percentage against gross charges.
- ✓ Denial rate and denial recovery rate should be modelled as separate assumptions, since the two respond to different operational levers, claims accuracy at submission versus follow-up and appeal effectiveness.
- ✓ Days in accounts receivable, sourced from the revenue cycle module's collection timing assumptions, is the primary link between the revenue cycle and the working capital forecast.
- ✓ Revenue cycle assumptions should be sourced and, where the model's granularity allows, tested by payer category, since collection performance varies materially across government, commercial, and self-pay claims.
Objective¶
This guide covers how to build the revenue cycle module of a hospital or healthcare provider financial model, translating gross billed charges into net patient service revenue and the resulting working capital impact, representing the operational process described in Revenue Cycle Management.
The Gross-to-Net Waterfall¶
The module should build an explicit sequence of deductions rather than a single blended collection percentage against gross charges:
- Gross billed charges. The provider's list-price charge for services delivered, driven by the volume, case mix, and pricing assumptions in the core revenue model.
- Contractual allowance. The gap between the gross charge and the specific payer's negotiated or regulated rate, modelled by payer mix category.
- Charity care and other adjustments. Amounts the provider does not expect to bill or collect for policy or regulatory reasons.
- Claims denial and write-off. Amounts denied by the payer and not ultimately recovered through resubmission or appeal.
The result is net patient service revenue, the economically meaningful top-line figure.
Denial Rate and Denial Recovery Rate¶
These two assumptions should be modelled separately, since they respond to different operational levers. Denial rate, the proportion of submitted claims initially rejected by the payer, reflects claims accuracy and completeness at the point of submission. Denial recovery rate, the proportion of denied claims ultimately recovered through correction, resubmission, or appeal, reflects the effectiveness of the provider's follow-up process. Blending the two into a single net collection percentage obscures which lever, submission accuracy or follow-up effectiveness, a provider should focus on improving, and prevents the model from testing each independently.
Connecting to Working Capital¶
Days in accounts receivable is derived from the revenue cycle module's collection timing assumptions, how long, on average, each payer category takes to pay a clean or corrected claim, and is the primary link between the revenue cycle module and the accounts receivable balance in the working capital forecast. A revenue cycle module built without explicit payment timing assumptions cannot produce a defensible working capital forecast.
Modelling by Payer Category¶
Where the model's granularity allows, denial rate, denial recovery rate, and payment timing should each be modelled by payer category, since collection performance varies materially across government, commercial, and self-pay claims. A single blended assumption across all payers can mask a genuine deterioration concentrated in one category, for example a rising self-pay share combined with declining self-pay collection performance.
Common Construction Pitfalls¶
Single blended collection percentage. Applying one net collection rate to gross charges, rather than building the explicit gross-to-net waterfall, obscures which deduction category is driving revenue leakage.
Denial rate and recovery rate combined. Blending submission accuracy and follow-up effectiveness into one assumption prevents the model from identifying which operational process needs improvement.
Working capital disconnected from revenue cycle assumptions. Forecasting days in accounts receivable independently of the revenue cycle module's own payment timing assumptions produces an internally inconsistent model.
Recommended Practices¶
- Build the gross-to-net waterfall as explicit, separately sourced deduction lines.
- Model denial rate and denial recovery rate as separate assumptions.
- Derive days in accounts receivable directly from the revenue cycle module's payment timing assumptions.
- Segment revenue cycle assumptions by payer category where the model's data supports it.
Continue Reading¶
Related Pillars¶
Related Technical Guides¶
Related Glossary¶
- Payer Mix
- Revenue Cycle Management (RCM)
- Days in Accounts Receivable
- Net Patient Service Revenue (NPSR)
Related Industries¶
How OXXON tests thisRun a free structural check with FMAE
Frequently Asked Questions
What is the gross-to-net revenue waterfall?
The sequence of deductions applied to gross billed charges to arrive at net patient service revenue, contractual allowance (the gap between gross charge and the payer's negotiated or regulated rate), charity care, and claims denial or write-off, each modelled as an explicit, separately sourced line rather than folded into one collection percentage.
Why should denial rate and denial recovery rate be modelled separately?
Because they respond to different operational levers. Denial rate reflects claims accuracy at the point of submission; denial recovery rate reflects the effectiveness of the follow-up, correction, and appeal process. Blending them into one net collection assumption obscures which lever a provider should focus on improving.
How does the revenue cycle module connect to working capital?
Through days in accounts receivable, which is derived from the revenue cycle module's collection timing assumptions (how long, on average, each payer category takes to pay a clean or corrected claim) and feeds directly into the accounts receivable balance in the working capital forecast.
Should revenue cycle assumptions be modelled by payer category?
Where the model's granularity allows, yes. Collection performance, denial rates, and payment timelines vary materially across government, commercial, and self-pay claims, and a single blended assumption can mask a deterioration concentrated in one payer category.
What data should support a revenue cycle assumption?
The provider's own historical claims data, ideally segmented by payer category, showing actual denial rates, denial recovery rates, and payment timing, rather than a generic industry benchmark applied without reference to the specific provider's claims accuracy and collections discipline.
Related Articles
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.
Hospital Financial Models
A hospital financial model links clinical and operational drivers, patient volume, case mix, payer mix, staffing, and equipment, into a full set of projected financial statements. This guide covers the core module architecture for a hospital operating model: how volume and case complexity assumptions feed revenue, how staffing and clinical cost structures respond to that same volume, and how the resulting model differs structurally from a generic corporate operating model.
Payer Mix
Payer mix is the distribution of a healthcare provider's patient volume, and more importantly its revenue, across payer categories such as government programmes, commercial insurance, managed care, and self-pay patients. Because each payer category reimburses the same clinical service at a materially different rate, payer mix is one of the primary determinants of a healthcare provider's realised revenue per case, independent of both volume and case mix index. A financial model that assumes a single blended reimbursement rate across all patients, rather than modelling payer mix explicitly, understates its sensitivity to a shift in that mix.
Revenue Cycle Management (RCM)
Revenue cycle management (RCM) is the end-to-end administrative and clinical process by which a healthcare provider captures, bills, and collects revenue for services delivered, spanning patient registration and eligibility verification, charge capture, claims submission, payer adjudication, denial management, and final collection or write-off. RCM performance, not just gross charges billed, determines a provider's actual realised cash revenue, and is the operational process a financial model's collection rate and days-in-accounts-receivable assumptions ultimately represent.
Days in Accounts Receivable (Healthcare)
Days in accounts receivable (Days in AR) measures the average number of days between a healthcare service being delivered and billed and the resulting payment being collected, calculated as accounts receivable balance divided by average daily net patient service revenue. It is one of the primary quantitative indicators of revenue cycle management performance, and a rising Days in AR figure signals either a payer mix shift toward slower-paying categories, a deterioration in claims accuracy, or a genuine breakdown in collections follow-through, each of which has a different implication for the financial model.
Net Patient Service Revenue (NPSR)
Net patient service revenue (NPSR) is the revenue a healthcare provider recognises after deducting contractual allowances (the difference between gross charges and the negotiated or regulated payer rate), charity care, and other revenue deductions from gross billed charges. NPSR, not gross charges, is the economically meaningful top-line revenue figure for a healthcare financial model, since gross charges are typically a list-price figure that bears little relationship to what any payer actually pays.
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.