Excel workbook preview13-Week Cash Flow Forecast Template
3 free downloads per account. Just your email and a 6-digit code.
About this template
A 13-week cash flow forecast shows, week by week for one quarter, how much cash comes in, how much goes out and what is left at the end of each week. Lenders ask for it when covenants tighten, boards ask for it when a large payment or a seasonal dip is coming, and new owners ask for it in the first week. It is a direct, receipts-and-payments view, so it is built from bank activity rather than from the income statement.
This workbook has a Forecast sheet with thirteen weekly columns for an invented manufacturer, formulas that roll each closing balance into the next week, and a revolving credit line that draws and repays itself to protect a minimum cash buffer. A variance sheet compares each week's actual receipts and payments with the forecast, and an assumptions sheet records the basis for every line. It rests on general treasury practice and needs no paid standard.
Who it is for
The controller or CFO whose lender, board or new owner asked for a rolling 13-week cash forecast by Friday.
What is inside
- Forecast sheet with 13 weekly columns, 4 receipt lines and 8 disbursement lines, worked for an invented manufacturer
- Week-ending dates, opening and closing cash all driven by formulas from one start date and one opening balance
- Automatic revolver draw and repayment that keeps closing cash at the minimum buffer, capped at the undrawn facility
- Total liquidity, cushion over the buffer and a Red, Amber or Green status for every week
- Key figures block: lowest closing cash, the week it falls, peak revolver balance and weeks in Red
- Actual vs Forecast sheet for 13 weeks with variance, variance % and an Explain flag against your tolerance
- Assumptions sheet with 12 line-by-line forecast bases, data sources and owners
- How to use sheet; every input cell is yellow and every output is a live formula
How to use it
Enter the Monday of week 1 and today's opening cash in the yellow input cells, then replace the sample receipts and disbursements line by line.
Files
- XLSX13-week-cash-flow-forecast-template.xlsx17 KB
Opens in Microsoft Word or Excel, Google Docs or Sheets, and LibreOffice. Based on general finance practice, not on one published standard. A template to adapt, not legal, tax or accounting advice.
Questions about this template
Why 13 weeks and not a month or a year?
Thirteen weeks is one quarter. It is short enough to forecast from known invoices, payroll dates and supplier runs, and long enough to show the next quarter-end, covenant test or seasonal low point. Many lenders and turnaround advisers ask for this horizon because weekly detail exposes timing problems that a monthly forecast hides.
How does the revolver line in the template work?
When closing cash before financing falls below the minimum buffer, the sheet draws the shortfall from the revolving facility, up to the undrawn amount. When cash is above the buffer and a balance is outstanding, it repays down to the buffer. If the facility is exhausted, the week turns Red.
How often should the forecast be updated?
Most finance teams roll it forward every week. They enter last week's actuals on the variance sheet, explain any difference above the tolerance, drop the completed week and add a new week 13. Variances that repeat in the same line point to a forecasting assumption that needs to change.



