How to Build a 13-Week Cash Flow Forecast (Template + Real Benchmarks)

Most founders I talk to can tell me their revenue to the dollar and have no idea what their bank balance will be in six weeks. A lot of them describe their entire cash process the same way: wake up, check the bank account, see money, keep going. That works right up until the morning it does not. You can be profitable on paper, growing 40 percent, and still miss payroll because an inventory balance, an ad bill, and a quarterly tax payment all landed in the same week your Shopify payout ran light.

The fix is a 13-week cash flow forecast: a direct, week-by-week map of every dollar moving in and out of your accounts for the next quarter. It is the same tool corporate turnaround teams and restructuring lenders lean on, and for a DTC brand the reason you need one is now provable with hard numbers. This is a build-along: by the end you will know which rows go in the spreadsheet, how to roll it each Monday, and how to read it so the trough shows up weeks before it hits your bank.

Why profitable DTC brands still run out of cash

Start with the uncomfortable data. The JPMorgan Chase Institute studied the daily cash flows of 597,000 small businesses and found the median one holds just 27 days of cash buffer. A quarter of them hold fewer than 13 days. That is the structural reason a profitable brand can hit a wall: most businesses have under a month of margin for a bad week, and they are running blind into it.

Now layer on the DTC-specific problem. Your accrual profit-and-loss statement books revenue when the sale happens and expenses when they are incurred. Useful for measuring profit, useless for timing cash. The gap between the two is the cash conversion cycle, and for a scaled DTC brand it averages around 130 days between paying a supplier and collecting the matching cash from customers. Profit shows up on the P&L the day you sell. The cash that profit represents is scattered across the months before and after, locked in inventory and ad spend you already paid for.

You have probably seen the stat that 82 percent of small businesses fail because of cash flow. It comes from a widely cited U.S. Bank figure, and it is worth keeping honest: it is a contributing-factor number, not "82 percent fail only from cash flow." The cleaner takeaway is the JPMorgan one. When the median brand has 27 days of runway and a 130-day cash cycle, surfacing a problem eight weeks out is the difference between a calm decision and an emergency.

When I talk to founders running a brand this size, the pattern is almost always the same: the business is healthy, the founder is paying attention, and yet the crunches still arrive by surprise. Glancing at the balance each morning reliably produces unexpected crunches. Structured weekly visibility is what stops them.

Direct forecast, not the cash flow statement

A 13-week forecast is a direct cash model. You list expected receipts and payments by the week the cash actually lands, in or out of the bank. That is different from your accrual P&L and different again from a cash flow statement, which is a backward-looking report of what already happened. The statement tells you where cash went. The forecast tells you where it is going and when you will be short.

The 13 weeks is deliberate: one fiscal quarter plus a buffer week, long enough to capture a full cash cycle, short enough that you can still forecast each line by hand. It is no accident that this is the exact horizon used outside ecommerce. Restructuring advisers call the 13-week model the star of the show in a turnaround, and lenders providing debtor-in-possession financing require 13-week variance reporting as a condition of the loan. It earned its reputation in the highest-stakes cash situations there are, and it sits alongside, not instead of, your 12-month plan. The whole point is timing: the forecast is where a 130-day cash lag becomes a specific number on a specific week, early enough to do something about it.

Build the template: receipts and outflows by when cash moves

One spreadsheet, 13 weekly columns. Down the left, five line-item groups plus a summary block. Here is the structure and, more importantly, the timing rule for each.

