Med Spa Financial Model - 5-Year Forecast – Excel XLSX

BENEFITS OF THIS DOWNLOADABLE EXCEL DOCUMENT

1. 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.
2. Analyze break-even treatments, capacity utilization, Base/Upside/Downside scenarios, EBITDA sensitivity, liquidity, and funding requirements within one connected model.
3. 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 Financial Model - 5-Year Forecast is an Excel template (XLSX) with a supplemental Zip archive file document available for immediate download upon purchase.

💎 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.

Source: Best Practices in Salon & Spa, Integrated Financial Model Excel: Med Spa Financial Model - 5-Year Forecast Excel (XLSX) Spreadsheet, SheetworksStudio