Beauty Salon Financial Model – Single Location (US): 5-Year Monthly 3-Statement Model with DCF Valuation & Cap Table

Description
This Excel model forecasts the launch and first five years of a single beauty salon (January 2026 – December 2030, in USD). All inputs sit on one Assumptions sheet and drive the monthly calculations, the integrated financial statements and the summary outputs automatically. Change the average ticket, the number of stylists or the rent, and every statement, chart and valuation updates in real time.
The model comes pre-filled with realistic base-case assumptions for a salon opening on 1 May 2026. You can use it as a working example or replace the inputs with your own numbers.

Revenue drivers (5 streams)

• Service revenue: number of stylists and technicians, services per provider per day, operating days per month, average service ticket and annual price increase
• In-salon retail products: attach rate (% of service visits) and average order value
• E-commerce (online product sales): online order rate and average order value
• Add-on treatments: attach rate and average add-on price
• Classes and events: events per month and average revenue per event
• Capacity ramp-up from the opening date, so the first months of trading are modelled realistically
  
  

Costs

• Cost of revenue: back-bar and service supplies, retail product cost and stylist commission (%)
• Salon running costs: rent including CAM, utilities, front desk and assistants, card processing fees, marketing and PR, and repairs and contingency
• Pre-opening OPEX and CAPEX timing (months before opening)
• Headcount plan with start dates and monthly salaries (owner/director, salon manager and up to 15 more roles), plus payroll tax
• G&A expense lines (laundry, licences and permits, and more), with annual cost inflation
  
  

Assets, financing and tax

• CAPEX by category: interior build-out, salon equipment, technical equipment (POS, IT, AV) and brand and concept design, each with its own depreciation period
• Working capital: receivable, payable and inventory days
• Term loan (SBA 7(a)-style) with drawdown date, term and interest rate
• Founder equity and up to three investor rounds
• Dividend policy (declaration period and payout ratio)
• Corporate tax rate and tax payment timing
  
  

Outputs

• Monthly and annual Income Statement, Balance Sheet and Cash Flow Statement (direct and indirect methods)
• Dashboard with key financials and charts
• Metrics: client visits, marketing spend, CAC, ARPA and customer lifetime value (LTV)
• Use of Funds: sources and uses of cash and the monthly burn rate
• Cap Table: pre- and post-money valuation, new shares issued and investor ownership after the raise
• DCF Valuation: free cash flow to firm, terminal value, enterprise value and equity value
  
  

Built to best-practice standards

• A single assumptions sheet, separate calculations and clear input/formula colour coding
• Integrity checks: balance sheet balance, cash flow reconciliation between the direct and indirect methods, and a negative-cash alert, all summarised on one Checks sheet
• Hyperlinked table of contents and a step-by-step user guide inside the file
• Fully unlocked, with no macros: every formula is open and editable
  
  

Who it's for

• Entrepreneurs opening a hair, beauty or nail salon
• Existing salon owners planning a new location or refinancing
• Consultants, accountants and bankers who assess salon business plans
• Founders preparing an SBA loan application or an investor pitch
  
  

Sheets included
Cover, Contents, Guide, Dashboard, Metrics, Valuation, Use of Funds, Cap Table, Assumptions, Calculations, Financial Statements (Monthly), Income Statement (Annual), Balance Sheet (Annual), Cash Flow (Annual), Checks, LookUp