Esthetics & Skincare Business Financial Model Template
Excel financial planning template for esthetics & skincare business. The online worksheet illustrations use a separate website scenario; review the selected product's file specification and delivery terms before buying.
6 online worksheet illustrations, described below
Opening budget, scenario assumptions and dashboard views
Online five-year scenario and monthly operating sensitivity
Excel template sold separately; review the selected file specification
The online preview illustrates 6 planning sections using this website's scenario. These illustrations are separate from the downloadable workbook.
01RevenueThe supplied current seller material describes a shared visit pool allocated by service mix, category prices and extra revenue per visit. This online illustration uses nonmedical facial completions and limited attached retail.Explore layout ↓
02COGS & OPEXSeller material describes direct, variable and fixed operating costs. The separately authored web case retains physical treatment cost when testing a service discount.Explore layout ↓
03PayrollThe seller description includes editable personnel assumptions. The online planning illustration pays all owner and employee hours, including nonappointment duties and a relief allowance.Explore layout ↓
04Capital and StartupSeller material describes editable capital assumptions; this web illustration distinguishes opening setup, refundable deposits, inventory, contingency and operating cash.Explore layout ↓
05IS, CF and BSThe supplied seller material describes income statement, cash flow and balance sheet reports. These online illustrations use StartFigures independently authored operating inputs.Explore layout ↓
06Scenarios and DashboardThe current seller material presents scenario comparisons and a dashboard. The web case tests realized facial yield, completed visits and reserve use at the stated paid roster.Explore layout ↓
Explore the online worksheet illustrations
Open each section to read the operating assumptions and illustration. These web views are not screenshots or downloadable Excel files.
Esthetics & Skincare BusinessHTML illustration
EBITDA = Revenue − operating costs
Illustrative workbook layout · annual USD
Income statement
Year 1
Year 2
Year 3
Revenue
$185,185
$274,349
$274,349
Treatment supplies, retail goods and payment charges
$27,778
$41,152
$41,152
Owner, employee, employer allowance and licensed relief
$142,896
$142,896
$142,896
Premises, booking, marketing and operating overhead
$55,200
$55,200
$55,200
EBITDA
−$40,689
$35,101
$35,101
EBITDA margin
-22.0%
12.8%
12.8%
Online scenario illustration; not a screenshot of the purchased workbook. Costs are shown as positive outflows; EBITDA excludes interest, tax, depreciation and amortization.
01RevenueOperating assumptions
Revenue
Scenario purpose: The supplied current seller material describes a shared visit pool allocated by service mix, category prices and extra revenue per visit. This online illustration uses nonmedical facial completions and limited attached retail.
Inputs
Completed visits across both estheticians, counted once
Nonmedical facial categories, net service prices and mutually exclusive service mix
Operating days, opening date and selected monthly ramp
Expected retail basket per visitor, with separate goods cost
Full appointment-block schedule maintained outside the simple sales multiplier
Outputs
Visit-based earned facial revenue
Attached retail revenue without a duplicate customer-volume stream
Service-time and completed-visit reconciliation
Scope and limitations
The seller description supports completed visits, service categories and separately modeled product sales. Native workbook formulas have not been inspected.
Source offers and seller example forecasts do not establish this studio local prices, bookings or cost base.
Independent retail traffic, medical procedures and substantive memberships require their own operating and liability schedules.
02COGS & OPEXOperating assumptions
COGS & OPEX
Scenario purpose: Seller material describes direct, variable and fixed operating costs. The separately authored web case retains physical treatment cost when testing a service discount.
Inputs
Treatment products, disposables and variable linen per completed visit
Expected wholesale cost of retail goods
Payment channel, plan and percentage-plus-fixed charges
Recurring lease, utilities, insurance, booking, marketing, cleaning and upkeep
Outputs
Contribution before committed provider payroll
Monthly overhead allowance and cost classification
Discount sensitivity with revised per-visit contribution
Scope and limitations
No observed consumable cost or wholesale margin is claimed; replace allowances with a tested product basket and actual supplier terms.
Scheduled owner and employee wages remain in payroll and are not deducted a second time.
Base annual forecasts hold one variable fraction; discount scenarios require a separate cost calculation.
03PayrollOperating assumptions
Payroll
Scenario purpose: The seller description includes editable personnel assumptions. The online planning illustration pays all owner and employee hours, including nonappointment duties and a relief allowance.
Inputs
Owner treatment and management compensation
Employee hourly pay and complete paid weekly calendar
Selected employer-cost allowance with actual tax/benefit review
Paid qualified relief hours and availability
Offered blocks, turnover, breaks, training and administration
Outputs
Annual complete labor allowance
Paid-hours versus offered-appointment calendar
Capacity and absence-coverage checks
Scope and limitations
National employee wages provide context rather than a local recruiting offer.
A relief allowance does not establish an actually licensed available substitute or complete management cover.
No native staffing scheduler or formula linkage is certified from seller text.
04Capital and StartupOperating assumptions
Capital and Startup
Scenario purpose: Seller material describes editable capital assumptions; this web illustration distinguishes opening setup, refundable deposits, inventory, contingency and operating cash.
Inputs
Compatible-site layout and coordinated premises bids
Landed nonmedical equipment basket and initial inventory at cost
Deposit, pre-opening labor and setup timing
Construction contingency and a separate operating reserve
Actual funding sources and dated cash commitments
Outputs
Opening allocation by purpose
Reserve bridge against cumulative ramp losses
Separation of cash retained from expenses and installed assets
Scope and limitations
No equipment price, landlord allowance, local bid or signed lease is implied by the authored allocation.
The studio assumes existing practitioner licenses; initial training and lost qualifying-time earnings are additional for an unqualified founder.
No debt terms, property purchase or grant is assumed.
05IS, CF and BSOperating assumptions
IS, CF and BS
Scenario purpose: The supplied seller material describes income statement, cash flow and balance sheet reports. These online illustrations use StartFigures independently authored operating inputs.
Inputs
Reconciled completed-visit sales and paid operating expenses
Opening equipment, deposits, inventory and funding timing
Retail tax collections, refunds and prepaid service obligations where applicable
Actual depreciation, financing and tax assumptions for a full private model
Outputs
Five-year operating-profit proxy
Income-to-cash distinctions
Asset, deposit and working-capital review
Scope and limitations
The public operating proxy excludes depreciation, interest, income tax, replacement capital and owner distributions.
A service prepayment is a cash/liability event; completed service revenue is not added to the same receipt twice.
Current paid attachments, financial-statement formulas and delivery have not been audited.
06Scenarios and DashboardOperating assumptions
Scenarios and Dashboard
Scenario purpose: The current seller material presents scenario comparisons and a dashboard. The web case tests realized facial yield, completed visits and reserve use at the stated paid roster.
Inputs
Base and changed completed visits within the offered calendar
Realized service mix, discount participation and limited retail
Held or revised per-visit direct cost and committed payroll/overhead
Slower opening ramp and higher fixed-cost case
Outputs
Monthly operating coverage
Feasible reservation/completion comparison
Opening-cash exposure under selected adverse assumptions
Scope and limitations
Cases are selected assumptions, not probabilities, national outcomes or achieved client retention.
A higher ticket can require longer treatment time; validate duration rather than changing price and count independently.
Dashboard returns described by a seller do not certify owner take-home cash, payback or valuation for this case.
Ways to prepare your files
Template
Current product · Shopify checkout
Edit the financial model with your own assumptions.
Define the revenue drivers, operating modules, outputs and review criteria before agreeing the work.
Project quote · Schedule agreed with you
Assumptions you can change
Use the Excel template to compare your financial assumptions. Review the selected version's input structure and outputs before adapting it. The online inputs and outputs on this page explain this website's price, volume, cost and opening-budget assumptions; they do not edit or verify a workbook. Range endpoints represent modeled scopes or sensitivities, not measured national averages.
Neither template establishes local demand, licensing compliance, financing approval or available owner cash.
Esthetics & Skincare Business input assumptions · USD unless stated
Driver
Base input
Scenario range / treatment
Role in the calculation
Realized revenue per completed visit, including limited retail
$132.00
$110.00 – $160.00
Revenue per sold unit
Completed visits per day across both estheticians
8
5 – 10
Daily throughput in the stated operating scope
Operating days per week
5
4 – 5
Trading schedule
Fixed operating costs / month
$16,508
Held constant
Operating break-even threshold
Contribution margin
85.0%
Held constant
Share of sales available for fixed costs
Starting share of mature volume
40.0%
Base ramp input
Opening month revenue
Mature volume added / month
5.0%
Base ramp input
Monthly ramp increment, capped at mature volume
Ramp horizon
24 months
Base ramp input
Period checked for operating break-even
The opening budget and annual expense inputs also need local quotes and staffing estimates. This page shows fixed examples; the free calculator lets you change price, volume and trading days.
Volume-only sensitivity · revenue at mature volume · monthly USD
Scenario
Daily units
Monthly revenue
Break-even revenue
First operating break-even
Lower volume
5
$14,289
$19,421
Not reached
Base volume
8
$22,862
$19,421
Month 10
Higher volume
10
$28,578
$19,421
Month 7
Only completed visits per day across both estheticians changes. Realized revenue per completed visit, including limited retail: $132.00; 5 operating days per week. Fixed costs and contribution margin stay constant. “Not reached” means no operating break-even within the 24-month ramp. Years 1–3 and the opening calculator ramp use one operating base within whole-dollar rounding. Years 4–5 follow the stated annual assumptions. Slider cases do not change the annual forecast or measure cash payback.
Sample outputs from the current case
These results are calculated from the website’s illustrative assumptions. They illustrate planning calculations; they do not establish the purchased workbook’s formula behavior.
01 / Annual forecast
Revenue across five years
$185.2k
Year 1
$274.3k
Year 2
$274.3k
Year 3
$300.3k
Year 4
$327.3k
Year 5
Annual USD. Full values appear in the Dashboard presentation.
02 / Opening allocation
Where the opening budget goes
Compatible-site fit-out, sink, finishes and access work$18,000
Two-room equipment, storage, linen and furniture$9,000
Lease deposit and pre-opening occupancy$7,500
Initial treatment and retail stock at cost$5,500
Professional, permit, insurance and booking setup$6,000
Pre-opening labor, training and launch marketing$6,000
Opening contingency$8,000
Operating cash reserve$65,000
One-time budget: $125,000. This allocation is not a cumulative cash-flow forecast.
03 / Operating earnings
Year 3 costs and EBITDA
Against annual revenue of $274,349.
Treatment supplies, retail goods and payment charges$41,152
Owner, employee, employer allowance and licensed relief$142,896
Premises, booking, marketing and operating overhead$55,200
EBITDA$35,101
EBITDA margin: 12.8%. EBITDA is not cash available to the owner.
04 / Operating threshold
Volume needed to break even
Required whole units per day
7
Break-even revenue / month
$19,421
Base revenue / month at maturity
$22,862
First operating break-even
Month 10
Units mean completed visits per day across both estheticians. The ramp covers 24 months; operating break-even does not measure recovery of opening capital.
Years 1–3 and the opening calculator ramp use one operating base within whole-dollar rounding. Years 4–5 follow the stated annual assumptions. The website does not yet supply a complete funding, debt, tax and working-capital schedule for a cumulative cash-flow or payback chart. Read the full input basis and limitations.
Annual forecast and monthly operating reconciliation
Years 1–3 and the opening calculator ramp use one operating base within whole-dollar rounding. Years 4–5 follow the stated annual assumptions.
Original inputs · annual USD · whole-dollar rounding tolerance $5
Check
Annual forecast
Monthly calculator base
Year 1 revenue
$185,185
$185,185
Year 1 operating result
−$40,689
−$40,688
Year 2 revenue
$274,349
$274,349
Year 2 operating result
$35,101
$35,100
Year 3 revenue
$274,349
$274,349
Year 3 operating result
$35,101
$35,100
Year 3 / full-volume annual revenue
$274,349
$274,349
Year 3 / full-volume annual operating result
$35,101
$35,100
Year 1 uses months 1–12, Year 2 months 13–24 and Year 3 months 25–36. Full-volume rows use mature monthly sales and operating result × 12. The calculator holds price, days, contribution and fixed costs constant; an annual price, staffing or cost change can explain a separate path. Sliders do not change this comparison. Neither column measures cash flow, owner distributions or payback. Agreement tests arithmetic, not demand or cash funding. Input basis.
Both products in one cart
Model + Business Plan
Write the strategy and test the assumptions for your esthetics & skincare business together. Update the narrative when you change the forecast.
The Business Plan uses Word and the Financial Model uses Excel. The online illustrations use this website's scenario data and may differ from the purchased files.
Listed file format
XLSX
Editor
Microsoft Excel
Editing
Adapt forecast assumptions in Excel. Check the selected version's forecast length, worksheets and formula permissions; the online illustrations use a separate scenario.
Other software
Compatibility with alternative editors has not been verified.
Delivery and terms
Review the product description, delivery details, license and final total in Shopify before paying.
Use the purchase button to buy the Esthetics & Skincare Business Financial Model for $109 through Shopify. This is a one-time price in USD before any applicable taxes.
What do the online previews show?
The online preview explains Revenue, COGS & OPEX, Payroll, Capital and Startup, IS, CF and BS, Scenarios and Dashboard using this website's illustrative case. It is separate from the downloadable Excel model.
Are these previews pages from a finished file?
The web previews are rendered from the website's case record. They illustrate planning concepts and calculations; they are not screenshots or a page-by-page inventory of the downloadable product.
What would I need to change for my business?
Review realized revenue per completed visit, including limited retail, completed visits per day across both estheticians, the operating schedule, opening budget and costs. These web previews do not edit a workbook. Test the website's price and volume assumptions in the business idea page's calculator.
Is the written business plan included?
The Financial Model is sold separately. The $168 Bundle adds the $59 Business Plan and $109 Financial Model for the same business to one cart, one of each.
Do the figures establish what my business will earn?
No. The figures describe an illustrative U.S. operating case, not measured industry averages or a prediction for your location. EBITDA is not owner cash, and operating break-even does not recover the opening investment. Check local costs, capacity and demand before using the assumptions.
Do the web previews reproduce the purchased files?
The online outlines, tables and worksheet illustrations use this website's scenario. They are not screenshots, a verified page count or a confirmed worksheet inventory of the purchased files. Check the selected product's specification before buying.
How are the files delivered?
Review the selected item's delivery method and license in Shopify before paying. These pages do not document a completed purchase or download test.
