13-Week Cash Flow Forecast — Excel Model (direct method, revolver logic, variance tracking, dashboard)

Description

The 13-week cash flow is the forecast lenders, boards and turnaround advisers actually ask for. This model gives you the whole thing in one workbook: a driver-based Assumptions sheet, a weekly Forecast built on the direct method, a Variance sheet to log actual closing cash as weeks close, and a Dashboard with the numbers that matter (lowest cash week, peak facility use, weeks below buffer).

What’s inside

• Assumptions sheet — opening cash, minimum buffer, credit line, collections run-rate and growth, payroll cadence, rent, supplier % of receipts, opex, interest rate
• Forecast sheet — 13 weekly columns + total: customer collections (forecast + known invoices), other receipts, financing, payroll, rent, suppliers, opex, taxes, capex, debt service, one-offs
• Automatic revolver: draws when closing cash would fall below the buffer, repays when it exceeds it; interest accrues weekly
• Headroom and availability rows with red/amber conditional formatting
• Variance sheet — forecast vs actual closing cash and cumulative receipts accuracy
• Dashboard — 10 KPIs, weekly status table and closing-cash chart

Sizes & formats

• Excel .xlsx (works in Excel 2010+, Google Sheets, LibreOffice, Numbers)
• No macros, no add-ins; every result is a formula you can audit
• Colour convention: blue-on-yellow inputs, black formulas, green cross-sheet links

Formats: XLSX. Print at home, at the office or send the PDF straight to a local print shop.

Who it’s for

CFOs, controllers, FP&A analysts, founders raising debt or managing a tight runway, and advisers who need a credible weekly cash view in an afternoon rather than a week.

How it works

1. Check out securely (card via iyzico, USD).
2. Your download link appears on the order page and in your e-mail immediately.
3. Print as many copies as you need for yourself or your team.

FAQ

Does it work in Google Sheets?

Yes — upload the file to Drive and open with Sheets; all functions used are supported.

Can I extend it beyond 13 weeks?

Yes. Copy the last weekly column to the right; the formulas are consistent across every week.

Is sample data included?

Yes — illustrative placeholder figures in every input cell so you can see how the model behaves before you overwrite them.

Digital product — no physical item is shipped. Personal and in-company use; no resale or redistribution. Part of the Quiet Capital collection by Kurums.