Working Capital and 13-Week Cash
The deterministic-split showcase. The model builds the 13-week cash model (the machinery) from AR and AP agings and actuals, you validate the machinery once, and then the model narrates scenarios on top of it. Levers, sensitivity checks, and the actions a forecast should drive.
120 min
6
18
5
Learning Objectives
By the end of this chapter you should be able to:
- 1Define what a validated 13-week cash forecast is: a weekly chain that ties, a correctly identified trough, and a minimum-cash line the treasury team can act on, before any scenario is narrated on top.
- 2Apply the deterministic split to a cash model, letting the model build the weekly arithmetic (the machinery) from the AR and AP agings and the actuals, while the analyst validates it once.
- 3Sequence the build-then-narrate workflow so the base weekly chain is validated first and every scenario rests on that validated base rather than on unchecked arithmetic.
- 4Run the red-lines check for cash and aging data before starting, and keep the forecast inside the normal treasury review chain.
- 5Validate the weekly chain by confirming each week's ending cash equals beginning cash plus collections minus disbursements, and identify the trough week and its minimum cash.
- 6Reason about scenarios and levers, tracing how a collections slip or a disbursement delay moves the trough and naming the action each liquidity lever implies.
- 7Frame the minimum-cash story for a treasurer, leading with the trough, the swing factors that drive it, and the protective moves rather than with the full weekly table.
- 8Explain the underlying treasury work and its established best practices: the direct-method 13-week cash flow forecast (a treasury and restructuring standard), the cash conversion cycle, and how AR and AP aging supply the collection and disbursement timing the chain depends on.
Part One: The Work: The 13-Week Cash Forecast, the Conversion Cycle, and the Agings. Section 1 of 6.
Part One · The Work: The 13-Week Cash Forecast, the Conversion Cycle, and the Agings
The Work: The 13-Week Cash Forecast, the Conversion Cycle, and the Agings
Part One
The Work: The 13-Week Cash Forecast, the Conversion Cycle, and the Agings
Before any tool builds anything, this part covers the actual treasury work: what a 13-week cash forecast is, why it sits at the center of liquidity and restructuring, and the established practices for building one a lender or a CFO would trust.
The 13-week cash forecast, and where it comes from
You are the treasury analyst at Meridian Components, a mid-market industrial parts manufacturer. Each Friday the CFO asks one thing: over the next quarter, which week gets tightest, how tight, and what to do about it. The standard tool for that answer is the 13-week cash flow forecast, a rolling, week-by-week projection of cash coming in and cash going out over the coming quarter.
The 13-week window is a deliberate choice. Thirteen weeks is one quarter at weekly resolution: short enough that receipts and payments can be scheduled from real source documents rather than smoothed out of the income statement, and long enough to see the next liquidity low point coming. It is built by the direct method, adding up expected cash receipts and disbursements from the ground up, rather than starting from accrual profit and working back. The Association for Financial Professionals treats this short-horizon, direct-method forecast as core treasury practice, and it is the format lenders and advisors typically expect.
The tool earns its reputation in restructuring. In a turnaround, the Turnaround Management Association describes the rolling 13-week cash flow, often abbreviated TWCF, as the working standard: a distressed company runs it each week to show it can fund operations, and each week's forecast is compared against what actually happened so the variance is visible. That weekly actual-versus-forecast discipline is a big part of why the tool is trusted, and it is a habit worth borrowing even when a company is healthy.
Why the timing exists: the cash conversion cycle
A 13-week forecast is really a schedule of timing, and the timing has a cause. Working-capital theory, as laid out in Brealey, Myers, and Allen's Principles of Corporate Finance, describes the cash conversion cycle: the stretch of time between paying your suppliers and collecting from your customers. In the usual form it is days sales outstanding plus days inventory outstanding, less days payable outstanding. The longer that cycle, the longer cash sits tied up in receivables and inventory before it comes back.
That is why a business can be profitable on paper and still run tight on cash: a working-capital swing can move near-term liquidity more than a quarter of reported earnings does. Brealey, Myers, and Allen make the same point through the cash budget, where each period's ending cash follows from beginning cash plus receipts minus disbursements. The 13-week forecast is that cash budget at weekly resolution. It does not restate profit; it schedules when cash actually lands and when it leaves.
The evidence base: AR aging, AP aging, and what "validated" means
The timing is not guessed; it is read off two schedules. The AR aging buckets receivables by how overdue each balance is (current, 1 to 30 days, 31 to 60, and so on), and it is the evidence base for collection timing: you estimate when each bucket turns into cash from how that customer base has historically paid, not from hope. The AP aging buckets payables by how soon each is due, and together with known dated items such as payroll runs, tax payments, and debt service, it schedules what leaves the account and when. A disciplined forecast, in the restructuring tradition, counts only the receipts the aging can support and dates each disbursement to when it truly comes due.
These schedules chain together. Each week's ending cash equals the prior week's ending cash, plus the collections read off the AR aging, minus the disbursements read off the AP aging and the dated items. That arithmetic has one right answer for a given set of inputs. So a forecast is not decision-ready because it looks finished; it is decision-ready when it is validated, which here means three things. The weekly chain ties, so each week follows from the prior week and the flows. The trough week is correctly identified as the true low point across the 13 weeks. And the minimum cash, the lowest balance the forecast reaches, is a figure the treasury team would stand behind. Validation comes before scenarios, because a scenario is just the base with a few inputs changed, and a stress test on a base that does not tie tends to be confidently wrong.
Check Your Understanding
Knowledge Check 1
Working Capital
A treasury team calls a 13-week cash forecast "decision-ready." Which description best fits what that standard requires?