Tanning Salon Financial Model
Originally published: 11/02/2025 09:07
Publication number: ELQ-96972-1
View all versions & Certificate
certified

Tanning Salon Financial Model

A comprehensive editable 5-Year 3-Statement, MS Excel spreadsheet for tracking your Tanning Salon's finances

Description
This 3-statement financial model for a tanning salon consists of the Income Statement, Cash Flow Statement, and Balance Sheet. These statements are interconnected and provide a comprehensive financial picture of the business.
It has a separate section for a 6 Tier Subscription revenue. Details below.


1. Income Statement (Profit & Loss Statement)The income statement details the revenues, expenses, and profits over a specific period (monthly, quarterly, or annually).
Revenue Section
  • Service Revenue: Revenue from tanning sessions, memberships, and packages.
    • Example: Single-session sales, unlimited monthly memberships, discounted package deals.
  • Product Sales: Revenue from lotions, protective eyewear, skin care, and beauty products.
  • Other Revenue: Gift card sales, late fees, rental space (if renting equipment to independent operators), advertising revenue (if promoting third-party products).
Cost of Goods Sold (COGS)
  • Product Costs: Costs of purchasing tanning lotions, eyewear, and beauty products.
  • Service Costs: Cleaning supplies, bulbs for tanning beds, and maintenance expenses directly tied to service delivery.
Gross Profit = Revenue - COGSOperating Expenses
  • Rent & Utilities: Salon space lease, electricity, water, internet.
  • Employee Salaries & Wages: Payroll for salon attendants, receptionists, and management.
  • Marketing & Advertising: Social media, flyers, local partnerships, loyalty program discounts.
  • Depreciation & Amortization: Depreciation on tanning beds, furniture, and salon equipment.
  • Insurance: Liability, workers' compensation, and property insurance.
  • Office & Administrative Expenses: Software subscriptions (POS systems, booking software), office supplies.
Operating Profit (EBIT) = Gross Profit - Operating ExpensesOther Income & Expenses
  • Interest Income: From bank savings or investments (if applicable).
  • Interest Expense: Loan payments for business expansion, equipment financing, etc.
  • Taxes: Corporate tax or self-employment tax.
Net Income = EBIT - Interest Expense - TaxesThis is the final profit or loss figure for the period.


2. Cash Flow StatementThe cash flow statement shows how cash moves in and out of the business, categorized into three sections:
Operating Cash Flow (OCF)
  • Cash Inflows:
    • Sales from tanning services and product sales.
    • Membership and package prepayments.
  • Cash Outflows:
    • Payments for rent, wages, marketing, utilities, and maintenance.
    • Taxes and other liabilities.
  • Net Operating Cash Flow = Cash Inflows - Cash Outflows
Investing Cash Flow (ICF)
  • Cash Inflows:
    • Sale of old tanning beds or unused equipment.
  • Cash Outflows:
    • Purchase of new tanning beds, salon furniture, software upgrades.
Financing Cash Flow (FCF)
  • Cash Inflows:
    • Business loans, investor funding.
  • Cash Outflows:
    • Repayment of loans, lease obligations, dividends (if applicable).
Net Cash Flow = Operating CF + Investing CF + Financing CFIf positive, the salon is generating more cash than it is spending. If negative, adjustments may be needed.


3. Balance SheetThe balance sheet presents the financial position of the salon at a given point in time, showing assets, liabilities, and equity.
AssetsCurrent Assets (Short-Term)
  • Cash & Cash Equivalents: Available bank balance and cash on hand.
  • Accounts Receivable: Outstanding customer payments (e.g., corporate clients with invoicing agreements).
  • Inventory: Tanning lotions, goggles, skincare products.
  • Prepaid Expenses: Rent, insurance, and other advance payments.
Fixed (Long-Term) Assets
  • Tanning Equipment: Beds, booths, spray tan machines (less accumulated depreciation).
  • Salon Furniture & Fixtures: Waiting room chairs, mirrors, counters.
  • Leasehold Improvements: Renovations and interior upgrades.
LiabilitiesCurrent Liabilities
  • Accounts Payable: Outstanding payments to suppliers.
  • Short-Term Debt: Loans due within a year.
  • Taxes Payable: Sales tax, payroll tax.
Long-Term Liabilities
  • Business Loans: Financing for equipment or expansion.
  • Lease Obligations: If renting salon space.
Owner’s Equity
  • Owner’s Investment: Initial capital or reinvested profits.
  • Retained Earnings: Profits retained in the business after expenses and distributions.
Formula: Assets = Liabilities + Owner’s EquityInterconnections Between the Statements
  1. Net Income from the Income Statement flows into the Cash Flow Statement (Operating Cash Flow) and Balance Sheet (Retained Earnings).
  2. Capital expenditures (from Cash Flow Statement) reduce cash and appear as assets on the Balance Sheet.
  3. Debt repayments (from Cash Flow Statement) reduce liabilities on the Balance Sheet.


Here are 6 tiered subscription ideas for your tanning salon, ranging from basic to luxury, catering to different customer needs:


1. Bronze Glow (Basic - Budget Friendly)
  • Access to Level 1 tanning beds (basic beds)
  • Up to 8 sessions per month
  • 5% discount on lotions & retail products
2. Sun Kissed (Entry-Level Mid-Tier)
  • Access to Level 1 & 2 tanning beds
  • Unlimited tanning in Level 1 beds
  • 10 sessions per month for Level 2
  • 10% discount on lotions & retail products
3. Golden Glow (Mid-Tier - Popular Choice)
  • Access to Levels 1, 2, & 3 tanning beds
  • Unlimited tanning in Levels 1 & 2
  • 12 sessions per month for Level 3
  • 15% discount on lotions & retail products
  • 1 free spray tan per month
4. Radiant Bronze (High-Tier - Premium Tanning)
  • Access to all tanning beds (Levels 1-4)
  • Unlimited tanning in Levels 1, 2 & 3
  • 15 sessions per month for Level 4
  • 20% discount on lotions & retail products
  • 2 free spray tans per month
  • VIP appointment scheduling
5. Platinum Glow (Luxury Membership)
  • Unlimited tanning in all levels
  • 3 free spray tans per month
  • 25% discount on lotions & retail products
  • Priority booking & express check-in
  • Complimentary hydrating after-care treatment
6. Ultimate Sun Goddess (Elite/VIP Membership)
  • Unlimited tanning in all levels + premium spray tans
  • 4 free spray tans per month
  • 30% discount on lotions & retail products
  • Exclusive VIP lounge access
  • Monthly skin hydration or exfoliation treatment
  • Special birthday & holiday gifts


Conclusion

This 3-statement financial model for a tanning salon helps owners analyze profitability, cash flow health, and financial stability. Understanding these statements ensures better decision-making for salon expansion, pricing strategies, and cost control.

This Best Practice includes
1 Excel Financial Model

Acquire business license for $90.00

Add to cart

Add to bookmarks

Discuss

Further information

Provides thorough oversight, tracking, and reporting of Tanning Salon's finances, including updates on budget utilisation and projections.


0.0 / 5 (0 votes)

please wait...