Business financial model file
Hair Salon Financial Model
Budget the salon fit-out and staffed appointment book before treating every empty chair as an additional profitable service.
Opening investment and working cash
The original model is an employee-staffed three-chair salon, not a booth-rental business. The deposit and product stock are working cash; wet-area works, stations and tools are investment. A color-heavy menu requires a different service-time and product-cost mix.
| Cash use | $ |
|---|---|
| CAPEX: Premises and wet-area fit-out | 32,000 |
| CAPEX: Three chairs/wash stations | 20,000 |
| CAPEX: Tools, POS and furnishings | 8,000 |
| Pre-opening: Local plans/professional setup | 4,000 |
| Pre-opening: Pre-opening recruitment/training and launch | 6,000 |
| Refundable deposit / tied-up cash | 6,000 |
| Opening stock / initial working inputs | 3,000 |
| Reserve: 2 selected fixed-cost months | 42,856 |
| Selected opening cash total | 121,856 |
CAPEX totals $60,000, pre-opening expense $10,000 and working cash $51,856. The deposit and opening stock tie up cash; they are not added again as monthly rent or consumed inputs. The reserve is a chosen fixed-cost buffer, not proof of full funding. Obtain actual installed/tax-inclusive quotes and dated opening payments.
Monthly fixed and variable OPEX
Stylist wages assume $22/hour, reception$18, each with an original 20% employer allowance. The roster is fixed here rather than a sales commission. If compensation follows commission or chair rental, rebuild costs/revenue instead of importing this payroll structure.
| Commitment | $ per month |
|---|---|
| Three stylists: loaded 160-hour rosters | 12,672 |
| Reception: loaded 160-hour roster | 3,456 |
| Rent/common charges | 3,000 |
| Utilities | 500 |
| Insurance | 350 |
| Software | 200 |
| Cleaning/laundry base | 350 |
| Marketing | 450 |
| Admin/fees | 250 |
| Maintenance | 200 |
| Total selected fixed cash | 21,428 |
| Item | $ per unit |
|---|---|
| Net collected selling value | 85 |
| Products per standard service | 8 |
| Incremental laundry/consumables | 2 |
| Percentage-only fee allocation (3%) | 2.55 |
| Contribution before scheduled payroll/fixed OPEX | 72.45 |
The percentage fee is an aggregate allocation, with no fixed per-payment charge assumed. Unit contribution is not owner income: the full listed monthly roster and overhead still need coverage.
Capacity, break-even and a lower-sales case
Three 160-hour stylists supply 480 paid hours;70% productive time leaves 336 one-hour comparable services. The chairs have 384 usable hours, so stylist time binds. Planned volume is 310 services; the average capacity is not proof that appointments line up without gaps.
For this fixed mix and commitment, whole-unit cash break-even is 296 completed standard cut/style services per month: ($21,428) ÷ $72.45, rounded up. The aggregate capacity is 336 units; it does not establish customer demand or a workable daily sequence.
| Paid units | Net sales $ | Selected result $ |
|---|---|---|
| 250 | 21,250 | -3,315.50 |
| 296 | 25,160 | 17.20 |
| 310 (planned) | 26,350 | 1,031.50 |
| 336 | 28,560 | 2,915.20 |
At 250 services, reception and scheduled stylists remain paid. An appointment promotion may move existing bookings instead of adding work; the retained guide's incremental service case helps separate that change from a whole-salon launch.
Practical KPI definitions
Measure net service sales per completed appointment and productive stylist hours/all paid stylist hours. Rebooking is a client-cohort measure, not an extra sale on the booking date. Keep color processing/chair occupancy separate from hands-on stylist time.
No retail product resale, tips, sales tax, debt, income tax or distributions are included. Customer receipts and replenishment are aligned within the selected month.
Method context: SBA business planning. All case prices, wages, cost ratios, reserve and capacity inputs above are original planning assumptions.
What the model covers
The official FinModelsLab listing describes an editable five-year Excel model for haircuts, blowouts, color, treatments and retail. Visits per day and operating days produce annual visits; service mix and category prices produce service revenue, with retail per visit added separately. Stated outputs include revenue and EBITDA forecasts, profit and loss, cash flow and break-even indicators.
Use stylist time to set the volume assumption
Our original 160-hour monthly case supports forty haircuts and forty three-hour color services, leaving $1,100 after selected commitments. If complete color slots take 3.5 hours, only 34 fit alongside those haircuts and the result falls to $590.
Build the stylist calendar from complete service slots before entering daily visits. Use category-specific product cost and the actual compensation arrangement for the chosen mix. The Hair Salon planning guide develops the original worked case.
Planning guide