Skip to content
Module 4CHAPTER 04Applied AI for Finance and Accounting

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.

Estimated time

120 min

Reading steps

6

Practice questions

18

Interactive tools

5

Start Reading

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

Section 1 / 6

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

1 min read

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

1 min read

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

2 min read1 knowledge check

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.

Why this work suits AI assistance. Most of a 13-week forecast is mechanical and high-volume: bucket the agings, chain the arithmetic, roll it forward, spin up scenarios. The inputs live in a small, known set of source documents, and the core calculation has one correct answer. That profile, a lot of structured mechanics anchored to a clear source base, is a strong candidate for AI help, as long as the collection timing stays tied to the agings and a person validates the chain before anyone leans on it.

Check Your Understanding

1

Knowledge Check 1

Working Capital

A treasury team calls a 13-week cash forecast "decision-ready." Which description best fits what that standard requires?

HomeAI COETrainingInsightsAcademy
AcademyCorp FinReal EstateEntr Fin