Pistil Data Financial Model
Consumer/DTC Startup Financials (Free Excel Download)
Cannabis market-intelligence SaaS platform that ingests public dispensary/eCommerce data and delivers sales-rep-level prospecting and competitive intelligence to cannabis brands.
professionals from Deloitte
Used by professionals from
About this model
Pistil Data is a cannabis market-intelligence SaaS platform that ingests public dispensary and e-commerce data. It gives cannabis brands sales-rep-level prospecting and competitive intelligence, turning fragmented market signals into actions for commercial teams.
The company sells subscription software to cannabis brands, with retailers planned as a future customer group. California and Colorado were live in July 2021, and the roadmap targeted 15 US states by the fourth quarter of 2022, making geographic coverage a primary growth driver.
The model builds ARR from new logos, seats, and data modules, then adds expansion and churn. State launches, data acquisition, compliance, sales cycles, gross margin, R&D, and customer retention determine the capital requirements of scaling the vertical data platform.
A turnkey financial model
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.
About Pistil Data
pistildata.com
How to build a detailed financial model for Pistil Data
A complete walkthrough of the business, drivers, and assumptions behind the downloadable Pistil Data model - distilled from its pitch deck and publicly available information.
Product & value proposition
- Product "Pistil for Brands" launched February 2021 in California; Colorado added June 2021
- Mobile-first app with four modules: Prospect, Upsell, Intel, Leaderboard
- Core use case: territory sales reps identify new dispensary accounts (prospects), win-back lapsed accounts, and upsell existing accounts - without needing a laptop in the field
- Data engine: 1B+ data points/day ingested from public eCommerce menus and public APIs; two years of IP built by a team of 15 engineers and data scientists
- Pipeline planned: "Pistil for Retailers" (named on slide 6 as a future segment); platform designed to serve retailers, distributors, MSOs, investors, ancillaries, and brands
- Positioning analogy: Bloomberg for Finance → Google for Internet → Salesforce for CRM → Oracle for Enterprise → Pistil for Cannabis
Revenue model
- SaaS subscription sold to cannabis brands; billing cadence not stated
- Unit of sale: appears to be per-brand (enterprise/team subscription), with the territory sales rep as the end-user
- Specific pricing tiers, seat counts, or ACV not disclosed in the deck
- Future products for retailers planned but not yet launched as of July 2021
Traction & metrics
- ~32 named customer logos displayed on "Broad Industry Adoption" slide; customers span brands, distributors, and ancillaries. Notable names include Plus Products, Kanha, Connected, HERBL, Flow Kana, Claybourne Co., Glass House Farms, Cannacraft, Lowell Herb Co.
- No ARR, MRR, revenue growth, churn, or NRR figures disclosed
- Qualitative customer ROI quotes only: e.g., "I won 14 new accounts using Pistil last quarter" (Anthony Bendana, Plus Products)
Competition / moat
- Identified competitive gap: legacy data solutions and "sub-par market intelligence" in cannabis
- Moat claims: two years of proprietary IP; ML applied to cannabis-specific data challenges; 1B+ data points/day at ingestion scale
- No named competitors listed; competitive framing is against the status quo (sales reps manually browsing Weedmaps 10–15 hrs/week)
Team & funding ask / use of funds
- Jeffrey Graham, PhD - CEO
- Taylor Jones - VP, Revenue & Customer Success
- Team described as technologists with deep cannabis market knowledge; 15 engineers and data scientists referenced
- Round: Series Seed; raise amount not disclosed
- Use of funds: 18-month runway; national rollout, new product features, new products for brands and retailers
- Geographic expansion goal: 15 states by Q4 2022: WA, OR, CA, NV, AZ, AK, CO, OK, IL, MI, PA, FL, ME, MA (14 states visible on map - likely 15th unlabeled or MA counts separately)
Recommended financial model
- Archetype + why: B2B vertical SaaS ARR model. Revenue is subscription-based, sold to cannabis brands on a per-account basis. The key operating metric is ARR built through new logo adds and state-by-state geographic expansion. Classic SaaS P&L with R&D, S&M, and G&A.
- Forecast horizon & granularity: Monthly for 18 months (matching stated runway use-of-funds period), then annual to Year 3. State-by-state rollout logic driving cohort adds.
- Key drivers & assumptions:
| Driver | Value | Source |
|---|---|---|
| States live at model start | 2 (CA, CO) | - |
| Target states by Q4 2022 | 15 | - |
| Approx. current customers at raise | ~32 logos | - |
| Months of runway funded | 18 | - |
| ACV per brand customer | $10k–$30k/yr; B2B vertical SaaS at seed stage with field-sales buyer; no deck data | |
| Avg. addressable brands per state | 50–200 active licensed brands; varies by market maturity | |
| New logo adds per state per month (post-launch) | 3–8; ramp over 3–6 months per state | |
| Gross churn (annual) | 15–25%; early-stage SaaS, nascent market | |
| Gross margin | 65–75%; data infra costs will be meaningful given 1B+ data points/day ingestion | |
| Headcount at raise | ~17 (15 eng/data + 2 named execs); likely 20–25 total with sales | |
| S&M as % of revenue | 40–60%; high for land-and-expand in early geographic rollout | |
| R&D as % of revenue | 35–50%; core IP-building phase |
- Scenarios (Base / Bull / Bear - which variables flex):
- Base: Reach 15 states by Q4 2022; 3–5 new logos/state/month; ACV $15k
- Bull: Faster state ramp (all 15 by Q2 2022); 6–8 logos/state/month; retailer product launches mid-2022 adding second revenue line
- Bear: Only 8–10 states by Q4 2022; 2–3 logos/state/month; ACV pressure to $10k; cannabis regulatory slowdowns in key states
- Required sheets / outputs:
- Assumptions - all drivers in one place; state launch calendar
- Revenue build - state × month cohort model: new logos, churned logos, active logos × ACV
- P&L - Revenue, COGS (data infra), Gross Profit, S&M, R&D, G&A, EBITDA
- Headcount plan - by function (Eng, Data, Sales, CS, G&A); drives S&M and R&D
- Cash flow - Operating cash + Seed raise proceeds; runway bridge to next round
- KPI dashboard - ARR, logo count, states live, net new ARR, burn rate, runway months
- Scenario toggle - Base / Bull / Bear
Frequently asked
Is the Pistil Data financial model free?+
Yes. The Pistil Data model is a free Excel (.xlsx) download with live formulas. Sign up with your email and the workbook is yours to keep, review, and edit.
What's included in the model?+
A 5-year monthly forecast with P&L, cash flow and runway, valuation (exit multiple plus a DCF cross-check), MOIC/IRR returns, and unit economics, with live formulas throughout.
How was this model built?+
It was built from Pistil Data's pitch deck and publicly available information, then structured to investment-banking standards as a fully editable Excel model.
Can I change the assumptions?+
Yes. You can change assumptions and the live formulas will recalculate in the downloadable Excel model.
Have more financial modelling questions? Contact us
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!
Other Consumer/DTC Startup Financial Models
Browse another startup in the same category.
Accel Club
Accel Club acquires Amazon third-party (FBA) seller businesses at 3–4x EV/EBITDA and scales them through operational integration, then exits at higher consumer/D2C multiples.
Afrocenchix
D2C brand selling natural, vegan-certified hair-care products for afro and curly hair.
Amperity
Enterprise Customer Data Platform (CDP) that unifies first-, second-, and third-party customer data across siloed systems to power personalization, analytics, and marketing activation.
AnyRoad
Enterprise SaaS platform for managing, measuring, and optimising branded experiential marketing.
Attentive
B2B SMS / mobile marketing SaaS for e-commerce and retail brands.
Aura
All-in-one consumer "intelligent safety" subscription replacing fragmented point solutions for identity, device, WiFi, social, assets, and privacy protection.
Belgian Boys
Belgian-inspired premium specialty food brand selling cookies, refrigerated cheesecakes, frozen waffles/crepes, and snacks through US retail and DTC channels.
Bespoken Spirits
Technology company that replaces barrel aging with a proprietary ACTivation process to produce premium, customizable spirits in days rather than decades.
