Forecast Visits
Project visits per day or operating period, operating days, and monthly seasonality.
An editable Excel workbook forecasts five years from daily visits, operating days, seasonality, service mix, pricing, and extra revenue into financial outputs.
Use the workbook to translate your salon's service volume and pricing plan into revenue, costs, staffing needs, cash flow, and financial statements.
You edit the operating assumptions, and the model carries those drivers through the five-year forecast, three scenarios, and management reports.
The model builds a shared visit pool, allocates visits by service mix, applies category prices, adds enabled extra revenue once, and totals each period.
Project visits per day or operating period, operating days, and monthly seasonality.
Split the non-duplicated visit pool across service categories using the service mix.
Multiply each category's allocated visits by its editable service price.
Add enabled extra revenue per visit or service unit only once.
Sum category revenue and extra revenue across the forecast periods.
The Revenue Assumptions view sets launch timing, daily visits, operating days, seasonality, service mix, category prices, and extra revenue per visit.
REVENUE ASSUMPTIONS
The COGS & OPEX view separates direct service costs, variable expenses, and fixed operating expenses across the forecast schedule.
COGS & OPEX
The Scenario Analysis view compares Low, Base, and High cases for revenue, gross margin, contribution margin, and EBITDA across five years.
SCENARIO ANALYSIS
The Dashboard combines model setup, scenario controls, core financial outputs, revenue mix, profitability, cash flow, and investment payback charts in one view.
DASHBOARD
The ready-made model fits a shared visit-pool revenue structure, while materially different revenue mechanics, schedules, or reporting may call for custom modeling.
The template is a planning starting point, not a guarantee of performance.
Financial Models Lab can build or adapt a model when you need different revenue logic, operating schedules, or reporting than the ready-made structure.
ORDER A CUSTOM FINANCIAL MODELAfter checkout, you receive the editable Excel financial model as an instant download with five-year forecasts, scenarios, statements, and management views.
Update the salon's revenue, cost, staffing, capital, and financing assumptions in Excel.
Review the five-year model with monthly and annual operating and financial detail.
Compare Low, Base, and High cases through the model's scenario controls and report.
Use the income statement, cash flow statement, balance sheet, dashboard, and summary outputs.
The essential answers are visible in full, with no accordion clicks required.
The model forecasts a shared visit pool, allocates visits by service mix, multiplies category visits by prices, adds enabled extra revenue once, and totals the periods.
You can edit the launch date, visits per day, operating days, monthly seasonality, service mix, category prices, and enabled extra revenue per visit or service unit.
You can compare how alternative cases affect revenue, gross margin, contribution margin, and EBITDA across the five-year forecast.
The product shows an income statement, cash flow statement, balance sheet, Dashboard, Scenario Analysis, Summary, and other management reports.
Yes. Financial Models Lab offers custom financial modeling when you need different revenue logic, operating schedules, or reporting.
It is a planning forecast based on the assumptions entered into the workbook, not a guarantee of business performance.
Get immediate access to a complete, pre-built financial model template designed specifically for a hair removal salon.
Core inputs and core outputs
Three scenario analysis
Presentation ready
DuPont analysis
Researched revenue assumptions
Lender-friendly financial outputs
Revenue stream detailed view
Performance metrics benchmark
I’m not an Excel person, and this template made the setup feel manageable. The inputs were clear, so I saved about 6 hours and didn’t get stuck decoding formulas.
The cash-flow tabs made it much easier to see when we’d run short and what the runway looked like. I could map out a funding gap in one afternoon instead of guessing.
This model showed our margin and break-even point without extra digging, so we could make pricing decisions faster. It turned a messy estimate into something we could explain in a meeting.