# The Hair Salon Owner: companion files

Julian R. Sterling

## What is here

- **Salon_1_Service_Price_Builder.xlsx** (Chapters 5 and 6; Workbook 1 of Appendix A): tabs Inputs, Price Build, Checks. Booked hours, the cost per booked hour, the selling rate of a chair hour and the price list, with the planner's typical service and its break-even (the price build of September 2025: 47.18 dollars a booked hour, a senior chair hour at 72.35 dollars, senior highlights at $225).
- **Salon_2_Chair_Hours_and_Break_Even.xlsx** (Chapters 3 and 14; Workbook 2): tabs Inputs, Break-Even, Checks. A closed year's revenue, variable and fixed costs per booked hour, and the break-even in booked hours a month (FY2026: 636.3 against an actual 842.0, a margin of safety of 205.6; FY2025: 418.9).
- **Salon_3_Stylist_Pay_and_Overtime.xlsx** (Chapter 9; Workbook 3): tabs Inputs, Workweek, Checks. One stylist's workweek on hourly pay plus commission: the regular rate and the overtime premium (week 63: 30.09 dollars an hour, a premium of $90, $1,474 for the week).
- **Salon_4_Commission_or_Booth_Rent.xlsx** (Chapter 11; Workbook 4): tabs Inputs, Compare, Checks. One stylist's year as an employee and as a booth renter, for the salon and for her ($54,949 against $14,300 for the salon; $71,285 against $117,446 for her, before her own taxes).
- **Salon_5_Back_Bar_Retail_and_Gift_Cards.xlsx** (Chapters 7 and 8; Workbook 5): tabs Inputs, Back Bar and Gift Cards, Checks. Back bar used at two waste rates, what retail leaves the salon and the gift cards outstanding (FY2026: $102,224 at 22 percent waste, gift cards outstanding $9,305).
- **Salon_6_Suites_Payback.xlsx** (Chapter 13; Workbook 6): tabs Inputs, Payback, Checks. The suites' contribution and payback, and the cash left after the bank ($96,000 of build-out, $31,252 of run-rate contribution, 36.9 months).
- **Salon_7_Value_and_Offer.xlsx** (Chapter 16; Workbook 7): tabs Inputs, Offer, Checks. The letter of intent from SDE to the cash at closing (adjusted SDE $235,861, price $589,653, seller note $58,965, cash at closing $490,336).
- **Hair_Salon_Owner_Check_Lists.docx**: the 8 check-lists of Appendix B, editable, with a box to tick before each item (The license and inspection file (chapter 2); The weekly book review (chapters 3 and 4); The price list (chapters 5 and 6); Back bar, retail and gift cards (chapters 7 and 8); Pay, overtime and tips (chapters 9 and 10); Renters, suites and who is an employee (chapters 11 and 13); Hiring and the stylist who leaves (chapter 12); Before answering an offer (chapters 15 and 16)).

Every workbook opens pre-filled with the exercise of Appendix A, so you can check each result against the book before typing your own figures.

## How to use the workbooks

Every workbook opens on its Inputs tab: blue type on a light yellow background is an input, and nothing else is typed by hand. The subject tab holds formulas only and is protected against overtyping, with no password. The Checks tab holds the tests of Appendix A: each one shows OK or CHECK, and the cell All checks shows OK only when every test below it does. A comparison line informs and carries no OK or CHECK.

The arithmetic is plain: the only functions are SUM, ROUND, MIN, MAX, IF and AND. No cell holds a date: periods are counts. Percentages are typed as percent (15 percent shows as 15%), and every division by an input that can be zero is wrapped in IF and shows 0 instead of an error. An empty input reads as zero in a sum, a product or a comparison, but a MIN or a MAX over a range skips it. The last section of Appendix A lists, workbook by workbook, what the checks do not catch.

To use a workbook on your own salon, start with a copy, replace every blue input from the record that owns each figure (the booking software's reports, the payroll records, the distributor's invoices, the statements, the bank's schedule, the letter itself), keep every check at OK, and never edit a formula to turn a CHECK into OK.

The workbooks are separate files with no link between them: a figure two workbooks share is typed again where it is used.

## A word of caution

Vellwyn Hair Studio, Inc., the town of Kestlebury, Ardmorrow Properties, Holmscarth Community Bank and every party in the case are fictional. Station counts, chair hours, occupancy rates, service times, prices, back bar costs, waste rates, commission rates, wages, tips, rents, suite terms, loan terms, offer terms and multiples are teaching assumptions, not market norms, not the rule of any state and not recommendations. Nothing here is a hairdressing or safety instruction. What a state requires is for its state board and counsel; taxes are for the outside CPA. The files are provided as they are, without warranty of any kind.
