Ecommerce Financial Model Template

Start with the Assumptions sheet. Fill in your current monthly order volume by channel, average order value, and gross margin for each product category. If you're not sure about gross margin, use total COGS divided by net revenue from your last income statement — that number is your baseline. Enter your return rate (most ecommerce businesses run 10–30% depending on category), your shipping cost per order, and your platform fee percentages. Don't need every number perfect on day one — use your best estimates and refine them as you go.

Once assumptions are in, review the Revenue Model sheet to confirm the channel mix and growth trajectory look right. Then move to the Unit Economics sheet and check your contribution margin per order by channel. If a channel shows negative or near-zero contribution margin, that's a signal — either your CAC is too high for that channel or the fees are eating the margin. The Marketing Budget sheet is where you'll allocate spend across paid search, paid social, and other channels and see ROAS by channel. Spend time here if paid marketing is a meaningful part of your cost structure.

Use the Inventory & COGS sheet to understand how much cash your inventory buildup will require, especially heading into Q4. Ecommerce businesses frequently run low on cash not because the business isn't profitable, but because inventory purchases hit the bank account 60–90 days before the corresponding sales. The Cash Flow sheet shows this timing gap clearly — look at the months where operating cash flow goes negative even as revenue is growing, and use those months to plan when to draw on a credit line or negotiate extended payment terms with suppliers. Update actuals monthly and use the model to recalibrate your next quarter's projections.

Ecommerce P&Ls are famously misleading if you look at gross margin alone. An online store might show 45% gross margin after COGS, but by the time you subtract shipping, payment processing (typically 2.9% + $0.30 per transaction), marketplace fees (Amazon charges 8–15% of revenue depending on category), and the cost of processing returns, contribution margin often falls to 15–25% — and that's before you've spent a dollar on customer acquisition. A financial model that calculates contribution margin per order by channel shows you the real profitability of each sales channel and whether your blended CAC makes sense against that margin.

The other number that surprises most ecommerce founders is how much cash inventory consumes as you scale. If you're doing $50K/month in revenue at 40% gross margin and growing 20% month over month, you need to be buying inventory well before that revenue hits — and your supplier probably requires payment net 30 or net 60, with lead times of 4–12 weeks depending on whether you're sourcing domestically or overseas. A business generating solid operating income on paper can still run out of cash because inventory investment scales faster than receivables. The Inventory & COGS sheet models this timing gap explicitly so you can see cash needs 90 days ahead instead of discovering the shortfall the week you need to place an order.

Customer acquisition cost and LTV:CAC ratio are the metrics that determine whether an ecommerce brand is building a real business or running a very expensive experiment in paid advertising. The benchmark most investors and operators use is LTV:CAC above 3x, with a CAC payback period under 12 months for DTC brands selling non-subscription products. But these numbers only mean something if you calculate them per channel — blended CAC across all channels hides the fact that Meta might be delivering customers at $18 CAC while Google Shopping customers cost $65 and buy half as often. This model separates CAC by channel so you can see which acquisition sources are worth scaling and which ones are consuming budget without proportional return.