Urgent Care Model
Healthcare Financial Model (Free Excel Download)
Forecast urgent-care clinic performance from visits, acuity, payer mix, reimbursement, provider capacity, staffing, site costs, and clinic-level EBITDA.
professionals from Deloitte
Used by professionals from
About this model
Urgent-care clinics combine local demand, payer mix, clinical staffing, and site expansion. This model helps you see how those everyday operating decisions build into revenue, profit, and cash flow across a group of clinics.
Use it for budgeting, acquisition analysis, or growth planning. It makes it easier to test what happens when visit volume, reimbursement, staffing costs, or new-clinic openings change.
What every model includes
Live formulas, no hardcoded values
Outputs are driven by live formulas, so the workbook updates from its assumptions instead of relying on hardcoded results.
All assumptions in one tab
Inputs are clearly marked in the Assumptions tab and separated from calculations, making it clear what to change and what to leave intact.
Statements always balancing
For integrated-statement models, the balance sheet, cash flow, and supporting schedules tie through properly.
Distinct schedules for clarity
Debt, working capital, taxes, and cash flow can get messy quickly. We group calculations in clear schedules, not across disconnected tabs.
No hidden macros or external links
There are no unexplained external workbook links or macros to undermine auditability or portability.
Changes flow through the model
Update a key driver and see the impact carry through the forecast, financing, and return outputs. We never use hardcoded numbers in formulas.
What's inside the Urgent Care Model
- Capacity inputs: Year-1 clinics, new clinics per year, visits per clinic-day, operating days
- Utilisation: Year-1 utilisation with an annual ramp and a practical ceiling
- Payer mix: commercial, Medicare, Medicaid, and self-pay shares of visits
- Net rates: per-visit reimbursement by payer, occ-health per clinic, ancillary per visit, rate escalation
- Cost structure: providers and support per clinic, provider comp, support wage, benefits, wage growth, medical supplies, rent, malpractice, marketing, SG&A, depreciation, tax
- Capital and working capital: maintenance capex, build-out cost per clinic, NWC, base-year revenue
- Valuation: WACC, terminal growth, net debt, shares outstanding
- Operations sheet: clinic roll-forward, utilisation ramp, visits per clinic, annual visits, provider and support headcount, visits per FTE
How the Urgent Care Financial Model Works: Visits, Payer Mix and Cash Flow
This urgent care financial model projects a multi-clinic walk-in operator over seven years, linking clinic growth and visit throughput to payer-mix revenue, operating costs, unlevered free cash flow and a discounted valuation. It suits readers evaluating how budgeting, acquisition or expansion decisions translate into revenue, EBITDA and equity value across an expanding clinic estate.
What Drives the Clinic Estate and Visit Volume
The model rolls the clinic estate forward each year: opening clinics plus new greenfield openings equal closing clinics, so the de novo pipeline a retail-health roll-up depends on is explicit rather than assumed. Closing clinics then feed two builds at once — annual visits and per-clinic headcount — while the year's new openings draw growth capital through a per-clinic build-out cost.
- Visit volume per clinic comes from visits per clinic-day multiplied by operating days and a utilisation factor. Utilisation begins at a Year 1 input and ramps by a fixed number of percentage points annually, capped at a practical ceiling, reflecting that new clinics season gradually and a platform rarely runs flat-out.
- Closing clinics times visits per clinic gives annual visits, the model's single most important volume driver.
Why Payer Mix Drives Revenue More Than Volume Alone
The distinguishing feature of an urgent-care operator is that the same clinical visit reimburses very differently depending on whether the patient carries commercial insurance, Medicare, Medicaid or pays cash.
- Patient-service revenue is therefore built payer by payer: annual visits times each payer's share times that payer's net rate per visit, escalated at a contract step-up rate.
- Commercial pays most per visit and Medicaid least, so the blended net revenue per visit falls out of the mix and becomes the headline yield metric — a richer commercial share lifts revenue with no change in visit count.
- An employer occupational-health book per clinic and per-visit ancillary income from imaging, labs and vaccines layer on top to reach total revenue.
How Costs Shape the EBITDA Margin
Provider and support labour are the dominant cost in a clinical business, and the model makes them headcount-driven: FTEs per clinic times wage, loaded for benefits and escalated at the wage-growth rate. The remaining lines — medical supplies, rent and occupancy, malpractice and insurance, marketing and corporate SG&A — are percentages of revenue.
- Because revenue escalates through rate step-ups and the utilisation ramp while per-clinic labour grows only with headcount and wage inflation, the EBITDA margin expands modestly across the horizon.
- That expansion is not automatic: once visits per FTE climbs past a productivity threshold, the model adds a PRN/float staffing line at a premium rate per excess visit, a volume-linked labour lever that partially offsets the ramp's margin lift. Depreciation, tax on positive EBIT and net income complete the P&L, with an identity check.
From Cash Flow to Valuation and Dashboard Use
Unlevered free cash flow is built from EBIT, unlevered tax and NOPAT, adding back depreciation, then deducting maintenance capex as a percentage of revenue, growth capex from the year's new clinics times build-out cost, and the change in working capital. That working-capital line is a use of cash, since payer receivables absorb funds as the book grows.
- The DCF sums the present value of explicit unlevered free cash flow and the present value of a Gordon-growth terminal value to reach enterprise value, then subtracts net debt for equity value and value per share, alongside an implied EV/EBITDA. A dashboard consolidates clinics, annual visits, utilisation, revenue per clinic, net revenue per visit, revenue, EBITDA, EBITDA margin, enterprise value and value per share.
- Readers can flex the de novo pipeline, the utilisation ramp, payer mix or rate escalation and watch those outputs move together.
Formatted to IB standards
Named theme colors repaint the whole workbook in one click, on top of an investment-banking structure with clear input, output, and cross-sheet reference styling - brand-ready, institutional-grade, and fully auditable.
Created by ex-finance professionals
Hey, I’m Alex and I created Finamodel.
Over my years in the finance industry I kept building the same models over and over again. Same structure, same assumptions, different logo. So I started building frameworks to turn them into clean, reusable templates.
Every model here is one I’d actually use for a client, and I personally vet each one before it goes up.
I’m not an expert in every industry, but I’ve built enough models to know what belongs in one. And when something is completely foreign to me, I reach out to my network for experts to work on our models with us.
Having a template library on hand cuts a first build from hours to minutes.
Need help finding your model? You’ll find me in the Finamodel app!
Frequently asked
What is an urgent-care model?+
An urgent-care model captures the seven-year operating economics and intrinsic value of a multi-clinic urgent-care (walk-in and immediate-care) operator. It rolls a clinic count forward, converts visits per clinic-day and a utilisation ramp into annual visits, splits those visits across a commercial, Medicare, Medicaid, and self-pay payer mix at a net rate per visit, layers occupational-health and ancillary revenue, runs the cost stack to EBITDA, and discounts an unlevered free-cash-flow stream to enterprise value, equity value, and value per share.
Why does the payer mix matter so much?+
The same visit pays very differently by payer: a commercial plan reimburses far more per visit than Medicaid, with Medicare and self-pay in between. The blended net revenue per visit is therefore set by the payer mix, and a shift toward commercial or away from Medicaid can move revenue as much as a change in volume. The model carries the mix and the per-payer net rates as explicit inputs so an analyst can stress reimbursement and watch the yield and the EBITDA margin move.
How is urgent-care revenue built?+
Revenue starts with volume: annual visits equal closing clinics times visits per clinic, where visits per clinic equal visits per clinic-day times operating days times a utilisation factor. Patient-service revenue is then the sum across payers of visits times each payer share times its net rate per visit, escalated at a contract step-up rate. An employer occupational-health book per clinic and per-visit ancillary income from imaging, labs, and vaccines layer on top to total revenue.
Why an unlevered DCF instead of an EBITDA multiple?+
An urgent-care platform runs healthy EBITDA margins but carries real depreciation and capex on clinic fit-out and equipment, and a working-capital drag because payer receivables grow with the book, so EBITDA overstates cash. The model bridges to unlevered free cash flow, NOPAT plus depreciation, less capex, less the change in working capital, and discounts it at a WACC, then adds a Gordon-growth terminal value. The implied EV/EBITDA falls out as a sanity check rather than as the valuation input.
Can I make it a levered or single-clinic model?+
The template is a single-entity unlevered DCF. For an equity-IRR view, add a de novo financing schedule and bridge to levered free cash flow; for a single clinic, set the estate to one clinic and size the visit throughput, payer mix, and headcount to that location. The net-debt line already bridges enterprise value to equity value, so a financing layer slots in cleanly.
Have more financial modelling questions? Contact us
Related templates
Hospital Operating Model
Operating model for hospital systems including inpatient/outpatient volumes, payer mix, DRG reimbursement, and staffing cost drivers.
Dental Practice
Five-year service-mix model: visits, production, collections, comp, and margins.
Senior Living Facility Economics Model
Operating model for senior living communities with unit mix, occupancy, care levels, staffing, and profitability analysis.
Gym and Fitness Studio Operating Model
Operating model for fitness franchises and independent gyms including membership revenue, class scheduling, and facility utilization.
