Quick answer
A financial model for a CPG brand is a connected projection of the business (P&L, balance sheet, and cash flow) that reflects how consumer packaged goods actually make money: revenue across retail and DTC, gross-to-net deductions and trade spend, and cash tied up in inventory. A good CPG model ties demand, margin, inventory, and cash together.
What a CPG model has to get right
A generic three-statement model treats revenue as one line and cost as another. A CPG model cannot. It has to reflect that a wholesale dollar and a DTC dollar carry very different margins, that trade spend and deductions shrink the top line, and that inventory ties up cash months before revenue arrives.
Key term: Gross-to-net. The bridge from list sales to net revenue after discounts, trade spend, deductions, and returns, often a 15 to 30 percent gap in CPG that a naive model ignores.
The building blocks
- Channel P&Ls. DTC, Amazon, and wholesale, each with real margins and fees.
- Gross-to-net. Trade spend, deductions, and returns modeled explicitly.
- Inventory and purchasing. POs, lead times, and the cash they consume.
- Unit economics. Contribution margin and, for DTC, cohort payback.
Why the pieces must connect
The value of a model is in the links. Change a retail forecast and inventory purchases, cash, and margin should all move. When Oats Overnight modeled a facility expansion, the answer only became clear because demand, capacity, and cash were connected: waiting was a $4M miss, not a saving. A disconnected model would have shown the saving and hidden the cost.
Where Drivepoint fits. Drivepoint is the AI finance platform built exclusively for consumer brands. It consolidates Shopify, Amazon, retail partners, and your GL into one live model in Excel, then answers what-if questions in minutes. Customers improve EBITDA margins by 6.7 points on average in their first year, and one exceptional finance person with Drivepoint replaces three without it.