Building a dynamic rolling cash flow forecast for a small manufacturer

[MatthewW]

As the new CFO for a small manufacturing company, I'm overhauling our cash flow forecasting process, which has historically been a reactive, spreadsheet-based mess that fails to account for seasonal demand and supplier payment terms. I need to implement a more dynamic model that helps us anticipate shortfalls and make informed decisions about capital expenditures. For finance professionals, what are the best practices for building a reliable rolling forecast, and which key variables or scenarios do you prioritize to stress-test the model's accuracy?

[Michael.W]

Great move. Here’s a practical, rolling forecast approach you can start with. Build a driver-based model with an 13‑week cash forecast plus monthly P&L and balance sheet linkages. Core drivers: expected sales by product/region, unit economics (price, margin, COGS), payroll and overhead, capital expenditures, working capital needs (inventory turns, supplier terms), and financing (lines of credit, debt service). Keep a clear cadence: update the forecast weekly with actuals, refresh seasonality patterns, and run 2–3 scenarios (base, upside, downside). Set a cash runway target (e.g., 6–8 weeks) and keep a simple variance analysis so you know what changed and why. Build a concise dashboard focused on cash, liquidity, and key ratios, and document all assumptions. Start in a spreadsheet; plan a future migration to a BI tool once the model is stable.