CATEGORY

FP&A Strategy

WRITTEN BY

Fin

Your AI CFO

FP&A Strategy

Building a CPG Financial Model for Series A

Building a CPG Financial Model for Series A

FP&A Strategy

5 minutes

WRITTEN BY

Fin

Your AI CFO

SHARE BUTTONS

WRITTEN BY

Fin

Your AI CFO

SHARE BUTTONS

Raising a CPG Series A in 2026 looks different than it did a few years ago. Investors have moved past velocity and brand story and want to see financial evidence before the conversation gets serious. Channel economics, trade spend modeling, scenario analysis with documented assumptions. If your model can't answer the basic questions in the first meeting, the process slows down fast. This is what the bar actually looks like.

TLDR:

  • CPG Series A models need channel-level P&L: blended gross margin hides which channels earn and which erode the business

  • Trade deductions cut gross sales 15% to 30% before COGS; your model needs a gross-to-net bridge with monthly accruals

  • Investors benchmark LTV:CAC at 3:1+ and CAC payback under 12 months; channel-level contribution margin, not gross margin, closes rounds

  • Model your cash hole explicitly, because inventory POs go out months before retailers pay on net 30 to 60 terms

  • Iris Finance builds a connected three-statement CPG model from live Shopify, Amazon, and accounting data, with category benchmarks across ~500 brands and ~$20B GMV

Why a CPG Financial Model Is Different From a Standard Three-Statement Model

A standard three-statement model tracks revenue, costs, and cash. That works for a SaaS business where revenue is recurring and inventory doesn't exist. CPG is structurally different, and a model that ignores that structure will get picked apart in any serious Series A diligence process.

CPG revenue is not one number. It's a stack of channel-specific economics for omnichannel CPG: DTC margin looks nothing like Amazon margin, which looks nothing like retail. Each channel carries its own deduction structure, fee load, and cash timing. Blending them into a single revenue line hides the real picture. Beyond channel economics, inventory sits on the balance sheet as a working capital commitment that swings cash flow materially, and trade spend erodes gross margin in ways that don't surface cleanly in a standard income statement. Investors know this. If your model doesn't reflect it, the gap between your numbers and theirs becomes a credibility problem.

What the Series A Bar Looks Like for CPG Brands in 2026

CPG funding has shifted from growth-at-all-costs to profitability, and that change is showing up in diligence expectations. Growth rate matters, but repeatable unit economics matter more. A brand showing $5M to $10M in revenue with improving contribution margin per channel and a clear path to profitability will get further than one growing faster on blended numbers nobody can explain.

Most Series A rounds for CPG brands in 2026 fall between $8M and $15M, with a fundraising timeline of four to six months from first meeting to close. That timeline compresses fast if your model cannot answer basic questions about use of proceeds. Investors want to see capital deployment connected directly to outcomes: more DTC spend, a retail push, inventory build. Your capital productivity model needs to validate each assumption behind it.

The Core Structure Investors Expect in a CPG Financial Model

Investors expect a connected three-statement model: income statement, balance sheet, and cash flow, all linked so that a change in one assumption ripples through automatically. Monthly granularity for the first 24 months, quarterly for years two and three, and annual beyond that is the standard expectation going into Series A due diligence.

"Connected" has a specific meaning here. If you change your DTC revenue assumption, your COGS, inventory requirement, accounts payable, and ending cash balance should all update without manual intervention. When they don't, investors notice. Siloed statements where the cash flow was built separately from the income statement, or where the balance sheet doesn't tie out, read as a signal that the finance function isn't ready for institutional capital.

The income statement carries channel-level detail. The balance sheet reflects inventory as working capital, not a footnote. The cash flow statement shows the actual timing of when money moves, beyond when revenue is recognized.

Channel-Level P&L: Why Blended Margin Kills Deals

Blended gross margin answers none of the questions investors actually ask. When DTC, Amazon, and wholesale revenue collapse into one line, you lose visibility into which channels earn and which ones quietly erode the business.

The same SKU can generate roughly 35% contribution margin on DTC and 18% on Amazon, not because COGS for ecommerce CPG brands differ, but because each channel carries its own fee structure and fulfillment dynamics. Amazon referral fees, FBA costs, and advertising loads compress margin in ways that only surface when you model each channel separately.

Investors will reconstruct this analysis during diligence regardless. Brands that produce it proactively signal financial sophistication. Brands that cannot produce it signal the opposite.

Gross-to-Net and Trade Spend Modeling

Revenue in a CPG model rarely means what the invoice says. Between list price and the cash that actually lands in your account sits a waterfall of deductions: trade spend, promotional allowances, slotting fees, chargebacks, and returns. These routinely reduce gross sales by 15% to 30% before you ever reach cost of goods.

