Revenue & Calc
Edit room capacity, monthly hours, utilization, treatment allocations and hourly-equivalent receipts; Calc applies launch timing to the monthly revenue forecast.

The Laser Hair Removal Financial Model is an Excel template for a single-room studio that converts available treatment hours, utilization and treatment mix into revenue and operating EBITDA. It connects service pricing, staffing, recurring costs and startup funding assumptions to a five-year planning case.
The example assumes an independent studio in approximately 800 leased square feet in suburban Houston, Texas. January 2026–December 2030 is a hypothetical forecast, with January 31, 2026 recorded as launch; these are not historical actuals.
The Excel template connects clinic assumptions to monthly calculations, scenario comparisons and standard financial reports.
Edit room capacity, monthly hours, utilization, treatment allocations and hourly-equivalent receipts; Calc applies launch timing to the monthly revenue forecast.
Set revenue-linked costs, fixed spending and staffing assumptions separately, with payroll inputs for employment dates, annual FTE and salaries.
Adjust Low, Base and High multipliers for revenue, COGS, variable expenses, fixed expenses and payroll, then compare margins and EBITDA.
Review the standard income statement, cash flow and balance sheet reports together through Summary; Checks supports reconciliation and input review.
One shared treatment-hour pool drives revenue, with each sold hour allocated to exactly one of five treatment areas.
The case equips one room with an owned refurbished dual-wavelength laser and provides 120 available treatment hours monthly. Annual utilization increases from 35% in 2026 to 45%, 55%, 65% and 72% in the following forecast years.
Treatment receipts and procedure durations are expressed as hourly equivalents, so the rates below are not per-session prices. Allocations total 100%; the model does not forecast a separate demand pool for each service.
| Treatment area | Sold-hour share | Receipts per hour |
|---|---|---|
| Underarm | 20% | $400 |
| Upper lip | 10% | $240 |
| Bikini line | 15% | $450 |
| Brazilian | 25% | $400 |
| Full leg | 30% | $400 |
Estimated planning inputs; the weighted average is $391.50 per sold treatment hour.
The Revenue Forecast links room availability, utilization and treatment mix to sales. Editing the allocation changes weighted hourly receipts, while changing utilization changes sold hours within the same capacity limit.
1 room × 120 hours/month × 12 months × 35% utilization × $391.50/hour = $197,316 annual revenue.
The supplied 2026 revenue uses 12 full monthly capacity periods; it does not prorate January’s treatment hours.
Operating expenses combine 11% of revenue with $80,400 in annual fixed costs and $115,000 in annual base payroll.
The COGS and Operating Expense Forecast separates treatment consumables at 4% of revenue from processing at 3%, acquisition at 4% and fixed operating costs. Fixed expenses include rent and common-area occupancy of $2,500 monthly.
| Role | Annual-average FTE | Annual base per FTE |
|---|---|---|
| Registered laser professional | 1 | $60,000 |
| Receptionist | 0.5 | $40,000 |
| Working owner-manager | 0.5 | $70,000 |
Estimated salaries produce $115,000 annual payroll across 2.0 FTE; these salaries are counted only in Payroll.
The Payroll Forecast calculates staffing costs from FTE, fixed salaries and employment dates. This case combines one full-time registered laser professional with a half-time receptionist and half-time working owner-manager; employer taxes, benefits and personal taxes are excluded.
Consulting and alternate physician services are budgeted through a separate external agreement within fixed costs. Utilities, insurance, software, baseline marketing, maintenance, professional services, cleaning and compliance renewals are also included in fixed coverage.
Startup assets, other opening cash and owner funding are distinct from the annual operating expense forecast.
The Capital Expenditure Plan schedules asset spending and tracks depreciation. Estimated items include the $60,000 installed refurbished laser, $25,000 qualifying fitout, $4,500 treatment equipment and $4,000 reception furniture, plus computer and point-of-sale equipment.
Refundable deposits, entity setup, opening legal work, prelaunch promotion and preopening training pay and occupancy are separate startup cash items. Receivables and payables are set to zero days, with 30 inventory days; customers pay at service and suppliers are prepaid.
Sources and Uses of Funds reconciles funding sources and cash allocation over a selected period. The estimated $170,425 owner funding covers startup assets, other launch cash, opening materials and three months of first-year recurring outflows, with zero committed outside funding.
The illustrated case moves from an EBITDA loss in 2026 to positive annual EBITDA in 2027.
| Year | Revenue | Operating Expenses | EBITDA |
|---|---|---|---|
| 2026 | $197,316 | $217,105 | −$19,789 |
| 2027 | $253,692 | $223,306 | $30,386 |
| 2028 | $310,068 | $229,507 | $80,561 |
| 2029 | $366,444 | $235,709 | $130,735 |
| 2030 | $405,907 | $240,050 | $165,857 |
Hypothetical projections, rounded to whole dollars; independent rounding may cause small differences between displayed totals.
Revenue rises from $197,316 in 2026 to $405,907 in 2030 as utilization increases at constant room capacity, mix and hourly receipts. EBITDA moves from a $19,789 loss to $165,857, with fixed expenses and base payroll unchanged.
The supplied operating forecast ends at EBITDA, so it does not establish net profit, cash balances or investment returns.
The Cash Flow Forecast shows operating, investing and financing movements and reconciles opening to closing cash. Use it to assess customer receipts, prepaid supplies, equipment purchases and funding; EBITDA alone does not measure liquidity.
The Returns sheet separates operating break-even, cash break-even, investment payback and annual ROIC.
Sales break-even compares revenue with the level needed to cover the modeled cost structure; cash break-even concerns cash coverage and timing. Investment payback follows cumulative project free cash flow until the investment is recovered.
Annual ROIC relates operating returns to invested capital and is distinct from both payback timing and IRR. No payback date, ROIC percentage or IRR result is established by the supplied EBITDA forecast.
The Returns report brings sales break-even, project and cumulative free cash flow, invested capital and ROIC together. Use these measures to examine whether the laser investment and working capital are supported by the completed cash-flow assumptions.
Dashboard Debt Controls feed the Debt schedules for financing terms and repayments; the case assumes no committed outside funding. Valuation supports discounted cash flow and sensitivity analysis, but the brief supplies no valuation result.
This template fits an owner-managed, single-room studio planning treatment capacity, staffing, equipment purchases and opening funding.
The modeled offering covers five laser treatment areas without retail sales, memberships, prepaid packages, franchise fees, gratuities or collected sales taxes. Businesses with additional rooms, mixed aesthetic services or different payment arrangements should revise the operating structure and funding assumptions.
These answers clarify the editable assumptions, scope and limits of the illustrative case.
Yes, Revenue inputs cover room capacity, monthly hours, utilization, exclusive treatment allocations and hourly-equivalent receipts, which feed the monthly calculations.
No, the five service rates are hourly-equivalent receipts derived from procedure receipts and durations; the supplied case does not state individual session prices.
No, all five areas share one room’s treatment-hour pool, with mutually exclusive allocations totaling 100%.
No, the example includes fixed base salaries but excludes employer taxes, benefits and personal income taxes.
No, the $170,425 estimate uses a three-month reserve policy; it has not been tested against peak cash needs.
No, the figures are illustrative planning outputs, and selections marked Estimated are not independently verified by the companion’s cited menus or occupational reference.
Low, Base and High controls compare profitability, and Returns supports payback analysis; the supplied example provides no tested payback or ROIC result.
KPIs, forecasts, and cash flow at a glance.
Key assumptions and calculations driving revenue forecasts.
Funding sources, spending, and closing cash.
Cash break-even, payback, and ROIC.
DCF valuation and sensitivity analysis.
Largest costs and spending trends.
Annual and monthly financial performance.
Compare margins and returns to benchmarks.
I stopped chasing numbers across different files and finally had one place for statements and charts. It made monthly reporting easier to review and cut our prep time by about 3 hours.
Building the full forecast by hand was taking forever, and this template shaved it down to an afternoon. I saved roughly 8 hours on the first pass alone, which let me focus on pricing and launch planning.
Switching between low, base, and high cases used to be messy, but this model keeps the assumptions organized. I could compare scenarios in minutes instead of reworking the whole sheet each time.