The Tool Every Lender Wants to See
When a business faces financial pressure — a covenant breach, a funding requirement, a cash crisis, or simply a period of acute uncertainty — one document gets requested more than any other. Not your management accounts. Not your annual report. Not a business plan.
A 13-week cash flow forecast.
It has become the standard tool in any distress or near-distress situation, and for good reason. A well-constructed 13-week model tells a lender, a funder, or a board of directors something that no other document can: exactly what is happening to cash, week by week, for the next quarter — and whether the business can meet its obligations during that period.
A 13-week cash flow forecast is not just a financial tool. In the right circumstances, it is the document that keeps a business alive.
This article explains what a 13-week cash flow model is, how it is built, what goes into it, and — critically — how it needs to be managed once it exists. Because a forecast that sits in a spreadsheet and is never updated is not a forecast. It is a guess.
Why 13 Weeks?
The 13-week horizon is not arbitrary. It represents one full quarter — long enough to capture a meaningful picture of the business cycle, short enough to forecast with genuine granularity and reasonable accuracy.
At this timeframe, you can work week by week rather than month by month. That matters because cash does not move in smooth monthly increments. Payroll falls on a specific date. A large customer payment arrives mid-week. A VAT or PAYE liability hits on a fixed deadline. Monthly forecasts smooth over these peaks and troughs. A weekly model exposes them.
For a lender or funder, that granularity is precisely the point. They are not interested in a monthly average. They want to know whether there is a week in the next quarter where the business runs out of money — and if so, when, by how much, and what is being done about it.
How a 13-Week Model Is Built
Building a credible 13-week cash flow model is a structured process. It is not complicated, but it requires discipline, access to the right data, and a clear understanding of how the business actually operates.
Step 1: Establish the Opening Cash Position
The model starts with a single, verified number — the cash balance at the beginning of week one. This needs to come directly from the bank, not from the accounting system, and it needs to be reconciled. Any discrepancy between the book balance and the bank balance needs to be understood and resolved before the model is built. A forecast built on an incorrect opening position is wrong from the first line.
Step 2: Map Your Receipts
Receipts are the money coming into the business. For most SMEs, this means customer payments — but the timing of those payments is rarely straightforward. You need to work from your actual debtor ledger, not your invoice dates.
For each significant customer or debtor category, the model should incorporate:
- The invoice value and date
- The agreed payment terms
- The actual payment pattern — because what customers are supposed to do and what they actually do are often very different
- Any known disputes, holds, or delays
In sectors with longer payment cycles or complex billing — professional services, construction, healthcare — this analysis can be the most time-consuming part of the build. In our work with a £20m international law firm ahead of a trade sale, mapping the debt and WIP ledger was central to the entire engagement. With over £3m at stake, understanding exactly when — and whether — that value would convert to cash was critical both to managing the business through the sale process and to supporting the valuation presented to the buyer.
Step 3: Map Your Payments
Payments are everything leaving the business. These fall into a small number of predictable categories:
- Payroll and associated costs — typically the largest and most fixed outflow, falling on known dates
- Supplier payments — mapped from the creditor ledger, incorporating agreed terms and any payment plans in place
- HMRC liabilities — VAT, PAYE, Corporation Tax, with specific payment dates that cannot be moved without consequence
- Rent, utilities, and fixed overhead — recurring commitments that are straightforward to model
- Debt service — loan repayments, interest, facility fees
- One-off or irregular items — capex, insurance renewals, legal costs, restructuring expenses
The discipline here is to be conservative. Overestimating receipts and underestimating payments is the most common modelling error — and the most dangerous. Lenders will stress-test your assumptions. They should, and you should too.
Step 4: Calculate the Weekly Cash Position
With opening balance, receipts, and payments mapped week by week, the model produces a closing cash balance for each week — and, where a funding facility exists, the headroom or utilisation against that facility. This is the number the lender is watching. Any week where the projected balance turns negative, or where headroom falls below an agreed threshold, is a week that requires a conversation.
Step 5: Sense-Check and Stress-Test
Before the model goes anywhere near a lender, it needs to be challenged. Does the receipts profile reflect realistic collection performance, or optimistic assumptions? What happens to the cash position if a major customer pays 2 weeks late? What if a supplier demands earlier settlement? What if a key revenue line underperforms by 10%?
Scenario modelling — running a base case, a downside case, and a severe downside — is what separates a credible forecast from a hopeful one. During our engagement with a £5m hospitality supplies group navigating a refinancing at the height of COVID-19, the model needed to incorporate multiple recovery scenarios for a sector where no one knew when trading would resume. That scenario discipline was central to giving the incoming lender the confidence to proceed.
Managing the Model: Where Most Businesses Fall Short
Building the model is the beginning, not the end. A 13-week cash flow forecast has a very short shelf life if it is not maintained — and an unmaintained forecast is worse than useless, because it creates false confidence.
Weekly Variance Analysis
Every week, actual cash movements need to be recorded against forecast. Where there are variances — and there will always be variances — they need to be understood. Was a payment late? Did a customer pay early? Did an unexpected cost arise? Each variance tells you something about the quality of your assumptions, and the explanations feed directly into improving the next iteration of the forecast.
For the multi-site care homes group we currently support, the weekly variance review is a core part of the engagement. In a sector where cash timing is affected by local authority payment cycles, agency staffing costs, and HMRC obligations, the variances are rarely trivial — and understanding them is what allows management to stay ahead of problems rather than behind them.
Rolling the Forecast Forward
Each week, the model rolls forward. Week one drops off, a new week 13 is added, and the entire forecast is refreshed. This is not a minor administrative task — it requires genuine re-engagement with the underlying data. Has the debtor ledger changed? Have any new payment plans been agreed? Are there new liabilities on the horizon?
The rolling nature of the model is what gives it its power. It means the business always has 13 weeks of forward visibility, and that visibility is always current.
Reporting to Stakeholders
For most businesses using a 13-week model in a distress or near-distress context, regular reporting to lenders and funders is not optional — it is a condition of their continued support. The format and frequency will vary, but the principles are consistent: present actuals against forecast, explain material variances, and update the forward projection.
In our engagement with the £120m multi-franchise hospitality group facing a covenant breach, the 13-week model was the foundation of every lender conversation. It gave the debt provider a structured, consistent basis on which to assess progress — and it gave management a credible tool with which to demonstrate that they had the situation under control. That dynamic was central to securing continued lender support through the turnaround.
A weekly reporting cadence, built around the 13-week model, changes the nature of the lender relationship. You stop being a problem to manage and start being a business they can support.
What Lenders Are Actually Looking For
It is worth being direct about what a lender wants to see when they review a 13-week cash flow forecast. They are not looking for perfection. They are not expecting the numbers to be exactly right. What they are assessing is something more fundamental:
- Does management understand their cash position?
- Are the assumptions realistic and supportable?
- Is there a clear view of where the risks lie?
- Is the business being run by people who are on top of the numbers?
A well-constructed, regularly updated 13-week model answers all four questions in the affirmative. A business that presents one — particularly in circumstances where many businesses present nothing — immediately differentiates itself. It signals competence, transparency, and control.
Those are exactly the qualities a lender needs to see before they will extend support, agree a waiver, or back a restructuring plan.
Do You Need One?
Not every business needs a 13-week cash flow model at all times. If your cash position is healthy, your working capital cycle is well managed, and your lender relationship is straightforward, monthly management accounts and a rolling annual forecast may be sufficient.
But if any of the following apply, a 13-week model is not optional — it is urgent:
- You are approaching or have breached a financial covenant
- You are in active discussion with a lender about your facilities
- You have entered into payment plans with HMRC or major suppliers
- Your cash balance is uncomfortably close to zero on a regular basis
- You are going through a refinancing, a sale process, or a restructuring
- Your business operates in a sector under acute external pressure
In all of these situations, the 13-week model is the document that gives you — and your stakeholders — the visibility to make good decisions under pressure. Building it properly, and maintaining it rigorously, is one of the highest-value things a business in difficulty can do.
A Final Word
Across our engagements — from a 130-site hospitality group navigating a covenant breach, to a multi-site care homes operator managing creditor pressure, to a hospitality supplier rebuilding from a £2m loss — the 13-week cash flow model has been the consistent foundation. Not because it solves problems by itself, but because it creates the visibility that allows problems to be solved.
You cannot manage what you cannot see. And you cannot ask others to support what they cannot understand.
A 13-week cash flow forecast, built and maintained properly, does both. If you would like support building one for your business — or in presenting your cash position to a lender — SIMBA Advisory works with SMEs at exactly these moments.