Click main image to view in full screen. Unlock all 15 preview images:
Med Spa Financial Model - 5-Year Forecast – Excel XLSX
Excel (XLSX) + Zip archive file (ZIP)
BENEFITS OF THIS DOWNLOADABLE EXCEL DOCUMENT
- Build an integrated 5-year med spa forecast connecting treatment capacity, service revenue, memberships, staffing, consumables, operating expenses, marketing, financing, and all three financial statements.
- Analyze break-even treatments, capacity utilization, Base/Upside/Downside scenarios, EBITDA sensitivity, liquidity, and funding requirements within one connected model.
- Turn clinic assumptions into management-ready insights with an Executive Dashboard, 15-slide presentation deck, and detailed 16-page user guide.
SALON & SPA EXCEL DESCRIPTION
π MED SPA & AESTHETIC CLINIC 5-YEAR FINANCIAL MODEL
Build a structured financial forecast for a med spa, aesthetic clinic, or cosmetic treatment business with a professional model connecting treatment capacity, service revenue, memberships, staffing, consumables, operating expenses, marketing, investment, financing, and liquidity.
This package combines a fully integrated 5-Year Three-Statement Financial Model, a professional 15-slide Investor / Management PowerPoint Deck, and a detailed 16-page How-to-Use Guide.
It is designed for med spa owners, aesthetic clinic founders, operators, consultants, finance teams, and management professionals who need a transparent framework for business planning and financial forecasting.
π¦ WHAT IS INCLUDED
β Premium financial model with 26 worksheets
β 5-year forecast with illustrative sample data for 2029β2033
β Integrated Income Statement, Balance Sheet, and Cash Flow Statement
β Executive Dashboard with 4 management charts
β 15-slide Investor / Management PowerPoint Deck
β 16-page How-to-Use PDF Guide
β Base / Upside / Downside Scenario Analysis
β Treatment Volume Γ Average Treatment Value Sensitivity Analysis
β Break-Even Analysis
β Funding Requirement Analysis
β Fully editable operating and financial assumptions
β No macros or VBA
β No APIs or live-data connections
β No automatic med spa or aesthetic-treatment pricing benchmarks
β All files and content provided in English
All included figures, prices, volumes, and assumptions are illustrative and can be replaced with business-specific information.
π TREATMENT CAPACITY
The model connects treatment demand with the operational capacity of the clinic.
Users can plan variables such as:
β Treatment Rooms
β Working Days
β Operating Hours
β Appointment Duration
β Treatment Volume
β Capacity Utilization
β Practitioner Capacity
These drivers provide the operating foundation for revenue, staffing, break-even, and profitability analysis.
π° TREATMENT REVENUE
The Treatment Revenue section supports structured planning across different service categories.
These may include:
β Injectable / Aesthetic Services
β Skin Treatments
β Laser / Device-Based Treatments
β Body Treatments
β Facial Services
β Other Treatment Categories
Users enter their own pricing, treatment volumes, growth assumptions, and business-specific service mix.
No current market prices or automatic treatment benchmarks are embedded.
π³ MEMBERSHIP & PACKAGE REVENUE
Recurring and prepaid revenue streams can be planned separately from individual treatment activity.
The model supports structured planning for:
β Membership Revenue
β Treatment Packages
β Package Sales
β Recurring Client Revenue
This provides additional visibility into recurring and packaged revenue alongside standard treatment activity.
ποΈ RETAIL & OTHER REVENUE
Additional revenue streams can be modeled independently, including:
β Retail Products
β Skincare Products
β Other Services
β Other Business Revenue
This helps adapt the model to different clinic and med spa business structures.
π₯ STAFFING & PAYROLL
The staffing schedule supports workforce planning for roles such as:
β Medical Director / Clinical Lead
β Practitioners
β Nurses / Injectors
β Estheticians
β Reception
β Practice Management
β Marketing / Administration
The model can incorporate:
β Headcount
β Compensation
β Benefits
β Start Month
β Annual Salary Growth
Payroll flows directly into profitability and cash-flow projections.
𧴠TREATMENT CONSUMABLES
Treatment-related consumable costs are modeled separately from general operating expenses.
This allows users to evaluate service economics using their own consumable assumptions rather than relying on external industry benchmarks.
π’ OPERATING EXPENSES
Recurring business expenses are planned separately from staffing, consumables, marketing, and capital investment.
This provides clearer visibility into the clinic's operating cost structure.
π£ MARKETING
A dedicated Marketing section supports planning for customer-acquisition and promotional spending.
Marketing assumptions flow directly into the financial forecast and scenario analysis.
π οΈ CAPEX & DEPRECIATION
Capital investment can be planned through dedicated schedules for:
β Treatment Equipment
β Devices
β Furniture
β Technology
β Fit-Out
β Replacement Investments
β Other Capital Expenditure
CapEx flows into depreciation, the Balance Sheet, Cash Flow Statement, and funding analysis.
π¦ DEBT & FINANCING
The Debt Schedule supports structured planning for financing, interest, repayment, and outstanding debt.
Financing assumptions are integrated with the three financial statements and liquidity forecast.
π INTEGRATED THREE-STATEMENT MODEL
The workbook includes fully connected:
β Income Statement
β Balance Sheet
β Cash Flow Statement
Revenue, staffing, consumables, OPEX, marketing, CapEx, depreciation, debt, cash, and equity flow through one structured financial model.
An integrated Balance Check supports model reconciliation.
π
MONTHLY & FIVE-YEAR FORECAST
The model combines:
β Monthly Forecast β Year 1
β Annual Forecast β Years 1 to 5
This provides short-term operating visibility together with a complete five-year financial outlook.
π EXECUTIVE DASHBOARD
The Executive Dashboard consolidates important operating and financial KPIs.
Metrics include:
β Revenue
β EBITDA
β EBITDA Margin
β Ending Cash
β Treatments
β Average Revenue per Treatment
β Capacity Utilization
β Revenue per Practitioner
β Membership Revenue
β Funding Requirement
Four management charts provide a visual overview of key financial and operating trends.
π― BREAK-EVEN ANALYSIS
The model helps users evaluate:
β Break-Even Treatments
β Modeled Treatment Volume
β Operating Headroom
β Contribution Economics
β Required Operating Activity
This supports planning around the level of business activity required to cover the modeled cost structure.
π SCENARIO ANALYSIS
The workbook supports:
β Base Case
β Upside Case
β Downside Case
Scenario drivers may include:
β Treatment Volume
β Average Treatment Price
β Capacity Utilization
β Consumable Costs
β Payroll
β Marketing
β Membership Growth
Scenario outputs are intended for management planning and are not predictions of future results.
π₯ SENSITIVITY ANALYSIS
A dedicated sensitivity analysis evaluates how combinations of:
β Treatment Volume
β Average Treatment Value
may affect projected EBITDA.
This provides an additional decision-support view beyond the standard scenario cases.
πΌ FUNDING REQUIREMENT
The Funding Requirement section connects liquidity planning with the financial model.
Users can review:
β Minimum Cash Balance
β Ending Cash
β Funding Requirement
β Debt Development
β Cash Availability
This helps identify potential financing needs within the modeled business plan.
π½οΈ 15-SLIDE INVESTOR / MANAGEMENT DECK
The included PowerPoint presentation provides a professional structure for communicating key model outputs.
Topics include:
β Executive Summary
β Business Overview
β Services and Revenue Streams
β Capacity
β Revenue Mix
β Memberships
β Staffing
β Marketing
β 5-Year Forecast
β EBITDA and Cash
β Break-Even
β Funding Requirement
β Scenarios
β Risks
β Final Management Summary
The deck can be adapted for internal reviews, planning discussions, consultant deliverables, financing preparation, or investor-oriented presentations.
π 16-PAGE HOW-TO-USE GUIDE
The included guide explains the complete workflow from initial assumptions through operating planning, financial statements, dashboard interpretation, scenarios, sensitivity analysis, and funding requirements.
π₯ WHO THIS MODEL IS FOR
β Med Spas
β Aesthetic Clinics
β Cosmetic Treatment Studios
β Clinic Owners and Founders
β Finance and Management Teams
β Consultants and Advisors
β Business Plan Preparation
β Capacity and Staffing Planning
β Cash Flow and Funding Planning
β Management and Financing Discussions
π» COMPATIBILITY
The primary model is provided in Microsoft Excel XLSX format.
Supplemental files include Microsoft PowerPoint PPTX and PDF.
The workbook may also be imported into Google Sheets where practical. Microsoft Excel remains the reference environment, and some formatting, charts, or functionality may vary after import.
β οΈ IMPORTANT INFORMATION
All prices, treatment volumes, staffing assumptions, consumable costs, marketing expenses, financing assumptions, and operating inputs are entered and controlled by the user.
The model contains no current market prices, automatic industry benchmarks, medical claims, diagnoses, or treatment recommendations.
It is a financial and business-planning template only.
βοΈ IMPORTANT DISCLAIMER
This product is an editable planning and financial-modeling template.
It does not constitute medical, clinical, financial, investment, tax, legal, accounting, valuation, financing, or other professional advice.
All sample figures, assumptions, scenarios, forecasts, and outputs are illustrative only and should be replaced and independently reviewed using the user's own business information.
No future revenue, profitability, financing approval, business performance, treatment volume, or other outcome is guaranteed.
Users remain responsible for reviewing all assumptions and outputs and should consult qualified professionals where appropriate.
All SheetworksStudio templates are independently created and unofficial. SheetworksStudio is not affiliated with, endorsed by, or sponsored by Microsoft, Google, or any other third-party brand.
Got a question about the product? Email us at support@flevy.com or ask the author directly by using the "Ask the Author a Question" form. If you cannot view the preview above this document description, go here to view the large preview instead.
Source: Best Practices in Salon & Spa, Integrated Financial Model Excel: Med Spa Financial Model - 5-Year Forecast Excel (XLSX) Spreadsheet, SheetworksStudio
ABOUT THE AUTHOR
SheetworksStudio creates premium Excel-based business templates, dashboards, trackers, financial models, and management systems for professionals, consultants, entrepreneurs, and organizations.
Our portfolio covers finance, project management, operations, risk management, compliance, AI governance, HR, supply chain, performance management, and business planning. Each product is designed to
... [read more]
Ask the Author a Question
You must be logged in to contact the author.
