MPModern Picnic Financial Model
Consumer/DTC Startup Financials (Free Excel Download)
Modern Picnic is a DTC + wholesale brand selling stylish, insulated lunchboxes and accessories targeted at women aged 18–54.
professionals from Deloitte
Used by professionals from






About this model
Modern Picnic sells stylish insulated lunchboxes and accessories designed for women aged 18 to 54. The brand combines fashion and function in a product category often treated as utilitarian, selling directly online and through wholesale, retail, and pop-up channels.
Its wholesale partners include Saks, Dillard's, and GILT, while DTC is the primary channel. The company was raising a $2 million seed round after closing $900,000 of pre-seed funding, with 49% of the raise allocated to freight and inventory.
The model builds revenue by DTC, wholesale, and retail channels from traffic, conversion, AOV, doors, and units. COGS, freight, inventory purchases, returns, CAC, gifting, and accessory attachment determine contribution margin, cash conversion, and the effect of channel mix.
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 Modern Picnic
modernpicnic.com
How to build a detailed financial model for Modern Picnic
A complete walkthrough of the business, drivers, and assumptions behind the downloadable Modern Picnic model - distilled from its pitch deck and publicly available information.
Product & value proposition
- Hero product: "The Luncher" - insulated lunchbox with vegan leather exterior, magnetic closure, utensil compartment.
- Full product line (with prices):
- Tote: $250
- Large Luncher: $189
- Backpack: $210
- Luncher: $159
- Mini Luncher: $129
- Pouch: $79
- Snacker: $59
- Pet Collection: $100
- Scarf: $45
- Positioning: "Female, cosmopolitan YETI" - styling + sustainability angle (vegan leather, reusable). Competes on aesthetics where incumbents compete on utility.
- Three growth pillars going forward: Product expansion, Licensing, Distribution.
Market
- Addressable audience framed as: 75M Women Age 18–54.
- $170B buying power cited.
- 85% consumer spend influence.
- YETI (comparable benchmark) valued at $9B.
- No formal TAM/SAM/SOM breakdown in deck. No lunchbox market size figure given.
Revenue model
- Channel 1 - DTC eCommerce: direct sales via own website. Primary channel (May 2018 launch). AOV $138.
- Channel 2 - Wholesale: current partners Saks Fifth Avenue, GILT, Dillard's; in discussion with Shopbop, Nordstrom, Bloomingdale's, Goop.
- Channel 3 - Retail: pop-ups and events (Soho NYC, Hudson Yards NYC); community foothold strategy.
- Revenue mix shown in projections as four segments: Existing Products D2C, New Product D2C, Wholesale, Retail.
- Price points: $45–$250 across SKUs. Weighted average will be below $159 (Luncher) given mix toward lower-price accessories.
- No gross margin figure disclosed in deck. No COGS or fulfillment cost data shown.
Traction & metrics
- Launch date: May 1, 2018.
- Revenue data from May 2018 to December 2021.
- YoY gross revenue growth rates: 2020 +71%, 2021 +200%, 2022 proj +177%, 2023 proj +140%, 2024 proj +100%.
- Target: grow 2020 revenue 40x by 2024.
- Absolute revenue figures are redacted in the chart (blank boxes on all bars).
- AOV: $138.
- Returning customer rate: 22%.
- Average LTV per customer: redacted.
- Average CAC: redacted.
- Average LTV:CAC ratio: redacted.
- Total unique customers to date: redacted (blank box in image).
- Age distribution of customers: 25–34 = 38%, 35–44 = 18%, 18–24 = 17%, 45–54 = 14%, 55–64 = 9%, 65+ = 4%.
- Brand ambassador program (launched 2019): 700+ ambassadors, 800+ social media posts, 20M+ impressions, 35 states, $0 acquisition cost, generates 20% of yearly revenue.
- New 2021 channels: SMS (9% of Q4 revenue), Affiliate (10% of Q4 revenue), SEO (11% of Q4 revenue), TikTok Ads (+3M likes, +125K followers).
- Press: hundreds of features (Vogue, NYT, Forbes, Cosmopolitan, Elle, etc.).
- Pre-seed financing: $900K raised across 2018–2021. Breakdown: $100K (2018/2019 implied), $350K, $550K.
Unit economics
- AOV: $138.
- Returning customer rate: 22%.
- LTV per customer: redacted in deck image.
- CAC: redacted in deck image.
- LTV:CAC ratio: redacted in deck image.
- Ambassador channel CAC: $0 (stated); contributes 20% of yearly revenue.
- No gross margin, COGS, or contribution margin figure disclosed.
Competition / moat
- Explicit competitive frame: YETI ($9B valuation) as the functional market leader; Modern Picnic as the women's lifestyle version.
- Problem framed as: "The lunchbox industry is underserved for the modern woman".
- Claim: "First to market stylish, insulated lunchbox for women".
- Moat levers: brand identity, community ambassador network (700+ ambassadors across 35 states, $0 CAC), extensive press coverage, strategic brand partnerships (American Express, Kendra Scott, L'Occitane, Martha Stewart, PETA, S'well, etc.).
- No direct competitor grid or pricing matrix shown.
Team & funding ask / use of funds
- Founder/CEO: Ali Kaminetsky - Lehigh University (Supply Chain + Marketing), ex-Macy's Merchant Buying/Planning EDP; founded Modern Picnic at age 22, launched May 2018.
- CFO: Patrick McCarthy.
- Operations Manager: Amber Carlson.
- Inventory Planner: Caitlin Fox.
- Social Media Associate: Caeley Perrine.
- Advisors: Alexandra Wilson (Co-Founder, Gilt + GLAMSQUAD), Michelle Grant (Founder/CEO, LIVELY), Adam Shoenberg (CEO, Hook & Albert), NJ Falk (Managing Partner, APL), Monica Royer (Founder, Monica + Andy).
- Ask: $2M Seed round.
- Use of funds:
- Freight / Inventory: 49% ($980K)
- Marketing / Paid Ads: 28% ($560K)
- Employees / G&A: 17% ($340K)
- Operating Expenses: 6% ($120K)
Recommended financial model
- Archetype + why: DTC consumer goods P&L with multi-channel revenue build. Revenue is product-driven, not subscription or usage-based. Three distinct channels (DTC, wholesale, retail) with different margin profiles. This is a classic DTC-to-omnichannel brand model: revenue = units × ASP by channel, with gross margin and operating expense waterfall to EBITDA. A 3-statement model anchored on inventory purchasing cycles is appropriate given that 49% of raise goes to freight/inventory.
- Forecast horizon & granularity: 2022–2026 annual (5 years), matching the company's own 2024 target horizon and giving 2 years of post-target visibility. Monthly granularity for Year 1 (2022) to capture seasonality and cash/inventory timing; annual for Years 2–5.
- Key drivers & assumptions:
*Revenue:*
- 2021 gross revenue base: growth rates imply a base exists but the absolute figure is redacted - must be sourced from company or back-calculated.
- YoY growth rates (per deck projections): 2022 +177%, 2023 +140%, 2024 +100%; 2025–2026 step-down to ~50% and ~30% respectively as growth matures.
- Revenue channel mix (2022 onward): Existing D2C, New Product D2C, Wholesale, Retail - per deck stacked bar. Exact $ splits not disclosed; D2C starts at ~80% of revenue, declining to ~55% by 2026 as wholesale and retail scale.
- AOV: $138; grows ~3–5% annually with mix shift toward higher-price products (Tote, Backpack, Large Luncher).
- Orders = Revenue / AOV.
*Gross margin:*
*CAC & customer acquisition:*
- Paid CAC: redacted in deck. typical DTC apparel/accessories CAC of $30–$60 for paid channels.
- Ambassador/organic CAC: $0; contributes 20% of yearly revenue, so blended CAC is materially lower.
- Returning customer rate: 22%; stable to slightly improving with ambassador community and new SMS/email channels.
*Marketing spend:*
- 28% of $2M raise allocated to paid ads ($560K); marketing as % of revenue declines from ~25–30% in early years to ~15% as organic/ambassador channels scale.
*Inventory & COGS:*
- 49% of raise ($980K) for freight/inventory; model must include inventory build lag (purchase → receipt → sale cycle, likely 60–120 days for overseas manufacturing).
- inventory turns of 3–5× per year for accessories-style DTC brand.
*Headcount / OpEx:*
- 17% of raise ($340K) for employees/G&A; 6% ($120K) operating expenses.
- Current team: 5 FTEs; headcount scales with revenue milestones.
- Scenarios (Base / Bull / Bear - which variables flex):
- Base: Revenue growth tracks deck projections (177% / 140% / 100%) through 2024; gross margin 58%; blended CAC holds.
- Bull: Wholesale partners (Nordstrom, Bloomingdale's) convert, adding 15–20% revenue uplift; licensing revenue materializes in 2023–2024.
- Bear: DTC growth slows post-fundraise (actual 2022 growth 80–100% vs 177% projected); wholesale stays at current 3 partners; retail pop-ups don't convert to permanent.
- Required sheets / outputs:
- Assumptions & drivers (all inputs in one place)
- Revenue build by channel (DTC existing products, DTC new products, wholesale, retail)
- P&L (Gross revenue → COGS → Gross profit → Marketing → G&A → EBITDA)
- Customer cohort / unit economics (orders, AOV, new vs. returning customers, blended CAC, LTV)
- Inventory & working capital schedule (purchase cycles, inventory on hand, days inventory outstanding)
- Cash flow / runway (given inventory-heavy model and $2M raise, cash burn and runway is critical)
- Scenario toggle (Base / Bull / Bear)
- Dashboard (revenue bridge, gross margin, customer count, cash runway)
Frequently asked
Is the Modern Picnic financial model free?+
Yes. The Modern Picnic 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 Modern Picnic'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.

