What a 13-Week Cash Flow Forecast Can Tell You About Your Business

An annual budget may show that a business is profitable, but it cannot always tell management whether there will be enough cash to make payroll three weeks from now. That is where a 13-week cash flow forecast becomes useful.

The forecast provides a short-term view of expected cash receipts and payments, normally organized by week. Thirteen weeks is long enough to identify developing cash pressure while remaining close enough to the present for the assumptions to be reasonably specific.

How it differs from a profit-and-loss projection

A profit-and-loss statement records revenue when it is earned and expenses when they are incurred. A cash flow forecast focuses on when money is actually expected to enter or leave the bank account.

If a customer is invoiced today but will not pay for 45 days, the sale may appear in the income statement before the cash becomes available. Similarly, loan principal payments, equipment purchases and certain tax payments use cash even though they may not appear as operating expenses.

A 13-week forecast begins with available cash and tracks expected receipts and disbursements. Typical categories include:

• Customer collections

• Cash sales

• Payroll and payroll taxes

• Vendor payments

• Rent and occupancy costs

• Loan payments

• Taxes

• Capital expenditures

• Owner contributions or distributions

The result is a projected weekly cash balance that shows when liquidity may become tight.

Why lenders may require it

Most commercial lenders require borrowers to provide financial information as part of regular loan servicing. Depending on the loan, this may include annual financial statements, tax returns, interim financial statements, borrowing-base reports or compliance certificates.

A 13-week cash flow forecast is not required for every performing loan. It is more likely to be requested when a company is experiencing liquidity pressure, has missed its projections, is seeking a restructuring or requires closer monitoring.

In those situations, the lender needs more than an annual budget. It needs to understand whether the borrower can meet payroll, pay critical vendors, maintain operations and make scheduled debt payments over the coming weeks.

The forecast also gives the lender a way to compare actual performance with management’s expectations and identify problems before they become more difficult to address.

What the forecast can reveal

A 13-week forecast can identify a cash shortage before it becomes an emergency. It can show whether the business needs to accelerate customer collections, delay a discretionary purchase, negotiate vendor terms or obtain additional working capital.

It can also help management decide which payments must be made immediately and which can be scheduled around expected receipts.

The forecast should be updated each week by replacing projected amounts with actual results and adding another week to the end of the schedule. Over time, the differences between forecast and actual performance help management improve its assumptions and understand the company’s collection and payment patterns.

A company does not need to be in financial distress to benefit from this process. Any business with seasonal revenue, uneven collections, rapid growth or limited cash reserves can use a 13-week forecast to make better short-term decisions.