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

Key takeaway

Build a cash flow forecast in Excel step by step: operating, investing and financing flows, working-capital timing, and closing cash by period.

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

Values in $000s. Closing cash dips to its lowest in month 5 — the tightest point, and the signal to secure funding ahead of it.

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 just your email. Enter your assumptions, preview the model, and download an editable workbook you can hand straight to a bank or board.

→ Build your cash flow forecasting model free with the Cashflow Forecasting tool

More Cash Flow Forecasting guides

Cash Forecasting Methods: Direct, Indirect, 13-Week & Driver-Based · 13-Week Cash Flow Forecast: A Practical Guide for Tight Cash · Direct vs Indirect Cash Flow Forecasting: Which Method to Use · Cash Flow Forecasting for Startups: Runway, Burn Rate & When to Raise · Working Capital Days Explained: DSO, DIO & DPO and Why They Drive Cash

About the author

Every model is built and reviewed by the project's Financial Advisor — a Fellow Chartered Accountant (FCA) of the Institute of Chartered Accountants of Pakistan (ICAP), Chartered Global Management Accountant (CGMA) and Associate Chartered Management Accountant (ACMA) with around two decades of corporate finance, audit and accounting experience, designing investor-grade financial models across industries. Full credentials and background are available on LinkedIn. More about the author →

← All guides · WACC calculator · DCF calculator · IRR calculator · Inside the 16-sheet model