The single most common mistake on the receipts side is entering sales instead of cash. Map each channel to its real payout timing. Shopify pays US merchants in 2 to 5 business days, with a 3-day minimum settlement, so last week's sales are roughly this week's cash. (The often-quoted "2 to 3 days" is too optimistic; Shopify's own US docs say 2 to 5, and new or higher-risk merchants start slower and can face rolling reserves.) Amazon runs about a 14-day settlement cycle and holds a reserve back. Wholesale is the trap: a founder I worked with simply could not get a key account to move from 60-day terms down to 45 or 30, no matter the conversation. Stated terms are a wish. Model wholesale on your actual AR aging, which is when customers really pay.

One adjustment that bites at scale: during peak season, processors hold reserves on the volume spike. A 10 percent reserve on $500K of Black Friday sales is $50K you will not see for 90 to 120 days. That is a real reason your biggest sales day can become a cash flow nightmare. Put the reserve in the model or your December forecast will lie to you.

On the outflows, order the lines by how badly they hurt if you miss them. Payroll is first and non-negotiable; it is the line you protect. When a brand is genuinely tight, the move operators describe is holding all accounts payable for a week to squeeze payroll through, which only works if the forecast told them the squeeze was coming. Inventory POs are second and, crucially, the movable ones in a crunch, which is exactly why you map every deposit and balance to the precise week it drafts. Ad spend is third: a trailing 4-week average with planned scale-ups layered on. Taxes are fourth, easy to forget and devastating to collide with a big inventory buy. Fixed costs are last and predictable.

The trough is hiding in your inventory days

Here is the part the conceptual guides skip. For a pure DTC brand, you collect from customers in days, so days sales outstanding is tiny: your accounts receivable is basically the weekend's orders waiting to settle. That means the cash conversion cycle is almost entirely inventory days minus how long your suppliers let you wait to pay. The trough is born in the inventory line.

And the inventory line is bigger than most founders think. Pulling the most recent 10-K filings and computing days inventory outstanding (inventory divided by cost of goods, times 365), scaled DTC brands are carrying staggering amounts: FIGS sat on 221 days in FY2025, YETI 133, Lululemon 117. Only the made-to-order outlier, Warby Parker, ran lean at 41 days. Put those against the 91 days a 13-week forecast actually covers and the problem is obvious.

When your inventory days exceed your forecast window, the cash is locked up longer than you can see, and the trough stops being a one-off collision. It becomes structural. This is the single thing I look for first. When I open a brand's 13-week and the first number that jumps out is 250 days of inventory, the trough is not a forecasting problem, it is a balance-sheet one. We usually push toward 3 to 4 months at the outside, because reducing inventory days is the fastest way to free up liquidity that is already yours.

The table below puts the inventory benchmarks next to the supplier-terms side of the cycle and the cash-buffer reality, so you can see where your own brand sits.

There is a related trap worth naming, because it pushes inventory days in the wrong direction. Ocean freight is cheap in 2026, with Shanghai-to-LA spot rates running a fraction of the roughly $10,000 per container peak of 2021. That tempts founders to over-order to "average down" freight per unit. But when freight is cheap, the binding constraint flips to inventory carrying cost, which runs 15 to 25 percent of inventory value per year. Buying ahead to save on shipping can quietly destroy cash. One operator solved the discipline problem by negotiating an order cap with suppliers, an explicit "I can order up to this much" ceiling, to keep the lumpy inventory line from blowing out.

Read the ending-balance line and find the trough

Now the model earns its keep. For each week, net cash flow is receipts minus outflows, and ending balance is the prior week's ending plus this week's net. String those ending balances across all 13 weeks and you get a curve. The lowest point is your cash trough.

In this illustrative $20M brand, cash starts at $420K and looks healthy. But a big inventory PO balance lands in Weeks 5 and 6, right on top of payroll, and the ending balance falls to $165K in Week 6, below the $250K minimum threshold. The brand is profitable that entire time. The P&L shows nothing. Only the cash curve shows the hole, and because you built 13 weeks of it, you saw Week 6 coming back in Week 1 or 2, while you still had every option open.

Set your minimum cash threshold at 20 to 30 percent of monthly burn and draw it as a line across the chart. Any week the ending balance dips below it gets flagged. As our cash conversion cycle guide covers, a well-built 13-week model gives you 8 to 10 weeks of forward visibility, which is the whole game.

Roll it weekly, and act when you spot a trough

A 13-week forecast is a habit, not a document. Every Monday: drop Week 1 and replace the forecast with actuals, shift Weeks 2 through 13 forward, add a fresh Week 13 at the back, then compare last week's forecast to what happened and write one or two lines of variance commentary.

That variance note is where the value compounds. On one review we had forecast a brand ending the week at $385K and it came in at $135K. A $250K miss is not noise; it is a model that needs recalibrating, and the only way you catch it is by writing down what you expected and comparing. If you consistently overestimate collections, your model is optimistic. If inventory always costs more than projected, you have a planning problem, not a forecasting one. Brands that update weekly and discuss it in leadership build forecasts that get smarter over time. The ones that build it once and let it drift get blindsided.

Seeing the trough early only matters if you act, ideally 2 to 3 weeks out:

1. Move the movable. Delay or split an inventory PO balance so it stops colliding with payroll.
2. Pull receipts forward. Offer a wholesale customer a small early-payment discount, or work down the lag on a slow channel.
3. Trim the controllable. Pull back ad spend for the trough weeks specifically, not permanently.
4. Pre-arrange the line. Draw on a pre-authorized facility on purpose, sized to the gap. With prime at 6.75% (May 2026), a typical DTC line costs roughly 8 to 10% on the draw. The mistake we see is waiting until it is an emergency, because that is when founders get desperate and reach for short-term cash advances that cost multiples of a line. If the gap is large enough that a line will not cover it, work through whether bridge debt or equity fits the gap before you sign anything.
5. Reserve for taxes ahead. If a quarterly payment is what tips you under, set the cash aside in the strong weeks before it.

If the trough keeps reappearing every cycle no matter what you do, that is not a forecasting issue, it is a structural one, usually too much inventory or a cash cycle that is too long. The fix lives in the cash conversion cycle levers, not a bigger overdraft. This forecast is one piece of the broader system in our guide to predictable, profitable growth. It pairs with the weekly cash flow KPIs you watch on the same Monday cadence, and with seasonal cash flow forecasting once a buying calendar, not a one-off collision, drives your trough.

Profit is an opinion about timing. Cash is a fact about a Tuesday. A 13-week forecast is just the discipline of turning the opinion into the fact, one week at a time, far enough ahead that you still have choices.

Sources and methodology

The cash-buffer benchmark comes from the JPMorgan Chase Institute report Cash is King: Flows, Balances, and Buffer Days (2016), which analyzed the daily cash flows of 597,000 small businesses and found a median buffer of 27 days, with 25 percent holding fewer than 13 days.

The inventory-days benchmarks are computed from public 10-K filings pulled via SEC EDGAR, using days inventory outstanding equal to period-end inventory divided by annual cost of goods sold, times 365. FIGS (CIK 1846576) came to 221 days for FY2025, YETI (CIK 1670592) to 133 days, and Warby Parker (CIK 1504776) to 41 days; Warby's figure reflects a made-to-order model and a COGS line that includes optical-lab and service costs, so its product-only inventory days run higher. Lululemon (117 days), Adidas (91-day payables), and Walmart (41-day payables) are secondary figures via Finbox.

The pooled-median DTC cash conversion cycle of roughly 130 days (versus a pre-COVID baseline near 80) is from an Eightx analysis of a 12-brand public DTC cohort, corroborated directionally by the 10-K math above and by vendor benchmarks that classify 60 to 120 days as typical and over 120 as a working-capital flag.

The bank prime rate of 6.75 percent (May 2026) is the Federal Reserve H.15 series via FRED (MPRIME); it has eased from an 8.50 percent peak at the end of 2023. Channel payout timing is from the Shopify Help Center (US settlement of 2 to 5 business days, with a 3-day minimum) and Amazon Seller Central (roughly a 14-day settlement cycle plus a held reserve). The 13-week cash balance curve is an illustrative model for a $20M DTC brand, built to show the shape of a trough rather than any single company; your exact trough week depends on your PO schedule, channel mix, and net terms.

Frequently Asked Questions