$0.00

Hair Salon Financial Model Template in Excel

A full hair salon financial model in Excel and Google Sheets, ready to use after you enter your assumptions. It covers revenue, expenses, cash flow, and break-even in one editable file.
  • Fully Editable
  • Instant Download
  • Professional Design
  • Pre-Built
  • No Expertise Is Needed

The Hair Salon Financial Model is an Excel template for projecting service-only salon revenue, operating expenses and EBITDA across 2026–2030. It links staffed stylist hours, billable utilization, service mix and realized hourly revenue to the operating forecast.

The illustrative U.S. case uses four salaried stylists, four workstations, two wash units and 0.8 FTE for management and reception in about 1,200 square feet. Inputs are planning estimates for a midsize metro; no city or signed lease is selected.

Forecast
5years
Stylists
4scheduled positions
Service streams
5hour-based categories
WORKBOOK CONTENTS

Edit Salon Inputs and Review Linked Reports

The workbook connects operating assumptions, cost schedules and financing inputs to financial statements and management reports.

Revenue & Calc

Set launch timing, staffed positions, monthly hours, utilization, service allocations and hourly receipts. Revenue and Calc translate those assumptions into monthly sales and annual financial projections.

COGS & OPEX and Payroll

Plan product consumption, card fees, monthly overhead and role-based salaries. Separate cost schedules show how higher utilization changes EBITDA against a largely fixed staffing commitment.

CAPEX, CapTable & Debt

Record asset purchases, owner contributions and proposed financing. Dashboard debt controls feed repayment schedules; entering debt changes financing flows, not salon service revenue.

Statements and Dashboard

Use IS, CF and BS to review earnings, cash movement and financial position. Dashboard scenario controls compare Low, Base and High revenue and expense multipliers.

REVENUE FORECAST

Stylist Capacity and Utilization Determine Service Revenue

Monthly sold stylist hours equal scheduled positions multiplied by available hours per stylist and billable utilization.

Services share one pool of billable stylist hours, allocated once across five offerings. The revenue rates are realized net receipts per billable stylist hour, so they must not be treated as customer tickets or multiplied by a separate appointment forecast.

Revenue Forecast

The Revenue Forecast shows how staffing capacity, utilization, service mix and hourly rates build sales. Edit these drivers to test whether the salon can support its payroll and occupancy costs at the planned level of use.

2026 service allocation and realized hourly revenue
ServiceBillable hours shareNet revenue/hour
Haircuts and styling35%$65.00
Single-process color25%$85.00
Highlights and balayage20%$100.00
Blowouts and occasion styling12%$70.00
Treatments and texture8%$90.00

Estimated inputs; the weighted 2026 rate is $79.60 per billable stylist hour.

2026 capacity-to-revenue calculation

4 stylists × 160 hours/month × 50% utilization × $79.60/hour = $25,472 monthly revenue; 12 months = $305,664.

The month-based forecast includes sales from January 2026, the launch month for the January 31 start date. Utilization rises from 50% to 74% by 2030 while staffing, available hours and service shares stay constant; the annual hourly revenue rates also increase.

OPERATING COSTS

Separate Sales-Linked Costs From Fixed Salon Commitments

Direct supplies and card fees vary with sales, while payroll and scheduled overhead create a fixed cost base.

COGS and Operating Expenses

The COGS and Operating Expenses forecast separates backbar products at 9% of revenue, disposable supplies at 1.5% and card fees at 2.8%. Fixed categories cover occupancy, utilities, laundry, software, insurance, professional services, marketing, maintenance, licenses, education and communications.

Rent starts at $2,800 per month for 12 paid months; total fixed operating expenses are $60,360 in 2026. Salaries sit in Payroll, outside COGS, variable and fixed expenses, so the same salary is never charged twice.

Payroll Forecast by Staff Role

The Payroll Forecast calculates personnel costs from staffing and compensation assumptions. Four stylists at $42,000 each plus 0.8 manager/reception FTE at $44,000 per FTE produce $203,200 in annual base payroll.

STARTUP AND FUNDING

Opening Funding Covers More Than Salon Equipment

Startup assets, distinct prelaunch payments and working capital contribute to opening funding, separately from annual operating expenses.

Capital Expenditure Plan

The Capital Expenditure Plan schedules durable salon assets and depreciation. Listed investments include $9,000 for chairs and stations, $6,500 for wash units, $3,000 for tools and $35,000 for plumbing and fitout, plus other durable equipment.

Owner funding is estimated at $155,822. Its basis combines durable assets, separate prelaunch cash, launch physical net working capital and a three-month first-year cash expense reserve, with no committed nonowner funding.

Separate prelaunch cash items include a refundable lease deposit, registration permits, website setup, launch marketing, preopening training pay, rent and utility connection. These opening amounts are distinct from recurring operating costs.

Sources and Uses of Funds

The Sources and Uses of Funds report reconciles funding and cash allocation over a selected period. This salon case sets receivables at zero days, payables at 15 and inventory at 30; these timing inputs do not establish cash sufficiency.

