Technical Guides

Healthcare Facility Operations Models

A healthcare facility operations financial model specialises the general social infrastructure framework to a continuously operating, clinically intensive building type: near-continuous occupancy driving building fabric wear intensity, clinical and medical equipment renewing on a materially shorter cycle than the building itself, and infection-control-driven maintenance and cleaning standards that exceed a typical commercial building specification. This guide covers how to build that specialised operations-phase model.

Healthcare Financial Due Diligence

Healthcare financial due diligence applies standard quality of earnings testing with sector-specific attention to reimbursement risk, revenue cycle health, and reserve adequacy for clinical liabilities such as malpractice or workers' compensation exposure. This guide covers how each of these areas should be tested during diligence, complementing the transaction-specific risk factors, synergy, payer contract transferability, clinical staff retention, covered in Healthcare Investment Models.

Healthcare Financial KPIs

Healthcare financial performance is best monitored through a defined set of KPIs spanning operating volume and capacity, revenue cycle efficiency, cost structure, and profitability, each of which isolates a different driver of overall financial performance. This guide sets out the core KPI set, how each is calculated, and, critically, how they should be read together rather than in isolation, since a single favourable metric can mask deterioration elsewhere in the operation.

Healthcare Investment Models

Healthcare investment and acquisition modelling applies standard valuation and returns analysis to a provider target, but requires diligence-specific attention to synergy realisation risk, payer contract transferability, and clinical staff retention, three drivers that determine whether a target's standalone financial performance will actually be realised post-transaction. This guide covers how each should be tested and reflected in the investment model, building on the provider operating model architecture used throughout this pillar.

Healthcare Model Audit

A healthcare model audit tests structural formula integrity across the revenue driver decomposition, revenue cycle waterfall, and staffing cost calculations, the sector-specific mechanics that sit on top of standard financial model structural audit practice. This guide covers what a healthcare model audit should verify at the formula level, distinct from the broader-scope Healthcare Model Review, and how it connects to the general financial model auditing discipline.

Healthcare Model Documentation Standards

Healthcare financial models require documentation that traces case mix, payer mix, and staffing ratio assumptions to their specific sources, since these assumptions are the most likely to be revisited, challenged, or invalidated by a subsequent regulatory or market change. This guide covers what a healthcare model's assumption documentation should capture, and why documentation discipline matters more in this sector given the recurring exposure to policy-driven assumption change.

Healthcare Model Governance Framework

A healthcare model governance framework establishes clear ownership, escalation, and board reporting structures for a provider's financial models, designed to survive personnel turnover and remain current across the reimbursement policy and market cycles this pillar has shown to be a recurring source of assumption change. This guide covers what such a framework should specify, and how it connects to the documentation and assurance disciplines covered elsewhere in this pillar.

Healthcare Model Review

A healthcare model review applies a structured, driver-by-driver testing sequence, volume, case mix, payer mix, revenue cycle, staffing, and capex, to a provider financial model, distinct from a full audit or independent validation in scope and depth. This guide covers how to scope a healthcare model review, the recommended testing sequence, and how findings should be reported to be actionable for management or an investment committee.

Healthcare Model Validation

Healthcare model validation independently checks whether a model's key input assumptions, case mix index, payer mix, staffing ratios, collection rates, are sourced from defensible internal or external evidence and whether the model's sensitivity coverage adequately tests the sector-specific drivers most likely to move the outcome. This guide covers what validation should verify about input sourcing and sensitivity coverage, distinct from the formula-level testing performed in Healthcare Model Audit.

Healthcare Modelling Best Practices

This capstone guide synthesises the construction discipline covered throughout this pillar into three governing principles for a defensible healthcare financial model: revenue driver decomposition (volume, case mix, payer mix, kept separable), revenue cycle rigour (an explicit gross-to-net waterfall with sourced assumptions), and activity-linked cost modelling (staffing and supply cost tied to actual clinical drivers, not flat growth rates). Each principle is cross-referenced to the detailed guides covering its implementation.

Healthcare Occupancy Models

