13-Week Cash Flow Forecast and Liquidity Model

Description
Build a rolling 13-week cash view with weekly receipts, operating disbursements, financing flows and liquidity headroom. The model links assumptions to a detailed cash flow, dashboard, scenario analysis and checks so users can identify pressure points and explain the drivers of cash movement.

Use the populated example as a starting point, replace the blue input cells with company-specific assumptions, and review the automated checks before relying on the forecast. The workbook is designed for finance teams, operators, advisers and lenders who need a practical short-term liquidity tool.


The weekly structure helps users separate timing differences from underlying operating performance. Receipts and payments can be updated as actual information arrives, while scenario inputs make it easier to assess delayed collections, weaker sales, higher costs or changes in financing. The liquidity dashboard summarizes the opening balance, weekly movement, closing cash and headroom so decision-makers can focus on the weeks that need action.


The workbook also supports a disciplined forecasting rhythm. Teams can refresh assumptions each week, compare expected and realized cash movement, investigate variances and roll the horizon forward. Clear input conventions and model checks reduce avoidable errors, but users should still validate every assumption against their own records and policies.


This template is intended to speed up planning and reporting rather than replace professional judgment. It does not provide accounting, tax, legal or investment advice. Users remain responsible for adapting the workbook to their business, reviewing formulas and deciding which scenarios are appropriate.