Your 13-Week Cash Forecast Shows Enough Cash. So Why Are You Still at Risk?

Your CFO opens the latest 13-week cash forecast.

Opening cash: $1.2 million.

Ending cash: $1.4 million.

No projected negative balances. No obvious crisis. The forecast even shows an improvement.

Wonderful.

Now look at week six.

Cash falls to $350,000, the company has $500,000 in minimum operating cash requirements, and a major customer payment is already looking questionable.

Suddenly, that comfortable $1.4 million ending balance isn’t quite so comforting.

This is one of the problems with cash forecasting. A company can finish the quarter with plenty of money and still run into a liquidity problem before it gets there.

The relevant question isn’t simply whether the business has enough cash at the end of the forecast.

It’s whether the business can meet its obligations throughout the forecast period, including when collections, payments, and operating assumptions don’t behave as expected.

That’s where cash flow stress testing becomes useful.

Why a Healthy Ending Cash Balance Can Be Misleading

A 13-week cash flow forecast estimates receipts, disbursements, and available cash over a rolling quarter.

The basic calculation is straightforward:

Opening cash + Cash receipts − Cash payments + Net financing = Closing cash

Repeat that calculation for each week, using the previous week’s closing cash as the next week’s opening balance.

The Association for Financial Professionals describes receipts-and-disbursements forecasting as a practical short-term methodology because it focuses on expected cash movements rather than accounting earnings.

But a cash forecast can be mathematically correct and still be dangerously optimistic.

Consider a business expecting $800,000 from customers during the next month.

The sales are legitimate. The invoices have been issued. Management expects payment.

The forecast includes the receipts.

Unfortunately, customers haven’t signed a legally binding agreement to pay precisely when someone in FP&A needs the money.

A two-week collection delay could push cash below the minimum required to operate, even if the business eventually collects every dollar.

The forecast may still show a healthy quarter-end balance.

The cash shortage happens in between.

And payroll generally doesn’t accept “the money should arrive next Tuesday” as a payment method.

Start With the Lowest Cash Balance, Not the Ending Balance

Consider this illustrative business.

All amounts are in thousands of dollars. The figures are hypothetical and assume unrestricted, available cash, with no financing transactions during the period.

The company starts with $1.2 million and finishes with $1.4 million.

Over the full period, receipts total $5 million and payments total $4.8 million.

Everything reconciles.

But week six tells a different story.

The company has only $350,000 remaining.

Assume management has established a $500,000 minimum operating cash reserve based on expected payment obligations and its tolerance for disruption.

The calculation becomes:

Cash headroom = Projected available cash − Minimum required cash

Week-six headroom:

$350,000 − $500,000 = −$150,000

The company has a $150,000 reserve shortfall.

It hasn’t necessarily become insolvent, and the forecast doesn’t establish that it will miss a payment. But it has breached management’s assumed liquidity threshold.

That distinction matters. A reserve breach is a warning requiring investigation and action, while an inability to meet obligations as they fall due is a more immediate problem.

Finance should report both the lowest projected cash balance and the amount by which it exceeds or falls below the required reserve.

The week-13 balance is useful.

The week-six balance is where management needs to pay attention.

Stress-Test the Assumptions That Can Actually Break the Forecast

A cash flow stress test asks what happens when specific assumptions deteriorate.

The objective isn’t to invent increasingly dramatic disasters until the spreadsheet resembles a financial horror film.

It’s to identify credible changes that could materially affect liquidity.

Start with the assumptions that have the greatest influence on cash timing and availability.

1. What happens if major customers pay late?

Suppose $250,000 of the $300,000 expected in week six comes from a major customer.

The customer now indicates that payment may arrive in week eight instead.

Assume the payment is delayed in full, all other receipts and payments remain unchanged, and no financing is available.

Week-six closing cash becomes:

$350,000 − $250,000 = $100,000

Against the $500,000 minimum reserve:

