Turn appointment demand into a break-even plan.
How many clients does a medical spa need to break even? The answer depends on what each completed visit contributes, how often clients return, and how much it costs to keep the clinic open.
In the illustrative example below, the November operating break-even threshold is approximately 209 completed appointments, assuming that month’s new-client activity, treatment economics and retail contribution. The forecast delivers about 225 appointments and earns $3,527 of EBITDA.
Explore the $45 Med Spa Excel ModelAbout this example: These are projections from the Base case of SmartHelping’s single-location Med Spa Financial Model, not results from an operating clinic or industry benchmarks. The example forecast starts in January 2027 and opens in March. Dollar amounts below are in actual dollars; displayed figures are rounded.
Start with visits, then translate them into clients.
A client and an appointment are different units. One person may return several times during a year, while another completes a consultation and never books a treatment. A database of 1,000 names does not tell you how many revenue-producing appointments the clinic will complete next month.
Build the forecast around first treatments and repeat treatments. Then estimate the active client pool needed to generate those visits. Keep consultations, booked treatments and completed treatments separate so that cancellations and capacity limits do not disappear from the plan.
Monthly fixed operating costs ÷ weighted contribution per completed appointment = completed appointments required.
Contribution is the amount left after variable costs. Deduct treatment products, consumables, variable provider incentives and relevant payment fees before using revenue to cover payroll, rent and overhead. Count scheduled provider salaries in fixed costs if they are already included there; avoid charging the same labor twice.
A worked example: the first profitable operating month.
In November 2027, the model forecasts approximately 87.9 first visits and 137.5 repeat visits. Combined with retail sales, that produces $84,525 of revenue. Recurring fixed operating costs are $45,476, and each completed repeat treatment contributes approximately $209.73 before those fixed costs.
The workbook asks a more specific question: with first-visit and retail contribution held constant, how many repeat appointments cover the remaining recurring costs?
($45,476 fixed costs − $18,080 first-visit contribution − $2,000 retail contribution − $75 prepaid-card-fee timing credit) ÷ $209.73
≈ 121 completed repeat visits
Add approximately 88 first visits and the threshold is about 209 completed appointments. The projected 225 appointments exceed it. This is a conditional threshold: changing first visits, retail sales, treatment mix or costs changes the answer. The small card-fee adjustment reconciles processing costs collected on prepaid packages with normalized treatment contribution.
| 2027 month | First visits | Repeat visits | Repeat visits needed* | EBITDA |
|---|---|---|---|---|
| September | 79.9 | 95.9 | 130.9 | −$7,340 |
| October | 83.9 | 115.8 | 125.8 | −$2,111 |
| November | 87.9 | 137.5 | 120.7 | $3,527 |
| December | 83.9 | 147.2 | 123.6 | $4,984 |
*Holds each month’s first-visit and retail contribution constant. Fractional visits are forecast averages; round required appointments up when setting a whole-appointment target. Operating break-even excludes depreciation, financing costs, income taxes, working-capital changes and capital spending.
Can repeat clients cover the clinic by themselves?
Reaching positive EBITDA with new and returning clients is one milestone. Having repeat-treatment contribution cover fixed operating costs is another. In November, repeat treatments contribute $28,847 against $45,476 of recurring fixed costs: only 63.4% coverage. First visits and retail still help the clinic reach operating break-even.
By June 2028, projected repeat-treatment contribution reaches $49,036 against $47,732 of recurring fixed costs, or 102.7% coverage. That provides a different view of resilience: how much of the clinic’s cost base is supported by returning patients?
Recreated from the workbook’s KPI dashboard. Each bar uses a 0–150% scale; the dashed line marks 100% coverage. Annual ratios divide annual repeat-treatment contribution by annual recurring fixed operating costs. They exclude debt service.
Repeat visits still require consumables, provider time and equipment. Strong retention does not make those visits costless. It improves the amount of future demand supported by an established client base.
Translate repeat appointments into an active client pool.
The Base case assumes 0.35 repeat visits per active client per month, 3.5% monthly attrition and a 6% treatment no-show or cancellation rate. These are editable planning assumptions. Visit frequency is an average across the client pool, not a recommended treatment schedule for any individual.
For a separate, simplified illustration, suppose your target is 200 completed repeat visits in a neutral-season month. With no capacity constraint, the surviving active pool would need to be approximately:
This illustration uses the pool after attrition and is not the workbook’s November break-even output. The full forecast also accounts for seasonality, new clients joining the repeat pool and available treatment capacity. Track repeat-visit share separately from client retention: they measure different things.
Check whether the clinic can deliver the required visits.
A break-even target is useful only if the operating plan can support it. The model limits booked treatments using provider hours, room hours and device availability. Consultations consume clinician and room time before treatment activity, and booked treatments consume capacity even when no-shows reduce completed visits.
In the example, average provider booked utilization reaches 100% in Year 5, while room utilization is approximately 91.6%. The forecast shows about 2,293 appointments of capacity-unserved demand during that year. Those are demand units the model cannot schedule, not completed visits or recognized revenue.
Adding a room alone may not solve a provider bottleneck. Evaluate staffing, scheduling and equipment constraints together. Also budget the costs of expansion explicitly: additional room capacity is not a substitute for entering the associated buildout, equipment, staffing and occupancy costs.
Treatment mix changes the break-even target.
Two clinics with the same number of appointments can produce different profit. Prices, product costs, appointment length and provider requirements change the contribution earned per visit and per scarce hour.
In the model’s illustrative Year 5 mix, dermal filler contributes approximately $449 per booked provider hour, versus $159 for facial and skin-care treatments. These are scenario outputs, not market benchmarks or treatment recommendations. They show why average revenue per patient alone is insufficient.
Compare contribution within the relevant provider and device constraints. A high-margin service may require a specific clinician or machine, and different services cannot always substitute for one another. Build the plan around appropriate care and the service mix your clinic can actually deliver.
Positive EBITDA does not mean the startup is fully funded.
The example opens in March and first produces positive monthly EBITDA in November: forecast month 11 and the ninth operating month. Earlier losses still matter. Year 1 EBITDA remains negative $174,199 despite the positive November and December results.
The equity figure includes $150,000 at time zero and approximately $158,800 of later contributions. Debt also supports the example: Year 1 includes $173,500 of term and equipment loan proceeds plus $50,000 drawn on the revolver. Equity required is therefore not the same as total project spending.
Review principal payments, interest, inventory, collection timing, deposits, capital purchases and minimum cash alongside operating profit. Prepaid packages also need care: cash arrives before all services are delivered. Selling a package does not make its entire cash receipt earned treatment revenue.
Stress-test the assumptions before opening.
Use the monthly forecast to test whether the clinic remains adequately funded when repeat demand builds more slowly. Start with these questions:
- Client acquisition: What happens if leads cost more or fewer consultations become first treatments?
- Retention: How much additional funding is needed if fewer first-time clients return and monthly attrition rises?
- Capacity: Does hiring another provider unlock enough completed treatments to justify the added payroll?
- Cash: Can the clinic maintain its cash reserve while paying debt and funding inventory?
The workbook’s Downside assumptions include 6.5% monthly attrition and 0.28 repeat visits per active client, compared with 3.5% and 0.35 in Base. Switch the case and review the resulting forecast; the Base-case break-even date and funding figures above should not be carried into that downside assessment.
See how the forecast works.
The walkthrough explains the customer and treatment engines, operating costs, capacity limits and funding schedules behind this example.
Open the workbook screenshots
Calculate your break-even point using your assumptions.
The SmartHelping Med Spa Startup Financial Model connects patients, repeat visits, treatment capacity and costs to a 60-month forecast, integrated financial statements, funding requirements and equity returns.
View the Med Spa Model — $45Need a different starting point? Use the Model Finder. For a forecast adapted to your clinic, explore custom financial modeling or send Jason your project details.
By Jason Varner, SmartHelping. Example source: SmartHelping Med Spa 5-Year Financial Model v1, Base case; KPI Visualizations, Monthly Operations, Summary and Assumptions. The figures illustrate how the model works and are not a forecast for a specific clinic. Calculations use unrounded values.
