13-week cash flow model

Why a 13-week cash flow model exists (and when you actually need one)

The CEO sent the spreadsheet over on a TFriday afternoon. Thirteen columns, one for each week, rows for every cash inflow and outflow the business expected between now and Christmas. No commentary, just the model and a two-line note: "Board wants weekly visibility. Can you validate the assumptions?"

This was a Series A company, eighteen months post-raise, burning through a extension round faster than anyone had forecast. The weekly model wasn't theatre. It was the only document that could answer the question the board was actually asking, which wasn't "are you profitable?" but "will you run out of money before you fix this?"

That's what a 13-week cash flow model is built for. Not long-term planning, not investor storytelling, but short-term survival and the specific decisions that keep a business liquid when the margin for error has collapsed to nothing.

Most businesses never need one. The ones that do need it badly, and they need it to be right.

What the model actually is

A 13-week cash flow model is a rolling forecast of every cash movement in and out of the business over the next thirteen weeks, updated weekly. It doesn't track accruals or non-cash expenses. It tracks cash: when it arrives, when it leaves, and what the bank balance will be at the end of each week if every assumption in the model holds.

The structure is simple. Each column represents one week. The rows list every expected cash receipt (customer payments, financing proceeds, refunds, anything that increases the bank balance) and every expected cash disbursement (payroll, rent, supplier invoices, loan repayments, tax payments, anything that decreases it). At the bottom of each column, you calculate the net cash flow for that week and the cumulative cash balance.

The opening cash for week two is the closing cash from week one. The model rolls forward, week by week, until you reach week thirteen. If the closing cash figure in any week drops below zero, or below whatever minimum operating balance the business requires, you've found your problem. That's the week you run out of money, and everything in the model before that week is the window you have to fix it.

Why thirteen weeks, not twelve or sixteen

Thirteen weeks is a quarter, near enough. It's long enough to see a full cycle of most recurring payments (monthly payroll, quarterly tax filings, regular supplier terms) but short enough that your assumptions about customer payment behavior and operational timing don't decay into guesswork.

A monthly model hides the problem. If you're forecasting cash at the month level, you're averaging out the lumpiness that kills businesses. A large customer payment might hit on the third of the month, but payroll goes out on the fifteenth and rent on the first. A monthly model shows you solvent for the whole month. A weekly model shows you overdrawn for six days in the middle, which is the reality your bank cares about.

Thirteen weeks also matches the cadence of board reporting for most venture-backed companies and the reporting expectations of lenders in workout situations. It's not arbitrary. It's the horizon where cash planning stops being strategy and starts being execution.

When you actually need this

You need a 13-week cash flow model when the answer to "will we have enough cash?" is no longer obvious from your bank balance and your mental model of what's coming.

That threshold is different for every business, but the common situations are predictable:

Restructuring or distress. If the business is in or near insolvency, if there's a lender workout in progress, if you're negotiating payment terms with creditors, you need weekly cash visibility. This is the scenario where the model isn't optional. Lenders will ask for it. Insolvency practitioners will build one if you haven't. The model becomes the basis for every decision about which invoices get paid and which get delayed.

Rapid burn with a finite runway. Venture-backed companies that are pre-revenue or burning cash faster than they're growing into profitability need this once the runway drops below six months. A thirteen-week model doesn't replace your annual budget or your board-facing financial model. It sits underneath it, tracking whether the burn rate you forecasted three months ago is the burn rate you're actually experiencing this week.

Seasonal or lumpy cash cycles. If your cash receipts are heavily seasonal (retail businesses with Q4 concentration, project-based services with long payment terms, agriculture, construction), a monthly model will smooth out the variation and hide the weeks where you're actually in deficit. The 13-week model shows you where the peaks and troughs land and whether your payment obligations are clustered in a trough.

Major operational changes. If you're opening a new location, launching a new product line, making a large capital purchase, or taking on debt, the cash impact doesn't spread evenly across the month. It hits in specific weeks. The model lets you see whether the cash is there in the specific week you need it, not just the month.

If none of these apply, you probably don't need a weekly cash model. A monthly cash flow forecast, updated quarterly and tied to your budget, is enough. The 13-week model is a tool for situations where the margin for error is thin and the cost of running out of cash is existential.

How to build it (the mechanics)

Start with the bank balance. The opening cash figure in week one is whatever is in the bank account today, plus any uncleared deposits, minus any outstanding checks or scheduled payments you know will clear before the week closes. This is the only actual number in the model. Everything else is a forecast.

Then list every expected cash receipt for each of the next thirteen weeks. Customer payments are the hard part, because they depend on invoicing timing, payment terms, and customer behavior. If you invoice on net-30 terms, the cash doesn't arrive thirty days after you issue the invoice. It arrives thirty days after the customer receives and processes the invoice, which might be three days later, and some customers pay early, some pay on time, and some pay late.

