Trusted by 25,000+ startup founders, investors and CPAs
Saved Me Hours
Megan Carter, CA
Building the spa model by hand would have eaten up my whole week, and this template cut that down fast. I had a clean forecast ready in a few hours instead of chasing formulas all day.
Scenario Planning Got Simple
Derek Johnson, TX
I used to dread setting up low, base, and high cases, but this model made the comparisons easy to follow. It saved me a full day of back-and-forth and gave me clearer assumptions for our meeting.
A Real Starting Point
Lauren Mitchell, FL
Starting from a blank sheet felt overwhelming, and this template gave me a structure I could actually work with. I went from stuck to sending a first draft to my partner the same afternoon.
MODEL OVERVIEW
What Is the Financial Model Day Spa?
The Day Spa financial model is an editable five-year Excel workbook that provides revenue from services based on a visit and prepares financial statements, scenarios and management reports.
Use the workbook to translate expected day visits, combination of services, prices, operating days, seasonality, costs, staff and capital needs into structured financial forecasts.
The operational editable assumptions form the basis for the model calculation, which then translates into monthly forecasts, financial statements, scenario comparisons and management opinions.
Built around service visitsOne group of visits is allocated in different categories of services before pricing and additional revenue is applied.
DAY OF THE INCOME FROM SPA SERVICES
How Does the Model Spa Day Calculate Revenue?
Revenue starts with a common pool of domain-spa visits, converts the quantity by business days and seasonality, allocates visits by service combination, applies prices and adds included allowances once.
01
Expected Visits
Set service visits to the day or period from the start date.
02
Build Volume
Convert rates of visits to the monthly and annual number of services using working days and seasonality.
03
Mixing
Split the common amount of visits into categories of services using a basket of services.
04
Use of the Price
Multiple allocated visits by price category and add possible additional revenue per visit once.
05
Total Revenue
Total of the categories of services and additional revenue for each forecast period for total revenue.
FORM OF CORRECTIONRevenue = Assigned units × Service price + Service units × Additional revenue
01 / REVENUE
How Are the Day Insights Organized?
The revenue worksheet shall organise the starting date, daily visits, working days, seasonality, service prices, a category basket and additional revenue in the service forecast.
REVENUE
The revenue view shows the size of visits, the prices of services, mix, seasonality and additional revenues.
02 / COGS & OPEX
How's Spa Day Organized?
The COGS & OPEX worksheet separates direct services costs, variable costs and fixed operating costs, thus providing the cost assumptions to the expected margins and cash needs.
COGS & OPEX
View COGS & OPEX separates direct, variable and fixed assumptions of operating costs.
03 / SCENARIOS
What Can Be Compared to Scenario Analysis?
The Scenarios compared the low, base and high cases in terms of revenue, gross margin, premium margin and EBITDA in the five-year forecast.
SCENARIOS
The scenario view covers small, basic and high cases of key financial resources.
04 / DASHBOARD
What Does the Distribution Board Have in Common?
The table includes control of scenarios, basic finances, income set, profitability, cash flow, working capital contributions, debt assumptions and return on investment in one management way.
DASHBOARD
The table contains scenario settings, financial results, revenue mix, cash flow and return graphs.
FIT OF PRODUCTS
Is Day Spa Financial Model Suitable for You?
This template matches those companies whose income is consistent with a single shared service pool; structural differences in revenue logic or reporting requirements may require non-standard modelling.
MODEL BY MADA READY
Good Example
Your income starts with one common amount of days of visits or service units.
You want to allocate visits to different categories of services using a editable service basket.
Price of services by category and can add additional revenue for the visit once.
You need five-year statements, low-base/high cases, and management reports from the entry to the edition.
CUSTOMS STRUCTURE
Consider Custom Pattern
You require revenue mechanics that do not use a single pool of service units.
You need important different operational schedules or computational logic for your company.
You require a reporting structure outside the workbook views shown for this template.
You want a model tailored to requirements that change the structure of the template.
The template is the starting point of planning, not a guarantee of performance.
FINANCIAL MODEL SERVICE
Do You Need a Model Built Around Your Requirements?
The Financial Models Laboratory can build or customize a financial model when your company needs different revenue logic, operating schedules or reporting from a ready-made template.
After the order you will receive an editable financial model Excel for immediate download with five-year projections, scenario analysis, declarations and management reporting.
01
Editable workbook
Open and change Excel's assumptions for your own day plan.
02
Five-year forecast
Review of the financial forecast 60-a monthly financial forecast with multi-annual reporting throughout the planning horizon.
03
Analysis of scenarios
Compare low, base and high cases using the workbook scenario framework.
04
Financial statements
Overview of the income account, cash flow, balance sheet, dashboard and other model reports.
BEFORE BUYING IMPORTANT INFORMATION
Day Spa Financial Model FAQ
The basic answers are visible in their entirety, without clicking on the accordion.
01
How Does the Day Spa Financial Model Calculate Revenue?
It provides a common pool of service visits, transforms volume using operating days and seasonality, allocates visits according to a combination of services, applies category prices and adds additional revenue once.
02
What are the assumptions that can be changed in Spa?
You can change the start date, average visits per day or period, working days, monthly seasonality, combination of services, service prices and allow additional revenue from visits or service units.
03
What can I compare in Low, Base and High scenarios?
The Scenarios compared the low, base and high cases in terms of revenue, gross margin, premium margin and EBITDA in the five-year forecast.
04
What financial results are taken into account?
Product Presents Income Statement, Cash Flow Statement, Balance Sheet, Distribution Board, Scenarios, Summary, Action Aprons, ROIC, Charts, KPIs, Valuation and Other Reporting Opinions.
05
Can the Financial Models Lab adapt it to its own requirements?
Yes. The financial models Lab offers custom financial modelling when you need different revenue logic, operating schedules or reporting structures.
06
Is this a forecast or a guarantee?
This is a planned forecast based on the possible editing assumptions, not a guarantee of the results of business activity or financial results.
What Does the Day Spa Financial Model Contain?
You get a comprehensive day spa financial model with a dynamic dashboard, 5-year projections, detailed cost breakdowns, and a complete set of financial statements.
All-in-one Dashboard
Core inputs and core outputs
Low/Base/High
Three scenario analysis
Professional Charts
Presentation ready
ROE Components
DuPont analysis
Revenue Inputs
Researched revenue assumptions
Bank-Ready Reports
Lender-friendly financial outputs
Revenue Breakdown
Revenue stream detailed view
KPI Dashboard
Performance metrics benchmark
Choosing a selection results in a full page refresh.
REVENUE
COGS & OPEX
SCENARIOS
DASHBOARD
