13-Week Cash Flow 1200×6302x | eFinancialModels

Financial Model, General Excel Financial Models

Accounting, Budget, Cash Flow Projections, Excel, Financial Analysis, Financial Model, Financial Planning, Free Cash Flows

The 13-Week Rolling Cash Flow Forecast is an Excel model that shows, week by week, how much cash a business will have over the next three months. It combines actual results for closed weeks with a forecast for the 13 weeks ahead on one timeline, so you can see a cash shortfall weeks before it happens and act in time.

What is this model template used for?
The template is used for short-term cash planning and liquidity management. It answers questions such as: Can we make payroll next month? Which week will cash be at its lowest? How many weeks will we fall below our minimum cash buffer? How much of our credit line will we need, and when can we repay it? It suits small and mid-sized businesses, controllers, CFOs, fractional CFOs, bookkeepers and anyone who reports cash to owners or lenders.

What are the main features of this template?
– Rolling 13-week window: one timeline of 65 weeks (52 weeks to close plus 13 weeks of lookahead). Increase “Weeks closed” by one each week and the forecast window, colors and dashboard move forward automatically, with no columns to copy.
– Setup tab: company name, start date, opening cash, minimum cash buffer, credit line limit and opening balance in one place.
– Cash Flow tab: receipts, operating disbursements and non-operating flows (capex, debt payments, owner distributions, new funding), with net cash flow, ending cash and a buffer status for every week.
– Optional credit line auto-draw: forecast weeks draw just enough to stay above the buffer, capped by the available limit, and repay when cash recovers. A limit-changes table handles limit increases or decreases over time.
– Dashboard: cash at last close, cash at end of window, lowest cash point and its week, weeks below buffer, peak credit line use, total receipts and disbursements, plus two charts.
– Weekly close checklist: eight steps with automatic checks that show “Ready to close = YES” only when every step is complete.
– Variance Log and Line Variance: save each week’s forecast, compare it to actuals line by line, flag favorable or unfavorable results, and track forecast accuracy over time.

How to best work with this template?
Start with the Setup tab, then enter expected weekly receipts and payments as positive numbers in the week the cash actually moves. Each week, save the forecast, enter actual results, forecast the new 13th week, log the variance and close the week. This takes about 10 minutes. Both a blank version and a sample version with four closed weeks are included. The model works in Microsoft Excel 2010 or later (Windows and Mac) and in Google Sheets, uses no macros, and can be customized by renaming or adding lines.

Why do you need this Financial Model Template?
Profit is not cash. A profitable business can still run short when large payments, slow collections or loan payments fall in the same weeks. A 13-week cash flow forecast is a standard tool for finance teams and is often requested by banks and lenders. This template gives you a structured, repeatable process to see problems early, plan borrowing, and make confident decisions about hiring, purchases and payments.

You must log in to submit a review.