4 min read
A 13-week cash flow forecast shows, week by week, how much cash will come in and go out of your business over the next quarter. Buyers and lenders ask for it because it reveals liquidity risk that annual statements hide. Building one before you go to market puts you in control of the story your numbers tell.
Why Buyers and Lenders Ask for a Rolling 13-Week View
Annual and monthly financials show where the business has been. A rolling 13-week forecast shows whether it can cover payroll, rent and debt service between now and closing.
During due diligence, a credible forecast reduces surprises and the price adjustments that follow them. It also signals that management understands its working capital, which supports a stronger business valuation.
Start With Clean Opening Cash and Real Receipts Data
Begin with the actual bank balance on the first day of the forecast, not the book balance. Then pull your accounts receivable aging and look at how quickly each major customer really pays.
Useful inputs include:
- Bank statements for the last 13 to 26 weeks
- Accounts receivable and accounts payable aging reports
- Payroll calendars and benefit due dates
- Loan agreements showing payment dates and covenants
Map Disbursements by Due Date, Not by Invoice Date
Cash leaves the business when a bill is paid, so schedule each outflow in the week it will actually clear. Payroll, rent, tax deposits and debt service go in first because they cannot slip.
Next, layer in vendor payments based on agreed terms. Finally, add one-time items such as equipment purchases, insurance renewals or deal-related professional fees.
Build the Weekly Template
Each week in the model needs four lines that tie together. Keep the structure simple so a lender can follow it in minutes.
- Beginning cash balance
- Total receipts for the week
- Total disbursements for the week
- Ending cash balance, which becomes next week’s beginning balance
Add a row for available borrowing capacity on your line of credit. This shows total liquidity, not just cash on hand.
Test the Forecast Against Reality Every Week
Each Monday, compare last week’s forecast to what actually happened and note the variance. Large misses usually point to optimistic collections or forgotten payables.
Roll the model forward by dropping the completed week and adding a new week 13. After a few cycles, your accuracy improves and your credibility with outside parties grows with it.
Use the Forecast to Strengthen a Sale or Refinancing
A reliable forecast lets you negotiate a working capital target with a buyer from a position of knowledge. It also helps you time a refinancing before a seasonal cash dip rather than during one.
The U.S. Small Business Administration recommends owners manage cash flow actively and prepare records well ahead of any sale of the business. Advisors experienced in M&A and capital solutions can pressure-test your assumptions before a buyer does.
Conclusion
A 13-week cash flow forecast is one of the simplest tools that a buyer or lender will trust. It exposes risk early, supports your valuation and gives you leverage in negotiations. If you want help building or reviewing one, our interim CFO services team at Tittle Advisory Group can work alongside you.
Frequently Asked Questions
What is a 13-week cash flow forecast?
It is a rolling weekly projection of cash receipts and disbursements covering one quarter. It shows whether the business can meet its obligations in the near term.
Why 13 weeks instead of monthly?
Weekly detail catches timing gaps, such as a payroll week before a large customer payment, that monthly totals hide. Thirteen weeks covers a full quarter while staying accurate.
How often should the forecast be updated?
Update it weekly by comparing actual results to the forecast and adding a new week at the end. This rolling approach keeps it current throughout a sale or refinancing.
Do lenders require a 13-week forecast?
Many lenders request one during refinancing, especially when covenants are tight or performance has changed. Having it ready speeds up the process and builds confidence.