13-Week Cash Flow Forecasting for PE-Backed Companies

A PE-backed company can hit its EBITDA plan and still run short of cash. Debt service, earnouts, working capital swings, and capital spending move cash on a different schedule than the P&L, and leverage leaves less room when that timing goes wrong.

A 13-week cash flow forecast is a tool most sponsors and lenders rely on to see the timing. It covers a full quarter, week by week, and it’s built on the direct method: the cash the company expects to receive and pay out, by date.

So let’s talk about when a portfolio company needs one, how to build it, how to keep it accurate, and how sponsors use it once it’s running.

When a portfolio company needs a 13-week forecast

Some companies run one permanently. Others build one when something changes, such as:

  • Covenant headroom getting thin
  • A large add-on closing, earnout, or deferred consideration payment coming due
  • Customer collections slowing down
  • Seasonal working capital needs, such as an inventory build or a large project starting
  • A lender request, often during an amendment or refinancing
  • The first 100 days after close, before monthly reporting is fully in place

Our thought is that any company carrying meaningful debt should run one continuously. Once it’s built, it takes a few hours a week to maintain, and it gives management a week-by-week view the monthly close can’t provide.

What the forecast looks like

A 13-week forecast usually fits on 1 tab, with 13 weekly columns and a column comparing last week’s forecast to actual. The rows follow cash from the beginning balance to the ending balance:

Beginning cash

  • Receipts: customer collections, broken out by major customers or aging bucket, and any other available receipts
  • Operating disbursements: payroll by pay date, vendor payments, rent, benefits, insurance, and taxes
  • Non-operating items: interest and principal, capital expenditures, earnouts, sponsor fees, and distributions

Ending cash

  • Revolver availability and total liquidity
  • Minimum liquidity threshold, or the covenant line the company needs to stay above
  • Keep it short enough that someone can review it in 15 minutes. A forecast with 200 rows tends to stop getting reviewed by week four.

Build receipts from the AR detail

Collections are the hardest line to forecast and the one that moves the ending balance most. Start with the receivables aging and the company’s actual payment history:

  • Pull 6 to 12 months of payment history and calculate average days to pay for each of the top 10 to 20 customers.
  • Apply that timing to open invoices and to the billings you expect over the next 13 weeks.
  • Forecast smaller customers together, using historical collection patterns.
  • Flag known issues: disputed invoices, customers on payment plans, and large customers who pay on a quarter-end cycle.

A single DSO applied to the whole receivables balance hides the timing that matters most. If the largest customer pays on day 60 and makes up 18% of receivables, that one payment can decide whether a given week is comfortable or requires a revolver draw.

Build disbursements from the calendar

Disbursements are easier to predict, as long as each one is tied to the date it actually leaves the bank:

  • Payroll: by pay date, with payroll taxes and benefits, including the months with 3 pay dates on a biweekly cycle
  • Vendors: from the open payables list and the company’s payment run schedule, with any recent changes to vendor terms
  • Fixed costs: rent, insurance, and software subscriptions on their real due dates, including annual and quarterly payments
  • Taxes: estimated income tax payments and sales tax remittances
  • Debt: interest and amortization dates from the credit agreement
  • One-time items: capital spending, earnouts, transaction fees, and severance

Annual payments are the ones most often missed. An insurance renewal or a software contract paid once a year can be a large number in a single week.

Compare forecast to actual every week

The forecast earns its keep through the weekly update. Each week, the owner should:

  • Drop the completed week and add a new week 13
  • Compare last week’s forecast to actual, line by line
  • Explain any variance above an agreed threshold
  • Note whether each variance is timing that will reverse or a permanent change

After a couple of months, the variance history shows where the forecast is consistently off. It’s usually collections from a handful of customers, and the assumptions for those customers can be adjusted. A reasonable target is ending cash within 5% of forecast at a 4-week horizon.

Tie it to the monthly forecast

The 13-week forecast is built from cash activity, and the company’s monthly forecast is usually built from the P&L and balance sheet. The two should land in roughly the same place at each month-end. When they don’t, the gap usually points to a working capital assumption that one model has and the other doesn’t.

The monthly forecast also covers what the 13-week view can’t: the rest of the fiscal year and the quarterly covenant tests beyond the 13-week window.

How sponsors use it

For the sponsor, the 13-week forecast answers the questions that come up between board meetings:

  • Liquidity: how close the company will get to its minimum cash level, and when
  • Covenants: whether liquidity or fixed charge coverage tests are at risk in the coming quarter
  • Timing decisions: when an add-on can close, when capital spending can go ahead, and whether a distribution makes sense
  • Lenders: many lenders ask for a 13-week forecast during an amendment, a waiver, or a refinancing

A weekly or biweekly 15-minute review with the sponsor is usually enough: ending cash by week, the largest variances, and anything unusual in the next four weeks.

What a tight week looks like

Example: a company starts the month with $2M in cash and has to keep at least $1.5M on hand under its credit agreement. In week two, a $600K biweekly payroll goes out on the same Friday as a $350K quarterly interest payment. The largest customer owes $900K and usually pays around day 55, which lands in week three. Collections from smaller customers roughly cover the regular vendor payments that week.

Looked at monthly, the business is fine, since the large customer payment covers payroll and interest with room to spare. Week by week, cash falls to about $1.05M at the end of week two, which is below the minimum, and it stays there until the customer pays.

With a 13-week forecast in place, the finance team sees that week coming six or more weeks out. They can move a vendor payment run, or plan a small revolver draw ahead of time and tell the lender. Without the forecast, the team usually finds out from the bank balance.

Common mistakes

  • Building it from P&L projections. The forecast has to come from expected cash in and out, by date.
  • Missing non-operating items. Earnouts, annual premiums, and tax payments are the usual misses.
  • Letting it go stale. A forecast that isn’t rolled forward weekly loses its value within a month.
  • No owner inside the company. When an outside advisor builds the forecast and nobody on the team maintains it, it tends to stop when the advisor leaves.
  • Too much detail. More rows rarely mean more accuracy. Focus the detail on the largest customers and the largest payments.

FAQ

How long does it take to build a 13-week cash flow forecast?

For a single entity with clean receivables and payables data, 1 to 2 weeks. Companies with multiple entities, several bank accounts, or messy customer payment data can take 3 weeks or more. The first few weekly updates usually take longer while the team settles into the routine.

Do we need software, or is Excel enough?

Excel works for most single-entity portfolio companies. Dedicated cash forecasting software starts to pay off when there are multiple entities, many bank accounts, or a need to pull bank data automatically every day.

Who should own the forecast?

Usually the controller or FP&A lead, with the CFO reviewing it weekly. It should sit with someone close enough to collections and payables to know when a large customer is running late or a vendor is pushing for faster payment.

How is a 13-week forecast different from a monthly cash flow forecast?

The 13-week forecast is built week by week from expected receipts and payments. A monthly forecast is usually derived from the P&L and balance sheet. The weekly version catches timing problems inside a month, such as a payroll and an interest payment landing in the same week before a large customer pays.

How accurate should the forecast be?

Within 5% of actual ending cash at a 4-week horizon is a reasonable target once the forecast has been running for a couple of months. Weeks 9 through 13 will always be less precise, and that’s expected.

Should we share it with our lenders?

If the credit agreement or an amendment requires it, yes. If it doesn’t, many sponsors still share it when liquidity is tight, because it shows the company is watching cash closely. Once you start sharing it, keep the format and timing consistent from week to week.