Cash Flow Management
Why Businesses Create a 13-Week Cash Flow Forecast
There is no single reason — and the reason you build it changes everything about how it should look and what you do with it.
A 13-week cash flow forecast is not one fixed document. It is a tool. And like any tool, how you build it depends on what you need it for.
Two businesses can both produce a 13-week forecast and end up with completely different documents — different levels of detail, different assumptions, different outputs, different actions taken afterward. The reason is simple: they built it for different purposes.
Before you start building, the first question to answer is: what is this for?
Most business owners skip it. They build the forecast because a bank asked for one, or because they nearly ran out of cash. They put numbers in a spreadsheet, hand it over, and move on. But the purpose changes everything.
How purpose changes the forecast
Defining the purpose first forces a better question. Instead of asking how do I build this, you ask what do I actually need to know, and why. That leads to a forecast used actively, updated regularly, and connected to real decisions — not filed away after the bank meeting.
13-Week Cash Flow Scenario Simulator
| Week | Opening Cash | Receipts (+) | Payments (-) | Ending Cash | Status |
|---|
What every forecast includes
Regardless of purpose, every 13-week forecast has the same foundation. The sections below describe only what changes or is added for each specific purpose.
- Expected cash receipts week by week
- Expected cash payments week by week
- Opening cash balance each week
- Closing cash balance each week
- Reviews it regularly — weekly in most cases
- Compares actuals against forecast each week
- Updates assumptions when the situation changes
- Uses the closing balance trend to spot problems
1 Avoid running out of cash
A business can be profitable on paper and still run out of cash — when money goes out faster than it comes in, even temporarily. The forecast shows in advance whether receipts will cover payments each week. With 8 to 10 weeks of visibility, you have options: delay a purchase, chase a payment, draw on a credit line. With two days of visibility, you have none.
- What is our minimum cash balance to keep operating?
- Which payments cannot be delayed under any circumstances?
- When does cash actually arrive from customers?
- Are there large one-off payments in the next 13 weeks?
- Use conservative receipt timing — actual arrival, not invoice date
- Include every fixed obligation by exact week
- Mark weeks where balance falls below your minimum threshold
- Treat any week below the minimum as an immediate action item
- Decide what to do about the gap before it arrives
- Do not wait until the week arrives to react
2 Know your true cash position week by week
Your bank balance tells you what happened yesterday. A business might show €80,000 in the bank — but have €60,000 in supplier payments due this week, €30,000 in payroll next week, and only €20,000 in expected receipts. The real position is not €80,000. It is a problem. The forecast replaces the bank balance as your primary reference point.
- What payments are committed but not yet shown in the bank?
- Are there invoices outstanding that customers have not paid?
- Are there funds in the account already spoken for?
- Start from the bank balance, then subtract committed outflows
- Show net usable cash separately from the raw closing balance
- Highlight weeks where balance looks healthy but committed payments make it tight
- Stop using the bank balance as a decision-making tool
- Use the projected weekly closing balance for spending decisions
- Flag surplus weeks where idle cash could reduce borrowing costs
3 Identify problems early enough to act
A shortfall visible in week 10 is not a week-10 problem. It is a today problem — because today is when you still have time to act. Businesses that manage cash reactively discover problems too late. By then, options are limited and the cost of fixing it is higher.
- How much lead time do we need to arrange additional financing?
- What is the earliest we could take corrective action?
- Who needs to be informed when a problem is identified?
- Keep the full 13-week horizon — do not let it shrink to 4 or 6 weeks
- Run a simple downside version alongside the base case
- Mark trigger points where the balance requires a decision
- Review all 13 weeks every week, not just the nearest 2 or 3
- When a problem appears, set a decision deadline immediately
- Assign responsibility for corrective action straight away
4 Make better operational decision
Hiring means higher payroll next month. Buying equipment means a large outflow on a specific date. A new contract may require upfront costs before revenue arrives. Without a forecast, these decisions are made on gut feel or the P&L — which does not show timing. A business can look profitable and still not have the cash available when it is needed.
- What operational decisions are we likely to face in the next 13 weeks?
- When does the cash outflow for each actually occur?
- Which decisions can be delayed without material cost if cash is tight?
- Add planned but uncommitted expenditures as a separate line
- Model timing carefully — a hire today may not hit payroll for 4 weeks
- Include both cost and any related revenue impact
- Check the forecast before approving any significant expenditure
- If a decision creates a problem week, evaluate whether timing can shift
- Use it as the reference in management meetings on spending decisions
5 Plan around seasonal patterns
Many businesses have predictable slow periods — retail before a quiet season, construction in winter, tourism outside peak months. The problem is not the slow period itself. The problem is arriving at it unprepared. A rolling 13-week forecast gives you advance visibility so you can prepare before the dip arrives.
- When exactly does our cash position typically get tightest?
- How much cash do we need to carry through the slow period?
- When do we need to start accumulating reserves or arranging financing?
- Roll the forecast forward continuously to capture the full seasonal cycle
- Use historical data for slow-period timing — not averages
- Model the peak-to-trough movement explicitly
- Arrange credit facilities before the slow period — lenders prefer this
- Adjust discretionary spending ahead of the dip, not during it
- Set a cash accumulation target and track it weekly
6 Manage growth that outpaces cash
Growth is one of the most common causes of cash problems. As sales increase, businesses pay for more staff, inventory, and operating costs — often before revenue arrives. This is the cash conversion gap. The faster you grow, the bigger it becomes. The forecast makes this gap visible before it empties the bank account.
- How much additional cash does each stage of growth require, and when?
- What is the gap between spending for growth and collecting from new sales?
- Does our credit facility cover the working capital needed?
- Model growth-related outflows separately from normal operations
- Use conservative receipt timing — new customers often pay slowly
- Include growth-related capital expenditure by exact week
- Use it to determine financing needs before the gap appears
- Present to lenders or investors as evidence of how much is needed and when
- Update at least monthly as growth assumptions change
7 Test scenarios before they happen
No forecast is certain. Customers pay late. Sales disappoint. Costs rise unexpectedly. The value of a forecast is not just the base case — it is the ability to test what happens if things go wrong. Each scenario shows the cash impact in advance, so you can prepare a response before the problem arrives — not improvise one after.
- What two or three events would most damage our cash position?
- How quickly could each scenario develop?
- What response options do we have, and how much time to execute them?
- Build separate scenario versions — not notes, actual numbers
- Common scenarios: major customer 30 days late, 20% sales drop, supplier demands early payment
- For each, identify the week the cash position becomes critical
- Prepare a specific response plan for each scenario in advance
- Set trigger conditions — if X happens, we do Y by date Z
- Review scenarios quarterly or when the business environment changes
8 Support borrowing and financing requests
Lenders want to see cash flow, not profit. A well-prepared forecast shows exactly how much you need and when — making the request specific and credible. Arriving without a forecast, or with rough estimates, signals that management does not have control of the numbers.
- What does this specific lender or investor need to see?
- How much do we actually need, and for how long?
- Can we demonstrate clearly how the loan will be repaid?
- Use line-by-line detail — weekly totals are not enough for most lenders
- Show debt service payments explicitly in the numbers
- Include a conservative downside scenario alongside the base case
- Document all assumptions clearly — lenders may ask
- Present with a short summary explaining the key assumptions
- Be prepared to walk through every major line item
- Update promptly if the lender asks follow-up questions
9 Monitor covenant compliance
Many loan agreements include financial covenants — minimum cash balances, borrowing limits, or other conditions. Breaching one, even technically, can trigger serious consequences including loan acceleration or default. The forecast lets you project a potential breach before it happens. Discovering it after the fact leaves no options.
- What covenants apply to our loan agreements?
- What are the exact thresholds and measurement dates?
- How much headroom do we currently have — and is it shrinking?
- Add covenant metrics as explicit lines in the forecast
- Flag measurement dates so they are visible weeks in advance
- Model headroom under a downside scenario
- Review covenant headroom every week alongside the cash position
- If headroom is shrinking, start the conversation with your lender early
- Prepare a corrective action plan as soon as a potential breach appears
10 Navigate financial distress or a turnaround
In a distress situation, the 13-week forecast becomes the most important document in the room. Turnaround advisers, restructuring consultants, and creditor committees all use it to assess whether the business can survive. It is not a planning document. It is a survival tool — updated weekly, tracked against actuals, reviewed by all key stakeholders.
- Do we have enough cash to keep operating while a solution is found?
- Which payments are critical to survival and which can be deferred?
- Who needs to see this forecast, and how often?
- Use a direct method — actual cash in and out, no accruals
- Be extremely conservative on receipts — assume customers pay late
- Show cash after critical payments separately from total closing balance
- Include restructuring costs and adviser fees explicitly
- Update it every week without exception
- Explain all variances against forecast immediately
- Use it as the basis for every creditor conversation and payment decision
11 Improve working capital management
Working capital — cash tied up in receivables, inventory, and payables — is one of the largest sources of cash inefficiency in most businesses. When a large receivable does not appear in the expected week, it shows up immediately as a gap. That visibility drives action: chasing collections, negotiating payment terms, adjusting inventory purchasing.
- What is our average collection time from customers, and how does it vary?
- Are we paying suppliers earlier than our agreed terms require?
- How much cash is tied up in inventory at any given time?
- Model receipt timing on actual collection patterns, not due dates
- Track debtor days and creditor days alongside the cash numbers
- Test what happens if collection time improves by 7 or 14 days
- Use slow collection weeks as a trigger to chase specific invoices
- Identify suppliers you are paying early and adjust to agreed terms
- Quantify the cash impact of improvements so the business case is clear
12 Communicate with investors and stakeholders
Investors and board members want to know that management has control of the cash position. A forecast demonstrates this more convincingly than any verbal reassurance. It shows that risks have been identified and planned for — and gives stakeholders a concrete view of the next quarter, not a general assurance that things are fine.
- What does this audience need to understand about our cash position?
- Are there liquidity risks in the next quarter they should know about?
- Is there a formal reporting requirement, or do we decide ourselves?
- Prepare a summary version with key metrics highlighted
- Include a short commentary on outlook, risks, and management actions
- To demonstrate trends, show a comparison with the previous forecast
- Send on a fixed schedule — predictability is a sign of discipline
- Raise concerns proactively rather than waiting to be asked
- Use it as the basis for any funding or strategic discussion
13 Build a weekly management discipline
This is the purpose experienced CFOs value most — and the hardest to explain to someone who has not experienced it. A forecast updated every week forces a regular, structured review of the business. Sales expectations, collections, supplier payments, payroll, and financing needs are all reviewed on a fixed schedule. Nothing goes unnoticed for a quarter. Over time, the discipline improves forecasting accuracy and creates a shared understanding of cash across the whole management team.
- Who needs to be involved in producing the forecast each week?
- What information do we need from sales, operations, and finance?
- How do we hold the team accountable for the accuracy of their inputs?
- Design the format so it can be updated quickly — not a full day's work
- Include a variance column showing actuals vs. last week's forecast
- Keep the format consistent so trends are easy to spot week to week
- Hold a short weekly cash review meeting — 30 minutes is enough
- Review variances first, then the next 13 weeks
- Track forecasting accuracy over time—this discipline accumulates knowledge
The strongest case for a 13-week forecast usually comes down to one of four situations: liquidity stress or turnaround, rapid growth creating working capital pressure, need for external financing, or the desire for stronger cash visibility and management discipline. Identify which applies to you — then build accordingly.