Cannabis Dispensary Chain Model
Consumer Financial Model (Free Excel Download)
Model dispensary sales through traffic, basket size, product mix, pricing, gross margin, compliance costs, inventory, and store growth to forecast cash flow.
professionals from Deloitte
Used by professionals from
About this model
This model helps you assess a cannabis dispensary selling flower, concentrates, edibles, and other regulated products. It connects customer visits, basket size, product mix, and inventory needs to the people, security, rent, and compliance costs of running the store.
Use it to evaluate a new location, licence opportunity, or operating plan. The model makes it easier to test demand, pricing, margins, and funding needs before committing capital.
What every model includes
Live formulas, no hardcoded values
Outputs are driven by live formulas, so the workbook updates from its assumptions instead of relying on hardcoded results.
All assumptions in one tab
Inputs are clearly marked in the Assumptions tab and separated from calculations, making it clear what to change and what to leave intact.
Statements always balancing
For integrated-statement models, the balance sheet, cash flow, and supporting schedules tie through properly.
Distinct schedules for clarity
Debt, working capital, taxes, and cash flow can get messy quickly. We group calculations in clear schedules, not across disconnected tabs.
No hidden macros or external links
There are no unexplained external workbook links or macros to undermine auditability or portability.
Changes flow through the model
Update a key driver and see the impact carry through the forecast, financing, and return outputs. We never use hardcoded numbers in formulas.
What's inside the Cannabis Dispensary Chain Model
- Store inputs: Year-1 stores, new stores per year, transactions per store, managers and budtenders per store, average basket
- Utilisation: Year-1 utilisation with an annual ramp and a practical ceiling
- Product mix: flower, pre-roll, vape & concentrate, edible and accessory shares and per-category gross margins
- Ancillary: delivery & online fee per transaction, price escalation
- Cost structure: budtender and manager FTEs and wage with benefits and wage growth; occupancy, marketing, security & compliance, utilities and SG&A as % of gross profit; depreciation (% of revenue)
- Tax: federal 280E rate on gross profit and state income tax rate on EBIT
- Capital and working capital: maintenance capex %, store build-out cost per store, NWC % of revenue growth, base-year revenue
- Valuation: WACC, terminal growth, net debt, shares outstanding
Cannabis Dispensary Chain Model: 7-Year Operating and DCF Template
This cannabis dispensary financial model template evaluates a multi-location retail chain over seven years. It links store openings, transaction volume, product mix, costs, and 280E tax treatment to produce EBITDA, net income, and a DCF valuation.
The underlying model is a values-only preview, but it shows the full calculation flow for assessing a dispensary operating plan. Rates and financial results described here reflect illustrative model settings, not industry benchmarks.
How the model builds store operations and transaction volume
The model starts with a store roll-forward: opening stores plus new stores equals closing stores each year. Closing stores drive manager and budtender headcount, and new stores drive build-out capex.
- Each store supports a mature number of transactions, set by trade area, license conditions, and checkout throughput. A utilization factor, starting at a Year 1 input and ramping to a practical ceiling, captures how quickly a newly licensed store builds its regular customers.
- Multiplying closing stores by effective transactions per store gives total transactions, the single most important volume driver.
Revenue engine: basket size, product mix, and delivery fees
Revenue is built from total transactions and the average basket. The basket is split across flower, pre-rolls, vapes and concentrates, edibles and beverages, and accessories and CBD.
- Each category's share of the basket is escalated at a shelf-price step-up, and because shares sum to one, product revenue simplifies to transactions times basket size. The mix governs the blend of margins rather than the basket's size, with edibles carrying the richest margin and vapes the thinnest.
- Transaction-driven delivery and online fees layer on top to give total revenue.
Cost structure, EBITDA, and the 280E tax wrinkle
Cost of goods sold is calculated per category as revenue times one minus that category's gross margin. Manager and budtender labor are headcount-driven, loaded for benefits and escalated at the wage-growth rate.
- Other overheads—occupancy and rent, marketing, security and compliance, utilities, and corporate SG&A—are set as a percentage of gross profit, reflecting the true operating scale. EBITDA is then reduced by depreciation to EBIT.
- The defining feature is IRC Section 280E: federal tax is charged on gross profit, not EBIT, while state income tax is charged on EBIT. The effective tax rate can reach around 60–62% of EBIT, well above a normal corporate burden.
Free cash flow, DCF valuation, and practical use
Unlevered free cash flow starts with EBIT, applies the total tax from the P&L to get NOPAT, adds back depreciation, and subtracts maintenance capex, store build-out capex, and the change in working capital. These cash flows are discounted at a WACC that includes a regulatory-risk premium.
- A Gordon-growth terminal value is added, and net debt is subtracted to reach equity value and value per share. Practically, the model lets an analyst flex new store openings, utilization ramp, product mix, cost percentages, and tax rates to see the combined effect on net income and enterprise value.
- It is suited for evaluating a new location, a licence opportunity, or an operating plan before committing capital.
Formatted to IB standards
Named theme colors repaint the whole workbook in one click, on top of an investment-banking structure with clear input, output, and cross-sheet reference styling - brand-ready, institutional-grade, and fully auditable.
Created by ex-finance professionals
Hey, I’m Alex and I created Finamodel.
Over my years in the finance industry I kept building the same models over and over again. Same structure, same assumptions, different logo. So I started building frameworks to turn them into clean, reusable templates.
Every model here is one I’d actually use for a client, and I personally vet each one before it goes up.
I’m not an expert in every industry, but I’ve built enough models to know what belongs in one. And when something is completely foreign to me, I reach out to my network for experts to work on our models with us.
Having a template library on hand cuts a first build from hours to minutes.
Need help finding your model? You’ll find me in the Finamodel app!
Frequently asked
What is a cannabis dispensary financial model?+
A cannabis dispensary financial model captures the seven-year operating economics and intrinsic value of a multi-location retail cannabis chain that sells flower, pre-rolls, vapes and concentrates, edibles and beverages, and accessories and CBD, plus a delivery and online service fee. It rolls a store count forward, converts a capacity-utilisation ramp into total transactions, splits an average basket across five product categories each at its own gross margin, charges the labour- and security-heavy cost stack to EBITDA, applies the IRC Section 280E tax treatment, and discounts an unlevered free-cash-flow stream to enterprise value, equity value, and value per share.
What is IRC Section 280E and why does it dominate the model?+
Section 280E of the U.S. tax code denies any federal income-tax deduction for a business that traffics in a Schedule I substance, except for cost of goods sold. For a plant-touching cannabis retailer that means operating expenses, labour, rent, marketing, security and depreciation are not deductible federally, so federal tax is charged on gross profit rather than on EBIT. The model computes federal tax on gross profit and state income tax on EBIT, producing an effective tax rate near sixty percent of EBIT, roughly triple a normal corporate rate, which is the single most important thing to understand about dispensary economics.
How is dispensary revenue built?+
Revenue is driven by the store estate and its utilisation: total transactions equal closing stores times transactions per store times a utilisation factor that ramps to a ceiling, and product revenue is total transactions times an average basket split across a five-category mix that sums to one, each escalated at a shelf-price step-up. Transaction-driven delivery and online fees layer on to total revenue.
Why does the model show such a low EV/EBITDA multiple?+
The implied EV/EBITDA sits in a deliberately low single-digit range because the 280E tax drag takes roughly sixty percent of EBIT and the discount rate carries a regulatory-risk premium for federal illegality, banking constraints and license fragility. That is the honest economic story of cannabis retail, and the model surfaces it rather than papering over it with a headline multiple.
Have more financial modelling questions? Contact us
Related templates
Retail Store Model
Plan and value a retail-store chain using new stores, customer traffic, sales, inventory, and operating costs.
Coffee Shop Chain Model
Plan and value a specialty coffee chain using store foot traffic, average ticket size, beverage gross margins, and a DCF.
Grocery Store Chain Model
Plan and value a supermarket chain using department sales per square foot, inventory shrinkage, gross margins, and a DCF.
E-Commerce Unit Economics
P&L model for e-commerce business with CAC, LTV, gross margin, and unit economics.
