# Ecommerce Forecast An 18-month ecommerce forecast that drives orders from sessions, seasonality, and conversion, lands net revenue through a returns waterfall, and strips five variable cost lines plus marketing share to land on contribution margin per month - with semester rollups and headline KPIs on the Summary sheet. - Canonical: https://finamodel.com/templates/ecommerce-forecast - Excel download: https://finamodel.com/templates/ecommerce-forecast.xlsx - Category: Consumer - Model type: Operating model - Difficulty: Beginner - Audiences: Founders & operators, CFOs & FP&A, E-commerce founders, Growth marketers, Operators - Tags: ecommerce, forecast, conversion, aov, contribution margin ## Overview 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's included - 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 - 18-month Funnel sheet: sessions, Q4 seasonality lift, conversion, orders, AOV, gross-to-net revenue with returns - Contribution sheet with five variable cost lines (COGS, shipping, pick and pack, payment fees, return handling), marketing spend, blended CAC, and contribution margin $ and % - Headline KPIs: weighted AOV, contribution margin %, blended 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. ## Built for ecommerce trading and AOP When the conversation needs to anchor on the funnel - sessions, conversion, AOV - and not on top-down revenue, this is the structure. Every revenue line traces back to a unit-level driver an operator can argue about. ## Designed for contribution-margin discipline Five variable cost lines tied to either orders or gross revenue, then marketing as a share of gross revenue. Contribution margin in $ and as % of net revenue surfaces on its own row each month. ## Audit-friendly mechanics Every input is a named range, every formula is one or two operations, and the workbook passes static-value, self-reference, dead-assumption, and unused-named-range scans. ## Built for ecommerce trading and AOP When the conversation needs to anchor on the funnel - sessions, conversion, AOV - and not on top-down revenue, this is the structure. Every revenue line traces back to a unit-level driver an operator can argue about. ## Designed for contribution-margin discipline Five variable cost lines tied to either orders or gross revenue, then marketing as a share of gross revenue. Contribution margin in $ and as % of net revenue surfaces on its own row each month. ## Audit-friendly mechanics Every input is a named range, every formula is one or two operations, and the workbook passes static-value, self-reference, dead-assumption, and unused-named-range scans. ## Workbook structure ### Cover Workbook overview, sheet legend, and tab-colour key for navigation. - Title and scope framing - Sheet-by-sheet purpose summary - Tab-colour legend ### Assumptions Every driver in one sheet: traffic, conversion and AOV, variable unit costs, marketing. - Base monthly sessions, session growth, Q4 lift - Conversion rate, AOV, AOV growth, return rate - Product COGS %, payment fee %, shipping per order, pick and pack per order, return handling cost - Marketing share of gross revenue and repeat-order share ### Funnel Traffic through to net revenue, per month. - Base sessions compounded at session growth - Seasonality factor lifts Q4 months by Q4_Lift - Conversion rate produces orders - AOV compounded at AOV growth lands gross revenue - Returns and return value strip the funnel to net orders and net revenue ### Contribution Variable costs and marketing, per month, landing on contribution margin. - Gross revenue and return value pulled from the Funnel sheet - Five variable cost lines: COGS, shipping, pick and pack, payment fees, return handling - Variable contribution and variable margin % per period - Marketing spend at a share of gross revenue, new orders, blended CAC per new order - Contribution margin $ and contribution margin %, marketing ROAS ### Summary Semester rollups and headline KPIs. - Months 1-6, 7-12, 13-18 columns plus a full-forecast total - Sessions, orders, weighted AOV - Gross revenue, net revenue, variable contribution, marketing spend, contribution margin - Contribution margin % and marketing ROAS per semester - Net-revenue reconciliation check (Net = Gross − Returns) ### Cover Workbook overview, sheet legend, and tab-colour key for navigation. - Title and scope framing - Sheet-by-sheet purpose summary - Tab-colour legend ### Assumptions Every driver in one sheet: traffic, conversion and AOV, variable unit costs, marketing. - Base monthly sessions, session growth, Q4 lift - Conversion rate, AOV, AOV growth, return rate - Product COGS %, payment fee %, shipping per order, pick and pack per order, return handling cost - Marketing share of gross revenue and repeat-order share ### Funnel Traffic through to net revenue, per month. - Base sessions compounded at session growth - Seasonality factor lifts Q4 months by Q4_Lift - Conversion rate produces orders - AOV compounded at AOV growth lands gross revenue - Returns and return value strip the funnel to net orders and net revenue ### Contribution Variable costs and marketing, per month, landing on contribution margin. - Gross revenue and return value pulled from the Funnel sheet - Five variable cost lines: COGS, shipping, pick and pack, payment fees, return handling - Variable contribution and variable margin % per period - Marketing spend at a share of gross revenue, new orders, blended CAC per new order - Contribution margin $ and contribution margin %, marketing ROAS ### Summary Semester rollups and headline KPIs. - Months 1-6, 7-12, 13-18 columns plus a full-forecast total - Sessions, orders, weighted AOV - Gross revenue, net revenue, variable contribution, marketing spend, contribution margin - Contribution margin % and marketing ROAS per semester - Net-revenue reconciliation check (Net = Gross − Returns) ## Features - **Funnel-driven, not top-down:** Revenue is built sessions → conversion → orders → AOV, so changes to a single driver propagate cleanly through gross and net revenue without manual stitching. - **Variable-cost contribution math:** Five variable cost lines tied to either orders or gross revenue land on a variable contribution that an ecommerce operator can defend in a board meeting. - **Audit-friendly mechanics:** Every input is a named range, every formula is one or two operations, and the workbook passes static-value, self-reference, dead-assumption, and unused-named-range scans. ## Use cases - **Annual operating plan:** Run the AOP for the next 18 months by editing traffic growth, conversion, AOV, and the marketing share; the contribution-margin trajectory drops out of the funnel. - **Channel-mix and pricing tests:** Flex AOV, return rate, or marketing % to test pricing changes or a paid-vs-organic mix shift and see contribution margin move period by period. - **Fundraising and board materials:** The Summary sheet's semester totals and contribution margin % give a one-page operating snapshot anchored in the unit-level funnel math. ## Frequently asked questions ### 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. ## Related templates - [E-Commerce Unit Economics](https://finamodel.com/templates/ecommerce-forecast-model) - [Cohort Retention](https://finamodel.com/templates/cohort-retention) - [Subscription Box Economics](https://finamodel.com/templates/subscription-box-model)