The short answer: A forecast both buyers and lenders believe is built from the shelf up with a realistic ramp. It separates what the retailer orders from what shoppers buy, sources every assumption, ties sales to a cash plan, and runs three cases, with the conservative one being the case the business can survive on.
“Will it sell through on the shelf?” “Will you pay us back?”
Those are the questions behind every launch forecast a founder hands to a retail buyer or a lender. Same spreadsheet, different worry.
Two readers, two questions
A retail buyer reads your forecast with one thing in mind: will this product earn its spot on the shelf? They look at velocity, meaning units per store per week, how many stores you want, and how fast distribution will build. They want to see the promo plan and the marketing support that will drive shoppers to the shelf. We cover what else buyers weigh in Retail Readiness Strategy: The 4 Things Buyers Want to See Before They Say Yes.
A lender or investor reads the same forecast with a different question: will this business turn inventory into cash and pay us back? They look at how long cash is tied up, plus working capital, production minimums, payment terms, trade spend, slotting, deductions, and chargebacks. They want to know what margin is left after all of it, and whether the business works if sales come in light.
One forecast should answer both, because the answers are connected. Velocity drives reorders. Reorders drive cash. Cash decides whether you can fund the next production run.
Build it from the shelf up, not the category down
The fastest way to lose a buyer or a lender is a top-down forecast. “The category is worth billions, and we only need 1% of it” sounds modest. It is a red flag, because it says nothing about how a unit gets sold.
A bottom-up forecast starts with the shelf. The math is simple:
Stores x units per store per week x weeks on shelf = units sold to shoppers
Say a retailer authorizes you in 200 stores, and you expect each store to sell 2 units a week. If every store were selling for a full year, that would be 200 x 2 x 52, or 20,800 units.
But stores do not all start selling on day one. Product has to reach distribution centers, then stores, then the shelf. So build in a ramp. For example, say only half the stores are selling during the first 13 weeks, and all 200 are selling after that. Now the first quarter is 100 x 2 x 13, or 2,600 units, and the rest of the year is 200 x 2 x 39, or 15,600 units. The year lands at 18,200 units, not 20,800, and a buyer can believe it.
Do this by retailer and by month. It takes longer than a top-down guess, but every line can be explained.
Separate the retailer’s order from the shopper’s purchase
This is where many launch forecasts go wrong. A new retailer places an opening order to fill its distribution centers and stores. That is sell-in, often called pipeline fill. It is not shoppers buying your product.
Say that same retailer wants 12 units per store to fill the shelf and the back room. That is 200 stores x 12 units, or 2,400 units in the opening order. It looks like a big first month. Then it goes quiet, because the retailer will not reorder until shoppers buy through that stock.
Show the two separately. Line one is the opening order. Line two is sell-through, from the stores x velocity math above. Line three is reorders, which depend on sell-through, not hope. If sell-through comes in light, reorders should drop automatically.
Show your work on every assumption
Every number in a forecast is an assumption, and credible ones say where they came from. Add an assumptions tab and label each input with its source:
- Comparable brands. How similar products at a similar price perform, from data you can point to.
- Test results. Sales from a regional launch, a pilot set of stores, or your own site, noting how that channel differs.
- Retailer data. What the retailer shares about the category or similar items.
- Syndicated data. Category and competitor sales from scan data providers, if you have access.
When an assumption is a judgment call, say so. “Estimated from comparable brands” beats a precise number with nothing behind it. Nobody trusts a guess dressed up as certainty.
If you want a second set of eyes on your assumptions before a buyer meeting or a lender conversation, grab 15 minutes with us and bring your current forecast.
Run three cases and live on the conservative one
Build a conservative case, a base case, and an upside case. Change only a few key inputs, like velocity, ramp speed, and reorder rate. For example, using the 200 stores above, the conservative case might assume 1 unit per store per week, the base case 2, and the upside case 3.
Here is the part most founders skip: plan your cash around the conservative case. If the business can pay its bills and cover its production minimums at that number, you have a launch plan. If it only works at the upside number, you have a bet.
Connect the forecast to your cash plan
A sales forecast says what you might sell. A cash plan says whether you will still be in business when the money arrives. Lenders need both, linked.
Start with timing. Say you pay your manufacturer for a production run in March, ship the opening order in May, and the retailer pays 60 days after it receives the goods. That is roughly four months between cash going out and cash coming in. Map that gap month by month.
Then subtract what the invoice does not show. Trade spend, promotions, slotting fees, and free fill reduce what you collect. Deductions and chargebacks come out of retailer payments, sometimes months later. Make each one a line in the forecast. We wrote about how these costs quietly erode margin in Trade Spend Is Not Marketing: How Promo Dollars Quietly Kill Your Margin.
What is left is the margin that matters. If it covers your costs in the conservative case, a lender can see a path to repayment. If not, the forecast is not finished.
Count what inventory and payment terms really cost
Inventory is not free while it waits. Every case costs money: storage, insurance, the interest or cost of capital on the cash tied up in it, and the risk of shrink, damage, obsolescence, and product aging out. Many supplements, foods, and beverages carry dates, so slow reorders can turn good inventory into a write-off. That is carrying cost, and it eats margin while product waits on the next purchase order.
Your forecast should show days of inventory, meaning how long product sits between production and sale. For example, say you hold about 90 days of inventory and your carrying costs run about 2% of inventory value per month (illustrative numbers). That is roughly 6% of the stock’s value spent just holding it.
Payment terms deserve the same attention. Some retailers push for longer net terms, meaning they pay you later. Each extra month is another month of inventory and production you fund yourself, which hurts most when you paid your manufacturer up front. Know your actual terms before you commit to volume, and put those terms, not the ones you hope for, into the cash plan. If a retailer asks to stretch them, model what that does to your cash before you agree.
Put the marketing and promo plan in the forecast
Marketing that drives shoppers to the shelf speeds up sell-through. Faster velocity brings repeat purchases and reorders, so inventory sits for fewer days, carrying costs drop, and cash comes back sooner. A product that moves also gives you leverage with the retailer, both to get paid on time and to push back when terms start to stretch. So the marketing plan behind the launch belongs in the forecast, with its timing and cost, next to the sales numbers it is meant to drive.
Promotions are part of that plan, and this is where it gets hard. A promotion lifts velocity while it runs. Run them too often, and shoppers learn to wait for the deal. Price perception slips, margin shrinks, and your everyday velocity looks weak to buyers and lenders, because the only strong weeks are the discounted ones. Promote too little, and a new product can sit unnoticed. There is no perfect formula, and the balance is genuinely hard to get right.
The forecast can at least make the trade-off visible. Show baseline velocity, what you sell at full price, separately from promo lift. Plan a limited promo calendar where every event has a clear purpose, like driving trial at launch or supporting a new retailer. Then include the full cost of each promotion, so the lift is weighed against what it costs.
The mistakes that sink credibility
These patterns cost trust with buyers, lenders, or both.
- The hockey stick. A steep climb with no explanation. Every jump should tie to something specific, like new stores, a promotion, or a new retailer.
- Treating pipeline fill like a run rate. A big opening order is not proof of demand, and it will not repeat every month.
- Forgetting trade and deductions. A forecast built on gross sales overstates the cash you will collect, and lenders notice.
- One forecast for the buyer, another for the bank. Sooner or later you will have to explain the gap. Build one model with three cases, and show each audience the parts they care about.
For more of the commercial mistakes that hurt launches, read The 7 Biggest Go-to-Market Mistakes CPG Founders Make (And What Each One Costs).
What to do this week
You do not need a finance team to fix your forecast. Start with five steps.
First, rebuild your sales line from the shelf up: stores, units per store per week, and weeks on shelf, with a realistic ramp by retailer.
Second, split the opening order from sell-through, and tie reorders to sell-through.
Third, add an assumptions tab, label the source of every key input, and show baseline velocity separately from promo lift. Then build your three cases.
Fourth, link the conservative case to a month-by-month cash plan that includes production timing, days of inventory, carrying costs, trade spend, and deductions.
Fifth, confirm your actual payment terms with each retailer before you commit to production volume, and plug those terms into the cash plan.
A forecast buyers and lenders both believe is not the most optimistic one. It shows its work and holds up when sales come in light.
To talk through your launch forecast, grab 15 minutes with us.
