Introduction
Every restructuring banker, on the first day of every distressed engagement, builds the same thing: a 13-week cash flow forecast. The model is the foundation of distressed advisory practice, the thing that DIP lenders demand, the thing the bankruptcy court expects to see at the first-day hearing, the thing creditors challenge line by line, and the thing the company's CFO will be asked about every Monday morning for the duration of the case. A restructuring analyst who cannot build a credible TWCF cannot do the job. A senior banker who cannot read a TWCF, spot the assumptions that will not hold, and explain the variances back to the lender group is missing the central skill of the practice.
This article walks through the TWCF in detail: what it is, why it uses the direct method rather than indirect, how the model gets built bottom-up over the first 5-7 days of an engagement, what populates each line, the standard line-item categories with their underlying source systems, the role of the TWCF in DIP shopping and the cash-collateral order, the interim-order-to-final-order progression, the variance reporting cadence and permitted-variance bands that DIP orders impose, the practical mechanics that separate a useful model from a fragile one, and a worked example showing how the model behaves through a typical Chapter 11 case.
What the TWCF Actually Is
The TWCF is a weekly, direct-method cash flow forecast covering the next 13 weeks (roughly one quarter), built bottom-up from actual contractual cash receipts and disbursements rather than from accounting projections. Three features distinguish it from a typical financial model.
- 13-Week Cash Flow (TWCF)
A weekly direct-method cash flow forecast spanning roughly the next quarter, used in distressed situations to track liquidity, support DIP financing requests, and serve as the operational benchmark for the restructuring. The TWCF differs from a standard cash flow forecast because it is built bottom-up from actual expected cash flows pulled from the company's AP and AR aging schedules, payroll systems, lease schedules, and contractual obligations, not derived from income statement projections. It is updated weekly with actual results bridged against forecast, with variance analysis that becomes the reporting cadence for the entire engagement, and it is typically attached as the budget exhibit to both the interim and final cash-collateral and DIP orders entered by the bankruptcy court.
- Direct method, not indirect. The standard cash flow statement in financial reporting uses the indirect method (start with net income, adjust for non-cash items, back into operating cash flow). The TWCF inverts this: each line is a cash movement (customer collections by week, vendor payments by week, payroll by week, debt service by week). The indirect method analyzes a year of completed activity; the direct method forecasts whether the next eight weeks will work.
- Weekly granularity. A monthly forecast can hide a liquidity problem inside a month. A company that pays semi-monthly payroll on the 15th and the 30th may have $10 million of cash on the 1st and $2 million on the 16th. A monthly forecast shows month-end $8 million; a weekly forecast shows the trough that determines whether the company can clear payroll. Severely constrained engagements move to daily granularity inside the first 30 days.
- Bottom-up construction. Lines populate from operational systems, not formulas tied to revenue. Customer collections come from AR aging and historical collection patterns by customer cohort; vendor payments from AP aging and known terms; payroll from the payroll system; lease payments from real estate schedules; interest and principal from credit agreements; capex from the project list. The forecast is an operational document anchored to documentable source data, not a stylized projection.
The Standard Architecture: Eight Sections, Twenty-Plus Lines
Every TWCF follows roughly the same architecture. The line items vary by industry, but the framework is consistent across engagements.
| Section | Standard Line Items | Source System / Data |
|---|---|---|
| Beginning Liquidity | Operating cash, restricted cash, undrawn revolver capacity, available factoring capacity | Treasury reports, ABL borrowing-base certificate |
| Operating Receipts | Customer collections (by customer cohort or segment), other operating receipts, factoring proceeds | AR aging, historical collection patterns, factoring program reports |
| Non-Operating Receipts | Asset sale proceeds, tax refunds, insurance recoveries, intercompany receipts | Sale process tracker, tax department, insurance claims tracker |
| Operating Disbursements | Vendor payments (critical/non-critical split), payroll and benefits, rent and leases, utilities, taxes | AP aging, payroll system, lease schedule, tax calendar |
| Debt Service | Interest (cash and PIK), scheduled principal, mandatory prepayments, factoring repayments | Credit agreements, indentures, factoring program docs |
| Professional Fees | Legal, RX bank, turnaround consultant, claims agent, US Trustee fees | Engagement letters, retention orders |
| Capex / Restructuring Costs | Maintenance capex, growth capex, restructuring costs, retention bonuses | Capex authorization list, KEIP/KERP, restructuring plan |
| Net Cash Flow & Liquidity | Net cash flow, ending cash, ending liquidity, available revolver, headroom vs operating cash floor | Calculated |
The eight sections are separable, which matters because creditor advisors and DIP lenders typically focus on different sections. The DIP lender wants to see the disbursements section in detail (because the variance covenant runs against disbursements). The unsecured creditors committee focuses on the receipts section (because that drives plan recoveries through stabilized EBITDA). Sale-process bidders focus on the asset sale and capex sections (because those affect the closing economics). A clean architecture lets the model serve all three audiences without re-cutting.
Operating Receipts: The Most Variable Line
The single most variable line in any TWCF is operating receipts, dominated by customer collections. Building it accurately requires more than averaging historical days sales outstanding. The standard approach: pull the AR aging at engagement start, identify the top 10-25 customers (typically 60-80% of receivables in most industrial and consumer businesses), build a customer-specific collection model for each top customer (historical days-to-pay, payment terms, known disputes, recent behavior, the customer's own credit profile), apply a blended collection curve to the long tail (typically 70-80% of current AR collects in the next month, 50-60% of 31-60 day AR, declining further for older buckets), and roll the AR aging forward by week with new sales generating new AR that ages into the forecast on the appropriate timeline.
Common pitfalls: applying average collection days to the entire AR balance (understates concentration risk), using collection rates that pre-date a customer's own distress, and ignoring the dispute backlog. Distressed engagements typically apply additional haircuts of 5-15% on collection forecasts to account for the slowdown in customer behavior that distressed announcements produce.
Operating Disbursements: The Most Contested Line
Operating disbursements is where the negotiation lives. The line items split into mandatory (payroll, rent, taxes, secured debt service), critical (key vendors essential to operations), discretionary (capex, marketing, professional fees), and deferrable (bonuses, optional capex, non-essential services). The model typically maintains separate columns for "scheduled" disbursements (what the company should pay) and "stretched" disbursements (what the company actually intends to pay given the constraint). The gap is the working capital lever, but it is finite: stretching too far triggers the vendor cascade described in the liquidity-crisis article.
How the TWCF Gets Built: Days 1-7
The standard build sequence over the first week of an engagement.
Day 1: Data request and initial pull
Issue a comprehensive data request to the company's CFO and treasurer. Required items: most recent bank statements (last 90 days), AP aging by vendor, AR aging by customer, payroll runs (last 6 months), lease schedule with payment dates, credit agreements and indentures, the latest borrowing-base certificate, capex authorization list, professional fee accruals, scheduled tax payments, and any existing internal cash forecasts.
Day 2: Historical reconciliation
Reconcile the last 4-8 weeks of bank activity to the company's general ledger. This calibrates the model to actual cash behavior and surfaces any discrepancies between reported and actual cash movements. Common findings: timing differences between when checks are mailed and when they clear, intercompany cash sweeps that have not been captured in the AP aging, and trapped balances in foreign or operating accounts.
Day 3: Build the operating receipts forecast
Apply the AR aging methodology described above. Test the resulting collection forecast against the last 4 weeks of actual receipts. The typical first-pass forecast misses by 5-15% on the upside; refine by adjusting the customer-specific collection assumptions until the variance is within 3-5% on the historical period.
Day 4: Build the operating disbursements forecast
Map the AP aging to the next 13 weeks based on payment terms and observed actual behavior. Layer in payroll, rent, utilities, taxes, and debt service from their respective source systems. Distinguish mandatory from deferrable; flag the items that are policy-driven rather than contractual.
Day 5: Stress test the model
Run base, downside, and severe-stress scenarios. Base case uses management's expected operating performance; downside applies haircuts on collections and conservative payment terms on critical vendors; severe stress models a 60-day cash-on-delivery vendor shift and a 25% collection slowdown. Identify the trough week and the operating cash floor.
Day 6: Build the variance and bridge architecture
Design the model so that actuals can be plugged in weekly and variances can be analyzed by line item. Include a one-page variance summary that will be the standing communication document with stakeholders.
Day 7: Walk through with management
Present the model to the CFO and CRO. Walk through assumptions, identify management's pushback, and finalize the version that goes to the board, the lender group, and (if a filing is contemplated) prospective DIP lenders.
The Day 7 walkthrough is often a difficult conversation: the model frequently shows runway shorter than management had been telling the board, particularly when AP stretching has masked the underlying cash burn or AR collection assumptions in the internal forecast were too aggressive.
How the TWCF Gets Used in Chapter 11
The TWCF is not a one-time deliverable. It is a living document that drives every consequential decision in the restructuring:
- Pre-filing diagnosis. The TWCF tells the board how much runway exists and which paths remain viable. Eight weeks forces a Chapter 11 conversation; twelve months allows a full out-of-court process.
- DIP shopping and the DIP order. When the company shops for DIP financing, the TWCF is the document the prospective DIP lenders use to size the facility, structure the draw schedule, and write the covenants. The DIP order entered by the bankruptcy court typically includes the TWCF as an attached budget exhibit and ties the company's spending authority to that budget on a line-item or aggregate basis.
- The interim-order-to-final-order progression. Most Chapter 11 DIP and cash-collateral matters proceed in two stages. At the first-day hearing, the court enters an interim order authorizing limited DIP draws and cash-collateral use sufficient to fund operations for the first 30-45 days. The interim order attaches an "Initial Budget" (typically the first 4-5 weeks of the TWCF) and provides the lender with limited adequate-protection rights consistent with the abbreviated notice period. Approximately 30 to 45 days later, after notice to all parties in interest, the court enters a final order with the full DIP credit agreement attached, the full TWCF as the approved budget, and the full set of lender protections. The TWCF therefore goes through at least two formal court approvals and many informal updates between filing and confirmation.
Variance reporting during the case. Once the DIP is in place, the company must report weekly variance against the TWCF. The DIP order sets permitted variance bands. Common structures:
| Variance Test | Common Threshold | Tested On | Effect of Breach |
|---|---|---|---|
| Operating disbursements | Cumulative actuals less than 110% of cumulative budget | Rolling 4-week basis | Event of default unless cured |
| Operating receipts | Cumulative actuals greater than 90% of cumulative budget | Rolling 4-week basis | Event of default unless cured |
| Net cash flow | Cumulative net cash flow no worse than budget by an absolute dollar threshold | Rolling 4-week basis | Event of default unless cured |
| Capex | Cumulative actuals less than 110% of budget | Rolling 4-week basis or cumulative case-to-date | Event of default unless cured |
| Professional fees | Cumulative actuals less than 110% of budget | Cumulative case-to-date | Event of default unless cured |
Common permitted-variance bands are 110% on disbursements and 90% on receipts (i.e., disbursements cannot exceed budget by more than 10%, receipts cannot fall below budget by more than 10%), tested on a rolling four-week cumulative basis. Some agreements use 120% bands on certain line items or impose 105% on operating disbursements with 110% on capex. Material breaches trigger lender consultation rights, milestone resets, or, in severe cases, events of default that would terminate the DIP and force the case onto an alternative path. Cure rights are typically narrow: the borrower has a few business days to demonstrate that a variance was driven by timing rather than substance, with no broad cure right.
The compliance test on each reporting date is a comparison of cumulative actuals against the cumulative approved budget over the rolling test window.
Sale processes and plan confirmation. If the case includes a Section 363 sale, the TWCF informs how long the company can run the marketing process and what the bid procedures and milestones must be to keep the company solvent through closing. At plan confirmation, the disclosure statement typically includes a longer-dated 2-3 year projection, but the near-term liquidity assumptions still trace back to the TWCF and its variance history. A debtor that has consistently met its TWCF has credibility at confirmation; one that has consistently missed has a much harder confirmation hearing.
Critical Vendor and Cash Collateral Mechanics
The TWCF must integrate with two Chapter 11 mechanics. First, the critical vendor budget: the debtor typically files a critical vendor motion at the first-day hearing requesting authority to pay pre-petition claims of designated suppliers in exchange for continued shipping on customary trade terms. The TWCF reflects this as a discrete line item, often capped at $25-100 million for mid-cap cases. Suppliers not on the list take their pre-petition claim as general unsecured. Modeling the post-petition AP aging cleanly (separating pre-petition trapped claims from post-petition obligations subject to administrative expense priority under Section 503(b)(9) for goods received within 20 days of filing) is one of the more technically demanding parts of a Chapter 11 TWCF.
Second, cash collateral mechanics: before a DIP is approved, debtors typically need authority to use cash collateral (cash deposits and receivables in which secured lenders have an interest) to fund operations. The cash collateral order at the first-day hearing incorporates the TWCF as the budget exhibit and grants pre-petition lenders adequate-protection liens, replacement liens, and superpriority administrative claims. Variance against the cash collateral budget can terminate the right to use cash collateral, forcing the company into a contested motion to continue operating.
Building a Useful TWCF in Practice
The mechanics of building a TWCF that survives stakeholder scrutiny are different from building a clean accounting model. Five practices distinguish a useful model from a brittle one:
- Anchor each line to a documentable source. AR aging by customer, AP aging by vendor, the payroll system, the lease schedule, the credit agreement, the capex authorization list. When a creditor's advisor challenges a number, the answer should be a screenshot of the source rather than a verbal explanation.
- Build downside scenarios from operational levers, not blanket haircuts. A useful downside case identifies specific operational risks (a major customer extending payment terms, a factor reducing the program limit, a critical vendor demanding COD) and quantifies the cash impact of each scenario rather than applying a 15% haircut across all collection lines.
- Reconcile to the bank statement weekly. Every Monday morning, reconcile the prior week's bank activity to the model and bridge any unexplained variance. Unexplained bridges are either cash management errors or signs the underlying business is not where management thinks it is.
- Document the assumptions. Maintain an assumptions tab that captures, line by line, the basis for each forecast: collection-rate assumptions by customer cohort, payment-term assumptions by vendor category, payroll cadence, scheduled debt service, capex commitment list. Without it, a model that needs to be rolled forward from week 13 to week 26 has to be re-derived from scratch.
- Manage the dual-track approach. By week three or four, the original TWCF will have hit unexpected variances. A TWCF that quietly recasts itself after the fact has lost its function as a forecasting tool. The right approach holds the original forecast in a frozen "approved budget" column, displays the variance, explains the operational driver, and presents an updated rolling forecast in a separate column. Most DIP orders contemplate this with weekly variance reports against the approved budget and four-weekly budget refreshes that become the new approved baseline.
What Distinguishes Strong RX Analysts on the TWCF
The difference between analysts who get staffed on flagship deals and those who do not is whether the model holds up under stress. Four practical skills separate them: forecasting collections by customer cohort rather than by blended DSO; modeling the corner cases (tax refunds, insurance recoveries, asset sale proceeds, sale-leaseback monetizations, tax-sharing payments) on realistic timing rather than aspirational; bridging weekly variances cleanly so that every dollar reconciles; and presenting the model in a one-page summary that captures the runway, the trough, the variance, and the key risks for readers who never touch the formula bar (CFO, board, bankruptcy lawyer, DIP lender's advisor, creditor committee).
The TWCF, in the end, is not just an analytical tool. It is the central operational document of any distressed engagement, the bridge between the company's day-to-day operations and the legal architecture of its restructuring, and the model on which every consequential negotiation in the case depends. The hours invested in building it well, updating it weekly, and bridging the variances cleanly compound across the engagement. The hours saved by building it lazily compound into bad outcomes that show up at the worst possible moments in the case, usually at the moment a variance covenant breach forces the DIP lender into a renegotiation that the company would have preferred to avoid.
Free Interview PDF Guide