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

Tanning Salon Financial Model
A comprehensive editable 5-Year 3-Statement, MS Excel spreadsheet for tracking your Tanning Salon's finances
AllFinancialModels offer a curated selection of high-quality yet financial model templates designed to support a wide range of business needs.Follow
tanning salonsun bedfinancial modelfinanceexcel spreadsheetexcel templatetanning studiosunbedstanning boothstanning beds
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
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)
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)
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)
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 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).
- 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.
- 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.
- 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.
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
- Cash Inflows:
- Sale of old tanning beds or unused equipment.
- Cash Outflows:
- Purchase of new tanning beds, salon furniture, software upgrades.
- Cash Inflows:
- Business loans, investor funding.
- Cash Outflows:
- Repayment of loans, lease obligations, dividends (if applicable).
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.
- Tanning Equipment: Beds, booths, spray tan machines (less accumulated depreciation).
- Salon Furniture & Fixtures: Waiting room chairs, mirrors, counters.
- Leasehold Improvements: Renovations and interior upgrades.
- Accounts Payable: Outstanding payments to suppliers.
- Short-Term Debt: Loans due within a year.
- Taxes Payable: Sales tax, payroll tax.
- Business Loans: Financing for equipment or expansion.
- Lease Obligations: If renting salon space.
- Owner’s Investment: Initial capital or reinvested profits.
- Retained Earnings: Profits retained in the business after expenses and distributions.
- Net Income from the Income Statement flows into the Cash Flow Statement (Operating Cash Flow) and Balance Sheet (Retained Earnings).
- Capital expenditures (from Cash Flow Statement) reduce cash and appear as assets on the Balance Sheet.
- 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
- 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
- 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
- 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
- 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
- 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
Further information
Provides thorough oversight, tracking, and reporting of Tanning Salon's finances, including updates on budget utilisation and projections.