$100,000 − $500,000 = −$400,000

The reserve shortfall has increased from $150,000 to $400,000.

Week seven is also affected because the missing cash carries forward.

Original week-seven closing cash: $600,000.

Revised week-seven closing cash: $350,000.

The payment finally arrives in week eight, restoring the original forecast trajectory from that point onward.

The business still finishes week 13 with $1.4 million.

Yet the lowest cash balance has fallen to $100,000.

That is the problem with treating a cash forecast as a quarterly total.

The same money can arrive within the quarter and still arrive too late to prevent a shortfall.

2. What happens if a major payment arrives early?

Collection delays aren’t the only timing risk.

Suppose the business also has a $175,000 supplier payment originally scheduled for week nine.

Under a revised contractual agreement, that payment becomes due in week six.

Assume the payment is moved entirely from week nine to week six, with no change to its amount.

Combined with the customer collection delay, week-six cash becomes:

$350,000 − $250,000 − $175,000 = −$75,000

The company now faces a projected negative cash balance.

Against the $500,000 operating reserve, the shortfall is:

−$75,000 − $500,000 = −$575,000

The difference between these two figures is important.

The company would need $75,000 of additional available cash to prevent its modeled balance from going negative.

It would need $575,000 to preserve the full $500,000 reserve at the trough.

Those are different funding objectives.

A CFO should know which one management is trying to achieve before asking the bank for money.

3. What happens if operating performance deteriorates?

Cash forecasting also needs to reflect changes in the business itself.

Suppose a major customer reduces purchases.

That might affect future collections, but it could also reduce inventory purchases, commissions, freight expenses, and other variable cash outflows.

A weak stress test reduces receipts while leaving every expense untouched.

Sometimes that’s appropriate, particularly when expenses are contractually committed or inventory has already been purchased.

Other times it exaggerates the net cash impact.

Finance needs to distinguish between costs that will genuinely decline and costs that remain payable despite lower activity.

The correct question is:

Which cash movements change because of the event, and when do those changes actually occur?

A lost sale may reduce cash receipts eight weeks from now.

The related inventory payment might be due next week.

Those timing differences determine the liquidity impact.

Compare Scenarios Using the Same Liquidity Measures

For the illustrative company, the scenarios can be summarized as follows.

Assumptions: The $250,000 customer receipt moves from week six to week eight. In the combined scenario, the $175,000 supplier payment also moves from week nine to week six. All other cash movements remain unchanged. No additional financing or management actions are assumed.

Notice the last row.

All three scenarios finish with exactly the same cash balance.

The risks are entirely different.

This is why a CFO reviewing liquidity scenarios should ask for the lowest cash position, timing of the trough, reserve shortfall, and available response time.

Ending cash alone conceals the problem.

Also, these scenarios are illustrations, not probability estimates. A $575,000 modeled reserve shortfall doesn’t mean the company has a particular likelihood of running out of cash.

Estimating that probability would require evidence about the underlying risks, their dependencies, and the range of plausible outcomes.

How Much Additional Funding Does the Business Actually Need?

Once the stress test identifies a potential shortfall, finance needs to calculate the amount of liquidity required.

For a weekly forecast:

Required incremental liquidity = Maximum(0, Minimum required cash − Lowest projected available cash)

Under the combined scenario:

$500,000 − (−$75,000) = $575,000

This is the minimum incremental cash needed at the modeled trough to maintain the stated reserve, assuming no other changes.

But it isn’t automatically the amount the company should borrow.

Before recommending financing, FP&A and treasury should establish:

• How much committed credit is available and drawable when needed?
• Are there borrowing-base restrictions, covenant conditions, or other limits?
• Can any payments be moved without breaching contractual obligations or damaging critical supplier relationships?
• Are customer collection commitments sufficiently reliable to support the revised forecast?
• Does the company need an additional contingency allowance for forecast uncertainty?

