$0.00

Hookah Lounge Five-Year Financial Model Template

Excel or Google Sheets. Open, edit, send. No plugins, no Office 365 lock-in, no 'request a demo' loop.
  • Fully Editable
  • Instant Download
  • Professional Design
  • Pre-Built
  • No Expertise Is Needed

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.

Forecast
5years
Hookah tables
20shared session capacity
Service packages
5exclusive allocations
WORKBOOK CONTENTS

What the Excel Template Includes

The workbook connects editable lounge assumptions to monthly calculations, operating comparisons and financial statements.

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.

COGS & OPEX / Payroll

Plan direct, sales-linked and fixed expenses separately from role-based salaries; compare cost changes with table-session revenue and EBITDA.

Dashboard & Scenarios

Set Low, Base and High multipliers for revenue, COGS, variable costs, fixed costs and payroll; compare their effects on operating profitability.

IS, CF, BS & Summary

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.

TABLE-SESSION REVENUE

How Shared Table Capacity Produces Revenue

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.

Revenue Forecast

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.

2026 shared-capacity revenue calculation

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.

OPERATING COSTS

How Costs and Staffing Affect EBITDA

Direct and other variable costs scale with sales, while fixed bills and Payroll are calculated separately.

COGS and Operating Expenses

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.

Payroll Forecast by Staff Role

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.

STARTUP AND FUNDING

How Startup Funding Differs From Operating Costs

Opening assets, separate preopening payments and working capital form the startup funding plan.

Capital Expenditure 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

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.

ILLUSTRATIVE PROJECTIONS

What the Five-Year Operating Forecast Shows

The selected lounge assumptions produce rising revenue and EBITDA across all five forecast years.

Illustrative Hookah Lounge forecast, USD
YearRevenueOperating ExpensesEBITDA
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.

Cash Flow Forecast

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.

BREAK-EVEN AND RETURNS

What Break-Even, Payback and ROIC Measure

The Returns report helps evaluate cost coverage and investment recovery using distinct operating and cash measures.

Break-Even, Payback and ROIC

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.

MODEL FIT

Where This Lounge Planning Model Fits

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.

COMMON QUESTIONS

Hookah Lounge Financial Model Questions

These answers clarify the editable assumptions and the illustrated case’s scope.

Can I change package prices and utilization?

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.

Does a two-bowl order use two sessions?

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.

Does the example include alcohol or kitchen sales?

No; this case models an adult-only tobacco-retail lounge with incidental nonalcohol refreshments included in package spend and no hot kitchen.

How does changing the launch date affect revenue?

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.

Can I compare alternative operating cases?

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.

Does the example establish net profit or payback?

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.

What Does the Hookah Lounge Financial Model Contain?

Financial Dashboard

KPIs, forecasts, and cash flow at a glance.

Revenue Engine

Key assumptions and calculations driving revenue forecasts.

Sources & Uses

Funding sources, spending, and closing cash.

Returns & Break-Even

Cash break-even, payback, and ROIC.

Business Valuation

DCF valuation and sensitivity analysis.

Expense Breakdown

Largest costs and spending trends.

Financial Summary

Annual and monthly financial performance.

KPI Benchmarks

Compare margins and returns to benchmarks.

Trusted by 25,000+ startup founders, investors and CPAs

Blank Page, Clear Start

Megan Harris, NY

4 star rating

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.

Hours Back in My Week

Derek Collins, TX

4 star rating

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.

Runway Became Easier To See

Priya Shah, CA

5 star rating

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.