MP
Modern 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.

Loading...

Used by professionals from

KPMG logoWharton logoColumbia logoESSEC logoPwC logoHEC logo

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
Read the pitch deck
Modern Picnic pitch deck cover
View on makeslides.com
Total raised
$900.0K
Funding round
Pre-Seed
Founded
2022
Category
Consumer/DTC
Customer
B2C
Geography
US

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:
  1. Assumptions & drivers (all inputs in one place)
  2. Revenue build by channel (DTC existing products, DTC new products, wholesale, retail)
  3. P&L (Gross revenue → COGS → Gross profit → Marketing → G&A → EBITDA)
  4. Customer cohort / unit economics (orders, AOV, new vs. returning customers, blended CAC, LTV)
  5. Inventory & working capital schedule (purchase cycles, inventory on hand, days inventory outstanding)
  6. Cash flow / runway (given inventory-heavy model and $2M raise, cash burn and runway is critical)
  7. Scenario toggle (Base / Bull / Bear)
  8. 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

Alex Tapio, ex-Deloitte financial modelling expert

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.xlsx
Metric
2026
2027
Revenue
--
--
EBITDA
--
--
AC

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.xlsx
Metric
2026
2027
Revenue
--
--
EBITDA
--
--
AF

Afrocenchix

D2C brand selling natural, vegan-certified hair-care products for afro and curly hair.

amperity.xlsx
Metric
2026
2027
Revenue
--
--
EBITDA
--
--
Amperity logo

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.xlsx
Metric
2026
2027
Revenue
--
--
EBITDA
--
--
AnyRoad logo

AnyRoad

Enterprise SaaS platform for managing, measuring, and optimising branded experiential marketing.

attentive.xlsx
Metric
2026
2027
Revenue
--
--
EBITDA
--
--
AT

Attentive

B2B SMS / mobile marketing SaaS for e-commerce and retail brands.

aura.xlsx
Metric
2026
2027
Revenue
--
--
EBITDA
--
--
Aura logo

Aura

All-in-one consumer "intelligent safety" subscription replacing fragmented point solutions for identity, device, WiFi, social, assets, and privacy protection.

belgian-boys.xlsx
Metric
2026
2027
Revenue
--
--
EBITDA
--
--
Belgian Boys logo

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.xlsx
Metric
2026
2027
Revenue
--
--
EBITDA
--
--
BS

Bespoken Spirits

Technology company that replaces barrel aging with a proprietary ACTivation process to produce premium, customizable spirits in days rather than decades.

Go further

Build the financial model you need with Fina

Browse templates, examples, and downloadable Excel models for the analysis you are trying to build. If you can't find your model, ask Fina to build a model for your specific needs.

Start for free
Excel financial model spreadsheet preview showing Customer Rollforward
Fina interactive chat interface preview