The Step Is To Determine Whether Cash Flows Are Relevant.: Complete Guide

Ever tried to decide if a project is worth the money, only to get stuck on the “cash flow” part? Worth adding: you’re not alone. Which means most of us have stared at a spreadsheet, squinting at rows of numbers and wondering which ones actually matter. Worth adding: the short version is: before you start adding, subtracting, or discounting anything, you have to figure out whether each cash flow is relevant. Get that step right, and the rest of the analysis falls into place.

What Is Determining Whether Cash Flows Are Relevant

When we talk about relevance, we’re not getting philosophical. Practically speaking, it’s a practical filter that tells you: “Should I even bother putting this number into my NPV or IRR calculation? ” In plain English, a cash flow is relevant if it will change the decision you’re trying to make. If it won’t, you can safely ignore it and keep your model tidy.

Most guides skip this. Don't Not complicated — just consistent..

Incremental vs. Sunk

The first thing to separate is incremental cash flow from a sunk cost. ” Sunk costs are past expenses that you can’t recover—think of the $10,000 you spent on market research last year. Incremental means “the extra cash that shows up because you take the project.That $10,000 is already gone; it won’t shift whether you go ahead with the new product line.

Opportunity Cost

Next up is opportunity cost. This is the cash you could earn elsewhere if you don’t lock your money into the project. As an example, if you have $50,000 sitting in a low‑yield savings account earning 1%, that 1% is an opportunity cost you need to consider as a relevant cash flow—because choosing the project means you’re giving up that interest.

Timing Matters

A cash flow that occurs today is not the same as one that arrives five years from now. Relevance includes timing because the value of money changes over time. Even if two projects have identical total cash inflows, the one that gets money earlier will usually be more attractive once you apply discounting Most people skip this — try not to..

Why It Matters / Why People Care

If you accidentally count a sunk cost, your NPV will look worse than it really is. That can lead you to reject a great opportunity. On the flip side, ignoring an opportunity cost might make a marginal project look like a winner, only to bite you later when you realize you could have earned more elsewhere.

Real‑world example: A manufacturing firm considered buying a new machine. Consider this: the purchase price was $200,000, and the old machine had a book value of $150,000. The accountant initially added the $150,000 as a cash outflow, treating it like a cost. In practice, that $150,000 is a sunk accounting figure—not a cash outflow. Day to day, the relevant cash flow is actually the sale price of the old machine, say $80,000, which should be added as a cash inflow. Ignoring that nuance made the project look $70,000 less profitable than it truly was.

Understanding relevance also keeps your model lean. No one wants to scroll through endless rows of numbers that don’t affect the decision. A clean, relevant cash‑flow statement is easier to audit, explain to stakeholders, and, frankly, to trust.

How It Works (or How to Do It)

Below is a step‑by‑step guide you can follow the next time you sit down with a capital‑budgeting spreadsheet.

1. Define the Decision Boundary

First, write down the exact question you’re answering. And “Should we launch product X? That said, ” “Do we replace machine Y? ” The answer hinges on the cash flows that differ between the “yes” and “no” scenarios.

2. List All Cash Flows for Both Scenarios

Create two columns: Base Case (do nothing) and Project Case (take the action). Pull in every cash movement you can think of—revenues, operating costs, taxes, capital expenditures, salvage values, working‑capital changes, etc.

3. Subtract Base from Project – Get Incremental Cash Flows

For each line item, subtract the Base Case amount from the Project Case amount. The result is the incremental cash flow. If the difference is zero, that line is irrelevant.

Example Table (simplified)

Notice how the $100,000 fixed overhead in the base case becomes a relevant $20,000 increase when you add the project. If the base case already had that cost, you only count the extra portion.

4. Identify Sunk Costs and Exclude Them

Look at each incremental line. If the cash flow originates from a past expenditure that cannot be recovered, drop it. Typical culprits: past R&D, advertising already paid, or equipment that’s already fully depreciated and cannot be sold.

5. Add Opportunity Costs

Ask yourself: “What am I giving up by committing this cash?” If you’re using internal cash that could otherwise earn a return, treat that foregone return as a cash outflow. g.Conversely, if you’re freeing up a resource (e., a warehouse space), treat the saved rent as a cash inflow.

6. Adjust for Timing

Place each incremental cash flow in the correct year. Use the project timeline to assign cash flows to Year 0, Year 1, …, Year N. Remember that initial outlays belong in Year 0 (the moment you decide).

