Test the price, capacity and costs behind your nail salon. Explore the online worksheet previews alongside calculations from the current illustrative business case.
6 online worksheet illustrations, described below
Opening budget, scenario assumptions and dashboard views
Five-year forecast and separate operating break-even sensitivity
Editable Excel product with assumptions and formulas
The online preview illustrates 6 planning sections using this website's scenario. These illustrations are separate from the downloadable workbook.
01Assumptions & RevenueBuild sales from one shared pool of completed nail-service visits, mutually exclusive service mix, category prices and ancillary add-on or retail revenue per visit.Explore layout ↓
02COGS & OPEXSeparate polish, gel, acrylic, dip, disposables, sanitation supplies, card fees and retail cost from premises, software, insurance, laundry and other overhead.Explore layout ↓
03PayrollTranslate a paid working owner-manager, eight employee nail technicians and limited reception or cleaning support into a complete labor budget.Explore layout ↓
04Capex & FundingSchedule the ventilation and leasehold work, pedicure systems, manicure stations, tools, deposits, opening costs, reserve and funding sources.Explore layout ↓
05Scenarios & Break-evenCompare net sale, service mix, completed visits, appointment completion, contribution margin, fixed costs and usable technician minutes.Explore layout ↓
06Dashboard & Financial StatementsConnect the selected operating case to five-year income statement, cash flow, balance sheet, KPI and investment views.Explore layout ↓
Explore the online worksheet illustrations
Open each online sheet presentation to read its specification and illustration. These web views are not screenshots or downloadable Excel files.
Nail SalonPlanned XLSX
EBITDA = Revenue − operating costs
Illustrative workbook layout · annual USD
Income statement
Year 1
Year 2
Year 3
Revenue
$468,000
$552,000
$617,760
Nail products, disposables, card fees and retail cost
$93,600
$107,640
$117,374
Paid owner and staff incl. employer costs
$318,000
$340,000
$360,000
Occupancy and other operating costs
$112,000
$115,000
$118,000
EBITDA
−$55,600
−$10,640
$22,386
EBITDA margin
-11.9%
-1.9%
3.6%
Planned presentation, not a completed file. Costs are shown as positive outflows; EBITDA excludes interest, tax, depreciation and amortization.
01Assumptions & RevenueWorksheet specification
Assumptions & Revenue
Planned purpose: Build sales from one shared pool of completed nail-service visits, mutually exclusive service mix, category prices and ancillary add-on or retail revenue per visit.
Inputs
Completed visits by day and month
Manicure, pedicure, gel and extension service mix
Net price by service category
Ancillary add-on and retail revenue per completed visit
Outputs
Monthly and annual revenue
Revenue by service category
Visit, mix, price and ancillary-revenue reconciliation
Limits and completion needs
Visit volume, mix and price are scenarios until replaced with booking and POS records.
Sales tax and pass-through tips remain outside net revenue; discounts and refunds reduce it.
02COGS & OPEXWorksheet specification
COGS & OPEX
Planned purpose: Separate polish, gel, acrylic, dip, disposables, sanitation supplies, card fees and retail cost from premises, software, insurance, laundry and other overhead.
Inputs
Product use and waste by service
Disposable and sanitation cost
Tender mix and card-processing assumptions
Rent, utilities, insurance, software, maintenance and waste handling
Outputs
Sales-linked cost schedule
Operating-expense schedule
Contribution and overhead bridge
Limits and completion needs
Supplier invoices, measured product use and merchant statements must replace provisional amounts.
A national asking-rent figure does not establish local occupancy cost.
03PayrollWorksheet specification
Payroll
Planned purpose: Translate a paid working owner-manager, eight employee nail technicians and limited reception or cleaning support into a complete labor budget.
Inputs
Roles, paid hours and wage or salary inputs
Commission, tips and employer-cost treatment
Opening and mature staffing levels
Training, nonservice time, leave and absence coverage
Outputs
Role-by-role payroll
Weekly and annual staffing cost
Payroll per completed visit and usable service hour
Limits and completion needs
National wage data do not replace local recruiting offers, commission terms or tip practices.
Worker status must follow the facts and applicable law rather than the label used in the model.
04Capex & FundingWorksheet specification
Capex & Funding
Planned purpose: Schedule the ventilation and leasehold work, pedicure systems, manicure stations, tools, deposits, opening costs, reserve and funding sources.
Inputs
Engineer, contractor and vendor bids
Deposits and authority fees
Opening supplies and pre-opening payroll
Debt, equity and working-capital timing
Outputs
Sources-and-uses schedule
Opening cash requirement
Funding gap and cash runway
Limits and completion needs
The $360,000 case is a planning allocation rather than a quote.
Debt terms, tax, project overruns and owner distributions need dated cash inputs.
05Scenarios & Break-evenWorksheet specification
Scenarios & Break-even
Planned purpose: Compare net sale, service mix, completed visits, appointment completion, contribution margin, fixed costs and usable technician minutes.
Inputs
Low, base and high visit cases
Service mix, price, duration and product use
Contribution margin and fixed costs
Booked-to-completed conversion and usable technician hours
Outputs
Break-even sales and completed visits
Required bookings at the selected completion rate
Operating surplus, shortfall and labor-capacity sensitivity
Limits and completion needs
A scenario is not a probability or a local demand forecast.
A visit target is infeasible when technician skills, sanitation time or the required station type do not fit the schedule.
Define the revenue drivers, operating modules, outputs and review criteria before agreeing the work.
Project quote · Schedule agreed with you
Assumptions you can change
These are the current inputs behind the business case and the intended starting points for the editable workbook. Range endpoints represent modeled scopes or sensitivities, not measured national averages.
Nail Salon input assumptions · USD unless stated
Driver
Base input
Scenario range / treatment
Role in the calculation
Net sales per completed visit
$55.00
$38.00 – $90.00
Revenue per sold unit
Completed client visits per day
36
22 – 50
Daily throughput in the stated operating scope
Operating days per week
6
5 – 7
Trading schedule
Fixed operating costs / month
$39,833
Held constant
Operating break-even threshold
Contribution margin
81.0%
Held constant
Share of sales available for fixed costs
Starting share of mature volume
52.0%
Base ramp input
Opening month revenue
Mature volume added / month
3.0%
Base ramp input
Monthly ramp increment, capped at mature volume
Ramp horizon
18 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
22
$31,436
$49,177
Not reached
Base volume
36
$51,440
$49,177
Month 16
Higher volume
50
$71,445
$49,177
Month 7
Only completed client visits per day changes. Net sales per completed visit: $55.00; 6 operating days per week. Fixed costs and contribution margin stay constant. “Not reached” means no operating break-even within the 18-month ramp. This sensitivity is separate from the annual forecast and does not measure cash payback.
Sample outputs from the current case
These results are calculated from the website’s illustrative assumptions. They demonstrate intended workbook topics, not a tested Excel file.
01 / Annual forecast
Revenue across five years
$468k
Year 1
$552k
Year 2
$617.8k
Year 3
$665k
Year 4
$715k
Year 5
Annual USD. Full values appear in the Dashboard presentation.
02 / Opening allocation
Where the opening budget goes
Leasehold work, plumbing, electrical, ventilation and finishes$135,000
Six pedicure spas, six manicure stations and installed equipment$70,000
Tools, task lighting, sanitation equipment and opening supplies$22,000
POS, furnishings, signage and security$18,000
Permits, design, deposits, recruiting, training and launch$25,000
Working capital reserve$90,000
One-time budget: $360,000. This allocation is not a cumulative cash-flow forecast.
03 / Operating earnings
Year 3 costs and EBITDA
Against annual revenue of $617,760.
Nail products, disposables, card fees and retail cost$117,374
Paid owner and staff incl. employer costs$360,000
Occupancy and other operating costs$118,000
EBITDA$22,386
EBITDA margin: 3.6%. EBITDA is not cash available to the owner.
04 / Operating threshold
Volume needed to break even
Required whole units per day
35
Break-even revenue / month
$49,177
Base revenue / month at maturity
$51,440
First operating break-even
Month 16
Units mean completed client visits per day. The ramp covers 18 months; operating break-even does not measure recovery of opening capital.
The annual forecast and fixed-cost sensitivity are separate planning views. 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 calculator comparison
The annual forecast and calculator use separate scenarios. Their revenue ramp or cost allocations differ, as shown below. The calculator's break-even month does not reconcile the annual forecast.
Original base inputs · USD per year
Check
Annual forecast
Calculator inputs
Year 1 revenue
$468,000
$422,840
Year 1 operating result
−$55,600
−$135,496
Year 3 / mature annual operating result
$22,386
$22,005
Calculator figures use the original first 12 months and mature monthly result × 12; sliders do not change this comparison. Neither column measures cash flow or payback. Input basis.
Both products in one cart
Model + Business Plan
Write the strategy and test the assumptions for your nail salon 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.
File format
XLSX
Editor
Microsoft Excel
Editing
Input cells, forecast assumptions and formulas; workbook behavior still needs verification.
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 Nail Salon 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 Assumptions & Revenue, COGS & OPEX, Payroll, Capex & Funding, Scenarios & Break-even, Dashboard & Financial Statements 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 net sales per completed visit, completed client visits per day, 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.
