Trusted by 25,000+ startup founders, investors and CPAs
Formula Errors Caught Fast
Megan Ross, NY
I was nervous one broken formula would throw off the whole model, but this template kept everything clean and easy to trace. It saved me a full day of checking cells before I shared it with my advisor.
Easy Enough To Use
Daniel Kim, CA
I’m not strong in Excel, so the clear layout and pre-built tabs were a relief. I finished the first draft in under two hours without needing help from a modeler.
Investor Questions Answered
Priya Shah, IL
I didn’t know what investors would expect, but the model already had the right structure and outputs. It helped me walk into a meeting with clearer assumptions and book a follow-up call.
Model review
What is the financial model of a CBD store?
The CBD store's Financial model is an editable Excel and Google Sheets workbook predicting five years of monthly and annual financial statements, scenarios and management reports.
Plan how store movement, buyer conversion, repeat purchases, basket size, product mix, prices, costs, employment and investment needs can shape your CBD retail forecast.
The editable operational assumptions are provided by monthly calculation engine, which composes the results for annual reviews, financial statements, scenario analyses and management reports.
Built for retail planningUse your own operational assumptions to check the economy of a visitor-run CBD store before you make any predictions.
revenue equipment from visitors to a CBD store to a basket
How does the CBD store calculate revenue?
Revenue starts with shoppers turning into buyers and then adds active orders from visiting customers before allocating units according to product mix and category price.
01
Change visitors
Weekly visitors adjusted to monthly seasonality and conversions create new buyers each month.
02
Build repeating cohorts
Some new buyers become repeat customers for a certain lifetime.
03
Calculating orders
Monthly orders shall link first orders with active customers repeating the order frequency times.
04
allocation of units
Orders times unit per order form units sold and then the mix of sales allocates categories.
05
Calculation of revenue
Allocated category units times category prices are summed up to total retail revenue.
Basic formulaRevenue = units sold × weighted category price
01 / Revenue
Which revenue drives the forecast?
Worksheet revenue combines visitor traffic, buyer conversion, repeat customer behaviour, basket size, product mix and category prices with forecast retail.
Revenue
The revenue Worksheet displays visitor, customer, order, product mix and price categories data.
02 / COGS & OPEX
How are product costs and operating costs determined?
Worksheet COGS & OPEX separates product costs, variable costs and fixed overhead costs so that the operational assumptions are consistently included in the forecast.
COGS & OPEX
Worksheet COGS & OPEX is divided into direct costs, Variable Costs and General Fixed Costs.
03 / Scenarios
What can be compared in different scenarios?
The scenario compares the low, basic and high levels for revenue, gross margin, contribution margin and EBITDA over the forecast period of five years.
Scenarios
The scenarios display charts of Low, Base and High cases for basic financial results.
04 / Dashboard
What does the chart sum up?
Dashboard allows you to control scenarios, basic financial results, a mix of revenue, profitability, cash flow and return on investment in a single management view.
Dashboard
Dashboard combines model setting, scenario control, financial tables and management charts.
Product adjustment
Is the financial model of a CBD store right for you?
The template is suitable for a visitor-based retail economy; structural works on order are more appropriate where revenue logic, timetables or reporting requirements differ significantly.
Model ready
It fits perfectly
Selling starts with shoppers turning into buyers.
Recurring purchases can be modelled through cohort of customers with a specific lifespan.
Orders become units and then units are allocated according to product mix and category price.
You need an edited five-year monthly and annual report comparing the scenarios.
Order structure
Think about the model
Revenue depend on essentially different channels or contract-based billing logic.
Customer retention requires behaviours beyond the lifetime of the cohort and the frequency of repeat ordering.
Operations shall require individual capacity, inventories or timetables of the unit economy outside retail flow.
Reporting requires a different structure than the financial and management visions in the workbook.
The indicator is the starting point for planning, not a guarantee of performance.
Financial modelling service for orders
Do you need a pattern that meets your requirements?
Financial Models Lab can build or customize the model when you need a different revenue logic, operational schedule or reporting based on your requirements.
After purchase, you will receive a fully editable financial model of Excel with Google Sheets compatibility, five-year monthly and annual forecasts, scenarios and financial reports.
01
Book to be edited
Use the pre-built financial model with your own CBD Store assumptions.
02
Forecast five years old
Review of the monthly and annual forecasts for the five-year planning horizon.
03
Analysis of scenarios
Compare the Low, Base and High cases using a scenario control in the workbook.
04
Financial statements
Analyze the income statement, the cash flow, the balance sheet, the balance sheet and the supplementary reports.
Before purchase
CBD Facility Financial model FAQ
The basic answers are visible in their entirety, without the need to click on the accordion.
01
How does financial model calculate the CBD store revenue?
The model converts shoppers into new buyers, adds orders from active repeat customers, converts orders into units, allocates a product mix and applies category prices.
02
Which assumptions can I change?
You can edit the launch date, weekly visitors, conversion, repeat order frequency, unit per order, product mix, category prices and monthly seasonality.
03
How do you compare Low, Base and High?
The scenario compares the low, basic and high results for revenue, gross margin, contribution margin and EBITDA of the five-year forecast.
04
What financial results are taken into account?
The financial results include income statement, cash flow, balance sheet, settlement table, summary, scenarios, assessment, equivalence, ROIC, charts, KPIs, indicators, DuPont and income rankings and expenditure.
05
Can the Financial Models Lab adapt the model to individual requirements?
Yes. the Financial Models Lab can build or adapt the revenue logic, operational schedules and reporting based on agreed requirements.
06
Is forecast in the book a guarantee?
No. The workbook is forecast planning based on edited assumptions, not a guarantee of performance.
What Does the CBD Store Financial Model Contain?
This Excel template for a CBD retail financial plan includes everything you need to build a complete, data-driven forecast for your business.
All-in-one Dashboard
Core inputs and core outputs
Low/Base/High
Three scenario analysis
Professional Charts
Presentation ready
ROE Components
DuPont analysis
Revenue Inputs
Researched revenue assumptions
Bank-Ready Reports
Lender-friendly financial outputs
Revenue Breakdown
Revenue stream detailed view
KPI Dashboard
Performance metrics benchmark
Choosing a selection results in a full page refresh.
Revenue
COGS & OPEX
Scenarios
Dashboard
