Free Excel templates

A free med spa treatment margin and break-even calculator in Excel

Price a neurotoxin treatment by the unit and a filler by the syringe, see what each leaves per hour of room time, what a member discount takes, and how many treatments a month cover the fixed costs.

With the worked case's inputs, a neurotoxin treatment of $524 leaves $289 after product and card fees, $578 an hour of room time; a filler syringe leaves $454, $605 an hour. A member discount takes the treatment's contribution to $237, a cut of 18.0%, and the first site needs 311 treatments a month to cover $69,985 of fixed costs.

Get the template

One Excel file, no macros, nothing locked. Free: enter your email address and the download opens at once, along with the other 129 free models.

Med_Spa_Treatment_Margin_and_Break_Even_Calculator.xlsx (12 KB)

You join the reader list: one email when a new free model or a new book comes out, and a few notes on using the models. Leave in one click. Already on the list? Enter the same address. How your address is used.

The book behind this model

This model goes with The Med Spa Owner, which explains the method behind it, chapter by chapter.

Get the PDF edition → See the book

Want every model at once?

The Financial Model Library: all 130 models from this site in one download, organised by theme, plus two modelling books in DRM-free PDF (Financial Modeling from First Principles and Real Estate Financial Modeling).

Get the Library, $79 →

This free file stays free. Secure checkout by Stripe.

Not on Amazon: 24 paperbacks by Julian R. Sterling on insurance and retirement, printed on demand and shipped worldwide. Browse the bookshop →

What is in the file

3 sheets. Inputs can be changed; everything else is a formula, and the last sheet checks the figures against the book.

Inputs
Prices per unit and per syringe, product costs, average units, minutes, card fee rate, injector pay, member discount, plan fee and the monthly fixed costs.
Calculator
Contribution per neurotoxin treatment and per filler syringe, per hour of room time, the member discount's effect, one appointment after injector pay, and the break-even.
Checks
Inputs filled, rates typed as fractions, product costs below prices, no negative fixed cost.

What the worked case returns

MeasureValue
Neurotoxin treatment, price$524
Neurotoxin treatment, contribution before staff pay$289
Neurotoxin, per hour of room time$578
Filler syringe, contribution$454
Filler, per hour of room time$605
Member price of the treatment$471
Member contribution per treatment$237
Contribution lost to the discount18.0%
Fixed costs a month$69,985
Treatments a month to break even311

Contributions are measured before staff pay, because the case pays its injectors by the hour or by salary; enter an hourly rate or a production percentage to see one appointment after injector pay. Units per treatment are a pricing average from the case, never a dose.

How to use it on your own case

  1. Type your price per unit and per syringe, product costs, average units and minutes per appointment on Inputs.
  2. Type your card fee rate, member discount, plan fee and injector pay.
  3. Type your monthly fixed costs line by line and your average contribution per treatment across the menu.
  4. Read the contribution per treatment and per room hour, the member effect and the break-even on Calculator; keep every check at OK.

Questions people ask about it

What is a good profit margin per neurotoxin treatment?

There is no single norm: it depends on your price per unit, your product cost and the units your clinicians use. The calculator shows what one treatment leaves after product and card fees, and per hour of room time, from your own figures.

Why rank treatments by contribution per room hour?

Rooms and injector time are the scarce resource. A treatment with a lower price can leave more per hour than one with a higher price if it takes less room time.

How much does a member discount cost?

More than its own rate: a 10 percent discount on the price comes entirely off the contribution, because product cost does not fall. In the worked case it cuts the treatment's contribution by 18.0%.

How many treatments a month does a med spa need to break even?

Fixed costs a month divided by the average contribution per treatment across the menu, rounded up. Staff paid by the hour or by salary belong in the fixed costs.

Go further

The free workbooks of The Med Spa Owner go further: the full companion set, blank models and the worked cases of the book.

See the book and its free files →

Other free templates

This template goes with The Med Spa Owner. See the book.