This editable five-year workbook forecasts medical spa visits, service mix, pricing, costs, and financing into monthly and annual statements, scenarios, and management reports.
Use the workbook to translate expected client visits and service choices into a structured forecast for revenue, operating costs, staffing, capital needs, and cash flow.
Change launch timing, visit volume, operating days, seasonality, service mix, category pricing, and extra revenue assumptions; linked schedules update the financial outputs.
Built around service visitsOne shared visit pool is allocated across service categories before pricing, so visits are not duplicated across revenue lines.
MEDICAL SPA REVENUE ENGINE
How Does the Medical Spa Calculate Revenue in This Model?
Revenue starts with one shared pool of service visits, converts volume by operating periods and seasonality, allocates visits by service mix, prices each category, and adds enabled extra revenue once.
01
Build Visit Volume
Forecast visits per day or period, then apply operating periods and seasonality.
02
Allocate Service Mix
Distribute the shared visit pool across service categories using the selected mix.
03
Price Services
Multiply each category’s allocated visits by its editable service price.
04
Add Extra Revenue
Apply enabled extra revenue once for each visit or service unit.
05
Calculate Revenue
Sum service-category revenue and extra revenue across the forecast periods.
CORE FORMULARevenue = Service units × Weighted service price + Service units × Extra revenue
01 / REVENUE
How Do You Set the Medical Spa Revenue Inputs?
The Revenue worksheet captures launch timing, visit volume, operating days, seasonality, service prices, service mix, and extra revenue assumptions that drive the forecast.
REVENUE
The Revenue view shows visit assumptions, service pricing, mix allocation, seasonality, and extra revenue inputs.
02 / COGS & OPEX
How Are Medical Spa Costs Structured?
The COGS & OPEX worksheet separates direct costs, variable expenses, and fixed operating expenses with timing and periodicity inputs feeding the monthly forecast.
COGS & OPEX
The COGS & OPEX view separates direct costs, variable expenses, fixed expenses, and monthly timing.
03 / SCENARIOS
How Can You Compare Alternative Medical Spa Cases?
The Scenarios report places Low, Base, and High cases side by side so you can compare forecast revenue, margins, and EBITDA under alternative assumptions.
SCENARIOS
The Scenarios view compares Low, Base, and High revenue and margin outcomes across five years.
04 / DASHBOARD
What Does the Medical Spa Dashboard Show?
The Dashboard combines model setup, scenario controls, core financial outputs, revenue mix, profitability, cash flow, and investment payback charts in one management view.
DASHBOARD
The Dashboard combines scenario controls, core financials, revenue mix, profitability, cash flow, and payback charts.
PRODUCT FIT
Is the Medical Spa Financial Model Right for Your Business?
The ready-made model fits visit-driven medical spa operations using shared service volume, while structurally different revenue logic or reporting may call for custom modeling.
READY-MADE MODEL
A Good Fit
You forecast one shared pool of client visits or service units by operating period.
You allocate that volume across service categories using an editable service mix.
You price service categories separately and may add extra revenue once per visit.
You need linked costs, scenarios, statements, and management reporting from editable assumptions.
CUSTOM STRUCTURE
Consider Custom Modeling
Your revenue depends on subscriptions, cohorts, contracts, inventory sales, or another structurally different engine.
You need several independent capacity pools instead of one shared service-unit pool.
You require operating schedules that differ materially from visits, service mix, pricing, and seasonality.
You need a reporting structure or calculation flow built around requirements outside this template.
The template is a planning starting point, not a guarantee of performance.
CUSTOM FINANCIAL MODELING SERVICE
Need a Model Built Around Your Requirements?
Financial Models Lab can build or adapt a financial model when your revenue logic, operating schedules, or reporting requirements differ from the ready-made structure.
After checkout, you receive the editable Medical Spa financial model for download, with five-year projections, scenarios, and linked financial reports.
01
Editable workbook
Open and edit the financial model in Microsoft Excel or Google Sheets.
02
Five-year forecast
Review five years of projections with monthly and annual financial detail.
03
Scenario analysis
Compare Low, Base, and High cases through the model’s scenario analysis view.
04
Financial reports
Review linked income statement, cash flow, balance sheet, summary, and management outputs.
BEFORE YOU BUY
Medical Spa Financial Model FAQ
The essential answers are visible in full, with no accordion clicks required.
01
How does the Medical Spa Financial Model calculate revenue?
It forecasts one shared visit pool, applies operating periods and seasonality, allocates visits by service mix, multiplies category visits by service prices, and adds enabled extra revenue once.
02
Which assumptions can I change?
You can edit the launch date, visits per day or period, operating periods, monthly seasonality, service mix, service prices, and enabled extra revenue per visit or service unit.
03
What can I compare in the Low, Base, and High scenarios?
The Scenarios view compares alternative Low, Base, and High cases across revenue, gross margin, contribution margin, and EBITDA over the forecast.
04
Which financial outputs are included?
The product shows an income statement, cash flow statement, balance sheet, Dashboard, Summary, and additional financial analysis reports in its workbook gallery.
05
Can Financial Models Lab adapt the model to custom requirements?
Yes. Financial Models Lab offers custom financial modeling for requirements involving different revenue logic, operating schedules, or reporting structures.
06
Is this workbook a forecast or a guarantee?
It is a planning forecast based on editable assumptions, not a guarantee of business performance or future results.
What Does the Medical Spa Financial Model Contain?
You get a complete, easy-to-use financial planning spreadsheet designed specifically for a medical aesthetics clinic.
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
Trusted by 25,000+ startup founders, investors and CPAs
Scenario Planning Made Simple
Megan Carter, FL
I could finally compare low, base, and high cases without rebuilding the sheet every time. It saved me hours and made it much easier to present assumptions in one meeting.
Runway Was Easy To See
Derek Wilson, TX
The cash-flow tab made it clear when we’d run short and how long we had left. I booked a planning call with my partner the same day because the runway picture was finally easy to read.
Cleaner Models, Fewer Errors
Priya Shah, CA
I stopped worrying about one broken formula throwing off the whole model. The structure helped me catch issues fast and cut my review time by about half.
Choosing a selection results in a full page refresh.
REVENUE
COGS & OPEX
SCENARIOS
DASHBOARD
