Weekly Challenge: Build a 13-Week Cash Forecast

Revenue is an opinion. Cash is a fact. This week's challenge is the one exercise that turns your bank balance from a surprise into a decision-making tool: a 13-week cash forecast.

Why 13 Weeks?

A quarter is long enough to reveal patterns, and short enough to stay accurate. Lenders and investors recognize the 13-week cash forecast as a standard discipline signal, and for good reason: it forces you to match the cash you expect to receive with the cash you are actually committed to spending, week by week, using real dates instead of monthly averages.

What Goes Into Each Week

Build your forecast in a simple spreadsheet, with one column per week and five rows of detail:

1. Starting Cash Balance

Your actual bank balance on day one. Use the real number, not the number you wish were true. If you run multiple accounts, consolidate them so you have one source of truth.

2. Cash Expected In, By Source and Date

List every inflow you can reasonably expect: customer payments, committed contracts, draws on existing credit lines. The key discipline is the date. An invoice you expect to be paid in week 2 does nothing for you if it actually lands in week 6.

3. Committed Costs

Payroll, rent, debt payments, insurance, and any other fixed obligations with a real due date. These are the non-negotiables, so they go first.

4. Flexible Spending

Everything you could delay if the forecast turns negative: marketing campaigns, equipment purchases, discretionary hiring. Mark these clearly, because this is your adjustment lever.

5. Ending Cash Balance

Starting balance, plus expected inflows, minus committed and flexible costs. That ending number rolls forward and becomes next week's starting balance.

The Real Discipline: Compare and Update

The first version of your forecast will be wrong. Everyone's is. The point of the exercise is not perfect prediction. It is the weekly review: compare what you forecast with what actually happened, understand where your assumptions missed, and update the remaining 13 weeks accordingly.

After a month of this, you will know two things most business owners never learn: how long your assumptions hold, and how early your cash squeezes announce themselves. That early warning is the entire payoff. A cash gap you see six weeks out is a scheduling conversation with vendors, a collections push, or a credit conversation with your bank. A cash gap you discover on the day payroll is due is a crisis.

A 20-Minute Start

You do not need a polished model to begin. Open a spreadsheet, label the next 13 weeks across the top, and fill in what you know: your current balance, the payments you are owed, and the bills you know are coming. Estimate where you are unsure, and mark those cells so you remember they are assumptions.

Then pick the single hardest assumption in your draft. For most owners it is one of two things: when customers will actually pay, or how much flexible spending is truly deferrable. That assumption is where your forecast is most likely to mislead you, so it deserves the most scrutiny in your weekly reviews.

What This Signals to Lenders and Investors

When you sit down for a capital conversation, a maintained 13-week cash forecast is evidence that you run your business on facts rather than hope. It shows you can articulate your cash cycle, you know your committed obligations, and you have a plan for the lean weeks. That is precisely the operating discipline that funding decisions reward.

Start your draft today. Which assumption is hardest for you to estimate? That question is worth answering before you need the answer.

AI-generated content, corroborated across trusted sources.