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.

Free, no credit card required
Edit in Excel
Created by ex-finance
professionals from Deloitte
Loading...

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

Go further

Build the financial model you need with Fina AI

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.

Excel financial model spreadsheet preview showing Customer Rollforward
Fina interactive chat interface preview
Career Principles

Learn Financial Modelling Skills with industry-leading Career Principles

Breaking into the finance industry? Explore courses in Excel, financial modeling, valuation, data analytics, and AI for business and finance.

Career Principles lesson on preparing a cash flow statement in Excel
Career Principles Financial Analyst Program
Career Principles Python for Data Analysis
Career Principles AI for Business and Finance course