Most companies that run into cash trouble don't fail because they were unprofitable. They fail because the cash ran out on a specific Tuesday — payroll due, a tax payment landing, a large customer paying two weeks late — and nobody saw the collision coming.
The instrument that prevents exactly this is the 13-week cash flow forecast: a rolling, weekly projection of every dollar entering and leaving the business over the next quarter. It is the standard tool of restructuring professionals and CFOs for one reason — it works.
Why 13 weeks, and why weekly
Thirteen weeks is one quarter. It is long enough to see the next VAT or payroll-tax deadline, the seasonal dip, the large invoice that lands in week 11 — and short enough that every line can be a real, named payment rather than a statistical guess.
The weekly grain is what makes it operational. A monthly cash forecast can look healthy while hiding a fatal week inside it: month-end shows a positive balance, but in week 2 payroll went out before your biggest customer paid. Companies don't run out of cash at month-end. They run out of cash on a Thursday.
How to build one: the structure
The model itself is simple. One column per week, thirteen weeks forward, three blocks of rows:
- Cash in — customer collections (by invoice, with realistic payment dates — not due dates), other operating receipts, financing inflows. The discipline is to schedule each receivable on the date the customer actually pays, based on their history.
- Cash out — payroll and social charges, suppliers (by payment run), rent, taxes (VAT, corporate installments, withholdings), debt service, capex. Fixed obligations first — they are the ones that cannot slip.
- The bridge — opening cash + inflows − outflows = closing cash, per week. Add your minimum operating cash cushion as a line, and the distance between closing cash and that cushion is your real margin of safety.
Then it rolls: every week, drop the week that just ended, add a new week 13, and — critically — compare last week's forecast to what actually happened. The forecast-versus-actual variance is where the learning is. After six or eight cycles, your collection assumptions stop being hopes and start being data.
The five mistakes that kill most cash forecasts
1. Using due dates instead of payment behavior. If a customer pays at 75 days against 60-day terms, modeling 60 days manufactures cash that will not arrive.
2. Forgetting the lumpy items. Quarterly tax installments, annual insurance premiums, bonus payments. Monthly averages smooth these into invisibility; the weekly grid exposes them.
3. Building it once and letting it die. A 13-week forecast that isn't refreshed weekly is a photograph, not an instrument. The value is in the rolling discipline.
4. Treating it as a finance-only document. The forecast changes decisions — when to schedule a supplier run, whether to accept a large order with 90-day terms, when a credit line needs to be drawn before the bank sees you desperate. Those are management decisions.
5. No scenario view. One version is not enough. A base case, a downside (your two largest customers pay 30 days late), and a stressed case tell you where the floor is — and how many weeks of warning you get before you hit it.
What it changes in practice
A well-run 13-week forecast typically surfaces three things within the first month:
- The real collection cycle — which customers structurally fund your business and which ones consume it.
- The concentration of risk — the specific weeks where payroll, taxes and supplier runs coincide, and how thin the cushion actually is in those weeks.
- Negotiating room — with visibility, you can move a supplier run one week, pull a collection forward with a small discount, or time a credit-line draw deliberately. Without visibility, you do all of this in crisis mode, at the worst possible price.
From spreadsheet to system
A spreadsheet is the right place to start — and the wrong place to stay. Manual forecasts decay: the person who built it leaves, the links break, the weekly refresh slips to monthly, and the instrument dies quietly.
The durable version is a forecast wired into your accounting and banking data: collections scheduled from real invoice behavior, fixed obligations loaded from the payment calendar, variances computed automatically every week. That is the difference between a report someone maintains and a system the business runs on.
This is precisely the instrument we build inside every engagement at Primus Pilus Capital — a rolling 13-week cash forecast is a standing deliverable of both our Profit Engine and Cash-Flow Systems tracks, refreshed weekly, with scenarios and board-ready reporting on top.
Frequently asked questions
What is a 13-week cash flow forecast?
A rolling, weekly projection of all cash entering and leaving a business over the next 13 weeks (one quarter). Each week it is refreshed: the completed week is dropped, a new week 13 is added, and forecast is compared against actuals. It is the standard cash-visibility instrument used by CFOs and restructuring professionals.
Why 13 weeks instead of a monthly forecast?
Thirteen weeks covers a full quarter — long enough to capture tax deadlines, payroll cycles and seasonality — while the weekly grain exposes the specific weeks where payments collide. A monthly forecast can show a healthy month-end balance while hiding a mid-month week where payroll goes out before a large customer pays.
What information do you need to build one?
Opening bank balance, accounts receivable with realistic payment dates based on each customer's actual behavior, accounts payable and supplier payment runs, payroll and social charges, tax calendar (VAT, installments, withholdings), debt service, and planned capex. The model itself fits in a spreadsheet: one column per week, cash in, cash out, and the weekly bridge to closing cash.
How often should the forecast be updated?
Weekly, without exception. The value comes from the rolling discipline: comparing last week's forecast to actuals, correcting collection assumptions, and always looking 13 weeks ahead. A forecast that is not refreshed weekly decays into a snapshot within a month.
Who builds and runs this at Primus Pilus Capital?
A rolling 13-week cash flow forecast is a standing deliverable of every Primus Pilus Capital engagement — set up during the fixed-price Diagnostic stage ($490, credited in full against Stage 02) and operated weekly in the Operate stage, with scenario views and board-ready reporting.