How an eCommerce Brand Built a 5-Year Financial Model
Kimberly Green | 2026-03-06
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 vetted, 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...
