Blog · Forecast and pipeline · Finance and FP&A teams
Forecast operating cash flow and capital expenditures from explicit business assumptions. Use a monthly example, a collection downside and a forecast-to-actual bridge to check cash generation.
A free cash flow forecast subtracts expected cash capital spending from projected operating cash flow. It shows whether the operating company is generating cash after its planned capital payments, with separate schedules explaining collection timing, supplier payments and investment decisions.
Use a stated definition throughout. The SEC's non-GAAP guidance, Question 102.07, describes operating cash flow less capital expenditures as a typical calculation, while warning that free cash flow has no uniform definition and does not necessarily represent cash available for discretionary spending.
Forecast free cash flow = Forecast cash flow from operating activities − Forecast cash capital expenditures
This article uses operating cash flow after the company's cash interest and income taxes. It includes all cash capital purchases in the plan. It does not subtract debt principal or dividends; those enter the closing-cash reconciliation separately. Keep that definition attached to every comparison.
The free cash flow glossary explains the measure itself. A separate unlevered free cash flow calculation uses a different financing basis; do not combine its inputs with this operating-company forecast.
Start with a monthly projected income statement, the latest closed balance sheet and operating balance schedules. Add a capital plan with payment dates, amounts, project owners and approval status. Preserve forecast versions so a revised plan does not overwrite the assumptions you later need to test.
For a US equipment distributor, forecast net income and depreciation, then forecast changes in receivables, inventory, trade payables and accrued operating expenses. The SEC's financial statement guide explains the reconciliation from net income through noncash items and operating assets and liabilities. Apply that structure to the forecast schedules.
The example assumes no noncash adjustments beyond depreciation, no acquisitions or foreign-currency effects, and no changes in interest or tax accruals. Operating balances below contain no capital invoices. All values are USD, in whole dollars without rounding.
Set up a spreadsheet with January in column B, February in C and March in D. Each increase is entered as a positive input; a decrease would be negative.
| Row | Driver | January (USD) | February (USD) | March (USD) | Quarter (USD) |
|---|---|---|---|---|---|
| 2 | Net income | 70,000 | 80,000 | 90,000 | 240,000 |
| 3 | Depreciation | 30,000 | 30,000 | 30,000 | 90,000 |
| 4 | Increase in receivables | 20,000 | 10,000 | 5,000 | 35,000 |
| 5 | Increase in inventory | 10,000 | 15,000 | 5,000 | 30,000 |
| 6 | Increase in trade payables | 15,000 | 5,000 | 10,000 | 30,000 |
| 7 | Increase in accrued operating expenses | 5,000 | 0 | 5,000 | 10,000 |
| 8 | Operating cash flow | 90,000 | 90,000 | 125,000 | 305,000 |
| 9 | Cash capital expenditures | 70,000 | 60,000 | 50,000 | 180,000 |
| 10 | Free cash flow | 20,000 | 30,000 | 75,000 | 125,000 |
In B8, calculate operating cash flow and copy across:
=SUM(B2:B3)-SUM(B4:B5)+SUM(B6:B7)
In B10, subtract cash capital spending and copy across:
=B8-B9
Put quarter totals in column E. In E2, enter the following and fill down through E10:
=SUM(B2:D2)
The quarter independently reconciles as $240,000 + $90,000 − $35,000 − $30,000 + $30,000 + $10,000 = $305,000 operating cash flow. Subtract $180,000 of capital payments to obtain $125,000 free cash flow. The monthly FCF values also sum to $125,000.
For the full linked balance-sheet method, use the indirect cash flow forecast. Here the focus is the operating cash and capital spending drivers that explain the FCF result.
The receivables forecast needs expected invoice collections, including large disputed balances and customers whose terms differ from the standard. Credit control owns that evidence. Do not assume that a revenue increase converts to cash within the same month.
Purchasing and operations own inventory receipts, usage and supplier timing. Increased payables can temporarily support cash, but a planned payment delay needs to agree with supplier terms and operational commitments.
Project owners provide capital payment dates, while finance checks the accounting classification. Separate planned spending that can move from contractual payments that are already due. Both remain in the base forecast unless an approved change says otherwise.
Treasury owns the reconciliation from these cash generation figures to actual liquidity. A quarterly FCF total is useful for planning investment capacity; it cannot establish whether a specific payroll date is funded.
Suppose a customer payment of $25,000 originally expected in January moves outside the quarter. Revenue, profit, inventory, supplier payments and capital spending stay unchanged. January's increase in receivables therefore rises from $20,000 to $45,000.
| Measure | Base quarter (USD) | Collection downside (USD) | Change (USD) |
|---|---|---|---|
| Increase in receivables | 35,000 | 60,000 | 25,000 |
| Operating cash flow | 305,000 | 280,000 | -25,000 |
| Cash capital expenditures | 180,000 | 180,000 | 0 |
| Free cash flow | 125,000 | 100,000 | -25,000 |
January operating cash becomes $65,000 and FCF becomes negative $5,000. February and March retain their base values, so negative $5,000 + $30,000 + $75,000 = $100,000 for the quarter. If the customer instead pays in February, the quarter's FCF is unchanged, although January liquidity still worsens.
Show that timing effect with a cash flow forecast chart, rather than interpreting only the quarter total.
At month-end, compare actual operating cash flow and capital payments with the saved forecast. A useful variance bridge is actual minus forecast, with positive amounts meaning higher FCF.
For example, compare January's saved forecast with these actual cash outcomes:
| January measure | Forecast (USD) | Actual (USD) | Actual minus forecast (USD) |
|---|---|---|---|
| Operating cash flow | 90,000 | 80,000 | -10,000 |
| Cash capital expenditures | 70,000 | 55,000 | -15,000 |
| Free cash flow | 20,000 | 25,000 | 5,000 |
Actual FCF is $80,000 − $55,000 = $25,000. Its favorable $5,000 variance equals negative $10,000 operating cash variance minus negative $15,000 spending variance. Lower capital payments therefore contribute positive $15,000 to FCF. Check whether that reflects a genuine cancellation or merely a delayed bill.
For closing cash, assume quarter-opening cash of $200,000, debt principal payments of $60,000 and no other investing or financing movements. Base closing cash is $200,000 + $125,000 − $60,000 = $265,000; the collection downside closes at $240,000. Both figures must agree with the complete cash schedule and projected balance sheet.
Upload your forecast workbook, operating cash actuals and capital payment export in a file or Google Sheet. Covirage maps the columns; its tools compute and check the figures, and the external AI model explains forecast differences with every figure traced to its rows. Create a free Covirage account and bring a sample of your own data.
See forecast analysis for the supporting workflow.
No. Free cash flow is a period's cash generation under a stated definition. Bank cash also reflects opening balances, borrowing, debt repayments, dividends and other cash movements. Reconcile those items separately before deciding whether the company can meet its obligations.
Use the cash paid for capital expenditures in the forecast period. An approved purchase order, asset delivery and payment can occur in different months. Link deposits, progress payments and final settlements to the asset plan so the cash forecast follows payment timing.
Yes. Receivables or inventory growth can absorb operating cash, and capital spending can exceed what operations generate. Identify the driver before responding: a temporary collection delay requires a different action from a planned investment or a persistent operating loss.
Replace completed months with reconciled actual operating cash flow and capital payments. Keep the original forecast version for comparison, revise remaining assumptions with named owners, and explain changes through profit, noncash adjustments, working capital and spending rather than one unexplained total.