Test the price, capacity and costs behind your med spa. Explore the online worksheet previews alongside calculations from the current illustrative business case.
4 online worksheet illustrations, described below
Opening budget, scenario assumptions and dashboard views
Five-year forecast and identified monthly operating sensitivity
Editable Excel product with assumptions and formulas
The online preview illustrates 4 planning sections using this website's scenario. These illustrations are separate from the downloadable workbook.
01RevenueThe current product page describes one shared visit pool, service-category allocation, prices, operating periods, seasonality and ancillary revenue once per visit.Explore layout ↓
02COGS & OPEX and PayrollProduct material identifies direct, variable and fixed operating costs, with payroll in the broader workbook. The online case explicitly funds clinical labor and owner governance.Explore layout ↓
03CAPEX and CapitalThe product gallery identifies capital investment and funding sections for adapting site, device and opening cash requirements.Explore layout ↓
04Statements and ScenariosThe product page identifies five-year monthly and annual projections, income statement, cash flow, balance sheet, dashboard and low/base/high scenario reporting.Explore layout ↓
Explore the online worksheet illustrations
Open each section to read the operating assumptions and illustration. These web views are not screenshots or downloadable Excel files.
Med SpaHTML illustration
EBITDA = Revenue − operating costs
Illustrative workbook layout · annual USD
Income statement
Year 1
Year 2
Year 3
Revenue
$950,300
$1,201,200
$1,404,000
Injectable products, treatment consumables, retail cost and payment fees
$361,114
$432,432
$491,400
Physician owner, NP, RN and reception incl. employer costs
$440,000
$475,000
$500,000
Premises, insurance, records, marketing and device maintenance
$170,000
$175,000
$180,000
EBITDA
−$20,814
$118,768
$232,600
EBITDA margin
-2.2%
9.9%
16.6%
Online scenario illustration; not a screenshot of the purchased workbook. Costs are shown as positive outflows; EBITDA excludes interest, tax, depreciation and amortization.
01RevenueOperating assumptions
Revenue
Scenario purpose: The current product page describes one shared visit pool, service-category allocation, prices, operating periods, seasonality and ancillary revenue once per visit.
Inputs
Completed treatment visits, opening calendar and launch timing
Neuromodulator, filler, laser hair removal and nonablative skin-treatment mix and prices
Realized ancillary skincare sales per completed visit
Outputs
Treatment-category revenue and total earned sales
Price, mix and nonduplicated visit reconciliation
Scope and limitations
Visible product description supports these mechanics; paid workbook formulas were not independently audited.
Qualified-person capacity, clinical eligibility and prepaid-service liabilities require separate operating checks.
02COGS & OPEX and PayrollOperating assumptions
COGS & OPEX and Payroll
Scenario purpose: Product material identifies direct, variable and fixed operating costs, with payroll in the broader workbook. The online case explicitly funds clinical labor and owner governance.
Inputs
Drug and filler acquisition, wastage, treatment supplies, retail cost and merchant fees
Paid physician, NP, RN, reception and employer costs
Lease, insurance, secure records, marketing, device service and compliance overhead
Outputs
Sales-linked versus fixed-cost bridge
Staffed clinical operating-cost plan
Scope and limitations
Procurement, wages, insurance and employer load are authored allowances needing actual quotes.
The model does not establish a legal ownership, prescribing or delegation arrangement.
03CAPEX and CapitalOperating assumptions
CAPEX and Capital
Scenario purpose: The product gallery identifies capital investment and funding sections for adapting site, device and opening cash requirements.
Inputs
Clinical fit-out, devices, storage and room equipment
Opening inventory, legal setup and launch cash
Funding sources, cash reserve and later replacement timing
Outputs
Opening uses and financing plan
Capital timing for the financial reports
Scope and limitations
This online allocation is independent of the seller’s premium example.
Device maintenance, financing, replacements and inventory payment timing need a dated cash schedule.
04Statements and ScenariosOperating assumptions
Statements and Scenarios
Scenario purpose: The product page identifies five-year monthly and annual projections, income statement, cash flow, balance sheet, dashboard and low/base/high scenario reporting.
Inputs
Verified local revenue, cost and staff assumptions
Capital and financing terms
Explicit alternative cases
Outputs
Five-year financial statements
Scenario comparisons and management reports
Scope and limitations
No completed purchase or paid-file delivery test was performed.
The online operating proxy excludes depreciation, debt, income tax, replacement investment and working-capital timing.
Ways to prepare your files
Template
Current product · Shopify checkout
Edit the financial model with your own assumptions.
Define the revenue drivers, operating modules, outputs and review criteria before agreeing the work.
Project quote · Schedule agreed with you
Assumptions you can change
These inputs drive the website business case. The purchased workbook has its own assumptions and examples; adapt them to your operating scope. Range endpoints represent modeled scopes or sensitivities, not measured national averages.
Med Spa input assumptions · USD unless stated
Driver
Base input
Scenario range / treatment
Role in the calculation
Net sales per completed treatment visit
$450.00
$350.00 – $550.00
Revenue per sold unit
Completed treatment visits per day
12
7 – 16
Daily throughput in the stated operating scope
Operating days per week
5
4 – 6
Trading schedule
Fixed operating costs / month
$56,667
Held constant
Operating break-even threshold
Contribution margin
65.0%
Held constant
Share of sales available for fixed costs
Starting share of mature volume
50.0%
Base ramp input
Opening month revenue
Mature volume added / month
5.0%
Base ramp input
Monthly ramp increment, capped at mature volume
Ramp horizon
18 months
Base ramp input
Period checked for operating break-even
The opening budget and annual expense inputs also need local quotes and staffing estimates. This page shows fixed examples; the free calculator lets you change price, volume and trading days.
Volume-only sensitivity · revenue at mature volume · monthly USD
Scenario
Daily units
Monthly revenue
Break-even revenue
First operating break-even
Lower volume
7
$68,198
$87,180
Not reached
Base volume
12
$116,910
$87,180
Month 6
Higher volume
16
$155,880
$87,180
Month 3
Only completed treatment visits per day changes. Net sales per completed treatment visit: $450.00; 5 operating days per week. Fixed costs and contribution margin stay constant. “Not reached” means no operating break-even within the 18-month ramp. Annual revenue and EBITDA use the annual forecast. Break-even uses a separate monthly calculator sensitivity; it does not establish when the annual forecast covers its costs. Slider cases do not change the annual forecast or measure cash payback.
Sample outputs from the current case
These results are calculated from the website’s illustrative assumptions. They illustrate planning calculations; they do not establish the purchased workbook’s formula behavior.
01 / Annual forecast
Revenue across five years
$950.3k
Year 1
$1.2m
Year 2
$1.4m
Year 3
$1.6m
Year 4
$1.7m
Year 5
Annual USD. Full values appear in the Dashboard presentation.
02 / Opening allocation
Where the opening budget goes
Leasehold work, accessible clinical layout and utilities$150,000
Laser and nonablative treatment equipment$125,000
Treatment chairs, clinical storage and room equipment$35,000
Reception, secure records, booking and IT setup$25,000
Opening injectable products, supplies and skincare inventory$55,000
Legal structure, permissions, deposits and insurance setup$45,000
Recruiting, clinical training and launch preparation$40,000
Protected working capital reserve$175,000
One-time budget: $650,000. This allocation is not a cumulative cash-flow forecast.
03 / Operating earnings
Year 3 costs and EBITDA
Against annual revenue of $1,404,000.
Injectable products, treatment consumables, retail cost and payment fees$491,400
Physician owner, NP, RN and reception incl. employer costs$500,000
Premises, insurance, records, marketing and device maintenance$180,000
EBITDA$232,600
EBITDA margin: 16.6%. EBITDA is not cash available to the owner.
04 / Operating threshold
Volume needed to break even
Required whole units per day
9
Break-even revenue / month
$87,180
Base revenue / month at maturity
$116,910
First operating break-even
Month 6
Units mean completed treatment visits per day. The ramp covers 18 months; operating break-even does not measure recovery of opening capital.
Annual revenue and EBITDA use the annual forecast. Break-even uses a separate monthly calculator sensitivity; it does not establish when the annual forecast covers its costs. The website does not yet supply a complete funding, debt, tax and working-capital schedule for a cumulative cash-flow or payback chart. Read the full input basis and limitations.
Annual forecast and monthly operating reconciliation
Annual revenue and EBITDA use the annual forecast. Break-even uses a separate monthly calculator sensitivity; it does not establish when the annual forecast covers its costs.
Original inputs · annual USD · whole-dollar rounding tolerance $5
Check
Annual forecast
Monthly calculator base
Year 1 revenue
$950,300
$1,081,418
Year 1 operating result
−$20,814
$22,917
Year 2 revenue
$1,201,200
$1,402,920
Year 2 operating result
$118,768
$231,894
Year 3 revenue
$1,404,000
$1,402,920
Year 3 operating result
$232,600
$231,894
Year 3 / full-volume annual revenue
$1,404,000
$1,402,920
Year 3 / full-volume annual operating result
$232,600
$231,894
Year 1 uses months 1–12, Year 2 months 13–24 and Year 3 months 25–36. Full-volume rows use mature monthly sales and operating result × 12. The calculator holds price, days, contribution and fixed costs constant; an annual price, staffing or cost change can explain a separate path. Sliders do not change this comparison. Neither column measures cash flow, owner distributions or payback. Agreement tests arithmetic, not demand or cash funding. Input basis.
Both products in one cart
Model + Business Plan
Write the strategy and test the assumptions for your med spa together. Update the narrative when you change the forecast.
The Business Plan uses Word and the Financial Model uses Excel. The online illustrations use this website's scenario data and may differ from the purchased files.
File format
XLSX
Editor
Microsoft Excel
Editing
Input cells, forecast assumptions and formulas; workbook behavior still needs verification.
Other software
Compatibility with alternative editors has not been verified.
Delivery and terms
Review the product description, delivery details, license and final total in Shopify before paying.
Use the purchase button to buy the Med Spa Financial Model for $109 through Shopify. This is a one-time price in USD before any applicable taxes.
What do the online previews show?
The online preview explains Revenue, COGS & OPEX and Payroll, CAPEX and Capital, Statements and Scenarios using this website's illustrative case. It is separate from the downloadable Excel model.
Are these previews pages from a finished file?
The web previews are rendered from the website's case record. They illustrate planning concepts and calculations; they are not screenshots or a page-by-page inventory of the downloadable product.
What would I need to change for my business?
Review net sales per completed treatment visit, completed treatment visits per day, the operating schedule, opening budget and costs. These web previews do not edit a workbook. Test the website's price and volume assumptions in the business idea page's calculator.
Is the written business plan included?
The Financial Model is sold separately. The $168 Bundle adds the $59 Business Plan and $109 Financial Model for the same business to one cart, one of each.
Do the figures establish what my business will earn?
No. The figures describe an illustrative U.S. operating case, not measured industry averages or a prediction for your location. EBITDA is not owner cash, and operating break-even does not recover the opening investment. Check local costs, capacity and demand before using the assumptions.