Occupancy modelling translates a facility's admissions and length-of-stay forecast into bed utilisation over time, and underpins both revenue capacity planning and staffing requirement forecasting. This guide covers how to build an occupancy model from patient day drivers, why licensed, staffed, and effective capacity must be distinguished, and how seasonal and day-of-week demand variation should be reflected rather than smoothed into an annual average.

Healthcare Regulatory Considerations

Healthcare financial models operate inside a regulatory framework that directly shapes revenue (reimbursement policy), permitted operations (licensure and accreditation), and capital planning (regulatory-mandated equipment or facility standards). This guide covers how each regulatory dimension should be reflected in the model as an explicit assumption or risk, and why jurisdictional variation means a single generic regulatory treatment cannot be applied across markets.

Healthcare Reimbursement Models

Healthcare providers are paid under several distinct reimbursement structures, diagnosis-related-group (DRG) case-based payment, itemised fee schedules, per-diem rates, and negotiated case rates, each requiring a different revenue calculation mechanic in the financial model. This guide covers how each reimbursement method actually calculates payment, and why blending them into a single average reimbursement rate misrepresents a provider's true revenue sensitivity to volume, acuity, and length-of-stay changes.

Healthcare Scenario Analysis

Healthcare scenario analysis tests how a provider's financial model performs under structurally coherent alternative futures, combining volume, payer mix, reimbursement policy, and cost drivers into internally consistent scenarios rather than varying each in isolation. This guide covers how to construct a base, upside, and downside case that moves correlated drivers together, and why a reimbursement policy downside deserves its own dedicated scenario given its distinct, regulator-driven trigger.

Healthcare Sensitivity Analysis

Healthcare sensitivity analysis isolates the impact of varying a single driver, patient volume, case mix index, payer mix, or clinical staffing ratio, holding all others constant, to identify which individual assumption the model's financial outcome is most exposed to. This guide covers how to structure a driver-by-driver sensitivity table specific to healthcare's revenue and cost mechanics, and why case mix and payer mix sensitivity deserve equal weight alongside the volume sensitivity that generic models default to testing.

Hidden Worksheets in Financial Models

A hidden worksheet in an Excel financial model is a worksheet that does not appear in the worksheet tab bar during normal navigation but remains part of the workbook and participates in the model's calculation structure. Excel supports two levels of worksheet hiding: standard hiding (via the right-click context menu) and very hidden (via the VBA editor), which cannot be unhidden through the standard interface. Hidden worksheets are a structural risk in financial models because they contain calculations that affect the model's outputs but are not visible to users or reviewers examining the model through normal means.

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.

How to Build Unlevered Free Cash Flow (FCFF)

Building unlevered free cash flow (FCFF) correctly is the first mechanical step of an FCFF-based DCF valuation. FCFF starts from NOPAT — operating profit adjusted for a hypothetical unlevered tax charge — and is adjusted for non-cash charges, capital expenditure, and working capital movements to arrive at the actual cash generated by the business, available to all capital providers before financing effects. This guide walks through the build line by line, the two equivalent construction methods (from NOPAT and from cash flow from operations), and the structural checks that confirm each line is properly linked to the rest of the model rather than entered as a disconnected assumption.

How to Build WACC (Step-by-Step)

Building WACC correctly requires three separate sub-builds — cost of equity via CAPM, after-tax cost of debt, and capital structure weights — combined into a single weighted average. Each sub-build has its own inputs, sources, and common errors, and the overall WACC figure is only as reliable as the weakest of its components. This guide walks through each step in order, the capital structure weighting convention (market values, not book values), and the structural checks that confirm the build is internally consistent with the rest of the model, including the circularity that arises when capital structure weights depend on a total value that itself depends on WACC.

How to Build a Comparable Company Analysis

Building a comparable company analysis correctly requires more than pulling a list of same-industry tickers. This guide walks through the full build in order — defining defensible peer selection criteria, spreading each peer's financials and calculating its multiples, calendarizing every peer to a common fiscal period, identifying and handling outliers, and applying the resulting multiple range to the subject company's own metrics — along with the structural checks that confirm each step has been performed consistently across the entire peer set.