Medical Spa Model
Healthcare Financial Model (Free Excel Download)
Forecast med-spa economics from treatment volume, provider utilization, pricing, memberships, product sales, consumables, marketing, staffing, and clinic-level EBITDA.
professionals from Deloitte
Used by professionals from
About this model
This model helps you plan a medical aesthetics business across injectables, treatments, memberships, and skincare sales. It connects demand and pricing to injector capacity, staff costs, and the investment required to grow the platform.
Use it to assess a single spa, a new location, or an acquisition strategy. The summary makes it clear how operating assumptions affect profit, cash flow, and value.
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 Medical Spa Model
- Spa inputs: Year-1 spas, new spas per year, treatments per spa, providers per spa, average treatment ticket
- Utilisation: Year-1 utilisation with an annual ramp and a practical ceiling
- Service mix: injectables, laser and energy, body contouring and facials and skincare shares, per-tier price indices and net margins
- Ancillary: members per spa and annual membership fee, skincare retail spend per treatment, price escalation
- Cost structure: provider and support comp and wage with benefits and wage growth; facilities and device leases, marketing, technology and SG&A as % of gross profit; depreciation (% of revenue); tax
- Capital and working capital: maintenance capex %, spa build-out cost per spa, NWC % of revenue growth, base-year revenue
- Valuation: WACC, terminal growth, net debt, shares outstanding
- Operations sheet: spa roll-forward, utilisation ramp, treatments per spa, total treatments, staff headcount, treatments per provider
Medical Spa Financial Model: How the Template Values an Aesthetics Platform
This med spa financial model template projects a multi-location medical aesthetics business over seven years, linking spa openings, treatment capacity, service mix and pricing to revenue, profit and unlevered free cash flow. It lets you examine how operational choices—from injector staffing to membership penetration—translate into EBITDA and enterprise value.
Operating Drivers: Spas, Capacity and Volume
The model begins with spa roll-forward and capacity utilisation. Each year, opening spas plus new openings equal closing spas, which drive provider count and treatment volume.
- Mature treatments per spa are set by room and provider capacity, then multiplied by an effective utilisation factor. The seasoned utilisation curve starts at a Year 1 input and ramps annually to a practical ceiling, reflecting that no spa fills every slot.
- A vintage-weighted blend discounts the year's new spas by a first-year productivity share, so de novo dilution from the build-out is charged upfront rather than pretending a new spa trades like a seasoned one. Demand-side volume is also capped by injector capacity—total providers times annual throughput per provider—keeping the staffing input honest.
Injector and coordinator headcount scale with closing spas, and provider labour sits in operating expense rather than cost of revenue, reflecting the people-intensive, licence-gated nature of aesthetics.
Calculation Flow: From Treatment Mix to Gross Profit
Treatment revenue is built tier by tier: total treatments times each service tier's share times a blended average ticket times that tier's price index, escalated annually. The four tiers—injectables, laser and energy, body contouring, and facials and skincare—each carry distinct price indices and net margins, so the realised revenue per treatment and blended margin fall out of the mix rather than raw visit count.
- For all tiers except injectables, consumables and product cost equals revenue times one minus net margin. Injectables product cost is instead built up from per-unit economics: toxin-led visits consume neurotoxin units at a cost per unit, filler-led visits consume HA syringes at a cost per syringe, blended by the visit split.
- Aesthetic memberships and skincare retail add revenue but also carry their own costs—membership fees include a redemption credit, and skincare retail carries a product cost—so every revenue line is charged.
The resulting gross profit then funds a headcount-driven labour stack and a gross-profit-geared overhead stack to reach EBITDA, EBIT and net income.
Outputs: Dashboard, P&L and Valuation Metrics
The model produces a one-page dashboard summarizing spas, treatments, utilisation, revenue per spa, revenue per treatment, total revenue, EBITDA, EBITDA margin, enterprise value and value per share. The P&L details revenue, consumables and product cost, gross profit and margin, provider and coordinator labour, overhead lines, EBITDA, EBIT, tax, net income and the implied injectables net margin that emerges from the per-unit build-up.
- An identity check ensures the P&L balances. Unlevered free cash flow is NOPAT plus depreciation less maintenance capex, spa build-out capex and the change in working capital.
- The DCF sums explicit UFCF and a Gordon-growth terminal value to enterprise value, subtracts net debt for equity value, and divides by shares for value per share. The dashboard also includes a seven-year operating summary, trend charts and a revenue-to-net-income waterfall.
Practical Use: Testing Sensitivities and Business Relationships
The template lets you flex key assumptions and observe how they flow through to valuation. Changing treatments per spa, the utilisation ramp, or the service mix shifts blended revenue per treatment, gross profit, EBITDA and enterprise value together.
- Adjusting the toxin-led visit share, neurotoxin units per visit, cost per toxin unit, or syringes per filler visit directly moves injectables product cost and the implied tier margin. Altering members per spa, annual membership fee or retail spend per treatment affects the membership and skincare lines.
- Because the model charges every revenue line with a cost and caps volume by injector capacity, it avoids overstating profit and reflects the operational trade-offs—such as slower build-out raising near-term volume per spa—that matter when evaluating growth strategies.
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 a med-spa financial model?+
A med-spa financial model captures the seven-year operating economics and intrinsic value of a multi-location medical aesthetics group that runs injectables and laser treatments alongside body contouring, facials, recurring aesthetic memberships and a skincare retail attach. It rolls a spa count forward, converts a capacity-utilisation ramp into total treatments, prices treatments across a four-tier service mix at a blended average ticket and price index, runs the high-gross-margin injector-heavy cost stack to EBITDA, and discounts an unlevered free-cash-flow stream to enterprise value, equity value, and value per share.
How is med-spa revenue built?+
Revenue is driven by the spa estate and its utilisation: total treatments equal closing spas times treatments per spa times a utilisation factor that ramps to a ceiling, and treatment revenue splits those treatments across an injectables, laser and energy, body contouring and facials and skincare mix, each priced at a blended average ticket times a per-tier price index. Spa-driven aesthetic memberships and treatment-driven skincare retail layer on to total revenue.
Why is the service mix so important?+
A device-light injectables visit, a device-heavy laser session and a high-ticket body-contouring cycle each carry very different price points and consumable economics, so the realised ticket per treatment and the blended margin both fall out of the mix rather than the raw treatment count. The model makes the per-tier price indices and net margins explicit so an analyst can flex the mix and pricing and watch revenue per treatment, gross profit and EBITDA move together.
Why an unlevered DCF instead of an EBITDA multiple?+
A med-spa group still builds out and equips each location with capital-intensive lasers and devices, so EBITDA overstates cash. The model bridges to unlevered free cash flow, NOPAT plus depreciation, less maintenance and build-out 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.
Have more financial modelling questions? Contact us
Related templates
Dental Practice
Five-year service-mix model: visits, production, collections, comp, and margins.
Physical Therapy Clinic Model
Plan and value an outpatient physical therapy clinic group using patient visits, payer reimbursement rates, staffing, and a DCF.
Franchise Unit Economics Model
Economics template for franchise systems modeling unit-level P&L, franchise fees, royalties, and multi-unit growth scenarios.
Gym and Fitness Studio Operating Model
Operating model for fitness franchises and independent gyms including membership revenue, class scheduling, and facility utilization.