For example, suppose the company has $300,000 of immediately drawable, committed credit capacity.

If that capacity is available at the trough, remains available under the stress assumptions, and can be used without violating applicable terms, the remaining reserve funding gap would be:

$575,000 − $300,000 = $275,000

That $275,000 might be addressed through additional financing, accelerated collections, appropriately negotiated payment timing, or other feasible cash actions.

The $300,000 credit facility isn’t extra cash sitting in the bank. It represents potential borrowing capacity, subject to its terms and availability.

Finance should show the cash forecast before financing and then separately model any proposed facility drawings, repayments, interest, and fees.

Otherwise, the business risks counting financing as available cash before confirming it can actually access the money.

Build Management Actions Into the Forecast Without Counting Them Twice

A common scenario-planning mistake is assuming that management’s proposed response has already solved the problem.

Consider a plan to address the $575,000 reserve shortfall.

Management proposes accelerating $150,000 of customer collections, deferring $125,000 of eligible discretionary payments, and drawing $300,000 from the available credit facility.

The total potential near-term liquidity improvement is:

$150,000 + $125,000 + $300,000 = $575,000

On paper, the reserve shortfall disappears.

Very neat.

Unfortunately, the customer hasn’t agreed to pay early, the supplier hasn’t approved revised terms, and treasury hasn’t confirmed the facility drawing conditions.

Those are proposed actions, not available cash.

A stronger forecast separates three categories.

Confirmed actions: Contractually agreed or operationally completed, with a reliable cash date.

Probable actions: Supported by evidence but still subject to execution or third-party agreement.

Contingent actions: Options management could pursue if conditions deteriorate.

Only include the cash impact of an action in the base forecast when its treatment is consistent with the company’s forecast policy and supported by evidence.

Keep unapproved actions in a separate mitigation scenario.

That allows the CFO to see the underlying cash exposure and how much of the proposed solution depends on events that haven’t happened yet.

It also prevents the same collection acceleration or payment deferral from appearing in multiple scenarios as though it creates fresh cash each time.

Don’t Confuse a Weekly Closing Balance With the Cash Available on Payroll Day

There is another weakness in weekly cash forecasting.

A company may finish Friday with $600,000 and still have insufficient cash on Wednesday.

Suppose the following movements occur during one week:

Opening cash on Monday: $450,000.

Payroll on Wednesday: $300,000.

Customer receipt on Friday: $400,000.

Other Friday payments: $100,000.

The closing weekly cash balance is:

$450,000 − $300,000 + $400,000 − $100,000 = $450,000

The week appears cash-neutral.

But immediately after Wednesday’s payroll, the company has only $150,000.

If another $200,000 of essential payments clears on Thursday, the balance temporarily becomes negative before Friday’s customer receipt.

The weekly closing balance doesn’t reveal that.

For companies with tight liquidity, large payment concentrations, or material uncertainty about receipt dates, daily cash forecasting around the expected trough may be necessary.

The Association for Financial Professionals’ cash forecasting guidance discusses selecting forecast horizons and methods according to the underlying cash flows and the quality of available data.

The practical implication is straightforward: the closer the business gets to its liquidity limit, the more precisely finance needs to understand payment dates.

A weekly forecast is useful for identifying the problem.

A daily forecast may be needed to manage it.

Set Liquidity Triggers Before the Cash Shortage Arrives

A stress test becomes more useful when management agrees in advance what will trigger action.

Otherwise, finance may produce an increasingly alarming forecast every Monday while leadership continues discussing whether the situation is sufficiently alarming to justify doing something.

The triggers should reflect the company’s operating needs, financing arrangements, and ability to respond.

For example, using the illustrative $500,000 minimum cash reserve, management could adopt the following internal framework.

These are illustrative management rules, not universal regulatory thresholds.

A business with a $500,000 minimum reserve and highly predictable daily cash flows may tolerate a different amount of headroom than one with concentrated customers and unpredictable collections.

