Cash

The 13 week cash flow forecast: how to build one and keep it honest

A 13 week cash flow forecast shows, week by week, how much cash a business will have over the next quarter. Here is how to build one, a worked example in pounds, the mistakes that make forecasts useless, and when lenders will ask to see it.

By Christopher Fagan, Managing Partner, PEF Consulting Partners

£13bnlargest programme delivered
£25msaving on the BP Pulse rollout
£160m+billing imbalance recovered
5 continentsdelivered across

Delivered for and alongside

ShellBPCapitaBaringaOfgemSmart DCCInsightsFlui TechnologiesExxonMobilVodafoneConstellation SoftwareDeloittePwCEYNational GridElexon

What a 13 week cash flow forecast is, and why 13 weeks

A 13 week cash flow is a rolling weekly forecast of cash in and cash out, starting from the actual bank balance today. It is built using the direct method: real receipts from customers, real payments to suppliers, staff, HMRC and lenders, in the week the money is expected to move. It is not the same as the cash flow statement in the annual accounts, which is built backwards from profit, and it is not a monthly budget.

Thirteen weeks is one quarter. That length works for three reasons:

  • It covers a full cycle of the big regular payments: a monthly payroll three times, monthly PAYE, a VAT quarter, quarterly rent in most leases, and loan interest.
  • It is long enough to see a problem coming and do something about it, such as chasing a debtor, moving a payment run or talking to the bank.
  • It is short enough that the numbers are based on real invoices, orders and payment terms rather than guesses.

Every week the oldest week drops off, actuals replace the forecast, and a new week thirteen is added at the end. That rolling habit is what makes it useful. A forecast built once and left alone is out of date within a fortnight.

The forecast answers a few plain questions. Can we pay the next three payrolls? When is our lowest cash point, and how close is it to the overdraft limit or a covenant? Which customers matter most to that low point? What happens if the biggest of them pays two weeks late?

How to build a 13 week cash flow forecast step by step

You can build a perfectly good forecast in a spreadsheet. The discipline matters more than the tool.

  1. Set the scope. Decide which companies and bank accounts are included. If cash moves between group companies, show those transfers on their own lines.
  2. Start from reconciled cash. Week one opens with the actual cleared bank balance, not the figure in the ledger.
  3. Forecast receipts customer by customer. For the largest customers, list open invoices and expected payment dates based on how they actually pay, not on the terms printed on the invoice. Group the smaller ones and apply their real average collection days. Only count new sales once they are invoiced and the payment timing is known.
  4. Forecast payments by type. Payroll first, because it is fixed and cannot slip. Then PAYE and National Insurance, VAT, rent, loan interest and capital repayments, and then supplier payment runs based on the creditors ledger and committed orders.
  5. Keep financing separate. Show facility drawings, repayments and any new money on separate lines so the board can see trading cash on its own.
  6. Keep the line count short. Twenty to thirty lines is usually enough. More than that and nobody reads it.
  7. Add headroom and a variance column. Show the closing balance against the overdraft limit or minimum liquidity covenant each week, and record last week’s forecast against actual from day one.

One person should own the forecast, with named people supplying the receipts and payments inputs. If it lives in one person’s head, it stops the week they are on holiday.

An illustrative worked example in pounds

Illustrative example only. The business and figures below are invented to show how the forecast reads. They are not from any client.

A distributor opens week one with £420,000 in the bank. It collects around £270,000 to £310,000 a week from customers, pays suppliers £150,000 a week, and has £35,000 a week of other running costs. Its monthly payroll of £260,000 falls in week four.

  • Week 1: opening £420,000, receipts £310,000, suppliers £150,000, other costs £35,000. Closing £545,000.
  • Week 2: opening £545,000, receipts £290,000, suppliers £150,000, VAT £120,000, other costs £35,000. Closing £530,000.
  • Week 3: opening £530,000, receipts £280,000, suppliers £150,000, PAYE and National Insurance £85,000, quarterly rent £90,000, other costs £35,000. Closing £450,000.
  • Week 4: opening £450,000, receipts £270,000, suppliers £150,000, payroll £260,000, loan interest £40,000, other costs £35,000. Closing £235,000.

On a monthly view this business looks fine: it ends the month with more than half its opening cash. The weekly view shows something different. Receipts are falling week on week, and if that trend continues into weeks five to eight, the next payroll pushes the balance close to the £100,000 minimum the lender requires.

That is the point of the exercise. With several weeks of warning, management can chase the three largest overdue debtors, agree a later date for a large supplier payment, or talk to the bank about headroom before the lender has to ask.

Running the forecast every week

The value of a 13 week cash flow comes from the weekly cycle around it. A simple routine that we see work:

  1. Monday: replace last week’s forecast with actual receipts and payments from the bank.
  2. Explain the variances. For each material difference, decide whether it was timing (the cash will still come, just later), amount (it will not come in full) or a wrong assumption (the method needs changing).
  3. Update the remaining weeks for anything the variances tell you, and add the new week thirteen.
  4. Hold a short cash meeting with the finance director and the people who own collections and purchasing. Agree actions with names against them.
  5. Send a one page summary to the board or lender: closing balance by week, the lowest point, headroom against limits and the main changes since last week.

