What you get
- Mollisio_13-Week_Cash_Flow_Forecast_BLANK.xlsx — the working model for your business.
- Mollisio_13-Week_Cash_Flow_Forecast_SAMPLE.xlsx — the same model, filled in for a fictional coffee roaster, so you can see what it looks like when it's working.
- This guide.
The workbook runs in Microsoft Excel 2016 or newer, Excel for the web, and LibreOffice. Google Sheets works too. The model uses no macros.
Why 13 weeks
A 13-week forecast covers one quarter, week by week. That's short enough to predict with reasonable accuracy and long enough to spot a cash crunch while you still have time to act: pushing back a purchase, chasing an invoice, talking to your bank, or timing a draw on your credit line. Lenders, turnaround advisors and CFOs use the same tool.
How the workbook is organized
| Tab | What you do there |
|---|---|
| Start Here | Read the five-step overview and color key |
| Setup | Enter your start date, opening cash, minimum cushion, collection pattern, inventory and line of credit settings, and optional stress-test adjustments |
| Receipts | Enter expected weekly sales, collections on invoices you already have, and other cash coming in |
| Payments Schedule | List each recurring or one-time payment once; the weekly grid fills automatically |
| 13-Week Forecast | Review the full weekly cash flow statement (calculated, no inputs) |
| Dashboard | See ending cash, the low point, risk flags and the cash chart |
| Actual vs Forecast | Record what actually happened each week and compare it to the forecast |
Color key: blue text is an input, black text is a formula, green text is a direct link from another tab, and a yellow fill marks a key assumption. Only change blue cells.
Step-by-step setup (about 45–60 minutes the first time)
Step 1: Setup tab
- Business name.
- Forecast start date: pick a Monday. Week 1 runs from that Monday through the following Sunday. The check at the bottom of the tab confirms the date is a Monday.
- Opening cash balance: the total of your operating bank accounts on the start date. Don't count money you can't spend, like a tax reserve you've already set aside.
- Minimum cash cushion: the lowest balance you're comfortable holding. If you're not sure, start with two to four weeks of typical payments.
- Sales and collections: - Share of sales paid at the time of sale: card, cash and other same-day payments. - The rest of your sales are treated as invoices. Enter the percentage of invoiced sales you typically collect in the same week, 1 week later, 2 weeks later, and so on up to 4 weeks. Base these on your actual history; your accounting software's A/R aging report is a good place to look. - Anything not collected within 4 weeks shows as "Uncollected." The model treats it as slow-paying and leaves it out of this forecast, which keeps the forecast conservative.
- Inventory and materials: the percentage of sales you spend on goods you resell or materials you use, and how many weeks after the sale you pay for them (0–4). Service businesses can enter 0%.
- Line of credit: your limit, current balance and interest rate. Then choose whether the model should automatically draw on the line to keep you at your cushion, and automatically repay it with extra cash. Enter a limit of 0 if you don't have a line.
- Stress test: leave both adjustments at 0% for your base case (see "Stress-testing your plan" below).
Step 2: Receipts tab
- Forecast sales: total expected sales for each week, across all channels. Last year's same weeks, adjusted for growth or known changes, are a good starting point. Watch for holidays and seasonal swings.
- Collections of receivables you already have: open invoices from before the start date. Use your A/R aging report and put each invoice in the week you realistically expect payment, not the due date.
- Other receipts: loan proceeds, owner contributions, tax refunds, asset sales and similar cash coming in.
Step 3: Payments Schedule tab
Enter each payment once:
| Column | What to enter |
|---|---|
| Payee / description | Anything that helps you recognize the payment |
| Category | Pick from the drop-down. This controls where the payment appears on the forecast. |
| Amount | The amount of each individual payment |
| Frequency | Weekly, Biweekly, Monthly, Quarterly or One-time |
| First payment date | The date of the next payment. For Monthly and Quarterly, the model repeats on the same day of the month. If the month is shorter (for example, the 31st in February), it uses the last day of the month. |
Tips:
- Enter payroll as net pay. Put employer taxes and benefits on a separate line under "Payroll taxes & benefits."
- Bills you already owe on the start date (your accounts payable) go in as One-time entries on the date you plan to pay them.
- Don't enter inventory purchases here if you already set an inventory percentage on the Setup tab. That would count them twice.
- Loan payments, estimated taxes, equipment purchases and owner draws are tracked as non-operating, so your operating cash flow stays clean.
- The Setup tab flags any row that has an amount but is missing a category, frequency or date. The model leaves those rows out until you fix them.
Step 4: Read the results
On the 13-Week Forecast tab, each week runs: Beginning cash + Receipts − Disbursements = Cash before line of credit, then adds credit line draws and subtracts repayments to reach Ending cash.
The Dashboard highlights:
- Lowest projected ending cash: how close you get to your cushion.
- Lowest cash before line of credit, and the week it happens: your real funding need. If this is far below your cushion, you're relying on the credit line.
- Weeks below cushion and weeks with negative cash.
- Overall status: Healthy; Healthy, relies on credit line; Watch: below cushion; or Action needed: cash shortfall.
Stress-testing your plan
On the Setup tab, try:
- Sales adjustment of −20%: what if sales come in 20% below plan?
- Operating expense adjustment of +10%: what if costs run over?
- Both at once.
If the status changes to "Watch" or "Action needed," decide now what you'd do: which payments could you delay, which receivables could you speed up, and how much credit line headroom do you have? Set both adjustments back to 0% when you're done.
The weekly routine (15 minutes)
- After each week closes, go to the Actual vs Forecast tab and enter actual receipts, actual disbursements and your ending bank balance.
- Look into any variance larger than about 10%. Was it timing (a customer paid a week late) or a real change (sales are trending lower)?
- Roll the forecast forward: on the Setup tab, move the start date ahead one week and update the opening cash to your actual bank balance.
- Update the Receipts and Payments Schedule tabs for anything new you've learned.
Each new week, save a copy of the workbook (for example, "Cash Forecast 2026-12-07.xlsx") so you keep a history of your forecasts.
How the calculations work
- Weeks: Week 1 starts on your start date; each week covers seven days.
- Collections: credit sales from each week are collected over the following weeks according to your collection percentages.
- Inventory: inventory % × adjusted sales, paid the chosen number of weeks later.
- Line of credit interest: prior week's ending balance × annual rate ÷ 52.
- Auto-draw: if cash before credit line activity falls below your cushion, the model draws the shortfall, up to the available credit.
- Auto-repay: if cash before credit line activity is above your cushion, the excess repays the line first.
- Stress tests: the sales adjustment applies to forecast sales (and therefore to collections and inventory). The expense adjustment applies to operating payment categories only, not to loans, taxes, equipment or owner draws.
Known limitations
- The model doesn't calculate taxes, payroll withholding or loan amortization. Enter those amounts directly, as provided by your payroll provider, lender or tax professional.
- The model is built for a single currency.
- Biweekly items repeat every 14 days from the first payment date. Semi-monthly payroll (the 15th and the last day of the month) should be entered as two Monthly rows.
- Opening receivables are entered by hand. The collection percentages only apply to new sales within the forecast.
Important
This workbook is an educational planning tool. It isn't tax, legal, accounting or investment advice. Results depend entirely on your inputs. Talk to a qualified professional before making significant financial decisions.