# The Med Spa Owner: companion files

Julian R. Sterling

## What is here

- **MedSpa_1_Margin.xlsx** (Chapters 5 and 6; Workbook 1 of Appendix A): tabs Inputs, Margin, Checks. One treatment priced by the unit, after product cost and card fees, per treatment and per hour of room time (an average neurotoxin treatment of the case in FY2026: $289, $578 an hour).
- **MedSpa_2_Membership.xlsx** (Chapter 9; Workbook 2): tabs Inputs, Membership, Checks. One member-month after the included service's supplies, the member discount and the card fee on the fee ($90.13 a member-month).
- **MedSpa_3_Pay.xlsx** (Chapter 7; Workbook 3): tabs Inputs, Pay, Checks. The same six months of an injector's production under three pay plans (mixed $53,030, percentage $68,371, flat hourly $37,440).
- **MedSpa_4_Laser.xlsx** (Chapter 8; Workbook 4): tabs Inputs, Laser, Checks. The laser lease beside the bank's loan quote and a rental by the day, with the months each covers (lease $141,600, loan $154,020, rental $144,000).
- **MedSpa_5_BreakEven.xlsx** (Chapter 12; Workbook 5): tabs Inputs, BreakEven, Checks. Fixed costs a month turned into treatments a month ($69,985, 311 treatments, rounded up).
- **MedSpa_6_Payback.xlsx** (Chapter 13; Workbook 6): tabs Inputs, Payback, Checks. The second location's simple payback at its latest quarterly pace (1.7 years).
- **MedSpa_7_Offer.xlsx** (Chapter 16; Workbook 7): tabs Inputs, Offer, Checks. The letter of intent from adjusted EBITDA to the cash paid at closing ($2,840,930 of enterprise value, $1,700,278 paid at closing before fees and taxes).
- **Med_Spa_Owner_Toolkit.docx**: the 8 check-lists of Appendix B, editable, with a box to tick before each item (The monthly numbers review (chapters 6, 12 and 14); Structure and the medical director (chapters 2 and 3); Product purchasing and records (chapter 4); Prices, memberships, packages and gift cards (chapters 5 and 9); Hiring and paying an injector (chapter 7); Marketing, reviews and photographs (chapter 10); A laser or a second site (chapters 8 and 13); Before answering an offer (chapters 15 and 16)).

## How to use the workbooks

Every workbook opens on its Inputs tab: blue type on a light blue background is an input, and nothing else is typed by hand. The subject tab is read top to bottom, one result per line. Black type is a formula, green type a figure read from another tab of the same workbook. The Checks tab holds the checks of Appendix A: each one is an IF test on your own inputs that reads OK or FAIL, and the cell All checks reads OK only when every check above it does. A check never says which option is better.

The arithmetic is plain: the only functions are SUM, ROUND, MIN, MAX, IF and AND. No date and no payment function is used anywhere. Rates are percentage cells: typing 2.75% stores the fraction the formulas need. Every division by an input that can be zero is wrapped in IF and shows 0 instead of an error. An empty input reads as zero in a sum, a product or a comparison, but a MIN over a range skips it: the "no negative" checks therefore pass on an empty cell. The last section of Appendix A lists what the checks do not catch.

To use a workbook on your own practice, start with a copy, replace every blue input from the record that owns each figure (the price list, product invoices, the card processor's statements, payroll, the membership reports, the lease and the loan quote, the statements, a letter of intent), keep every check at OK, and compare a result only with the same site's own earlier months and years. Never edit a formula to turn a FAIL into OK.

The workbooks are separate files with no link between them: a figure two workbooks share is typed again where it is used.

## A word of caution

Corvelline Medical, P.C., Corvelline Aesthetics Management, LLC, Marrowdeen Community Bank, Kesterlyn Equipment Finance, Dravencote Properties and every party in the case are fictional. Prices, units, product costs, rates, fees, wages, terms, quotes and multiples are teaching assumptions, not market norms or recommendations; units per treatment are a pricing average, never a dose. Who may own a medical practice, how the medical director supervises, who may inject and how an injector may be paid are for counsel in the practice's state; taxes are for the outside CPA; every clinical decision belongs to the medical director and the treating clinician. The files are provided as they are, without warranty of any kind.