The complication is timing. Retailers bill many of these deductions retroactively, sometimes months after the sale. A model that books gross revenue without accruing for expected deductions will overstate profitability in early periods and absorb a painful correction later. Trade spend in CPG retail is typically treated as contra-revenue, and CPG trade spend benchmarks show it accounts for 15% to 25% of gross sales before suppliers receive payment, making accrual accuracy critical. Investors recognize this pattern immediately.

What they want to see is a gross-to-net bridge: a structured waterfall from list price to net revenue, with each deduction category broken out, accrued monthly, and tied to specific customer or retailer agreements. Accrual methodology matters as much as the line items themselves.

Unit Economics Investors Will Pressure-Test

Gross margin tells investors what you charge minus what it costs to make. Contribution margin tells them whether the business actually works at scale. Investors at Series A push hard on the latter because it accounts for variable costs gross margin ignores: fulfillment, paid media, merchant fees, and channel-specific deductions.

The benchmarks vary by category. Food and beverage brands typically target lower gross margins than supplements and personal care, which tend to run meaningfully higher. But gross margin alone won't close a round. Investors want channel-level contribution margin with a clear path of improvement as volume scales.

CAC payback and LTV:CAC round out the pressure test. A payback period under 12 months and LTV:CAC at or above 3:1 are the reference points most investors use. For subscription brands, net dollar retention becomes a fourth variable. A brand growing fast but losing revenue from existing cohorts year-over-year carries a very different risk profile than one holding or expanding it.

Scenario Modeling and Sensitivity Analysis

A base case model tells investors where you expect to land. Scenario analysis tells them how well you understand your own business.

The standard framework is bull, base, and bear, each built on individually documented assumptions. Investors will ask why your base case CAC is $42 and not $55. If assumptions aren't documented, they become circular during diligence, and circular assumptions are the most common reason models fall apart before a term sheet.

The variables that move CPG unit economics models most are COGS, CAC, AOV, and channel mix. A 200 basis point COGS shift from a tariff change can compress contribution margin enough to push payback periods past the threshold investors use to underwrite a deal. For brands sourcing internationally, tariff sensitivity has become a near-mandatory section of any credible Series A model.

Each scenario should change no more than three to five assumptions from the base case, with every change explained in plain language. Scenarios requiring simultaneous best-case outcomes across every variable aren't scenarios; they're optimism with a spreadsheet attached.

Inventory and Cash Flow Modeling

Inventory is where CPG models most often break down before a term sheet.

The core problem is timing. Product gets purchased months before it ships, before a retailer pays, and before any revenue hits the income statement. A model that records revenue when earned but never shows the cash required to fund the inventory build underneath it will produce a misleadingly healthy picture, right up until the brand runs out of runway.

What investors want is a working capital model that connects the sales forecast to inventory purchasing, then connects both to a rolling 13-week cash flow forecast. The demand assumption drives a purchase order. That PO creates a payable with a specific due date. Revenue gets collected on net 30 to net 60 terms depending on the retailer. The gap between cash out and cash back is the cash conversion cycle, and it needs to be modeled explicitly.

Model Component

What It Shows

Inventory build schedule

PO timing and amounts tied to demand plan

Accounts payable

Vendor payment terms and cash outflow timing

Accounts receivable

Retailer payment terms and collection timing

Working capital gap

Cash required before collections close the cycle

A founder who can show the cash trough at peak inventory build, with a clear explanation of how Series A proceeds bridge it (including whether debt vs. equity financing is the right structure), is a founder who understands how CPG businesses actually fail.

How to Build a Data Room That Supports Your Model

The model is only half the package. How you present it tells investors as much as the numbers themselves.

A Series A data room for a CPG brand should include 24 months of monthly actuals broken out by channel, a connected three-statement model with every assumption documented, cohort data by acquisition channel, and a gross-to-net bridge. Each piece should be traceable back to source data, not manually assembled exports that introduce reconciliation risk.

Investors read the organization of a data room as a proxy for how the business is run. A folder of unlabeled Excel files signals that finance is still in spreadsheet mode. A clean, structured room with clearly labeled sections and consistent formatting (aligned with board-ready finance reports for CPG brands) signals a team that has already internalized institutional standards. The underlying numbers can be identical in both cases, but the latter closes faster.

Start assembling diligence materials three to six months before you plan to actively fundraise. Founders who wait until a first meeting to begin organizing financials spend the early weeks of a process answering data requests instead of advancing conversations. That lag costs negotiating position, and negotiating position is what drives valuation.