7. Apply Tax Effects Correctly

Taxes can be tricky. That's why the cash flow impact of a tax shield (e. g.In real terms, , depreciation) is relevant because it changes after‑tax cash. Still, the tax expense itself is already embedded in the incremental net income; you don’t double‑count it.

8. Run the Discounted Cash Flow (DCF) Model

Now that you have a clean list of relevant, incremental cash flows, discount them at the appropriate hurdle rate (WACC, required return, etc.Now, ). The sum is your NPV. If NPV > 0, the project passes the relevance test and the financial test Worth keeping that in mind..

9. Sensitivity Check

Finally, vary the key inputs (sales volume, discount rate, salvage value) to see how dependable your relevance decisions are. If a cash flow flips from positive to negative under a slight change, flag it as a risk.

Common Mistakes / What Most People Get Wrong

Counting Depreciation as a Cash Outflow

Depreciation is a non‑cash expense. Some folks still plug it into the cash‑flow statement as a cost, which artificially drags down NPV. The correct move is to add back depreciation (or the tax shield derived from it) because it doesn’t involve actual cash leaving the firm Most people skip this — try not to..

Forgetting Working‑Capital Changes

A project often needs extra inventory or receivables. Those are real cash uses, but they’re easy to overlook. If you ignore the incremental increase in working capital, you’ll overstate cash flow in the early years But it adds up..

Mixing Up Book Value and Market Value

When you sell an old asset, use its market (salvage) value, not its book value, to calculate the cash inflow. The difference between the two is a tax effect, not a cash flow itself It's one of those things that adds up. Still holds up..

Assuming All Future Costs Are Relevant

Only costs that change because of the decision matter. Fixed overhead that stays the same whether you build or not is irrelevant. Yet many models keep the whole overhead line, diluting the signal.

Ignoring Taxes on Salvage Value

If you sell equipment for more than its tax base, you’ll owe tax on the gain. Conversely, a loss yields a tax shield. Skipping this step can swing the NPV by tens of thousands.

Practical Tips / What Actually Works

• Create a “Relevance Checklist.” Before you start, write down: incremental cash flow? sunk cost? opportunity cost? tax effect? This forces you to evaluate each line systematically.
• Use Color Coding. In Excel, highlight sunk costs in gray, opportunity costs in blue, and true cash inflows/outflows in green. Visual cues speed up reviews.
• Document Assumptions Inline. Next to each cash flow, add a short note: “sale of old machine – market value $80k.” Future you (or a reviewer) will thank you.
• Keep Year 0 Clean. All initial outlays should be in Year 0, including the net cash from disposing of old assets. Mixing them into Year 1 creates timing errors.
• Run a “What‑If” for Sunk Costs. Temporarily add a sunk cost to see how it skews NPV. If the decision flips, you’ve discovered a hidden bias.
• Ask a Non‑Finance Friend. Explain your cash‑flow list to someone outside finance. If they can’t see why a number matters, you probably need to revisit its relevance.

FAQ

Q1: Is the cost of financing the project a relevant cash flow?
A: No. Financing costs (interest expense) are accounted for in the discount rate (WACC). Including them as cash outflows double‑counts the cost of capital.

Q2: How do I treat a lease payment?
A: Treat the lease as an operating cash outflow if it’s an operating lease. If it’s a capital lease, break it into interest (ignored) and principal repayment (relevant as a financing activity, but again captured in WACC). Focus on the incremental cash impact.

Q3: What about tax credits that are non‑refundable?
A: If a tax credit reduces your tax liability, it’s a cash inflow. Even if it can’t be refunded, the reduction in tax paid is still cash saved, so it’s relevant.

Q4: Should I include environmental cleanup costs that will happen regardless of the project?
A: No. If the cleanup is mandatory and will occur whether or not you proceed, it’s a common cost and therefore irrelevant to the incremental analysis.

Q5: Does inflation affect relevance?
A: Inflation changes the real value of cash flows, but relevance is about difference between scenarios. As long as you apply the same inflation assumptions to both cases, the incremental cash flows remain relevant. Just be consistent.

So there you have it: the whole process of sifting through numbers to decide which cash flows actually belong in your analysis. It may feel like a lot of bookkeeping, but once you internalize the “incremental vs. Also, sunk” mindset, the rest becomes second nature. Next time you open a spreadsheet, start with the relevance filter—your future self (and your bottom line) will thank you.