How to Build a CPG Financial Model (With Metrics)
A CPG financial model is fundamentally different from a SaaS or e-commerce model. If you pitch a consumer investor with a model that doesn't account for distributor margins, trade spend deductions, and the cash conversion cycle of manufacturing, you will be laughed out of the room. Here is how to structure a financial model for a wholesale food brand.
1. The Revenue Bridge (Gross to Net)
In CPG, what you invoice is never what you collect. Your model must clearly bridge Gross Revenue to Net Revenue.
- Gross Revenue: The total value of the invoices sent to your distributors or retailers.
- Less Trade Spend: Deduct your MCBs, off-invoice discounts, and slotting fees (typically 15-25% of gross).
- Less Spoilage/Damages: Deduct an allowance for unsalable product (typically 1-2% of gross).
- Less Cash Discounts: Deduct the 2% discount distributors take for paying early (2% Net 10).
- = Net Revenue: The actual cash you expect to collect.
2. The True COGS Calculation
Your COGS must be fully burdened. Do not just model the invoice price of your ingredients. A fully burdened COGS includes:
- Raw ingredients and packaging
- Inbound freight (getting materials to the co-packer)
- Tolling fees (the co-packer's labor charge)
- Yield loss (the 5% of ingredients scrapped during production)
Subtracting your fully burdened COGS from your Net Revenue gives you your Gross Margin.
3. The Cash Conversion Cycle (CCC)
This is where food brands go bankrupt. Your model must project cash flow, not just P&L profitability. The Cash Conversion Cycle measures how long your cash is tied up in inventory before it turns back into cash from sales.
If you have to pay your co-packer Net 30, but the product sits in a warehouse for 60 days, and then UNFI takes 45 days to pay the invoice, your cash is tied up for 75 days. Your financial model must show the working capital required to bridge this gap, especially during periods of rapid growth when you are funding massive pipeline fills.
4. Freight and Fulfillment (OpEx vs COGS)
Be clear about where freight lives in your model. Inbound freight (to the factory) belongs in COGS. Outbound freight (from your 3PL to the distributor) belongs in Operating Expenses (OpEx) under logistics. Separating these allows you to analyze your manufacturing efficiency independently from your logistics efficiency.
Moving Beyond the Spreadsheet
A spreadsheet model is necessary for fundraising, but it is too slow for daily operations. To manage your actual business, you need operations software that tracks your real-time landed COGS and trade spend deductions, ensuring your actual performance matches your modeled projections.
Frequently Asked Questions
What is a good gross margin for a food brand?
A healthy food brand should target a fully-burdened gross margin of 40% to 50%. Anything below 35% makes it incredibly difficult to absorb trade spend, outbound freight, and marketing costs while eventually reaching profitability.
What is a 2% Net 10 payment term?
It is a standard grocery industry term meaning the distributor will deduct 2% from the invoice total if they pay you within 10 days; otherwise, the full amount is due in 30 days. In practice, major distributors often take the 2% discount even if they pay in 45 days.
How do I model slotting fees?
Slotting fees should be modeled as a deduction from Gross Revenue (Trade Spend) in the month the new stores launch. They represent a massive, one-time hit to profitability that must be funded by working capital.
Help shape the commercial release.
A working prototype validated Guidance's core operating model. The commercial rebuild is translating that proof into production-ready workflows with CPG design partners.
Apply as Design Partner →SKU Unit Economics and Rationalization
Build a SKU P&L at unit level. Start with Net Price per Unit (price after retailer margin and deductions) and subtract Variable COGS, direct fulfillment, and attributable promo cost to get Unit Contribution Margin: Unit CM = Net Price - (Variable COGS + Fulfillment per unit + Promo per unit). Then calculate Contribution Margin Percent = Unit CM / Net Price. For decision making, compute Break Even Volume = Allocated Fixed Costs / Unit CM. If Unit CM is negative or break even is unreachable given demand, flag the SKU for rationalization. Use a simple ranking: contribution dollars per SKU, contribution percent, and absolute volume. A practical rule for small brands: if a SKU contributes less than 5% of total contribution dollars and has contribution percent below portfolio average, prioritize discontinuation or reformulation.
Include SKU-specific hidden costs: separate out slotting fees, special packaging runs, and quality callbacks into an SKU overhead bucket. Track these monthly and allocate by run frequency or revenue. Run a quarterly SKU health check using three thresholds: contribution margin percent, annualized velocity, and changeover frequency. If a SKU forces more than X extra changeovers per quarter or consumes more than Y percent of co-packer minimum runs, it creates operational friction that should be quantified as a negative adjustment to the SKU CM.
Modeling Trade Promotions and Promo ROI
Model promotions as incremental drivers, not just discounts. Start with baseline weekly velocity by SKU and channel. Estimate Lift% from comparable promos or historical averages. Incremental Units = Baseline Units x Lift%. Incremental Gross Profit = Incremental Units x Unit Contribution Margin. Promo Spend should include price discount, retailer funding, free goods, and incremental logistics. Then calculate Promo ROI = (Incremental Gross Profit - Promo Spend) / Promo Spend. Example: baseline 10,000 units, lift 30% = 3,000 incremental. If Unit CM = $1.25, incremental gross = $3,750. If promo spend is $3,000, Promo ROI = (3750 - 3000) / 3000 = 25%.
Adjust for cannibalization and post-promo slump. Apply a cannibalization rate to estimate lost sales from other SKUs or weeks. Apply a post-promo reversion factor for the following 4 to 12 weeks. Practical guardrails: require promo ROI greater than 20 to 50 percent to justify trade funded promotions if inventory and cash costs are material. Track promo-driven accounts receivable and ensure retailer deductions are forecasted as lagged cash outflows. Maintain a promo calendar in the model to avoid overlapping promos that erode incremental lift.
Production Batch Economics and Run Scheduling
Treat production runs as economic levers. Use the Economic Order Quantity framework when you control runs: EOQ = sqrt(2 x D x S / H) where D is annual demand in units, S is setup cost per run, and H is annual holding cost per unit. Example: D = 120,000 units, S = $500, H = $0.25 results in EOQ ≈ 21,900 units. If co-packer minimum runs are 5,000 and changeover times add $750 in labor, recalculate S and rederive EOQ. When using co-packers, track effective per-unit setup amortization = Setup Cost / Run Quantity and push that into product COGS for each SKU.
Layer in real constraints: packaging lead times, seasonal demand spikes, and shelf-life limits. Build a manufacturing cadence plan with run frequency, expected yield loss percentage, and buffer stock targets. Quantify the cost of smaller runs by adding changeover and testing fees to per-unit cost. Use sensitivity tables that show per-unit cost at run sizes of 5k, 10k, 20k, and EOQ to help commercial teams price promos and assess SKU viability.
CapEx, Depreciation, and Buy Versus Co-pack Decisions
When evaluating equipment, quantify the cash payback and the accounting impact separately. Use straight-line depreciation for modeling simplicity: Annual Depreciation = Purchase Price / Useful Life. For example, a filler costing $250,000 with a 7-year life is $35,714 depreciation per year. Cash payback is Purchase Price / Annual Cash Savings. If insourcing saves $0.05 per unit and runs 1,000,000 units per year, cash savings are $50,000 and payback is 5 years. Include maintenance capex of 1 to 2 percent of equipment value annually and spare parts inventory as working capital.
Also model financing structures: upfront cash purchase, capital lease, or loan. A loan moves cash outflows to scheduled repayments and interest, and may change covenants. Run sensitivity on utilization: how many hours or units are needed to reach targeted per-unit cost. Finally, consider strategic tradeoffs: owning gives control and potentially lower long-term COGS but increases fixed costs and operational complexity. Co-packing keeps capex low but limits flexibility and can mask per-unit setup inefficiencies that are easier to optimize when you own the line.