Accuracy should be judged honestly. Weeks one and two should be very close to actual. Weeks three to six depend heavily on collections. Weeks seven to thirteen show direction rather than precision. If the near weeks are regularly wrong by a wide margin, the method needs fixing before anyone relies on the later weeks.

Many businesses find the forecast also exposes wider process problems, such as invoices raised late or purchase orders raised after the goods arrive. Those are worth fixing at source, and our guides to order to cash and procure to pay explain where to start.

Common mistakes that make a cash forecast useless

Most forecasts that fail do so for the same handful of reasons.

  • Using due dates instead of real payment behaviour. If a customer always pays at 60 days on 30 day terms, forecast 60.
  • Counting the sales pipeline as cash. Orders not yet won, delivered or invoiced do not belong in the near weeks.
  • Starting from the ledger, not the bank. Unreconciled items make the opening balance wrong and every week after it.
  • Forgetting the lumpy payments. VAT quarters, annual insurance, rent quarter days, bonuses and capital repayments are the ones that cause the nasty surprises.
  • Hiding financing inside trading lines. If a facility drawing is netted into receipts, the board cannot see whether the business is generating cash or borrowing it.
  • No variance review. A forecast that is never compared to actual never gets better.
  • Letting the cadence slip. Updated every other week, then monthly, then when someone asks. By then it is a history document.
  • Optimism under pressure. When cash is tight, people forecast what they hope will happen. The person who owns the forecast needs to be able to say no.

If several of these sound familiar, the forecast is not the only problem. It usually means management information more widely needs attention, and that is often where a root cause analysis is a better starting point than another spreadsheet.

When lenders and others ask for a 13 week cash flow

A 13 week forecast is one of the first things lenders, their advisers and investors ask to see when they become concerned about a business. The common triggers are:

  • A covenant breach, or a forecast breach, on a loan or facility.
  • A request for more headroom, a waiver or an amendment to existing terms.
  • A refinancing, where the new lender wants to see short term liquidity as well as the longer plan.
  • An asset based lending facility, where availability is tied closely to debtors and stock.
  • A private equity owner reviewing a portfolio company that is behind plan.
  • The start of a turnaround or a restructuring, where every decision depends on knowing how long the cash lasts.

When a forecast is going to a lender, it needs to reconcile to the bank and management accounts, state its key assumptions plainly, and come with a record of how accurate previous versions were. A forecast with a track record carries far more weight than a polished one produced for the first time.

Directors have a further reason to keep one. When a company is in financial difficulty, directors need to show they understood the cash position and acted on it. A forecast updated weekly, with minutes of the decisions taken, is good evidence of that. Directors who are worried about solvency should take advice from a licensed insolvency practitioner or lawyer. PEF does not give that advice, but we help businesses build and run the forecast as part of our business turnaround consulting and restructuring advisory work.

Related reading: Business turnaround consulting, Restructuring advisory, Business turnaround strategy: the stages that work, Finance transformation, Order to cash explained.

Common questions

What is a 13 week cash flow forecast?

It is a rolling weekly forecast of cash receipts and payments over the next 13 weeks, starting from the actual bank balance. It uses the direct method, so it shows real money moving in the week it is expected, rather than profit. Each week, actuals replace the oldest forecast week and a new week is added at the end, so it always looks a full quarter ahead.

Why 13 weeks rather than a month or a year?

Thirteen weeks is a quarter, which captures a full cycle of payroll, PAYE, a VAT quarter and quarterly rent. It is long enough to give management time to act on a problem and short enough that the figures are based on actual invoices, orders and payment terms. Longer term planning still needs a monthly forecast, but the 13 week view is the one that protects liquidity.

Can I build a 13 week cash flow forecast in Excel?

Yes, and most businesses start that way. A well structured spreadsheet with twenty to thirty lines, a reconciled opening balance and a variance column is enough for a single company with one bank account. Software becomes worthwhile when there are several entities or currencies, a large number of customer invoices, or several people updating the forecast each week.

How accurate should a 13 week cash flow forecast be?

The first two weeks should be very close to actual, because the receipts and payments are already known. Weeks three to six depend mostly on how reliably customers pay. Weeks seven to thirteen show the direction of travel rather than an exact figure. Track forecast against actual every week, and if the near weeks are often wrong, fix the method before relying on the later weeks.

Who should own the cash flow forecast?

One named person in finance, usually the financial controller or finance director, should own it and be accountable for its accuracy. Others supply inputs, such as credit control for receipts and purchasing for committed spend. The owner needs the authority to challenge optimistic inputs, and there should be a second person who can run it if the owner is away.

Do you know your lowest cash point in the next quarter? If the answer is not a confident yes, talk to us about building a forecast your board and lenders can rely on.

Book a confidential conversation

PEF TRACK RECORD£13bnLargestprogramme led5Continentsdelivered across19 yrsSystems delivery£25mLargestsingle saving

Consultancy from PEF

Independent, client side support when the business is off plan or changing shape: business turnaround, restructuring advisory, chief transformation officer, centres of excellence, shared services and gbs, asset management, hedge funds, oil and gas, portfolio company turnaround. For our fees see pricing.

CF

Written by Christopher Fagan

Managing Partner, PEF Consulting Partners

Christopher has led systems and transformation delivery for 19 years, including the National Grid separation, the £9bn Energy Bills Support Scheme and the BP Pulse EV charging rollout.