ILLUSTRATIVE FINANCIAL PROJECTIONS

Higher Billable Utilization Expands the Illustrated EBITDA

The supplied five-year operating forecast reports revenue, total operating expenses and EBITDA in U.S. dollars.

Illustrative annual salon forecast, USD
YearRevenueOperating ExpensesEBITDA
2026$305,664$304,213$1,451
2027$377,801$315,618$62,182
2028$428,053$324,167$103,886
2029$467,611$331,349$136,262
2030$509,171$338,855$170,316

Illustrative projections, rounded to whole dollars; displayed totals may differ because of rounding.

EBITDA rises from $1,451 in 2026 to $170,316 in 2030 as revenue increases against constant $203,200 annual base payroll. The opening year has little EBITDA headroom; slower utilization or excluded employment costs could materially change that result.

Cash Flow Forecast

The Cash Flow Forecast separates operating, investing and financing cash movements and reconciles opening to closing cash. Review it for payment timing, asset purchases and funding; the EBITDA table does not establish net profit, closing cash or tested liquidity.

BREAK-EVEN AND INVESTMENT RETURNS

Evaluate Cost Coverage, Investment Recovery and Capital Returns

Separate reports support break-even, payback, annual ROIC and valuation analysis; the brief supplies no numerical results for these measures.

Break-Even, Payback and ROIC

The Returns report compares revenue against break-even requirements and tracks project free cash flow, cumulative recovery and invested capital. Use it to evaluate the consequences of salon capacity, overhead and funding assumptions.

Sales break-even identifies the revenue needed to cover modeled costs. Cash break-even concerns cash coverage, investment payback tracks recovery through cumulative project free cash flow, and annual ROIC measures returns on invested capital rather than an IRR.

Low, Base and High multipliers let you stress revenue, COGS, variable expenses, fixed expenses and payroll. Valuation separately uses discounted unlevered free cash flow, a terminal multiple and opening net debt; its sensitivities do not turn EBITDA directly into a business value.

MODEL FIT

Designed for an Independent Employer Hair Salon

This case fits a service-only salon built around shared salaried stylist capacity.

Use it for a new salon plan or an operating-budget review. Chair rentals, stylist commissions and retail product sales require an adapted revenue or cost structure; they are outside this supplied case.

COMMON QUESTIONS

Hair Salon Financial Model Questions Answered

These answers clarify editable assumptions, the illustrated business scope and the meaning of the outputs.

What can I edit in this Excel template?

Edit staffing, available hours, utilization, hourly revenue rates, service time shares, operating costs, payroll, startup spending, working-capital days and Dashboard scenario multipliers.

Does each service have separate customer demand?

No; each service receives a share of one sold stylist-hour pool, without a second appointment or customer-volume engine.

Are the hourly rates salon menu prices?

No; they are realized net revenue per billable stylist hour, so an appointment price cannot be substituted without accounting for the time it occupies.

Does the example include employment taxes or benefits?

No; the illustrated $203,200 annual base payroll excludes employer taxes and benefits, and personal taxes are also outside this pass-through business case.

Is the owner funding figure a guaranteed cash requirement?

No; the estimated $155,822 combines startup funding components and a three-month cash expense reserve, without establishing a tested minimum cash balance or borrowing requirement.

Does positive EBITDA establish payback or net profit?

No; depreciation, financing, taxes, capital spending and working-capital timing affect other measures, which require their own statement and Returns calculations.

Are these actual salon results or industry benchmarks?

No; the displayed results are illustrative projections from estimated inputs, and the workbook’s benchmark comparisons depend on the reference values entered by the user.

What Does the Hair Salon Financial Model Contain?

Financial Dashboard

KPIs, forecasts, and cash flow at a glance.

Revenue Engine

Key assumptions and calculations driving revenue forecasts.

Sources & Uses

Funding sources, spending, and closing cash.

Returns & Break-Even

Cash break-even, payback, and ROIC.

Business Valuation

DCF valuation and sensitivity analysis.

Expense Breakdown

Largest costs and spending trends.

Financial Summary

Annual and monthly financial performance.

KPI Benchmarks

Compare margins and returns to benchmarks.

Trusted by 25,000+ startup founders, investors and CPAs

Saved Hours On Setup

Megan Carter, TX

5 star rating

Building the salon model by hand would have taken me all week, but this template cut it down to an afternoon. I had a clean first draft ready for a lender call without chasing formulas.

Clear Cases Without The Guesswork

Derek Walsh, FL

4 star rating

Switching between low, base, and high cases used to be a mess. Here, the assumptions are easy to update, so I could compare all three scenarios in minutes and book a planning meeting the same day.

Margins And Break-Even In View

Nina Brooks, CA

5 star rating

I could finally see where the salon actually makes money and when it breaks even. That made our pricing discussion much clearer and saved me from digging through spreadsheets line by line.