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.

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.
The workbook connects operating assumptions, cost schedules and financing inputs to financial statements and management reports.
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.
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.
Record asset purchases, owner contributions and proposed financing. Dashboard debt controls feed repayment schedules; entering debt changes financing flows, not salon service revenue.
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.
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.
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.
| Service | Billable hours share | Net revenue/hour |
|---|---|---|
| Haircuts and styling | 35% | $65.00 |
| Single-process color | 25% | $85.00 |
| Highlights and balayage | 20% | $100.00 |
| Blowouts and occasion styling | 12% | $70.00 |
| Treatments and texture | 8% | $90.00 |
Estimated inputs; the weighted 2026 rate is $79.60 per billable stylist hour.
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.
Direct supplies and card fees vary with sales, while payroll and scheduled overhead create a fixed cost base.
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.
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 assets, distinct prelaunch payments and working capital contribute to opening funding, separately from annual operating expenses.
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.
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.
The supplied five-year operating forecast reports revenue, total operating expenses and EBITDA in U.S. dollars.
| Year | Revenue | Operating Expenses | EBITDA |
|---|---|---|---|
| 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.
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.
Separate reports support break-even, payback, annual ROIC and valuation analysis; the brief supplies no numerical results for these measures.
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.
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.
These answers clarify editable assumptions, the illustrated business scope and the meaning of the outputs.
Edit staffing, available hours, utilization, hourly revenue rates, service time shares, operating costs, payroll, startup spending, working-capital days and Dashboard scenario multipliers.
No; each service receives a share of one sold stylist-hour pool, without a second appointment or customer-volume engine.
No; they are realized net revenue per billable stylist hour, so an appointment price cannot be substituted without accounting for the time it occupies.
No; the illustrated $203,200 annual base payroll excludes employer taxes and benefits, and personal taxes are also outside this pass-through business case.
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.
No; depreciation, financing, taxes, capital spending and working-capital timing affect other measures, which require their own statement and Returns calculations.
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.
KPIs, forecasts, and cash flow at a glance.
Key assumptions and calculations driving revenue forecasts.
Funding sources, spending, and closing cash.
Cash break-even, payback, and ROIC.
DCF valuation and sensitivity analysis.
Largest costs and spending trends.
Annual and monthly financial performance.
Compare margins and returns to benchmarks.
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.
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.
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.