Demand, Mix & Revenue
Revenue and Calc turn paid monthly product units, selling prices, category shares, and launch timing into five individual product forecasts and consolidated sales.
Cigar Lounge Financial Model
Fully Editable
Instant Download
Professional Design
Pre-Built
No Expertise Is Needed
Fully Editable
Instant Download
Professional Design
Pre-Built
No Expertise Is Needed
Description
The Cigar Lounge Financial Model is an Excel financial planning template for an independent cigar retail lounge. It connects paid product demand, five merchandise categories, realized selling prices, merchandise costs, staffing, startup investment, and financing assumptions to a five-year forecast from 2026 through 2030.
The illustrative case is an owner-operated lounge in leased Tampa, Florida premises with 40 lounge seats. Sales come from cigars, take-home boxes, and accessories; lounge access is complimentary with purchase, so the forecast does not assume alcohol, memberships, seat charges, or food service.
- Forecast years
- 52026 through 2030
- Revenue categories
- 5product sales streams
- Planned staff
- 3annual-average FTE
- Scenario cases
- 3Low, Base, High
WORKBOOK STRUCTURE
What Is Included in the Cigar Lounge Model
The workbook links operating assumptions to monthly calculations, financial statements, and management analysis instead of requiring separate, disconnected forecasts.
Purchases, Expenses & Staff
COGS & OPEX separates merchandise costs, processing fees, and recurring overhead. Payroll plans the manager and two tobacconist or retail-host positions.
Assets, Funding & Cash
CAPEX covers startup assets and depreciation schedules, while CapTable, Debt, Sources & Uses, and Cash Flow support investment and financing analysis.
Financial Reports & Checks
Income Statement, Balance Sheet, Summary, Scenarios, Returns, Valuation, Charts, and Checks help review results, reconcile schedules, and test assumptions.
REVENUE BUILD
How Cigar Sales Become Monthly Revenue
Monthly paid product demand is allocated once across five categories, then multiplied by each category’s realized unit price.
In the 2026 Base illustration, the lounge sells 1,100 paid items per month. The mix is 45% everyday singles, 30% premium singles, 10% rare singles, 10% take-home boxes, and a residual 5% accessories.
The 2026 prices are $12, $22, $38, $180, and $40 per category, respectively. Box purchases are separate units, not multiples of single-cigar sales; repeat customer purchases are already included in monthly demand.
Revenue Forecast
The Revenue Forecast organizes five merchandise sales streams using paid-unit volume, price, category share, and launch timing. Its inputs feed the monthly Calc schedule and annual sales projections.
The illustrative demand assumption grows from 1,100 to 1,900 paid items per month by 2030, with annual changes to the realized selling prices.
2026 Base-case revenue calculation
1,100 paid items per month × $35.80 weighted average realized price × 12 active months = $472,560 annual revenue.
OPERATING COSTS
How Product Costs and Payroll Affect EBITDA
The forecast separates merchandise-related direct costs, processing fees, recurring fixed expenses, and staff payroll without counting salaries twice.
The illustrative cost assumptions apply 53% of revenue to landed cigars and accessories, 0.6% to lounge and retail consumables, and 3% to merchant processing and disputes. These percentages move with projected sales.
Fixed expenses cover rent, utilities, marketing, insurance, POS and website, cleaning, ventilation and humidor maintenance, professional services, licenses, and security. The 2026 rent input is $4,500 per month, paid across 12 forecast months.
COGS and Operating Expenses
The COGS and Operating Expenses forecast separates sales-linked inventory and consumable costs from transaction fees and recurring overhead. This helps explain how merchandise margins and occupancy expenses shape contribution and EBITDA.
The staffing plan uses one lounge manager at $60,000 annual base pay and two tobacconists or retail hosts at $38,000 each. These fixed base salaries total $136,000 per year in the illustrative operating case.
The recorded scope excludes employer payroll taxes, benefits, and personal taxes. Payroll is a distinct expense line and is not included again in COGS, variable costs, or fixed overhead.
Payroll Forecast by Staff Role
The Payroll Forecast organizes staffing levels and compensation by role, including hiring timing, full-time equivalents, salaries, and available payroll controls. It connects personnel planning with monthly expense calculations and reported profitability.
OPENING INVESTMENT
How Startup Spending and Funding Are Planned
The opening plan distinguishes long-lived assets, one-time setup cash, initial inventory, and a reserve for recurring outflows.
The example allocates $150,000 to startup assets, including a $45,000 leasehold fitout, $50,000 ventilation system, $25,000 humidor equipment, and $20,000 seating and fixtures. Remaining asset categories include POS and security equipment, signage, and lighting.
Capital Expenditure Plan
The Capital Expenditure Plan schedules leasehold improvements, ventilation, humidors, and retail fixtures as asset purchases, with depreciation controls where applicable. These expenditures are distinct from annual operating expenses and EBITDA.
Illustrative initial owner funding is $342,495, comprising $150,000 in assets, $24,000 in separate preopening cash items, $41,288 in opening stock, and a $127,207 three-month operating reserve. These components are rounded for display.
Accounts receivable and payable days are both zero because customers pay immediately and suppliers are paid when ordering. Inventory days are set to 59, linking stock-holding assumptions to the working-capital schedule.
Sources and Uses of Funds
The Sources and Uses of Funds report organizes the planned origin and allocation of money, including equity, financing, operating payments, and investment uses. It helps distinguish owner contributions from sales revenue or earned profit.
FIVE-YEAR PROJECTIONS
What the 2026–2030 Example Forecast Shows
The sample Base-case forecast shows sales growth and a transition from negative to positive EBITDA, not verified historical outcomes.
| Year | Revenue | Operating Expenses | EBITDA |
|---|---|---|---|
| 2026 | $472,560 | $508,829 | -$36,269 |
| 2027 | $616,476 | $592,919 | $23,557 |
| 2028 | $744,708 | $668,198 | $76,510 |
| 2029 | $832,702 | $720,770 | $111,931 |
| 2030 | $900,988 | $762,257 | $138,731 |
Illustrative model outputs, rounded to whole dollars. Small differences can arise from rounding.
Revenue rises as monthly paid-unit demand grows and prices change, while merchandise costs remain a percentage of revenue. Fixed base salaries stay at $136,000 in the example, so higher sales improve operating coverage over time.
The operating case produces an EBITDA loss of $36,269 in 2026, positive EBITDA of $23,557 in 2027, and $138,731 by 2030. EBITDA is before depreciation, interest, income taxes, and financing or investment cash movements.
Projected Income Statement
The Projected Income Statement connects revenue and expense schedules to gross margin, contribution margin, EBITDA, and further accounting lines. The documented example above establishes operating results through EBITDA only, not its net profit figures.
The Cash Flow and Balance Sheet reports provide a separate lens on inventory, investment, funding, and liquidity. These schedules may differ materially from EBITDA because stock purchases, capital expenditure, financing, and cash collection timing affect cash movement.
Cash Flow Forecast
The Cash Flow Forecast organizes operating, investing, and financing cash movements and reconciles opening with closing cash. Use it to test cash requirements around opening inventory, fitout spending, ongoing expenses, and funding choices.
SCENARIOS AND RETURNS
How to Evaluate Break-Even, Payback, and Risk
Returns and scenario reports provide different decision measures; neither EBITDA nor revenue growth alone proves that an investment pays back.
Sales break-even compares projected revenue with the operating level needed to cover relevant costs. Cash break-even concerns cumulative cash flows, investment payback tracks recovery of invested funding, and annual ROIC assesses returns relative to invested capital.
The model includes these calculation and reporting functions, but the supplied illustrative case does not establish a payback date, return percentage, or valuation. Those results must be reviewed from the actual workbook assumptions and outputs.
Break-Even, Payback and ROIC
The Returns analysis brings together break-even measures, project cash flows, investment payback, and return on invested capital. Compare these separate metrics when evaluating the scale and timing of a cigar lounge investment.
The Dashboard offers Low, Base, and High multipliers for revenue, COGS, variable operating costs, fixed expenses, and payroll. Changing the selected scenario lets you compare how sales pressure and cost changes affect margins and EBITDA.
Debt controls support four modeled facilities with repayment choices, while Valuation provides DCF and sensitivity functions. Their available calculations do not mean that outside financing is secured or that any particular valuation is established.
Financial Scenario Analysis
The Financial Scenario Analysis compares Low, Base, and High assumptions through projected revenue, gross margin, contribution margin, and EBITDA. It helps assess how product demand and the cost structure may respond to changing conditions.
FREQUENTLY ASKED QUESTIONS
Cigar Lounge Financial Model FAQs
Answers to common questions about the template’s sales structure, assumptions, operating projections, and funding analysis.
Does the model include tobacco retail and lounge sales?
Yes. It models five paid retail categories: everyday, premium, and rare single cigars; take-home cigar boxes; and accessories. Lounge access is complimentary with purchase.
Can I change sales volume and product prices?
Yes. Edit monthly paid product demand, selling prices, and category shares to update revenue calculations and the related operating projections.
Does the forecast limit sales to lounge seats?
No. The 40 seats and premises size describe the sample operating footprint; paid product demand drives revenue without a seating-capacity clamp.
Are salaries included in product costs?
No. The illustrative manager and host salaries run through Payroll and are separate from COGS, sales-linked variable expenses, and fixed overhead.
Does the workbook include cash flow and balance sheet reports?
Yes. Its declared reports include monthly Cash Flow and Balance Sheet statements, supported by inventory, investment, equity, and debt schedules.
Can I compare different scenarios?
Yes. The Dashboard provides Low, Base, and High assumptions for sales and operating cost categories, with a Scenarios report comparing margins and EBITDA.
Does positive EBITDA mean cash break-even or payback?
No. EBITDA is an operating earnings measure. Cash break-even and investment payback require separate cash-flow and investment-return calculations.
Are the sample projections guaranteed?
No. The 2026–2030 figures are illustrative, estimated planning outputs, not historical facts, verified market averages, or guaranteed future returns.
What Does the Cigar 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
Clearer Cash-Flow Outlook
This cigar lounge model showed me where the cash gaps would hit, so I could map runway and funding needs before opening. It saved me hours of guesswork and made my monthly plan easier to trust.
Fewer Formula Headaches
I stopped worrying about one broken cell throwing off the whole sheet. The built-in structure helped me review the model faster and cut my cleanup time by about 3 hours.
Investor-Ready From The Start
I finally had a model that lined up with what investors wanted to see, so my deck and numbers matched cleanly. That clarity helped me book a meeting without reworking the format.