Salon & Spa Model

Operating Businesses Financial Model (Free Excel Download)

Plan salon and spa performance through service volume, chair utilization, pricing, retail sales, stylist commissions, staffing, memberships, rent, and location EBITDA.

Loading...

Used by professionals from

KPMG logoWharton logoColumbia logoESSEC logoPwC logoHEC logo

About this model

A salon or spa sells a limited number of appointment hours each day, making utilisation and service mix central to performance. This model connects locations, chairs and treatment rooms, bookings, service prices, memberships, and staff pay in one plan.

Use it to budget a single site, plan a multi-location rollout, or evaluate an acquisition. It makes the effect of fuller schedules, better retail attachment, and changing stylist costs easy to see.

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 Salon & Spa Model

  • Location & capacity inputs: Year-1 locations, new locations per year, chairs & rooms per location, operating hours per chair, average visit duration
  • Utilisation: Year-1 booking utilisation with an annual ramp and a practical ceiling
  • Service mix, pricing & retention: hair/nail/spa mix and per-line average tickets, retail attach per visit, members per location and annual fee, visits per client, rebooking rate, price escalation
  • Cost structure: service supply cost %, retail product cost %, stylist commission %, productive hours per stylist; support staff per location, wage, benefits and wage growth; rent per location, marketing, G&A, depreciation as % of revenue; tax
  • Capital & working capital: maintenance capex %, build-out cost per location, NWC % of revenue change, base-year revenue
  • Valuation: WACC, terminal growth, net debt, shares outstanding
  • Operations sheet: location roll-forward, chair capacity, booked hours, total visits, derived stylist FTE, support headcount, client base and retention
  • Revenue sheet: three service lines, take-home retail, memberships & packages, total revenue

Salon & Spa Financial Model: How the Template Works

This salon spa financial model projects a multi-location salon and day-spa group. It builds revenue from chair and room capacity, applying utilisation and service mix to generate visits and revenue.

The model then flows through costs to EBITDA, ending in an unlevered DCF valuation. It suits operators and investors evaluating single sites, rollouts, or acquisitions.

What Drives Performance in the Operating Build

The model starts with a location roll-forward, adding new sites each year to an opening count. Each location contributes chairs and treatment rooms, which set the available service hours when multiplied by operating hours per chair.

  • A utilisation ramp converts those hours into booked hours, and dividing by average visit duration yields total visits. This chair-hour approach reflects that an idle hour is lost forever, making utilisation the core margin lever.
  • Staffing falls out of booked hours divided by productive hours per stylist, so labour scales with demand rather than a fixed headcount. A client-base block then derives active and retained clients from visits and rebooking rates.

Revenue Lines and Service Mix

Revenue is built from three streams: services, retail, and memberships. Service revenue splits visits across hair, nail, and spa & massage lines, each with its own average ticket escalated annually.

  • Because spa visits typically carry higher tickets, shifting the mix expands blended revenue per visit even if visit volume stays flat. Retail revenue comes from take-home product attach per visit.
  • Memberships and packages are location-driven, calculated as members per location times an annual fee. Together these produce total revenue, giving a clear view of how pricing, mix, and attachment interact.

Cost Structure and Profitability Flow

The P&L nets service supply cost and retail product cost into gross profit. Stylist and therapist pay is a commission on service revenue, so it sits in operating expenses below gross profit, keeping the gross margin high.

  • Support labour is headcount-driven with wage growth and benefits. Rent is a fixed cost per location, escalated annually.
  • Marketing and G&A are percentages of revenue. This structure means EBITDA is the key profitability metric, and as utilisation and prices rise while rent grows only with locations, the EBITDA margin expands modestly over the forecast horizon.

Cash Flow, Valuation, and Practical Use

Unlevered free cash flow is NOPAT plus depreciation, less maintenance capex and new-location build-out capex, and less changes in working capital.

  • Working capital is a light call because the business is largely point-of-service and prepaid memberships, with only retail inventory tying up cash.
  • The DCF discounts explicit cash flows and a Gordon-growth terminal value at WACC to reach enterprise value, then subtracts net debt for equity value and value per share.
  • This makes the model useful for budgeting a single site, planning a rollout, or evaluating an acquisition, as it links operational drivers to valuation.
income_statement.xlsx
Income statement, brown brand palette
income_statement.xlsx
Income statement, green brand palette
income_statement.xlsx
Income statement, red brand palette

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.

Alex Tapio, ex-Deloitte financial modelling expert

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 salon and spa financial model?+

A salon and spa financial model captures the seven-year operating economics and intrinsic value of a multi-location hair, nail and day-spa group. It rolls a location count forward, builds chair-hour capacity, converts that perishable capacity to visits through a booking-utilisation ramp and an average visit duration, prices a three-line service mix with retail attach and memberships, treats stylist pay as a commission on service revenue, and discounts an unlevered free-cash-flow stream to enterprise value, equity value and value per share.

Why is chair-hour utilisation the key driver?+

A chair or treatment room is perishable inventory - an idle chair-hour is gone forever. The model makes chair-hour capacity explicit (chairs times open hours times utilisation equals booked hours) and converts it to visits at an average visit duration rather than assuming a fixed visits-per-location, so utilisation is the lever that fills the inventory and flows straight to visits, revenue, gross profit and EBITDA.

How is this different from a med-spa?+

A med-spa is a medical, injector- and physician-led business whose capacity constraint is injector time and whose service labour is a salaried wage. This is a non-medical, stylist- and therapist-led business whose constraint is chairs and stylist hours, whose ticket is lower but visit frequency far higher, and whose service labour is a commission on service revenue. That commission structure keeps the gross margin high and makes EBITDA, not gross margin, the headline profitability line.

Why an unlevered DCF, and what about working capital?+

A salon is a point-of-service, largely prepaid-membership business, so only retail inventory ties up a small fraction of revenue growth. The bridge charges maintenance and new-location build-out capex and that light working-capital call, discounts unlevered free cash flow at a WACC reflecting a stable, mature consumer-services demand profile, and adds a Gordon-growth terminal value. Enterprise value bridges through net debt to value per share, with the implied EV/EBITDA as a sanity check below the faster-growing, higher-ticket med-spa peer.

Have more financial modelling questions? Contact us

Go further

Build the financial model you need with Fina

Browse templates, examples, and downloadable Excel models for the analysis you are trying to build. If you can't find your model, ask Fina to build a model for your specific needs.

Start for free
Excel financial model spreadsheet preview showing Customer Rollforward
Fina interactive chat interface preview