How an eCommerce Brand Built a 5-Year Financial Model

How a Multi-Channel eCommerce Brand Built a 5-Year Financial Model That Actually Held Up

Most founders wing their financial projections. They grab a SaaS template, plug in some benchmarks, call it a model, and hope nobody asks follow-up questions. Ever Ledger didn't. They built a 5-year financial model using actual sales data from Shopify, Amazon, and TikTok Shop—then stress-tested it against reality. The result: investor conversations where every assumption held.

The Problem: Benchmarks Are Expensive Lies

Industry benchmarks sound authoritative until you need to explain a 5% miss to an investor. CPG and eCommerce founders know this: your business doesn't operate at "industry average." It operates at your velocity, your channel mix, your customer acquisition cost. Every assumption that isn't backed by your data is a liability.

Ever Ledger started with a pile of transaction data across three channels. No consulting studies. No industry reports. Just actuals.

Case Study: The Build

Channel-Specific Actuals, Not Benchmarks

Ever Ledger pulled real numbers from each channel: Shopify direct sales, Amazon marketplace dynamics, TikTok Shop's emerging conversion patterns. For each channel, they calculated current sell-through velocity, percentage breakdown by SKU, and the timing of cash inflows. The goal was simple—turn revenue data into a model that matched their actual business.

But channels aren't created equal. Amazon takes a cut. TikTok Shop has different commission structures. Shopify direct has lower platform fees but higher customer acquisition costs. Each channel required its own line-item logic.

Big-Box Retail: Where Benchmarks Break

The bigger shock came when they modeled traditional retail. Costco, Target, other big-box retailers aren't just taking a markup. They're charging slotting fees upfront, taking promotional deductions off the top, and stretching payment terms to 60-90 days. A 5% miss on a $10M Costco contract isn't a rounding error—it's a cash crisis.

As Ashley from Undo Gummies put it: "We literally take the data from different sales channels. We can look at current sales velocity, percentage breakdown by SKU. Those are assumptions backed by hard data. Certain retailers will charge slotting fees or make deductions. 5% of your sales revenue is a huge number to be off by."

This is why eCommerce projections for investors require precision. One overlooked deduction structure can tank your entire forecast.

Three Scenarios: Base, Downside, Upside

Three-scenario modeling isn't optional when you're fundraising. Ever Ledger built base, downside, and upside cases—but not by guessing. Each scenario was stress-tested against their actual data. What happens if repeat customer rate drops 10%? What if the TikTok channel doubles? What if big-box retail scales slower than expected?

The model answered each question with line-item precision. No black boxes. No "we'll figure it out later."

The Outcome: Investor Conversations That Stick

Founders who show up with a detailed, data-backed financial model change the room. Instead of defending assumptions, Ever Ledger was answering questions. "What's your repeat rate on Amazon?" "Based on our actual repeat cohort data, it's X. Here's the trend line." "How are you modeling Costco slotting fees?" "We worked backward from Costco's standard contract terms and our historical cost structure."

Every assumption tied to evidence. No fluff. No consultant-speak.

The model became a living document, updated monthly as actuals came in. When the business performed differently than projected, they knew exactly where and why—and could recalibrate in real time. That's not luck. That's competence.

Building a CPG Financial Model for the Real World

A solid CPG financial model for fundraising starts with your data, not industry reports. Calculate your actual velocity per channel. Model retailer deductions with precision—slotting fees, promotional allowances, net-term timing. Stress-test against real scenarios. Then defend it line by line in the room.

Your financial model is your case. Make it bulletproof.

Ready to Build a Financial Model That Holds Up?

Ever Ledger helps founders build 5-year financial models backed by actual sales data, not assumptions. If you're preparing to fundraise and need a model that answers every investor question, connect with Ever Ledger's team. They'll take your channel data and build a projection model that actually survives scrutiny.