Ecommerce Forecast
Consumer Financial Model (Free Excel Download)
Forecast ecommerce orders and contribution margin from sessions, seasonality, conversion, returns, variable costs, and marketing spend for sharper trading decisions.
professionals from Deloitte
Used by professionals from
About this model
An ecommerce forecast model translates a marketing funnel into a contribution-margin forecast over 18 months. Sessions grow off a monthly base with a compounded growth rate; a Q4 seasonality factor lifts October through December; conversion produces orders; AOV (also compounded) lands gross revenue; a returns rate strips revenue and orders to net. From net revenue, the model deducts five variable cost lines - product COGS as a share of gross revenue, shipping and pick-and-pack per order, payment fees as a share of gross revenue, and return-handling cost per returned unit - to land on a variable contribution. Marketing spend is a share of gross revenue; subtracting it from variable contribution gives the contribution margin in dollars and as a percentage of net revenue.
Every input lives on a single Assumptions sheet as a named range, so flexing a single driver - conversion, AOV growth, marketing share, return rate - propagates cleanly through the Funnel and Contribution sheets and rolls up into the Summary. The Summary breaks the 18-month forecast into three semesters (Months 1-6, 7-12, 13-18) with sessions, orders, weighted AOV, gross revenue, net revenue, variable contribution, marketing spend, contribution margin, contribution margin %, marketing ROAS, and a reconciliation check that confirms the gross-to-net waterfall holds.
Ecommerce founders, growth marketers, CFOs, and FP&A teams use this template for annual operating plans, channel-mix and pricing tests, and board materials when the conversation needs to anchor on funnel mechanics and contribution margin rather than top-down revenue. For cohort-level CAC payback and LTV work, use the parallel E-Commerce Unit Economics template; for fixed costs and EBITDA, layer on a 3-statement or runway template.
What every model includes
Live formulas, no hardcoded values
Outputs are driven by live formulas, so the workbook updates from its assumptions instead of relying on hardcoded results.
All assumptions in one tab
Inputs are clearly marked in the Assumptions tab and separated from calculations, making it clear what to change and what to leave intact.
Statements always balancing
For integrated-statement models, the balance sheet, cash flow, and supporting schedules tie through properly.
Distinct schedules for clarity
Debt, working capital, taxes, and cash flow can get messy quickly. We group calculations in clear schedules, not across disconnected tabs.
No hidden macros or external links
There are no unexplained external workbook links or macros to undermine auditability or portability.
Changes flow through the model
Update a key driver and see the impact carry through the forecast, financing, and return outputs. We never use hardcoded numbers in formulas.
What's inside the Ecommerce Forecast
- 18-month Funnel sheet: base sessions, Q4 seasonality factor, conversion, orders, AOV, gross-to-net revenue with returns
- Contribution sheet with five variable cost lines, marketing spend, blended CAC, and contribution margin $ and %
- Assumptions sheet with named ranges for every traffic, AOV, cost, and marketing driver
- Summary with three semester columns (Months 1-6, 7-12, 13-18) plus a full-forecast total
- Headline KPIs: weighted AOV, contribution margin %, marketing ROAS, and a net-revenue reconciliation check
- Q4 seasonality lift applied automatically to Oct, Nov, Dec sessions
Ecommerce Forecast: How the Model Works
This ecommerce forecast template builds a monthly P&L from sessions to contribution margin over 18 months. It shows how seasonality, conversion, and AOV create orders and net revenue, then subtracts variable costs and marketing.
Use it to trace unit economics, channel efficiency, and cohort value without treating it as a market prediction.
Core Drivers of Demand and Revenue
The forecast begins with sessions, which grow month to month unless overridden, and a twelve-cell seasonality vector applied by calendar month so peaks land in the right periods. Orders come from sessions multiplied by a steady conversion rate, preventing growth from compounding unnaturally.
- Average order value starts at an assumed figure and compounds at a monthly growth rate, with the ability to override any period. Gross revenue is orders times AOV.
- Promotional discounts reduce that gross figure only in designated promo months, and returns are priced at the post-promo per-order revenue, so net revenue reflects the cash a direct-to-consumer brand should expect to keep.
From Revenue to Contribution Margin
On the contribution sheet, net revenue from the funnel is the starting point. Six variable cost lines are then deducted: product COGS as a percentage of gross revenue, shipping cost per order, a negative shipping fee recovery line, fulfilment per order, payment fees as a percentage of gross revenue, and return handling cost applied only to returned orders.
- The result is variable contribution. Marketing spend, which is an independent input rather than an echo of gross revenue, is subtracted to arrive at contribution margin and contribution percentage.
- A marketing ROAS measure uses net revenue as the denominator, following DTC convention. Separate checks ensure every cost line aligns with order and revenue flows.
Channel Mix and Cohort Economics
Six channels, including paid search, influencer, and retention email, each receive a monthly share of a total marketing budget. Attributed orders are allocated by each channel's efficiency weight, and channel metrics such as ROAS and CAC emerge from those allocations.
- A separate cohort block tracks eighteen acquisition vintages over twelve months since acquisition, using a retention curve to estimate retained customers, returning revenue, and cohort contribution. This yields average customer lifetime and average LTV per customer.
- The cohort figures are analytical and do not feed the summary revenue split, which instead uses the funnel's repeat-share assumption to avoid double-counting.
Summary Rollups and Practical Use
The summary sheet rolls the eighteen months into five buckets, including the first year, the second half of year two, and the full forecast. It presents headline KPIs such as sessions, orders, net revenue, contribution margin, and ROAS alongside a unit-economics tier that shows LTV, paid CAC, the LTV-to-CAC ratio, and CAC payback months.
- New and returning revenue always sum exactly to net revenue. A five-level marketing pressure test illustrates how contribution margin percentage would change at marketing shares ranging from ten to thirty percent of gross revenue.
- The template supports evaluating demand assumptions, cost structure, and acquisition efficiency; it does not include fixed costs or a balance sheet.
Formatted to IB standards
Named theme colors repaint the whole workbook in one click, on top of an investment-banking structure with clear input, output, and cross-sheet reference styling - brand-ready, institutional-grade, and fully auditable.
Created by ex-finance professionals
Hey, I’m Alex and I created Finamodel.
Over my years in the finance industry I kept building the same models over and over again. Same structure, same assumptions, different logo. So I started building frameworks to turn them into clean, reusable templates.
Every model here is one I’d actually use for a client, and I personally vet each one before it goes up.
I’m not an expert in every industry, but I’ve built enough models to know what belongs in one. And when something is completely foreign to me, I reach out to my network for experts to work on our models with us.
Having a template library on hand cuts a first build from hours to minutes.
Need help finding your model? You’ll find me in the Finamodel app!
Frequently asked
What is an ecommerce forecast model?+
A forecast that drives revenue from a marketing funnel - sessions × conversion × AOV - and then strips variable unit costs and marketing share to land on contribution margin per period. It is the standard structure DTC operators use to plan trading and stress-test pricing or channel-mix changes.
How is this different from the E-Commerce Unit Economics template?+
The unit-economics template is a cohort-and-LTV business model - CAC payback, repeat rates, channel-level margin. This template is narrower and more operational: an 18-month period-by-period forecast that stops at contribution margin. Use this for the AOP and trading plan; use the unit-economics template for cohort-level CAC payback work.
How is the Q4 lift applied?+
A seasonality factor row on the Funnel sheet returns 1 + Q4_Lift when MONTH(date) is October, November, or December, and 1 otherwise. Sessions for the period are Base sessions × Seasonality factor, so conversion and AOV downstream pick up the lift automatically.
Why is ROAS constant in every period?+
Marketing spend is modelled as a share of gross revenue (Marketing_Pct), so Gross revenue / Marketing spend = 1 / Marketing_Pct - a constant. To model varying ROAS, switch Marketing spend to an explicit dollar input per period, or drive it from sessions × CPM.
Can I extend the forecast beyond 18 months?+
Yes - the builder is parameterised by NUM_PERIODS. Bump it and rerun, then add another semester column on the Summary sheet to cover the longer horizon.
Have more financial modelling questions? Contact us
Related templates
E-Commerce Unit Economics
P&L model for e-commerce business with CAC, LTV, gross margin, and unit economics.
Cohort Retention
12-cohort SaaS retention model with logo curve, NRR, and LTV per cohort.
Subscription Box Economics
Model recurring revenue, churn, customer acquisition, and fulfillment costs for a subscription service.
Restaurant Unit Economics and Multi-Unit Model
Single-unit operating metrics, cost of goods sold, labor, rent, and multi-unit chain economics.
