Liquidity Gap Analysis in the 13-Week Cash Flow Forecast
A weekly cash flow forecast only becomes a risk management tool once it identifies exactly which week cash runs short, by how much, and what response the situation calls for. This is how that layer of analysis is built.
Liquidity gap analysis sits on top of the weekly cash flow model. Its role is narrow and specific: define what a safe cash position looks like, find the weeks where the forecast falls short of that position, size the funding needed to close the shortfall, and set up indicators that flag the next gap before it arrives. The approach below covers each of these steps in the order they are normally built.
Minimum cash requirement
Before any gap can be measured, the forecast needs a reference point: how much cash the business should hold at minimum. This reference point has two parts — a minimum safe cash balance, and a liquidity buffer held on top of it.
What is the minimum safe cash balance?
The minimum safe cash balance is the lowest amount of cash the business aims to keep in its accounts at all times. It acts as a safety net against delayed customer payments or sudden extra costs. It is typically set from monthly operating expenses, often one to two months' worth as a starting point, then adjusted for the specific business — its industry, payment terms, and how predictable its cash flow has been historically.
How many payroll cycles should be covered?
Payroll is usually the largest and most time-sensitive outflow in the forecast, so it is checked separately once the minimum balance is set. The balance calculated from operating expenses needs to cover at least one to two full payroll cycles without relying on incoming cash that hasn't arrived yet; if it falls short of that, the minimum balance is raised until it does. This check uses actual past payroll amounts rather than estimates, so the coverage is confirmed against real figures.
How much liquidity buffer is required?
A liquidity buffer is created above the minimum cash balance. It covers normal variation in cash flow — a slower month of collections, or expenses that run higher than expected — that the minimum balance alone isn't sized to absorb. A common target is 30 to 60 days of key outflows, depending on the company's stability and industry. The ending cash balance for each week is tracked against minimum balance plus buffer through the 13-week period; if it dips too low, that week is flagged for action.
The liquidity policy documents two figures: the minimum safe cash balance — sized from operating expenses and checked to ensure it covers at least one to two payroll cycles — and the liquidity buffer held on top of it for normal variation. Together these set the cash target the business monitors throughout the 13-week forecast, along with the point at which management action is required if projected cash is expected to fall below it.
Liquidity gap identification
With the minimum requirement defined, the analysis turns to spotting the differences between cash coming in and cash going out over the weeks ahead. All expected inflows — customer payments — and outflows — supplier bills, payroll, and other expenses — go into the model. The ending cash balance for each week emerges from these calculations, and this is what reveals where cash may run low.
Showing which week has the lowest cash balance
The week with the lowest cash balance stands out clearly in the forecast and is flagged first. It often occurs when large payments align with slower incoming funds. Knowing the exact week in advance allows time to prepare — speeding up collections, or adjusting spending before that week rather than during it.
How much additional funding is required?
The additional funding required is the amount needed to bring the low cash balance back above the minimum safe level. It is calculated by subtracting the projected low balance from the agreed minimum cash target. This figure sets the size of the gap and points toward the options for closing it — drawing on a credit line, or delaying non-critical payments.
When does a liquidity shortage occur?
Liquidity becomes constrained when the forecast shows cash falling near or below the minimum safe balance or the liquidity buffer. This condition usually appears several weeks before the actual low point, which is what gives time to act. It can arise from timing mismatches between inflows and outflows, seasonal dips, or unexpected costs. Catching it early, inside the 13-week view, is what prevents a manageable gap from becoming a bigger problem.
The gap analysis report lists the week with the lowest cash balance, the amount of any additional funding needed, and the points where liquidity tightens. Tables and short explanations keep the information easy to follow, with recommendations for closing each gap set out at the end.
Peak funding requirement
Where the identified funding shortfalls point to individual weeks, a peak funding need assessment is performed over the entire 13-week period to determine the greatest cash need the business is likely to face.
What is the maximum cash deficit?
The maximum cash deficit is the largest negative cash balance projected in any single week. After calculating ending cash for each week, the biggest drop below zero — or below the minimum safe level — marks this point. It identifies the single week where cash runs shortest.
What is the maximum cumulative deficit?
The maximum cumulative deficit tracks the total funding gap over time rather than in a single week. It adds up the weekly deficits while considering any surpluses that can offset earlier shortfalls. This shows the overall cash shortfall that builds across the 13 weeks. It gives a fuller picture than single-week views alone.
What size credit facility would close the gap?
The credit facility is sized to the maximum cumulative deficit, not the single-week figure. The cumulative deficit shows the full borrowing capacity needed across the period, not just the worst week. A facility of that size keeps cash above the safe minimum throughout the 13 weeks. A modest additional buffer is normally added on top for unexpected changes, without oversizing the facility beyond what the forecast supports.
A forecast shows a single-week deficit of 18,000 in week 6. By week 9, after netting off surpluses in the weeks between, the cumulative shortfall has grown to 41,000. The recommended credit facility is sized to the 41,000 cumulative figure, not the smaller single-week number, plus a modest buffer for unexpected changes.
The funding requirement calculation sets out the maximum cash deficit, the maximum cumulative deficit, and the recommended credit facility size, with tables showing how these figures move week by week. This is what supports a financing decision made ahead of the gap, rather than during it.
Scenario analysis
The forecast so far represents one version of events — the base case. Scenario analysis tests how different situations would affect cash flow and liquidity gaps, so that risks become visible before they occur rather than after. Each scenario adjusts specific assumptions while keeping the rest of the model consistent, which shows how sensitive the cash position is to each type of change.
| Scenario | Effect on the forecast |
|---|---|
| Collections come in 20% lower | Incoming cash decreases across the weeks; ending balances drop, gaps widen, and liquidity constraints tend to appear earlier. |
| Major customers pay 30 days late | Cash inflows shift to later weeks; short-term deficits appear even if total revenue for the period is unchanged. |
| Suppliers demand earlier payment | Outflows move sooner; available cash falls in the early weeks and liquidity gaps widen. |
| Sales decline | Revenue and collections fall immediately, while outflows such as payroll, rent, and already-committed purchases adjust more slowly. Any reduction in variable costs typically lags and only partly offsets the drop in cash coming in, which is why the cumulative deficit usually widens over the 13-week window. |
Best case, base case, worst case
The base case uses expected, normal conditions. The best case assumes faster collections and higher sales. The worst case combines slower payments, lower sales, and earlier outflows. Comparing the three shows the range of possible liquidity gaps and peak funding requirements the business may need to plan for, rather than a single fixed number.
Scenario analysis is delivered as a short summary for each what-if situation and for the three main cases, showing the impact on cash balances, deficits, and funding needs. This supports decisions on which protective actions are worth preparing in advance, and which can wait until conditions are clearer.
Early warning indicators
Early warning indicators are metrics that tend to move before a cash problem shows up in the 13-week forecast itself. Reviewed alongside the weekly forecast, they allow action to be taken while there is still time.
Which metrics signal future liquidity problems?
Six metrics are reviewed on a regular basis. Rising trends or values that move outside the normal range for the business are treated as an alert.
The liquidity dashboard brings these six indicators together in one place, showing current values, trends, and simple alerts for each one. It links directly to the 13-week forecast, so the effect of a change in any indicator on cash balances, deficits, and funding needs is visible immediately.
Management actions
Once a gap is identified, the response falls into two categories: increasing cash inflows, and reducing cash outflows.
Increasing cash inflows
- Faster collections — reminders, early payment discounts, or tighter credit terms to speed up incoming customer payments.
- Asset sales — converting equipment, inventory, or other assets not currently needed into immediate cash.
- New funding — bank lines, short-term loans, or investor support, sized to the peak funding requirement already identified.
Reducing cash outflows
- Payment deferrals — negotiating longer terms with suppliers, or delaying non-essential bills without damaging the relationship.
- Cost reductions — cutting discretionary spending such as travel, marketing, or temporary staff.
- Capex postponement — delaying major equipment or project purchases to preserve cash in the near term.
This is a written list of actions that can be taken if the forecast shows a week where cash is expected to fall below the safe minimum. For each action, the list states how much cash it is expected to free up, how fast it takes effect, and the steps needed to carry it out. The list is prepared in advance, before any shortfall actually appears, so the right action — matched to how large the shortfall is and when it happens — can be chosen quickly instead of worked out under pressure.