Blog · Finance metrics and formulas · Finance and FP&A teams
Incremental cash flow analysis compares cash with and without a proposed business decision. Work through receipts, operating payments, taxes, capital spending and working capital without counting the same cash twice.
Incremental cash flow analysis compares the cash a business expects with a proposed decision against the cash it expects without that decision. The difference belongs to the decision; the total cash generated by the business does not. Keep both alternatives on the same dates and use explicit, supplied assumptions.
Write the decision as a choice: add a packaging line or continue with the current line, for example. The alternative must include the maintenance, staffing and customer collections that would happen anyway. A baseline with no costs makes the proposal look worse; a baseline that assumes no business activity makes it look better.
The relevant test is whether a future cash amount changes between alternatives. OpenStax's discussion of relevant information distinguishes avoidable costs from costs that remain and explains why sunk costs do not affect the choice.
Gather the approved sales assumptions, collection schedule, supplier and payroll budgets, equipment quotes and cash-tax estimates. Give each assumption an owner and an effective date. Include lost receipts from displaced products or foregone use of existing space when the proposal causes them. A different demand outlook belongs in cash flow scenario analysis, which changes the assumptions around this comparison.
Incremental cash flow = Cash flow with the decision - Cash flow without the decision
Use positive receipts and negative payments. Keep a separate column for the explanation and source of each difference. Do not turn an invoice date into a cash date without a collection or payment assumption.
An illustrative Ohio packaging company supplies the following first-year cash budgets. The proposal adds capacity. Both alternatives cover the same year, and the capital payment occurs during that year. All amounts are USD; the figures are exact, with no rounding.
| Cash row | Without decision (USD) | With decision (USD) | Incremental cash (USD) |
|---|---|---|---|
| Customer receipts | 2,000,000 | 2,350,000 | 350,000 |
| Supplier, payroll and other operating payments | -1,500,000 | -1,690,000 | -190,000 |
| Cash income-tax payments | -80,000 | -108,000 | -28,000 |
| Equipment payments | -40,000 | -200,000 | -160,000 |
| Net cash flow | 380,000 | 352,000 | -28,000 |
Put the headings in row 1 and the cash rows in rows 2 through 5. Columns B and C contain the alternatives; column D is the difference. Enter this in D2 and fill down:
=C2-B2
Enter these total formulas in B6, C6 and D6, respectively:
=SUM(B2:B5)
=SUM(C2:C5)
=SUM(D2:D5)
The proposal produces $132,000 more operating cash after cash taxes: $350,000 less $190,000 less $28,000. Its additional equipment payment is $160,000, leaving first-year incremental cash of negative $28,000. The company still generates positive total cash under either alternative. That does not make the proposal's first-year difference positive.
For a smaller operating choice, the incremental analysis example separates relevant revenue and cost without extending this cash schedule into a full investment appraisal.
The customer and supplier schedules already include collection and payment timing. The assumptions underneath the incremental amounts above are:
| Input or calculation | Incremental amount (USD) | Cash implication |
|---|---|---|
| Sales invoiced | 400,000 | Starting point for collections |
| Increase in customer receivables | 50,000 | Invoiced but not collected |
| Customer receipts: sales less receivables increase | 350,000 | 400,000 - 50,000 |
| Operating expense before inventory and payable timing | 175,000 | Excludes depreciation and cash taxes |
| Increase in inventory | 30,000 | Additional purchases |
| Increase in supplier payables | 15,000 | Purchases not yet paid |
| Operating payments | 190,000 | 175,000 + 30,000 - 15,000 |
Assume no other operating balance changes, write-offs or noncash movements. The increase in operating working capital is $65,000: $50,000 plus $30,000 less $15,000. It is already reflected in the receipts and payments. Subtracting it again from $132,000 would understate operating cash.
Depreciation is also absent from these payment rows. The SEC's cash-flow primer distinguishes actual receipts and expenditures from indirect-method adjustments for noncash items such as depreciation. Any depreciation-related change in tax cash belongs in the supplied cash-tax schedule, with the tax team's assumptions attached.
The total of the row differences must equal the difference between the alternative totals. This check must return zero:
=D6-(C6-B6)
Here, $352,000 less $380,000 equals negative $28,000, matching the incremental column. Also tie each alternative to its underlying schedules. A zero arithmetic check cannot prove that a missing payment was included.
Then distribute the same rows into the months when cash moves. An annual total cannot show the largest temporary funding requirement. This first-year view assumes no terminal disposal proceeds or recovery of working capital; a longer schedule should include them only when the owner expects the cash to move. Use the existing cash flow forecast method for that timing schedule. For a multiyear investment decision, pass the dated incremental amounts into capital budgeting cash flow analysis using the owner's approved appraisal assumptions.
Bring a workbook containing both scenarios, the supplied assumptions and the supporting cost schedules to Covirage. Covirage maps the columns; its tools compute and check the differences, and the external AI model explains the results with every figure traced to its rows. Create a free Covirage account and bring a sample of your own export.
See Covirage for finance teams for the same work across your business files.
Exclude spending that has already occurred because the current decision cannot change it. Keep future cash consequences of that spending, such as disposal proceeds or a changed tax payment, when those consequences differ between the alternatives.
Yes, when the decision changes cash tied up in receivables, inventory or operating payables. Include those changes through either a working-capital bridge or cash collection and payment schedules. Using both for the same transactions counts the effect twice.
It means the stated alternative produces more cash over the measured period under the supplied assumptions. Approval also depends on timing, funding needs, risk, service requirements and the investment appraisal method the business has agreed to use.