Free Excel templates

A free hair salon service price and break-even planner in Excel

The cost of a booked chair hour turned into a selling rate and a price floor, and a year of costs turned into the services a month a salon needs. One sheet of inputs, live formulas and six checks.

The file opens on the book's fictional salon and its price build of September 2025. Seven employed stylists at 34 chair hours a week and the owner at 24, over 50 working weeks at 78 percent occupancy: 10,218 booked hours a year. Fixed costs net of booth rent of $299,560 and hourly pay of $182,499 make $47.18 a booked hour and a senior chair hour at $72.35. A typical service of 1.25 hours with $12.00 of back bar has a price floor of $110, leaves $69.77 and breaks even at 575.8 services a month.

Get the planner

One Excel file, no macros, nothing locked on the Inputs tab. Free: enter your email address and the download opens at once, along with the other free models.

Hair_Salon_Service_Price_and_Break_Even_Planner.xlsx (12 KB)

You join the reader list: one email when a new free model or a new book comes out, and a few notes on using the models. Leave in one click. Already on the list? Enter the same address. How your address is used.

The book behind this planner

This file is drawn from workbooks 1, 2 and 4 of The Hair Salon Owner, which follows one fictional salon through two fiscal years: the move from commission tiers to hourly pay plus commission, prices built from the cost of a chair hour, back bar and retail, booth renters turned employees, four suites built next door, break-even in chair hours and a letter of intent from a stylist who wants to buy.

DRM-free PDF, $19.99 → · Paperback, $32.99, shipped worldwide

What is in the file

Three sheets. Blue type on a yellow fill is an input; black type is a formula, protected against overtyping with no password.

Inputs
Stations, employed stylists and their chair hours, the owner's chair hours, working weeks and occupancy; the hourly wage, paid hours, weeks paid and the payroll burden rate; fixed costs a month and expected booth rent; commission, card fees, the target margin and the waste allowance; one typical service (hours and back bar); retail revenue and its cost; and one stylist's year for the commission or booth rent comparison.
Planner
Booked hours, hourly pay, fixed costs net of booth rent, the cost per booked hour, the take-out factor and the selling rate; the price floor, the variable cost and the margin per service; services a month, break-even in services and revenue a month and the owner's income above break-even; retail margin beside it; and what one stylist leaves the salon as an employee ($54,949 in the case) and as a booth renter ($14,300).
Checks
Stylists, hours and the service time above zero, occupancy in range, a positive take-out factor, booth rent below fixed costs, stylists within the stations, a booth rent and weeks in range, and an All checks cell.

Three things to try

Raise the target margin to 15 percent. The cost per booked hour does not move; the selling rate of a senior chair hour goes from $72.35 to $78.36. Only the take-out factor changes.

Lower the occupancy. Type 70 percent instead of 78 and watch the cost per booked hour climb: the same people and rent spread over fewer hours that clients actually book.

Change the booth rent. At $400 a week instead of $275, the same stylist would leave the salon $20,800 a year as a renter, still far below $54,949 as an employee in the case. Who is an employee is not decided by the rent: that is for counsel.

Questions

Why divide by booked hours and not chair hours?

Because a salon sells booked hours. A cost spread over every chair hour assumes every chair hour is booked, and every price built on it is too low by exactly the share that stays empty.

Is this a price list for my salon?

No. The hours, wages, product costs and prices are the book's teaching assumptions, not market prices, and nothing here says how a service must be done.

Related reading