Common Financial Modeling Mistakes CPG Founders Make Before a Series A

Most of these mistakes don't sink deals outright. They create questions that compound until an investor loses confidence mid-process.

  • Blended gross margin where channel-level contribution should be. Investors rebuild this themselves and ask why you didn't.

  • Inventory modeled as a balance sheet entry with no connection to the cash flow forecast. The cash hole becomes visible during diligence, not before.

  • Revenue presented at gross with deductions buried in a footnote. When the net revenue bridge doesn't tie to the bank, the integrity question spreads to every other number.

  • A model that cannot be tied back to monthly actuals. If the 2024 revenue in your model doesn't match the 2024 revenue in your P&L, no assumption in year three matters anymore.

  • Scenarios that aren't scenarios. Three tabs with different titles but the same optimistic assumptions don't constitute sensitivity analysis.

The investor question that exposes each of these is the same: "Can you walk me from this line to your bank statement?" A model built on verified actuals answers that in minutes. One built on exported spreadsheets assembled under fundraising pressure often can't.

How Iris Finance Helps CPG Brands Prepare a Series A-Ready Financial Model

Iris builds the financial model every earlier section describes as table stakes for a Series A, pulling live data from Shopify, Amazon, TikTok, and your accounting system into a connected three-statement model. The model generates in one to two hours and reforecasts in roughly 15 seconds after month-end close, so your model is never a static artifact from six weeks ago when investors start asking questions.

The benchmarking layer matters just as much. With data across roughly 500 brands and approximately $20B in GMV, Iris gives you category-level reference points for contribution margin, CAC payback, and LTV:CAC. When an investor asks why your base case CAC assumption is $42, you can show it against what similar brands in your category have actually achieved.

Investor-Grade Diligence, Without the Manual Reformatting

The Data Rooms feature assembles diligence materials directly from verified Iris data, with watermarked access control and data integrity flagging built in. The manual export step that quietly introduces errors into most diligence packages is gone. What investors receive traces back to source data automatically.

Iris also stays accurate within 50 basis points of final actuals before books close. Most CPG founders spend a live process working off numbers that are four to six weeks stale. Brands that use Iris before a raise typically continue post-close.

Final Thoughts on What Series A Investors Expect From a CPG Financial Model

The brands that move through a Series A process cleanly are almost always the ones that treated the model as a living document, not a fundraising artifact. Channel economics, working capital timing, and documented assumptions aren't extras; they're the baseline your investors will check against. Start building that foundation now, and the diligence conversations become a lot more straightforward. The Iris team works with CPG brands doing exactly that.

FAQ

What is the best FP&A tool for a CPG brand preparing for a Series A raise?

Iris Finance is purpose-built for this use case: it pulls live data from Shopify, Amazon, TikTok, and your accounting system into a connected three-statement model with channel-level contribution margin, scenario modeling benchmarked against ~500 brands, and a data room that traces directly to source data. Generic FP&A tools like Pigment or Anaplan are built for enterprise planning cycles, not CPG-specific economics like gross-to-net bridges, Amazon fee structures, or inventory-driven cash holes.

How do I model the impact of a tariff increase on my CPG brand's gross margin?

Run the tariff as a COGS shock in your base case: isolate the affected SKUs, apply the cost increase at the unit level, and let it flow through contribution margin by channel, since DTC and Amazon will absorb it differently given their fee structures. Change one assumption at a time, document the basis, and show the payback period impact explicitly; investors will run this analysis regardless, and a model that already answers it removes a diligence friction point.

What should a CPG series A financial model include to survive investor due diligence?

At minimum: a connected three-statement model with channel-level P&L, a gross-to-net bridge from list price to net revenue, an inventory build schedule tied to the cash flow forecast, CAC payback and LTV:CAC by acquisition channel, and three documented scenarios with no more than three to five assumption changes each from the base case. Monthly granularity for the first 24 months is the standard expectation, and every number should trace back to monthly actuals. If it doesn't tie to your bank, no assumption in year three survives scrutiny.

How can cohort data help a CPG brand support LTV projections to Series A investors?

Cohort data by acquisition channel gives investors an empirical basis for 24 to 36-month LTV projections instead of a forward assumption with no support underneath it. Brands with at least 18 months of cohort history can show actual repurchase frequency, net dollar retention, and CAC payback curves: the specific signals investors use to stress-test whether the growth model holds as paid media scales.

How should a CPG brand structure its data room before series A fundraising?

See the data room section above for the full checklist. The organizing principle matters as much as the contents: investors read data room structure as a proxy for how the finance function operates, and a clean, labeled room signals institutional readiness, shortening the diligence cycle in ways that directly affect negotiating position.