Product description

The Vertically Integrated Cannabis Financial Model is designed specifically for a vertically integrated business that manages all stages of the supply chain – from plant propagation through to final product sales. It provides a comprehensive framework to project startup costs, ongoing operating expenses, and profitability across the following core operations:
✅ Cultivation (with or without Nursery) – indoor/greenhouse/outdoor flowering & harvest
✅ Processing/Manufacturing – trimming, drying, extraction, infusion, packaging
✅ Wholesale & Retail – B2B distribution and DTC sales of proprietary and third-party products, plus services
✅ Ancillary services – e.g., event organizing, consumption lounge

Using a mix of industry-informed assumptions, the model calculates revenue and cost line items on a monthly basis over a flexible seven-year period. These monthly results are automatically aggregated into quarterly and annual summaries, enabling clear visibility across different time horizons. The model generates a full suite of financial statements, consisting of cash flow, income statement, and balance sheet, which allows you to build a complete financial model. In addition, the model includes integrated financial analysis across key categories such as profitability, liquidity, leverage, efficiency, and return on equity, including DuPont analysis for deeper insight into performance drivers. For all inputs, you can easily set the start date and year for key decisions and the model adjusts automatically.

1. A dedicated cannabis cultivation module designed for scalability and adaptability across diverse climates and regulatory environments, structured around four core production options: nursery (for in-house clone development to support internal cultivation operations), indoor (for controlled-environment growth), greenhouse (for propagation or full-cycle cultivation), and outdoor (for full-term or finishing cultivation) – allowing operators to use a single method or run integrated multi-environment operations.
2. Three distinct blocks: one for cultivation and one for manufacturing (including processing and extraction), producing finished goods such as dried flower, pre-rolls, cannabis concentrates and cannabis infused products, with room to add other offerings as needed; and one for retail, including third-party product purchasing and/or services direct costs, delivery options, and all related distribution costs.
3. Three integrated revenue streams: wholesale sales of your own branded products, retail sales of your own branded products, and retail sales of select third-party products through company-owned stores and/or service-based income (e.g., event organizing, consumption lounge). Use predefined settings (e.g., product type, potency, price) or fully customize assumptions to reflect your specific business model.
4. Full forecasting of all cost categories – direct, initial, selling, administrative, and operational – with a streamlined capitalization table that automatically incorporates financing rounds into the financials.
5. A simple hiring planner where you enter a role, salary, and start date, and the model automatically calculates your staffing timeline and payroll projections – flexible enough for startups or larger operations.
6. A cash-flow-first approach that continuously tracks cash burn and cash on hand based on your revenue and expense forecasts.
7. Financial statements (income statement and balance sheet) focused on clarity and relevance, turning detailed inputs into clean, print-ready summaries with key ratios and performance metrics.
8. A “Data for BP” worksheet to help populate a Vertically Integrated Cannabis Business Plan Template using real-time outputs from the model.
9. Email customer support to assist with questions or guidance on using the model effectively.

Vertically Integrated Cannabis Financial Model Sample (Alabama)

The Cannabis Vertically Integrated Financial Model is a fully-functioning Excel financial model for a cannabis business to:

• Get Fast & Free Updates – You’ll receive instant access upon purchase. If we’re in the process of rolling out an update, your download will be available within 12 hours. Once purchased, you’ll always have access to the latest version – free updates included for life.




• Input Your Key Assumptions – This financial model generates initial projections using only a few core inputs: square footage (meterage) per facility type, product types, unit pricing, wholesale/retail sales split, and manufacturing product mix (by %). These suffice for a high-level estimate. For greater accuracy, refine key operational parameters – e.g., propagation method (seeds vs. clones), annual harvests, plant density (plants/sq. ft or sq. m), yield (lbs/sq. ft or kg /sq. m), direct costs (cultivation, manufacturing, distribution), third-party product assortments, service offerings, and delivery options. The model instantly generates comprehensive financial projections.




• Refine Your Forecast – After setting the base inputs, you can fine-tune the model by adjusting other assumptions – such as licensing and other initial setup fees, operational expenses (OpEx) and capital expenditures (CapEx). OpEx and CapEx values are pre-populated based on industry-standard costs per sq. ft (sq. m), but can be reviewed, adjusted, or customized as needed. All formulas are transparent and fully editable, so you can adapt calculations to your specific operations or add new categories, revenue streams, or cost structures. Designed for both beginners and advanced users, the model is easy to use without financial modeling experience – yet powerful enough to customize with Excel expertise.




• Create a Detailed Revenue Model – Forecast income based on production schedule and pricing, enabling accurate, scenario-driven revenue projections.




• Create Funding Estimates – Determine how much capital you need to launch or scale your business. The model calculates startup costs, working capital needs, and cash flow gaps, helping you plan for loans, investors, or self-funding.




• Create Detailed Expense Forecasts – Automatically project costs split into Cost of Goods Sold (COGS) – like material and manufacturing costs, testing, packaging, transport, storage, and direct labor – and Selling, General & Administrative (SG&A) expenses, including legal setup fees, facility rental and maintenance, insurance, professional fees, depreciation, marketing expenses, and indirect staff costs.




• Generate Cash Flow and Income Statements – The model produces a full 7-year monthly and annual cash flow statement, income statement (P&L), and key financial summaries – all dynamically updated as you change your assumptions.




• Understand your Forecasts – The model automatically creates summaries and graphs of key financial and operational metrics to understand what they say about your business, and use them for pitch and presentation materials.




• Complete Your Business Plan Effortlessly – A dedicated “Data for BP” worksheet compiles all key financial and operational data into a clean, easy-to-copy format, helping you quickly fill in the financial sections of your business plan or investor proposal.

This model for a hemp/CBD business is available at hempcbdbusinessplans.com.