HomeFinancial Modeling › E-Commerce Financial Model

E-Commerce Financial Model: Complete Guide to Building One

An e-commerce financial model projects the revenue, costs, and profitability of an online retail business. It starts with traffic and conversion metrics, builds through gross merchandise value (GMV) and take rates, and flows into a full P&L that captures the unique cost structure of digital commerce — fulfillment, shipping, returns, and customer acquisition.

What Makes E-Commerce Models Unique

E-commerce models differ from traditional retail and SaaS models in a few critical ways. Revenue is transactional, not recurring — you have to win each sale. The cost structure is dominated by COGS (product cost), fulfillment, and shipping, not software hosting. And unit economics depend on repeat purchase rates more than contractual retention.

The top of the funnel is a traffic-and-conversion engine. Your revenue forecast starts with sessions, conversion rate, and average order value — not simply a growth rate applied to last year’s revenue.

Core Components

ComponentWhat It CoversKey Metrics
Traffic & ConversionSessions by channel, conversion rate, AOVSessions, CVR, AOV, GMV
Revenue BuildGMV, take rate (for marketplaces), net revenue, returnsNet Revenue, Return Rate, GMV
COGS & Gross ProfitProduct cost, inbound freight, packagingGross Margin, COGS %
Fulfillment & ShippingPick/pack, outbound shipping, last-mile deliveryFulfillment cost per order, Shipping % of revenue
Customer AcquisitionPaid media, organic, referral, CAC by channelCAC, ROAS, Blended CAC
Unit EconomicsContribution margin per order, LTV, paybackCM per order, LTV/CAC, Payback Period
Operating ExpensesTechnology, G&A, people costsOperating Margin, OpEx ratio

Step-by-Step: Building the Model

Step 1 — Traffic and Conversion Funnel

Start with monthly sessions by channel: organic search, paid search, social media, email, and direct. Apply a conversion rate to each channel (industry average: 2–3% for e-commerce). Multiply by average order value to get GMV. This bottom-up approach is far more defensible than simply projecting top-line growth.

Step 2 — Revenue Bridge

GMV is not revenue. Subtract returns (typically 15–30% for apparel, 5–10% for electronics), marketplace commissions (if applicable), and promotional discounts to arrive at net revenue. For marketplace models, apply a take rate (10–20%) to get platform revenue.

Step 3 — Cost of Goods Sold

COGS for e-commerce includes the landed cost of product (manufacturing + inbound freight + duties), packaging materials, and any product-level costs. Target gross margins vary by category: 50–70% for DTC brands, 30–40% for electronics, 60–80% for digital products.

Step 4 — Fulfillment Economics

This is where e-commerce models get granular. Model pick-and-pack costs per order, outbound shipping (varies by weight, zone, and carrier), and returns processing. Fulfillment typically runs $4–8 per order for a mid-size DTC brand. This cost line often determines whether the business model is viable at scale.

Step 5 — Customer Acquisition

Build your marketing spend by channel. Calculate CAC for each channel (spend ÷ new customers acquired). Then compute blended CAC across all channels. Compare against contribution margin per order to determine first-order profitability, and against LTV for long-term viability.

Step 6 — Contribution Margin & Unit Economics

Contribution margin per order = AOV − COGS − fulfillment − shipping − payment processing fees. This is the unit-level profit before marketing and overhead. If this number is negative, no amount of growth will fix the business.

Gross Merchandise Value GMV = Sessions × Conversion Rate × Average Order Value
Contribution Margin per Order CM = AOV − COGS − Fulfillment − Shipping − Payment Processing
Customer Lifetime Value LTV = AOV × Purchase Frequency × Avg. Customer Lifespan × Gross Margin

E-Commerce Benchmarks

MetricTypical RangeBest-in-Class
Conversion Rate1.5–3.0%4–5%+
Gross Margin40–60%65–75%
Return Rate10–20%5–8%
CAC (DTC)$30–80Under $25
LTV/CAC2–3x4x+
Fulfillment % of Revenue10–15%Under 8%
Contribution Margin15–25%30%+
Analyst Tip
The most common mistake in e-commerce models is ignoring return rates. A 25% return rate on a $100 AOV means your effective revenue per order is $75 — but you still paid shipping both ways and processing time. Always model returns as a direct hit to both revenue and costs.

Key Takeaways

  • E-commerce revenue starts with traffic × conversion × AOV — not a simple growth rate assumption.
  • GMV is not revenue. Subtract returns, discounts, and commissions to get net revenue.
  • Contribution margin per order is the single most important unit economics metric — it must be positive.
  • Fulfillment and shipping costs are the hidden margin killers in e-commerce — model them per order.
  • LTV/CAC above 3x and first-order contribution profitability are signs of a sustainable business model.

Frequently Asked Questions

What is the difference between GMV and revenue in e-commerce?

GMV (Gross Merchandise Value) is the total value of goods sold before deductions. Revenue is what you actually keep after subtracting returns, discounts, and marketplace commissions. For a DTC brand, net revenue might be 75–90% of GMV depending on return rates. For a marketplace, revenue is the take rate times GMV.

How do I forecast traffic for an e-commerce model?

Break traffic into channels: organic search (grows with SEO investment and content), paid search and social (scales with ad spend), email (grows with list size), and direct/referral. Model each channel’s growth drivers separately. Paid channels should tie to a CAC or ROAS target rather than an arbitrary growth rate.

What conversion rate should I assume?

Average e-commerce conversion rates range from 1.5–3.0%. Mobile converts lower (1–2%) than desktop (3–5%). Category matters too — necessities convert higher than luxury. Use your own data if available; otherwise, start with 2% and build scenarios around it using sensitivity analysis.

How do I model customer acquisition costs?

Calculate CAC per channel: total channel spend ÷ new customers from that channel. Then compute a blended CAC across all channels. Be careful to distinguish between new and returning customer orders — a repeat purchase shouldn’t be counted as a new acquisition. Blended CAC should fall over time as organic channels grow.

How does an e-commerce model differ from a SaaS model?

SaaS revenue is contractual and recurring; e-commerce revenue is transactional. SaaS measures retention through churn rates; e-commerce measures it through repeat purchase rates. SaaS gross margins are 70–85%; e-commerce is 40–65%. Both track CAC and LTV, but the mechanics of revenue recognition and cost structure are fundamentally different.