Revenue & Calc
Change tables, daily turns, trading days, utilization, package mix and session prices; monthly calculations allocate one shared capacity pool and consolidate earned revenue.

The Hookah Lounge Financial Model is an Excel template for projecting table-session revenue, operating costs and EBITDA for an adult-only tobacco-retail lounge. Editable capacity, utilization, package prices, staffing and startup inputs connect the operating plan to the workbook’s financial reports.
The illustrative Phoenix, Arizona case covers 2026–2030 in US dollars, net of sales taxes and customer tips. It assumes 20 three-seat tables in 2,000 square feet, bundled nonalcohol refreshments, no alcohol and no hot kitchen.
The workbook connects editable lounge assumptions to monthly calculations, operating comparisons and financial statements.
Change tables, daily turns, trading days, utilization, package mix and session prices; monthly calculations allocate one shared capacity pool and consolidate earned revenue.
Plan direct, sales-linked and fixed expenses separately from role-based salaries; compare cost changes with table-session revenue and EBITDA.
Set Low, Base and High multipliers for revenue, COGS, variable costs, fixed costs and payroll; compare their effects on operating profitability.
Review income, cash flow and balance sheet reports together; the supplied case documents numerical outputs only through EBITDA, so other financial results require separate workbook review.
One table-session pool is allocated once across five exclusive packages, then multiplied by each package’s net price.
Twenty tables × 3.5 turns × 26 trading days provide 1,820 available table sessions per month. Two-hour sessions across seven opening hours support the aggregate turns assumption; utilization sets the share of capacity sold.
The Revenue Forecast connects table capacity, seasonal utilization, package mix and net prices to earned sales. Classic, premium, fruit, luxury and two-bowl sharing packages receive 35%, 30%, 15%, 15% and 5% of sessions, respectively, with refreshments already included.
9,828 used table sessions × $47.00 weighted spend per session = $461,916 annual revenue.
Seasonality averages 1.00 annually; base utilization rises from 45% in 2026 to 65% in 2030, with a 71.5% seasonal peak. The January 31, 2026 launch activates a full January; months before an edited launch date produce zero revenue.
Annual used sessions increase to 14,196 by 2030, while the weighted spend reaches $52.30 per session as package prices increase.
Direct and other variable costs scale with sales, while fixed bills and Payroll are calculated separately.
The COGS and Operating Expenses report separates revenue-linked costs from monthly fixed spending. Shisha and charcoal, bundled refreshments, and mouthpieces and foil total 19% of revenue; processing, sales-linked advertising and laundry add 5.5%.
Fixed operating expenses are $115,800 in 2026 and $127,822 in 2030, covering occupancy, utilities, insurance, marketing, software, maintenance, administration, waste services and security. Rent starts at $4,500 per month and reaches approximately $4,967 per month in 2030.
The Payroll Forecast calculates fixed base pay from annual-average FTE by role. One manager, attendants, host/cafe staff and a half-FTE cleaner total 5.0 FTE in 2026 and 6.0 in 2030, producing annual payroll of $208,000 and $244,000.
Opening assets, separate preopening payments and working capital form the startup funding plan.
The Capital Expenditure Plan schedules asset purchases and depreciation where applicable. Selected startup assets include $38,000 for ventilation, $30,000 for leasehold improvements, $18,000 for furniture and $7,000 for hookah pipes and durable accessories.
Additional startup assets include burners, refreshments equipment, POS hardware, cameras and signage. Separate opening cash items cover the lease deposit, permits, preopening marketing, legal setup and training pay; these are distinct from recurring operating expenses.
Sources and Uses of Funds reconciles funding sources and cash allocation over selected forecast months. The case’s estimated $242,292 owner contribution includes assets, distinct one-time payments, opening physical working capital and a three-month recurring-outflow reserve; no external funding is committed.
Working-capital controls are 0 receivable days, 0 payable days and 21 inventory days. Dashboard Debt Controls and the Debt schedule can model financing terms and repayments, but no borrowing amount or loan approval is established by this case.
The selected lounge assumptions produce rising revenue and EBITDA across all five forecast years.
| Year | Revenue | Operating Expenses | EBITDA |
|---|---|---|---|
| 2026 | $461,916 | $436,969 | $24,947 |
| 2027 | $526,890 | $473,783 | $53,107 |
| 2028 | $596,396 | $511,779 | $84,617 |
| 2029 | $666,994 | $532,117 | $134,876 |
| 2030 | $742,451 | $553,722 | $188,729 |
Illustrative projections, rounded to whole dollars; displayed revenue less expenses may differ from displayed EBITDA by $1.
EBITDA margin increases from approximately 5.4% in 2026 to 25.4% in 2030 as session volume and prices grow while payroll levels off after 2028. These are model outputs from estimated inputs, not historical results or industry averages.
The Cash Flow Forecast separates operating, investing and financing cash movements and reconciles opening with closing cash. Review inventory purchases, startup investment and funding timing here; positive EBITDA and a planned reserve do not establish tested cash sufficiency.
The Returns report helps evaluate cost coverage and investment recovery using distinct operating and cash measures.
The Returns report evaluates sales break-even, cash break-even, investment payback and annual ROIC using its supporting schedules. For this lounge, review those measures after changing session utilization, payroll or startup investment.
Sales break-even compares revenue with operating cost coverage; cash break-even identifies when cash inflows cover relevant cash outflows. Investment payback tracks recovery of the initial investment, while annual ROIC measures operating returns on invested capital.
The Valuation report uses discounted unlevered free cash flow and terminal assumptions, with sensitivity to discount rates and terminal valuation. The supplied case establishes no valuation, payback period or ROIC result.
The model fits a session-based tobacco lounge with shared tables and refreshments bundled into package prices.
The supplied planning case requires premises that qualify for Arizona’s tobacco-store exemption and prevent smoke infiltration, with tobacco remaining the majority of receipts. The template does not establish that a proposed location or package allocation meets those conditions.
Capacity, staffing, prices and startup amounts are planning estimates rather than independently verified local benchmarks. Replace them with your proposed operating plan and supplier quotes before using the projections to make investment decisions.
These answers clarify the editable assumptions and the illustrated case’s scope.
Yes; edit package prices, allocation shares, utilization and seasonality alongside tables, trading days and turns, while keeping all packages within one shared table-session pool.
No; the documented two-bowl sharing package occupies one table session, just like each other package, so its higher spend does not create additional capacity.
No; this case models an adult-only tobacco-retail lounge with incidental nonalcohol refreshments included in package spend and no hot kitchen.
The single launch date activates the entire selected month across all packages; earlier months generate zero revenue, rather than prorating the launch month by trading days.
Yes; Dashboard Scenario Controls apply Low, Base and High multipliers to revenue and four expense groups, while the Scenarios report compares revenue, margins and EBITDA.
No; the documented operating forecast ends at EBITDA, and the declared financial statements and Returns reports require their supporting cash, financing, depreciation and tax assumptions before those outcomes can be assessed.
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 was stuck before I even began, and this template gave me a clean place to start. It turned the blank-sheet problem into a workable draft in under an hour.
Building the model by hand would have eaten up days, but this saved me a ton of time. I had a full five-year view ready for review the same afternoon.
The cash-flow layout made it much easier to see runway and possible shortfalls month by month. That clarity helped me plan funding needs before they became urgent.