Cash Flow · 2026-07-07

How to Build a Cash Flow Forecast in Excel (Free Template + Steps)

Step-by-step guide to building a cash flow forecast in Excel — operating, investing and financing cash flows, working-capital timing and closing cash — with a free automated template.

A cash flow forecast in Excel projects the money moving in and out of a business over time, so you can see when cash peaks, dips or runs short before it actually happens. The fastest way to build one is to start from your revenue and cost assumptions, layer in working-capital timing, and let the three sections of the cash flow statement — operating, investing and financing — roll into a single closing-cash line. Below is the exact structure a finance professional uses, and how to generate it free in minutes.

Start with clear operating assumptions

Every reliable forecast begins with visible inputs, not hard-coded numbers. Set your revenue drivers (price, volume, growth), your operating costs (as a percentage of revenue or a fixed monthly amount, each with its own inflation), and your tax rate. Keeping these on a single assumptions sheet means anyone reviewing the model can trace every cash figure back to a driver they can challenge.

Add working-capital timing

Profit is not cash. Revenue is booked before customers pay, and stock is bought before it sells — so the timing of receivables, inventory and payables drives when cash actually arrives. Enter receivable days (DSO), inventory days (DIO) and payable days (DPO), and the model converts them into the period-by-period working-capital movement that either consumes or releases cash. This single step is what separates a real cash flow forecast from a profit projection.

Build the three cash-flow sections

A complete cash flow statement has three parts. Operating cash flow starts from net income, adds back non-cash items like depreciation, and adjusts for the working-capital movement. Investing cash flow captures capital expenditure. Financing cash flow covers debt drawdowns, repayments, interest and any dividends. Summing the three gives the net movement in cash for each period.

Close the loop with opening and closing cash

The closing cash of one period becomes the opening cash of the next. Charting the closing-cash line across months or quarters instantly shows your lowest point — the peak funding need — and the month cash could turn negative. A well-built model also ties to a balance sheet that balances every period, which is the credibility signal lenders and investors look for.

Common cash flow forecasting mistakes

The most frequent error is forecasting cash on the sale date instead of the collection date — a sale today on 60-day terms is cash two months from now, not today. A close second is ignoring seasonality: costs and collections that cluster in certain months swing your closing cash far more than an annual average suggests. Many forecasts also omit tax instalments and debt repayments, which are real, non-negotiable outflows. Building from explicit receivable, inventory and payable days, and modelling tax and financing as their own lines, avoids all three traps.

Refresh it, don't set and forget

A cash flow forecast is only as good as its last update. Compare each period's actuals against forecast, and where they diverge, fix the assumption rather than the output — persistent gaps almost always point to over-optimistic collection timing. A model that recalculates when you change one input makes this monthly refresh a five-minute job instead of a rebuild.

Skip the manual build

Wiring all of this by hand is slow and error-prone. The EasyFinancialModels Cashflow Forecasting tool builds the entire forecast — operating, investing and financing cash flows, a dedicated working-capital schedule and a self-balancing model — as a fully formula-linked Excel file. It's free for a 3-year forecast, with monthly, quarterly or annual periods and no sign-up. Enter your assumptions, preview the model, and download an editable workbook you can hand straight to a bank or board.

→ Build your financial model free