The timing of management action also matters.

If securing financing requires four weeks, identifying a shortfall two weeks before it occurs is already late.

The forecast should therefore connect each material risk to the latest date on which management can take an effective corrective action.

A warning is only useful if the business still has time to respond.

Measure Forecast Quality Where Errors Actually Hurt

Finance teams often assess forecast accuracy by comparing total expected cash receipts or ending balances with actual results.

That can conceal serious timing errors.

Suppose the forecast predicts $2 million of collections over four weeks.

Actual collections also total $2 million.

At the monthly level, collection accuracy appears perfect.

But $600,000 arrived two weeks later than forecast.

If that delay caused a reserve breach, the apparent accuracy is irrelevant to the liquidity decision.

A better review considers both amount and timing.

For each forecast refresh, finance should examine:

Cash balance error: Actual closing cash minus the closing cash previously forecast for the same date.

Receipt timing error: The difference between expected and actual receipt dates for material collections.

Payment timing error: The difference between expected and actual payment dates for material disbursements.

Liquidity trough error: The difference between the forecast minimum cash balance and the actual minimum over the same period, using comparable daily or weekly observations.

The team should also distinguish between forecast errors caused by poor assumptions and cash movements caused by management decisions made after the forecast was issued.

Otherwise, a deliberate payment deferral might be classified as a forecasting failure, while an unreliable customer collection assumption escapes scrutiny.

The purpose is to improve the next forecast and the decisions based on it.

A perfectly formatted forecast with consistently incorrect payment dates is still an incorrect forecast.

It just has excellent formatting.

What Should the CFO See Every Week?

A CFO shouldn’t need to inspect thirteen columns of receipts and payments to understand the company’s liquidity exposure.

The underlying detail belongs in the model.

The management summary should answer a smaller set of questions:

1. What is the lowest projected available cash balance, and when does it occur?
2. How much headroom remains above the minimum required cash reserve?
3. Which assumptions create the greatest downside exposure?
4. What happens under the most relevant combined stress scenario?
5. How much additional liquidity would be needed, and when?
6. Which management actions are confirmed, proposed, or contingent?
7. What decision must be made now to prevent a future shortfall?

For material exposures, include the accountable owner and the date by which the action must occur.

If the company has significant borrowing restrictions, restricted cash, or multiple legal entities, the summary should also distinguish cash that is genuinely accessible from cash that exists elsewhere in the organization but cannot readily fund the obligation.

A consolidated cash balance can look reassuring while the entity responsible for payroll has a very different problem.

The FP&A Trends discussion of cash flow transformation addresses the importance of integrating operational drivers, cash forecasts, and treasury planning. The management report should make those relationships visible without burying the decision beneath another spreadsheet.

A Cash Forecast Should Tell Management When to Act

The purpose of stress testing isn’t to prove that something terrible could happen.

Given enough imagination, finance can construct a scenario in which almost any business runs out of money.

The useful exercise is identifying credible liquidity exposures, calculating their consequences, and determining which actions are available before the problem becomes unavoidable.

Start with the base forecast.

Find the lowest cash balance.

Test the customer receipts, supplier payments, and operating assumptions most likely to change the result.

Calculate the reserve shortfall and the timing of any funding requirement.

Then separate confirmed liquidity from proposed solutions.

For the next forecast review, ask your finance team to present the lowest cash balance under the base case and one credible downside scenario, along with the action required to protect the minimum reserve.

If the forecast only tells you that cash looks healthy at the end of thirteen weeks, you’re missing the most useful part of the analysis.

The business has to survive weeks one through twelve first.

Put your own assumptions to the test: The Schlott Company’s Finance Decision Lab includes a 13-week cash flow forecasting tool that lets you model weekly receipts, payments, financing, and minimum cash reserves. Use it to identify your projected cash trough and test what happens when the timing changes.