BusinessPlanHub

Consumer Product Brand Financial Model, Free in Excel

The BusinessPlanHub CPG financial model is a free Excel download for a consumer product brand, with a product cost input, a subscription revenue line and three statements over 60 months.

Download the free model Book a free consultation

Free · Excel (.xlsx) · Imports into Google Sheets

Download the CPG financial model

Pick this for a single-brand product business with subscribe-and-save sales.

We use your email to send you the model and offer a free consultation. No spam.

Why does a CPG brand need its own financial model?

A product brand lives or dies on what one unit earns. A store can survive thin margins on volume. A brand with one hero product and a subscription cannot hide behind a catalogue.

The BusinessPlanHub CPG model uses the same engine as the ecommerce model. The difference is the revenue side. It adds subscription inputs (price, churn and active subscriptions), so you can model one-off buyers and subscribe-and-save customers separately.

It covers 60 months and builds an income statement, balance sheet and statement of cash flows.

What does one unit earn?

Start with a single unit. Before you touch the Assumptions tab, write down the price a customer pays and the full cost to deliver it.

LineQuestion to answer
Selling priceWhat does the customer pay per order, after any discount?
Product costWhat does the unit cost to make, pack and inbound?
Payment processingWhat do you lose to card fees?
Fulfilment and shippingWho pays, you or the customer?
Gross margin after product costWhat is left to fund marketing and overheads?

The file has a Product Cost input and a separate Payment Processing line. If your orders contain several units, work out the cost of a whole order first.

Here is the part founders skip. Marketing has to be paid from that margin. If the gross margin cannot cover customer acquisition, no growth rate will fix it.

How should I model subscribe-and-save?

Model subscriptions as their own line, with a price, a churn rate and the active base carried forward month to month. The file does exactly that: it tracks previous months’ active subscriptions, churned subscriptions and retained subscriptions.

Churn is the input to defend. A lender or investor will ask where it comes from. If you have no subscribers yet, use a cautious figure and explain it. Do not assume that people who subscribe in month one are still paying in month twelve.

Also check whether subscribers cannibalise one-off orders. A customer who moves to a subscription may stop placing one-off orders. Keep the two honest.

When does retail or wholesale change the model?

Retail and wholesale change the model the moment a retailer buys from you instead of the customer. The file models direct-to-consumer orders, so it does not do this for you.

If you add a wholesale line, you will need to add:

  • a revenue line for retailer orders, at your wholesale price, not the shelf price
  • a cost to win and support the account
  • payment terms, since retailers usually pay later than a card does
  • more inventory, because you stock ahead of their orders

The file has inputs for inventory, average days receivable and average days payable, which you can use to reflect those terms. The wholesale revenue line itself you add by hand. Say that clearly in your plan, so a reader knows which part is modelled and which is added.

For the shape of a plan in this space, see the food and beverage sample plans and the manufacturing and wholesale plans. Their figures are invented, so use them for structure only.

What do reviewers check in a product brand’s numbers?

They check margin, repeat behaviour and cash tied up in stock. In that order, usually.

  • Margin. Is the product cost realistic at your volume, and does it include everything?
  • Repeat behaviour. Is your returning customer rate backed by your own data?
  • Cash. Inventory is paid for before it sells. Does your starting cash and equity cover it?
  • Acquisition. Does paid ad spend rise with orders?

If you plan to raise money, expect the cash questions first. See how to build financial projections for how reviewers read them.

Free to use, free to check

The example numbers in the file are placeholders, so overwrite them all.

If you want a second pair of eyes on the unit economics, book a free 30-minute consultation. Open the .xlsx in Excel, or bring it into Google Sheets with File > Import.

Sample business plans that fit this model

These are 6 of 9 sample plans for businesses that earn money the way this model does. Every sample plan is a fictional example, so use it for structure, not for figures.

Browse more: Food & Beverage business plans · Manufacturing & Wholesale business plans

CPG financial model: common questions

Does the CPG model include wholesale or retail distribution?

No. The file models direct-to-consumer orders and subscriptions. If you sell through retailers or distributors, add a wholesale revenue line and its own cost and payment-terms assumptions.

How does the subscription line work?

It sits alongside the one-off order inputs and uses a price, a churn rate and the previous month's active subscriptions. You set each one from your own expectations.

Can I open the CPG template in Google Sheets?

Yes, by importing it. Use File > Import in Google Sheets, then recheck the Financials tab.

What is the difference between the CPG and ecommerce models?

They share one engine. The ecommerce model is for a store with many products, and this one adds the subscription line a product brand needs.