Revenue and Calc
Revenue holds capacity, utilization, service shares and rates. Calc allocates the single sold-hour pool across months and services, connecting a change in the work schedule to annual sales.

This Mobile Hair Salon Financial Model is an Excel template for a solo hairstylist visiting clients around Portland, Oregon. It turns available hours, utilization, five service allocations and realized hourly rates into monthly and annual revenue forecasts.
The illustrative 2026–2030 plan begins with a full month at its January 31, 2026 launch. The stylist uses a compact transport vehicle and portable tools; the home serves administration only, with no salon van or retail product sales.
The workbook links a single stylist’s operating assumptions with financial statements, investment schedules and checks.
Revenue holds capacity, utilization, service shares and rates. Calc allocates the single sold-hour pool across months and services, connecting a change in the work schedule to annual sales.
COGS & OPEX separates consumables, sanitation, processing, travel, marketing and overhead. Payroll models the owner's salary independently so it is not duplicated in cost percentages.
CAPEX schedules vehicle and equipment purchases; CapTable records equity. Sources & Uses and Cash Flow distinguish funding, operating receipts, asset spending and financing movements.
Dashboard, Income Statement, Balance Sheet and Summary organize results. Scenarios, Returns, Valuation, Ratios and Checks support decisions and reconciliation without guaranteeing business outcomes.
Revenue starts with available stylist hours and utilization, not a separate appointment count for every service.
The model starts with 160 available stylist hours monthly. Billable utilization is 45% in 2026, then 52%, 58%, 64% and 68%; unbilled hours cover driving, setup and administration.
Sold stylist-hours are allocated once: haircuts and finishing 30%, blowouts 15%, root color 25%, highlights and balayage 20%, and event hair styling 10%. Color finishing stays within the color service; there is no retail resale.
The Revenue Forecast links monthly stylist hours, billable utilization, service mix and realized per-hour rates to projected sales. Calc distributes the resulting activity across forecast months, letting the owner evaluate utilization and allocation changes without double-counting capacity.
160 available hours × 45% billable utilization × $102.25 weighted realized revenue per sold hour = $7,362 monthly revenue; 12 months produce $88,344 in 2026.
The modeled per-hour rates are $100 for haircuts, $75 for blowouts, $100 for roots, $110 for highlights and $140 for event styling. Rates remain flat across the forecast, so higher utilization—not price inflation—drives growth.
Expenses combine revenue-linked rates, fixed monthly spending and one owner-stylist base salary.
Direct costs are 10.5% of sales: 9% for color and backbar materials and 1.5% for laundry and sanitation. Variable costs add 11%: 3% payment processing, 4% fuel and parking, and 4% referral marketing.
The COGS and Operating Expenses forecast applies direct and variable cost rates while scheduling recurring overhead. It helps show which expenses increase with service revenue and which remain fixed as the stylist fills more available hours.
Annual fixed overhead of $9,180 includes professional and vehicle insurance, maintenance, storage, booking, bookkeeping, licensing, education and equipment repairs. Professional and tools insurance is estimated at $25 monthly.
The Payroll Forecast includes one owner stylist at 1.0 annual-average FTE with $48,000 in annual fixed base pay. The salary is a separate payroll expense rather than another percentage added to COGS or variable costs.
The opening budget separates durable assets, launch cash, inventory and a planning reserve from annual operating costs.
Startup assets total $21,500: an $18,000 used compact vehicle, $2,000 styling tools, an $800 portable wash station and $700 in booking hardware. The plan excludes a converted salon vehicle and customer-facing premises.
The Capital Expenditure Plan organizes purchases such as the service vehicle, wash station and reusable styling equipment. It also supports depreciation schedules for accounting reports, while the initial capital outlay remains separate from the operating EBITDA calculation.
Additional opening cash covers $1,800 in registration, preopening marketing and refundable deposits, plus $653.50 of material stock. A $19,043 reserve represents three months of recurring expenses; it has not been tested against peak cash needs.
The Sources and Uses of Funds report reconciles owner contributions with cash allocated to purchases, operations and retained balances. The illustrative opening plan specifies $42,997 of initial owner equity, with no other funding in the documented case.
Receivable and payable days are zero; inventory days are 26. These working-capital controls affect financial statements and liquidity schedules but do not prove cash sufficiency.
Higher billable utilization raises projected revenue and EBITDA without adding a second stylist or increasing hourly prices.
| Year | Revenue | Operating Expenses | EBITDA |
|---|---|---|---|
| 2026 | $88,344 | $76,174 | $12,170 |
| 2027 | $102,086 | $79,129 | $22,958 |
| 2028 | $113,866 | $81,661 | $32,205 |
| 2029 | $125,645 | $84,194 | $41,451 |
| 2030 | $133,498 | $85,882 | $47,616 |
Illustrative forecasts, not observed results. Amounts are rounded to whole dollars; displayed totals may differ slightly.
Revenue rises from $88,344 in 2026 to $133,498 in 2030 as utilization grows within 160 monthly hours. Operating expenses cover materials, variable costs, overhead and the $48,000 owner salary.
Illustrative EBITDA rises from $12,170 to $47,616. These results exclude depreciation, interest and taxes, and do not establish net profit, investment payback or cash balances.
The Cash Flow Forecast tracks cash receipts, operating payments, capital spending and financing movements separately from EBITDA. Use it to assess liquidity consequences of the opening equity contribution, vehicle purchase and working-capital assumptions rather than treating earnings as available cash.
The workbook distinguishes the operating sales threshold, cumulative cash recovery and return on invested capital.
Sales break-even measures revenue needed to cover operating costs. Cash break-even follows cumulative cash generation, and investment payback measures recovery of invested funds; annual EBITDA alone establishes none of these timings.
The Returns report examines sales break-even, cash break-even, investment payback and annual ROIC as separate calculations. It can help test whether changes to utilization, expenses or startup investment alter the investment case, but no specific payback month or ROIC is supplied here.
Dashboard Scenario Controls use Low, Base and High multipliers for revenue and cost groups. Scenarios compares margins and EBITDA; Valuation and Ratios support additional analysis when relevant assumptions are supplied.
It fits a qualified solo stylist planning portable home-visit services rather than a staffed storefront.
Test slower utilization, alternative service mix and cost changes without creating more billable hours than the stylist has available.
Replace estimated prices, costs and travel assumptions with actual business data. Public menus supply context, not verification of this case.
These answers clarify the operating assumptions and what the financial reports can and cannot establish.
No. It assumes a used compact vehicle carrying portable tools for client home visits, with an existing home used only for administration.
Monthly sales equal available stylist hours times billable utilization, allocated once across five service categories and multiplied by each realized hourly rate.
Yes. Edit the utilization, five service shares and realized hourly prices in Revenue; Calc uses those inputs for the monthly forecast.
Yes. The illustrative plan budgets one full-time-equivalent owner stylist at $48,000 per year, separately from direct and variable operating costs.
No. It is planned owner equity for equipment, setup, materials and a reserve—not earnings, a verified cash requirement or an investment return.
No. EBITDA excludes investing cash flows; Cash Flow, CAPEX and Sources & Uses address purchase and funding movements separately.
It includes Low, Base and High scenario tools and Returns calculations, but the illustrated operating forecast does not establish a specific payback period or ROIC.
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 finally knew what to show investors and in what order. It saved me hours of second-guessing and made the whole pitch feel much cleaner.
The runway and shortfall view made it easy to see when cash would get tight. I caught a funding gap early and planned around it instead of guessing.
Pricing, labor, and growth were all in one place, so the model stopped feeling scattered. I cleaned up my assumptions in under an hour and could explain them without digging through sheets.