SmartHelping / Medical Spa / Excel
Med Spa Startup Financial Model
Plan a medical spa from opening costs to repeat-client profitability. Connect marketing, treatment demand, provider hours, rooms, and equipment to a five-year forecast of revenue, expenses, cash needs, and investment returns.
Immediate download after purchase. By purchasing, you agree to the Terms of Service.
See the model in action
Walk through the Med Spa Financial Model.
Build a plan around your clinic
Test the operating plan before committing capital.
A single-location startup forecast
Model one leased medical spa over 60 monthly periods, including the pre-opening period, with annual financial summaries.
Base, downside, and upside cases
Change the selected case to test a different set of operating assumptions and see the effect on the forecast.
Editable treatment and staffing inputs
Start with the clinic assumptions, treatment menu, staff plan, and capital expenditure plan. Customize the inputs around your proposed location.
A focus on repeat-client economics
Review how repeat visits contribute toward scheduled payroll, rent, equipment upkeep, and clinic overhead as the business develops.
From marketing to completed treatments
Connect customer demand to the capacity to serve it.
The forecast connects client acquisition and repeat visits with the time available from your providers, treatment rooms, and devices.
New-client funnel
Paid marketing and organic leads feed consultation bookings and treatment conversion. Consultation time uses clinician and room capacity before treatment activity is scheduled.
Repeat-client activity
Build the active repeat-client pool using completed first visits, repeat-client conversion, and attrition. Visit frequency and seasonality determine repeat-treatment demand.
Provider, room, and device limits
Device availability, provider hours, and shared room capacity constrain booked treatments. Appointment time consumes scheduled capacity, while no-shows reduce completed treatments and revenue.
Unserved demand
See appointment demand that exceeds available capacity. Unserved demand is treated as lost activity in the forecast rather than carried forward as a waiting list.
Service revenue, product sales, and operating costs
Build revenue and expenses from their underlying drivers.
Six editable treatment categories
The starting menu includes neuromodulator, dermal filler, laser hair removal, facial/skin care, microneedling, and laser skin treatments. Adjust prices, treatment mix, resource requirements, and direct costs.
New and repeat treatment revenue
Completed new-client and repeat-client treatments drive service revenue. Review the contribution of each group as the client base develops.
Retail and prepaid treatment credits
Include retail product sales and prepaid treatment credits. The model tracks advance collections, credit redemptions, and the remaining prepaid liability separately.
Treatment-level variable costs
Connect service activity to products, consumables, provider incentives, and other direct costs. Include payment processing and the cost of retail products.
Staffing and fixed overhead
Plan employee roles, hiring timing, compensation, and employer payroll burden. Include rent, marketing, medical oversight, insurance, and other clinic overhead.
Equipment, inventory, and working capital
Schedule capital purchases and depreciation, plan inventory needs, and account for collection and supplier payment timing in the cash forecast.
Startup capital and ongoing liquidity
Plan how the clinic is funded and when cash can be distributed.
Dynamic sources and uses
Review funding sources and cash requirements through the model’s peak funding point. Trace equipment, inventory, deposits, pre-opening spending, and operating cash needs into the equity funding requirement.
Term loan and equipment financing
Set operating term-loan assumptions and equipment financing terms. Follow loan draws, interest, principal repayment, and remaining balances through the forecast.
Revolver and equity support
Model a revolving credit facility and later equity contributions subject to their limits. Review remaining funding gaps when available capital is insufficient.
Cash retention and distributions
Set minimum operating cash, cash retained against prepaid liabilities, distribution timing, and the share of available cash distributed. Distributions also require the revolver to be fully repaid.
Financial statements, operating KPIs, and returns
Review the clinic from operating performance through exit value.
Integrated financial statements
Review monthly and annual income statements, balance sheets, and cash flow statements, supported by operating, asset, debt, tax, and cash schedules.
KPI dashboard and visualizations
Review new and repeat visits, client retention, capacity utilization, revenue, margins, cash, and debt-service coverage. Track repeat-client contribution against fixed operating costs.
Equity summary
Follow equity contributions, distributions, and exit proceeds. Review equity XIRR, multiple on invested capital, and NPV using the timing of those cash flows.
DCF and valuation comparisons
Review project cash flow and discounted cash flow valuation alongside a football-field comparison of valuation approaches.
Optional Year 5 exit
Include or exclude a sale at month 60. Select a continuing DCF, EBITDA multiple, or revenue multiple approach and account for sale transaction costs.
Valuation and repeat-business sensitivities
Test WACC versus growth, EBITDA multiples versus EBITDA changes, and attrition versus visit frequency. The repeat-business grid shows unconstrained steady-state coverage; the main cases include the full capacity-constrained forecast.
Also included in these collections
Explore the Med Spa model as part of a bundle.
Industry-Specific Financial Model Bundle
This Med Spa Financial Model is included in the Industry-Specific Bundle, alongside operating models built around the drivers of different businesses.
View the Industry-Specific BundleSuper Smart Bundle
This model is also included in the Super Smart Bundle, the complete public SmartHelping collection of financial models, calculators, and trackers.
View the Super Smart BundleQuestions before you start
A few useful details.
What type of business does this model cover?
A startup medical spa operating from one leased location. The forecast covers 60 months from the selected start date, including any pre-opening months.
Can I customize the treatments and staffing plan?
Yes. The workbook includes editable treatment, staff, and capital expenditure inputs so you can tailor the forecast to your clinic’s operating plan.
Does the model limit revenue based on capacity?
Yes. Completed treatments are constrained by the applicable device, provider, and room capacity. Demand above those limits remains visible as unserved demand.
How are prepaid treatment credits handled?
The model separates cash collected in advance from revenue recognized as credits are redeemed for eligible services. It tracks the remaining prepaid balance and the cash retention policy you select.
Does it include financing and investment returns?
Yes. It includes term and equipment debt, revolving credit, equity support, cash distributions, and an optional Year 5 sale, with valuation and equity return outputs.
Which bundles include this model?
The Med Spa Startup Financial Model is included in the Industry-Specific Bundle and the Super Smart Bundle linked above.
Plan your medical spa startup
Connect the clinic you want to build to the capital it needs.
Med Spa Startup Financial Model — $45, delivered as an Excel download.
