E-commerce Working Capital: The Inventory + Ad-Spend Math That Actually Predicts ROI

E-commerce is one of the most working-capital-leveraged business models in commercial finance. Inventory has to be paid for upfront, often with 60-day lead times. Ad spend is paid daily by the platform. Customer payment is instant — but the cash arrives only after the inventory and ad spend has been deployed.

This structural pattern means e-commerce operators run on inventory float and ad-spend float simultaneously, and the businesses that scale do it on top of working capital that fits the math. The ones that don't, stall at the revenue level their cash flow can self-fund.

Here is how to think about working capital for an e-commerce operation, and the specific math that determines whether a deal makes sense.

The cash conversion cycle, written down honestly

For a typical Shopify-and-paid-acquisition operation:

Step	Days
PO sent to supplier	Day 0
Deposit paid (typically 30%)	Day 0–7
Production lead time	Day 7–45
Final payment + shipping	Day 45–55
Inventory received and ready to sell	Day 55–60
Inventory sold (median sell-through)	Day 60–110
Cash from sales received	Day 60–112 (slightly delayed by processor settlement)

The cash-out events live in the first 55 days. The cash-in events start at day 60 and finish at day 110+. The financing requirement is the area under the curve between cash out and cash in — typically 3–4 months of inventory + ad spend.

For a growing brand, this float is real money — several weeks of inventory and ad spend tied up before the sales catch up. It has to come from somewhere: the operator's own cash, financing, or — most commonly — both.

The right math for an inventory-funded advance

Working capital deployed for inventory has a clean ROI test. Run it before signing.

Inputs:

• Net advance after origination fee
• Total repayment over the term
• Term (weeks)
• Inventory cost as % of unit retail (e.g., 25%)
• Expected sell-through time in weeks (use the trailing number, not the optimistic one)

The calculation:

1. Units of inventory the advance funds = net advance ÷ unit cost
2. Revenue if all units sell = units × unit retail
3. Gross margin generated = revenue × gross margin %
4. Net contribution after capital cost = gross margin − cost of the advance (total repayment − net advance)
5. ROI of the deal = net contribution ÷ net advance

Example: take a $20,000 advance and put all of it into inventory. After origination, about $18,500 goes to work.

Brand A — $40 unit cost, $130 retail, 12-week sell-through:

• Units funded: ~460
• Revenue if it all sells: ~$59,800
• Gross margin (69%): ~$41,000
• Even after the cost of the advance, that's a large multiple on the capital. This is the deal you take.

Brand B — $80 unit cost, $120 retail, 18-week sell-through:

• Units funded: ~230
• Revenue if it all sells: ~$27,600
• Gross margin (33%): ~$9,100
• After the cost of the advance, there's barely anything left. This is the deal you decline, or take much smaller.

Same advance, same term — wildly different outcome, because the gross margin per turn either has room to absorb the cost of capital or it doesn't.

The right math for an ad-spend-funded advance

Ad-spend funding is structurally similar but uses different inputs.

Inputs:

• Net advance
• Total repayment over the term
• Trailing 90-day MER (Marketing Efficiency Ratio = total revenue / total ad spend) or platform-level ROAS, depending on attribution model

The math, simplified:

1. Total ad spend the advance funds = net advance (assuming it's deployed entirely to acquisition)
2. Expected revenue from that ad spend = ad spend × MER
3. Gross margin from that revenue = expected revenue × gross margin %
4. Net contribution after capital cost = gross margin − capital cost
5. ROI = net contribution ÷ net advance

The honest variant: use trailing MER from the most recent 90 days, not the all-time number. Acquisition costs have inflated structurally across most platforms in the last 18 months. A brand with a trailing-12-month MER of 3.2 may have a trailing-90-day MER of 2.4, and the deal sizing should reflect the recent number.

Operators who pencil deals against optimistic historical MER numbers consistently end up with the wrong-sized advance for current performance.

The working-capital-vs-cash-flow timing question

E-commerce operators frequently ask: "I've got cash in the bank. Should I use it for inventory, or take an advance and keep the cash?"

The right answer depends on the next 90 days of expected cash needs. If that cash will be needed for operating expenses (payroll, rent, software, returns processing) over the next 90 days regardless, taking the advance preserves the operating cushion. If the cash is genuinely surplus and the inventory cycle is short, deploying it directly is cheaper than financing it.

For most growing operations, the financing answer is correct: cash is the buffer, inventory and ad spend are the deployable capital. Spending the buffer first means you have no cushion for the inevitable event — a return wave, a paused ad account, a supplier delay — that landed on every e-commerce operator at least twice in the last 24 months.

Renewal timing for e-commerce

Two natural renewal triggers:

1. At 40–50% paid down, with the trailing 90 days of revenue showing measurable growth attributable to the funded inventory or ad spend. This is the strong renewal — the desk can underwrite the next deal at the new revenue base.

2. Going into a known peak season (Q4 for most consumer brands, Q2–Q3 for outdoor or summer brands). Pre-positioning capital before the peak — taken at 50% paid down on the prior deal — is the cleanest pattern in DTC funding.

The wrong renewal pattern is taking a renewal because the existing weekly debit is becoming uncomfortable. That's a sizing problem, not a renewal opportunity, and adding more capital makes it worse.

What disqualifies an e-commerce file

Three patterns we won't fund or size aggressively against:

Heavy reliance on a single platform with no diversified revenue. A brand running 90%+ of revenue through one paid channel (typically Meta) carries unhedged platform risk. We can fund — but smaller, and with different terms.

No clear inventory turn data. If the operator can't tell us median weeks-to-sell-through, the deal is being underwritten against assumed cash flow rather than measured cash flow. This is rarely intentional dishonesty; it's almost always under-instrumentation. We'll size conservatively until the data exists.

Heavy returns volume (>15%). Returns delay cash receipt and consume gross margin. Brands above 15% returns require the math to be re-run with the returned units and reverse logistics costs included.

The shortest possible advice

Run the deal math before signing. Use trailing — not historical — input numbers. Size to the use of funds plus a 25% buffer. Don't deploy the operating cushion to inventory; finance the inventory and keep the cushion for the events that don't have a deal math attached.

Operators who do this scale through working capital at an accelerated rate without fragility. Operators who treat working capital as general operating funding consistently stall at a revenue level that the cash-flow math couldn't support.