What is a 13-week cash flow model?

A 13-week cash flow model (also called a 13-week cash flow forecast or TWCF) is a short-term liquidity management tool that projects cash inflows and outflows week by week for a 13-week (3-month) horizon. It is the standard tool used in distressed situations (required by lenders), during M&A transactions, and in treasury departments for near-term liquidity visibility. It uses the direct method — actual cash receipts and disbursements, not accrual P&L — and is updated weekly with actual data.

What is the difference between direct and indirect method cash flow forecasting?

The indirect method (used in the statutory cash flow statement) starts from net income and adjusts for non-cash items and working capital changes to arrive at operating cash flow. It is backward-looking and used for reporting. The direct method forecasts actual cash receipts (collections from customers) and actual cash disbursements (vendor payments, payroll, rent, taxes) week by week. Treasury uses the direct method for forward-looking liquidity management because it shows the exact timing of cash movements.

How does AI help with cash flow forecasting?

Claude with ClaudeFinLab builds the 13-week cash flow model structure, computes DSO-based collections schedules from AR aging, projects payables disbursements from DPO and AP aging, models seasonal patterns, runs liquidity stress tests (minimum cash floor analysis), and identifies weeks where cash may fall below covenant minimums. It turns weekly cash receipts/disbursements data into a structured forecast with variance tracking.

AI for Cash Flow Forecasting: 13-Week Cash Flow and Liquidity Planning with Claude (2026)

How treasury and FP&A teams use Claude AI for cash flow forecasting: 13-week cash flow model structure, DSO-based collections scheduling, AP disbursements forecasting, liquidity stress testing, and working capital optimization.

Cash Flow Forecasting and AI

A 13-week cash flow model is the most operationally critical forecast in treasury. Built in Excel with manual data collection from AR, AP, payroll, and tax teams, it typically takes 1-2 days per week to update. Claude with ClaudeFinLab structures the model, automates the collections schedule from AR aging data, and runs liquidity stress tests — compressing the weekly update cycle from hours to minutes.

Collections Schedule from AR Aging

"Build the weekly collections forecast from this AR aging report: Current (0-30 days) $3.2M — historical collection rate 92% within 2 weeks (Week 1: 60%, Week 2: 32%); 31-60 days $1.8M — collection rate 85% within 3 weeks (Week 1: 25%, Week 2: 35%, Week 3: 25%); 61-90 days $0.9M — collection rate 70% within 4 weeks; 90+ days $0.4M — collection rate 40% (bad debt provision 60%). Project weekly cash receipts for Weeks 1-8. Total expected collections: $5.8M. Bad debt write-off recommendation: $0.24M (60% × $0.4M)."
"Adjust the collections schedule for seasonal payment patterns: Q4 collections in this B2B SaaS business are typically 35% higher than Q1-Q3 (annual renewal bulge). We are currently in Week 1 of Q4. Apply a 35% uplift to the base collections forecast for the next 8 weeks, then model weeks 9-13 at normal base rates as the renewal cohort clears. Show the impact on weekly minimum cash balance."

Disbursements Schedule

"Build the weekly disbursements forecast: (1) Payroll: $1.2M bi-weekly (next payment Week 2, then Week 4, 6, 8, 10, 12); (2) Rent: $180K on the 1st of each month (Week 1 and Week 5); (3) Vendor AP: current AP outstanding $4.5M, DPO 45 days — project weekly vendor payments based on $1.2M weekly AP accrual and 45-day payment terms; (4) Federal income tax: $420K due Week 6 (estimated tax payment); (5) TLB interest: $1.85M due Week 8; (6) Capex: $250K equipment payment in Week 3. Build the full 13-week disbursements schedule."

Liquidity Stress Testing

"Run a liquidity stress test on the 13-week forecast: base case ending cash $8.2M (Week 13). Stress scenario: (1) collections lag by 1 week across all customers (customers pay one week later than forecast); (2) 2 large customers (combined $1.8M AR) require 90-day payment extension; (3) an unexpected $500K legal settlement payment in Week 7. Recompute ending cash: $8.2M - $1.8M (slow customers) - $0.5M (legal) = $5.9M. What is the minimum weekly cash balance in the stress scenario? Is it above the credit agreement minimum liquidity covenant of $5.0M?"
"Identify the minimum cash trough in the 13-week forecast: starting cash $6.5M. Weekly net cash flows (Week 1 through Week 13): -$420K, -$1.2M, -$180K, +$1.8M, -$1.4M, -$420K, +$2.1M, -$1.85M, +$1.4M, +$0.8M, -$1.2M, +$1.4M, +$0.8M. Compute cumulative cash balance each week. Identify the minimum cash week (trough). If trough is below $3.0M liquidity covenant, how much revolver capacity is needed to cover the gap?"

Working Capital Optimization

"Model the cash impact of reducing DSO from 62 to 45 days: current annual revenue $52M, so current AR outstanding = $52M × 62/365 = $8.84M. At 45-day DSO: AR = $52M × 45/365 = $6.41M. Cash release from DSO reduction: $8.84M - $6.41M = $2.43M one-time cash inflow (over the transition period). If we can achieve this over 60 days through an AR factoring facility (cost: 1.5%/month on sold AR, max $3M facility), what is the net cash benefit vs. cost of the facility?"

Where to Start

Paste your current AR aging by bucket (0-30, 31-60, 61-90, 90+) and ask Claude to build a collections schedule with your historical collection rate assumptions. Separately, list your fixed disbursements (payroll dates, rent, interest payments) and ask Claude to build the disbursements schedule. Combine them for the 13-week net cash flow. That 30-minute exercise replaces a half-day of manual modeling.

Get your free API key