How a CPG Brand's Financial Model Caught a SKU Trend Before It Derailed Their Projections

Kimberly Green | 2026-04-14

<!DOCTYPE html> CPG Financial Model SKU Trend Case Study How a CPG Brand's Financial Model Caught a SKU Trend Before It Derailed Their Projections

A consumer packaged goods brand was watching their sales data when something odd showed up on the dashboard. For six months straight, one product format was tanking while another was exploding. The natural read was market demand had shifted hard. Customers wanted the smaller size. The larger size was becoming obsolete. The data seemed obvious.

So they started building next year's projections around that trend. A full 5-year plan—revenue, margins, cash flow—all built on the assumption that the smaller size would keep winning and the larger size would keep declining. That's the default. Trends continue until someone proves they don't.

Then their financial modeler looked at the projections and asked one question that changed the entire plan.

The Question That Changed Everything

Ashley Aviram, who handles financial modeling for CPG and ecommerce brands at Ever Ledger, put the numbers in front of the founders and asked: "Is this trend real or is something else happening?"

The founders looked at it. Then one of them said: "Oh. Yeah. We stopped manufacturing the large size six months ago."

They were literally selling through the last inventory. The "trend" wasn't consumer preference. It wasn't market shift. It was inventory depletion of a discontinued product. If they built next year's model on the assumption that the trend would continue, they'd be projecting growth for a product line they'd already killed.

This is the difference between a spreadsheet and actual financial modeling. A spreadsheet projects forward. A real model asks questions. Numbers tell you where to look, not what you'll find when you look there.

Why This Matters for Your Projections

In CPG and ecommerce, sell-through rates are gospel. They're the one metric that shows you what customers actually want, stripped of inventory distortions, marketing noise, and founder intuition. They're the closest thing you get to pure signal. They're also the easiest metric to misinterpret if you don't know what's actually driving the movement.

When you run ecommerce SKU analysis accounting through a financial model, a declining SKU can mean almost anything. Actual demand loss. Manufacturing discontinued. Distribution pulled from channels. Seasonal noise. A competitor taking share. Each scenario is a different 5-year forecast. Each requires different assumptions and cash flow projections.

Your model can't know which one is real. But it can organize the data clearly enough that the people running the business—the people who actually know—can answer. That's the whole point.

The Conversation Is Half the Model

Most founders think of financial modeling as a technical exercise. Build it. Run the projections. Done. Actually, that's the first half.

A real financial model is built for questions, not answers. You feed it sell-through rates, inventory turns, channel mix, cohort data—the raw material of ecommerce SKU analysis accounting. It organizes it all and asks: Does this make sense? And when the answer from the data is "no"—when something doesn't line up, when a trend looks wrong, when behavior doesn't match assumptions—that's where the conversation starts. The modeler and the founder, looking at the numbers together, digging into what's actually true.

For this CPG brand, that conversation meant their entire 5-year CPG projections financial model shifted from being built on a false premise to being built on reality. They stopped chasing a phantom trend and started planning for what was actually happening: winding down one format deliberately, scaling another, knowing exactly why the numbers moved month to month.

What Your Model Should Be Catching

If you're running ecommerce SKU analysis accounting and building CPG financial projections, your modeler should be asking:

  • What does the sell-through rate tell us about each SKU's real trajectory?
  • Are we assuming trends continue, or do we have reasons to believe they shift?
  • What would we see in the data if discontinuation, channel shifts, or competitive moves happened?
  • Are we seeing that? Why or why not?

A model that answers these questions is working. A model that just projects forward is guesswork with better formatting.

The Difference Between Data and Insight

Numbers don't tell you what's true. They tell you what to ask about. This CPG brand had all the data they needed. They just needed someone to organize it so the question became obvious: Why is this happening?

The answer was simple once they asked. But if they'd skipped that conversation, their entire 5-year plan would have been built on the ghost of a product line they'd already discontinued.

That's what separates a financial model from a spreadsheet. Numbers with built-in questions. Data that triggers the conversation with founders who know what's really going on.

If you're a CPG or ecommerce founder building projections, this matters deeply. The modelers who catch these trends before they break your forecast aren't smarter at math. They're better at asking the right questions. They know the difference between a number that looks like a trend and a number that tells you something's actually changed. They understand that a declining SKU can mean ten different things, and they know to ask which one it is before they build your entire 5-year strategy around the wrong answer.

Ever Ledger specializes in financial modeling for CPG and ecommerce founders who want models that ask the right questions. Ashley and her team catch the SKU trends that could otherwise derail your projections—and they do it by talking to you.

Continue exploring

Related Sam's List pages