Medical Spa Financial Model Template Excel
Launching or scaling a medical spa takes more than a great location and a skilled injector — it takes a financial model that proves the business works. This Medical Spa Financial Model Template is a fully built, 5-year monthly Excel model designed specifically for medspas, aesthetic practices, and wellness clinics offering Botox, dermal fillers, laser and energy-based treatments, body contouring, facials, chemical peels, microneedling, weight management, IV therapy, and hormone services. Every formula is dynamic, every date is linked, and every driver — from new patient leads to provider capacity — is built to mirror how a real medical spa actually makes money.
Financial Model For A Medical Spa (Medi Spa)
Unlike generic startup budget templates, this medical spa financial model is engineered around the specific economics of an aesthetics business: patient acquisition and retention, visit frequency, treatments per visit, service-category pricing, provider staffing ratios, and clinical capacity constraints. It walks through the full financial story in 13 linked tabs — assumptions, startup CapEx, revenue build, unit economics, staffing, operating expenses, P&L, cash flow, balance sheet, debt financing, investor returns, and a KPI dashboard — so you can move from a blank spreadsheet to a bank-ready, investor-ready financial package in minutes, not weeks.
Whether you’re opening your first location, raising equity or SBA debt financing, building a franchise disclosure package, or simply trying to understand your own break-even point, this model gives you a professional, formula-driven financial forecast built the way lenders, investors, and CPAs expect to see one. Change a single start date and the entire 5-year monthly timeline — headers, escalations, and labels across all 13 tabs — updates automatically. No broken formulas, no manual rework, no guesswork.
Why Buy This Model
Most medical spa owners either pay a financial modeling consultant thousands of dollars for a custom build, or they try to cobble one together from a generic startup template that has no idea what a “treatment mix” or “provider utilization rate” even is. This model closes that gap. It was purpose-built around the actual mechanics of a medspa — patients converting into visits, visits converting into treatments across 15 real service categories, and revenue that’s capped by how many clinical hours your providers can actually deliver — so the numbers you show a bank, an investor, or your own management team hold up under scrutiny. Every input cell is color-coded and editable, every output is a live formula, and the entire 5-year monthly build reconciles automatically (revenue ties, cash ties, and the balance sheet balances) so you can trust what you’re presenting. You’re not buying a spreadsheet — you’re buying weeks of financial modeling work, medspa-specific logic, and lender-ready polish for a fraction of what a custom build would cost.
Tab-by-Tab Highlights
01. Cover Control
A medical spa business plan financial model needs a professional front page, and this cover control tab delivers one — model purpose, version control, a live scenario selector, and an automated master checklist confirming every tie-out across the 5-year monthly medspa financial projection passes before you present it.
Highlights:
- Live scenario selector (Base / Upside / Downside) that flexes the entire model from one cell
- Aggregated PASS/REVIEW status pulling in the revenue, cash, and balance sheet checks from every tab
- Model version, purpose, and last-updated tracking for lenders and investors
- Color-coded legend and clickable index linking to all 13 tabs
02. Assumptions
The control center of this medical spa Excel financial model: one Model Start Date drives every date in the workbook, plus every pricing, staffing, patient acquisition, inflation, tax, and financing input a medspa owner or CFO needs to run realistic 5-year monthly scenarios.
Highlights:
- Single Model Start Date input auto-updates every tab’s monthly and annual timeline
- Patient acquisition, conversion, retention, and visit-frequency drivers in one place
- Year-1 pricing and margin assumptions for all 15 treatment categories with built-in inflation
- Staffing utilization, financing, tax, and working-capital assumptions fully editable and color-coded
Medical Spa Revenues
03. Startup CapEx
Every medical spa startup budget needs a clear buildout and pre-opening cost schedule, and this tab covers it — leasehold improvements, laser and medical equipment, furniture and IT, security deposits, initial inventory, and a full sources-and-uses table showing exactly how opening day is funded.
Highlights:
- Itemized buildout, laser/medical equipment, and furniture & IT CapEx categories
- Pre-opening marketing, training, legal, and licensing cost tracking
- Automated Sources & Uses table matching equity, bank debt, and equipment financing to total startup cost
- Feeds fixed-asset and opening-cash balances directly into the Balance Sheet and Cash Flow tabs
04. Services Revenue Build
The engine room of this medspa financial model: new patients times conversion rate, visits per patient, and treatments per visit flow through 15 service categories — injectables, devices, aesthetics, and wellness — before provider clinical capacity caps what the business can actually deliver.
Highlights:
- Full patient funnel: leads → conversion → active patients → churn → visits
- Revenue built bottom-up across Botox, fillers, lasers, body contouring, facials, IV therapy, and more
- Provider capacity constraint (FTEs × hours × utilization × revenue/clinical hour) caps unrealistic demand
- Built-in tie-out check comparing top-down and bottom-up revenue every single month
05. Unit Economics
Serious medspa investors and lenders always ask about unit economics, and this tab answers every question automatically — revenue per visit, revenue per patient, gross margin by treatment, provider compensation ratios, customer acquisition cost, retention rate, and monthly break-even patient and revenue targets.
Highlights:
- Revenue per visit and per patient, calculated live from the P&L and Revenue Build
- Gross margin, COGS, and contribution margin by individual treatment category
- Customer acquisition cost (CAC) and marketing spend per new patient
- Break-even patients per month and break-even revenue per month, fully formula-driven
06. Providers Staffing
Staffing is the single biggest cost driver in any medical spa financial model, and this tab handles it in full — medical director, physicians, nurse practitioners, RNs, aestheticians, and front-office headcount, annual hiring ramps, and escalating compensation feeding straight into payroll and capacity.
Highlights:
- Editable annual FTE counts for every clinical and non-clinical role
- Compensation rates that escalate automatically with the payroll escalation assumption
- Clinical FTE total feeds directly into the Revenue Build’s provider capacity constraint
- Automatic payroll tax, benefits, and bonus/commission calculations
07. Operating Expenses
Beyond payroll, a medical spa’s overhead can make or break profitability — this tab itemizes rent, CAM, utilities, insurance, marketing, software/SaaS, professional fees, and two dozen more line items, each escalating annually and flowing straight into the income statement.
Highlights:
- Rent, CAM, utilities, and insurance with independent escalation assumptions
- Marketing budget tied directly to new patient acquisition volume and CAC
- Software, legal, accounting, and professional fee tracking
- Every line links 1:1 into the P&L’s operating expense section
Medical Spa Financial Statements
08. Income Statement (P&L)
A complete monthly and annual income statement — revenue by service category, cost of revenue, gross margin, payroll, operating expenses, EBITDA, depreciation, interest, and net income — built entirely from the operating engine upstream, exactly how a real medspa P&L should read.
Highlights:
- Revenue broken out across injectables, devices, aesthetics, wellness, retail, and membership
- Full cost of revenue and gross margin by category
- EBITDA, EBITDA margin, EBIT, and net margin calculated automatically
- Built-in depreciation schedule supporting both the P&L and Balance Sheet
09. Cash Flow
Profit isn’t cash, and this tab proves it — operating, investing, and financing cash flow reconciled monthly with working capital changes, debt proceeds and repayments, owner distributions, and a clean beginning-to-ending cash roll-forward every lender wants to see.
Highlights:
- Full indirect-method operating cash flow with working capital detail
- Investing section capturing startup CapEx and pre-opening costs
- Financing section tracking equity, bank debt, equipment financing, and distributions
- Automated tie-out check confirming Month 1 cash matches the CapEx sources & uses
10. Balance Sheet
A fully linked monthly balance sheet — cash, receivables, inventory, fixed assets, debt, and equity — that automatically balances every single month across the 5-year medical spa financial projection, with a built-in check confirming assets always equal liabilities plus equity.
Highlights:
- Complete current assets, fixed assets, and other assets build
- Current and long-term liabilities split automatically from the debt schedule
- Retained earnings and current-year net income tracked separately, GAAP-style
- Automated PASS/REVIEW balance check across all 60 months
11. Debt Financing
Bank term loan and equipment financing amortization schedules, fully automated with level monthly payments, interest, principal, and ending balances — everything a lender or SBA underwriter needs to see how debt service is calculated and repaid over time.
Highlights:
- Level-payment amortization schedules for both bank debt and equipment financing
- Automatic current vs. long-term debt split for the Balance Sheet
- Interest expense flows directly into the P&L every month
- Editable loan amount, rate, and term assumptions
12. Returns Investor
Built for anyone raising outside capital — EBITDA trends, cash-on-cash returns, cumulative distributions, exit valuation on an EBITDA multiple, MOIC, and an annualized IRR calculated straight from the model’s own monthly cash flows.
Highlights:
- Cash-on-cash return and cumulative distribution multiple by year
- Editable exit EBITDA multiple and automatic exit equity value calculation
- MOIC and annualized IRR computed from the real monthly cash flow stream
- Payback period calculated automatically in months
Key Financial Metrics & Projections For A Medical Spa
13. Dashboard Sensitivities
A one-page KPI dashboard summarizing revenue, EBITDA, cash, patient counts, and capacity utilization by year, plus built-in sensitivity tables showing how conversion rate and provider utilization changes move the model’s key numbers.
Highlights:
- Chart tracking Revenue, EBITDA, and Ending Cash across all 5 years
- Conversion-rate sensitivity table showing the revenue and EBITDA impact of demand swings
- Provider utilization sensitivity table showing the impact of capacity changes
- Balance sheet check included right on the dashboard for at-a-glance confidence
Medi Spa Frequently Asked Questions (Faq)
Q: Do I need financial modeling or Excel experience to use this?
No. Every input cell is color-coded blue so you know exactly what to change, and every calculation is already built for you. You just enter your own numbers — patient volume, pricing, staffing, rent — into the Assumptions tab and the rest of the model updates itself.
Q: Can I change the start date, or is it locked to a specific year?
You can set any Model Start Date you want on the Assumptions tab, and the entire 5-year monthly timeline — every header, label, and escalation across all 13 tabs — updates automatically. There’s no manual rework required.
Q: Is this model just for a brand-new medspa, or can an existing practice use it too?
Both. The Startup CapEx and financing tabs are built for a new location, but you can zero those out and use the Assumptions, Revenue Build, P&L, Cash Flow, and Dashboard tabs as a forward-looking operating model for an existing medical spa.
Q: Will this work for a bank loan or SBA financing application?
Yes. The model is built in the standard “bankable” format lenders expect — color-coded inputs, a full 3-statement build (P&L, Cash Flow, Balance Sheet), a debt amortization schedule, and built-in tie-out checks confirming the model reconciles every month.
Q: Does it actually calculate things like break-even and provider capacity, or is that just marketing?
It’s fully calculated. The Unit Economics tab computes break-even patients and break-even revenue per month from live formulas, and the Revenue Build tab caps monthly revenue based on your actual provider headcount, available hours, and utilization rate — so the model won’t show revenue your staff couldn’t physically deliver.
Q: What treatment categories are included?
Fifteen categories across four groups: Injectables (Botox/neuromodulators, dermal fillers, other injectables), Devices (laser, RF, body contouring, skin resurfacing), Aesthetics (facials, chemical peels, microneedling, waxing), and Wellness/Medical (weight management, IV therapy, hormone therapy, other medical services) — plus retail/skincare and membership revenue.
Q: Does it work in Google Sheets, or only Excel?
The model is built natively in Excel using standard formulas (SUMIFS, INDEX/MATCH, PMT, IRR, etc.) and is fully compatible with Excel on Windows and Mac. It can be uploaded to Google Sheets, though some formatting and chart elements display best in Excel.
Q: Can I use this to raise money from investors?
Yes. The Returns Investor tab is built specifically for that conversation — it calculates cash-on-cash returns, MOIC, and annualized IRR based on an editable exit EBITDA multiple, using the model’s actual monthly cash flows rather than static assumptions.
Q: What if my medi spa has more or fewer providers, or different services than what’s built in?
Every driver is editable — headcount by role, treatment mix percentages, pricing, and service categories can all be adjusted on the Assumptions and Providers Staffing tabs to match your real business, without touching the underlying formulas.
Q: Is this a one-time purchase, and do I get updates or support?
This is a one-time purchase — the file is yours to keep, edit, and reuse for as long as you need it. Because every formula is fully visible and unlocked, you (or your accountant) can adjust, extend, or audit any part of the model at any time.
Q: How do I know the numbers actually tie out and aren’t just hardcoded?
Every number in the model is a live formula, not a typed-in value. The Cover Control tab includes an automated master check that confirms revenue ties top-down to bottom-up, cash flow reconciles to the startup funding sources and uses, and the balance sheet balances in every single month — all visible with a PASS flag.
Q: Can I customize the branding or remove any references before presenting it?
Yes. The file is fully editable — you can rename tabs, update the cover page, add your logo, and adjust colors to match your own branding before sending it to a bank, investor, or partner.
Medical Spa Financial Model Conclusion
This Medical Spa Financial Model is essential for planning, forecasting, and securing investment. With detailed income projections, cash flow tracking, and balance sheet monitoring, they ensure the business maintains profitability and financial health.