Ecommerce Pro Forma Template

Start with the Assumptions sheet. Enter your AOV, projected monthly order volume, channel mix, return rate, and unit-level cost structure — product cost as a percentage of revenue, fulfillment cost per order, and payment processing rate. If you're projecting a new store, use your product category's typical AOV as a benchmark and set order volume to a conservative year-one target based on your planned marketing spend and organic traction. The ramp schedule is critical for a new brand: most DTC stores run at 30–50% of their target monthly order volume in months one through three as ad accounts optimize and organic search builds. Set that ramp conservatively — investors know the pattern and will push back on projections that assume full-speed revenue from month one.

Once the Assumptions sheet is dialed in, review the Unit Economics sheet and verify that your contribution margin per order is positive across all channels before you add marketing spend. This is the ecommerce founder's gut-check: if product cost, fulfillment, payment fees, and returns together consume more than 70–75% of your selling price, you don't have enough contribution margin to fund customer acquisition at any meaningful scale. Then move to the Customer Acquisition sheet and enter your planned marketing spend by channel with realistic CAC estimates — use actual CPM and conversion rate data if you have it, or category benchmarks if you're starting from scratch. The LTV:CAC and payback period outputs will tell you quickly whether your acquisition model is fundable.

Use the 5-Year P&L and Cash Flow sheets when presenting to investors or lenders. Investors in consumer DTC brands focus on gross margin trajectory, CAC payback period, repeat purchase rate, and whether the model reaches EBITDA breakeven within a credible timeframe. The Cash Flow Projection is the sheet that often reveals whether a business plan is actually executable — if the model shows a peak working capital need of $400,000 in month seven due to pre-holiday inventory purchasing, that's a specific number you can plan around. Run the unit economics and cash flow analysis before any investor conversation and know your contribution margin percentage, LTV:CAC ratio, and peak cash need cold — those three numbers define the financial narrative of an early-stage ecommerce brand.

Ecommerce is one of the most capital-efficient businesses to start but one of the easiest to underestimate financially. A Shopify store can be live in 48 hours, but the economics of scaling it profitably are complex: gross margins of 30–55% sound healthy until you subtract fulfillment (often $5–12 per order), payment processing (2.5–3.5%), platform fees, and return costs, leaving contribution margins of 15–30% before any marketing spend. For a DTC brand spending $30 on CAC to acquire a customer with a $60 AOV and 25% contribution margin, the math breaks immediately — $15 of contribution margin minus $30 of CAC means the first purchase loses $15. The business only works if that customer buys again, and a pro forma forces you to make that math explicit before you've spent real money discovering it.

The financial metrics that define ecommerce health are gross margin (30–55% for most product categories; beauty and apparel run higher, electronics lower), contribution margin after fulfillment and fees (target above 20–25% to have room for profitable marketing spend), CAC payback period (under 12 months for most brands; under 6 months for consumer subscription), and LTV:CAC ratio (above 3:1 is the standard investor threshold). Amazon and marketplace revenue looks attractive for volume but often runs 15–25 points lower in net contribution margin than DTC revenue once you account for referral fees (8–15%), FBA fees ($3–8 per unit), advertising cost of sale (10–20% for competitive categories), and the absence of customer data ownership. A pro forma that models channels separately — not just blended revenue — surfaces this tradeoff before you've built a business dependent on a channel that doesn't support sustainable margins.

The inventory and cash flow cycle is where most early-stage ecommerce businesses run into trouble. Sourcing from overseas manufacturers requires purchase orders 12–16 weeks before goods are in-hand, which means Q4 holiday inventory must be committed in July or August — months before any holiday revenue. A brand doing $50,000 per month might need to purchase $150,000–$200,000 in inventory to cover the holiday peak, drawing down cash two to three months before those orders generate revenue. Add supplier deposits, freight costs, and the working capital needed to fund customer acquisition during a growth push, and the total funding requirement is often 2–3x what founders initially estimate. This template models that cycle month by month so you can see exactly when cash is needed, how deep the trough goes, and whether your capital plan covers it — rather than discovering the gap when your bank account hits zero in October.