The model has to reflect reality, not the contract terms. If your average collection period is 38 days, not 30, use 38. If a specific large customer always pays ten days late, model them ten days late. Optimism in a 13-week cash model is expensive.

For disbursements, list every payment obligation by the week it's due. Payroll is usually the largest and most predictable: same amount, same day, every pay period. Rent, loan repayments, insurance premiums, software subscriptions, these are all contractual and scheduled. Supplier invoices are less predictable, but if you have decent payables records, you can estimate them by looking at the average weekly payment volume over the last quarter and adjusting for any known large purchases.

Then calculate the net cash flow for each week and roll it forward:

The closing cash balance in week thirteen is your forecast cash position at the end of the quarter. If it's negative, or uncomfortably close to zero, you've identified the problem. Now you can work backwards through the model to see which assumptions, if changed, would prevent it.

What the model tells you that a P&L doesn't

A P&L tells you whether the business is profitable on an accrual basis. It matches revenue to the period it was earned and expenses to the period they were incurred, regardless of when the cash actually moved. That's useful for understanding unit economics and long-term sustainability, but it's not useful for answering the question "can I make payroll next week?"

A 13-week cash model answers that question. It ignores accruals entirely. Revenue doesn't appear in the model until the cash from that revenue hits the bank. An expense doesn't appear until the payment clears. Depreciation, amortization, stock-based compensation, none of it shows up, because none of it affects the cash balance.

The gap between the two views is where most cash crunches hide. A business can be profitable on a P&L and still run out of cash if the timing is wrong. You invoice a customer in January, recognize the revenue in January, but the cash doesn't arrive until March. Meanwhile, you paid your suppliers in February. The P&L says you're profitable. The cash flow model says you're overdrawn.

The 13-week model forces you to confront timing, which is the dimension most founders underestimate until it becomes a crisis.

The assumptions that matter most

The quality of a 13-week cash flow model depends entirely on the quality of the assumptions behind it. Three assumptions matter more than the rest:

Customer payment timing. If you get this wrong, every cash receipt in the model is wrong. The way to get it right is to pull your actual collection data for the last six months and calculate the weighted average days to payment by customer segment. Don't assume everyone pays on terms. Model what actually happens.

Discretionary spend. Some costs are fixed and contractual. Some are discretionary and can be delayed or cut if cash gets tight. The model should separate the two, because the scenario planning you'll do with this model depends on knowing which costs you can actually control in a short timeframe. Payroll is fixed (in the short term). A planned marketing spend is discretionary. Label them differently.

Minimum cash balance. The model isn't trying to get you to zero. It's trying to keep you above whatever minimum operating balance the business requires to function. For most businesses, that's at least one payroll cycle plus a buffer for unexpected payments. If your bi-weekly payroll is $50,000 and you want a $20,000 buffer, your minimum cash balance is $70,000. Any week where the model shows you dropping below that is a week where you need to act.

How to use it (the decision layer)

The model itself is just a spreadsheet. The value is in what you do with it.

Update it every week. At the end of each week, replace the forecast for that week with the actual cash movement, adjust the assumptions for the remaining weeks based on what you've learned, and add a new week at the end so you're always looking thirteen weeks forward. This isn't optional. A 13-week model that gets updated monthly is just a monthly model with extra columns.

Run scenarios. The base case model shows what happens if every assumption holds. The scenarios show what happens if they don't. What if your largest customer pays two weeks late? What if you delay a planned hire by a month? What if you draw down the remaining balance on your credit line? Each scenario is a version of the model with one or two assumptions changed. The scenarios tell you which levers you have and how much room each one buys you.

Identify the constraint week. This is the week where cash drops to the lowest point, or the first week where it drops below your minimum balance. Everything before that week is your window to act. If the constraint week is week eight, you have seven weeks to fix the problem. That might mean accelerating a customer payment, delaying a supplier payment, cutting a discretionary cost, or raising capital. The model doesn't make the decision for you, but it tells you exactly how much time you have to make it.

What it won't do

A 13-week cash flow model won't fix a business that's structurally unprofitable. It won't replace a budget or a long-term financial plan. It won't tell you whether your unit economics work or whether your pricing is sustainable.

It will tell you whether you're going to run out of cash in the next thirteen weeks, and if so, exactly when and by how much. That's the only question it's designed to answer, and for businesses where that question matters, it's the most important question there is.

If you're not in a cash-constrained situation, you don't need this. If you are, and you're not already maintaining a weekly cash model, you're operating without the one piece of visibility that could prevent the constraint from becoming a crisis.

A shorter version of this piece appears on LinkedIn: [LINKEDIN_POST_URL].

If you're building a 13-week cash flow model for the first time, or you've inherited one and need to validate the assumptions behind it, I work with founders and finance teams on exactly this kind of build: calendly.com/muhammed-adediran/30min.