Why the 13-Week Cash Flow Comes First in Restructuring
In a crisis the annual budget is too far away. A 13-week cash flow shows which week the gap opens and how much time each decision buys.
In a business facing a liquidity crisis, the annual budget sits at too high a level to make decisions on. Daily cash tracking, on the other hand, drowns management in detail. A 13-week rolling cash flow balances the two by giving roughly a quarter's visibility at weekly resolution: short-term payment control with enough forward view.
The basic structure of the model
| Section | Content | Control question |
|---|---|---|
| Opening cash | Bank balances, available lines | Is it genuinely available without restriction? |
| Collections | Expected inflows by customer | Is the collection date separated from the invoice date? |
| Operating payments | Raw materials, wages, tax, energy | Are criticality and payment priority defined? |
| Financing | Interest, principal, leasing, factoring | Are the contractual dates correct? |
| Investment | Essential maintenance and deferrable capex | Which is essential to keep the business running? |
| Closing cash | Liquidity at week end | Does it fall below the minimum cash buffer? |
How should the cash committee work?
The model creates no value on its own. A weekly cash committee should discuss collection variances, critical payments, bank lines and the bottlenecks in the next 4–6 weeks. Every line should have an owner and a probability of occurring. “The customer will pay” should not be an assumption but a date and a likelihood confirmed by whoever owns that collection.
Why is it strong in a bank negotiation?
The bank wants to see whether a restructuring request is simply a plea to defer payments or part of a sustainable turnaround plan. A 13-week model shows management's cash discipline, the size of the short-term requirement and the purpose to which new money will be put.
Three scenarios are essential
- Base: management's most likely estimates.
- Downside: delayed collections, margin erosion or a shortfall in sales.
- Liquidity stress: a severe shock such as a contraction in bank lines or the loss of a critical customer.
In each scenario the answer to “in which week do we fall below minimum cash?” sets out how much decision time management has. That interval is a critical indicator for restructuring, a capital increase, an asset sale or cost action.
Common mistakes
- Generating collections automatically from the sales budget instead of using real customer payment behaviour.
- Leaving out essential payments such as VAT and tax, wages, energy and critical suppliers.
- Counting credit lines that are not actually available as a source of cash.
- Confusing one-off cash inflows with sustainable operating cash.
- Leaving the model as a finance department file and not involving the commercial and operations teams.
The 13-week cash flow is the company's “control panel” in a crisis. Built well, management and the bank talk from the same data set; trust rises, options become visible earlier and the restructuring negotiation becomes concrete.
Official sources and further reading
- EBA — Guidelines on management of non-performing and forborne exposures
- EBA — Guidelines on loan origination and monitoring
Five design decisions that turn the model into a restructuring tool
1. Forecast collections on behaviour, not on the invoice due date
A customer's contractual term may be 30 days; but if the median actual payment over the last 12 months is 52 days, using 30 days in the cash model pushes management into false confidence. For critical customers, the historical payment distribution, open invoice ageing and confirmation from the sales team at customer level should be used together.
2. Split payments by decision class, not by accounting class
Treating wages, tax and critical raw materials at the same priority as deferrable consultancy or capital expenditure is wrong. Labelling payments as “essential / critical to operations / negotiable / deferrable” shows management which levers it holds when cash is short.
3. Do not count an available credit line as cash
An approved limit is not cash the bank will advance at any moment. There may be drawdown conditions, collateral margin, covenants, cheque risk at customer level or a right for the bank to reassess. The model should separate the “theoretical limit” from “realistically available headroom”.
4. Define a minimum cash buffer
A zero balance shows that the model works technically and that the company is fragile operationally. A minimum cash level approved by management should be set for payroll, critical suppliers and unexpected variances; the model should flag any week that falls below it automatically.
5. Make forecast variance a KPI
If the forecast-to-actual difference is measured each week across collections, suppliers, tax, credit and other lines, the model learns over time. Persistent variance in the same direction may be a process or incentive problem rather than a modelling error.
How should the 13-week model be presented in a bank negotiation?
Rather than handing the bank a working file of hundreds of lines, use a management summary: opening cash, minimum cash, the week of the lowest balance, the funding gap, the main assumptions, management actions and the restructuring request. The detailed model is provided as an audit trail when required.
| Management indicator | What does it tell you? |
|---|---|
| Week of minimum cash | The timing of the liquidity problem |
| Cumulative funding gap | The size of the buffer required |
| Collection realisation rate | The quality of the model's assumptions |
| Deferrable payment amount | Short-term management flexibility |
| Available limit headroom | Dependence on the bank, and the buffer |
A bridge from 13 weeks to 24 months
The 13-week model is the navigation screen in a crisis; a 12–24 month integrated financial model tests whether the restructuring is sustainable. The first shows weekly liquidity, the second the link between income statement, balance sheet and cash flow and the debt service capacity. Both models should rest on the same core assumptions.
Example: turning a weekly cash gap into a management decision
Suppose a manufacturing company forecasts a TRY 1,2 million cash gap in week 5. The value of the model is not limited to saying “we go negative in week 5.” If TRY 700 thousand of the gap comes from delayed collections at two large customers, TRY 300 thousand from cash purchases of raw material and TRY 200 thousand from a loan instalment, three different sets of action follow. Senior management contact at customer level for the collections, negotiation of lot size and terms for procurement, and a review of instalment timing or line utilisation for the loan. The funding request then takes shape within a chain of cause and effect.
Model governance: who should own what?
| Area | Owner | Weekly output |
|---|---|---|
| Collections | Sales plus Finance | Expected date and risk by customer |
| Suppliers | Procurement plus Finance | Critical payments and options on terms |
| Payroll and tax | Finance | A firm payment calendar |
| Credit | Treasury / CFO | Instalments, interest, available limit |
| Model consolidation | CFO / Finance | The 13-week rolling forecast and the action list |
If the model is updated by the finance team alone, commercial assumptions go stale quickly. Sales should own collections, procurement should confirm critical payments and material requirements, and management should sign off weekly action decisions.
What should be on the cash committee agenda?
- Last week's forecast-to-actual variance
- The minimum cash and critical payment picture for the next four weeks
- The 10 customers whose collections are most overdue
- The 10 items tying up most cash through inventory or procurement
- Bank limit headroom and upcoming loan payments
- Actions with a named owner and a date
That rhythm is what turns the 13-week model from an Excel file into the company's early warning system. In a financial restructuring, one of the strongest signals of confidence for a bank is management demonstrating that it runs the cash process in a regular and disciplined way.
Book a call →