# Hospital Model Build a hospital financial model with inpatient and outpatient revenue streams, departmental cost tracking, payer mix dynamics, and clinical metrics like ALOS and Case Mix Index. Designed for healthcare operators and investors. - Canonical: https://finamodel.com/templates/hospital-model - Excel download: https://finamodel.com/templates/hospital.xlsx - Category: Healthcare - Model type: Operating model - Difficulty: Intermediate - Audiences: Developers & sponsors, Public sector, Hospital administrators, Health systems CFOs, Healthcare investors, Medical center operators - Tags: hospital, drg-reimbursement, payer-mix, service-lines, nursing-staffing ## Overview This operating model projects five years of profitability and cash flow for a general acute care hospital system by forecasting inpatient and outpatient volumes, payer mix, DRG reimbursement rates, clinical staffing by service line, and operating expense scaling. Answer: can the hospital achieve 10–16% EBITDA margins and generate positive operating leverage as volumes grow and labour inflation stabilises? The workbook builds revenue from three streams: inpatient (licensed beds × occupancy × length of stay × net revenue per discharge), outpatient (visit volumes × net revenue per visit), and ED (annual visits × revenue per visit). Payer mix drives reimbursement: Medicare and Medicaid at regulated DRG rates, commercial at contracted rates with 3–5% annual escalators. Operating expenses: salaries and wages (50–55% of revenue, highest category), supplies (15–20%), purchased services (8–12%), and facilities/insurance (4–6%). FTE scaling: 4.5–5.5 FTEs per adjusted occupied bed. Working capital: DSO 45–65 days, DIO 15–25 days. Used by hospital systems, PE sponsors in healthcare acquisitions, lenders underwriting hospital debt, and policymakers modelling health system consolidation impact. The model captures service line profitability (high-margin OR procedures, low-margin inpatient medical), payer mix sensitivity (shift from commercial to Medicaid erodes margins by 200+ bps), and agency labour premiums (15% uplift vs. FTE base). Benchmarks: HCA Healthcare, Tenet, UHS - all showing 50–55% SWB ratio, 3–5% operating margin, 60–90+ days cash on hand. Days cash covenant is typically >60 days (liquidity buffer for supply chain and payroll timing). ## What's included - Inpatient and outpatient revenue stream modelling - Departmental P&L with overhead allocation logic - Payer mix sensitivity including DRG reimbursements - Dynamic staffing and FTE optimisation schedules - Capex planning for facility expansion and medical equipment - Inpatient and outpatient case volumes by service line - Payer mix (Medicare, Medicaid, commercial insurance, self-pay) - DRG reimbursement rates and case complexity weighting - Outpatient procedure pricing and volume - Clinical staff (nursing, physicians) headcount and compensation - Supplies, equipment, and operating costs scaled to volumes ## Inside the Hospital Model: How Acute Care Economics Are Captured This hospital model builds a general acute care facility's financials from operating drivers, not headline guesses. It translates beds, occupancy, length of stay, case mix and payor contracts into net revenue, staffing costs, capital spending and cash flow. The aim is a transparent evaluation of how volume, payor mix and capacity decisions flow through to earnings and balance sheet strength. ### Revenue Drivers and Payor Contracting Inpatient revenue starts with available bed days, occupancy and patient days, then divides by average length of stay to get admissions. Case mix index and the Medicare base rate provide a second cross-check on intensity. - Outpatient and emergency department streams use separate visit volumes and rate escalators, reflecting different growth pressures from ambulatory surgery centres and urgent care. A payor mix layer then converts gross charges into net patient revenue by applying contractual allowances and bad debt ratios for Medicare, Medicaid, commercial and self-pay tiers, each with its own collection period and rate escalation. - Value-based capitation adds a per-member-per-month block with shared savings. ### Cost Structure and Staffing Economics Labour is built from the bottom up rather than as a fixed percentage of revenue. Total full-time equivalents come from adjusted occupied beds multiplied by a staffing ratio. - Those FTEs split across nursing, physician, technical and administrative roles, each with its own salary and benefits burden. Productive nursing hours are separated from non-productive time such as paid leave and education. - Agency labour is costed explicitly from agency FTEs, hours and an hourly rate that is materially higher than the in-house base, capturing post-pandemic staffing pressure. Medical supplies and pharmaceuticals are variable costs, with a 340B saving applied to outpatient drug spend. Purchased services, facilities, malpractice, marketing and equipment rent round out operating expenses. ### Capital Investment, Debt and Balance Sheet Mechanics Capital spending combines maintenance capex as a percentage of net revenue, growth capex for new beds, and explicit equipment refresh outlays in later years. Depreciation follows separate lives for buildings and equipment. - The balance sheet is anchored to an opening column with explicit cash, accounts receivable, inventory, payables, property, debt and equity inputs. Share capital is held constant at opening equity rather than acting as a plug, and retained earnings accumulate net income. - Debt is split into three tranches with distinct balances, rates and terms; interest is calculated on the opening balance, which avoids circularity. Covenants track debt service coverage, leverage and fixed-charge coverage. ### How the Model Is Used in Practice The structure supports a disciplined underwriting process. A user changes occupancy, case mix, payor mix, wage inflation or bed expansion and sees the effect on net patient revenue, staffing cost, EBITDAR, EBITDA and cash flow. - Working capital responds automatically because receivable days vary by payor and inventory and payables are tied to operating activity. Valuation uses a discounted cash flow with terminal value, while a KPI dashboard surfaces labour productivity, revenue cycle metrics, financial health and cost-of-capital checks. - Fifteen validation checks test balance sheet integrity, occupancy caps, coverage ratios and margin ranges. The public file is a values-only preview, not a live calculating workbook. ## Built for healthcare facility economics Use this model when payer mix, departmental margins, and clinical volume metrics drive the hospital financial plan. ## Handles the complexity of hospital revenue A useful hospital model connects clinical metrics like occupancy, ALOS, and case mix to financial outcomes across inpatient and outpatient streams. ## Better for capital budgeting and planning This gives you the departmental granularity needed for facility expansion decisions, payer contract negotiations, and operational efficiency analysis. ## Built for healthcare facility economics Use this model when payer mix, departmental margins, and clinical volume metrics drive the hospital financial plan. ## Handles the complexity of hospital revenue A useful hospital model connects clinical metrics like occupancy, ALOS, and case mix to financial outcomes across inpatient and outpatient streams. ## Better for capital budgeting and planning This gives you the departmental granularity needed for facility expansion decisions, payer contract negotiations, and operational efficiency analysis. ## Features - **Service line profitability:** Segment revenue and expenses by service (orthopedics, oncology, emergency, women's health, etc.) to identify margin drivers and optimization opportunities. - **Payer mix and reimbursement dynamics:** Model realistic payer negotiations, adjust rates for inflation, and reflect shift toward value-based contracts and bundled payments. - **Staffing and supply chain economics:** Link clinical staff ratios to patient volumes, model locum tenens and agency costs, and forecast supply chain inflation and efficiency. ## Use cases - **Strategic service line investment:** Analyze margins and volumes by service to prioritize capital investment, recruitment, and marketing spending. - **Operating efficiency initiatives:** Identify cost reduction and productivity improvement opportunities in staffing, supply utilization, and length of stay. - **Acquisition and integration planning:** Analyze target hospital financial performance, identify synergy opportunities, and forecast combined entity economics. ## Frequently asked questions ### What is a hospital financial model? It is a model that forecasts hospital revenue, costs, and profitability using clinical and operational drivers such as payer mix, patient volume, and departmental performance. ### Who uses hospital financial models? Hospital administrators, healthcare investors, lenders, and consultants use them for capital budgeting, strategic planning, and performance monitoring. ### What should a hospital model include? It should include inpatient and outpatient revenue, departmental P&L, payer mix assumptions, staffing matrices, and capex planning for equipment and facilities. ### Does it handle DRG reimbursements? Yes. The model supports weighted DRG averages for inpatient services, multiplying base payment rates by the Case Mix Index and discharge volumes. ### Can I model facility expansion? Yes. The capex module includes schedules for new wings, surgical suites, and diagnostic equipment with IRR and payback outputs based on projected patient throughput. ## Related templates - [Medical Device Financial Model](https://finamodel.com/templates/medtech-model) - [Senior Living Facility Economics Model](https://finamodel.com/templates/senior-living-model) - [Insurance Portfolio Risk and Return Model](https://finamodel.com/templates/insurance-portfolio-model)