13-Week Rolling Cash Flow Forecast — Turnaround-Grade, with Revolver Mechanics

All Industries, General Excel Financial Models

Budgeting, Cash Flow Analysis, Cash Flow Projections, Controlling, Dashboard, Excel, Financial Planning, Forecast, Forecasting, Stress Test

The 13-Week Rolling Cash Flow Forecast is the instrument every cash-tight or turnaround business runs on, built to a standard a restructuring professional would recognise. It projects receipts and payments across a rolling 13-week window and, crucially, models the working-capital facility (revolver) properly rather than pretending one isn’t there.

What it does: each week, operating receipts and payments roll up to a net movement, and the facility responds automatically — drawing when the business is short and sweeping cash back when it is long — so you see the closing cash position and, just as importantly, the headroom remaining against the facility limit every single week. That headroom line is the number a director, lender or insolvency practitioner watches, and most cash-flow templates simply don’t compute it.

Main features: a 13-week rolling weekly forecast; draw-and-sweep revolver logic with a facility limit; weekly closing cash and facility headroom; a dashboard view of the liquidity position; and a deliberately stressed worked example (a tax payment and an equipment repair pushing cash negative before the facility defends a minimum buffer, then recovering as collections come in). 364 live formulas, recalc-verified with zero formula errors, and the revolver mechanics independently checked.

How to work with it: every editable cell is blue text on a yellow fill — nothing else needs touching. Enter your opening position, facility limit and weekly receipts and payments, and the model does the rest.

Why you need it: when cash is tight, a wrong or over-simplified forecast is dangerous, and a locked template won’t let you see how the facility behaves. This one is fully unlocked, every formula visible, with a plain-English cover and honest notes. It suits a finance director, controller, restructuring adviser or owner-manager who needs to prove short-term solvency week by week and defend a covenant or a facility limit to a lender or board. Currency-agnostic; treat $ as your currency. For planning only, not financial advice.

You must log in to submit a review.